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 |