The purpose of the command is to break out the DMS capacity arrays into tables so that a third party tool can be used to access views and generate third party capacity reports.  The building of the capacity tables does not impact any other area of DMS; only the scheduler is affected where if the option is selected, the capacity tables would be built automatically after the schedule run.

Two tables and two views are created when the new schedule command “Build Capacity Tables” has been selected.  The command can be run manually from the Schedule menu using File | Build Capacity Tables or run automatically after a schedule run if the option “Auto build capacity tables for 3rd party” is selected on the Schedule Options of the Scheduler. 

Either a time period of Daily or Monthly can be selected.  Whatever time period is selected on the options tab is the time period used if the File | Build Capacity Tables command is executed.

The first pass creates the table CapacityLoadDetail that has a corresponding view called VWCapacityLoadDetail.  The second pass typically takes longer and creates the table OperationLoadDetail that has a corresponding view  VWOperationLoadDetail. 

VWCapacityLoadDetail has the following columns:

1. YearNo The year number (i.e. 2011, 2012, etc.)  Integer
2. MonthNo The month number from 1 to 12.  Integer
3. DayDate The date.  If monthly, the date will be the first day of the month.  DateTime
4. ResourceID Internal ID to link to the Resource table.  Integer
5. ResourceName Name of the resource.  String 20.
6. CapacityHrs The capacity in hours of the resource for the time period.  Float
7. LoadHrs The load in hours on the resource.  Float

VWOperationLoadDetail has the following columns:

1. YearNo The year number (i.e. 2011, 2012, etc.)  Integer
2. MonthNo The month number from 1 to 12.  Integer
3. DayDate The date.  If monthly, the date will be the first day of the month.  DateTime
4. OrderNumber  The order number of the operation’s job.  String 25
5. PartNo  The part number of the job.  String 45
6. JobId  The Job Identification.  String 45
7. OperationID Internal ID to link to the operation table.  Big Integer
8. Ident Operation identification.  String 15
9. ResourceName Name of the resource.  String 20
10. LoadHrs  The hours used by this option on the resource for the time period.  Float

The option to build capacity tables can also be selected on the Options tab of the Scheduler.  If “Auto build capacity tables for 3rd party” is selected, the scheduler will automatically build the capacity tables at the end of the schedule run.