Table Detail Report

LH_E_AMI_2017_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_AMI_2017_METRICS
Definition: This table is used to store Hearing Screening metrics from the Lighthouse eMeasure. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_AMI_2017_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
AMI_DX_NOMEN VARCHAR(50) Y The nomenclature of the Acute Myocardial Infarction diagnosis.
AORTIC_BALLOON_NOMEN VARCHAR(50) Y The nomenclature of the Aortic Balloon Pump Insertion procedure
CARDIO_ARREST_NOMEN VARCHAR(50) Y The nomenclature of the Cardiopulmonary Arrest diagnosis
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DEN_IND DOUBLE Y Identifies if the patient is in the denominator for the AMI Metric.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ECG_PERF_NOMEN VARCHAR(50) Y The nomenclature of the Electrocardiogram
ECG_RESULT_NOMEN VARCHAR(50) Y The result of the Electrocardiogram
ED_ARRIVAL_DT_TM DATETIME Y Time the patient arrived the emergency department.
ED_ARRIVAL_UTC_DT_TM DATETIME Y Time the patient arrived the emergency department normalized to GMT.
ED_DEPART_DT_TM DATETIME Y Time the patient departed from the emergency department.
ED_DEPART_UTC_DT_TM DATETIME Y Time the patient departed from the emergency department. normalized to GMT
ED_ENCNTR_ID DOUBLE N Identifies the encounter is admitted through the ED
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCL_IND DOUBLE Y Identifies if the patient is in the denominator exclusion for the AMI Metric.
EXCP_IND DOUBLE Y Identifies if the patient is in the numerator exception for the AMI Metric.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIB_THERAPY_DT_TM DATETIME Y Identifies the FIRST date/time of an fibrinolytic therapy for the patient during ED or Inpatient encounter
FIB_THERAPY_UTC_DT_TM DATETIME Y Identifies the FIRST date/time of an fibrinolytic therapy for the patient during ED or Inpatient encounter normalized to GMT
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_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HOSP_SVC_IND DOUBLE N Indicates if the encounter should be excluded from the population due to the visit type
INTUBATION_NOMEN VARCHAR(50) Y The nomenclature of the Endotracheal Intubation procedure
IPP_IND DOUBLE N Identifies if the patient is in the population for the CAC Metric.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_AMI_2017_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_AMI_2017_METRICS 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.
NUM_IND DOUBLE Y Identifies if the patient is in the numerator for the AMI Metric.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAYER_CODE_TXT VARCHAR(20) Y Identifies the payer code for the encounter
PCI_PERF_DT_TM DATETIME Y The date/time when the PCI procedure was performed
PCI_PERF_NOMEN VARCHAR(50) Y The nomenclature of the PCI procedure.
PCI_PERF_UTC_DT_TM DATETIME Y The utc date/time when the PCI procedure was performed
PERSON_ETHNIC_CODE VARCHAR(50) Y Ethnicity code of the patient as per value set
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(500) Y Ethnicity code system OID of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(50) Y Ethnicity code display of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(50) Y Ethnicity code system name of the patient as per value set
PERSON_GENDER_CODE VARCHAR(50) Y Gender code of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(500) Y Gender code system OID of the patient as per value set
PERSON_GENDER_CODE_SYSTEM VARCHAR(50) Y Gender code display of the patient as per value set
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(50) Y Gender code system name of the patient as per value set
PERSON_PAYER_CODE VARCHAR(50) Y Represents the patient's member or subscriber identifier with respect to the payer
PERSON_PAYER_CODE_DISPLAY VARCHAR(500) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_PAYER_CODE_SYSTEM VARCHAR(50) Y Represents the patient's member or subscriber identifier display with respect to the payer
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(50) Y Represents the patient's member or subscriber identifier coding system name with respect to the payer
PERSON_RACE_CODE VARCHAR(50) Y Race code of the patient as per value set
PERSON_RACE_CODE_DISPLAY VARCHAR(500) Y Race code system OID of the patient as per value set
PERSON_RACE_CODE_SYSTEM VARCHAR(50) Y Race code display of the patient as per value set
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(50) Y Race code system name of the patient as per value set
PERSON_RACE_DESC VARCHAR(500) Y The list of all of a patient's races
TIMEZONE_IDENT DOUBLE Y Identifies the timezone index number associated with the quality measure.
TRANS_AMB_SURG_DT_TM DATETIME Y The date/time of the transfer from ambulatory surgical center
TRANS_AMB_SURG_UTC_DT_TM DATETIME Y The UTC date/time of the transfer from ambulatory surgical center.
TRANS_ED_DT_TM DATETIME Y The date/time of the transfer from emergency department location
TRANS_ED_UTC_DT_TM DATETIME Y The UTC date/time of the transfer from emergency department location.
TRANS_IP_DT_TM DATETIME Y The date/time of the transfer from inpatient
TRANS_IP_UTC_DT_TM DATETIME Y The UTC date/time of the transfer from inpatient.
TRANS_OP_DT_TM DATETIME Y The date/time of the transfer from oupatient
TRANS_OP_UTC_DT_TM DATETIME Y The UTC date/time of the transfer from oupatient.
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 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VENT_ASSIST_NOMEN VARCHAR(50) Y The nomenclature of the Ventricular Assist Device Placement procedure



Relationship Detail - LH_E_AMI_2017_METRICS


Child Column in LH_E_AMI_2017_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
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_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC 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
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_E_AMI_2018_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_AMI_2018_METRICS
Definition: Stores data gathered by the LH_E_AMI_2018 program.
Table Type: ACTIVITY





Column Detail - LH_E_AMI_2018_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
AMI_DX_NOMEN VARCHAR(60) Y The nomenclature of the Acute Myocardial Infarction diagnosis
AORTIC_BALLOON_NOMEN VARCHAR(60) Y The nomenclature of the Aortic Balloon Pump Insertion procedure
CARDIO_ARREST_NOMEN VARCHAR(60) Y The nomenclature of the Cardiopulmonary Arrest diagnosis
DEN_IND DOUBLE Y Identifies if the patient is in the denominator for the AMI Metric
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_METRIC_0_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_8A_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ECG_PERF_DT_TM DATETIME Y The date/time of the Electrocardiogram.
ECG_PERF_UTC_DT_TM DATETIME Y The utc date/time of the Electrocardiogram.
ED_ARRIVAL_DT_TM DATETIME Y Time the patient arrived the emergency department.
ED_ARRIVAL_UTC_DT_TM DATETIME Y Time the patient arrived the emergency department normalized to GMT.
ED_DEPART_DT_TM DATETIME Y Time the patient departed from the emergency department.
ED_DEPART_UTC_DT_TM DATETIME Y Time the patient departed from the emergency department. normalized to GMT
ED_ENCNTR_ID DOUBLE N Identifies the encounter is admitted through the ED
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCL_IND DOUBLE Y Identifies if the patient is in the denominator exclusion for the AMI Metric
EXCP_IND DOUBLE Y Identifies if the patient is in the numerator exception for the AMI Metric
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIB_THERAPY_DT_TM DATETIME Y Identifies the FIRST date/time of an fibrinolytic therapy for the patient during ED or Inpatient encounter
FIB_THERAPY_UTC_DT_TM DATETIME Y Identifies the FIRST date/time of an fibrinolytic therapy for the patient during ED or Inpatient encounter normalized to GMT
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_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
INTUBATION_NOMEN VARCHAR(60) Y The nomenclature of the Endotracheal Intubation procedure
IP_ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
IP_ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_AMI_2018_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_AMI_2018_METRICS 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.
NUM_IND DOUBLE Y Identifies if the patient is in the numerator for the AMI Metric
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PATIENT_IDENT VARCHAR(50) Y Identifies the earliest documented medical record number of the patient.
PCI_PERF_DT_TM DATETIME Y The date/time when the PCI procedure was performed
PCI_PERF_NOMEN VARCHAR(60) Y The nomenclature of the PCI procedure
PCI_PERF_UTC_DT_TM DATETIME Y The utc date/time when the PCI procedure was performed
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y Ethnicity code system OID of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y Gender code system OID of the patient as per value set
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_RACE_DESC VARCHAR(300) Y The list of all of a patient's races
TIMEZONE_TXT VARCHAR(100) Y The timezone of the record.
TRANS_AMB_SURG_DT_TM DATETIME Y The date/time of the transfer from ambulatory surgical center
TRANS_AMB_SURG_UTC_DT_TM DATETIME Y The UTC date/time of the transfer from ambulatory surgical center
TRANS_ED_DT_TM DATETIME Y The date/time of the transfer from emergency department location
TRANS_ED_UTC_DT_TM DATETIME Y The UTC date/time of the transfer from emergency department location
TRANS_IP_DT_TM DATETIME Y The date/time of the transfer from inpatient
TRANS_IP_UTC_DT_TM DATETIME Y The UTC date/time of the transfer from inpatient
TRANS_OP_DT_TM DATETIME Y The date/time of the transfer from oupatient
TRANS_OP_UTC_DT_TM DATETIME Y The UTC date/time of the transfer from oupatient
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 script name responsible for updating the record.
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.
VENT_ASSIST_NOMEN VARCHAR(60) Y The nomenclature of the Ventricular Assist Device Placement procedure



Relationship Detail - LH_E_AMI_2018_METRICS


Child Column in LH_E_AMI_2018_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
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_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_0_ID LH_D_METRIC D_METRIC_ID
D_METRIC_8A_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC 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
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_E_AMI_2019_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_AMI_2019_METRICS
Definition: Stores data gathered by the LH_E_AMI_2019 program.
Table Type: ACTIVITY





Column Detail - LH_E_AMI_2019_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
AMB_SURG_DT_TM DATETIME Y The date/time of the admission to ambulatory surgical center
AMI_DX_NOMEN VARCHAR(60) Y The nomenclature of the Acute Myocardial Infarction diagnosis
AORTIC_BALLOON_NOMEN VARCHAR(60) Y The nomenclature of the Aortic Balloon Pump Insertion procedure
CARDIO_ARREST_NOMEN VARCHAR(60) Y The nomenclature of the Cardiopulmonary Arrest diagnosis
DEN_IND DOUBLE Y Identifies if the patient is in the denominator for the AMI Metric
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_METRIC_8A_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ECG_PERF_DT_TM DATETIME Y The date/time of the Electrocardiogram
ED_ARRIVAL_DT_TM DATETIME Y Time the patient arrived the emergency department.
ED_DEPART_DT_TM DATETIME Y Time the patient departed from the emergency department.
ED_ENCNTR_ID DOUBLE N Identifies the encounter is admitted through the ED
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCEP_IND DOUBLE Y Identifies if the patient is in the numerator exception for the AMI Metric
EXCLUDE_IND DOUBLE Y Identifies if the patient is in the denominator exclusion for the AMI Metric
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIB_THERAPY_DT_TM DATETIME Y Identifies the FIRST date/time of an fibrinolytic therapy for the patient during ED or Inpatient encounter
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 Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HOSP_ARRIVAL_DT_TM DATETIME Y The date/time of first ED location or IP location
INTUBATION_NOMEN VARCHAR(60) Y The nomenclature of the Endotracheal Intubation procedure
IP_ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_AMI_2019_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_AMI_2019_METRICS 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.
NUM_IND DOUBLE Y Identifies if the patient is in the numerator for the AMI Metric
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PATIENT_IDENT VARCHAR(50) Y The financial number alias associated to the person
PCI_PERF_DT_TM DATETIME Y The date/time when the PCI procedure was performed
PCI_PERF_NOMEN VARCHAR(60) Y The nomenclature of the PCI procedure
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y Ethnicity code system OID of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y Gender code system OID of the patient as per value set
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_RACE_DESC VARCHAR(300) Y The list of all of a patient's races
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.
TIME_ZONE_TXT VARCHAR(100) Y The timezone of the record.
TRANS_ED_DT_TM DATETIME Y The date/time of the transfer from emergency department location
TRANS_IP_DT_TM DATETIME Y The date/time of the transfer from inpatient
TRANS_OP_DT_TM DATETIME Y The date/time of the transfer from oupatient
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 script name responsible for updating the record.
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.
VENT_ASSIST_NOMEN VARCHAR(60) Y The nomenclature of the Ventricular Assist Device Placement procedure



Relationship Detail - LH_E_AMI_2019_METRICS


Child Column in LH_E_AMI_2019_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
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_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_8A_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC 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
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_E_AMI_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_AMI_METRICS
Definition: This table is used to store AMI metrics from the Lighthouse eMeasure. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_AMI_METRICS


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.
ACUTE_EVOLVING_MI_IND DOUBLE Y Identifies if the result of the ECG was acute or evolving MI
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_SOURCE_FLAG DOUBLE Y Identifies the admission source of the encounter
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
AORTIC_BALLOON_30_IND DOUBLE Y Identifies if the patient had an aortic balloon pump within 30 minutes of ED or Inpatient (Whichever was first)
AORTIC_BALLOON_90_IND DOUBLE Y Identifies if the patient had an aortic balloon pump within 90 minutes of ED or Inpatient (Whichever was first)
ASPIRIN_ADV_EFFECTS_IND DOUBLE Y Identifies if the patient had an adverse effect to aspirin
ASPIRIN_ALLERGY_IND DOUBLE Y Identifies if the patient had an allergy to aspirin
ASPIRIN_DISCH_MED_REASON_IND DOUBLE Y Identifies if the patient had a medical reason for not prescribing aspirin at discharge
ASPIRIN_DISCH_PAT_REF_IND DOUBLE Y Identifies if the patient refused aspirin at discharge
ASPIRIN_INTOLERANCE_IND DOUBLE Y Identifies aspirin intolerance
ASPIRIN_MED_REASON_IND DOUBLE Y Identifies if the patient had a medical reason for not giving aspirin
ASPIRIN_PAT_REF_IND DOUBLE Y Identifies if the patient refused aspirin
CARDIOPULMONARY_30_DX_IND DOUBLE Y Identifies if the patient had a cardiopulmonary arrest within 30 minutes of ED or Inpatient (Whichever was first)
CARDIOPULMONARY_90_DX_IND DOUBLE Y Identifies if the patient had a cardiopulmonary arrest within 90 minutes of ED or Inpatient (Whichever was first)
CLINICAL_TRIAL_IND DOUBLE Y Identifies if the patient was in a clinical trial before or during the encounter
CMO_ORDER_2_IND DOUBLE Y Identifies if the patient had a Comfort Measures Only Order during the Inpatient Encounter. Used for AMI-10 calculations.
CMO_ORDER_IND DOUBLE Y Identifies if the patient had a Comfort Measures Only Order during the Inpatient Encounter.
CMO_PERF_2_IND DOUBLE Y Identifies if the patient had a Comfort Measures Only Performed during the Inpatient Encounter. Used for AMI-10 calculations.
CMO_PERF_IND DOUBLE Y Identifies if the patient had a Comfort Measures Only Performed during the Inpatient Encounter.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DEN_EXCEPTION_10_IND DOUBLE N Identifies if the encounter is a denominator exception for AMI-10
DEN_EXCEPTION_7_IND DOUBLE N Identifies if the encounter is a denominator exception for AMI-7a
DEN_EXCEPTION_8_IND DOUBLE N Identifies if the encounter is a denominator exception for AMI-8a
DISCHARGE_DISPOSITION_FLAG DOUBLE Y Identifies the discharge disposition of the encounter
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_MED_ASPIRIN_IND DOUBLE Y Identifies that the patient received aspirin at discharge
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISCH_MED_WARFARIN_IND DOUBLE Y Identifies if the patient was prescribed warfarin at discharge
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Defines the discharge disposition of the encounter.
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
D_PRIN_DX_ID DOUBLE N Identifies the principal diagnosis code of the encounter
ECG_DT_TM DATETIME Y Identifies the FIRST date/time of an ECG performed on the patient during ED or Inpatient encounter
ECG_UTC_DT_TM DATETIME Y Identifies the FIRST date/time of an ECG performed on the patient during ED or Inpatient encounter normalized to GMT
ED_ARRIVAL_DT_TM DATETIME Y Time the patient arrived the emergency department.
ED_ARRIVAL_UTC_DT_TM DATETIME Y Time the patient arrived the emergency department normalized to GMT.
ED_DEPART_DT_TM DATETIME Y Time the patient departed from the emergency department.
ED_DEPART_UTC_DT_TM DATETIME Y Time the patient departed from the emergency department. normalized to GMT
ED_ENCNTR_ID DOUBLE N Identifies the encounter is admitted through the ED
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENDOTRACHEAL_INTUBATION_30_IND DOUBLE Y Identifies if the patient had an endotracheal intubation within 30 minutes of ED or Inpatient (Whichever was first)
ENDOTRACHEAL_INTUBATION_90_IND DOUBLE Y Identifies if the patient had an endotracheal intubation within 90 minutes of ED or Inpatient (Whichever was first)
EXCLUDE_10_IND DOUBLE N Identifies if the encounter is excluded for AMI-10
EXCLUDE_2_IND DOUBLE N Identifies if the encounter is excluded for AMI-2
EXCLUDE_7_IND DOUBLE N Identifies if the encounter is excluded for AMI-7a
EXCLUDE_8_IND DOUBLE N Identifies if the encounter is excluded for AMI-8a
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIB_MED_REASON_IND DOUBLE Y Identifies if there was a medical reason for not giving fibrinolytic therapy within 30 minutes of ED or Inpatient (Whichever was first)
FIB_PAT_REF_IND DOUBLE Y Identifies if the patient refused fibrinolytic therapy within 30 minutes of ED or Inpatient (Whichever was first)
FIB_THERAPY_DT_TM DATETIME Y Identifies the FIRST date/time of an fibrinolytic therapy for the patient during ED or Inpatient encounter
FIB_THERAPY_UTC_DT_TM DATETIME Y Identifies the FIRST date/time of an fibrinolytic therapy for the patient during ED or Inpatient encounter normalized to GMT
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LBBB_IND DOUBLE Y Identifies if the result of the ECG was LBBB
LDL_100_DT_TM DATETIME Y Identifies the date/time that an LDL result < 100 was received for the patient
LDL_100_UTC_DT_TM DATETIME Y Identifies the date/time that an LDL result < 100 was received for the patient normalized to GMT
LH_E_AMI_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_AMI_METRICS 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.
MED_NOT_DONE_HOLD_IND DOUBLE Y Identifies if the reason for not administering medication was a hold
NOT_IN_DEN_7_IND DOUBLE N Identifies if the encounter is not in the denominator for AMI-7a
NOT_IN_DEN_8_IND DOUBLE N Identifies if the encounter is not in the denominator for AMI-8a
NUMERATOR_10_IND DOUBLE N Identifies if the encounter is in the numerator for AMI-10
NUMERATOR_2_IND DOUBLE N Identifies if the encounter is in the numerator for AMI-2
NUMERATOR_7_IND DOUBLE N Identifies if the encounter is in the numerator for AMI-7a
NUMERATOR_8_IND DOUBLE N Identifies if the encounter is in the numerator for AMI-8a
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAYER_CODE_TXT VARCHAR(20) Y identifies the payer code value that is associated to the patient for QRDA file payer information.
PCI_MED_REASON_IND DOUBLE Y Identifies if there was a medical reason for not giving PCI within 30 minutes of ED or Inpatient (Whichever was first)
PCI_PAT_REF_IND DOUBLE Y Identifies if the patient refused PCI within 30 minutes of ED or Inpatient (Whichever was first)
PCI_PERF_DT_TM DATETIME Y Identifies the FIRST date/time of PCI performed on the patient during ED or Inpatient encounter
PCI_PERF_UTC_DT_TM DATETIME Y Identifies the FIRST date/time of PCI performed on the patient during ED or Inpatient encounter normalized to GMT
POPULATION_1_IND DOUBLE Y Identifies if the patient is in the population for the AMI metrics: AMI-2, AMI-7a, and AMI-8a
POPULATION_2_IND DOUBLE Y Identifies if the patient is in the population for the AMI metric: AMI-10
STATIN_DISCH_IND DOUBLE Y Identifies if patients had statin prescribed at discharge
STATIN_DISCH_MED_RES_IND DOUBLE Y Identifies if there was a medical reason for not giving statin at discharge
STATIN_DISCH_PAT_REF_IND DOUBLE Y Identifies if the patient refused statin at discharge
STATIN_DISCH_SYSTEM_RES_IND DOUBLE Y Identifies if there was a system reason for not giving statin at discharge
STATIN_MED_RES_IND DOUBLE Y Identifies if there was a medical reason for not giving statin
STATIN_PAT_REF_IND DOUBLE Y Identifies if the patient refused statin
STATIN_SYSTEM_RES_IND DOUBLE Y Identifies if there was a system reason for not giving statin
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.
VENTRICULAR_ASSIST_DEV_30_IND DOUBLE Y Identifies if the patient had a ventricular assist device within 30 minutes of ED or Inpatient (Whichever was first)
VENTRICULAR_ASSIST_DEV_90_IND DOUBLE Y Identifies if the patient had a ventricular assist device within 90 minutes of ED or Inpatient (Whichever was first)



Relationship Detail - LH_E_AMI_METRICS


Child Column in LH_E_AMI_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
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_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_PRIN_DX_ID LH_D_DIAGNOSIS D_DIAGNOSIS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DIAGNOSIS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC 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
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_E_APHYBD_2024_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures All Payer Hybrid 2024 Metrics
Definition: Stores data gathered by the LH_E_APHYBD_2024 script. The data consists of HWR and HWM 2024 Metrics for State of Maryland (ALL_PAYER).
Table Type: ACTIVITY





Column Detail - LH_E_APHYBD_2024_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
BICARB_LAB_RSLT_DT_TM DATETIME Y The date/time of the first bicarbonate lab test for the episode of care.
BICARB_LAB_RSLT_TXT VARCHAR(30) Y The result of the first bicarbonate lab test for the episode of care.
BODY_TEMP_RSLT_DT_TM DATETIME Y The date/time of the first body temperature recorded for the episode of care.
BODY_TEMP_RSLT_TXT VARCHAR(30) Y The result of the first body temperature recorded for the episode of care.
BODY_WGT_RSLT_DT_TM DATETIME Y The date/time of the first body weight recorded for the episode of care.
BODY_WGT_RSLT_TXT VARCHAR(30) Y The result of the first body weight recorded for the episode of care.
CREAT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first creatinine lab test for the episode of care.
CREAT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first creatinine lab test for the episode of care.
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
D_ADMIT_BUILDING_ID DOUBLE N Dimension ID for admit building.
D_ADMIT_FACILITY_ID DOUBLE N Dimension ID for admit facility.
D_ADMIT_NURSE_UNIT_ID DOUBLE N Dimension ID for admit nurse unit.
D_ADMIT_SRC_ID DOUBLE N Dimension ID for admit source.
D_ADMIT_TYPE_ID DOUBLE N Dimension ID for admit type.
D_ATTEND_PRSNL_ID DOUBLE N Dimension ID for attending physician.
D_BR_CCN_ID DOUBLE N Dimension ID for CCN.
D_BR_HCO_ID DOUBLE N Dimension ID for HCO.
D_DISCHARGE_BUILDING_ID DOUBLE N Dimension ID for discharge building.
D_DISCHARGE_FACILITY_ID DOUBLE N Dimension ID for discharge facility.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N Dimension ID for discharge nurse unit.
D_DISCH_DISP_ID DOUBLE N Dimension ID for discharge disposition.
D_ENCNTR_TYPE_ID DOUBLE N Dimension ID for encounter type.
D_METRIC_0_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N Dimension ID for person data.
ED_ARRIVAL_DT_TM DATETIME Y The start of the emergency encounter.
ED_DEPART_DT_TM DATETIME Y The end of the emergency encounter.
ED_ENCNTR_ID DOUBLE N The ID of the emergency encounter associated to the record.
ENCNTR_ID DOUBLE N The ID of the qualifying 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 Financial Number of the record.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GLUC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first glucose lab test for the episode of care.
GLUC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first glucose lab test for the episode of care.
HCT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first hematocrit lab test for the episode of care.
HCT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first hematocrit lab test for the episode of care.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HEART_RATE_RSLT_DT_TM DATETIME Y The date/time of the first heart rate recorded for the episode of care.
HEART_RATE_RSLT_TXT VARCHAR(30) Y The result of the first heart rate recorded for the episode of care.
HIC_MBI_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
HWM_IPP_IND DOUBLE Y Indicates that the encounter is in Initial population for Hybrid Mortality Measure.
HWM_RESULT_IND DOUBLE Y Indicates that at least one of the results exists for Hybrid Mortality Measure.
HWR_IPP_IND DOUBLE Y Indicates that the encounter is in Initial population for Hybrid Re-admission Measure.
HWR_RESULT_IND DOUBLE Y Indicates that at least one of the results exists for Hybrid Re-admission Measure.
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_APHYBD_2024_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_APHYBD_2024_METRICS 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.
O2_SAT_RSLT_DT_TM DATETIME Y The date/time of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
O2_SAT_RSLT_TXT VARCHAR(30) Y The result of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
OBS_SERV_ARRIVAL_DT_TM DATETIME Y The start of the observation encounter.
OBS_SERV_DEPART_DT_TM DATETIME Y The end of the observation encounter.
OBS_SERV_ENCNTR_ID DOUBLE N The ID of the observation services encounter associated to the record.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PATIENT_IDENT VARCHAR(50) Y Identifies the earliest documented medical record number of the patient.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y String to store ethnicity display.
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y String to store gender display.
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y String to store payer display.
PERSON_RACE_DESC VARCHAR(300) Y String to store multiple races.
PLATELET_LAB_RSLT_DT_TM DATETIME Y The date/time of the first platelet count recorded for the episode of care.
PLATELET_LAB_RSLT_TXT VARCHAR(30) Y The result of the first platelet count recorded for the episode of care.
POTAS_LAB_RSLT_DT_TM DATETIME Y The date/time of the first potassium lab test for the episode of care.
POTAS_LAB_RSLT_TXT VARCHAR(30) Y The result of the first potassium lab test for the episode of care.
RESP_RATE_RSLT_DT_TM DATETIME Y The date/time of the first respiratory rate recorded for the episode of care.
RESP_RATE_RSLT_TXT VARCHAR(30) Y The result of the first respiratory rate recorded for the episode of care.
SBP_RSLT_DT_TM DATETIME Y The date/time of the first systolic blood pressure recorded for the episode of care.
SBP_RSLT_TXT VARCHAR(30) Y The result of the first systolic blood pressure recorded for the episode of care.
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
SOD_LAB_RSLT_DT_TM DATETIME Y The date/time of the first sodium lab test for the episode of care.
SOD_LAB_RSLT_TXT VARCHAR(30) Y The result of the first sodium lab test for the episode of care.
SRC_UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated to be preserved during extracts.
SRC_UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record to be preserved during extracts.
TIMEZONE_TXT VARCHAR(300) Y The timezone of the record in ""America/Chicago"" format.
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 script name responsible for updating the record.
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.
WBC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first white blood cells count lab test for the episode of care.
WBC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first white blood cells count lab test for the episode of care.



Relationship Detail - LH_E_APHYBD_2024_METRICS


Child Column in LH_E_APHYBD_2024_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
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_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_0_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC 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
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID