VIEW_PAYEXP_ADJUSTMENT fields

This table lists the available fields in the VIEW_PAYEXP_ADJUSTMENT view. These fields are used in the <data> block of the XML definition. Fields with the asterisk symbol (*) must be exported.

Col. Field Name Type Size/Format Description
1 Emp_Name* Varchar2 40 Employee identification name from the EMPLOYEE table.
2 Emp_Lastname Varchar2 40 Employee last name from EMPLOYEE table.
3 Emp_Firstname Varchar2 40 Employee first name from EMPLOYEE table.
4 Emp_Val1 Varchar2 40 Employee value from EMPLOYEE table.
5 Emp_Val2 Varchar2 40 Employee value from EMPLOYEE table.
6 Emp_Val3 Varchar2 40 Employee value from EMPLOYEE table.
7 Emp_Val4 Varchar2 40 Employee value from EMPLOYEE table.
8 Emp_Val5 Varchar2 40 Employee value from EMPLOYEE table.
9 Emp_Val6 Varchar2 40 Employee value from EMPLOYEE table.
10 Emp_Val7 Varchar2 40 Employee value from EMPLOYEE table.
11 Emp_Val8 Varchar2 40 Employee value from EMPLOYEE table.
12 Emp_Val9 Varchar2 40 Employee value from EMPLOYEE table.
13 Emp_Val10 Varchar2 40 Employee value from EMPLOYEE table.
14 Emp_Val11 Varchar2 40 Employee value from EMPLOYEE table.
15 Emp_Val12 Varchar2 40 Employee value from EMPLOYEE table.
16 Emp_Val13 Varchar2 40 Employee value from EMPLOYEE table.
17 Emp_Val14 Varchar2 40 Employee value from EMPLOYEE table.
18 Emp_Val15 Varchar2 40 Employee value from EMPLOYEE table.
19 Emp_Val16 Varchar2 40 Employee value from EMPLOYEE table.
20 Emp_Val17 Varchar2 40 Employee value from EMPLOYEE table.
21 Emp_Val18 Varchar2 40 Employee value from EMPLOYEE table.
22 Emp_Val19 Varchar2 40 Employee value from EMPLOYEE table.
23 Emp_Val20 Varchar2 40 Employee value from EMPLOYEE table.
24 Emp_ID Number 10 From WORK_DETAIL_ADJUST table.
25 Wrks_Start_Time Date From WORK_DETAIL_ADJUST table.
26 Wrks_End_Time Date From WORK_DETAIL_ADJUST table.
27 Wrks_Manual_Calc Char 1 From WORK_DETAIL_ADJUST table.
28 Shft_ID Number 10 From WORK_DETAIL_ADJUST table.
29 Paygrp_ID Number 10 From WORK_DETAIL_ADJUST table.
30 Calcgrp_ID Number 10 From WORK_DETAIL_ADJUST table.
31 Wrks_Authorized Char 1 From WORK_DETAIL_ADJUST table.
32 Wrks_Auth_By Varchar2 From WORK_DETAIL_ADJUST table.
33 Wrks_Auth_Date Date From WORK_DETAIL_ADJUST table.
34 Wrks_Flag_Brk Varchar2 1 From WORK_DETAIL_ADJUST table.
35 Wrks_Flag_Recall Varchar2 1 From WORK_DETAIL_ADJUST table.
36 Wrks_Flag1 Varchar2 1 From WORK_DETAIL_ADJUST table.
37 Wrks_Flag2 Varchar2 1 From WORK_DETAIL_ADJUST table.
38 Wrks_Flag3 Varchar2 1 From WORK_DETAIL_ADJUST table.
39 Wrks_Flag4 Varchar2 1 From WORK_DETAIL_ADJUST table.
40 Wrks_Flag5 Varchar2 1 From WORK_DETAIL_ADJUST table.
41 Wrks_UDF1 Varchar2 40 From WORK_DETAIL_ADJUST table.
42 Wrks_UDF2 Varchar2 40 From WORK_DETAIL_ADJUST table.
43 Wrks_UDF3 Varchar2 40 From WORK_DETAIL_ADJUST table.
44 Wrks_UDF4 Varchar2 40 From WORK_DETAIL_ADJUST table.
45 Wrks_UDF5 Varchar2 40 From WORK_DETAIL_ADJUST table.
46 Wrks_UDF6 Varchar2 40 From WORK_DETAIL_ADJUST table.
47 Wrks_UDF7 Varchar2 40 From WORK_DETAIL_ADJUST table.
48 Wrks_UDF8 Varchar2 40 From WORK_DETAIL_ADJUST table.
49 Wrks_UDF9 Varchar2 40 From WORK_DETAIL_ADJUST table.
50 Wrks_UDF10 Varchar2 40 From WORK_DETAIL_ADJUST table.
51 Wrks_Desc Varchar2 100 From WORK_DETAIL_ADJUST table.
52 Wrks_Clocks Varchar2 4000 From WORK_DETAIL_ADJUST table.
53 Wrkd_Start_Time Date From WORK_DETAIL_ADJUST table.
54 Wrkd_End_Time Date From WORK_DETAIL_ADJUST table.
55 Wrkd_Minutes* Number 10 From WORK_DETAIL_ADJUST table.
56 Wrkd_Rate* Number 20,5 From WORK_DETAIL_ADJUST table.
57 Wrkd_Work_Date* Date From WORK_DETAIL_ADJUST table.
58 Wrkda_Adjust_Date Date From WORK_DETAIL_ADJUST table.
59 Dock_ID Number 10 From WORK_DETAIL table.
60 Htype_ID Number 10 From WORK_DETAIL table.
61 Job_ID Number 10 From WORK_DETAIL table.
62 Tcode_ID Number 10 From WORK_DETAIL table.
63 Proj_ID Number 10 From WORK_DETAIL table.
64 Wrkd_Quantitiy Number 20,10 From WORK_DETAIL table.
65 Wrkd_Type Varchar2 1 From WORK_DETAIL table.
66 Wrkd_Flag1 Varchar2 1 From WORK_DETAIL table.
67 Wrkd_Flag2 Varchar2 1 From WORK_DETAIL table.
68 Wrkd_Flag Varchar2 1 From WORK_DETAIL table.
69 Wrkd_Flag4 Varchar2 1 From WORK_DETAIL table.
70 Wrkd_Flag5 Varchar2 1 From WORK_DETAIL table.
71 Wrkd_Flag5 Varchar2 1 From WORK_DETAIL table.
72 Wrkd_Flag6 Varchar2 1 From WORK_DETAIL table.
73 Wrkd_Flag7 Varchar2 1 From WORK_DETAIL table.
74 Wrkd_Flag8 Varchar2 1 From WORK_DETAIL table.
75 Wrkd_Flag9 Varchar2 1 From WORK_DETAIL table.
76 Wrkd_Flag10 Varchar2 1 From WORK_DETAIL table.
77 Dept_ID Number 10 From WORK_DETAIL table.
78 Wrkd_UDF1 Varchar2 40 From WORK_DETAIL table.
79 Wrkd_UDF2 Varchar2 40 From WORK_DETAIL table.
80 Wrkd_UDF3 Varchar2 40 From WORK_DETAIL table.
81 Wrkd_UDF4 Varchar2 40 From WORK_DETAIL table.
82 Wrkd_UDF5 Varchar2 40 From WORK_DETAIL table.
83 Wrkd_UDF6 Varchar2 40 From WORK_DETAIL table.
84 Wrkd_UDF7 Varchar2 40 From WORK_DETAIL table.
85 Wrkd_UDF8 Varchar2 40 From WORK_DETAIL table.
86 Wrkd_UDF9 Varchar2 40 From WORK_DETAIL table.
87 Wrkd_UDF10 Varchar2 40 From WORK_DETAIL table.
88 Retro Varchar2 1 Not in table. 'Y' indicates that this is the adjustment view.