Table Detail Report

BR_DATAM_REPORT_LAYOUT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Report Layout
Definition: Stores the possible layouts for a report.
Table Type: REFERENCE





Column Detail - BR_DATAM_REPORT_LAYOUT


Column Name Type Null? Definition
BR_DATAMART_REPORT_ID DOUBLE N The report this layout is a possibility for.
BR_DATAM_REPORT_LAYOUT_ID DOUBLE N Unique generated number that identifies a single row on the BR_DATAM_REPORT_LAYOUT table.
LAYOUT_FLAG DOUBLE N The type of available layout for this report.0
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_DATAM_REPORT_LAYOUT


Child Column in BR_DATAM_REPORT_LAYOUT(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_REPORT_ID BR_DATAMART_REPORT BR_DATAMART_REPORT_ID


BR_DATAM_VAL_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Value Set
Definition: Grouping mechanism for EHR Topics.
Table Type: REFERENCE





Column Detail - BR_DATAM_VAL_SET


Column Name Type Null? Definition
BR_DATAMART_CATEGORY_ID DOUBLE N The corresponding category from the BR_DATAMART_CATEGORY table. This along with a template_name and a value_set_name make up a unique method of finding a value set's corresponding values.
BR_DATAM_VAL_SET_ID DOUBLE N Unique, generated number that identifies a single row on the BR_DATAM_VAL_SET table.
TEMPLATE_NAME VARCHAR(50) N QRDA template to be used for e-submission, not currently in Millennium.
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.
VALUE_SET_NAME VARCHAR(255) N The name given to a list of values for the particular data element, not currently in Millennium.
VOCAB_OID_TXT VARCHAR(100) Y Object Identifier for this vocabulary as related to this value set.



Relationship Detail - BR_DATAM_VAL_SET




Parent Column in BR_DATAM_VAL_SET (PK) Child Table Name Child Column Name
Children: BR_DATAM_VAL_SET_ID BR_DATAMART_FILTER EXPECTED_ACTION_VALUE_SET_ID
BR_DATAMART_FILTER INACTION_REASON_VALUE_SET_ID
BR_DATAM_VAL_SET_ITEM BR_DATAM_VAL_SET_ID


BR_DATAM_VAL_SET_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Value Set Item
Definition: Links a value set with the vocabulary coding system items.
Table Type: REFERENCE





Column Detail - BR_DATAM_VAL_SET_ITEM


Column Name Type Null? Definition
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_DATAM_VAL_SET_ID DOUBLE N The value set that is linked to this coding system item.
BR_DATAM_VAL_SET_ITEM_ID DOUBLE N Unique, generated number that uniquely identifies a single row on the BR_DATAM_VAL_SET_ITEM 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.
SOURCE_VOCAB_ITEM_IDENT VARCHAR(50) N The code for the EHR Measure. This corresponds to a source_identifier on the Nomenclature table.
SOURCE_VOCAB_MEAN VARCHAR(12) N The coding system used for the EHR Measure code. This corresponds to a source vocabulary code on the nomenclature table.
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_DATAM_VAL_SET_ITEM


Child Column in BR_DATAM_VAL_SET_ITEM(FK) Parent Table Name Parent Column Name
Parents: BR_DATAM_VAL_SET_ID BR_DATAM_VAL_SET BR_DATAM_VAL_SET_ID




Parent Column in BR_DATAM_VAL_SET_ITEM (PK) Child Table Name Child Column Name
Children: BR_DATAM_VAL_SET_ITEM_ID BR_DATAM_VAL_SET_ITEM_MEAS BR_DATAM_VAL_SET_ITEM_ID


BR_DATAM_VAL_SET_ITEM_MEAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Value Set Item Measure
Definition: Details about value sets, their related vocabulary coding sets, and QRDA measures.
Table Type: REFERENCE





Column Detail - BR_DATAM_VAL_SET_ITEM_MEAS


Column Name Type Null? Definition
BR_DATAM_VAL_SET_ITEM_ID DOUBLE N The value set and vocabulary item that this measure is related to. The corresponding value id from the BR_DATAMART_MAP_VALUE table.
BR_DATAM_VAL_SET_ITEM_MEAS_ID DOUBLE N Unique, generated number that identifies a single row on the BR_DATAM_VAL_SET_ITEM_MEAS table.
DRUG_CATEGORY_TXT VARCHAR(100) N The Multum drug class.
DRUG_DESC VARCHAR(1650) Y Provides a display value used for Medications only.
DRUG_EXCLUSION_IND DOUBLE Y Indicates if the medication administration should be excluded.
MAPPING_REQUIRED_IND DOUBLE N Indicates whether this value needs to be mapped for e-submission.
MEAS_IDENT VARCHAR(50) N Measure number (used for PQRS only). Not currently in Millennium.
MEAS_MAX_VALUE DOUBLE Y The highest acceptable limit for inclusion in this QRDA measure. This is used for submission of actual results, established by CMS, not in Millennium.
MEAS_MIN_VALUE DOUBLE Y The lowest acceptable limit for inclusion in this QRDA measure. This is used for submission of actual results, established by CMS, not in Millennium.
MEAS_UOM_TXT VARCHAR(30) Y The unit of measure associated with the min_value and max_value.
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.
VOCAB_ITEM_DESC VARCHAR(300) Y The display value for the vocabulary item related to this measure.
VOCAB_ITEM_END_EFFECTIVE_DT_TM DATETIME Y The last date and time that this vocabulary item is effective for this measure.
VOCAB_ITEM_QUALIFIER_TXT VARCHAR(40) N Field for providing additional details about a vocabulary item as it relates to this measure.
VOCAB_OID_TXT VARCHAR(40) N Object Identifier for this vocabulary as related to this measure.



Relationship Detail - BR_DATAM_VAL_SET_ITEM_MEAS


Child Column in BR_DATAM_VAL_SET_ITEM_MEAS(FK) Parent Table Name Parent Column Name
Parents: BR_DATAM_VAL_SET_ITEM_ID BR_DATAM_VAL_SET_ITEM BR_DATAM_VAL_SET_ITEM_ID


BR_DATA_OPS



Column Section Relationship Section Top of Page


Table-level Detail

Description: BEDROCK DATA OPS
Definition: BEDROCK OPS DATA
Table Type: REFERENCE





Column Detail - BR_DATA_OPS


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DATA_OP_TYPE VARCHAR(30) Y Type of operation being performed
OP_START_DT_TM DATETIME Y Time operation started
RUN_ID DOUBLE N Identifies run with client and start version
START_VERSION_NBR DOUBLE N Identifies which version of start has been loaded
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_DATA_OPS




Parent Column in BR_DATA_OPS (PK) Child Table Name Child Column Name
Children: RUN_ID BR_DATA_OPS_LOG RUN_ID