Skip to content

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

TableRule
RAM_Activity_TemplateRAMActivityTemplate
RAM_Activity_TypeRAMActivityType
RAM_Activity_Type_PartRAMActivityTypePart
RAM_Activity_Type_SkillRAMActivityTypeSkill
RAM_Activity_Type_ToolRAMActivityTypeTool
RAM_Act_Template_OperationRAMActTemplateOperation
RAM_Act_Template_Usage_PeriodRAMActTempUsagePeriod
RAM_Activity_Type_App_TemplateRAMActTypeAppTemplate
RAM_Act_Type_Custom_MetricRAMActTypeCustomMetric
RAM_Appointment_TemplateRAMAppointmentTemplate
RAM_Appointment_Template_ItemRAMApptTemplateItem
RAM_AttributeRAMAttribute
RAM_Attribute_Allowed_ValueRAMAttribAllowedValue
RAM_Attribute_ValueRAMAttributeValue
RAM_CalendarRAMCalendar
RAM_Calendar_ItemRAMCalendarItem
RAM_CapacityRAMCapacity
RAM_Capacity_PartRAMCapacityPart
RAM_CommentRAMComment
RAM_ContractRAMContract
RAM_CustomerRAMCustomer
RAM_Custom_MetricRAMCustomMetric
RAM_DatasetRAMDataset
RAM_Data_UpdateRAMDataUpdate
RAM_Depot_Trans_SettingsRAMDepotTransSettings
RAM_Distance_PenaltyRAMDistancePenalty
RAM_DivisionRAMDivision
RAM_Division_RequirementRAMDivisionRequirement
RAM_Division_TypeRAMDivisionType
RAM_Fuel_TypeRAMFuelType
RAM_IconRAMIcon
RAM_LocationRAMLocation
RAM_Location_DivisionRAMLocationDivision
RAM_Location_TypeRAMLocationType
RAM_Membership_CategoryRAMMembershipCategory
RAM_Modelling_PatternRAMModellingPattern
RAM_Object_GroupRAMObjectGroup
RAM_OperationRAMOperation
RAM_Operation_HierarchyRAMOperationHieararchy
RAM_Operation_OrderingRAMOperationOrdering
RAM_Operation_SkillRAMOperationSkill
RAM_PartRAMPart
RAM_Part_StockRAMPartStock
RAM_Part_Transfer_SettingsRAMPartTransferSettings
RAM_PositionRAMPosition
RAM_ProjectRAMProject
RAM_Project_GroupRAMProjectGroup
RAM_Project_LevelRAMProjectLevel
RAM_Project_TemplateRAMProjectTemplate
RAM_Project_Template_GroupRAMProjectTemplateGroup
RAM_Project_Template_LevelRAMProjectTemplateLevel
RAM_RequirementRAMRequirement
RAM_Requirement_PositionRAMRequirementPosition
RAM_Requirement_Position_LevelRAMRequirementPosLevel
RAM_Requirement_RoleRAMRequirementRole
RAM_Requirement_Role_LevelRAMRequirementRoleLevel
RAM_ResourceRAMResource
RAM_Resource_CapacityRAMResourceCapacity
RAM_Resource_DivisionRAMResourceDivision
RAM_Resource_Division_AvailabilityRAMResDivisionAvail
RAM_Resource_PoolRAMResourcePool
RAM_Resource_Pool_ResourceRAMResourcePoolResource
RAM_Resource_Pool_Res_TypeRAMResourcePoolResType
RAM_Resource_Pool_SetRAMResourcePoolSet
RAM_Resource_PreferenceRAMResourcePreference
RAM_Resource_RetentionRAMResourceRetention
RAM_Resource_SkillRAMResourceSkill
RAM_Resource_Skill_AvailabilityRAMResourceSkillAvail
RAM_Resource_Travel_WithRAMResourceTravelWith
RAM_Resource_TypeRAMResourceType
RAM_Resource_Type_CapacityRAMResourceTypeCapacity
RAM_Resource_Type_LocationRAMResourceTypeLocation
RAM_Resource_Type_SkillRAMResourceTypeSkill
RAM_Resource_Type_TransitionRAMResTypeTransition
RAM_RoleRAMRole
RAM_Role_SkillRAMRoleSkill
RAM_RotaRAMRota
RAM_RuleRAMRule
RAM_Rule_CollectionRAMRuleCollection
RAM_Rule_Collection_RuleRAMRuleCollectionRule
RAM_Rule_OverrideRAMRuleOverride
RAM_Rule_ParameterRAMRuleParameter
RAM_Separation_GroupRAMSeparationGroup
RAM_Separation_ModelRAMSeparationModel
RAM_Separation_Model_ItemRAMSeparationModelItem
RAM_Shift_CategoryRAMShiftCategory
RAM_Shift_TemplateRAMShiftTemplate
RAM_Shift_Template_ItemRAMShiftTemplateItem
RAM_Shift_Template_Item_BreakRAMShiftTempItemBreak
RAM_Shift_Template_MembershipRAMShiftTempMembership
RAM_Shift_Template_SetRAMShiftTemplateSet
RAM_Shift_Template_Set_ItemRAMShiftTempSetItem
RAM_SkillRAMSkill
RAM_Skill_HierarchyRAMSkillHierarchy
RAM_Skill_TypeRAMSkillType
RAM_SLA_TemplateRAMSLATemplate
RAM_SLA_Template_ItemRAMSLATemplateItem
RAM_SLA_TypeRAMSLAType
RAM_Slot_Usage_RuleRAMSlotUsageRule
RAM_Slot_Usage_Rule_SetRAMSlotUsageRuleSet
RAM_Special_DayRAMSpecialDay
RAM_Special_Day_ItemRAMSpecialDayItem
RAM_TargetRAMTarget
RAM_Target_FocusRAMTargetFocus
RAM_Target_LevelRAMTargetLevel
RAM_Team_RequirementRAMTeamRequirement
RAM_Template_Operation_UsageRAMTempOperationUsage
RAM_Time_PatternRAMTimePattern
RAM_Time_Pattern_TemplateRAMTimePatternTemplate
RAM_Time_Pattern_Template_ItemRAMTimePatternTempItem
RAM_Transfer_Rule_TemplateRAMTransferRuleTemplate
RAM_Transfer_Rule_Tmp_ItemRAMTransferRuleTmpItem
RAM_Transfer_Rule_Tmp_LevelRAMTransRuleTmpLevel
RAM_Travel_Cost_ModelRAMTravelCostModel
RAM_Travel_PenaltyRAMTravelPenalty
RAM_UnavailabilityRAMUnavailability
RAM_Unavailability_CategoryRAMUnavailCategory
RAM_Usage_ClassRAMUsageClass
RAM_Usage_ModelRAMUsageModel
RAM_Usage_Model_ItemRAMUsageModelItem
RAM_Usage_Model_SLARAMUsageModelSLA
RAM_Utilisation_TemplateRAMUtilisationTemplate
RAM_Utilisation_Template_ItemRAMUtilisationTempItem
RAM_VehicleRAMVehicle
RAM_Vehicle_ClassRAMVehicleClass
RAM_Vehicle_ModelRAMVehicleModel
RAM_Vehicle_Ownership_TypeRAMVehicleOwnershipType