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 |