P 2 K_BE_ELECTION_OPTIONS
Back to current versionRestore this version

Alias: BELO#

Unique Keys: _
Child Table:
_
Parent Table: _

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

User Fields: Allowed
Audit Logging: Not Allowed