GVT_FIN_CHK

(SQL Table)
Index Back

EE Final Check Header

LIFE_ADD_BENEFC is a record which identifies the beneficiaries associated with the Life Insurance or Accidental Death plans (plan types '2X') that a participant has enrolled in. It is populated in the Base benefits system using the Life and AD/D Benefits 2 panel within the Benefits Window or by the BASEMLOD/BASOELOD load processes of the Benefits Administration product. There can be multiple dependent records per life plan per employee, but the total benefit distribution must be 100%.

  • Parent record: LIFE_ADD_BEN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Prompt Table: PER_ORG_ASGN_VW

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date