HPREV - Employee Previous Employment (PV) Database
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
V_CHADATE |
T |
8 |
0 |
Last Change Date |
2 |
V_COMPANY |
C |
3 |
0 |
Company Identifier |
3 |
V_CURRENCY |
C |
3 |
0 |
Currency Type (USD/CAD) |
4 |
V_EMPNAME |
C |
20 |
0 |
Previous Employer Name |
5 |
V_EMPNO |
C |
9 |
0 |
Employee ID |
6 |
V_FROM |
T |
8 |
0 |
Job Start Date |
7 |
V_PERIOD |
C |
5 |
0 |
Pay Frequency Code |
8 |
V_SALARY |
N |
10 |
2 |
Salary |
9 |
V_TITLE |
C |
20 |
0 |
Job Title |
10 |
V_TO |
T |
8 |
0 |
Job End Date |
11 |
_PERIOD |
C |
1 |
0 |
Pay Frequency Description |
12 |
_ZFILTER |
C |
25 |
0 |
Filter Function |