BN_DEPEND_WK

(SQL Table)
 Index Back

Used for managing Depend List

This work record is used as the basis for managing a cache of Dependent information for benefit cost calculations. This work record is intended for use in association with SQL BN_CACHE_DEPEND.

  • Parent record: JOB

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
    01=default
    2 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    3 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
    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
    5 BIRTHDATE Date(10) DATE Date of Birth
    6 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    7 SMOKER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee or dependent is a smoker.
    N=Non Smoker
    Y=Smoker
    8 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
    9 STUDENT Character(1) VARCHAR2(1) NOT NULL Student
    N=No
    Y=Yes
    10 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

    Y/N Table Edit

    11 EFFDT Date(10) DATE NOT NULL Effective Date