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 |