Output data
During a Scheduler run, APS populates the following SQL Server tables:
Table | Contents |
---|---|
BATTIME | A record for each batch which stores the time the batch was formed and how long it processed. |
BATWAIT | A record for each order which was part of a batch which stores the time the order started waiting and how long it waited. |
DOWN | A record for each period of time any resource is projected to be idle, and the reason for the idleness. |
JOB | Information about allocations (operations scheduled) and loads the operations have generated. |
MATSCHD | Information about jobs that affect material inventory. |
ORDIND | Used internally by the Scheduler to join tables. |
RESLOAD | Information about a resource's load for each planning period (such as the number of hours a resource is loaded). |
RESSCHD | Information about the operations the Scheduler has scheduled and the resources those operations have allocated. This data includes the start and end times (sequencing information). |
RGLOAD | Information about a resource group's load for each planning period. |