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