BAS_CVG_CD_RULE (SQL Table)	Index Back
Coverage Code Control Rules Works in conjunction with the Event Rules table (BAS_EVENT_CLASS) to determine allowable changes by Covered person type - Added for ERISA compliance

BAS_CVG_CD_RULE

(SQL Table)

Coverage Code Control Rules

Works in conjunction with the Event Rules table (BAS_EVENT_CLASS) to determine allowable changes by Covered person type - Added for ERISA compliance

Parent record: 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

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL Event Classification

4 COVERED_PERSON_TYP Character(2) VARCHAR2(2) NOT NULL Covered Person Type: Added fields for Benefits ERISA implementation. Groups relationship codes into categories, i.e. Son, Daughter => Child
AC=Adult Child
CH=Child
DP=Domestic Partner
EE=Employee
NQ=Non-Qualified Dependent
OD=Other Qualified Dependent
SP=Spouse
SS=US Same-Sex Spouse
XS=ExSpouse

5 COVRG_SAME_FLG Character(1) VARCHAR2(1) NOT NULL Same Coverage Flag (Y/N) - Event processing when these is a current election - Can coverage for this Person Type remain the same in number? - Added field for ERISA compliance.
Y/N Table Edit
Default Value: N

6 COVRG_MORE_FLG Character(1) VARCHAR2(1) NOT NULL More Coverage Flag (Y/N) - Event processing when these is a current election - Can coverage for this Person Type increase? - Added field for ERISA compliance.
Y/N Table Edit
Default Value: N

7 COVRG_LESS_FLG Character(1) VARCHAR2(1) NOT NULL Less Coverage Flag (Y/N) - Event processing when these is a current election - Can coverage for this Person Type decrease in number? - Added field for ERISA compliance.
Y/N Table Edit
Default Value: N

8 COVRG_IND Character(1) VARCHAR2(1) NOT NULL Coverage Indicator - Event rules processing, when there is no current elected coverage - Values are Required, Allowed or Not Allowed - Added field for ERISA compliance.
A=Allowed
N=Not Allowed
R=Required
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EVENT_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Event Rules ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Event Classification
4	COVERED_PERSON_TYP	Character(2)	VARCHAR2(2) NOT NULL	Covered Person Type: Added fields for Benefits ERISA implementation. Groups relationship codes into categories, i.e. Son, Daughter => Child AC=Adult Child CH=Child DP=Domestic Partner EE=Employee NQ=Non-Qualified Dependent OD=Other Qualified Dependent SP=Spouse SS=US Same-Sex Spouse XS=ExSpouse
5	COVRG_SAME_FLG	Character(1)	VARCHAR2(1) NOT NULL	Same Coverage Flag (Y/N) - Event processing when these is a current election - Can coverage for this Person Type remain the same in number? - Added field for ERISA compliance. Y/N Table Edit Default Value: N
6	COVRG_MORE_FLG	Character(1)	VARCHAR2(1) NOT NULL	More Coverage Flag (Y/N) - Event processing when these is a current election - Can coverage for this Person Type increase? - Added field for ERISA compliance. Y/N Table Edit Default Value: N
7	COVRG_LESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Less Coverage Flag (Y/N) - Event processing when these is a current election - Can coverage for this Person Type decrease in number? - Added field for ERISA compliance. Y/N Table Edit Default Value: N
8	COVRG_IND	Character(1)	VARCHAR2(1) NOT NULL	Coverage Indicator - Event rules processing, when there is no current elected coverage - Values are Required, Allowed or Not Allowed - Added field for ERISA compliance. A=Allowed N=Not Allowed R=Required Default Value: A