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 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
|
| 2 | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN_VW |
|
| 3 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |