CBR_EVENT_BENEF(SQL Table) |
Index Back |
---|---|
COBRA Event BeneficiaryCBR_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. |
# | 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 | 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 |