VIEW_PAYEXP_CURRENT fields

This table lists the available fields in the VIEW_PAYEXP_CURRENT 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_FLAG1 Varchar2 1 From EMPLOYEE table
25 EMP_FLAG2 Varchar2 1 From EMPLOYEE table
26 EMP_FLAG3 Varchar2 1 From EMPLOYEE table
27 EMP_FLAG4 Varchar2 1 From EMPLOYEE table
28 EMP_FLAG5 Varchar2 1 From EMPLOYEE table
29 EMP_FLAG6 Varchar2 1 From EMPLOYEE table
30 EMP_FLAG7 Varchar2 1 From EMPLOYEE table
31 EMP_FLAG8 Varchar2 1 From EMPLOYEE table
32 EMP_FLAG9 Varchar2 1 From EMPLOYEE table
33 EMP_FLAG10 Varchar2 1 From EMPLOYEE table
34 EMP_FLAG11 Varchar2 1 From EMPLOYEE table
35 EMP_FLAG12 Varchar2 1 From EMPLOYEE table
36 EMP_FLAG13 Varchar2 1 From EMPLOYEE table
37 EMP_FLAG14 Varchar2 1 From EMPLOYEE table
38 EMP_FLAG15 Varchar2 1 From EMPLOYEE table
39 EMP_FLAG16 Varchar2 1 From EMPLOYEE table
40 EMP_FLAG17 Varchar2 1 From EMPLOYEE table
41 EMP_FLAG18 Varchar2 1 From EMPLOYEE table
42 EMP_FLAG19 Varchar2 1 From EMPLOYEE table
43 EMP_FLAG20 Varchar2 1 From EMPLOYEE table
44 EMP_FULLTIME Varchar2 1 Employee full time flag from EMPLOYEE table
45 Emp_ID Number 10 Employee ID from WORK_SUMMARY table.
46 Wrks_Work_Date Date Work date from WORK_SUMMARY table.
47 Wrks_Start_Time Date Work start time from WORK_SUMMARY table.
48 Wrks_End_Time Date Work end time from WORK_SUMMARY table.
49 Wrks_Manual_Calc Char 1 From WORK_SUMMARY table.
50 Shft_ID Number 10 Shift ID from WORK_SUMMARY table.
51 Paygrp_ID Number 10 Pay group ID from WORK_SUMMARY table.
52 Calcgrp_ID Number 10 Calc group ID from WORK_SUMMARY table.
53 Wrks_Authorized Char 1 Work summary authorized flag from WORK_SUMMARY table.
54 Wrks_Auth_By Varchar2 Work summary authorized person from WORK_SUMMARY table.
55 Wrks_Auth_Date Date Work summary authorized date from WORK_SUMMARY table.
56 Wrks_Flag_Brk Varchar2 1 From WORK_SUMMARY table.
57 Wrks_Flag_Recall Varchar2 1 From WORK_SUMMARY table.
58 Wrks_Flag1 Varchar2 1 From WORK_SUMMARY table.
59 Wrks_Flag2 Varchar2 1 From WORK_SUMMARY table.
60 Wrks_Flag3 Varchar2 1 From WORK_SUMMARY table.
61 Wrks_Flag4 Varchar2 1 From WORK_SUMMARY table.
62 Wrks_Flag5 Varchar2 1 From WORK_SUMMARY table.
63 Wrks_UDF1 Varchar2 40 From WORK_SUMMARY table.
64 Wrks_UDF2 Varchar2 40 From WORK_SUMMARY table.
65 Wrks_UDF3 Varchar2 40 From WORK_SUMMARY table.
66 Wrks_UDF4 Varchar2 40 From WORK_SUMMARY table.
67 Wrks_UDF5 Varchar2 40 From WORK_SUMMARY table.
68 Wrks_UDF6 Varchar2 40 From WORK_SUMMARY table.
69 Wrks_UDF7 Varchar2 40 From WORK_SUMMARY table.
70 Wrks_UDF8 Varchar2 40 From WORK_SUMMARY table.
71 Wrks_UDF9 Varchar2 40 From WORK_SUMMARY table.
72 Wrks_UDF10 Varchar2 40 From WORK_SUMMARY table.
73 Wrks_Dexc Varchar2 100 From WORK_SUMMARY table.
74 Wrks_Clocks Varchar2 4000 From WORK_SUMMARY table.
75 Wrkd_Start_Time Date Work start time from WORK_DETAIL table.
76 Wrkd_End_Time Date From WORK_DETAIL table.
77 Wrkd_Minutes* Number 10 From WORK_DETAIL table.
78 Wrkd_Rate* Number 20,5 From WORK_DETAIL table.
79 Wrkd_Work_Date* Date From WORK_DETAIL table.
80 Dock_ID Number 10 From WORK_DETAIL table.
81 Htype_ID Number 10 From WORK_DETAIL table.
82 Job_ID Number 10 From WORK_DETAIL table.
83 Tcode_ID Number 10 From WORK_DETAIL table.
84 Proj_ID Number 10 From WORK_DETAIL table.
85 Wrkd_Quantity Number 20,10 From WORK_DETAIL table.
86 Wrkd_Type Varchar2 1 From WORK_DETAIL table.
87 Wrkd_Flag1 Varchar2 1 From WORK_DETAIL table.
88 Wrkd_Flag2 Varchar2 1 From WORK_DETAIL table.
89 Wrkd_Flag Varchar2 1 From WORK_DETAIL table.
90 Wrkd_Flag4 Varchar2 1 From WORK_DETAIL table.
91 Wrkd_Flag5 Varchar2 1 From WORK_DETAIL table.
92 Wrkd_Flag5 Varchar2 1 From WORK_DETAIL table.
93 Wrkd_Flag6 Varchar2 1 From WORK_DETAIL table.
94 Wrkd_Flag7 Varchar2 1 From WORK_DETAIL table.
95 Wrkd_Flag8 Varchar2 1 From WORK_DETAIL table.
96 Wrkd_Flag9 Varchar2 1 From WORK_DETAIL table.
97 Wrkd_Flag10 Varchar2 1 From WORK_DETAIL table.
98 Dept_ID Number 10 From WORK_DETAIL table.
99 Wrkd_UDF1 Varchar2 40 From WORK_DETAIL table.
100 Wrkd_UDF2 Varchar2 40 From WORK_DETAIL table.
101 Wrkd_UDF3 Varchar2 40 From WORK_DETAIL table.
102 Wrkd_UDF4 Varchar2 40 From WORK_DETAIL table.
103 Wrkd_UDF5 Varchar2 40 From WORK_DETAIL table.
104 Wrkd_UDF6 Varchar2 40 From WORK_DETAIL table.
105 Wrkd_UDF7 Varchar2 40 From WORK_DETAIL table.
106 Wrkd_UDF8 Varchar2 40 From WORK_DETAIL table.
107 Wrkd_UDF9 Varchar2 40 From WORK_DETAIL table.
108 Wrkd_UDF10 Varchar2 40 From WORK_DETAIL table.
109 Retro Varchar2 1 Not in table. 'N' indicates that this is the current view.
110 ACCTU_LABEL Varchar2 40 From WORK_DETAIL table.
111 ACCTU_DESC Varchar2 40 From WORK_DETAIL table.
112 ACCTP_LABEL Varchar2 40 From WORK_DETAIL table.
113 ACCTP_DESC Varchar2 40 From WORK_DETAIL table.
114 ACCTA_LABEL Varchar2 40 From WORK_DETAIL table.
115 ACCTA_DESC Varchar2 40 From WORK_DETAIL table.
116 DIMENSION1_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
117 DIMENSION1_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
118 DIMENSION2_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
119 DIMENSION2_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
120 DIMENSION3_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
121 DIMENSION3_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
122 DIMENSION4_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
123 DIMENSION4_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
124 DIMENSION5_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
125 DIMENSION5_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
126 DIMENSION6_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
127 DIMENSION6_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
128 DIMENSION7_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
129 DIMENSION7_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
130 DIMENSION8_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
131 DIMENSION8_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
132 DIMENSION9_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
133 DIMENSION9_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.
134 DIMENSION10_ACCTD_LABEL Varchar2 40 From WORK_DETAIL table.
135 DIMENSION10_ACCTD_DESCRIPTION Varchar2 40 From WORK_DETAIL table.