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

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 (&) in the flag position indicates the flag is to be blanked.

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.