P 2 K_BE_COVERAGE_RATES

Alias: BCGR#

(P2K_BE_COVERAGE_RATES)

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


Coverage Rates

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
BCGD_IDNumber(10)IDYlink to P2K_BE_COVERAGE_DETAILS
COVERAGE_STEP_CODEVarchar2(16)CODEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
UP_TO_LIMITNumber(18)AMT12V6
NEXT_STEP_CODEVarchar2(16)CODE
FLEX_AMOUNTNumber(18)AMT12V6
PREMIUM1_RATENumber(18)AMT12V6
PREMIUM2_RATENumber(18)AMT12V6
EE_DEDUCTION_RATENumber(18)AMT12V6
ER_CONTRIBUTION_RATENumber(18)AMT12V6
TAXBEN_RATENumber(18)AMT12V6
USER1_RATENumber(18)AMT12V6
USER2_RATENumber(18)AMT12V6
USER3_RATENumber(18)AMT12V6

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page