BEN_OE_ENR_HIST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
4	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
5	STATUS_DT	Date(10)	DATE	Status Date
6	BAS_PROCESS_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Status AE=Program Elig Assign Error AN=Program Elig Assign None AS=Program Elig Assigned EE=Election Error ET=Entered FA=Finalized - Benefit Pgm None FE=Finalized - Enrolled FP=Finalized - Prepared None NT=Notified PE=Prepare Error PR=Prepared RE=Re-Enter
7	EVENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Event Status C=Closed to Processing D=Disconnected from Job Record O=Open for Processing V=Void
8	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
10	JOB_EFFDT	Date(10)	DATE	Job Effective Date
11	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
12	BAS_EVT_DISCONNECT	Character(1)	VARCHAR2(1) NOT NULL	Event Disconnected
13	ALLOW_SELF_SERVICE	Character(1)	VARCHAR2(1) NOT NULL	Available through Self Service N=No Self Service X=Event Created Prior to HCM 7.5 Y=Self Service Allowed
14	NUM_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of Days Default Value: 1