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.
| 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 |