Table Detail Report

BR_CPC_ELIG_PROV_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Comprehensive Primary Care Eligible Provider Relation
Definition: Stores the relationship between CPCs and eligible providers.
Table Type: REFERENCE





Column Detail - BR_CPC_ELIG_PROV_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BR_CPC_ELIG_PROV_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_CPC_ELIG_PROV_RELTN table.
BR_CPC_ID DOUBLE N The CPC group that this eligible provider belongs to.
BR_ELIGIBLE_PROVIDER_ID DOUBLE N The eligible provider that is a part of this CPC group.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ORIG_BR_CPC_ELIG_PROV_RELTN_ID DOUBLE N Used for versioning. Contains the original PK value for BR_CPC_ELIG_PROV_RELTN_ID
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - BR_CPC_ELIG_PROV_RELTN


Child Column in BR_CPC_ELIG_PROV_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_CPC_ID BR_CPC BR_CPC_ID
ORIG_BR_CPC_ELIG_PROV_RELTN_ID BR_CPC_ELIG_PROV_RELTN BR_CPC_ELIG_PROV_RELTN_ID
BR_ELIGIBLE_PROVIDER_ID BR_ELIGIBLE_PROVIDER BR_ELIGIBLE_PROVIDER_ID




Parent Column in BR_CPC_ELIG_PROV_RELTN (PK) Child Table Name Child Column Name
Children: BR_CPC_ELIG_PROV_RELTN_ID BR_CPC_ELIG_PROV_RELTN ORIG_BR_CPC_ELIG_PROV_RELTN_ID


BR_CPC_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Comprehensive Primary Care Location Relation
Definition: Stores the relationship between CPCs and locations.
Table Type: REFERENCE





Column Detail - BR_CPC_LOC_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BR_CPC_ID DOUBLE N The CPC group that tis associated to this location.
BR_CPC_LOC_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_CPC_LOC_RELTN table.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LOCATION_CD DOUBLE N The location that is associated to this CPC group.
ORIG_BR_CPC_LOC_RELTN_ID DOUBLE N Used for versioning. Contains the original PK value for BR_CPC_LOC_RELTN_ID
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - BR_CPC_LOC_RELTN


Child Column in BR_CPC_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_CPC_ID BR_CPC BR_CPC_ID
ORIG_BR_CPC_LOC_RELTN_ID BR_CPC_LOC_RELTN BR_CPC_LOC_RELTN_ID
LOCATION_CD LOCATION LOCATION_CD




Parent Column in BR_CPC_LOC_RELTN (PK) Child Table Name Child Column Name
Children: BR_CPC_LOC_RELTN_ID BR_CPC_LOC_RELTN ORIG_BR_CPC_LOC_RELTN_ID


BR_DATAMART_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Category
Definition: table to store lighthouse report categories
Table Type: REFERENCE





Column Detail - BR_DATAMART_CATEGORY


Column Name Type Null? Definition
BASELINE_TARGET_IND DOUBLE N Determines whether to display baseline/target values. 1 is OFF.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BR_DATAMART_CATEGORY_ID DOUBLE N unique id for each category
CATEGORY_MEAN VARCHAR(30) N unique string for a category
CATEGORY_NAME VARCHAR(100) N category display name
CATEGORY_TOPIC_MEAN VARCHAR(30) Y Stores a generic meaning for categories that are linked together
CATEGORY_TYPE_FLAG DOUBLE N Stores the type of reports to be setup - 0=lighthouse 1= Mpages 2=nhiqm
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FLEX_FLAG DOUBLE N Stores in indicator of how this category is flexed.
LAYOUT_FLAG DOUBLE N Indicates what type of layout this view has chosen. 0 - Summary Layout, 1 - Workflow Layout
RELIABILITY_SCORE_IND DOUBLE N Determines whether to display Reliability Score Input Fields. 1 is OFF.
SCRIPT_NAME VARCHAR(30) Y Name of the ccl script that will be used by Mpages to return data for the category
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VIEWPOINT_CAPABLE_IND DOUBLE N Indicates whether a category is eligible to be included in an MPage viewpoint.



Relationship Detail - BR_DATAMART_CATEGORY




Parent Column in BR_DATAMART_CATEGORY (PK) Child Table Name Child Column Name
Children: BR_DATAMART_CATEGORY_ID BR_DATAMART_FILTER BR_DATAMART_CATEGORY_ID
BR_DATAMART_REPORT BR_DATAMART_CATEGORY_ID
BR_DATAMART_TEXT BR_DATAMART_CATEGORY_ID
BR_DATAM_MAPPING_TYPE BR_DATAMART_CATEGORY_ID
LH_ABS_MEASURE BR_DATAMART_CATEGORY_ID
LH_ABS_MEASURE_RELTN BR_DATAMART_CATEGORY_ID
LH_ABS_SPECIAL_SKIP_LOGIC BR_DATAMART_CATEGORY_ID
MP_VIEWPOINT_RELTN BR_DATAMART_CATEGORY_ID
PREG_BR_CONFIG_HISTORY MP_VIEW_ID


BR_DATAMART_DEFAULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Default
Definition: table to store default data for each filter
Table Type: REFERENCE





Column Detail - BR_DATAMART_DEFAULT


Column Name Type Null? Definition
BR_DATAMART_DEFAULT_ID DOUBLE N Unique id for default data
BR_DATAMART_FILTER_ID DOUBLE N id from br_datamart_filter
CODE_SET DOUBLE Y code set column
CV_DESCRIPTION VARCHAR(255) N Long name for a result
CV_DISPLAY VARCHAR(100) N short name for a result
GROUP_CE_CONCEPT_CKI VARCHAR(255) Y Concept cki for an event code
GROUP_CE_NAME VARCHAR(100) Y description for an event code
GROUP_NAME VARCHAR(100) Y Bedrock display name for group of events
ORDER_DETAIL_IND DOUBLE Y Indicates if a default has order details
QUALIFIER_FLAG DOUBLE Y indicates how the result is to be compared to an event - greater than, equal to, less than,etc. 1=Equal to 2=Not equal to 3=Greater than 4=Less than 5=Greater than or equal to 6=Less than or equal to
RESULT_TYPE_FLAG DOUBLE Y indicates the type of result - numeric,alpha,free text 1=Alpha 2=Numeric
RESULT_VALUE VARCHAR(255) Y the actual result that an event will be linked to - could be a free textnumber or a string value
UNIQUE_IDENTIFIER VARCHAR(255) N unique string for results
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - BR_DATAMART_DEFAULT


Child Column in BR_DATAMART_DEFAULT(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_FILTER_ID BR_DATAMART_FILTER BR_DATAMART_FILTER_ID




Parent Column in BR_DATAMART_DEFAULT (PK) Child Table Name Child Column Name
Children: BR_DATAMART_DEFAULT_ID BR_DATAMART_DEFAULT_DETAIL BR_DATAMART_DEFAULT_ID


BR_DATAMART_DEFAULT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Default Detail
Definition: Stores additional data for a default result
Table Type: REFERENCE





Column Detail - BR_DATAMART_DEFAULT_DETAIL


Column Name Type Null? Definition
BR_DATAMART_DEFAULT_DETAIL_ID DOUBLE N Unique ID for the table.
BR_DATAMART_DEFAULT_ID DOUBLE N Unique ID from the BR_DATAMART_DEFAULT table
DETAIL_CKI VARCHAR(255) N cki value for default detail
DETAIL_VALUE VARCHAR(255) N free text value for the default detail
OE_FIELD_MEANING VARCHAR(25) N unique meaning from oe_field_meaning table
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - BR_DATAMART_DEFAULT_DETAIL


Child Column in BR_DATAMART_DEFAULT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_DEFAULT_ID BR_DATAMART_DEFAULT BR_DATAMART_DEFAULT_ID