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 |