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