UPG_CBR_EVT_BNF (SQL Table)	Index Back
COBRA Event Beneficiary CBR_Event_Benef is a child record of CBR_Event_Rules. It defines for a specific COBRA event class the dependent relationships that are qualified for the COBRA event. These rules are used by the COBRA Administration product to qualify and process COBRA events.

UPG_CBR_EVT_BNF

(SQL Table)

COBRA Event Beneficiary

CBR_Event_Benef is a child record of CBR_Event_Rules. It defines for a specific COBRA event class the dependent relationships that are qualified for the COBRA event. These rules are used by the COBRA Administration product to qualify and process COBRA events.

Parent record: CBR_EVENT_RULES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COBRA_EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL COBRA Event Classification
Prompt Table: CBR_EVENT_RULES

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

3 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COBRA_EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	COBRA Event Classification Prompt Table: CBR_EVENT_RULES
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
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