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:

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_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_Shift_Category RAMShiftCategory
RAM_Shift_Template_Set RAMShiftTemplateSet
RAM_Skill_Type RAMSkillType
RAM_SLA_Template RAMSLATemplate
RAM_SLA_Type RAMSLAType
RAM_Target RAMTarget
RAM_Time_Pattern_Template RAMTimePatternTemplate
RAM_Travel_Cost_Model RAMTravelCostModel
RAM_Unavailability_Category RAMUnavailCategory
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_Division RAMDivision
RAM_Position RAMPosition
RAM_Project_Template_Group RAMProjectTemplateGroup
RAM_Project_Template_Level RAMProjectTemplateLevel
RAM_Rule RAMRule
RAM_Shift_Template RAMShiftTemplate
RAM_Skill RAMSkill
RAM_SLA_Template_Item RAMSLATemplateItem
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_Utilisation_Template_Item RAMUtilisationTempItem
RAM_Activity_Type_App_Template RAMActTypeAppTemplate
RAM_Activity_Type_Part RAMActivityTypePart
RAM_Activity_Type_Skill RAMActivityTypeSkill
RAM_Location_Type RAMLocationType
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_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_Resource RAMResource
RAM_Resource_Type_Capacity RAMResourceTypeCapacity
RAM_Resource_Type_Location RAMResourceTypeLocation
RAM_Resource_Type_Skill RAMResourceTypeSkill
RAM_Resource_Type_Transition RAMResTypeTransition
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