HTERMJH - Terminated Employee Job (TERMJH) Database
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 |
Supervisor Company (formerly "Secondary Supervisor Company ") |
45 |
J_SUP2NO |
C |
25 |
0 |
Supervisor ID Number (formerly "Secondary Supervisor ID Number") |
46 |
J_SUP2VIS |
C |
25 |
0 |
Supervisor Name (formerly "Secondary Supervisor Name ") |
47 |
J_SUPERCO |
C |
3 |
0 |
Manager Company (formerly "Supervisor Company ") |
48 |
J_SUPERNO |
C |
9 |
0 |
Manager ID Number (formerly "Supervisor ID Number") |
49 |
J_SUPERVIS |
C |
25 |
0 |
Manager Name (formerly "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 |