Database overview

The diagram below illustrates the data hierarchy in the SQL Server database used by both the Planner and the Scheduler.

• An Order is a request for item production.
• An Item is the output of the production.
• A quantity of items is divided into Loads, which proceed through the routing.
• A batch is a group of potentially disimilar items that are processed together.
• A Routing identifies how to make the item.
• Operations are the steps in the process of producing the item.
• Resources are the requirements for performing the job, such as crew or machines.
• Materials are the consumable production requirements (such as nuts and bolts).
• Deliveries add to the inventory level of materials.
• Holidays identify plant shutdowns and holidays.
• Shifts limit resource availability.
• Shift exceptions identify special situations such as overtime and maintenance.