!!!Alias: BELO (P2K_BE_ELECTION_OPTIONS) Unique Keys: \\ Child Table: \\ Parent Table:\\ ERD: [ERD-BE30] \\ !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[BOEE_ID]|Number(10)|[ID]|Y|link to [P2K_BE_OPEN_ENROLLMENT_EES] |[BPN_ID]|Number(10)|[ID]|Y|link to [P2K_BE_PLAN_DEFINITIONS] |[BEPS_ID]|Number(10)|[ID]|Y|link to [P2K_BE_EMPLOYEE_PLAN_SETS] |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[BCG_ID]|Number(10)|[ID]| |link to [P2K_BE_COVERAGES] |[PFQ_ID]|Number(10)|[ID]| |link to [P2K_PR_FREQUENCIES] |[COVERAGE_STEP_CODE]|Varchar2(16)|[CODE]| | |[PLAN_REG_NUMBER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[EE_ANNUAL_COST]|Number(18)|[AMT12V6|AMTnn]| | |[ER_ANNUAL_COST]|Number(18)|[AMT12V6|AMTnn]| | |[CHOSEN_COVERAGE]|Varchar2(1)|[TOGGLE]| | !!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] User Fields: Allowed\\ Audit Logging: Not Allowed\\ [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.P2K_BE_ELECTION_OPTIONS] [{InsertPage page='Internal.P2K_BE_ELECTION_OPTIONS' default='Click to create a new discussion page'}] }]