Job Team field specifications
This table lists the field-column specifications in the Job Team import interface. Fields with the asterisk (*) symbol are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | WBT_NAME* | Varchar2 | 40 | Team name (WBT_NAME), which is resolved to the WBT_ID field. |
| 2 | JOB_NAME* | Varchar2 | 40 | Job name (JOB_NAME), which is resolved to the JOB_ID field. |
| 3 | JOBTEAM_DOT_THRESH* | Number | 2 | Daily Overtime Threshold.
Number of hours in a day in which beyond this point the employee is considered to be working overtime. |
| 4 | JOBTEAM_WOT_THRESH* | Number | 2 | Weekly Overtime Threshold.
Number of hours in a week in which beyond this point the employee is considered to be working overtime. |
| 5 | JOBTEAM_AV_HR_RATE* | Number | 2 | Average Hourly Rate |
| 6 | JOBTEAM_OT_MULT* | Number | 2 | Overtime Multiplier.
The factor by which the average hourly rate for this job is multiplied to determine the overtime rate. |
| 7 | JOBTEAM_OT_INC* | Number | 2 | Overtime Increment.
Used to estimate the overtime cost (where Base Rate * OT Multiplier + OT increment = OT Cost). |
| 8 | JOBTEAM_SORT_ORDER | Number | 2 | Auto-assignment sort order.
This field determines the relative priority for auto assignment when matching employees to jobs and skills. A higher sort order results to a higher priority for a job. Duplicate values are not allowed unless they are null. Null values have the lowest priority in the sort order and share the same sort order. If there is no Auto Assignment sort order value specified, all jobs are treated equally for the team. |