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). |