Table Detail Report

LH_F_CRI_ENCNTR_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_CRI_ENCNTR_METRICS
Definition: This table is used to store metrics for the Lighthouse CRI quality measure.
Table Type: ACTIVITY





Column Detail - LH_F_CRI_ENCNTR_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_CNT DOUBLE Y Identifies the number of arterial lines inserted during the visit.
ACT_IABP_CNT DOUBLE Y Identifies the number of IABP lines inserted during the visit. .
ACT_LA_CNT DOUBLE Y Identifies the number of left atrial lines inserted during the visit. .
ACT_PA_CNT DOUBLE Y Identifies the number of pulmonary artery lines inserted during the visit.
ACT_PERIPH_CNT DOUBLE Y Identifies the number of peripheral IV lines inserted during the visit. .
ADMIT_DT_TM DATETIME Y The date and time when the patient was admitted to the hospital
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.
ART_LINE_DAYS DOUBLE Y The total number of arterial line days during this visit.
CENTRAL_LINE_DAYS DOUBLE Y Identifies the number of central line days during the visit.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CONTRA_REASON_IND DOUBLE Y Identifies if patient has preferred site contraindication reason documented.
CVL_CHK_CNT DOUBLE Y Identifies the number of times the central venous line checklist was used during the visit.
CVL_CHK_RECOMMEND_CNT DOUBLE Y Identifies the number of times the central line checklist recommendations were followed during the visit.
CVL_DAILY_ASSESS_CNT DOUBLE Y Identifies the number of central lines that were assessed daily during the visit.
CVL_DIALYSIS_CNT DOUBLE Y Identifies the number of dialysis central lines inserted during the visit. .
CVL_DIALYSIS_LINE_DAYS DOUBLE Y The total number of dialysis central line days during this visit.
CVL_IMP_PORT_CNT DOUBLE Y Identifies the number of implanted prot central lines inserted during the visit. .
CVL_IMP_PORT_LINE_DAYS DOUBLE Y The total number of implanted prot central line days during this visit.
CVL_INFECTION_CNT DOUBLE Y Identifies the number of central venous lines that resulted in an infection during the visit.
CVL_INSERTED_CNT DOUBLE Y Identifies the number of central venous lines that were inserted during the visit.
CVL_INT_SHEATH_CNT DOUBLE Y Identifies the number of introducer sheath central lines inserted during the visit.
CVL_INT_SHEATH_LINE_DAYS DOUBLE Y The total number of introducer sheath central line days during this visit.
CVL_PICC_CNT DOUBLE Y Identifies the number of PICC central lines inserted during the visit.
CVL_PICC_LINE_DAYS DOUBLE Y The total number of PICC central line days during this visit
CVL_POA_IND DOUBLE Y Identifies if the patient had a central venous line present upon admission.
CVL_TUNNEL_CNT DOUBLE Y Identifies the number of tunneled central lines inserted during the visit.
CVL_TUNNEL_LINE_DAYS DOUBLE Y The total number of tunneled central line days during this visit
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged; normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_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_ENCNTR_TYPE_ID DOUBLE N Unique identifier for the encounter type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_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. Foreign 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.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
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.
FOLEY_DAILY_ASSESS_CNT DOUBLE Y Identifies the number of foley catheter that were appropriately assessed daily.
FOLEY_DAYS DOUBLE Y Identifies the number of indwelling catheter days during the visit.
FOLEY_DOC_INDICATION_CNT DOUBLE Y Identifies the number of times an indication reason was documented for hospital inserted indwelling catheters.
FOLEY_INFECTION_CNT DOUBLE Y Identifies the number of urinary tract infections that result from hospital insertions of an indwelling catheter.
FOLEY_INSERTED_CNT DOUBLE Y Identifies the number of indwelling urinary catheters that were inserted during the visit.
FOLEY_POA_IND DOUBLE Y Identifies if an indwelling urinary catheter was present upon admission.
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.
IABP_LINE_DAYS DOUBLE Y The total number of IABP line days during this visit.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LA_LINE_DAYS DOUBLE Y The total number of left atrial line days during this visit.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain.
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
PA_LINE_DAYS DOUBLE Y The total number of pulmonary arterial line days during this visit.
PERIPH_LINE_DAYS DOUBLE Y The total number of peripheral IV line days during this visit.
POPULATION_IND DOUBLE Y Identifies if the encounter qualifies for the falls population.
SITE_FEM_IND DOUBLE Y Identifies the patient has non-tunneled central line with site femoral inserted during the visit.
SITE_SUB_IND DOUBLE Y Identifies tif the patient has non-tunneled central line with site subclavian inserted during the visit.
SITE_UMB_ART_CNT DOUBLE Y Identifies the number of central line with site umbilical artery inserted during the visit.
SITE_UMB_VEIN_CNT DOUBLE Y Identifies the number of central line with site umbilical vein inserted during the visit.
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_CRI_ENCNTR_METRICS


Child Column in LH_F_CRI_ENCNTR_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_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_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




Parent Column in LH_F_CRI_ENCNTR_METRICS (PK) Child Table Name Child Column Name
Children: F_CRI_ENCNTR_METRICS_ID LH_F_CRI_CE_METRICS F_CRI_ENCNTR_METRICS_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CRI_CE_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_F_DELIRIUM_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_DELIRIUM_METRICS
Definition: Fact table for Delirium Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_DELIRIUM_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 and time when the patient was admitted to the hospital
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.
ASSESS_HRS_IND DOUBLE Y Identifies the client configurable number of hours prior to assessment
ASSESS_MET_IND DOUBLE Y Identifies if the patient received an assessment within the defined assessed hours timeframe
AT_RISK_TIME_IND DOUBLE Y Identifies if the patient was identified at risk of Delirium with Delirium
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DELIR_CONFIRMED_FLAG DOUBLE Y Identifies if the patient had a confirmed Delirium status. 0 - No; 1 - Yes; 999 - Missing
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.
DX_PROB_IND DOUBLE Y Identifies if the patient had a Delirium diagnosis or problem
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_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_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_1_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_METRIC_2_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_3_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_4_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_5_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_6_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_7_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_8_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_9_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 Identifies the principle diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Describes the principle procedure that was performed during the patient visit.
EDUCATION_FLAG DOUBLE Y Identifies if the patient had Delirium education documented. 0 - No; 1 - Yes; 999 - Missing
EDUCATION_TIMING_IND DOUBLE Y Identifies if the patient had a responsible learner present no later than 5 minutes after the Delirium education.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
FALL_IND DOUBLE Y Identifies if the patient had a Delirium fall after delirium was identified
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
F_DELIRIUM_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_DELIRIUM_METRICS table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LOC_ICU_DIAG_IND DOUBLE Y Identifies if the patient's first delirium diagnosis occurred in the ICU
LOC_ICU_FALL_IND DOUBLE Y Identifies if the patient's documented Delirium fall occurred in the ICU
LOC_ICU_RESTRAINT_IND DOUBLE Y Identifies if the patient's documented restraint occurred in the ICU
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.
MENTAL_STATUS_IND DOUBLE Y Identifies if the patient has had a mental status disturbances screening documented
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
PLAN_IND DOUBLE Y Identifies if the patient was on a plan
POPULATION_IND DOUBLE Y Identifies patients that qualify for the base population for the Lighthouse metric.
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
RESPONSIBLE_LEARNER_FLAG DOUBLE Y Identifies if the patient had a responsible learner present during education. 0 - No; 1 - Yes; 999 - Missing
RESTRAINT_IND DOUBLE Y Identifies if restraints were ordered for the patient
RISK_IND DOUBLE Y Identifies if the patient is at risk for Delirium
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_DELIRIUM_METRICS


Child Column in LH_F_DELIRIUM_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_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_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
D_METRIC_6_ID LH_D_METRIC D_METRIC_ID
D_METRIC_7_ID LH_D_METRIC D_METRIC_ID
D_METRIC_8_ID LH_D_METRIC D_METRIC_ID
D_METRIC_9_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_DEPRESSION_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_DEPRESSION_METRICS
Definition: Fact table for Depression Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_DEPRESSION_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 and time when the patient was admitted to the hospital
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.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COM_RES_EDU_IND DOUBLE Y Identifies if the patient had suicide prevention community Resources Education Documented
COM_RES_PT_UNDERSTAND_IND DOUBLE Y Identifies if the patient had verbalized understanding of community resources
DEPR_INIT_SCREEN_IND DOUBLE Y Identifies if the patient had actual or suspected pain during their visit.
DEPR_INIT_SCREEN_SCORE DOUBLE Y Identifies the depression symptom score
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged; normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_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_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_1_ID DOUBLE Y 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_METRIC_2_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_3_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_4_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_5_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_6_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_7_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_8_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_9_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 Identifies the principle diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Describes the principle procedure that was performed during the patient visit.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
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_DEPRESSION_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_DEPRESSION_METRICS table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
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.
NEG_POS_SCREEN_SCORE_IND DOUBLE Y FIRST Initial Depression Screen score (documented within 24 hrs of admission) is negative and total depression screen score is positive
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
PLAN_TIME_8H_IND DOUBLE Y Identifies if the patient was placed on a depressive symptom-suicide prevention plan within 8 hr of a positive score
POPULATION_IND DOUBLE Y Identifies if the patient was screened for depressive symptoms within 24 hrs
POS_24H_IND DOUBLE Y Identifies if the patient was screened for total depressive symptoms within 24 hours of admission with a positive score
POS_TOTAL_DEPR_IND DOUBLE Y Identifies if the patient had a total depression screen documented >=5
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
SUICIDE_PRECAUTIONS_IND DOUBLE Y Identifies if the patient had Suicide Precaution ordered
SUICIDE_PREVENT_EDU_IND DOUBLE Y Identifies if the patient had suicide prevention Education Documented
SYMPT_MGMT_EDU_IND DOUBLE Y Identifies if the patient had depressive symptom Mgmt Education Documented
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_DEPRESSION_METRICS


Child Column in LH_F_DEPRESSION_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_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_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
D_METRIC_6_ID LH_D_METRIC D_METRIC_ID
D_METRIC_7_ID LH_D_METRIC D_METRIC_ID
D_METRIC_8_ID LH_D_METRIC D_METRIC_ID
D_METRIC_9_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_DYSPHAGIA_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_DYSPHAGIA_METRICS
Definition: Fact table for Dysphagia Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_F_DYSPHAGIA_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.
CARDIAC_SURG_FLAG DOUBLE Y Identifies if the patient was a cardiac surgery patient.0 = Patient did not have cardiac surgery; 1 = Cardiac surgery defined in SurgiNet; 2 = Cardiac procedure defined through HIM
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.
DYS_EDUCATION_IND DOUBLE Y Identifies if dysphagia education was documented.
DYS_PLAN_IND DOUBLE Y Identifies if the patient was on a dysphagia management plan
DYS_PROB_DX_DT_TM DATETIME Y Identifies the onset date/time of the dysphagia diagnosis/problem.
DYS_PROB_DX_IND DOUBLE Y Identifies if the patient had a dysphagia diagnosis or problem.
DYS_PROB_DX_UTC_DT_TM DATETIME Y Identifies the onset date/time of the dysphagia diagnosis/problem.
DYS_SYMPTOM_MASK DOUBLE Y The dysphagia symptoms documented on the patient.0 = No dysphagia symptoms1 = Slow or slurred speech2 = Speech disturbance4 = Absence of gag reflex8 = Choking with swallowing16 = Coughing with swallowing32 = Throat clearing64 = Absent or weak voluntary cough
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_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_10_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_11_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_12_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_13_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_14_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_15_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_16_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_17_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_18_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_19_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_1_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_20_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_2_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_3_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_4_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_5_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_6_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_7_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_8_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_9_ID DOUBLE N The unique identifier for the quality measure.
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.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
F_DYSPHAGIA_METRICS_ID DOUBLE N Unique identifier for the lighthouse dysphagia 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.
INPATIENT_ADMIT_DT_TM DATETIME Y Identifies the date/time on which the patient became an inpatient.
INPATIENT_ADMIT_UTC_DT_TM DATETIME Y Identifies the date/time on which the patient became an inpatient.
INTUBATION_DURATION_IND DOUBLE Y Identifies if intubation lasted longer than 48 hours.
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.
NO_ASPIRATION_SYMPTOM_IND DOUBLE Y Identifies if there were no symptoms of aspiration documented.
NPO_DURATION_IND DOUBLE Y Identifies if the patient was NPO longer than 48 hours.
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
POPULATION_IND DOUBLE Y Identifies patients that qualify for the base population for the Lighthouse metric.
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.
SLP_EVAL_IND DOUBLE Y Identifies if a speech language pathology order was placed.
STK_DX_DT_TM DATETIME Y Identifies the onset date/time of the stroke diagnosis.
STK_DX_IND DOUBLE Y Identifies if the patient had a stroke diagnosis.
STK_DX_UTC_DT_TM DATETIME Y Identifies the onset date/time of the stroke diagnosis.
SWALLOW_EVAL_IND DOUBLE Y Identifies if a swallow evaluation was ordered.
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_DYSPHAGIA_METRICS


Child Column in LH_F_DYSPHAGIA_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_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_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
D_METRIC_6_ID LH_D_METRIC D_METRIC_ID
D_METRIC_7_ID LH_D_METRIC D_METRIC_ID
D_METRIC_8_ID LH_D_METRIC D_METRIC_ID
D_METRIC_9_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_FALLS_DTL_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_FALLS_DTL_METRICS
Definition: Fact table for Falls Detail Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_FALLS_DTL_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
D_FALL_BUILDING_ID DOUBLE Y The building in which the patient had a fall.
D_FALL_DOCU_PRSNL_ID DOUBLE N Identifies the person that documented the fall.
D_FALL_FACILITY_ID DOUBLE Y The facility in which the patient had a fall.
D_FALL_NURSE_UNIT_ID DOUBLE Y The nurse unit in which the patient had a fall.
ENCNTR_ID DOUBLE Y Identifies the encounter against which the quality measure is associated.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
FALL_ACTIVITY_MASK DOUBLE Y Identifies the activity at the time of the fall
FALL_CONDITION_MASK DOUBLE Y Identifies the condition(s) at the time of the fall
FALL_DEV_IND DOUBLE N Identifies if the fall was a developmental fall.
FALL_IND DOUBLE Y Identifies each fall
FALL_LOCATION_MASK DOUBLE Y Identifies the location(s) at the time of the fall
FALL_NON_DEV_IND DOUBLE N Identifies if the fall was a non-developmental fall.
FALL_UNASSISTED_IND DOUBLE Y Identifies if the fall was unassisted
FALL_UNWITNESSED_IND DOUBLE Y Identifies if the fall was unwitnessed
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
F_FALLS_DTL_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_FALLS_DTL_METRICS table.
HEALTH_SYSTEM_ID DOUBLE Y 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.
INCDNT_DT_TM DATETIME Y The date/time on which the incident occurred for the patient.
INCDNT_UTC_DT_TM DATETIME Y The date/time on which the incident first occurred for the patient; normalized to GMT.
INJURY_IND DOUBLE Y Identifies if the fall resulted in an injury
INJURY_LEVEL_TXT VARCHAR(50) Y Identifies the injury level of the fall
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LOGICAL_DOMAIN_ID DOUBLE Y 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.
MOD_SEVERE_INJURY_IND DOUBLE Y Identifies if the fall resulted in a moderate or severe injury
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PRIOR_ASSESS_DT_TM DATETIME Y Date time of the most recent assessment prior to the fall
PRIOR_ASSESS_UTC_DT_TM DATETIME Y Date time of the most recent assessment prior to the fall; normalized to GMT
RISK_PRIOR_FALL_IND DOUBLE Y Identifies if the patient was at risk prior to this incident.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_F_FALLS_DTL_METRICS


Child Column in LH_F_FALLS_DTL_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_FALL_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_FALL_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_FALL_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_FALL_DOCU_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID