BEN_DEFN_OPTN(SQL Table) |
Index Back |
|---|---|
Benefit Option DefinitionBEN_DEFN_OPTN is a record that defines the benefit options for each plan type and is used for processing in Payroll and Benefit Administration. A benefit option is a combiniation of benefit plan and coverage code. For Benefit Administration, it contains information on each option such as the option code, option level, eligility rules ID, etc. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BENEFIT_PROGRAM |
Character(3) | VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table: BEN_DEFN_PGM |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | 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. |
| 4 | OPTION_ID |
Number(4,0) | SMALLINT NOT NULL | Option ID |
| 5 | DISPLAY_OPT_SEQ | Number(3,0) | SMALLINT NOT NULL | Display Option Sequence |
| 6 | OPTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Option Type
D=General Deduction G=General Credit O=Option P=Program W=Waive Option |
| 7 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BENEF_PLAN_TBL |
| 8 | COVRG_CD | Character(2) | VARCHAR2(2) NOT NULL |
Coverage Code
Prompt Table: COVRG_CD_TBL |
| 9 | OPTION_CD | Character(3) | VARCHAR2(3) NOT NULL | Option Code |
| 10 | OPTION_LVL | Number(2,0) | SMALLINT NOT NULL | Option Level |
| 11 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: DEDUCTION_TBL |
| 12 | DFLT_OPTION_IND | Character(1) | VARCHAR2(1) NOT NULL |
Default Option Indicator
Y/N Table Edit Default Value: N |
| 13 | ELIG_RULES_ID | Character(4) | VARCHAR2(4) NOT NULL |
Eligibility Rules ID
Prompt Table: BAS_ELIG_RULES |
| 14 | LOCATION_TBL_ID | Character(4) | VARCHAR2(4) NOT NULL |
Location Table ID
Prompt Table: GEOG_LOCN_TBL |
| 15 | CROSS_PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Cross Plan Type
Prompt Table: BEN_PLAN_TYP_VW |
| 16 | CROSS_BENEF_PLAN | Character(6) | VARCHAR2(6) NOT NULL |
Cross Benefit Plan
Prompt Table: BEN_PLN_EFF_VW |
| 17 | COVERAGE_LIMIT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Cross Coverage Limit Pct |
| 18 | CROSS_PLN_DPND_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Cross Plan Dependent Check
Y/N Table Edit |