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 |