!!!Alias: BCG (P2K_BE_COVERAGES) Unique Keys: \\ Child Table: \\ Parent Table: \\ ERD: [ERD-BE20] \\ Coverages !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[BPN_ID]|Number(10)|[ID]|Y|link to [P2K_BE_PLAN_DEFINITIONS] |[COVERAGE_CODE]|Varchar2(16)|[CODE]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[COVERAGE_REMIT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[POLICY_NUMBER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CONTACT_ROLE]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[DISPLAY_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[EVIDENCE_REQUIRED]|Varchar2(1)|[TOGGLE]| | |[ESTIMATED_COSTS]|Varchar2(1)|[TOGGLE]| | |[PRE_TAX]|Varchar2(1)|[TOGGLE]| | |[RECIPIENT_TYPE]|Varchar2(2)|[X_PLAN_RECIPIENT_TYPE]| | |[NUMBER_RECIPIENTS]|Number(5)|[NUMBER5|NUMBERn]| | |[MAXIMUM_CHILD_AGE]|Number(5)|[NUMBER5|NUMBERn]| | |[MAXIMUM_STUDENT_AGE]|Number(5)|[NUMBER5|NUMBERn]| | |[WAITING_PERIOD]|Number(5)|[NUMBER5|NUMBERn]| | |[MINIMUM_HOURS_PER_WEEK]|Number(5)|[NUMBER5|NUMBERn]| | |[EXCLUDE_FROM_OPEN_ENROLLMENT]|Varchar2(1)|[TOGGLE]| | |[MAXIMUM DISABLED AGE]|Number(5)|[NUMBER5|NUMBERn]| | User Fields: Allowed\\ Audit Logging: Allowed\\ ---- ![Notes|Edit:Internal.P2K_BE_COVERAGES] [{InsertPage page='Internal.P2K_BE_COVERAGES' default='Click to create a new notes page'}]