P 2 K_BE_PLAN_DEFINITIONS
Back to current versionRestore this version

Alias: BPN#

(P2K_BE_PLAN_DEFINITIONS)

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


Plan Definitions

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PLAN_CODEVarchar2(16)CODEY
DEN_IDNumber(10)ID link to P2K_CM_ENTITIES
BPT_IDNumber(10)IDYlink to P2K_BE_BENEFIT_PLAN_TYPES
DCL_IDNumber(10)IDYlink to P2K_CM_CALENDARS
BRM_IDNumber(10)ID link to P2K_BE_REMITTANCE_REPORTS
DESCRIPTIONVarchar2(50)DESCRIPTION
PLAN_ACCESS_CODEVarchar2(2)X_PLAN_ACCESS_CODE
ESTABLISHED_DATEDate()DATE
PLAN_END_DATEDate()DATE
PARTICIPATION_RULEVarchar2(2)X_PARTICIPATION_RULE
POLICY_NUMBERVarchar2(30)VARCHAR30
CALCULATION_SEQUENCENumber(5)NUMBER5
PLAN_REMIT_SEQUENCENumber(5)NUMBER5
TRACK_DECLINEVarchar2(1)TOGGLE
LAST_REMIT_DATEDate()DATE
REMIT_BY_STATEVarchar2(1)X_REMIT_BY_STATE
REMIT_BY_UNIT_OR_GROUPVarchar2(1)TOGGLE
REMIT_DATE_RULEVarchar2(2)X_REMIT_DATE_RULE
REMIT_ASOF_DAYNumber(5)NUMBER5
PRINT_ZERO_RULEVarchar2(2)X_PRINT_ZERO_RULE
PRINT_ALL_WAIVERSVarchar2(1)TOGGLE
NOT_SCHEDULEDVarchar2(1)TOGGLE
APPROVAL_REQUIREDVarchar2(1)X_BE_APPROVAL
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
WEB_DOCUMENTVarchar2(200)URL
ELECTION_DOCUMENTVarchar2(200)URL
PLAN_ELECTION_SETVarchar2(16)X_PLAN_ELECTION_SET
OPEN_ENROLLMENT_ALLOWEDVarchar2(2)X_BE_OE_ALLOWED
DEFAULT_ELECTION_DECISIONVarchar2(2)X_BE_OE_ELECTION_DECISION
DISPLAY_SEQUENCENumber(5)NUMBER5
GRANDFATHEREDVarchar2(1)TOGGLE
ELECTION_INTRO_TEXTVarchar2(4000)VARCHAR4000
TRACK_OE_NO_CHANGEVarchar2(1)TOGGLE

Derived Fields#

Column Name
DRV_PLAN_ELECTION_SET_CODE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page