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