Table Detail Report
LH_F_AMI_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_AMI_METRICS |
Definition: | This table is used to store metrics for the Lighthouse Acute Myocardial Infarction quality measure. |
Table Type: | ACTIVITY |
Column Detail - LH_F_AMI_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACEI_ARB_MASK | DOUBLE | Y | Identifies if the patient was prescribed ACEI or ARB at discharge. |
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. |
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. |
ADM_SRC_FLAG | DOUBLE | Y | Identifies the admission source for the patient. |
AMI10_REJECT_IND | DOUBLE | Y | Identifies if the patient was rejected from the measure. |
AMI1_ADM_SRC_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI1_ASA_24H_ARR_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI1_DISC_DISP_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI1_NO_ASA_ARR_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI1_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMI2_ASP_AT_DISC_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI2_DISC_DISP_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI2_NO_ASP_DISC_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI2_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMI3_ACEI_DISC_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI3_ARB_DISC_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI3_DISC_DISP_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI3_LVEF_MOD_SEVERE_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI3_NO_ACEI_ARB_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI3_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMI4_DISC_DISP_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI4_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMI4_SMOKE_COUNS_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI4_SMOKE_HX_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI5_BETA_DISC_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI5_DISC_DISP_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI5_NO_BETA_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI5_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMI7_ADM_SRC_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI7_FIB_DELAY_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI7_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMI8_ADM_SRC_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI8_PCI_DELAY_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI8_PCI_PRIM_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI8_PCI_PROC_CODE_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI8_PCI_ST_DT_TM | DATETIME | Y | Identifies patients that qualify for this AMI metric. |
AMI8_PCI_ST_UTC_DT_TM | DATETIME | Y | Identifies patients that qualify for this AMI metric. |
AMI8_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMI9_ADM_SRC_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI9_DISC_DISP_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI9_DISC_DISP_EXP_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI9_REJECT_IND | DOUBLE | Y | Identifies patients rejected for AMI-9 |
AMIT1_DISC_DISP_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT1_LDL_IN_HOSP_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT1_LDL_ND_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT1_LDL_POST_DISC_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT1_LDL_PRE_ARR_QL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT1_LDL_PRE_ARR_QNT_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT1_PRE_ARR_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT1_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMIT2_DISC_DISP_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT2_LDL_QNT_RESULT | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT2_LDL_QNT_VLD_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT2_LDL_RESULT_QL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT2_LDL_RX_DISC_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT2_REASON_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMIT2_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the AMI metric. |
AMI_AGE_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI_BASE_POPULATION_IND | DOUBLE | Y | Identifies patients that qualify for the base AMI population. |
AMI_CLIN_TRIAL_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI_CMO_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI_ED_TRANS_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI_FIB_ADMIN_DT_TM | DATETIME | Y | Identifies patients that qualify for this AMI metric. |
AMI_FIB_ADMIN_FLAG | DOUBLE | Y | Identifies if the patient has fibrinolytic administration. 0 - False, 1 - True, 999 - Missing. |
AMI_FIB_ADMIN_UTC_DT_TM | DATETIME | Y | Identifies patients that qualify for this AMI metric. |
AMI_LOS_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
AMI_ST_LBBB_IND | DOUBLE | Y | Identifies patients that qualify for this AMI metric. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility normalized to GMT. |
ASA_24H_ARR_FLAG | DOUBLE | Y | Identifies if the patient received aspirin within 24 hours of arrival. |
ASP_AT_DISC_FLAG | DOUBLE | Y | Identifies if the patient was prescribed aspirin at discharge. |
BETA_BLK_DISC_FLAG | DOUBLE | Y | Identifies if the patient had a beta blocker at discharge. |
CLIN_TRIAL_EXCL_FLAG | DOUBLE | Y | Identifies if the patient is excluded from the measure due to participation in a clinical trial. |
CMO_ORDER_DT_TM | DATETIME | Y | Identifies the date/time on which comfort measures were ordered. |
CMO_ORDER_UTC_DT_TM | DATETIME | Y | Identifies the date/time on which comfort measures were ordered. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
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. |
DISC_DISP_FLAG | DOUBLE | Y | Identifies the discharge disposition of the patient. |
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_AMI10_METRIC_ID | DOUBLE | N | The unique identifier for the measure. |
D_AMI1_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI1 metric. |
D_AMI2_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI2 metric. |
D_AMI3_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI3 metric. |
D_AMI4_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI4 metric. |
D_AMI5_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI5 metric. |
D_AMI7A_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI7A metric. |
D_AMI7_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI7 metric. |
D_AMI8A_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI8A metric. |
D_AMI8_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI8 metric. |
D_AMI9_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMI9 metric. |
D_AMIT1_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMIT1A metric. |
D_AMIT2_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the AMIT2 metric. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
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 | The conditions under which the patient left the facility at the time of discharge. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table. |
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_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Identifies the principle procedure associated with the encounter. |
ED_TRANS_EXCL_FLAG | DOUBLE | Y | Identifies if the patient is excluded from the measure due to a transfer from an ED. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_10_IND | DOUBLE | Y | Identifies if the patient was excluded from the measure. |
EXCLUDE_1_IND | DOUBLE | Y | Identifies patients excluded from AMI-1 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies patients excluded from AMI-2 |
EXCLUDE_3_IND | DOUBLE | Y | Identifies patients excluded from AMI-3 |
EXCLUDE_4_IND | DOUBLE | Y | Identifies patients excluded from AMI-4 |
EXCLUDE_5_IND | DOUBLE | Y | Identifies patients excluded from AMI-5 |
EXCLUDE_7_IND | DOUBLE | Y | Identifies patients excluded from AMI-7 and AMI-7a |
EXCLUDE_8_IND | DOUBLE | Y | Identifies patients excluded from AMI-8 and AMI-8a |
EXCLUDE_9_IND | DOUBLE | Y | Identifies patients excluded from AMI-9 |
EXCLUDE_T1A_IND | DOUBLE | Y | Identifies patients excluded from AMI-T1a |
EXCLUDE_T2_IND | DOUBLE | Y | Identifies patients excluded from AMI-T2 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FIB_DELAY_EXCL_FLAG | DOUBLE | Y | Identifies if there is a valid reason documented for fibrinolytic delay. |
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. |
F_AMI_METRICS_ID | DOUBLE | N | Unique identifier for the lighthouse AMI metrics |
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_TRANSFER_FLAG | DOUBLE | Y | Identifies if the patient transferred from another acute care facility. |
INIT_ECG_INTERP_FLAG | DOUBLE | Y | Identifies if the patient had an elevated ST-segment or LBBB. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LDL_IN_HOSP_FLAG | DOUBLE | Y | Identifies if the patient had an LDL-c during this visit. |
LDL_LT_100_FLAG | DOUBLE | Y | Identifies if the patient had an LDL-c result less than 100. |
LDL_ND_EXCL_FLAG | DOUBLE | Y | Identifies if there is a valid reason documented for not receiving an LDL-c. |
LDL_POST_DISC_FLAG | DOUBLE | Y | Identifies if there is a plan for a post-discharge LDL-c. |
LDL_PRE_ARR_QL_FLAG | DOUBLE | Y | Identifies if the patient had a pre-arrival qualitative LDL-c. |
LDL_PRE_ARR_QNT_FLAG | DOUBLE | Y | Identifies if the patient had a pre-arrival quantitative LDL-c. |
LDL_RESULT_QL_FLAG | DOUBLE | Y | Identifies if there is a qualitative LDL-c result. |
LDL_RX_DISC_FLAG | DOUBLE | Y | Identifies if a lipid-lowering agent was prescribed at discharge. |
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. |
LVEF_MOD_SEVERE_FLAG | DOUBLE | Y | Identifies if the patient has moderate or severe systolic dysfunction. |
NHIQM_VERSION | DOUBLE | Y | Identifies the version of NHIQM for which the patient qualifies |
NO_ACEI_ARB_EXCL_FLAG | DOUBLE | Y | Identifies if there is a valid reason for not prescribing ACEI or ARB at discharge. |
NO_ASA_ARR_EXCL_FLAG | DOUBLE | Y | Identifies if there is a reason documented for not giving aspirin within 24 hours of arrival. |
NO_ASP_DISC_EXCL_FLAG | DOUBLE | Y | Identifies if there is a reason documented for not prescribing aspirin at discharge. |
NO_BETA_BLK_EXCL_FLAG | DOUBLE | Y | Identifies if a valid reason was documented for not prescribing a beta blocker at discharge. |
NO_LPD_LOWER_EXCL_FLAG | DOUBLE | Y | Identifies if there is a valid reason for not prescribing a lipid-lowering agent. |
NO_STATIN_REASON_FLAG | DOUBLE | Y | Identifies if there was a documented reason for not prescribing statin at discharge. |
NUMERATOR_10_IND | DOUBLE | Y | Identifies if the patient qualified for the measure. |
NUMERATOR_1_IND | DOUBLE | Y | Identifies patients that qualify for AMI-1 |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients that qualify for AMI-2 |
NUMERATOR_3_IND | DOUBLE | Y | Identifies patients that qualify for AMI-3 |
NUMERATOR_4_IND | DOUBLE | Y | Identifies patients that qualify for AMI-4 |
NUMERATOR_5_IND | DOUBLE | Y | Identifies patients that qualify for AMI-4 |
NUMERATOR_7A_IND | DOUBLE | Y | Identifies patients that qualify for AMI-4 |
NUMERATOR_8A_IND | DOUBLE | Y | Identifies patients that qualify for AMI-4 |
NUMERATOR_9_IND | DOUBLE | Y | Identifies patients that qualify for AMI-4 |
NUMERATOR_T1A_IND | DOUBLE | Y | Identifies patients that qualify for AMI-4 |
NUMERATOR_T2_IND | DOUBLE | Y | Identifies patients that qualify for AMI-4 |
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 |
PCI_DELAY_EXCL_FLAG | DOUBLE | Y | Identifies if there is a documented reason for delay in PCI. |
PCI_PRIM_EXCL_FLAG | DOUBLE | Y | Identifies if the PCI was the primary procedure. |
PRE_ARR_MED_EXCL_FLAG | DOUBLE | Y | Identifies if the patient is excluded due to receiving a lipid-lowering agent prior to arrival |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed normalized to GMT. |
SMOKE_COUNS_FLAG | DOUBLE | Y | Identifies if the patient received smoking cessation counseling |
SMOKE_HX_FLAG | DOUBLE | Y | Identifies if the patient has a history of smoking. |
STATIN_AT_DISC_FLAG | DOUBLE | Y | Identifies if the patient was prescribed statin at discharge. |
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. |
Relationship Detail - LH_F_AMI_METRICS
Child Column in LH_F_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_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_DIAGNOSIS_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_AMI1_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI2_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI3_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI4_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI5_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI7A_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI7_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI8A_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI8_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMI9_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMIT1_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_AMIT2_METRIC_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 | |
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 | |
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 | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_ANEMIA_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_ANEMIA_METRICS |
Definition: | Contains data related to the Lighthouse Anemia metrics. |
Table Type: | ACTIVITY |
Column Detail - LH_F_ANEMIA_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. |
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. |
ANEMIA_BSA_RESULT | DOUBLE | Y | Identifies the patients bsa level. |
ANH_DOC_IND | DOUBLE | Y | Identifies patients that had ANH documented |
ANTIFIB_ADMIN_IND | DOUBLE | Y | Identifies patients that had an antifibrinolytic ordered and administered. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility; normalized to GMT. |
BASE_POPULATION_IND | DOUBLE | Y | Identified patients that qualify for the lighthouse stroke metric. |
BLOOD_TRANSFUSE_CNT | DOUBLE | Y | Identifies the number of blood transfusions for the patient. |
BLOOD_TRANSFUSE_IND | DOUBLE | Y | Identifies patients with a blood transfusion. |
CELL_SALVAGE_DOC_IND | DOUBLE | Y | Identifies patients that had cell salvage documented. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DAY_0_HGB_RESULT | DOUBLE | Y | Identifies the hemoglobin result on the day of surgery. |
DAY_1_HGB_RESULT | DOUBLE | Y | Identifies the hemoglobin result on the day after surgery. |
DAY_2_HGB_RESULT | DOUBLE | Y | Identifies the hemoglobin result two days after surgery. |
DAY_3_HGB_RESULT | DOUBLE | Y | Identifies the hemoglobin result three days after surgery. |
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. |
DISCH_HGB_RESULT | DOUBLE | Y | Identifies the hemoglobin result on the day of 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 circumstance under which the patient was admitted or will be admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | The most recent attending physician associated with the encounter. |
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 | The conditions under which the patient left the facility at the time of discharge. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table. |
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_01_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_02_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_03_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_04_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_05_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_06_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_07_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_08_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_09_ID | DOUBLE | N | Identifies a metric associated with falls. NForeign key to the lh_d_metric table. |
D_METRIC_10_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_11_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_12_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_13_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_14_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_15_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_16_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_17_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_18_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_19_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_20_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | The principal diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | The principal procedure associated with the encounter. |
D_PROC_GROUP_ID | DOUBLE | N | Identifies the patient's anemia procedure grouping. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
ENROLLED_AMP_IND | DOUBLE | Y | Identifies patients that are enrolled in an anemia management program. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
F_ANEMIA_METRICS_ID | DOUBLE | N | Unique identifier for the lighthouse stroke metrics. |
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. |
HGB_21_30_DAYS_IND | DOUBLE | Y | Identifies patients that had their hemoglobin lab completed 21-30 days prior to the date of the procedure. |
HIGH_PREOP_HGB_RESULT | DOUBLE | Y | Identifies the highest pre-op hemoglobin result for the patient up to 30 days prior to the procedure. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the 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. |
LOW_POSTOP_HGB_RESULT | DOUBLE | Y | Identifies the lowest post-op hemoglobin result up to 2 days post-op. |
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 |
POSTOP_ESA_RECD_IND | DOUBLE | Y | Identifies patients that received ESA after surgery. |
POSTOP_IRON_RECD_IND | DOUBLE | Y | Identifies patients that received IV Iron after surgery. |
PREOP_ESA_RECD_IND | DOUBLE | Y | Identifies patients that received ESA up to 45 days prior to surgery. |
PREOP_IRON_RECD_IND | DOUBLE | Y | Identifies patients that received IV iron up to 45 days prior to surgery. |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed; normalized to GMT |
PROC_ACTUAL_DT_TM | DATETIME | Y | Identifies the date/time on which the procedure actually occurred. |
PROC_ACTUAL_UTC_DT_TM | DATETIME | Y | Identifies the date/time on which the procedure actually occurred. |
PROC_GROUP_MEANING | VARCHAR(50) | Y | Identifies the patient's anemia procedure grouping. |
PROC_REQUEST_DT_TM | DATETIME | Y | Identifies the date for which the procedure was requested. |
PROC_REQUEST_UTC_DT_TM | DATETIME | Y | Identifies the date for which the procedure was requested. |
PROC_SCHED_DT_TM | DATETIME | Y | Identifies the date on which the procedure was scheduled. |
PROC_SCHED_UTC_DT_TM | DATETIME | Y | Identifies the date on which the procedure was scheduled. |
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. |
URGENT_SCHED_REASON_IND | DOUBLE | Y | URGENT_SCHED_REASON_IND column |
Relationship Detail - LH_F_ANEMIA_METRICS
Child Column in LH_F_ANEMIA_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_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_DIAGNOSIS_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_01_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_02_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_03_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_04_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_05_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_06_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_07_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_08_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_09_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_10_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_11_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_12_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_13_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_14_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_15_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_16_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_17_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_18_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_19_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_20_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 | |
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 | |
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 | |
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 | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_CAC_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_CAC_METRICS |
Definition: | This table is used to store metrics for the Lighthouse Children?s Asthma quality measure. |
Table Type: | ACTIVITY |
Column Detail - LH_F_CAC_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. |
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. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility normalized to GMT. |
CAC1_NO_REL_REASON_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC1_REL_ADM_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC2_CORT_ADM_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC2_NO_CORT_REASON_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC3_DISC_DISP_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC3_HMPC_CONT_USE_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC3_HMPC_FOLLOW_UP_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC3_HMPC_GIVEN_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC3_HMPC_PRESENT_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC3_HMPC_REL_USE_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC3_HMPC_RESC_ACT_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC3_HMPC_TRIGGERS_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC_1_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the CAC metric. |
CAC_2_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the CAC metric. |
CAC_3_REJECT_IND | DOUBLE | Y | Identifies patients that were rejected for the CAC metric. |
CAC_AGE_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC_BASE_POPULATION_IND | DOUBLE | Y | Identifies patients that qualify for the base CAC population. |
CAC_CLIN_TRIAL_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CAC_LOS_EXCL_IND | DOUBLE | Y | Identifies patients that qualify for this CAC metric. |
CLIN_TRIAL_EXCL_FLAG | DOUBLE | Y | Identifies if the patient is excluded from the measure due to participation in a clinical trial. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
CORT_ADMIN_FLAG | DOUBLE | Y | Identifies if corticosteroids were administered. |
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. |
DISC_DISP_FLAG | DOUBLE | Y | Identifies the discharge disposition of the patient. |
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_CAC_1_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the CAC metric. |
D_CAC_2_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the CAC metric. |
D_CAC_3_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the CAC metric. |
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 | The conditions under which the patient left the facility at the time of discharge. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table. |
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_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Identifies the principle procedure associated with the encounter. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_1_IND | DOUBLE | Y | Identifies patients excluded from CAC-1 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies patients excluded from CAC-2 |
EXCLUDE_3_IND | DOUBLE | Y | Identifies patients excluded from CAC-3 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
F_CAC_METRICS_ID | DOUBLE | N | Unique identifier for the lighthouse Children?s Asthma Metrics |
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. |
HMPC_GIVEN_FLAG | DOUBLE | Y | Identifies if the HMPC was given. |
HMPC_GIVEN_MASK | DOUBLE | Y | Identifies the attributes of the HMPC that were documented. |
HMPC_PRESENT_FLAG | DOUBLE | Y | Identifies if the HMPC is present. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the 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. |
NHIQM_VERSION | DOUBLE | Y | Identifies the version of NHIQM for which the patient qualifies |
NO_CORT_REASON_FLAG | DOUBLE | Y | Identifies if there is a documented reason for not administering corticosteroids |
NO_RELIEVERS_REASON_FLAG | DOUBLE | Y | Identifies if there is a documented reason for not administering relievers |
NUMERATOR_1_IND | DOUBLE | Y | Identifies patients that qualify for CAC-1 |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients that qualify for CAC-2 |
NUMERATOR_3_IND | DOUBLE | Y | Identifies patients that qualify for CAC-3 |
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 |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed normalized to GMT. |
RELIEVERS_ADMIN_FLAG | DOUBLE | Y | Identifies if the patient had relievers administered |
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. |
Relationship Detail - LH_F_CAC_METRICS
Child Column in LH_F_CAC_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_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_DIAGNOSIS_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_CAC_3_METRIC_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 | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_CHF_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_CHF_METRICS |
Definition: | This table is used to store metrics for the Lighthouse Congestive Heart Failure quality measure. |
Table Type: | ACTIVITY |
Column Detail - LH_F_CHF_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACEI_ARB_MASK | DOUBLE | Y | Identifies if the patient was prescribed an ACEI or ARB at discharge. |
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. |
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. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility normalized to GMT. |
CLIN_TRIAL_EXCL_FLAG | DOUBLE | Y | Identifies if the patient is excluded from the measure due to participation in a clinical trial. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_INSTRUCTION_MASK | DOUBLE | Y | Identifies the discharge instructions provided to the patient. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged normalized to GMT. |
DISC_DISP_FLAG | DOUBLE | Y | Identifies the discharge disposition of the patient. |
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_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 | The conditions under which the patient left the facility at the time of discharge. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table. |
D_HF1_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the HF1 metric. |
D_HF2_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the HF2 metric. |
D_HF3_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the HF3 metric. |
D_HF4_METRIC_ID | DOUBLE | N | Identifies the patient population associated with the HF4 metric. |
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_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Identifies the principle procedure associated with the encounter. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_1_IND | DOUBLE | Y | Identifies patients excluded from HF-1 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies patients excluded from HF-2 |
EXCLUDE_3_IND | DOUBLE | Y | Identifies patients excluded from HF-3 |
EXCLUDE_4_IND | DOUBLE | Y | Identifies patients excluded from HF-4 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
F_CHF_METRICS_ID | DOUBLE | N | Unique identifier for the lighthouse CHF metrics. |
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. |
HF1_DISCH_DISP_INCL_IND | DOUBLE | Y | Identifies patients with the appropriate discharge disposition for the HF1 metric. |
HF1_DI_ACTIVITY_IND | DOUBLE | Y | Identifies patients with written discharge instructions for activity. |
HF1_DI_DIET_IND | DOUBLE | Y | Identifies patients with written discharge instructions for diet. |
HF1_DI_FOLLOWUP_IND | DOUBLE | Y | Identifies patients with written discharge instructions for a follow-up visit. |
HF1_DI_MEDICATIONS_IND | DOUBLE | Y | Identifies patients with written discharge instructions for medications. |
HF1_DI_SYMPTOMS_IND | DOUBLE | Y | Identifies patients with written discharge Identifies patients with written discharge instructions for symptoms. |
HF1_DI_WEIGHT_IND | DOUBLE | Y | Identifies patients with written discharge instructions for weight. |
HF1_REJECT_IND | DOUBLE | Y | Identifies patient records that have been rejected from the HF-1 metric due to missing data |
HF2_DISCH_DISP_EXCL_IND | DOUBLE | Y | Identifies HF2 patients that have been excluded due to their discharge disposition. |
HF2_LVS_PERF_IND | DOUBLE | Y | identifies if the LVS assessment has been performed |
HF2_LVS_REASON_EXCL_IND | DOUBLE | Y | Identifies if a patient was excluded due to an LVS function assessment not done |
HF2_REJECT_IND | DOUBLE | Y | Identifies patient records that have been rejected from the HF-2 metric due to missing data |
HF3_ACEI_DISC_IND | DOUBLE | Y | identifies patients with ACEI prescribed at discharge |
HF3_ARB_DISC_IND | DOUBLE | Y | identifies patients with ARB prescribed at discharge |
HF3_DISCH_DISP_EXCL_IND | DOUBLE | Y | Identifies HF3 patients that have been excluded due to their discharge disposition. |
HF3_LVEF_MOD_SEVERE_IND | DOUBLE | Y | Identifies patients with an LVEF of moderate to severe. |
HF3_NO_ACEI_ARB_EXCL_IND | DOUBLE | Y | Identifies if a patient was excluded due to a documented reason for not prescribing ACEI or ARB at discharge. |
HF3_REJECT_IND | DOUBLE | Y | Identifies patient records that have been rejected from the HF-3 metric due to missing data |
HF4_DISCH_DISP_EXCL_IND | DOUBLE | Y | Identifies HF4 patients that have been excluded due to their discharge disposition. |
HF4_REJECT_IND | DOUBLE | Y | Identifies patient records that have been rejected from the HF-4 metric due to missing data |
HF4_SMOKE_COUNS_IND | DOUBLE | Y | identifies if the patient has attending smoking cessation counseling |
HF4_SMOKE_HX_IND | DOUBLE | Y | Identifies patients with a history of smoking. |
HF_AGE_EXCL_IND | DOUBLE | Y | Identifies if a patient was excluded due to age. |
HF_BASE_POPULATION_IND | DOUBLE | Y | Identifies patients that qualify for the base heart failure population. |
HF_CLIN_TRIAL_EXCL_IND | DOUBLE | Y | Identifies if a patient was excluded due to participation in a clinical trial. |
HF_CMO_EXCL_IND | DOUBLE | Y | Identifies if a patient was excluded due to an order for comfort measures. |
HF_LOS_EXCL_IND | DOUBLE | Y | Identifies if a patient was excluded due to length of stay. |
HF_LVAD_TRANSPLANT_EXCL_IND | DOUBLE | Y | Identifies if a patient was excluded due to a heart transplant procedure. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the 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. |
LVEF_MOD_SEVERE_FLAG | DOUBLE | Y | Identifies patients with an LVEF of moderate to severe. |
LVS_PERF_FLAG | DOUBLE | Y | Identifies if the patient had an LVS function evaluation. |
LVS_REASON_EXCL_FLAG | DOUBLE | Y | Identifies if there was a valid reason documented for not performing an LVS function evaluation. |
NHIQM_VERSION | DOUBLE | Y | Identifies the version of NHIQM for which the patient qualifies |
NO_ACEI_ARB_EXCL_FLAG | DOUBLE | Y | Identifies if there is a valid reason documented for not prescribing an ACEI/ARB at discharge. |
NUMERATOR_1_IND | DOUBLE | Y | Identifies patients that qualify for HF-1 |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients that qualify for HF-2 |
NUMERATOR_3_IND | DOUBLE | Y | Identifies patients that qualify for HF-3 |
NUMERATOR_4_IND | DOUBLE | Y | Identifies patients that qualify for HF-4 |
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 |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed normalized to GMT. |
SMOKE_COUNS_FLAG | DOUBLE | Y | Identifies if the patient has attended smoking cessation counseling. |
SMOKE_HX_FLAG | DOUBLE | Y | Identifies if the patient has a history of smoking |
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. |
Relationship Detail - LH_F_CHF_METRICS
Child Column in LH_F_CHF_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_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_DIAGNOSIS_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_HF1_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_HF2_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_HF3_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_HF4_METRIC_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 | |
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 | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_CRI_CE_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_CRI_CE_METRICS |
Definition: | This table is used to store metrics for the Lighthouse CRI quality measure. |
Table Type: | ACTIVITY |
Column Detail - LH_F_CRI_CE_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. |
ACT_ART_IND | DOUBLE | Y | Identifies if the row refers to an arterial line. |
ACT_IABP_IND | DOUBLE | Y | Identifies if the row refers to a IABP line . |
ACT_LA_IND | DOUBLE | Y | Identifies if the row refers to a left atrial line . |
ACT_PA_IND | DOUBLE | Y | Identifies if the row refers to a pulmonary artery line . |
ACT_PERIPH_IND | DOUBLE | Y | Identifies if the row refers to a peripheral IV line . |
CVL_ASSESS_24H_IND | DOUBLE | Y | Identifies if the central venous line was assessed within 24 hours of insertion. |
CVL_ASSESS_DAILY_IND | DOUBLE | Y | Identifies if the central venous line was assessed on a daily basis. |
CVL_DIALYSIS_IND | DOUBLE | Y | Identifies if the row refers to a dialysis central line . |
CVL_IMP_PORT_IND | DOUBLE | Y | Identifies if the row refers to a implanted prot central line . |
CVL_IND | DOUBLE | Y | Identifies if the row is associated with a central venous line. |
CVL_INT_SHEATH_IND | DOUBLE | Y | Identifies if the row refers to a introducer sheath central line . |
CVL_PICC_IND | DOUBLE | Y | Identifies if the row refers to a PICC central line . |
CVL_TUNNEL_IND | DOUBLE | Y | Identifies if the row refers to a tunneled type central line . |
D_CRI_BUILDING_ID | DOUBLE | N | The building in which the patient received an invasive line. |
D_CRI_FACILITY_ID | DOUBLE | N | The facility in which the patient received an invasive line. |
D_CRI_NURSE_UNIT_ID | DOUBLE | N | The nurse unit in which the patient had received an invasive line. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EVENT_ID | DOUBLE | N | Identifies the clinical event against which the quality measure is associated. Foreign key to the CLINICAL_EVENT table. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
FOLEY_ASSESS_24H_IND | DOUBLE | Y | Identifies if the foley catheter has been assessed within 24 hours of hospital insertion. |
FOLEY_ASSESS_DAILY_IND | DOUBLE | Y | Identifies if the foley catheter has been assessed daily. |
FOLEY_DOC_INDICATION_IND | DOUBLE | Y | Identifies if foley insertions that had appropriate indication documented at the time of insertion. |
FOLEY_IND | DOUBLE | Y | Identifies if the row is associated with an indwelling urinary catheter. |
FOLEY_POA_IND | DOUBLE | Y | Identifies if the row is a foley catheter present upon admission. |
F_CRI_CE_METRICS_ID | DOUBLE | N | Unique identifier for the lighthouse CRI line metrics. |
F_CRI_ENCNTR_METRICS_ID | DOUBLE | N | Identifier for the lighthouse CRI encounter metrics. |
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. |
INSERT_DT_TM | DATETIME | Y | The date/time on which the catheter was inserted. |
INSERT_UTC_DT_TM | DATETIME | Y | The date/time on which the catheter was inserted; normalized to GMT. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
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. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PREV_BSI_DT_TM | DATETIME | Y | Identifies the date/time of the last blood stream infection incident. |
PREV_BSI_UTC_DT_TM | DATETIME | Y | Identifies the date/time of the last blood stream infection incident normalized to GMT. |
PREV_UTI_DT_TM | DATETIME | Y | Identifies the date/time of the last urinary tract infection incident. |
PREV_UTI_UTC_DT_TM | DATETIME | Y | Identifies the date/time of the last urinary tract infection incident normalized to GMT. |
REMOVE_DT_TM | DATETIME | Y | The date/time on which the catheter was removed. |
REMOVE_UTC_DT_TM | DATETIME | Y | The date/time on which the catheter was removed; normalized to GMT. |
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. |
Relationship Detail - LH_F_CRI_CE_METRICS
Child Column in LH_F_CRI_CE_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_CRI_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_CRI_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_CRI_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
F_CRI_ENCNTR_METRICS_ID | LH_F_CRI_ENCNTR_METRICS | F_CRI_ENCNTR_METRICS_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CRI_ENCNTR_METRICS | HEALTH_SYSTEM_SOURCE_ID |