BAS_PAR_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID Prompt Table: BAS_SCHED
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
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	ADDR_EFFDT	Date(10)	DATE	Address Effective Date
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
7	JOB_EFFDT	Date(10)	DATE NOT NULL	Job Effective Date
8	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
9	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules. Prompt Table: BEN_DEFN_PGM
10	EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Event Classification Prompt Table: BAS_EVT_CLASS
11	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
12	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
13	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
14	ADDR_ELIG_CHG	Character(1)	VARCHAR2(1) NOT NULL	Address Eligibility Changed Y/N Table Edit Default Value: N
15	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.
16	JOB_ELIG_CHG	Character(1)	VARCHAR2(1) NOT NULL	Job Eligibility Changed Y/N Table Edit Default Value: N
17	BAS_EVT_DISCONNECT	Character(1)	VARCHAR2(1) NOT NULL	Event Disconnected Y/N Table Edit Default Value: N
18	BAS_EVENT_CHG	Character(1)	VARCHAR2(1) NOT NULL	Event Out of Sequence Y/N Table Edit Default Value: N
19	ADDR_ELIG_CHG_DT	Date(10)	DATE	Address Elig Changed Date
20	MJ_ELIG_CHG_DT	Date(10)	DATE	The date that the MJ_ELIG_CHG field was set to 'Y'.
21	JOB_ELIG_CHG_DT	Date(10)	DATE	Job Elig Changed Date
22	BAS_EVT_DISC_DT	Date(10)	DATE	Event Disconnect Date
23	BAS_EVENT_CHG_DT	Date(10)	DATE	Event Changed Date
24	FINALIZE_ENROLL	Character(1)	VARCHAR2(1) NOT NULL	Finalize/Apply Defaults Y/N Table Edit
25	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
26	ELECT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Election Source N=None Entered O=Online V=Voice Response W=Web
27	EVENT_EMPLRCD	Number(3,0)	SMALLINT NOT NULL	Event Empl Rcd#
28	EVENT_DT	Date(10)	DATE NOT NULL	Event Date
29	EVENT_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence of Event
30	EVENT_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Event Priority
31	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
32	MULTI_ACTIVITY_IND	Character(1)	VARCHAR2(1) NOT NULL	Multi-Activity Indicator Y/N Table Edit Default Value: N
33	STATUS_DT	Date(10)	DATE NOT NULL	Status Date
34	OPTION_NOTIFY_DT	Date(10)	DATE	Date Notified of Options
35	ELECT_RCVD_DT	Date(10)	DATE	Elections Received Date
36	CONFIRM_NOTIFY_DT	Date(10)	DATE	Date Notified of Confirmation
37	CONFIRM_RCVD_DT	Date(10)	DATE	Confirmation Received Date
38	SERVICE_DT	Date(10)	DATE	Service Date
39	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.
40	ALLOW_SELF_SERVICE	Character(1)	VARCHAR2(1) NOT NULL	Available through Self Service N=No Self Service X=Event Created Prior to HRMS7.5 Y=Self Service Allowed Y/N Table Edit
41	EFFDT	Date(10)	DATE NOT NULL	Effective Date
42	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
43	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.