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