P 2 K_BE_ELECTION_OPTIONS

Alias: BELO#

(P2K_BE_ELECTION_OPTIONS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-BE30


Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
BOEE_IDNumber(10)IDYlink to P2K_BE_OPEN_ENROLLMENT_EES
BPN_IDNumber(10)IDYlink to P2K_BE_PLAN_DEFINITIONS
BEPS_IDNumber(10)IDYlink to P2K_BE_EMPLOYEE_PLAN_SETS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
BCG_IDNumber(10)ID link to P2K_BE_COVERAGES
PFQ_IDNumber(10)ID link to P2K_PR_FREQUENCIES
COVERAGE_STEP_CODEVarchar2(16)CODE
PLAN_REG_NUMBERVarchar2(50)VARCHAR50
EE_ANNUAL_COSTNumber(18)AMT12V6
ER_ANNUAL_COSTNumber(18)AMT12V6
CHOSEN_COVERAGEVarchar2(1)TOGGLE
RASE_IDNumber(10)ID link to P2K_RE_ASSESSMENTS

Derived Fields#

Column Name
DRV_CHOICE_TEXT
DRV_COST_BASIS
DRV_DFT_SORT_ORDER
DRV_EE_COST
DRV_ER_COST
DRV_ESTIMATED_COSTS
DRV_PLAN_INFORMATION
DRV_POLICY_NUMBER
DRV_ECT_IDS
DRV_EE_COST_POST_TAX
DRV_EE_COST_PRE_TAX

User Fields: Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page