Staffing Requirements Template and Shift Template Import Interface field specifications
This table lists the field-column specifications in the Staffing Requirements Template and Shift Template import interface. Fields marked with an asterisk (*) are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | Template Type* | Varchar2 |
This is used to determine whether the import is for a Staffing Requirement Template or a Shift Template.
The valid values for this field are:
|
|
| 2 | SRT Parent | Varchar2 | Specify an existing SRT Name. This field is only valid if you specify ST in the Template Type.
If an SRT Name is specified for an SRT record, this field is skipped. If this field is blank for an ST record, a shift template is created under NO TEMPLATE. |
|
| 3 | Name* | Varchar2 | 40 |
SRT or ST name |
| 4 | Description | Varchar2 | 100 |
Description for the SRT or ST. |
| 5 | Team* | Varchar2 | 40 |
Teams for the SRT or ST. |
| 6 | Length* | Integer | Length of the SRT or ST. You can specify values between 1 to 999. | |
| 7 | Workload Unit* | Varchar2 |
Specify the Headcounts or Hours.
Note: This field is only required if you are importing an SRT.
|
|
| 8 | Include Areas* | Varchar2 | 1 | Specify True or False. The default value is False.
Note: This field is skipped if you are importing an ST.
|
| 9 | Active* | Varchar2 | 1 | Specify True or False . The default value is True. |
| 10 | Start Date* | Varchar2 | Specify a date not earlier than 01/01/1900. Use the MM/dd/yyyy format. | |
| 11 | End Date* | Varchar2 | Specify a date not later then 01/01/3000. Use the MM/dd/yyyy format. | |
| 12 | Remove Unassigned* | Varchar2 | 1 | Specify True or False . The default value is False.
Note: This field is skipped if you are importing an SRT.
|
| 13 | Replacement Shifts* | Varchar2 | 1 | Specify True or False . The default value is False.
Note: This field is skipped if you are importing an SRT.
|
| 14 | Day Part* | Varchar2 | The valid values for this field are the day parts that belong to the specified Teams. | |
| 15 | Area* | Varchar2 | The valid values for this field are the active areas that belong to the specified Teams.
Note: This field is only required if the specified value in Include Areas is True.
|
|
| 16 | Job* | Varchar2 | The valid values for this field are jobs that have a start date and end date within the specified period. | |
| 17 | Priority* | Integer | Specify a value between 0 and 999. The default value is 0.
Note: This field is skipped if you are importing an ST.
|
|
| 18 | Shift* | Varchar2 | 40 | The valid values for this filed are shifts that belong to the team and are active between the start and end time. This field is required for ST.
Note: This field is skipped if you are importing an SRT.
|
| 19 | Skill | Varchar2 | Use a vertical bar (|) as a separator when specifying more than one skill for a single record. The | |
| 20 | Proficiency* | Varchar2 | This field is skipped if there is no skill specified. The valid values are 0 to 999.
Separate the proficiency values for different skills using a vertical bar. If the same proficiency is applied to all skills, specify a single value. The maximum number of characters supported in this field is 1000. The default value is 0. |
|
| 21 | Mandatory* | Varchar2 | 1 | This field is skipped if there is no skill specified. The valid values are True to False.
Separate the proficiency values for different skills using a vertical bar. If the same proficiency is applied to all skills, specify a single value. The maximum number of characters supported in this field is 1000. The default value is False. |
| 22 | Day* | Integer | Specify a value between 1 and the Length value. If a Day N is skipped, the value for that day is 0. | |
| 23 | Value* | Integer | Specify a value between 0 and the maximum value in the database.
The default value is 0. |
|
| 24 | Skill Value | Varchar2 | Specify a value between 0 and the maximum value in the database.
Separate the proficiency values for different skills using a vertical bar. If the same proficiency is applied to all skills, specify a single value. The maximum number of characters supported in this field is 1000. The default value is 0. This field is skipped for ST and when left blank. |
You must specify a record for each day as specified in the Length field. If there is no record for a day, the value is automatically 0.