| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
J_ACTIVE |
C |
1 |
0 |
Active Code (A/T/D/L/N) |
|
2 |
J_ANNUAL |
N |
18 |
5 |
Annual Pay |
|
3 |
J_BONUSAMT |
N |
13 |
2 |
Bonus Amount |
|
4 |
J_CHADATE |
T |
8 |
0 |
Last Change Date |
|
5 |
J_COBRA |
C |
1 |
0 |
COBRA Code (Y/N/P/E/S) |
|
6 |
J_COMPANY |
C |
3 |
0 |
Company Code |
|
7 |
J_CURRENCY |
C |
3 |
0 |
Currency Type (USD/CAD) |
|
8 |
J_EEOCLASS |
C |
6 |
0 |
EEO Classification Code |
|
9 |
J_EEOG |
C |
2 |
0 |
EEOG |
|
10 |
J_EFFDATE |
T |
8 |
0 |
Change Date For Job Data |
|
11 |
J_EMPLOY |
C |
3 |
0 |
Employment Status Code |
|
12 |
J_EMPNO |
C |
9 |
0 |
Employee ID |
|
13 |
J_EXEMPT |
C |
1 |
0 |
Exempt Status Code (Y/N) |
|
14 |
J_FUNCTION |
C |
2 |
0 |
EEO-4 Job Category Function |
|
15 |
J_JMISC1 |
C |
10 |
0 |
Miscellaneous 1 |
|
16 |
J_JMISC2 |
C |
15 |
0 |
Miscellaneous 2 |
|
17 |
J_JMISC3 |
N |
10 |
2 |
Miscellaneous 3 |
|
18 |
J_JMISC4 |
N |
10 |
2 |
Miscellaneous 4 |
|
19 |
J_JOBCLASS |
C |
6 |
0 |
EE Classification Code |
|
20 |
J_JOBCODE |
C |
8 |
0 |
Job Code |
|
21 |
J_JOBDATE |
T |
8 |
0 |
Job Start Date |
|
22 |
J_JOBGROUP |
C |
6 |
0 |
EEO Job Group Code |
|
23 |
J_JOBTITLE |
C |
17 |
0 |
Job Title |
|
24 |
J_LEVEL1 |
C |
12 |
0 |
Division Code |
|
25 |
J_LEVEL2 |
C |
12 |
0 |
Department Code |
|
26 |
J_LEVEL3 |
C |
12 |
0 |
Location Code |
|
27 |
J_LEVEL4 |
C |
12 |
0 |
Not Defined |
|
28 |
J_LEVEL5 |
C |
12 |
0 |
Not Defined |
|
29 |
J_LOCATION |
C |
12 |
0 |
Work Location Code |
|
30 |
J_MAILSTOP |
C |
6 |
0 |
Mail Stop |
|
31 |
J_NORMUNIT |
N |
11 |
5 |
Normal Units |
|
32 |
J_PAYDATE |
T |
8 |
0 |
Pay Effective Date |
|
33 |
J_PAYFREQ |
C |
1 |
0 |
Pay Frequency Code |
|
34 |
J_PERFDATE |
T |
8 |
0 |
Performance Review Date |
|
35 |
J_RATING |
C |
5 |
0 |
Performance Review Rating Code |
|
36 |
J_REASON |
C |
8 |
0 |
Reason Code |
|
37 |
J_REHIRE |
C |
1 |
0 |
Rehire Code (Y/N) |
|
38 |
J_SALARY |
N |
16 |
5 |
Salary |
|
39 |
J_SALGRADE |
C |
6 |
0 |
Salary Grade Code |
|
40 |
J_SALHOUR |
C |
1 |
0 |
Salary or Hourly Code (S/H) |
|
41 |
J_SEASONAL |
C |
1 |
0 |
Seasonal Code (Y/N) |
|
42 |
J_SHIFT |
C |
2 |
0 |
Shift Code |
|
43 |
J_SHIFTPRE |
N |
9 |
4 |
Shift Premium |
|
44 |
J_SUP2CO |
C |
3 |
0 |
Secondary Supervisor Company |
|
45 |
J_SUP2NO |
C |
25 |
0 |
Secondary Supervisor ID Number |
|
46 |
J_SUP2VIS |
C |
25 |
0 |
Secondary Supervisor Name |
|
47 |
J_SUPERCO |
C |
3 |
0 |
Supervisor Company |
|
48 |
J_SUPERNO |
C |
9 |
0 |
Supervisor ID Number |
|
49 |
J_SUPERVIS |
C |
25 |
0 |
Supervisor Name |
|
50 |
J_TERMDATE |
T |
8 |
0 |
Termination Date |
|
51 |
J_TERMREAS |
C |
8 |
0 |
Termination Reason Code |
|
52 |
J_TERMTYPE |
C |
1 |
0 |
Termination Type Code (V/I/U) |
|
53 |
J_UNITRATE |
N |
11 |
5 |
Unit Rate |
|
54 |
_ACTIVE |
C |
25 |
0 |
Employee Status Description |
|
55 |
_AN1000 |
C |
25 |
0 |
Annual Pay Rounded to Thousand |
|
56 |
_ANNUAL |
C |
25 |
0 |
Employee's Annual Pay |
|
57 |
_COBRA |
C |
25 |
0 |
COBRA (Yes/No/Pending/etc) |
|
58 |
_EEOCLASS |
C |
25 |
0 |
EEO Classification |
|
59 |
_EMPLOY |
C |
25 |
0 |
Employee Type Description |
|
60 |
_EXEMPT |
C |
25 |
0 |
Exempt Status (Exempt/Non-Exempt) |
|
61 |
_JOBCODE |
C |
25 |
0 |
Job Code Description |
|
62 |
_JOBGROUP |
C |
25 |
0 |
EEO Job Group |
|
63 |
_LEVEL1 |
C |
25 |
0 |
Division |
|
64 |
_LEVEL2 |
C |
25 |
0 |
Department |
|
65 |
_LEVEL3 |
C |
25 |
0 |
Location |
|
66 |
_LEVEL4 |
C |
25 |
0 |
Not Defined |
|
67 |
_LEVEL5 |
C |
25 |
0 |
Not Defined |
|
68 |
_LOCATION |
C |
25 |
0 |
Work Location |
|
69 |
_PAYFREQ |
C |
25 |
0 |
Pay Frequency |
|
70 |
_RATING |
C |
25 |
0 |
Performance Review Rating |
|
71 |
_REASON |
C |
25 |
0 |
Reason |
|
72 |
_REHIRE |
C |
3 |
0 |
Rehire (Yes/No) |
|
73 |
_SALGRADE |
C |
25 |
0 |
Salary Grade |
|
74 |
_SALHOUR |
C |
25 |
0 |
Salary or Hourly |
|
75 |
_SEASONAL |
C |
3 |
0 |
Seasonal Worker (Yes/No) |
|
76 |
_SHIFT |
C |
25 |
0 |
Shift |
|
77 |
_TERMREAS |
C |
25 |
0 |
Termination Reason |
|
78 |
_ZFILTER |
C |
25 |
0 |
Filter Function |