Scheduling Data

Scheduling data includes data fetches for tables for scheduling entities such as activities, resources, shifts, skills etc. Full details of the scheduling schema can be found in the Scheduling Schema Guide in the IFS Planning & Scheduling Optimization (PSO) documentation.

Tables & Rules mapped

Table Rule
Application_Dataset ApplicationDataset
Dataset Dataset
Activity Activity
Activity_Group ActivityGroup
Activity_Incentive ActivityIncentive
Activity_Part ActivityPart
Activity_Productive_Time ActivityProductiveTime
Activity_Resource_Pool_Set ActivityResourcePoolSet
Activity_Skill ActivitySkill
Activity_SLA ActivitySLA
Activity_Status ActivityStatus
Activity_Type ActivityType
Activity_Type_Skill ActivityTypeSkill
Activity_Type_Part ActivityTypePart
Additional_Attribute AdditionalAttribute
Appointment_Offer_Response AppointmentOfferResponse
Appointment_Request AppointmentRequest
Appointment_Template AppointmentTemplate
Appointment_Template_Item AppointmentTemplateItem
Activity_Type_App_Template ActivityTypeAppTemplate
Availability Availability
Availability_Pattern AvailabilityPattern
Broadcast Broadcast
Broadcast_Parameter BroadcastParameter
Calendar Calendar
Calendar_Item CalendarItem
Capacity Capacity
Capacity_Part CapacityPart
Contract Contract
Customer Customer
Custom_Exception CustomException
Custom_Exception_Data CustomExceptionData
Custom_URL CustomURL
Incentive Incentive
Incentive_Availability IncentiveAvailability
Isochrone_Request IsochroneRequest
Location Location
Location_Region LocationRegion
Location_Type LocationType
Modelling_Pattern ModellingPattern
Object_Deletion ObjectDeletion
Object_Group ObjectGroup
Part Part
Part_Stock PartStock
Productivity_Category ProductivityCategory
Region Region
Resources Resource
Resource_Capacity ResourceCapacity
Resource_Type_Capacity ResourceTypeCapacity
Resource_Part ResourcePart
Resource_Pool ResourcePool
Resource_Pool_Item ResourcePoolItem
Resource_Pool_Set ResourcePoolSet
Resource_Preference ResourcePreference
Resource_Region ResourceRegion
Resource_Skill ResourceSkill
Resource_Skill_Availability ResourceSkillAvail
Resource_Type ResourceType
Resource_Type_Location ResourceTypeLocation
Resource_Type_Skill ResourceTypeSkill
Resource_Type_Transition ResourceTypeTransition
Rule Rule
Rule_Collection RuleCollection
Rule_Collection_Rule RuleCollectionRule
Rule_Parameter RuleParameter
Rule_Resource RuleResource
Schedule_Event ScheduleEvent
Schedule_Exception_Response ScheduleExceptResponse
Shift Shift
Shift_Pattern ShiftPattern
Shift_Type ShiftType
Skill Skill
Skill_Hierarchy SkillHierarchy
Skill_Set SkillSet
Skill_Set_Incentive SkillSetIncentive
Skill_Set_Incentive_Avail SkillSetIncentiveAvail
Skill_Set_Incentive_Level SkillSetIncentiveLevel
Skill_Set_Skill SkillSetSkill
Skill_Type SkillType
SLA_Type SLAType
Separation_Group SeparationGroup
Separation_Model SeparationModel
Separation_Model_Item SeparationModelItem
Source_Data SourceData
Source_Data_Parameter SourceDataParameter
Special_Day SpecialDay
Special_Day_Item SpecialDayItem
Travel_Cost_Model TravelCostModel
Travel_Detail_Request TravelDetailRequest
Travel_Penalty TravelPenalty
Target Target
Target_Focus TargetFocus
Target_Level TargetLevel
URL_Parameter URLParameter
URL_String URLString
Visit_Part VisitPart

 

Broadcast

The Broadcast attributes are either hardcoded, set in the Dataset Parameters or set in the mapping package as follows:

 

* If these are set to true then the load input will include the additional broadcast request. This will always be for a 'CHANGE' plan and filtered to the correct allocation type (2 for ABE, 8 for DSP). In addition, if you don't explicitly set this parameter but the dataset process type is set to 'Appointment' then the ABE broadcast will automatically be added.

Broadcast Parameters

The Broadcast Parameters are taken from PSO Integration Configuration Broadcast Settings or hardcoded as follows: