Alias: BCGC#

(P2K_BE_COVERAGE_COMPONENTS)

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


Coverage Components

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
BBC_IDNumber(10)IDYlink to P2K_BE_BENEFIT_COMPONENTS
BCGD_IDNumber(10)IDYlink to P2K_BE_COVERAGE_DETAILS
BBCR_IDNumber(10)IDYlink to P2K_BE_BC_RULES
MUC_IDNumber(10)ID link to P2K_AM_USER_CALCS
PEL_IDNumber(10)ID link to P2K_PR_ELEMENTS
PPC_IDNumber(10)ID link to P2K_PR_PAY_COMPONENTS
COMPONENT_SEQUENCENumber(5)NUMBER5Y
BC_ACTIONVarchar2(2)X_BC_ACTIONY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
FIELD_VALUEVarchar2(200)VARCHAR200
ALLOW_VALUE_OVERRIDEVarchar2(1)TOGGLE
ENTER_ENROLLMENTVarchar2(1)TOGGLE
ENTER_BENEFIT_LINESVarchar2(1)TOGGLE
ENTER_REMIT_HISTORYVarchar2(1)TOGGLE
UPDATE_REMIT_HISTORYVarchar2(1)TOGGLE
ENTER_ELECTIONVarchar2(1)TOGGLE
SHOW_ON_ELECTIONVarchar2(1)TOGGLE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page