Table Detail Report

LH_F_FALLS_HST_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_FALLS_HST_METRICS
Definition: Fact table for Falls History Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_FALLS_HST_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.
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_DAILY_IND DOUBLE Y Identifies patients with a risk assessment at least once per shift
AT_RISK_IND DOUBLE Y Identifies if the patient is at risk.
DEPART_DT_TM DATETIME Y The date/time on which the patient left the unit.
DEPART_UTC_DT_TM DATETIME Y The date/time on which the patient left the unit; normalized to GMT.
D_BUILDING_ID DOUBLE Y The building the patient spent time in.
D_FACILITY_ID DOUBLE Y The facility the patient spent time in.
D_NURSE_UNIT_ID DOUBLE Y The nurse unit the patient spent time in.
EDUCATION_IND DOUBLE Y Identifies if the at risk patient has had education documented.
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_IND DOUBLE Y Identifies each fall
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
F_FALLS_HST_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_FALLS_HST_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
IN_LOC_WIN_24H_IND DOUBLE Y Identifies if patient was in the unit in the first 24hrs
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.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PLAN_INITIATED_IND DOUBLE Y Identifies if the at risk patient has had an orderset or powerplan activated.
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 patients that are at risk, had an incident documented, and were at risk prior to the 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_HST_METRICS


Child Column in LH_F_FALLS_HST_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID


LH_F_FALLS_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_FALLS_METRICS
Definition: This table is used to store metrics for the Lighthouse falls prevention quality measure. This table is at the encounter grain based upon the falls prevention population definition.
Table Type: ACTIVITY





Column Detail - LH_F_FALLS_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted; normalized to GMT.
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_DAILY_IND DOUBLE Y Identifies if the patient was assessed for risk on a daily basis.
ASSESS_DT_TM DATETIME Y The date/time on which the patient was first assessed for risk.
ASSESS_IND DOUBLE N Identifies if the encounter had a Fall Risk Assessment performed.
ASSESS_UTC_DT_TM DATETIME Y The date/time on which the patient was first assessed for risk; normalized to GMT.
ASSESS_WIN_24H_IND DOUBLE Y Identifies if the patient was assessed for risk within 24 hours of admission.
AT_RISK_FOR_INJURY_IND DOUBLE Y Identifies if the patient is at risk for an injury.
AT_RISK_IND DOUBLE Y Identifies if the patient is at risk.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DEV_FALL_IND DOUBLE Y Identifies if the fall is a developmental fall.
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 Y The building to which the patient was admitted.
D_ADMIT_DIAGNOSIS_ID DOUBLE N Describes the primary symptoms the patient was experiencing upon admission
D_ADMIT_FACILITY_ID DOUBLE Y The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE Y The nurse unit to which the patient was admitted.
D_ADMIT_PRSNL_ID DOUBLE N Identifies the physician responsible for the patient admission.
D_ADMIT_SRC_ID DOUBLE Y Identifies the place from which the patient came before being admitted.
D_DISCHARGE_BUILDING_ID DOUBLE Y The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE Y The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE Y The nurse unit from which the patient was discharged
D_ENCNTR_TYPE_ID DOUBLE Y Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
D_FIRST_FALL_BUILDING_ID DOUBLE Y The building at which the first incident occurred.
D_FIRST_FALL_FACILITY_ID DOUBLE Y The facility at which the first incident occurred.
D_FIRST_FALL_NURSE_UNIT_ID DOUBLE Y The nurse unit at which the first incident occurred.
D_MED_SERVICE_ID DOUBLE Y 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_METRIC_21_ID DOUBLE N Identifier of the falls metric.
D_METRIC_22_ID DOUBLE N Identifier of the falls metric.
D_METRIC_23_ID DOUBLE N Identifier of the falls metric.
D_METRIC_24_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_25_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_26_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_27_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_28_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_29_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_PERSON_ID DOUBLE Y Identifies the person associated with the quality measure. Foreign key to the PERSON table.
D_PRIMARY_DIAGNOSIS_ID DOUBLE N Describes the primary symptoms the patient was experiencing at the time of the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Describes the principle procedure that was performed during the patient visit.
EDUCATION_HOME_IND DOUBLE N Identifies if the encounter received home fall prevention education.
EDUCATION_IND DOUBLE Y Identifies if the at risk patient has had education documented.
ENCNTR_ID DOUBLE Y 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 an incident has been documented during the patient visit.
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_FALLS_METRICS_ID DOUBLE N Unique identifier for lighthouse falls prevention metrics
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 first 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 the number of patients with an incident that resulted in an injury.
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.
NBR_FALLS DOUBLE Y Total number of incident occurrences during the visit
NBR_NON_DEV_FALLS DOUBLE Y Identifies the number of non-developmental falls during this visit.
NEXT_INPT_DT_TM DATETIME Y Identifies the date and time of admission of the next inpatient encounter.
NEXT_INPT_UTC_DT_TM DATETIME Y Identifies the date and time of admission of the next inpatient encounter.
NON_DEV_FALL_DT_TM DATETIME Y The date/time of the non-developmental fall.
NON_DEV_FALL_IND DOUBLE Y Identifies if the fall is a non-developmental fall.
NON_DEV_FALL_UTC_DT_TM DATETIME Y The date/time of the non-developmental fall; normalized to GMT
NON_DEV_INJURY_IND DOUBLE Y Identifies if the patient had a non-developmental fall resulting in an injury.
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
PEDIATRIC_IND DOUBLE N Identifies if the row is for a pediatric patient.
PLAN_INITIATED_IND DOUBLE Y Identifies if the at risk patient has had an orderset or powerplan activated.
POPULATION_IND DOUBLE Y Identifies if the encounter qualifies for the falls population.
PREV_INCDNT_DT_TM DATETIME Y The date/time on which the previous incident took place.
PREV_INCDNT_UTC_DT_TM DATETIME Y The date/time on which the previous incident took place; normalized to GMT.
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
RISK_DT_TM DATETIME Y The date/time on which the patient was first identified at risk.
RISK_INJURY_MEDS_IND DOUBLE N Identifies if the encounter had an At Risk for Injury medications ordered.
RISK_PRIOR_FALL_IND DOUBLE Y Identifies patients that are at risk had an incident documented and were at risk prior to the incident.
RISK_PRIOR_ND_FALL_IND DOUBLE Y Identifies if the patient was at risk prior to the non-developmental fall.
RISK_UTC_DT_TM DATETIME Y The date/time on which the patient was first identified at risk; normalized to GMT.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - LH_F_FALLS_METRICS


Child Column in LH_F_FALLS_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
D_FIRST_FALL_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
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
D_FIRST_FALL_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
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
D_METRIC_21_ID LH_D_METRIC D_METRIC_ID
D_METRIC_22_ID LH_D_METRIC D_METRIC_ID
D_METRIC_23_ID LH_D_METRIC D_METRIC_ID
D_METRIC_24_ID LH_D_METRIC D_METRIC_ID
D_METRIC_25_ID LH_D_METRIC D_METRIC_ID
D_METRIC_26_ID LH_D_METRIC D_METRIC_ID
D_METRIC_27_ID LH_D_METRIC D_METRIC_ID
D_METRIC_28_ID LH_D_METRIC D_METRIC_ID
D_METRIC_29_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
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
D_FIRST_FALL_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
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


LH_F_FVE_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Fact Fluid Volume Excess Metrics
Definition: Fact table for inpatient Fluid Volume Excess Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_F_FVE_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted; normalized to GMT.
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.
DAILY_IO_IND DOUBLE Y Identifies if the patient had daily intake and output; starting the day after the patient was first identified with FVE.
DAILY_WEIGHT_IND DOUBLE Y Identifies if the patient had weight measured daily; starting the day after the patient was first identified with FVE.
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_PROBLEM_ADMIT_FLAG DOUBLE Y Identifies if the patient has an admitting diagnosis that is a candidate for FVE. 0 = Does not qualify 1 = Cardiac 2 = Renal 3 = Hepatic 4 = FVE
DX_PROBLEM_TX_FLAG DOUBLE Y Identifies if the patient has a diagnosis or problem that is a candidate for FVE. 0 = Does not qualify 1 = Cardiac 2 = Renal 3 = Hepatic 4 = FVE
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 pain. Foreign key to the lh_d_metric table.
D_METRIC_11_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_12_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_13_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_14_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_15_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_16_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_17_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_18_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_19_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_1_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_20_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
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 Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_8_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_9_ID DOUBLE N Identifies a metric associated with pain. NForeign key to the lh_d_metric table.
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.
EDUCATION_IND DOUBLE Y Identifies if the patient had FVE education documented.
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 the record was first loaded into the table.
FVE_ADMIT_FLAG DOUBLE Y Identifies if the patient is at-risk for FVE or has FVE on admission. 0 = Not at risk; no FVE 1 = Risk on Admission 2 = FVE on Admission
FVE_DT_TM DATETIME Y The date/time on which the patient was first identified with FVE.
FVE_RISK_DT_TM DATETIME Y The date/time on which the patient was first identified at-risk for FVE.
FVE_RISK_UTC_DT_TM DATETIME Y The date/time on which the patient was first identified at-risk for FVE.
FVE_TX_FLAG DOUBLE Y Identifies if the patient is at-risk for FVE or has FVE on transfer. 0 = Not at risk; no FVE 1 = Risk on Admission 2 = FVE on Admission
FVE_UTC_DT_TM DATETIME Y The date/time on which the patient was first identified with FVE.
F_FVE_METRICS_ID DOUBLE N Unique identifier for the lighthouse Fluid Volume Excess 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.
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 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
PLAN_INITIATED_IND DOUBLE Y Identifies if the patient had an FVE powerplan initiated.
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.
READMIT_FLAG DOUBLE Y Identifies if the heart failure patient had a previous visit in which they had FVE. 0 = No visit in last 6 months with FVE 1 = Visit 3 months prior to admit with FVE 2 = Visit 6 months prior to admit with FVE and not within 3 months prior to admit
SHORT_OF_BREATH_FLAG DOUBLE Y Identifies if the patient had shortness of breath documented. 0 = No shortness of breath documented / Does not qualify 1 = Shortness of breath on admission 2 = Shortness of breath on transfer 3 = Shortness of breath on admission and transfer
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.
WEIGHT_GAIN_FLAG DOUBLE Y Identifies if the patient had a documented weight gain. 0 = No weight gain / does not qualify 1 = Weight gain on admission 2 = Weight gain on transfer 3 = Weight gain on admission and transfer



Relationship Detail - LH_F_FVE_METRICS


Child Column in LH_F_FVE_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_GLYCEMIC_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_GLYCEMIC_METRICS
Definition: Fact table for Glycemic Control Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_F_GLYCEMIC_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.
ANTIDIABETIC_MED_DISC_IND DOUBLE Y Identifies if the patient received antidiabetic medications reconciled at discharge.
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.
CONTROLLED_DIET_IND DOUBLE Y Identifies patients receiving a calorie controlled diet
DEXTROSE_INFUSION_IND DOUBLE Y Identifies patients that had a Dextrose Infusion administered.
DIABETIC_TEACHING_IND DOUBLE Y Identifies patients who received Diabetic Teaching
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 during the visit.
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 the metric identifier for the Lighthouse metric.
D_METRIC_11_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_12_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_13_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_14_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_15_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_16_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_17_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_18_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_19_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_20_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_6_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_7_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_8_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_9_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
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 Identifies the principle procedure associated with the encounter.
EDUCATION_IND DOUBLE Y Identifies patients who received 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 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_GLYCEMIC_METRICS_ID DOUBLE N Unique identifier for the Lighthouse Glycemic Control metrics
GLUCOSE_RESULT_IND DOUBLE Y Identifies patients that had a glucose result documented
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.
HGBA1C_ORDER_IND DOUBLE Y Identifies patients who had an HgbA1c ordered
HYPERGLYCEMIA_CNT DOUBLE Y Stores the number of times the blood glucose level was elevated (above 150)
HYPOGLYCEMIA_CNT DOUBLE Y Stores the number of times the blood glucose level was low (below 60)
INSULIN_PROTOCOL_IND DOUBLE Y Identifies patients placed on an insulin protocol
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 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
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
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_GLYCEMIC_METRICS


Child Column in LH_F_GLYCEMIC_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_HAPU_DTL_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_F_HAPU_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_HAPU_BUILDING_ID DOUBLE Y The building in which the patient had a HAPU.
D_HAPU_DOCU_PRSNL_ID DOUBLE N Identifies the person that documented the HAPU.
D_HAPU_FACILITY_ID DOUBLE Y The facility in which the patient had a HAPU.
D_HAPU_NURSE_UNIT_ID DOUBLE Y The nurse unit in which the patient had a HAPU.
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.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
F_HAPU_DTL_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_HAPU_DTL_METRICS table.
HAPU_DAY_OF_STAY DOUBLE Y The day of stay on which the hapu occurred.
HAPU_IND DOUBLE Y Identifies each hospital acquired pressure ulcer
HAPU_STAGE_FLAG DOUBLE Y Identifies the stage for a hospital acquired pressure ulcer.
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.
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.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
RISK_PRIOR_HAPU_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_HAPU_DTL_METRICS


Child Column in LH_F_HAPU_DTL_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_HAPU_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_HAPU_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_HAPU_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_HAPU_DOCU_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID