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

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