HRSECJOB

Employee Secondary Job (SJ) Database

Seq Field Name Type Length Dec Description

1

S_CHADATE

T

8

0

Last Change Date

2

S_COMPANY

C

3

0

Company Code

3

S_COMPARAT

N

6

2

Compa Ratio

4

S_CURRENCY

C

3

0

Currency Type (USD/CAD)

5

S_EFFDATE

T

8

0

Effective Date

6

S_EMPNO

C

9

0

Employee ID

7

S_EXPDATE

T

8

0

Expiration Date

8

S_ILLIND

C

1

0

Method of Illness Accrual

9

S_ILLRATE

N

9

5

Illness Accrual Rate

10

S_JOBCODE

C

8

0

Employee Job Code

11

S_JOBTITLE

C

25

0

Job Title

12

S_LABORIND

C

1

0

Direct/Indirect Labor Indicator

13

S_PERIND

C

1

0

Method of Personal Accrual

14

S_PERIOD

C

1

0

Period Code

15

S_PERRATE

N

9

5

Personal Accrual Rate

16

S_SALARY

N

16

5

Salary

17

S_SALGRADE

C

6

0

Salary Grade Code

18

S_VACIND

C

1

0

Method of Vacation Accrual

19

S_VACRATE

N

9

5

Vacation Accrual Rate

20

S_WORKCOMP

C

5

0

Workers Compensation Code

21

_JOBCODE

C

25

0

Job Code Description

22

_PERIOD

C

25

0

Period

23

_SALGRADE

C

25

0

Salary Grade

24

_WORKCOMP

C

25

0

Workers Compensation Code Description

25

_ZFILTER

C

25

0

Filter Function