GVT_FIN_CHK(SQL Table) |
Index Back |
---|---|
EE Final Check HeaderLIFE_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%. |
# | 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 Record
Prompt Table: PER_ORG_ASGN_VW |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |