Table Detail Report
LH_EH_QRDA
Column Section | Top of Page |
Table-level Detail
Description: | LH_EH_QRDA |
Definition: | Stores data for Eligible Hospital Quality Reporting Data Architecture |
Table Type: | ACTIVITY |
Column Detail - LH_EH_QRDA
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_DISPLAY | VARCHAR(300) | Y | The human readable display of the code. |
CODE_SYSTEM | VARCHAR(40) | Y | The OID of the coding system to which the code belongs. |
CODE_SYSTEM_NAME | VARCHAR(12) | Y | The name of the coding system to which the code belongs. |
CODE_SYSTEM_SDTC | VARCHAR(100) | Y | The OID of the value set to which the code belongs. |
CODE_TXT | VARCHAR(50) | Y | The qualifying code for the record. |
CONDITION_MASK | DOUBLE | Y | A bitmask that identifies what conditions are associated to the record. The conditions correspond to the following numbers: AMI - 1, CAC - 2, ED - 4, EHDI - 8, PC - 16, STK - 32, VTE - 64 |
EFFECTIVE_HIGH_DT_TM | DATETIME | Y | The high (end) date/time assocaited to the record. |
EFFECTIVE_HIGH_UTC_OFFSET | VARCHAR(5) | Y | Stores the UTC offset for the effective_high_dt_tm (e.g. -0500). |
EFFECTIVE_LOW_DT_TM | DATETIME | Y | The low (start) date/time associated to the record. |
EFFECTIVE_LOW_UTC_OFFSET | VARCHAR(5) | Y | Stores the UTC offset for the effective_low_dt_tm (e.g. -0500). |
ENCNTR_ID | DOUBLE | N | The primary key of the ENCOUNTER table for the encounter associated to the record. |
EXTRACT_DT_TM | DATETIME | Y | The start date/time of the program that collected the record last. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifier of the health system to which the record belongs. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifier of the health system source to which the record belongs. |
HL7_TEMPLATE | VARCHAR(50) | Y | The HL7 template for the record. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_EH_QRDA_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_EH_QRDA table. |
LOGICAL_CONDITION_MASK | DOUBLE | Y | A bitmask that identifies which conditions the data should be submitted for. Possible values are: AMI - 1, CAC - 2, ED - 4, EHDI - 8, PC - 16, STK - 32, VTE - 64, HWR - 128, PCB - 256, PCM - 512, Opioid - 1024, Hybrid - 2048, HH - 4096, STEMI - 8192, GMCS - 16384, ORAE - 32768 |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
PARENT_ENTITY_ID | DOUBLE | N | The primary key of the table in Millennium from which the record was retrieved. |
PARENT_ENTITY_NAME | VARCHAR(30) | Y | The name of the table in Millennium from which the record was retrieved. |
PARTITION_DT_TM | DATETIME | Y | The date/time corresponding to the qualifying encounters relation to a measurement period. |
PERSON_ID | DOUBLE | N | The primary key of the PERSON table for the person associated to the record. |
QRDA_VERSION | DOUBLE | N | Identifies the version of the QRDA program that was used to insert/update the record. VERSION = VERSION YEAR + (QRDA VERSION / 100) |
SRC_UPDT_DT_TM | DATETIME | Y | Indicates the actual time when the row was inserted or updated at the source. This column is used only for date extraction and will not be populated on the client site. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed. This column is used only for date extraction and will not be populated on the client site. |
UPDT_CNT | DOUBLE | Y | 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 | Y | 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_SOURCE | VARCHAR(50) | Y | The name of the program that updated the record last. |
UPDT_TASK | VARCHAR(50) | Y | 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 | VARCHAR(255) | Y | The value set name for the record. |
LH_EH_QRDA_ATTRIB
Column Section | Top of Page |
Table-level Detail
Description: | LH_EH_QRDA_ATTRIB |
Definition: | Stores attributes to the LH_EH_QRDA data for Eligible Hospital Quality Reporting Data Architecture. |
Table Type: | ACTIVITY |
Column Detail - LH_EH_QRDA_ATTRIB
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_DISPLAY | VARCHAR(300) | Y | The human readable display of the code. |
CODE_SYSTEM | VARCHAR(40) | Y | The OID of the coding system to which the code belongs. |
CODE_SYSTEM_NAME | VARCHAR(12) | Y | The name of the coding system to which the code belongs. |
CODE_SYSTEM_SDTC | VARCHAR(100) | Y | The OID of the value set to which the code belongs. |
CODE_TXT | VARCHAR(50) | Y | The qualifying code for the record. |
COMP_CODE | VARCHAR(50) | Y | The component code for an encounter attribute(Example: POA-Present On Admission component for a diagnosis). |
COMP_DISPLAY | VARCHAR(300) | Y | The component display name for an encounter attribute(Example: POA-Present On Admission component for a diagnosis). |
CONDITION_MASK | DOUBLE | Y | A bitmask that identifies what conditions are associated to the record. The conditions correspond to the following numbers: AMI - 1, CAC - 2, ED - 4, EHDI - 8, PC - 16, STK - 32, VTE - 64 |
EFFECTIVE_HIGH_DT_TM | DATETIME | Y | The high (end) date/time assocaited to the record. |
EFFECTIVE_HIGH_UTC_OFFSET | VARCHAR(5) | Y | Stores the UTC offset for the effective_high_dt_tm (e.g. -0500). |
EFFECTIVE_LOW_DT_TM | DATETIME | Y | The low (start) date/time associated to the record. |
EFFECTIVE_LOW_UTC_OFFSET | VARCHAR(5) | Y | Stores the UTC offset for the effective_low_dt_tm (e.g. -0500). |
ENCNTR_ID | DOUBLE | N | Unique generated number that identifies a single row on the ENCOUNTER table. |
EXTRACT_DT_TM | DATETIME | Y | The start date/time of the program that collected the record last. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifier of the health system to which the record belongs. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifier of the health system source to which the record belongs. |
HL7_TEMPLATE | VARCHAR(50) | Y | The HL7 template for the record. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_EH_QRDA_ATTRIB_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_EH_QRDA_ATTRIB table. |
LH_EH_QRDA_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_EH_QRDA table. |
LOGICAL_CONDITION_MASK | DOUBLE | Y | A bitmask that identifies which conditions the data should be submitted for. Possible values are: AMI - 1, CAC - 2, ED - 4, EHDI - 8, PC - 16, STK - 32, VTE - 64, HWR - 128, PCB - 256, PCM - 512, Opioid - 1024, Hybrid - 2048, HH - 4096, STEMI - 8192, GMCS - 16384, ORAE - 32768 |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
PARENT_ENTITY_ID | DOUBLE | N | Unique generated number that identifies a single row on the table identified in PARENT_ENTITY_NAME. |
PARENT_ENTITY_NAME | VARCHAR(30) | Y | The name of the table in Millennium from which the record was retrieved. |
PARTITION_DT_TM | DATETIME | Y | The date/time corresponding to the qualifying encounters relation to a measurement period. |
PERSON_ID | DOUBLE | N | Unique generated number that identifies a single row on the PERSON table. |
QRDA_VERSION | DOUBLE | N | Identifies the version of the QRDA program that was used to insert/update the record.VERSION = VERSION YEAR + (QRDA VERSION / 100) |
RESULT_DT_TM | DATETIME | Y | The date/time provided as a result of an assessment. |
RESULT_UNIT | VARCHAR(40) | Y | The units of the numeric result value for the record. |
RESULT_UTC_OFFSET | VARCHAR(5) | Y | Stores the UTC offset for the result_dt_tm (e.g. -0500) |
RESULT_VALUE | DOUBLE | N | The numeric result value for the record. |
SRC_UPDT_DT_TM | DATETIME | Y | Indicates the actual time when the row was inserted or updated at the source. This column is used only for date extraction and will not be populated on the client site. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed. This column is used only for date extraction and will not be populated on the client site. |
UPDT_CNT | DOUBLE | Y | 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 | Y | 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_SOURCE | VARCHAR(50) | Y | The name of the program that updated the record last. |
UPDT_TASK | VARCHAR(50) | Y | 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 | VARCHAR(255) | Y | The value set name for the record. |
LH_EH_QRDA_ISSUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_EH_QRDA_ISSUE |
Definition: | Stores possible errors within the Eligible Hospital Quality Reporting Data Architecture |
Table Type: | ACTIVITY |
Column Detail - LH_EH_QRDA_ISSUE
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_TXT | VARCHAR(50) | Y | The qualifying code for the record. |
CONDITION_MASK | DOUBLE | Y | A bitmask that identifies what conditions are associated to the record. The conditions correspond to the following numbers: AMI - 1, CAC - 2, ED - 4, EHDI - 8, PC - 16, STK - 32, VTE - 64 |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_BR_CCN_ID | DOUBLE | N | The CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | The Healthcare organization Number. |
D_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
ENCNTR_ID | DOUBLE | N | The primary key of the ENCOUNTER table for the encounter associated to the record. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifier of the health system to which the record belongs. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifier of the health system source to which the record belongs. |
ISSUE_FLAG | DOUBLE | Y | Identifies the type of issue. - 1= Patient MRN is missing 2= ED start date is null 3= Entry end is less than start 4= Encounter end equals start 5= Ambiguous documentation date. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_EH_QRDA_ISSUE_ID | DOUBLE | N | PRIMARY KEY |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARENT_ENTITY_ID | DOUBLE | N | The primary key of the table in Millennium from which the record was retrieved. |
PARENT_ENTITY_NAME | VARCHAR(30) | Y | The name of the table in Millennium from which the record was retrieved. |
PATIENT_IDENT | VARCHAR(50) | Y | The financial number alias associated to the person |
QRDA_VERSION | DOUBLE | N | Identifies the version of the QRDA program that was used to insert/update the record. VERSION = VERSION YEAR + (QRDA VERSION / 100) |
SECOND_ENCNTR_ID | DOUBLE | Y | The primary key of the ENCOUNTER table for the second encounter associated to the record, for situations where an encounter has potential submission issues because of shared or overlapping data with another encounter. |
SECOND_FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the second encounter, for situations where an encounter has potential submission issues because of shared or overlapping data with another encounter. |
SRC_UPDT_DT_TM | DATETIME | Y | Indicates the actual time when the row was inserted or updated at the source |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed |
UPDT_CNT | DOUBLE | Y | 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 | Y | 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_SOURCE | VARCHAR(50) | Y | The name of the program that updated the record last. |
UPDT_TASK | VARCHAR(50) | Y | 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 | VARCHAR(255) | Y | The value set name for the record. |
Relationship Detail - LH_EH_QRDA_ISSUE
Child Column in LH_EH_QRDA_ISSUE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID |
LH_HINT
Column Section | Top of Page |
Table-level Detail
Description: | LH_HINT |
Definition: | This table will hold reference data regarding the hints that queries should be using in the Lighthouse Reporting data model |
Table Type: | REFERENCE |
Column Detail - LH_HINT
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. |
CUSTOM_IND | DOUBLE | N | Identifies if the row has been updated manually on an individual client site |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data |
HINT_TXT | VARCHAR(2000) | Y | The exact hint text that we want to use for the script + measure |
LH_HINT_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_HINT table. |
MEASURE_NAME | VARCHAR(50) | N | The specific measure/query that is going to be hinted |
PROCESS_DT_TM | DATETIME | Y | The date/time the record wad first loaded into the table. |
SCRIPT_NAME | VARCHAR(40) | N | The script name that is associated to the Measure |
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_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
LH_IMPORT_QRDA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_IMPORT_QRDA |
Definition: | Stores data from QRDA Category 1 files being imported. |
Table Type: | ACTIVITY |
Column Detail - LH_IMPORT_QRDA
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_DISPLAY | VARCHAR(300) | Y | The human readable display of the code. |
CODE_SYSTEM | VARCHAR(40) | Y | The OID of the coding system the code is in. |
CODE_SYSTEM_NAME | VARCHAR(40) | Y | The name of the coding system the code is in. |
CODE_SYSTEM_SDTC | VARCHAR(100) | Y | The OID of the value set the code is in. |
CODE_TXT | VARCHAR(50) | Y | The qualifying code for the record. |
EC_IND | DOUBLE | N | Indicator for whether this measure was imported from an EC QRDA file. |
EFFECTIVE_HIGH_DT_TM | DATETIME | Y | The high (end) date time associated to the record |
EFFECTIVE_HIGH_UTC_OFFSET | VARCHAR(5) | Y | Contains the UTC offset for the effective_high_dt_tm (e.g. -0500). |
EFFECTIVE_LOW_DT_TM | DATETIME | Y | The low (start) date time associated to the record. |
EFFECTIVE_LOW_UTC_OFFSET | VARCHAR(5) | Y | Contains the UTC offset for the effective_low_dt_tm (e.g. -0500). |
EH_CONDITION_MASK | DOUBLE | N | A bitmask that identifies what conditions are associated to the record. The conditions correspond to the following numbers: AMI - 1, CAC - 2, ED - 4, EHDI - 8, PC - 16, STK - 32, VTE - 64 |
EH_IND | DOUBLE | N | Indicator for whether this measure was imported from an EH QRDA file. |
ENCNTR_ID | DOUBLE | N | The unique identifier for new encounters being imported onto the table. |
HL7_TEMPLATE | VARCHAR(50) | Y | The template defined by HL7 Implementation guide that encapsulates the record. |
LH_IMPORT_QRDA_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_IMPORT_QRDA table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
PERSON_ID | DOUBLE | N | The primary key of the PERSON table for the person associated to the record. |
QRDA_IMPORT_VERSION | VARCHAR(10) | Y | Identifier for which version of Import was used to insert the record. |
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_SOURCE | VARCHAR(50) | N | The name of the program that updated the record last. |
UPDT_TASK | VARCHAR(50) | 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 | VARCHAR(255) | Y | The name of the value set the record corresponds to. |
Relationship Detail - LH_IMPORT_QRDA
Parent Column in LH_IMPORT_QRDA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LH_IMPORT_QRDA_ID | LH_IMPORT_QRDA_ATTRIB | LH_IMPORT_QRDA_ID |