UPG_DEPBEN_TYPE(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 |