LIFE_ADD_TBL(SQL Table) |
Index Back |
|---|---|
Life AD/D Ben Plan ParametersLIFE_ADD_TBL is a record which defines the Life and Accidental Death plans offered by a company. It is used to define the basic coverage calculation used (flat amount, factors, special rules, etc.) and any applicable coverage groups. It is populated online in the Life and AD/D Plan Table panel. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PLAN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
Prompt Table: LIFE_PLAN_VW |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BENEF_PLAN_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | COVG_GROUP_CD | Character(4) | VARCHAR2(4) NOT NULL |
Coverage Group Code
Prompt Table: COVG_GROUP_TBL |
| 5 | COVERAGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to define the coverage level.
1=Plan Level 2=Employee Level Default Value: 1 |
| 6 | BN_FORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL |
This field is key for defining the formula and formula can be uniquely identified by this field.
Prompt Table: BN_FORMULA |
| 7 | ENROLLE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
The Field is used to determine the insuerd person type.
1=Coverage Employee 2=Coverage Dependents Default Value: 1 |
| 8 | SUM_DEP_COVG | Character(1) | VARCHAR2(1) NOT NULL |
This Field determines the if need to sum the dependent coverage amount or not.
Y/N Table Edit Default Value: N |
| 9 | FACTOR_XSALARY | Number(5,3) | DECIMAL(4,3) NOT NULL | Factor |
| 10 | GVT_ASSIGN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Assignable?
Y/N Table Edit Default Value: N |
| 11 | DISCRIMINATORY | Character(1) | VARCHAR2(1) NOT NULL |
This field is used for Discriminatory Life.
Y/N Table Edit |
| 12 | SPEC_RELATION | Character(1) | VARCHAR2(1) NOT NULL |
This Field determines if coverage relationship is specified.
Y/N Table Edit Default Value: N |