JBCMP_CUR_MC_VW (SQL View)	Index Back
Current Job Per A Mass Change View of the Job record as of a Mass Change Effective Date. This is used for the Mass Change templates for current job data. JOB is one of the ore records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create Multiple JOB records for an employee.

JBCMP_CUR_MC_VW

(SQL View)

Current Job Per A Mass Change

View of the Job record as of a Mass Change Effective Date. This is used for the Mass Change templates for current job data. JOB is one of the ore records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create Multiple JOB records for an employee.

SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,C.COMP_EFFSEQ ,C.COMP_RATECD ,B.MC_DEFN_ID ,C.COMP_RATE_POINTS ,C.COMPRATE ,C.COMP_PCT ,%Substring(C.COMP_FREQUENCY,1,1) ,C.CURRENCY_CD ,C.MANUAL_SW ,C.CONVERT_COMPRT ,C.RATE_CODE_GROUP ,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.SHIFT ,A.REG_TEMP ,A.FULL_PART_TIME ,A.FLSA_STATUS ,A.OFFICER_CD ,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.STD_HRS_FREQUENCY ,A.EEO_CLASS ,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.COMP_FREQUENCY ,A.COMPRATE ,A.CHANGE_AMT ,A.CHANGE_PCT ,A.ANNUAL_RT ,A.MONTHLY_RT ,A.DAILY_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.FUNCTION_CD ,A.HOURLY_RT_FRA ,A.ACCDNT_CD_FRA ,A.ESTABID ,A.REG_REGION ,A.DIRECTLY_TIPPED ,A.PAY_SYSTEM_FLG ,A.BENEFIT_SYSTEM ,A.SUPV_LVL_ID FROM PS_JOB A , PS_MC_DEFN_HR B , PS_COMPENSATION C WHERE A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.EFFDT = ( SELECT MAX (J.EFFDT) FROM PS_JOB J WHERE J.EMPLID = A.EMPLID AND J.EMPL_RCD = A.EMPL_RCD AND J.EFFDT <= B.ASOFDATE ) AND A.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = A.EMPLID AND J2.EMPL_RCD = A.EMPL_RCD AND J2.EFFDT = A.EFFDT ) AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_COMPENSATION C1 WHERE C1.EMPLID = A.EMPLID AND C1.EMPL_RCD = A.EMPL_RCD AND C1.EFFDT <= A.EFFDT ) AND C.EFFSEQ = ( SELECT MAX(C2.EFFSEQ) FROM PS_COMPENSATION C2 WHERE C2.EMPLID = C.EMPLID AND C2.EMPL_RCD = C.EMPL_RCD AND C2.EFFDT = C.EFFDT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW
Prompt Table: PERSON

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

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

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

5 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence

6 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

7 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition

8 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points

9 COMP_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

10 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent

11 COMP_CMP_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Compensation Frequency

12 COMP_CURR_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

13 MANUAL_SW Character(1) VARCHAR2(1) NOT NULL Manual Switch

14 CONVERT_COMPRT Number(19,6) DECIMAL(18,6) NOT NULL Converted Comp Rate

15 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

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

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

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

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

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

21 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
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

22 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Default Value: HIR
Prompt Table: ACTION_TBL

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

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

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

26 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code

27 JOB_ENTRY_DT Date(10) DATE Job Entry Date

28 DEPT_ENTRY_DT Date(10) DATE Department Entry Date

29 POSITION_ENTRY_DT Date(10) DATE Position Entry Date

30 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
Default Value: N

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

32 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
Default Value: F

33 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required

34 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

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

36 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

37 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.

38 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.

39 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.

40 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.

41 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.

42 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.

43 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.

44 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.

45 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.

46 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.

47 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

48 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.

49 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.

50 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
Prompt Table: PAYGRP_EMPLTYPE

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

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

53 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

54 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

55 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
Prompt Table: EMPL_CLASS_TBL
Set Control Field: REG_REGION

56 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
Prompt Table: SAL_PLAN_TBL

57 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
Prompt Table: SAL_GRADE_TBL

58 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date

59 STEP Number(2,0) SMALLINT NOT NULL Step
Prompt Table: SAL_STEP_TBL

60 STEP_ENTRY_DT Date(10) DATE Step Entry Date

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

62 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
Prompt Table: ACCT_CD_TBL

63 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

64 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
Prompt Table: COMP_FREQ_VW

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

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

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

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

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

70 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate

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

72 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.

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

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

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

76 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_HR

77 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
Default Value: OPR_DEF_TBL_HR.SETID

78 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
Default Value: OPR_DEF_TBL_HR.SETID

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

80 HOURLY_RT_FRA Character(3) VARCHAR2(3) NOT NULL HFR

81 ACCDNT_CD_FRA Character(1) VARCHAR2(1) NOT NULL HFR
0=Do not Pay
1=Building
2=Waterproofing
3=Floor Surface
4=Factory Making
5=Laboratory
6=WorkShop
7=Office

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

83 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Prompt Table: REG_STANDARD_VW

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

85 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface

86 BENEFIT_SYSTEM Character(2) VARCHAR2(2) NOT NULL A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits.
BA=Benefits Administration
BN=Base Benefits
OT=Not Managed in PeopleSoft

87 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system
Prompt Table: SUPVSR_LVL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
6	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
7	MC_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Mass Change Definition
8	COMP_RATE_POINTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
9	COMP_COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
10	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
11	COMP_CMP_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Compensation Frequency
12	COMP_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	MANUAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Manual Switch
14	CONVERT_COMPRT	Number(19,6)	DECIMAL(18,6) NOT NULL	Converted Comp Rate
15	RATE_CODE_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
16	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
17	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
18	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
19	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data Y/N Table Edit Default Value: N
20	POSN_CHANGE_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Position Management Record Y/N Table Edit Default Value: N
21	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased 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
22	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Default Value: HIR Prompt Table: ACTION_TBL
23	ACTION_DT	Date(10)	DATE	Action Date Default Value: %date
24	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
25	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
26	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code
27	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
28	DEPT_ENTRY_DT	Date(10)	DATE	Department Entry Date
29	POSITION_ENTRY_DT	Date(10)	DATE	Position Entry Date
30	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating Default Value: N
31	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary Default Value: R
32	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time Default Value: F
33	FLSA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FLSA Status A=Administrative C=Computer Employee E=Executive H=Highly Compensated Employees M=Management N=Nonexempt O=Outside Salesperson P=Professional V=Nonexempt Alt Overtime X=No FLSA Required
34	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
35	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
36	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
37	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.
38	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.
39	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.
40	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.
41	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.
42	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.
43	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.
44	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.
45	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.
46	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.
47	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
48	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.
49	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.
50	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried Prompt Table: PAYGRP_EMPLTYPE
51	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule Prompt Table: HOLIDAY_TBL
52	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
53	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
54	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
55	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification Prompt Table: EMPL_CLASS_TBL Set Control Field: REG_REGION
56	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: SAL_PLAN_TBL
57	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Prompt Table: SAL_GRADE_TBL
58	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date
59	STEP	Number(2,0)	SMALLINT NOT NULL	Step Prompt Table: SAL_STEP_TBL
60	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
61	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
62	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: ACCT_CD_TBL
63	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
64	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 Prompt Table: COMP_FREQ_VW
65	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
66	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
67	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
68	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
69	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
70	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
71	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
72	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.
73	SHIFT_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Shift Differential Rate
74	SHIFT_FACTOR	Number(5,3)	DECIMAL(4,3) NOT NULL	Shift Differential Factor
75	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
76	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR
77	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID Default Value: OPR_DEF_TBL_HR.SETID
78	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID Default Value: OPR_DEF_TBL_HR.SETID
79	FUNCTION_CD	Character(2)	VARCHAR2(2) NOT NULL	Function Code
80	HOURLY_RT_FRA	Character(3)	VARCHAR2(3) NOT NULL	HFR
81	ACCDNT_CD_FRA	Character(1)	VARCHAR2(1) NOT NULL	HFR 0=Do not Pay 1=Building 2=Waterproofing 3=Floor Surface 4=Factory Making 5=Laboratory 6=WorkShop 7=Office
82	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
83	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_STANDARD_VW
84	DIRECTLY_TIPPED	Character(1)	VARCHAR2(1) NOT NULL	Tipped D=Directly Tipped I=Indirectly Tipped N=Not Tipped
85	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface
86	BENEFIT_SYSTEM	Character(2)	VARCHAR2(2) NOT NULL	A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits. BA=Benefits Administration BN=Base Benefits OT=Not Managed in PeopleSoft
87	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system Prompt Table: SUPVSR_LVL_TBL