DB - Dependent Benefits

  • Employee report Detail topic.

  • Accesses data from the Dependent Benefit file.

  • Provides data about dependent and dependent benefit information by benefit type, plan code, and effective date.

  • Valid only with the Benefits system.

  • Data loaded by Dependant (HR13.1), the Dependent Benefits subforms in Benefit Entry (BN31.1), Employee Benefit Changes (BN32.1), Employee Change Benefit Update (BN100), and Mass Benefit Add (BN101).

    Item name Description
    Dep Create Date Dependent benefit creation date
    Dep Update Date Dependent benefit update date
    Dep User Id Dependent user id
    Dependent Number Number assigned to the dependent
    Disabled Indicates if employee is disabled
    Employee Start Date Employee's start date for a benefit
    Gender Dependent's gender
    Name - First First name of dependent
    Name - Full Full name of dependent
    Name - Last Last name of dependent
    Name - Middle Init Middle initial of dependent
    Plan Code Plan code
    Plan Description Plan description
    Plan Type Plan type
    Relationship Relationship of dependent to employee
    Social Nbr Dependent's social number
    Start Date Start date for dependent benefit
    Stop Date Stop date for dependent benefit
    Student Indicates if dependent is a student