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_ID | Number | 10 | Employee ID from WORK_SUMMARY table. |
25 | Wrks_Work_Date | Date | Work date from WORK_SUMMARY table. | |
26 | Wrks_Start_Time | Date | Work start time from WORK_SUMMARY table. | |
27 | Wrks_End_Time | Date | Work end time from WORK_SUMMARY table. | |
28 | Wrks_Manual_Calc | Char | 1 | From WORK_SUMMARY table. |
29 | Shft_ID | Number | 10 | Shift ID from WORK_SUMMARY table. |
30 | Paygrp_ID | Number | 10 | Pay group ID from WORK_SUMMARY table. |
31 | Calcgrp_ID | Number | 10 | Calc group ID from WORK_SUMMARY table. |
32 | Wrks_Authorized | Char | 1 | Work summary authorized flag from WORK_SUMMARY table. |
33 | Wrks_Auth_By | Varchar2 | Work summary authorized person from WORK_SUMMARY table. | |
34 | Wrks_Auth_Date | Date | Work summary authorized date from WORK_SUMMARY table. | |
35 | Wrks_Flag_Brk | Varchar2 | 1 | From WORK_SUMMARY table. |
36 | Wrks_Flag_Recall | Varchar2 | 1 | From WORK_SUMMARY table. |
37 | Wrks_Flag1 | Varchar2 | 1 | From WORK_SUMMARY table. |
38 | Wrks_Flag2 | Varchar2 | 1 | From WORK_SUMMARY table. |
39 | Wrks_Flag3 | Varchar2 | 1 | From WORK_SUMMARY table. |
40 | Wrks_Flag4 | Varchar2 | 1 | From WORK_SUMMARY table. |
41 | Wrks_Flag5 | Varchar2 | 1 | From WORK_SUMMARY table. |
42 | Wrks_UDF1 | Varchar2 | 40 | From WORK_SUMMARY table. |
43 | Wrks_UDF2 | Varchar2 | 40 | From WORK_SUMMARY table. |
44 | Wrks_UDF3 | Varchar2 | 40 | From WORK_SUMMARY table. |
45 | Wrks_UDF4 | Varchar2 | 40 | From WORK_SUMMARY table. |
46 | Wrks_UDF5 | Varchar2 | 40 | From WORK_SUMMARY table. |
47 | Wrks_UDF6 | Varchar2 | 40 | From WORK_SUMMARY table. |
48 | Wrks_UDF7 | Varchar2 | 40 | From WORK_SUMMARY table. |
49 | Wrks_UDF8 | Varchar2 | 40 | From WORK_SUMMARY table. |
50 | Wrks_UDF9 | Varchar2 | 40 | From WORK_SUMMARY table. |
51 | Wrks_UDF10 | Varchar2 | 40 | From WORK_SUMMARY table. |
52 | Wrks_Dexc | Varchar2 | 100 | From WORK_SUMMARY table. |
53 | Wrks_Clocks | Varchar2 | 4000 | From WORK_SUMMARY table. |
54 | Wrkd_Start_Time | Date | Work start time from WORK_DETAIL table. | |
55 | Wrkd_End_Time | Date | From WORK_DETAIL table. | |
56 | Wrkd_Minutes* | Number | 10 | From WORK_DETAIL table. |
57 | Wrkd_Rate* | Number | 20,5 | From WORK_DETAIL table. |
58 | Wrkd_Work_Date* | Date | From WORK_DETAIL 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_Quantity | 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. 'N' indicates that this is the current view. |