Work Detail field specifications
This table lists the field-column specifications of the Work Detail part of the Schedule Work Detail Import Interface. Fields with the asterisk symbol (*) are required.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Type_Identifier | Varchar2 | 1 | D for work detail records |
2 | Emp_Name* | Varchar2 | 40 | Employee name |
3 | Ovrtyp_Id* | Varchar2 | 10 |
Override type for which to create the override. The override
order (Ovr_Order) can optionally be supplied by appending a tilde ( Override order is used only for timesheet elapsed time overrides and defaults to 0 if not supplied. |
4 | Work_Date* | Varchar2 | 40/yyyyMMdd | Date of the schedule |
5 | Start_Time | Varchar2 | 40/yyyyMMdd-HHmm | Schedule start time |
6 | End_Time | Varchar2 | 40/yyyyMMdd-HHmm | Schedule end time |
7 | Wrkd_Minutes | Varchar2 | 40 | Minutes of work. Required for premium type overrides. |
8 | Tcode_Name | Varchar2 | 40 | Time code name |
9 | Dept_Name | Varchar2 | 40 | Department name |
10 | Job_Name | Varchar2 | 40 | Job name |
11 | Proj_Name | Varchar2 | 40 | Project name |
12 | Dock_Name | Varchar2 | 40 | Docket name |
13 | Htype_Name | Varchar2 | 40 | Hour type name |
14 | Ovr_Wbu_Name | Varchar2 | 40 | The creator user/process name. Default is Work Detail Interface. |
15 | Ovr_Comments | Varchar2 | 200 | Comments that accompany the override |
16 | Wrkd_Rate | Varchar2 | 40 | Work rate |
17 | Wrkd_Quantity | Varchar2 | 40 | Work quantity |
18 | Wrkd_Comments | Varchar2 | 40 | Comments |
19 | Wrkd_UDF1 | Varchar2 | 40 | Work Detail UDF1 |
20 | Wrkd_UDF2 | Varchar2 | 40 | Work Detail UDF2 |
21 | Wrkd_UDF3 | Varchar2 | 40 | Work Detail UDF3 |
22 | Wrkd_UDF4 | Varchar2 | 40 | Work Detail UDF4 |
23 | Wrkd_UDF5 | Varchar2 | 40 | Work Detail UDF5 |
24 | Wrkd_UDF6 | Varchar2 | 40 | Work Detail UDF6 |
25 | Wrkd_UDF7 | Varchar2 | 40 | Work Detail UDF7 |
26 | Wrkd_UDF8 | Varchar2 | 40 | Work Detail UDF8 |
27 | Wrkd_UDF9 | Varchar2 | 40 | Work Detail UDF9 |
28 | Wrkd_UDF10 | Varchar2 | 40 | Work Detail UDF10 |
29 | Wrkd_Flags1..10 | Varchar2 | 10 | 10-one character flags for general use. Use a space character in the flag position to indicate no processing is to be done for that flag. An ampersand ( |
30 | End_Date | Varchar2 | 40/yyyyMMdd | The end date of the override. This optional field is only used with the LTA override type; the field is ignored for all other override types. |
31 | Bad_Quantity | Number | 10,5 | Number of items scrapped. This optional field is only used with the Work Premium Time override type (210); the field is ignored for all other override types. |
32 | Reason_Name | Varchar2 | 40 | Reason for the scrapped quantities. This optional field is only used with the Work Premium Time override type (210); the field is ignored for all other override types. |