Work Detail Import Interface field specification

This table lists the field-column specifications of the Work Detail Import Interface. Fields with the asterisk symbol (*) are required.

Col. Field Name Type Size/Format Description
1 Emp_Name* Varchar2 40 Employee name
2 Ovrtyp_ID* Varchar2 10 Override type for which to create the override. Optionally, the override order (Ovr_Order) can be supplied by appending a tilde (~) symbol with the override order. For example: 600~1. Override order is used only for timesheet (elapsed time) overrides and defaults to 0 if not supplied.
3 Work_Date* Varchar2 40/yyyyMMdd Date of the schedule
4 Start_Time Varchar2 40/yyyyMMdd HHmm Schedule start time
5 End_Time Varchar2 40/yyyyMMdd HHmm Schedule end time
6 Wrkd_Minutes Varchar2 40 Minutes of work. Required for premium type overrides.
Note: Worked minutes should be positive when using the Work Detail Import.
7 Tcode_Name Varchar2 40 Time code name
8 Dept_Name Varchar2 40 Department name
9 Job_Name Varchar2 40 Job name
10 Proj_Name Varchar2 40 Project name
11 Dock_Name Varchar2 40 Docket name
12 Htype_Name Varchar2 40 Hour type name
13 Ovr_Wbu_Name Varchar2 40 The creator user or process name. Default is Work Detail Interface.
14 Ovr_Comments Varchar2 200 Comments that accompany the override
15 Wrkd_Rate Varchar2 40 Work rate
16 Wrkd_Quantity Varchar2 40 Work quantity
17 Wrkd_Comments Varchar2 40 Comments
18 Wrkd_UDF1 Varchar2 40 Work detail UDF1
19 Wrkd_UDF2 Varchar2 40 Work detail UDF2
20 Wrkd_UDF3 Varchar2 40 Work detail UDF3
21 Wrkd_UDF4 Varchar2 40 Work detail UDF4
22 Wrkd_UDF5 Varchar2 40 Work detail UDF5
23 Wrkd_UDF6 Varchar2 40 Work detail UDF6
24 Wrkd_UDF7 Varchar2 40 Work detail UDF7
25 Wrkd_UDF8 Varchar2 40 Work detail UDF8
26 Wrkd_UDF9 Varchar2 40 Work detail UDF9
27 Wrkd_UDF10 Varchar2 40 Work detail UDF10
28 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 (&) in the flag position indicates the flag is to be blanked.
29 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.
30 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.
31 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.