EMPLIDPrompt Table: PERSON
EMPL_RCDPrompt Table: PER_ORG_ASGN_VW
EFFDTDefault Value: LIFE_ADD_BEN.COVERAGE_BEGIN_DT
DEPENDENT_BENEF01=default
Prompt Table: DEPENDENT_VW
N=No
Y=Yes
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
GVT_FIN_CHK_BEN(SQL Table) |
Index Back |
|---|---|
EE Final Check BeneficiariesLIFE_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 Rcd Nbr
Prompt Table: PER_ORG_ASGN_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: LIFE_ADD_BEN.COVERAGE_BEGIN_DT |
| 4 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEPENDENT_VW |
| 5 | BENEF_PCT | Number(3,0) | SMALLINT NOT NULL | Percent Beneficiary Paid |
| 6 | FLAT_AMOUNT | Signed Number(9,0) | DECIMAL(8) NOT NULL | Flat Amount |
| 7 | EXCESS | Character(1) | VARCHAR2(1) NOT NULL |
Excess
N=No Y=Yes Y/N Table Edit Default Value: N |
| 8 | CONTINGENT | Character(1) | VARCHAR2(1) NOT NULL |
Contingent
Y/N Table Edit Default Value: N |