GPIN_MDA_DEPEND

(SQL Table)
Index Back

MDA Dependents

This record holds the Medical Allowance dependent information for payees.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

Prompt Table: GPIN_DEP_VW
Set Control Field: DEPENDENT_BENEF