BAS_PARTIC_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	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.
6	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
7	ADDR_EFFDT	Date(10)	DATE	Address Effective Date
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	JOB_EFFDT	Date(10)	DATE NOT NULL	Job Effective Date
10	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
11	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
12	EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Event Classification
13	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 Default Value: C
14	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
15	PROCESS_IND	Character(1)	VARCHAR2(1) NOT NULL	Process Indicator A=Assign Benefit Program E=Elect Options N=Normal Processing P=Prepare Options R=Re-Enter V=Void Default Value: N
16	ADDR_ELIG_CHG	Character(1)	VARCHAR2(1) NOT NULL	Address Eligibility Changed Y/N Table Edit Default Value: N
17	MJ_ELIG_CHG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate that a change to the Primary_Jobs table was detected for this employee, which may have an impact on eligibility already processed for this event. Y/N Table Edit Default Value: N
18	JOB_ELIG_CHG	Character(1)	VARCHAR2(1) NOT NULL	Job Eligibility Changed Y/N Table Edit Default Value: N
19	BAS_EVT_DISCONNECT	Character(1)	VARCHAR2(1) NOT NULL	Event Disconnected Y/N Table Edit Default Value: N
20	BAS_EVENT_CHG	Character(1)	VARCHAR2(1) NOT NULL	Event Out of Sequence Y/N Table Edit Default Value: N
21	ADDR_ELIG_CHG_DT	Date(10)	DATE	Address Elig Changed Date
22	MJ_ELIG_CHG_DT	Date(10)	DATE	The date that the MJ_ELIG_CHG field was set to 'Y'.
23	JOB_ELIG_CHG_DT	Date(10)	DATE	Job Elig Changed Date
24	BAS_EVT_DISC_DT	Date(10)	DATE	Event Disconnect Date
25	BAS_EVENT_CHG_DT	Date(10)	DATE	Event Changed Date
26	FINALIZE_ENROLL	Character(1)	VARCHAR2(1) NOT NULL	Finalize/Apply Defaults Y/N Table Edit Default Value: N
27	CREDIT_ROLLOVER	Character(1)	VARCHAR2(1) NOT NULL	Excess Credit Rollover To C=Cash D=FSA - Dependent Care F=Forfeit Excess Credits H=FSA - Health Care R=FSA - Retirement Counseling S=Savings - 401K Plan Default Value: C
28	ELECT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Election Source N=None Entered O=Online V=Voice Response W=Web Default Value: O
29	EVENT_EMPLRCD	Number(3,0)	SMALLINT NOT NULL	Event Empl Record
30	EVENT_DT	Date(10)	DATE NOT NULL	Event Date
31	EVENT_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence of Event
32	EVENT_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Event Priority
33	BAS_ACTION_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Source of Action BP=Benefits Person EX=Multijob Trigger Explosion ME=Manual Event MJ=MultiJob Indicator Change OE=Open Enrollment PB=Passive Event Birthdate PS=Passive Event Service Date SN=Snapshot TJ=Job Data Change TL=Union Change TP=Address Change
34	MULTI_ACTIVITY_IND	Character(1)	VARCHAR2(1) NOT NULL	Multi-Activity Indicator Y/N Table Edit Default Value: N
35	STATUS_DT	Date(10)	DATE NOT NULL	Status Date
36	OPTION_NOTIFY_DT	Date(10)	DATE	Date Notified of Options
37	ELECT_RCVD_DT	Date(10)	DATE	Elections Received Date
38	CONFIRM_NOTIFY_DT	Date(10)	DATE	Date Notified of Confirmation
39	CONFIRM_RCVD_DT	Date(10)	DATE	Confirmation Received Date
40	SERVICE_DT	Date(10)	DATE	Service Date
41	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.
42	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 Default Value: N
43	GVT_HIRE_DATE	Date(10)	DATE	Hire Date
44	GVT_SCD_TSP	Date(10)	DATE	Service Comp Date - TSP
45	BAS_SUPPRESS_FORMS	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether or not enrollment and/or confirmation forms should be printed or suppressed for an event. This flag can be set at the event rule level or at the employee/event level. B=Print Both Forms C=Print Confirmation Forms Only E=Print Enrollment Forms Only S=Suppress Print of Both Forms
46	BAS_ENR_FORMS_DAYS	Number(3,0)	SMALLINT NOT NULL	This field indicates how many days prior to an event an enrollment form should be printed.