Modeling Data¶
Modeling data can be set up to support either stand-alone resource planning, or combined resource planning and scheduling, or even simply to supplement the scheduling data.
The following data is stored in the Resource Planning Database:
- General Data: E.g. Activity Types, SLA Types, Regions, Skills, Parts, Appointment Templates. When integrated with scheduling this data will always be included in the schedule input data.
- Resource Data: Resources plus related data such as resource skills, attributes etc. When integrated with scheduling resources will only be included if they have rota items (shifts) set up in the resource planner within the scheduling period. All other related data is pulled through as required.
- Activity Data: Locations and SLA information can also be set up for activities to be included in the scheduling input data.
See the Modeling Schema Guide in IFS Planning and Scheduling Optimization (PSO) documentation for full details of the entities which can be mapped to.
Tables & Rules Mapped¶
| Table | Rule |
|---|---|
| RAM_Appointment_Template | RAMAppointmentTemplate |
| RAM_Attribute | RAMAttribute |
| RAM_Calendar | RAMCalendar |
| RAM_Capacity | RAMCapacity |
| RAM_Customer | RAMCustomer |
| RAM_Contract | RAMContract |
| RAM_Data_Update | RAMDataUpdate |
| RAM_Dataset | RAMDataset |
| RAM_Division_Type | RAMDivisionType |
| RAM_Icon | RAMIcon |
| RAM_Membership_Category | RAMMembershipCategory |
| RAM_Modelling_Pattern | RAMModellingPattern |
| RAM_Part | RAMPart |
| RAM_Project_Template | RAMProjectTemplate |
| RAM_Role | RAMRole |
| RAM_Rota | RAMRota |
| RAM_Rule_Collection | RAMRuleCollection |
| RAM_Separation_Group | RAMSeparationGroup |
| RAM_Separation_Model | RAMSeparationModel |
| RAM_Shift_Category | RAMShiftCategory |
| RAM_Shift_Template_Set | RAMShiftTemplateSet |
| RAM_Skill_Type | RAMSkillType |
| RAM_SLA_Template | RAMSLATemplate |
| RAM_SLA_Type | RAMSLAType |
| RAM_Slot_Usage_Rule_Set | RAMSlotUsageRuleSet |
| RAM_Target | RAMTarget |
| RAM_Time_Pattern_Template | RAMTimePatternTemplate |
| RAM_Transfer_Rule_Template | RAMTransferRuleTemplate |
| RAM_Travel_Cost_Model | RAMTravelCostModel |
| RAM_Unavailability_Category | RAMUnavailCategory |
| RAM_Usage_Class | RAMUsageClass |
| RAM_Usage_Model | RAMUsageModel |
| RAM_Utilisation_Template | RAMUtilisationTemplate |
| RAM_Activity_Type | RAMActivityType |
| RAM_Appointment_Template_Item | RAMApptTemplateItem |
| RAM_Attribute_Allowed_Value | RAMAttribAllowedValue |
| RAM_Calendar_Item | RAMCalendarItem |
| RAM_Capacity_Part | RAMCapacityPart |
| RAM_Comment | RAMComment |
| RAM_Depot_Trans_Settings | RAMDepotTransSettings |
| RAM_Division | RAMDivision |
| RAM_Operation | RAMOperation |
| RAM_Position | RAMPosition |
| RAM_Project_Template_Group | RAMProjectTemplateGroup |
| RAM_Project_Template_Level | RAMProjectTemplateLevel |
| RAM_Rule | RAMRule |
| RAM_Separation_Model_Item | RAMSeparationModelItem |
| RAM_Shift_Template | RAMShiftTemplate |
| RAM_Skill | RAMSkill |
| RAM_SLA_Template_Item | RAMSLATemplateItem |
| RAM_Slot_Usage_Rule | RAMSlotUsageRule |
| RAM_Special_Day | RAMSpecialDay |
| RAM_Target_Focus | RAMTargetFocus |
| RAM_Target_Level | RAMTargetLevel |
| RAM_Time_Pattern | RAMTimePattern |
| RAM_Time_Pattern_Template_Item | RAMTimePatternTempItem |
| RAM_Travel_Penalty | RAMTravelPenalty |
| RAM_Usage_Model_Item | RAMUsageModelItem |
| RAM_Usage_Model_SLA | RAMUsageModelSLA |
| RAM_Utilisation_Template_Item | RAMUtilisationTempItem |
| RAM_Activity_Type_App_Template | RAMActTypeAppTemplate |
| RAM_Activity_Type_Part | RAMActivityTypePart |
| RAM_Activity_Type_Skill | RAMActivityTypeSkill |
| RAM_Appt_Template_Item | RAMApptTemplateItem |
| RAM_Location_Type | RAMLocationType |
| RAM_Operation_Hierarchy | RAMOperationHieararchy |
| RAM_Operation_Ordering | RAMOperationOrdering |
| RAM_Operation_Skill | RAMOperationSkill |
| RAM_Part_Transfer_Settings | RAMPartTransferSettings |
| RAM_Project | RAMProject |
| RAM_Requirement | RAMRequirement |
| RAM_Role_Skill | RAMRoleSkill |
| RAM_Rule_Collection_Rule | RAMRuleCollectionRule |
| RAM_Rule_Parameter | RAMRuleParameter |
| RAM_Shift_Template_Item | RAMShiftTemplateItem |
| RAM_Shift_Template_Membership | RAMShiftTempMembership |
| RAM_Shift_Template_Set_Item | RAMShiftTempSetItem |
| RAM_Skill_Hierarchy | RAMSkillHierarchy |
| RAM_Special_Day_Item | RAMSpecialDayItem |
| RAM_Transfer_Rule_Tmp_Item | RAMTransferRuleTmpItem |
| RAM_Activity_Type_Tool | RAMActivityTypeTool |
| RAM_Division_Requirement | RAMDivisionRequirement |
| RAM_Location | RAMLocation |
| RAM_Project_Group | RAMProjectGroup |
| RAM_Project_Level | RAMProjectLevel |
| RAM_Requirement_Position | RAMRequirementPosition |
| RAM_Requirement_Role | RAMRequirementRole |
| RAM_Shift_Template_Item_Break | RAMShiftTempItemBreak |
| RAM_Activity_Template | RAMActivityTemplate |
| RAM_Location_Division | RAMLocationDivision |
| RAM_Requirement_Position_Level | RAMRequirementPosLevel |
| RAM_Requirement_Role_Level | RAMRequirementRoleLevel |
| RAM_Resource_Type | RAMResourceType |
| RAM_Act_Template_Operation | RAMActTemplateOperation |
| RAM_Act_Template_Usage_Period | RAMActTempUsagePeriod |
| RAM_Resource | RAMResource |
| RAM_Resource_Type_Capacity | RAMResourceTypeCapacity |
| RAM_Resource_Type_Location | RAMResourceTypeLocation |
| RAM_Resource_Type_Skill | RAMResourceTypeSkill |
| RAM_Resource_Type_Transition | RAMResTypeTransition |
| RAM_Template_Operation_Usage | RAMTempOperationUsage |
| RAM_Attribute_Value | RAMAttributeValue |
| RAM_Object_Group | RAMObjectGroup |
| RAM_Part_Stock | RAMPartStock |
| RAM_Resource_Capacity | RAMResourceCapacity |
| RAM_Resource_Division | RAMResourceDivision |
| RAM_Resource_Preference | RAMResourcePreference |
| RAM_Resource_Retention | RAMResourceRetention |
| RAM_Resource_Skill | RAMResourceSkill |
| RAM_Resource_Travel_With | RAMResourceTravelWith |
| RAM_Rule_Override | RAMRuleOverride |
| RAM_Team_Requirement | RAMTeamRequirement |
| RAM_Unavailability | RAMUnavailability |
| RAM_Resource_Skill_Availability | RAMResourceSkillAvail |
| RAM_Resource_Division_Availability | RAMResDivisionAvail |