Field Listing for Table ASSIGNMENTLOADING
Field: | RESOURCELEVEL | Type: | VARCHAR Length: 10 |
Field: | RESOURCETYPE | Type: | VARCHAR Length: 20 |
Field: | RESOURCENAME | Type: | VARCHAR Length: 30 |
Field: | TIMESCALE | Type: | VARCHAR Length: 10 |
Field: | DEPARTMENTCODE | Type: | VARCHAR Length: 20 |
Field: | PERIOD1PERCENT | Type: | INTEGER |
Field: | PERIOD2PERCENT | Type: | INTEGER |
Field: | PERIOD3PERCENT | Type: | INTEGER |
Field: | PERIOD4PERCENT | Type: | INTEGER |
Field: | PERIOD5PERCENT | Type: | INTEGER |
Field: | PERIOD6PERCENT | Type: | INTEGER |
Field: | PERIOD7PERCENT | Type: | INTEGER |
Field: | PERIOD8PERCENT | Type: | INTEGER |
Field: | PERIOD9PERCENT | Type: | INTEGER |
Field: | PERIOD10PERCENT | Type: | INTEGER |
Field: | PERIOD11PERCENT | Type: | INTEGER |
Field: | PERIOD12PERCENT | Type: | INTEGER |
Field: | PERIOD13PERCENT | Type: | INTEGER |
Field: | PERIOD14PERCENT | Type: | INTEGER |
Field: | PERIOD15PERCENT | Type: | INTEGER |
Field: | PERIOD16PERCENT | Type: | INTEGER |
Field: | PERIOD17PERCENT | Type: | INTEGER |
Field: | PERIOD18PERCENT | Type: | INTEGER |
Field: | PERIOD19PERCENT | Type: | INTEGER |
Field: | PERIOD20PERCENT | Type: | INTEGER |
Field: | PERIOD21PERCENT | Type: | INTEGER |
Field: | PERIOD22PERCENT | Type: | INTEGER |
Field: | PERIOD23PERCENT | Type: | INTEGER |
Field: | PERIOD24PERCENT | Type: | INTEGER |
Field: | PERIOD25PERCENT | Type: | INTEGER |
Field: | PERIOD26PERCENT | Type: | INTEGER |
Field: | PERIOD27PERCENT | Type: | INTEGER |
Field: | PERIOD28PERCENT | Type: | INTEGER |
Field: | PERIOD29PERCENT | Type: | INTEGER |
Field: | PERIOD30PERCENT | Type: | INTEGER |
Field: | PERIOD1COLOUR | Type: | INTEGER |
Field: | PERIOD2COLOUR | Type: | INTEGER |
Field: | PERIOD3COLOUR | Type: | INTEGER |
Field: | PERIOD4COLOUR | Type: | INTEGER |
Field: | PERIOD5COLOUR | Type: | INTEGER |
Field: | PERIOD6COLOUR | Type: | INTEGER |
Field: | PERIOD7COLOUR | Type: | INTEGER |
Field: | PERIOD8COLOUR | Type: | INTEGER |
Field: | PERIOD9COLOUR | Type: | INTEGER |
Field: | PERIOD10COLOUR | Type: | INTEGER |
Field: | PERIOD11COLOUR | Type: | INTEGER |
Field: | PERIOD12COLOUR | Type: | INTEGER |
Field: | PERIOD13COLOUR | Type: | INTEGER |
Field: | PERIOD14COLOUR | Type: | INTEGER |
Field: | PERIOD15COLOUR | Type: | INTEGER |
Field: | PERIOD16COLOUR | Type: | INTEGER |
Field: | PERIOD17COLOUR | Type: | INTEGER |
Field: | PERIOD18COLOUR | Type: | INTEGER |
Field: | PERIOD19COLOUR | Type: | INTEGER |
Field: | PERIOD20COLOUR | Type: | INTEGER |
Field: | PERIOD21COLOUR | Type: | INTEGER |
Field: | PERIOD22COLOUR | Type: | INTEGER |
Field: | PERIOD23COLOUR | Type: | INTEGER |
Field: | PERIOD24COLOUR | Type: | INTEGER |
Field: | PERIOD25COLOUR | Type: | INTEGER |
Field: | PERIOD26COLOUR | Type: | INTEGER |
Field: | PERIOD27COLOUR | Type: | INTEGER |
Field: | PERIOD28COLOUR | Type: | INTEGER |
Field: | PERIOD29COLOUR | Type: | INTEGER |
Field: | PERIOD30COLOUR | Type: | INTEGER |
Field: | PERIOD1CAPACITY | Type: | DOUBLE |
Field: | PERIOD2CAPACITY | Type: | DOUBLE |
Field: | PERIOD3CAPACITY | Type: | DOUBLE |
Field: | PERIOD4CAPACITY | Type: | DOUBLE |
Field: | PERIOD5CAPACITY | Type: | DOUBLE |
Field: | PERIOD6CAPACITY | Type: | DOUBLE |
Field: | PERIOD7CAPACITY | Type: | DOUBLE |
Field: | PERIOD8CAPACITY | Type: | DOUBLE |
Field: | PERIOD9CAPACITY | Type: | DOUBLE |
Field: | PERIOD10CAPACITY | Type: | DOUBLE |
Field: | PERIOD11CAPACITY | Type: | DOUBLE |
Field: | PERIOD12CAPACITY | Type: | DOUBLE |
Field: | PERIOD13CAPACITY | Type: | DOUBLE |
Field: | PERIOD14CAPACITY | Type: | DOUBLE |
Field: | PERIOD15CAPACITY | Type: | DOUBLE |
Field: | PERIOD16CAPACITY | Type: | DOUBLE |
Field: | PERIOD17CAPACITY | Type: | DOUBLE |
Field: | PERIOD18CAPACITY | Type: | DOUBLE |
Field: | PERIOD19CAPACITY | Type: | DOUBLE |
Field: | PERIOD20CAPACITY | Type: | DOUBLE |
Field: | PERIOD21CAPACITY | Type: | DOUBLE |
Field: | PERIOD22CAPACITY | Type: | DOUBLE |
Field: | PERIOD23CAPACITY | Type: | DOUBLE |
Field: | PERIOD24CAPACITY | Type: | DOUBLE |
Field: | PERIOD25CAPACITY | Type: | DOUBLE |
Field: | PERIOD26CAPACITY | Type: | DOUBLE |
Field: | PERIOD27CAPACITY | Type: | DOUBLE |
Field: | PERIOD28CAPACITY | Type: | DOUBLE |
Field: | PERIOD29CAPACITY | Type: | DOUBLE |
Field: | PERIOD30CAPACITY | Type: | DOUBLE |
Field: | PERIOD1LOADING | Type: | DOUBLE |
Field: | PERIOD2LOADING | Type: | DOUBLE |
Field: | PERIOD3LOADING | Type: | DOUBLE |
Field: | PERIOD4LOADING | Type: | DOUBLE |
Field: | PERIOD5LOADING | Type: | DOUBLE |
Field: | PERIOD6LOADING | Type: | DOUBLE |
Field: | PERIOD7LOADING | Type: | DOUBLE |
Field: | PERIOD8LOADING | Type: | DOUBLE |
Field: | PERIOD9LOADING | Type: | DOUBLE |
Field: | PERIOD10LOADING | Type: | DOUBLE |
Field: | PERIOD11LOADING | Type: | DOUBLE |
Field: | PERIOD12LOADING | Type: | DOUBLE |
Field: | PERIOD13LOADING | Type: | DOUBLE |
Field: | PERIOD14LOADING | Type: | DOUBLE |
Field: | PERIOD15LOADING | Type: | DOUBLE |
Field: | PERIOD16LOADING | Type: | DOUBLE |
Field: | PERIOD17LOADING | Type: | DOUBLE |
Field: | PERIOD18LOADING | Type: | DOUBLE |
Field: | PERIOD19LOADING | Type: | DOUBLE |
Field: | PERIOD20LOADING | Type: | DOUBLE |
Field: | PERIOD21LOADING | Type: | DOUBLE |
Field: | PERIOD22LOADING | Type: | DOUBLE |
Field: | PERIOD23LOADING | Type: | DOUBLE |
Field: | PERIOD24LOADING | Type: | DOUBLE |
Field: | PERIOD25LOADING | Type: | DOUBLE |
Field: | PERIOD26LOADING | Type: | DOUBLE |
Field: | PERIOD27LOADING | Type: | DOUBLE |
Field: | PERIOD28LOADING | Type: | DOUBLE |
Field: | PERIOD29LOADING | Type: | DOUBLE |
Field: | PERIOD30LOADING | Type: | DOUBLE |
Field: | RESOURCEDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | LOADINGSTARTDATE | Type: | DATE |
Field: | PERIOD1VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD2VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD3VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD4VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD5VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD6VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD7VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD8VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD9VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD10VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD11VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD12VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD13VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD14VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD15VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD16VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD17VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD18VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD19VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD20VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD21VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD22VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD23VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD24VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD25VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD26VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD27VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD28VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD29VALUES | Type: | VARCHAR Length: 65 |
Field: | PERIOD30VALUES | Type: | VARCHAR Length: 65 |
Field: | DEPARTMENTSEQUENCE | Type: | INTEGER |
Field: | RESOURCESEQUENCE | Type: | INTEGER |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |