DEPBEN_TYPE_TBL(SQL Table) |
Index Back |
|---|---|
Dependent role by RelationshipThis record defines which Relationship types can be treated as legal Dependents. This is used to default DEPBENEF_TYPE when a new Dependent/Beneficiary is added into the system, or when and individual's Relationship code is edited |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RELATIONSHIP |
Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 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 Default Value: OD |
| 5 | AGE_LIMIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Y/N Age Limit Flag - Added for Benefits ERISA implementation. Y => Age limit for 1X plan coverage applies to this relationship code.
Y/N Table Edit Default Value: N |
| 6 | CERTIFICATE_ID | Character(10) | VARCHAR2(10) NOT NULL |
The CERTIFICATE_ID is the unique identifier for a Certificate definition.
Prompt Table: CERTIFICATE |
| 7 | MUTUALLY_EXCLUSIVE | Character(1) | VARCHAR2(1) NOT NULL |
Indicates a mutually exclusive state.
Y/N Table Edit Default Value: N |
| 8 | GENDER_VALIDATION | Character(2) | VARCHAR2(2) NOT NULL |
The GENDER_VALIDATION field is a translate value field used within Benefits to control dependent information.
NO=No Gender Validation OS=Opposite Sex Only SS=Same Sex Only Default Value: NO |