BAS_EVENT_CLASS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EVENT_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Event Rules ID Prompt Table: BAS_EVENT_RULES
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Event Classification Prompt Table: BAS_EVT_CLASS
4	PROOF_CHG_LVL	Number(2,0)	SMALLINT NOT NULL	Change Levels Until Proof Req
5	ELIG_CHG_LVL	Number(2,0)	SMALLINT NOT NULL	Eligibility Change Levels
6	PROOF_START_LVL	Number(2,0)	SMALLINT NOT NULL	Proof Start at Level Default Value: 99
7	PROOF_START_FLT	Number(8,0)	INTEGER NOT NULL	Proof Start at Flat Amount Default Value: 99999999
8	WV_ELIG_CHG_LVL	Number(2,0)	SMALLINT NOT NULL	Waive Eligibilit Change Levels
9	WV_PROOF_START_LVL	Number(2,0)	SMALLINT NOT NULL	Waive Proof Start Level Default Value: 99
10	WV_PROOF_START_FLT	Number(8,0)	INTEGER NOT NULL	Waive Proof Start Flat Amount Default Value: 99999999
11	PRE_ENTER	Character(1)	VARCHAR2(1) NOT NULL	Pre-enter Y/N Table Edit Default Value: N
12	USE_HISTORY	Character(1)	VARCHAR2(1) NOT NULL	Use History Y/N Table Edit Default Value: N
13	SELECT_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Select Allowed A=All Plans C=Current Plan D=Current Plan + Waive N=None Default Value: A
14	ELECT_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Elect Required Y/N Table Edit Default Value: N
15	COVERAGE_BEGINS_CD	Character(1)	VARCHAR2(1) NOT NULL	Coverage Begins Code A=Month-Begin After Event Dt E=On the Event Date M=Month-Begin On/Aft Event Dt P=On Pay Pd Begin after Event Dt Default Value: E
16	WAIT_PERIOD_DD	Number(3,0)	SMALLINT NOT NULL	Wait Period Days
17	WAIT_PERIOD_MM	Number(2,0)	SMALLINT NOT NULL	Wait Period Months
18	USE_EXIST_WAIT	Character(1)	VARCHAR2(1) NOT NULL	Use Existing Waiting Period Y/N Table Edit Default Value: N
19	COVERAGE_ENDS_CD	Character(1)	VARCHAR2(1) NOT NULL	Coverage Ends Code E=On the Event Date M=On Month-End after Event Dt P=On Pay Pd End after Event Dt Default Value: E
20	GRACE_PERIOD_DD	Number(3,0)	SMALLINT NOT NULL	Grace Period Days
21	GRACE_PERIOD_MM	Number(2,0)	SMALLINT NOT NULL	Grace Period Months
22	DED_FLXCR_BEGIN_CD	Character(1)	VARCHAR2(1) NOT NULL	Deduction+Flex Credits Begin C=On CovgBegin Date F=1st Full PayPd After Covg BgDt P=Pay Pd Containing Covg BegDt R=Pay Pd Preceding Covg BegDt Default Value: P
23	DED_FLXCR_END_CD	Character(1)	VARCHAR2(1) NOT NULL	Deduction+Flex Credits End E=On Covg End Date F=1st Full PayPd after Event Dt P=Pay Pd Containing Event Date R=Pay Pd Preceding Covg EndDt Default Value: F
24	DFLT_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Default Method C=Assign Cur Covrg Else Option E=Assign Cur Covrg Else Low Opt L=Default to Lowest Elig Option N=Assign Cur Covrg Else None O=Default to Option and Coverage T=Terminate Coverage X=Default Option for Exc Credit Default Value: E
25	DFLT_CREDIT_IND	Character(1)	VARCHAR2(1) NOT NULL	Provide FlexCR Upon Default Y/N Table Edit Default Value: Y
26	IGNORE_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Ignore Plan C=Excess Credit Only N=No Y=Yes Y/N Table Edit Default Value: N
27	IGNORE_DEPBEN_EDIT	Character(1)	VARCHAR2(1) NOT NULL	Ignore Dep/Ben Edits Y/N Table Edit Default Value: N
28	COLLECT_DEPBEN	Character(1)	VARCHAR2(1) NOT NULL	This field tells the system whether to collect dependents or beneficiaries with the employee's enrollment. Y/N Table Edit Default Value: Y
29	ALLOW_ADD_DEPBEN	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag denoting whether employees are permitted to add new dependents or beneficiaries via the eBenefits Self-Service applications. Y/N Table Edit Default Value: Y
30	CERTIFICATE_ID	Character(10)	VARCHAR2(10) NOT NULL	The CERTIFICATE_ID is the unique identifier for a Certificate definition. Prompt Table: CERTIFICATE
31	IGNORE_INVEST_EDIT	Character(1)	VARCHAR2(1) NOT NULL	Ignore Investment Edits Y/N Table Edit Default Value: N
32	COLLECT_FUNDS	Character(1)	VARCHAR2(1) NOT NULL	This field tells the system whether to collect fund allocations with the employee's enrollment. Y/N Table Edit Default Value: Y
33	BILL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action E=End Billing N=None S=Start Billing Default Value: N
34	BILL_DATE_CD	Character(1)	VARCHAR2(1) NOT NULL	Billing Starts On A=1st Full Bill Pd After Event E=On the Event Date Default Value: E
35	BILL_DELAY_DD	Number(3,0)	SMALLINT NOT NULL	Delay Billing Days
36	BILL_DELAY_MM	Number(2,0)	SMALLINT NOT NULL	Delay Billing Months
37	PERCENT_CALC	Character(1)	VARCHAR2(1) NOT NULL	Percent Calculation Y/N Table Edit Default Value: N
38	RATE_QUALIFIER	Character(1)	VARCHAR2(1) NOT NULL	Rate Qualifier E=Employee Rate T=Total Rate Default Value: E
39	RATE_PERCENT	Number(3,0)	SMALLINT NOT NULL	Rate Percent
40	FLAT_CALC	Character(1)	VARCHAR2(1) NOT NULL	Flat Amount of Y/N Table Edit Default Value: N
41	RATE_AMOUNT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Rate Amount
42	COVRG_CD_CTL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Coverage Control Flag - Added field for ERISA compliance Y/N Table Edit Default Value: N
43	FSA_PLEDGE_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	FSA Pledge Control - Event Porcessing - Rule that determines whether an employee is allowed to Increase, Decrease or Neither the FSA Pledge Amount. ERISA compliance modification D=Decrease Pledge Only I=Increase Pledge Only N=Not Applicable Default Value: N
44	IGNORE_OVRG_DPND	Character(1)	VARCHAR2(1) NOT NULL	A flag on BAS_EVENT_CLASS. If set, BenAdmin will not drop overage dependents. Y/N Table Edit Default Value: N
45	RETAIN_COVRD_DPND	Character(1)	VARCHAR2(1) NOT NULL	A flag on BAS_EVENT_CLASS. If set, BenAdmin will attempt to retain dependents and assign proper coverge code. Y/N Table Edit Default Value: N