HTERMJH - Terminated Employee Job (TERMJH) Database

HTERMJH field information

 
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