COVRG_CDEFFDTDefault Value: %date
COVERED_PERSON_TYPAC=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
FEDGVT_CVGRULE_CFG(SQL Table) |
Index Back |
|---|---|
Coverage Code Rule ConfigFederal Coverage Code Rule Configuration table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COVRG_CD |
Character(2) | VARCHAR2(2) NOT NULL | Coverage Code |
| 2 | EFFDT |
Date(10) | DATE |
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 |
| 4 | FED |
Character(1) | VARCHAR2(1) NOT NULL | Federal Functionality |
| 5 | MIN_NUM_COVERED | Number(1,0) | SMALLINT NOT NULL | Minimum Number Covered for COVRG_CD/COVERED_PERSON_TYP combination |
| 6 | MAX_NUM_COVERED | Number(2,0) | SMALLINT NOT NULL | Maximum Number Covered for COVRG_CD/COVERED_PERSON_TYP combination |