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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation