Alias: BEPS#

(P2K_BE_EMPLOYEE_PLAN_SETS)

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


Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
BOEE_IDNumber(10)IDYlink to P2K_BE_OPEN_ENROLLMENT_EES
BOPS_IDNumber(10)IDYlink to P2K_BE_OPEN_PLAN_SETS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EVIDENCE_OF_INSURANCEVarchar2(1)X_EVIDENCE_STATUS
ELECTION_STAGEVarchar2(2)X_BE_OE_ELECTION_STAGE
ELECTION_DECISIONVarchar2(2)X_BE_OE_ELECTION_DECISION
REASON_FOR_DECLINEVarchar2(2)X_BE_DECLINE_REASON

User Fields: Allowed
Audit Logging: Allowed