How Does ARP Work

The ARP Architecture

The ARP architecture consists of the following

1. Modelling Database - All ARP data resides in this Database. All tables here are prefixed with RAM_

2. Resource Planning Service (RPL) - A windows service used to undertake processing of shift rotas.

3. Planning & Scheduling Optimization Workbench (PSW) - An GUI application allowing users to interact with the ARP system to define and Manage data.

In addition, the ARP requires the assistance of the following 

1. Scheduling System Database - This database holds all data relating to users, security, system settings and monitoring

2. Scheduling Administration Service (ADM) - A windows service to provide housekeeping functions on the database and monitor each scheduling service for errors and computer resource usage.

Initial Load Process

 1 - The external application sends the load to the Scheduling Input Manager for the Schedule. This load file consists of a extra tag of instruction which tells the SIM that it needs to get the ARP details.

 2 - The SIM then goes to the Modelling database to fetch this additional details

 3 - The SIM stiches up the data from the EA and the Modelling database and creates a single combined input files

 4 - This Input file which now has data from both the EA and ARP is pushed to the Scheduling Database

 5 - The DSE working on the scheduling database uses this new information and producing a new scheduling plan

 6 - The SBM is notified of a the availability of a new plan

 7 - The SBM broadcasts the new plan back to the EA

Below is the extra information tag received in the Input data which instructs the SIM to fetch the data from the ARP

 <Source_Data>

<source_data_type_id>RAM</source_data_type_id>

<sequence>1</sequence>

</Source_Data>

-<Source_Data_Parameter>

<source_data_type_id>RAM</source_data_type_id>

<sequence>1</sequence>

<parameter_name>rota_id</parameter_name>

<parameter_value>ABC</parameter_value>

</Source_Data_Parameter>