GM_JOB_VW (SQL View)	Index Back
EE Job History View Grants Management - Professionals profile. This view of the JOB record is used to select one of the multiple job records for an employee.

GM_JOB_VW

(SQL View)

EE Job History View

Grants Management - Professionals profile. This view of the JOB record is used to select one of the multiple job records for an employee.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.DEPTID , A.JOBCODE , A.POSITION_NBR , A.POSITION_OVERRIDE , A.POSN_CHANGE_RECORD , A.EMPL_STATUS , A.ACTION , A.ACTION_DT , A.ACTION_REASON , A.LOCATION , A.TAX_LOCATION_CD , A.JOB_ENTRY_DT , A.DEPT_ENTRY_DT , A.POSITION_ENTRY_DT , A.REG_TEMP , A.FULL_PART_TIME , A.COMPANY , A.PAYGROUP , A.BAS_GROUP_ID , A.ELIG_CONFIG1 , A.ELIG_CONFIG2 , A.ELIG_CONFIG3 , A.ELIG_CONFIG4 , A.ELIG_CONFIG5 , A.ELIG_CONFIG6 , A.ELIG_CONFIG7 , A.ELIG_CONFIG8 , A.ELIG_CONFIG9 , A.BEN_STATUS , A.BAS_ACTION , A.COBRA_ACTION , A.EMPL_TYPE , A.HOLIDAY_SCHEDULE , A.STD_HOURS , A.OFFICER_CD , A.EMPL_CLASS , A.SAL_ADMIN_PLAN , A.GRADE , A.GRADE_ENTRY_DT , A.STEP , A.STEP_ENTRY_DT , A.GL_PAY_TYPE , A.ACCT_CD , A.EARNS_DIST_TYPE , A.SALARY_MATRIX_CD , A.RATING_SCALE , A.REVIEW_RATING , A.REVIEW_DT , A.COMP_FREQUENCY , A.COMPRATE , A.CHANGE_AMT , A.CHANGE_PCT , A.ANNUAL_RT , A.MONTHLY_RT , A.HOURLY_RT , A.ANNL_BENEF_BASE_RT , A.SHIFT_RT , A.SHIFT_FACTOR , A.CURRENCY_CD , A.BUSINESS_UNIT , A.SETID_DEPT , A.SETID_JOBCODE , A.REG_REGION , A.DIRECTLY_TIPPED , %subrec(JOB_USA_SBR,A) , %subrec(JOB_GER_SBR,A) , %subrec(JOB_FRA_SBR,A) , A.ADDS_TO_FTE_ACTUAL , A.CLASS_INDC , A.ENCUMB_OVERRIDE , A.FICA_STATUS_EE , A.FTE , A.PRORATE_CNT_AMT FROM PS_JOB A WHERE Effdt=( SELECT MAX(effdt) FROM PS_JOB WHERE emplid=A.emplid AND EMPL_RCD=A.EMPL_RCD) AND effseq=( SELECT MAX(effseq) FROM PS_JOB WHERE emplid=A.emplid AND EMPL_RCD=A.EMPL_RCD AND effdt=A.effdt)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: JOBCODE_TBL

7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

8 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Position Data Override
Y/N Table Edit
Default Value: N

9 POSN_CHANGE_RECORD Character(1) VARCHAR2(1) NOT NULL Position Management Record
Y/N Table Edit
Default Value: N

10 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Employee Status
A=Active
D=Deceased
I=Inactive
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
Default Value: A

11 ACTION Character(3) VARCHAR2(3) NOT NULL Action

12 ACTION_DT Date(10) DATE Action Date
Default Value: %date

13 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
Prompt Table: ACTN_REASON_TBL

14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: LOCATION_TBL

15 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
Prompt Table: %RECNAME_EDIT

16 JOB_ENTRY_DT Date(10) DATE Job Entry Date

17 DEPT_ENTRY_DT Date(10) DATE Department Entry Date

18 POSITION_ENTRY_DT Date(10) DATE Position Entry Date

19 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
Default Value: R

20 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
F=Full-Time
P=Part-Time
Default Value: F

21 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

22 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

23 BAS_GROUP_ID Character(3) VARCHAR2(3) NOT NULL Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program.

24 ELIG_CONFIG1 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

25 ELIG_CONFIG2 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

26 ELIG_CONFIG3 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

27 ELIG_CONFIG4 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

28 ELIG_CONFIG5 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

29 ELIG_CONFIG6 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

30 ELIG_CONFIG7 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

31 ELIG_CONFIG8 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

32 ELIG_CONFIG9 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.

33 BEN_STATUS Character(4) VARCHAR2(4) NOT NULL Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated.
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Benefits
Q=Retired With Benefits
R=Retired
S=Suspended
T=Terminated
U=Terminated With Benefits

34 BAS_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.

35 COBRA_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.

36 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried

37 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
Prompt Table: HOLIDAY_TBL

38 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

39 OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President
Default Value: N

40 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
A=Assignee
C=Consultant
E=Expatriate
G=Agency/Temp
I=Intern
P=Apprentice
R=Contractor
T=Trainee

41 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

42 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

43 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date

44 STEP Number(2,0) SMALLINT NOT NULL Step

45 STEP_ENTRY_DT Date(10) DATE Step Entry Date

46 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type

47 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Account Code

48 EARNS_DIST_TYPE Character(1) VARCHAR2(1) NOT NULL Earnings Distribution Type
A=By Amount
H=By Hours
N=None
P=By Percent
Default Value: N

49 SALARY_MATRIX_CD Character(5) VARCHAR2(5) NOT NULL Salary Matrix Code

50 RATING_SCALE Character(4) VARCHAR2(4) NOT NULL Rating Scale

51 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

52 REVIEW_DT Date(10) DATE Review Date

53 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly

54 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

55 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount

56 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent

57 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate

58 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate

59 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate

60 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.

61 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate

62 SHIFT_FACTOR Number(5,3) DECIMAL(4,3) NOT NULL Shift Differential Factor

63 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

64 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

65 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

66 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID

67 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

68 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped

69 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
A=Administrative
E=Executive
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
X=No FLSA Required
Default Value: X

70 EEO_CLASS Character(1) VARCHAR2(1) NOT NULL EEO Classification
E=Exclude from Count
N=None of the Above
P=Production Trainee
W=White-Collar Trainee
Default Value: N

71 FUNCTION_CD Character(2) VARCHAR2(2) NOT NULL Function Code

72 TARIFF_GER Character(2) VARCHAR2(2) NOT NULL Tariff

73 TARIFF_AREA_GER Character(3) VARCHAR2(3) NOT NULL Tarif Area

74 PERFORM_GROUP_GER Character(2) VARCHAR2(2) NOT NULL Performance Group

75 LABOR_TYPE_GER Character(1) VARCHAR2(1) NOT NULL Labor Type

76 SPK_COMM_ID_GER Character(9) VARCHAR2(9) NOT NULL Spokesman Committee ID

77 WRKS_CNCL_MEM_GER Character(3) VARCHAR2(3) NOT NULL Works Council Member

78 HOURLY_RT_FRA Character(3) VARCHAR2(3) NOT NULL Hours Type

79 ACCDNT_CD_FRA Character(1) VARCHAR2(1) NOT NULL Work Accident Type Code

80 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

81 VALUE_1_FRA Character(5) VARCHAR2(5) NOT NULL Value 1

82 VALUE_2_FRA Character(5) VARCHAR2(5) NOT NULL Value 2

83 VALUE_3_FRA Character(5) VARCHAR2(5) NOT NULL Value 3

84 VALUE_4_FRA Character(5) VARCHAR2(5) NOT NULL Value 4

85 VALUE_5_FRA Character(5) VARCHAR2(5) NOT NULL Value 5

86 CTG_RATE Number(3,0) SMALLINT NOT NULL Category Rate

87 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours

88 PAID_FTE Number(4,2) DECIMAL(3,2) NOT NULL This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field.

89 PAID_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Paid Work Period
Prompt Table: STDHRS_FREQ_VW

90 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count
Y/N Table Edit
Default Value: N

91 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified/Unclassified Indc
B=All
C=Classified
T=Temporary
U=Unclassified
Default Value: C

92 ENCUMB_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Encumbrance Override
Y/N Table Edit
Default Value: N

93 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
E=Exempt
M=Medicare only
N=Subject
Default Value: N

94 FTE Number(8,6) DECIMAL(7,6) NOT NULL FTE

95 PRORATE_CNT_AMT Character(1) VARCHAR2(1) NOT NULL Prorate Contract Change Amount
C=Prorate Over Contract Period
N=No Proration of Change Amt.
P=Prorate over Payment Period

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
6	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
7	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
8	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Position Data Override Y/N Table Edit Default Value: N
9	POSN_CHANGE_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Position Management Record Y/N Table Edit Default Value: N
10	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Employee Status A=Active D=Deceased I=Inactive L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration Default Value: A
11	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
12	ACTION_DT	Date(10)	DATE	Action Date Default Value: %date
13	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
14	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
15	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code Prompt Table: %RECNAME_EDIT
16	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
17	DEPT_ENTRY_DT	Date(10)	DATE	Department Entry Date
18	POSITION_ENTRY_DT	Date(10)	DATE	Position Entry Date
19	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary Default Value: R
20	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time F=Full-Time P=Part-Time Default Value: F
21	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
22	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
23	BAS_GROUP_ID	Character(3)	VARCHAR2(3) NOT NULL	Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program.
24	ELIG_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
25	ELIG_CONFIG2	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
26	ELIG_CONFIG3	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
27	ELIG_CONFIG4	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
28	ELIG_CONFIG5	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
29	ELIG_CONFIG6	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
30	ELIG_CONFIG7	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
31	ELIG_CONFIG8	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
32	ELIG_CONFIG9	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
33	BEN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated. A=Active D=Deceased L=Leave of Absence P=Leave With Benefits Q=Retired With Benefits R=Retired S=Suspended T=Terminated U=Terminated With Benefits
34	BAS_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
35	COBRA_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
36	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried
37	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule Prompt Table: HOLIDAY_TBL
38	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
39	OFFICER_CD	Character(1)	VARCHAR2(1) NOT NULL	Officer Code C=Chairman D=Director N=None O=Officer P=President S=Secretary T=Treasurer V=Vice President Default Value: N
40	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification A=Assignee C=Consultant E=Expatriate G=Agency/Temp I=Intern P=Apprentice R=Contractor T=Trainee
41	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
42	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
43	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date
44	STEP	Number(2,0)	SMALLINT NOT NULL	Step
45	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
46	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
47	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Account Code
48	EARNS_DIST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Earnings Distribution Type A=By Amount H=By Hours N=None P=By Percent Default Value: N
49	SALARY_MATRIX_CD	Character(5)	VARCHAR2(5) NOT NULL	Salary Matrix Code
50	RATING_SCALE	Character(4)	VARCHAR2(4) NOT NULL	Rating Scale
51	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
52	REVIEW_DT	Date(10)	DATE	Review Date
53	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly
54	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
55	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
56	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
57	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
58	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
59	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
60	ANNL_BENEF_BASE_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
61	SHIFT_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Shift Differential Rate
62	SHIFT_FACTOR	Number(5,3)	DECIMAL(4,3) NOT NULL	Shift Differential Factor
63	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
64	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
65	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
66	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
67	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
68	DIRECTLY_TIPPED	Character(1)	VARCHAR2(1) NOT NULL	Tipped D=Directly Tipped I=Indirectly Tipped N=Not Tipped
69	FLSA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FLSA Status A=Administrative E=Executive M=Management N=Nonexempt O=Outside Salesperson P=Professional X=No FLSA Required Default Value: X
70	EEO_CLASS	Character(1)	VARCHAR2(1) NOT NULL	EEO Classification E=Exclude from Count N=None of the Above P=Production Trainee W=White-Collar Trainee Default Value: N
71	FUNCTION_CD	Character(2)	VARCHAR2(2) NOT NULL	Function Code
72	TARIFF_GER	Character(2)	VARCHAR2(2) NOT NULL	Tariff
73	TARIFF_AREA_GER	Character(3)	VARCHAR2(3) NOT NULL	Tarif Area
74	PERFORM_GROUP_GER	Character(2)	VARCHAR2(2) NOT NULL	Performance Group
75	LABOR_TYPE_GER	Character(1)	VARCHAR2(1) NOT NULL	Labor Type
76	SPK_COMM_ID_GER	Character(9)	VARCHAR2(9) NOT NULL	Spokesman Committee ID
77	WRKS_CNCL_MEM_GER	Character(3)	VARCHAR2(3) NOT NULL	Works Council Member
78	HOURLY_RT_FRA	Character(3)	VARCHAR2(3) NOT NULL	Hours Type
79	ACCDNT_CD_FRA	Character(1)	VARCHAR2(1) NOT NULL	Work Accident Type Code
80	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
81	VALUE_1_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 1
82	VALUE_2_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 2
83	VALUE_3_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 3
84	VALUE_4_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 4
85	VALUE_5_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 5
86	CTG_RATE	Number(3,0)	SMALLINT NOT NULL	Category Rate
87	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
88	PAID_FTE	Number(4,2)	DECIMAL(3,2) NOT NULL	This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field.
89	PAID_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Paid Work Period Prompt Table: STDHRS_FREQ_VW
90	ADDS_TO_FTE_ACTUAL	Character(1)	VARCHAR2(1) NOT NULL	Adds to FTE Actual Count Y/N Table Edit Default Value: N
91	CLASS_INDC	Character(1)	VARCHAR2(1) NOT NULL	Classified/Unclassified Indc B=All C=Classified T=Temporary U=Unclassified Default Value: C
92	ENCUMB_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Override Y/N Table Edit Default Value: N
93	FICA_STATUS_EE	Character(1)	VARCHAR2(1) NOT NULL	FICA Status-Employee E=Exempt M=Medicare only N=Subject Default Value: N
94	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	FTE
95	PRORATE_CNT_AMT	Character(1)	VARCHAR2(1) NOT NULL	Prorate Contract Change Amount C=Prorate Over Contract Period N=No Proration of Change Amt. P=Prorate over Payment Period