MAR_STATPD_TBL

(SQL Table)
 Index Back

Setup Table for Marital Status

This is a setup table that updates the Marital Status in Personal Data based on the fact that the flag to update personal data marital status is indicated as a 'Y'.

  • Parent Record Of MAR_STATREL_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 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed

    Default Value: M