MAR_STATREL_TBL

(SQL Table)
Index Back

Child Setup Table for Mar Stat

This is child of the setup table 'MAR_STATUS_PD' that shows all the types of people 'Relationship' that need to be updated in the personal data record based on the indicator to update the personal data. The people code is done in RELATIONSHIPS.EMPLID_RELATED@SaveEdit.

  • Parent record: MAR_STATPD_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 UPDT_PD_MARTL_STAT Character(1) VARCHAR2(1) NOT NULL Updt Persnl Data Marital Stat

    Y/N Table Edit

    Default Value: Y

    2 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship