Table Detail Report

LH_F_SEPSIS_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_SEPSIS_METRICS
Definition: Contains data related to the Lighthouse Sepsis metrics.
Table Type: ACTIVITY





Column Detail - LH_F_SEPSIS_METRICS


Column Name Type Null? Definition
ABX_ADMIN_DT_TM DATETIME Y Identifies the initial administration of antibiotics after presentation.
ABX_ADMIN_UTC_DT_TM DATETIME Y Identifies the initial administration of antibiotics after presentation.
ABX_BLD_CULT_X_MET_IND DOUBLE Y Identifies if a patient has blood culture collected before an antibiotic administered within designed time frame of presentationand
ABX_PRESENT_X_MET_IND DOUBLE Y Identifies if a patient has antibiotic administered in designed time frame of presentation.
ABX_X_HRS_IND DOUBLE Y Identifies if a patient has an antibiotic administered within design time frame of presentation ( default 3 hours if no design time frame)
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.
ADVISOR_CONFIRMED_IND DOUBLE Y Identifies if sepsis is confirmed via the advisor.
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.
AVG_GLUCOSE_RSLT DOUBLE Y Identifies the average blood glucose results for those verified between 6 and 24 hours after presentation.
BLD_CULT_COLLECT_DT_TM DATETIME Y Identifies the initial date/time of the blood culture collection; after presentation.
BLD_CULT_COLLECT_UTC_DT_TM DATETIME Y Identifies the initial date/time of the blood culture collection; after presentation.
BLD_CX_CLT_PRIOR_ABX_IND DOUBLE Y Identifies if the rule for Blood Culture Collected Before Patient starts Abx
BLOOD_GLUCOSE_6_24H_IND DOUBLE Y Identifies if the patient had a blood glucose result between 6 and 24 hours after presentation.
BROAD_SPECTRUM_IND DOUBLE Y Identifies if the patient was given antibiotics prior to presentation
COMM_ACQ_SEPSIS_DX_IND DOUBLE N Identifies if a patient has community acquired sepsis in designed time frame of presentation
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CVP_DT_TM DATETIME Y Identifies the date/time CVP was measured on the patient
CVP_RSLT_MET_IND DOUBLE Y Identifies if the patient has a CVP result greater than or equal to 8 mmHG within 6 hours of presentation.
CVP_UTC_DT_TM DATETIME Y Identifies the date/time CVP was measured on the patient, normalized to GMT
CVP_X_MET_IND DOUBLE N Identifies if a patient has CVP in designed time frame of presentation
DEATH_DT_TM DATETIME Y The date/time on which the patient passed
DEATH_UTC_DT_TM DATETIME Y The date/time on which the patient passed
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.
DROTRECOGIN_DT_TM DATETIME Y Identifies the initial date/time that drotrecogin was administered after presentation.
DROTRECOGIN_UTC_DT_TM DATETIME Y Identifies the initial date/time that drotrecogin was administered after presentation.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstance under which the patient was admitted or will be admitted.
D_ATTEND_PRSNL_ID DOUBLE N The most recent attending physician associated with the encounter.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N The conditions under which the patient left the facility at the time of discharge.
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type, surgery, general resources, or others.
D_METRIC_01_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_02_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_03_ID DOUBLE N Identifies a metric associated with sepsis Foreign key to the lh_d_metric table.
D_METRIC_04_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_05_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_06_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_07_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_08_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_09_ID DOUBLE N Identifies a metric associated with sepsis. NForeign key to the lh_d_metric table.
D_METRIC_10_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_11_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_12_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_13_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_14_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_15_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_16_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_17_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_18_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_19_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_20_ID DOUBLE N Identifies a metric associated with sepsis. Foreign key to the lh_d_metric table.
D_METRIC_21_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_22_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_23_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_24_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_25_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_26_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_27_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_28_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_29_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_30_ID DOUBLE N Metric ID for Metric 30
D_METRIC_31_ID DOUBLE N Metric ID for Metric 31
D_METRIC_32_ID DOUBLE N Metric ID for Metric 32
D_METRIC_33_ID DOUBLE N Metric ID for Metric 33
D_METRIC_34_ID DOUBLE N Metric ID for Metric 34
D_METRIC_35_ID DOUBLE N Metric ID for Metric 35
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
D_PRIN_DIAGNOSIS_ID DOUBLE N The principal diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N The principal procedure associated with the encounter.
ED_IND DOUBLE Y Identifies if the Sepsis rule fired while the patient was in the ED.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENC_TYPE_FLAG DOUBLE N Identifies the encounter type of the patient
EXPIRED_IND DOUBLE Y Indicator to Say if the Patient is Expired
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINAL_SEPSIS_DX_IND DOUBLE Y Final Sepsis Diagnosis Indicator
FINAL_SEV_SEPSIS_DX_IND DOUBLE Y Final Severe Sepsis Diagnosis Indicator
FINAL_SHOCK_DX_IND DOUBLE Y Final Shock Diagnosis Indicator
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_ADVR_FLAG DOUBLE N Identifies the most severe sepsis advisor that was confirmed.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
FIRST_SCRN_RULE_FLAG DOUBLE N Identifies the first sepsis alert for the Screening Rule Specificity
FLUID_BOLUS_AMT DOUBLE Y Identifies the fluid bolus amount administered.
FLUID_BOLUS_DT_TM DATETIME Y Identifies the date/time on which the fluid bolus was started.
FLUID_BOLUS_GUIDE_AMT DOUBLE Y Identifies the fluid bolus guideline based upon the type of fluid bolus administered.
FLUID_BOLUS_UTC_DT_TM DATETIME Y Identifies the date/time on which the fluid bolus was started.
FLUID_BOLUS_X_AMT DOUBLE Y Identifies the amount of the fluid bolus administered in designed time frame of presentation.
FLUID_BOLUS_X_GUIDE_AMT DOUBLE Y Identifies the fluid bolus guideline based upon the bolus that the patient received in designed time frame of presentation.
FLUID_BOLUS_X_MET_IND DOUBLE Y Identifies if a patient has the fluid bolus which started in designed time presentation.
FLUID_BOLUS_Y_GUIDE_AMT DOUBLE Y Stores the Fluid Bolus Guide Amount.
FLUID_VOLUME DOUBLE Y Cummilative Fluid Balance Volume Within 6 Hrs
FLUID_VOLUME_X DOUBLE Y Cummilative Fluid Balance Volume Within X Hrs
F_SEPSIS_METRICS_ID DOUBLE N Unique identifier for the lighthouse sepsis metrics.
GLUCOCORTICOIDS_DT_TM DATETIME Y Identifies if the patient received low dose glucocorticoids within 24 hours of presentation.
GLUCOCORTICOIDS_UTC_DT_TM DATETIME Y Identifies if the patient received low dose glucocorticoids within 24 hours of presentation.
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.
HIGHEST_ADVR_FLAG DOUBLE N Identifies the most severe sepsis advisor that was confirmed.
INFCT_PRESENT_DT_TM DATETIME Y Identifies the date/time of the Sepsis Infection Suspected rule firing.
INFCT_PRESENT_UTC_DT_TM DATETIME Y Identifies the date/time of the Sepsis Infection Suspected rule firing, normalized to GMT.
INFECTION_SRC_DOC_IND DOUBLE N Identifies if the patient had an Infection Source Documented
INFECTION_SRC_FLAG DOUBLE N Identifies the specific Infection Source.1 - Sepsis Infection Suspected2 - Abx Started Prior to Sepsis Alert3 - Bld Cx Collect Before Pt Started Abx
LACTACT_X_HRS_MET_IND DOUBLE Y Identifies if a patient has a serum lactate mesure in designed time frame of presentation
LACTATE_RESULT_DT_TM DATETIME Y Identifies the initial date/time of the serum lactate result; after presentation.
LACTATE_RESULT_UTC_DT_TM DATETIME Y Identifies the initial date/time of the serum lactate result; after presentation.
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.
MAP_BOLUS_RSLT_MET_IND DOUBLE Y Identifies if a patient has a map result less than 65 mg within 6 hours after the fluid bolus was started.
MAP_RSLT_LX_6HR_IND DOUBLE Y Identifies if a patient has a map result less than 65 mg between design time frame prior presentation and 6 hours after presentation
MAP_RSLT_LX_FX_IND DOUBLE Y Identifies if a patient has a map result less than 65 mg within 6 hours after the fluid bolus was started.
MAP_RSLT_MET_IND DOUBLE Y Identifies if the patient had a MAP result less than 65 mg within 6 hours after presentation.
MECH_VENT_DAYS DOUBLE Y Total Number of Mechanical Ventilation Days
MED_PLATEAU_PRESSURE_RSLT DOUBLE Y Identifies the medial plateau pressure for those performed within 24 hours after presentation.
MORTALITY_SEPSIS_IND DOUBLE Y Indicates if the Patient is Expired due to Sepsis
NEXT_ED_DT_TM DATETIME Y Identifies the date/time of the next ED encounter the patient has after the Sepsis encounter
NEXT_ED_UTC_DT_TM DATETIME Y Identifies the date/time of the next ED encounter the patient has after the Sepsis encounter, normalized to GMT
NON_MECH_VENT_DAYS DOUBLE Y Total Number of Non Mechanical Ventilation Days
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PATIENT_WEIGHT DOUBLE Y Identifies the most current weight of the patient
PLAN_INITIATED_IND DOUBLE Y Identifies if the sepsis powerplan or order set has been initiated.
PLATEAU_PRESSURE_24H_IND DOUBLE Y Identifies if the patient had a plateau pressure within 24 hours after presentation.
POPULATION_IND DOUBLE Y Identifies if the patient is a part of the Lighthouse condition population.
PRESENTATION_DT_TM DATETIME Y Identifies the date/time that the patient presented with septic symptoms.
PRESENTATION_UTC_DT_TM DATETIME Y Identifies the date/time that the patient presented with septic symptoms.
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_IND DOUBLE N Identifies if a patient has an encounter 31 days prior to this admission
RE_ED_X_DAY_IND DOUBLE Y Indicaties if the Patient is Readmitted to ED within X Days
RE_LACT_6HR_MET_IND DOUBLE Y Serum Lactate Remeasured Within 6 Hours Indicator
RE_LACT_X_MET_IND DOUBLE N Identifies if a patient who has had they serum lactate measured above 4 mmol/L
SCVO2_DT_TM DATETIME Y Identifies the date/time ScvO2 was measured on the patient
SCVO2_RSLT_MET_IND DOUBLE Y Identifies if the patient has a ScvO2 result greater than or equal to 70% within 6 hours of presentation.
SCVO2_UTC_DT_TM DATETIME Y Identifies the date/time ScvO2 was measured on the patient, normalized to GMT
SCVO2_X_MET_IND DOUBLE N Identifies if the Scv02 was measured within X hours of presentation
SEPSIS_DIAG_FLAG DOUBLE Y Identifies if the patient is belong to which sepsis diagnosis such as 3 - Sepsis, 2 - Severe Sepsis, 1 - Septic Shock or 0 - Other.
SEPSIS_EXPIRED_IND DOUBLE Y Identifies if the patient expired due to sepsis.
SEPSIS_ICD_DX_IND DOUBLE Y Identifies if the patient has a sepsis ICD9 diagnosis code.
SEPSIS_IND DOUBLE N Identifies if a patient a Sepsis Infection Suspected
SEPTIC_SHOCK_BP_IND DOUBLE N Identifies if a patient had the St John Rule/Recommendation Action fire
SEPTIC_SHOCK_IND DOUBLE N Identifies if a patient had the Septic Shock Rule fire
SERUM_LACTATE_RSLT_MET_IND DOUBLE Y Identifies if the patient had a serum lactate result greater than or equal to 4 within 6 hours after presentation.
SERUM_LACT_RSLT_DT_TM DATETIME Y Identifies the date/time that the serum lactate result was verified
SERUM_LACT_RSLT_LX_3_IND DOUBLE N Identifies if a patient has a serum lactate result greater than or equal to 4 between design time frame prior presentable and 3 hours after presentation
SERUM_LACT_RSLT_LX_6HR_IND DOUBLE Y Identifies if a patient has a serum lactate result greater than or equal to 4 between design time frame prior presentable and 6 hours after presentation
SERUM_LACT_RSLT_LX_FX_IND DOUBLE Y Identifies if a patient has a serum lactate result greater than or equal to 4 in design time frame of presentation
SERUM_LACT_RSLT_UTC_DT_TM DATETIME Y Identifies the date/time that the serum lactate result was verified, normalized to GMT
SEV_ICD_DX_IND DOUBLE Y Identifies if the patient has a diagnosis of severe sepsis.
SEV_PRESENT_DT_TM DATETIME Y Identifies the date/time of the Severe Sepsis rule firing
SEV_PRESENT_UTC_DT_TM DATETIME Y Identifies the date/time of the Severe Sepsis rule firing, normalized to GMT
SEV_SEPSIS_IND DOUBLE N Identifies if a patient had the St John Rule/Recommendation Action fire
SHOCK_BP_PRESENT_DT_TM DATETIME Y Identifies the date/time of the Shock BP Sepsis rule firing
SHOCK_BP_PRESENT_UTC_DT_TM DATETIME Y Identifies the date/time of the Shock BP Sepsis rule firing, normalized to GMT
SHOCK_ICD_DX_IND DOUBLE Y Identifies if the patient has a diagnosis of sepsis shock.
SHOCK_PRESENT_DT_TM DATETIME Y Identifies the date/time of the Shock Sepsis rule firing
SHOCK_PRESENT_UTC_DT_TM DATETIME Y Identifies the date/time of the Shock Sepsis rule firing, normalized to GMT
SIRS_ALERT_IND DOUBLE N Identifies if a Patient had the SIRS alert rule fire
SIRS_PRESENT_DT_TM DATETIME Y Identifies the date/time of the Systemic Inflammatory Response Syndrome (SIRS) rule firing.
SIRS_PRESENT_UTC_DT_TM DATETIME Y Identifies the date/time of theSystemic Inflammatory Response Syndrome (SIRS) rule firing, normalized to GMT.
SYSTOLIC_BP_IND DOUBLE N Identifies if a patient has a systolic BP result <90mmHg
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.
VASOPRESSOR_DT_TM DATETIME Y Identifies the initial date/time that vasopressor was administered within 6 hours of presentation.
VASOPRESSOR_UTC_DT_TM DATETIME Y Identifies the initial date/time that vasopressor was administered within 6 hours of presentation.
VASO_X_MET_IND DOUBLE N Identifies if a patient has vasopressors in designed time frame of presentation



Relationship Detail - LH_F_SEPSIS_METRICS


Child Column in LH_F_SEPSIS_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_PRIN_DIAGNOSIS_ID LH_D_DIAGNOSIS D_DIAGNOSIS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DIAGNOSIS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_01_ID LH_D_METRIC D_METRIC_ID
D_METRIC_02_ID LH_D_METRIC D_METRIC_ID
D_METRIC_03_ID LH_D_METRIC D_METRIC_ID
D_METRIC_04_ID LH_D_METRIC D_METRIC_ID
D_METRIC_05_ID LH_D_METRIC D_METRIC_ID
D_METRIC_06_ID LH_D_METRIC D_METRIC_ID
D_METRIC_07_ID LH_D_METRIC D_METRIC_ID
D_METRIC_08_ID LH_D_METRIC D_METRIC_ID
D_METRIC_09_ID LH_D_METRIC D_METRIC_ID
D_METRIC_10_ID LH_D_METRIC D_METRIC_ID
D_METRIC_11_ID LH_D_METRIC D_METRIC_ID
D_METRIC_12_ID LH_D_METRIC D_METRIC_ID
D_METRIC_13_ID LH_D_METRIC D_METRIC_ID
D_METRIC_14_ID LH_D_METRIC D_METRIC_ID
D_METRIC_15_ID LH_D_METRIC D_METRIC_ID
D_METRIC_16_ID LH_D_METRIC D_METRIC_ID
D_METRIC_17_ID LH_D_METRIC D_METRIC_ID
D_METRIC_18_ID LH_D_METRIC D_METRIC_ID
D_METRIC_19_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
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
D_METRIC_30_ID LH_D_METRIC D_METRIC_ID
D_METRIC_31_ID LH_D_METRIC D_METRIC_ID
D_METRIC_32_ID LH_D_METRIC D_METRIC_ID
D_METRIC_33_ID LH_D_METRIC D_METRIC_ID
D_METRIC_34_ID LH_D_METRIC D_METRIC_ID
D_METRIC_35_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
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_SEPSIS_PD_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_SEPSIS_PD_METRICS
Definition: This table is used to store Sepsis Post Discharge Report Metrics . This table is at the Alert(Clincial Event) Grain.
Table Type: ACTIVITY





Column Detail - LH_F_SEPSIS_PD_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.
BILLING_DX VARCHAR(200) Y The Name of the Billing Diagnosis.
BILLING_DX_CODE VARCHAR(20) Y The Code of the Billing Diagnosis.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CULTURE_COLLECT_DT_TM DATETIME Y The Date/Time of the Culture Collection
CULTURE_COLLECT_UTC_DT_TM DATETIME Y The Date/Time of the Culture Collection Normalized to GMT.
CULTURE_NAME VARCHAR(200) Y The Name of the Culture
CULTURE_ORD_DT_TM DATETIME Y The Date/Time of the Culture Order
CULTURE_ORD_UTC_DT_TM DATETIME Y The Date/Time of the Culture Order Normalized to GMT
CULTURE_RESULT DOUBLE Y The Result of the Culture
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_DX VARCHAR(200) Y The Name of the Discharge Diagnosis.
DISCHARGE_DX_CODE VARCHAR(20) Y The Code of the Discharge Diagnosis.
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 Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_FINANCIAL_CLASS_ID DOUBLE N Identifies the financial class of the encounter during registration
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXPIRED_IND DOUBLE Y Indicates if the Encounter is Discharged Dead/Deceased.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINAL_DX VARCHAR(200) Y The Name of the Final Diagnosis.
FINAL_DX_CODE VARCHAR(20) Y The Code of the Final Diagnosis.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_INFECTION_DT_TM DATETIME Y The Date/Time of the First Infection Source
FIRST_INFECTION_SRC VARCHAR(200) Y Name of the First Infection Source
FIRST_INFECTION_UTC_DT_TM DATETIME Y The Date/Time of the First Infection Source Normalized to GMT
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
FLUID_ADMIN_DT_TM DATETIME Y The Date/Time of the Fluid Administration.
FLUID_ADMIN_UTC_DT_TM DATETIME Y The Date/Time of the Fluid Administration Normalized to GMT.
FLUID_COMPLETE_DT_TM DATETIME Y The Date/Time of the Fluid Completion.
FLUID_COMPLETE_UTC_DT_TM DATETIME Y The Date/Time of the Fluid Completion Normalized to GMT
FLUID_INFUSE DOUBLE Y The Infusion Rate of the Fluid
FLUID_INFUSE_UNIT VARCHAR(20) Y The Infusion Rate Unit of the Fluid
FLUID_NAME VARCHAR(200) Y The Name of the Fluid
FLUID_ORD_DT_TM DATETIME Y The Date/Time of the Fluid Order
FLUID_ORD_UTC_DT_TM DATETIME Y The Date/Time of the Fluid Order Normalized to GMT
FLUID_RATE DOUBLE Y The Rate of the Fluid
FLUID_RATE_UNIT VARCHAR(20) Y The Rate Unit of the Fluid
FLUID_VOLUME DOUBLE Y The Volume of the Fluid
FLUID_VOLUME_UNIT VARCHAR(20) Y The Volume Unit of the Fluid
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.
LACTATE_COLLECT_DT_TM DATETIME Y The Date/Time of the Lactate Collection
LACTATE_COLLECT_UTC_DT_TM DATETIME Y The Date/Time of the Lactate Collection Normalized to GMT
LACTATE_NAME VARCHAR(200) Y The Name of the Lactate
LACTATE_ORD_DT_TM DATETIME Y The Date/Time of the Lactate Order
LACTATE_ORD_UTC_DT_TM DATETIME Y The Date/Time of the Lactate Order Normalized to GMT
LACTATE_RESULT DOUBLE Y The Result of the Lactate
LAST_INFECTION_DT_TM DATETIME Y The Date/Time of the Last Infection Source
LAST_INFECTION_SRC VARCHAR(200) Y Name of the Last Infection Source
LAST_INFECTION_UTC_DT_TM DATETIME Y The Date/Time of the Last Infection Source Normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LENGTH_OF_STAY DOUBLE Y The Length of Stay of the Encounter.
LH_F_SEPSIS_PD_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_SEPSIS_PD_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, if you assign clients a logical_domain_id, this would allow you to store data for multiple clients on this table.
MED_ADMIN_DT_TM DATETIME Y The Date/Time of the Medication Administration
MED_ADMIN_UTC_DT_TM DATETIME Y The Date/Time of the Medication Administration Normalized to GMT
MED_COMPLETE_DT_TM DATETIME Y The Date/Time of the Medication Completion
MED_COMPLETE_UTC_DT_TM DATETIME Y The Date/Time of the Medication Completion Normalized to GMT
MED_NAME VARCHAR(200) Y The Name of the Medication
MED_ORD_DT_TM DATETIME Y The Date/Time of the Medication Order
MED_ORD_UTC_DT_TM DATETIME Y The Date/Time of the Medication Order Normalized to GMT
MED_SERVICE VARCHAR(50) Y The Medical Service at the Time of the Alert
NURSE_UNIT VARCHAR(50) Y The Nurse Unit at the Time of the Alert
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PLAN_ORD_DT_TM DATETIME Y The Date/Time of the PowerPlan Order
PLAN_ORD_UTC_DT_TM DATETIME Y The Date/Time of the PowerPlan Order Normalized to GMT
POPULATION_IND DOUBLE Y Identifies if the encounter is qualified initial population for Sepsis CCPS Audit Report
PREV_INFECTION_CNT DOUBLE Y The Count of Previous Infection Source Completions(Not Counting Most Recent)
PREV_PLAN_CNT DOUBLE Y The Count of Previous PowerPlan Completions(Not Counting Most Recent)
SEPSIS_CNT DOUBLE Y The Total Number of Sepsis Alerts on the Encounter.
SEPSIS_DX_IND DOUBLE Y Indicates if the Encounter has a SEPSIS Diagnoses.
SHOCK_CNT DOUBLE Y The Total Number of Shock Alerts on the Encounter.
SHOCK_DX_IND DOUBLE Y Indicates if the Encounter has a SHOCK Diagnoshs.
SIRS_CNT DOUBLE Y The Total Number of SIRS Alerts on the Encounter.
SIRS_DX_IND DOUBLE Y Indicates if the Encounter has a SIRS Diagnosis.
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_SEPSIS_PD_METRICS


Child Column in LH_F_SEPSIS_PD_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_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_FINANCIAL_CLASS_ID LH_D_FINANCIAL_CLASS D_FINANCIAL_CLASS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FINANCIAL_CLASS 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_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_F_SEPSIS_RT_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_SEPSIS_RT_METRICS
Definition: This table is used to store Sepsis Real Time Report Metrics . This table is at the Alert(Clincial Event) Grain.
Table Type: ACTIVITY





Column Detail - LH_F_SEPSIS_RT_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.
BILLING_DX VARCHAR(200) Y The Name of the Billing Diagnosis.
BILLING_DX_CODE VARCHAR(20) Y The Code of the Billing Diagnosis.
CE_EVENT_END_DT_TM DATETIME Y The Date/Time of the Clinical Event.
CE_EVENT_END_UTC_DT_TM DATETIME Y The Date/Time of the Clinical Event Normalized to GMT.
CE_EVENT_ID DOUBLE N The Clinical Event ID of the Alert.
CE_EVENT_TYPE VARCHAR(150) Y the Event Type of the Clinical Event.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CULTURE_COLLECT_DT_TM DATETIME Y The Date/Time of the Culture Collection
CULTURE_COLLECT_UTC_DT_TM DATETIME Y The Date/Time of the Culture Collection Normalized to GMT.
CULTURE_NAME VARCHAR(200) Y The Name of the Culture
CULTURE_ORD_DT_TM DATETIME Y The Date/Time of the Culture Order
CULTURE_ORD_UTC_DT_TM DATETIME Y The Date/Time of the Culture Order Normalized to GMT
CULTURE_RESULT DOUBLE Y The Result of the Culture
CULTURE_TR VARCHAR(20) Y The Time Remaining CountDown for the Culture
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_DX VARCHAR(200) Y The Name of the Discharge Diagnosis.
DISCHARGE_DX_CODE VARCHAR(20) Y The Code of the Discharge Diagnosis.
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 Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_FINANCIAL_CLASS_ID DOUBLE N Identifies the financial class of the encounter during registration
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
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.
FINAL_DX VARCHAR(200) Y The Name of the Final Diagnosis.
FINAL_DX_CODE VARCHAR(20) Y The Code of the Final Diagnosis.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_INFECTION_DT_TM DATETIME Y The Date/Time of the First Infection Source
FIRST_INFECTION_SRC VARCHAR(200) Y Name of the First Infection Source
FIRST_INFECTION_UTC_DT_TM DATETIME Y The Date/Time of the First Infection Source Normalized to GMT
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
FLUID_ADMIN_DT_TM DATETIME Y The Date/Time of the Fluid Administration.
FLUID_ADMIN_UTC_DT_TM DATETIME Y The Date/Time of the Fluid Administration Normalized to GMT.
FLUID_COMPLETE_DT_TM DATETIME Y The Date/Time of the Fluid Completion.
FLUID_COMPLETE_UTC_DT_TM DATETIME Y The Date/Time of the Fluid Completion Normalized to GMT
FLUID_INFUSE DOUBLE Y The Infusion Rate of the Fluid
FLUID_INFUSE_UNIT VARCHAR(20) Y The Infusion Rate Unit of the Fluid
FLUID_NAME VARCHAR(200) Y The Name of the Fluid
FLUID_ORD_DT_TM DATETIME Y The Date/Time of the Fluid Order
FLUID_ORD_UTC_DT_TM DATETIME Y The Date/Time of the Fluid Order Normalized to GMT
FLUID_RATE DOUBLE Y The Rate of the Fluid
FLUID_RATE_UNIT VARCHAR(20) Y The Rate Unit of the Fluid
FLUID_TR VARCHAR(20) Y The Time Remaining CountDown for the Fluid
FLUID_VOLUME DOUBLE Y The Volume of the Fluid
FLUID_VOLUME_UNIT VARCHAR(20) Y The Volume Unit of the Fluid
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.
ICU_IND DOUBLE Y Indicates if the Encounter has been in ICU.
LACTATE_COLLECT_DT_TM DATETIME Y The Date/Time of the Lactate Collection
LACTATE_COLLECT_UTC_DT_TM DATETIME Y The Date/Time of the Lactate Collection Normalized to GMT
LACTATE_NAME VARCHAR(200) Y The Name of the Lactate
LACTATE_ORD_DT_TM DATETIME Y The Date/Time of the Lactate Order
LACTATE_ORD_UTC_DT_TM DATETIME Y The Date/Time of the Lactate Order Normalized to GMT
LACTATE_RESULT DOUBLE Y The Result of the Lactate
LACTATE_TR VARCHAR(20) Y The Time Remaining CountDown for the Lactate
LAST_INFECTION_DT_TM DATETIME Y The Date/Time of the Last Infection Source
LAST_INFECTION_SRC VARCHAR(200) Y Name of the Last Infection Source
LAST_INFECTION_UTC_DT_TM DATETIME Y The Date/Time of the Last Infection Source Normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LENGTH_OF_STAY DOUBLE Y The Length of Stay of the Encounter.
LH_F_SEPSIS_RT_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_SEPSIS_RT_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MED_ADMIN_DT_TM DATETIME Y The Date/Time of the Medication Administration
MED_ADMIN_UTC_DT_TM DATETIME Y The Date/Time of the Medication Administration Normalized to GMT
MED_COMPLETE_DT_TM DATETIME Y The Date/Time of the Medication Completion
MED_COMPLETE_UTC_DT_TM DATETIME Y The Date/Time of the Medication Completion Normalized to GMT
MED_NAME VARCHAR(200) Y The Name of the Medication
MED_ORD_DT_TM DATETIME Y The Date/Time of the Medication Order
MED_ORD_UTC_DT_TM DATETIME Y The Date/Time of the Medication Order Normalized to GMT
MED_SERVICE VARCHAR(50) Y The Medical Service at the Time of the Alert
MED_TR VARCHAR(20) Y The Time Remaining CountDown for the Medication
NURSE_UNIT VARCHAR(50) Y The Nurse Unit at the Time of the Alert
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PLAN_ORD_DT_TM DATETIME Y The Date/Time of the PowerPlan Order
PLAN_ORD_UTC_DT_TM DATETIME Y The Date/Time of the PowerPlan Order Normalized to GMT
POPULATION_IND DOUBLE Y Identifies if the encounter is qualified initial population for Sepsis CCPS Audit Report
PREV_INFECTION_CNT DOUBLE Y The Count of Previous Infection Source Completions(Not Counting Most Recent)
PREV_PLAN_CNT DOUBLE Y The Count of Previous PowerPlan Completions(Not Counting Most Recent)
SEPSIS_CNT DOUBLE Y The Total Number of Sepsis Alerts on the Encounter.
SEPSIS_DX_IND DOUBLE Y Indicates if the Encounter has a SEPSIS Diagnoses.
SHOCK_CNT DOUBLE Y The Total Number of Shock Alerts on the Encounter.
SHOCK_DX_IND DOUBLE Y Indicates if the Encounter has a SHOCK Diagnoshs.
SIRS_CNT DOUBLE Y The Total Number of SIRS Alerts on the Encounter.
SIRS_DX_IND DOUBLE Y Indicates if the Encounter has a SIRS Diagnosis.
TOC_ADVISOR DOUBLE Y Time to Complete Advisor/PowerPlan
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_SEPSIS_RT_METRICS


Child Column in LH_F_SEPSIS_RT_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_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_FINANCIAL_CLASS_ID LH_D_FINANCIAL_CLASS D_FINANCIAL_CLASS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FINANCIAL_CLASS 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_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_F_STROKE_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_STROKE_METRICS
Definition: Contains data related to the Lighthouse stroke metrics.
Table Type: ACTIVITY





Column Detail - LH_F_STROKE_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.
ANTICOAG_DISC_FLAG DOUBLE Y Identifies if anticoagulation therapy was prescribed at discharge.
ANTITHR_DISC_FLAG DOUBLE Y Identifies if antithrombotic therapy was prescribed 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.
ASSESS_REHAB_FLAG DOUBLE Y Identifies if the patient has been assessed for rehab.
ATRIAL_FIB_FLUTTER_FLAG DOUBLE Y Identifies if the patient had atrial fibrillation/flutter documented.
BASE_POPULATION_IND DOUBLE Y Identified patients that qualify for the lighthouse stroke metric.
CLIN_TRIAL_EXCL_FLAG DOUBLE Y Identifies if the patient is excluded from the measure due to participation in a clinical trial.
CMO_ORDER_DT_TM DATETIME Y Identifies the date/time on which comfort measures were ordered.
CMO_ORDER_UTC_DT_TM DATETIME Y Identifies the date/time on which comfort measures were ordered.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CT_HEAD_EXAM_DT_TM DATETIME Y The date/time that the CT head exam was completed.
CT_HEAD_EXAM_UTC_DT_TM DATETIME Y The date/time that the CT head exam was completed.
CT_HEAD_READ_DT_TM DATETIME Y The date/time that the CT head exam was read.
CT_HEAD_READ_UTC_DT_TM DATETIME Y The date/time that the CT head exam was read.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged; normalized to GMT.
DISC_DISP_FLAG DOUBLE Y Identifies the discharge disposition of the patient.
DYSPHAGIA_SCR_DT_TM DATETIME Y The date/time that the dysphagia screening was completed.
DYSPHAGIA_SCR_UTC_DT_TM DATETIME Y The date/time that the dysphagia screening was completed.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstance under which the patient was admitted or will be admitted.
D_ATTEND_PRSNL_ID DOUBLE N The most recent attending physician associated with the encounter.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N The conditions under which the patient left the facility at the time of discharge.
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type, surgery, general resources, or others.
D_METRIC_01_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_02_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_03_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_04_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_05_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_06_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_07_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_08_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_09_ID DOUBLE N Identifies a metric associated with falls. 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.
D_PRIN_DIAGNOSIS_ID DOUBLE N The principal diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N The principal procedure associated with the encounter.
EDUCATION_IND DOUBLE Y Identifies if stroke education was completed.
EDUCATION_MASK DOUBLE Y Identifies the type of stroke education provided to the patient.
ED_ARRIVAL_DT_TM DATETIME Y Identifies the arrival date/time in the ED.
ED_ARRIVAL_UTC_DT_TM DATETIME Y Identifies the arrival date/time in the ED.
ED_ARRIVE_EMS_IND DOUBLE Y Identifies if the arrival mode was EMS.
ED_DISCHARGE_DT_TM DATETIME Y Identifies the discharge date/time from the ED.
ED_DISCHARGE_UTC_DT_TM DATETIME Y Identifies the discharge date/time from the ED.
ELECTIVE_CAROTID_EXCL_FLAG DOUBLE Y Identifies if the patient is excluded from the measure due to elective carotid intervention.
EMERGENCY_DEPT_FLAG DOUBLE Y Identifies if the patient was an ED patient.
EMERGENCY_DEPT_IND DOUBLE Y Identifies if the patient was admitted to the ED.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_10_IND DOUBLE Y Identifies patients excluded from STK-10
EXCLUDE_1_IND DOUBLE Y Identifies patients excluded from STK-1
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from STK-2
EXCLUDE_3_IND DOUBLE Y Identifies patients excluded from STK-3
EXCLUDE_4_IND DOUBLE Y Identifies patients excluded from STK-4
EXCLUDE_5_IND DOUBLE Y Identifies patients excluded from STK-5
EXCLUDE_6_IND DOUBLE Y Identifies patients excluded from STK-6
EXCLUDE_8_IND DOUBLE Y Identifies patients excluded from STK-8
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_STROKE_METRICS_ID DOUBLE N Unique identifier for the lighthouse stroke metrics.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IH_GI_BLEED_REG_DT_TM DATETIME Y The registration date/time of the encounter on which the patient had a brain bleed.
IH_GI_BLEED_REG_UTC_DT_TM DATETIME Y The registration date/time of the encounter on which the patient had a brain bleed.
ISCHEMIC_IND DOUBLE Y Identifies patients with ischemic stroke.
LAST_KNOWN_WELL_DT_TM DATETIME Y Identifies the date/time on which comfort measures were ordered.
LAST_KNOWN_WELL_FLAG DOUBLE Y Identifies if symptoms onset was witnessed.
LAST_KNOWN_WELL_UTC_DT_TM DATETIME Y Identifies the date/time on which comfort measures were ordered.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LDL_C_GTE_100_FLAG DOUBLE Y Identifies if the measured value for the LDL-c was greater than or equal to 100.
LDL_C_MEASURED_FLAG DOUBLE Y Identifies if the patient had an LDL-c within the first 48 hours of arrival or within 30 days prior to arrival.
LIPID_LOWER_PRE_ARR_FLAG DOUBLE Y Identifies if the patient had a lipid-lowering agent pre-arrival.
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.
NEURO_ORDER_DT_TM DATETIME Y The date/time the neurological consult was ordered.
NEURO_ORDER_UTC_DT_TM DATETIME Y The date/time the neurological consult was ordered.
NHIQM_VERSION DOUBLE Y Identifies the version of NHIQM for which the patient qualifies
NIH_ASSESS_DT_TM DATETIME Y The date/time that the NIH stroke assessment was completed.
NIH_ASSESS_UTC_DT_TM DATETIME Y The date/time that the NIH stroke assessment was completed.
NO_ANTICOAG_REASON_FLAG DOUBLE Y Identifies if there was a documented reason for not prescribing anticoagulation therapy.
NO_ANTITHR_REASON_FLAG DOUBLE Y Identifies if there is a reason for not prescribing antithrombotic therapy.
NO_ATHERO_EVIDENCE_FLAG DOUBLE Y Identifies patients without evidence of atherosclerosis.
NO_STATIN_REASON_FLAG DOUBLE Y Identifies if there is a documented reason for not prescribing Statin.
NO_TPA_EOD2_REASON_FLAG DOUBLE Y Identifies if there is a reason for not administering tPA by end of hospital day 2.
NO_TPA_REASON_FLAG DOUBLE Y Identifies if there is a reason for not initiating an IV thrombolytic.
NO_VTE_MECH_REASON_FLAG DOUBLE Y Identifies if there is a documented reason for not receiving mechanical VTE prophylaxis. 0 = Not Met; 1 = Met; 999 = Missing
NO_VTE_PROPH_REASON_FLAG DOUBLE Y Identifies if there is a reason for not receiving VTE prophylaxis. 0 = Not Met; 1 = Me; t999 = Missing
NUMERATOR_10_IND DOUBLE Y Identifies patients that qualify for STK-10
NUMERATOR_1_IND DOUBLE Y Identifies patients that qualify for STK-1
NUMERATOR_2_IND DOUBLE Y Identifies patients that qualify for STK-2
NUMERATOR_3_IND DOUBLE Y Identifies patients that qualify for STK-3
NUMERATOR_4_IND DOUBLE Y Identifies patients that qualify for STK-4
NUMERATOR_5_IND DOUBLE Y Identifies patients that qualify for STK-5
NUMERATOR_6_IND DOUBLE Y Identifies patients that qualify for STK-6
NUMERATOR_8_IND DOUBLE Y Identifies patients that qualify for STK-8
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
PHYS_SEE_DT_TM DATETIME Y The date/time at which the physician first saw the patient in the ED.
PHYS_SEE_UTC_DT_TM DATETIME Y The date/time at which the physician first saw the patient in the ED.
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
REJECT_10_IND DOUBLE Y Identifies patients excluded from STK-10
REJECT_1_IND DOUBLE Y Identifies patients excluded from STK-1
REJECT_2_IND DOUBLE Y Identifies patients excluded from STK-2
REJECT_3_IND DOUBLE Y Identifies patients excluded from STK-3
REJECT_4_IND DOUBLE Y Identifies patients excluded from STK-4
REJECT_5_IND DOUBLE Y Identifies patients excluded from STK-5
REJECT_6_IND DOUBLE Y Identifies patients excluded from STK-6
REJECT_8_IND DOUBLE Y Identifies patients excluded from STK-8
STATIN_DISC_FLAG DOUBLE Y Identifies if the patient was prescribed Statin at discharge.
STROKE_ORDER_SET_IND DOUBLE Y Identifies if the patient has a stroke order set initiated.
STROKE_PLAN_IND DOUBLE Y Identifies if the patient has a stroke plan initiated.
STROKE_SIGNS_IND DOUBLE Y Identifies if the patient has stroke signs or symptoms.
SYMP_ONSET_DT_TM DATETIME Y The stroke symptom onset date/time
SYMP_ONSET_UTC_DT_TM DATETIME Y The stroke symptom onset date/time
TPA_ADMIN_DT_TM DATETIME Y The date/time that tPA was administered.
TPA_ADMIN_FLAG DOUBLE Y Identifies if tPA has been administered.
TPA_ADMIN_UTC_DT_TM DATETIME Y The date/time that tPA was administered.
TPA_ADVISOR_COMP_DT_TM DATETIME Y The date/time that the tPA advisor was completed.
TPA_ADVISOR_COMP_UTC_DT_TM DATETIME Y The date/time that the tPA advisor was completed.
TPA_EOD2_FLAG DOUBLE Y Identifies if tPA was administered by the end of hospital day 2.
TPA_INITIATE_DT_TM DATETIME Y Identifies the date/time on which VTE prophylaxis was received.
TPA_INITIATE_FLAG DOUBLE Y Identifies if an IV thrombolytic has been initiated.
TPA_INITIATE_UTC_DT_TM DATETIME Y Identifies the date/time on which VTE prophylaxis was received.
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.
VTE_PROPHYLAXIS_DT_TM DATETIME Y Identifies the date/time on which VTE prophylaxis was received.
VTE_PROPHYLAXIS_MASK DOUBLE Y Identifies the type of VTE prophylaxis received.
VTE_PROPHYLAXIS_UTC_DT_TM DATETIME Y Identifies the date/time on which VTE prophylaxis was received.



Relationship Detail - LH_F_STROKE_METRICS


Child Column in LH_F_STROKE_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_PRIN_DIAGNOSIS_ID LH_D_DIAGNOSIS D_DIAGNOSIS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DIAGNOSIS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_01_ID LH_D_METRIC D_METRIC_ID
D_METRIC_02_ID LH_D_METRIC D_METRIC_ID
D_METRIC_03_ID LH_D_METRIC D_METRIC_ID
D_METRIC_04_ID LH_D_METRIC D_METRIC_ID
D_METRIC_05_ID LH_D_METRIC D_METRIC_ID
D_METRIC_06_ID LH_D_METRIC D_METRIC_ID
D_METRIC_07_ID LH_D_METRIC D_METRIC_ID
D_METRIC_08_ID LH_D_METRIC D_METRIC_ID
D_METRIC_09_ID LH_D_METRIC D_METRIC_ID
D_METRIC_10_ID LH_D_METRIC D_METRIC_ID
D_METRIC_11_ID LH_D_METRIC D_METRIC_ID
D_METRIC_12_ID LH_D_METRIC D_METRIC_ID
D_METRIC_13_ID LH_D_METRIC D_METRIC_ID
D_METRIC_14_ID LH_D_METRIC D_METRIC_ID
D_METRIC_15_ID LH_D_METRIC D_METRIC_ID
D_METRIC_16_ID LH_D_METRIC D_METRIC_ID
D_METRIC_17_ID LH_D_METRIC D_METRIC_ID
D_METRIC_18_ID LH_D_METRIC D_METRIC_ID
D_METRIC_19_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
D_PRIN_PROCEDURE_ID LH_D_PROCEDURE D_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PROCEDURE HEALTH_SYSTEM_SOURCE_ID


LH_F_UI_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_UI_METRICS
Definition: Fact table for inpatient Urinary Incontinence Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_F_UI_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.
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.
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. Foreign 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 patients that had Urinary Incontinence 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.
F_UI_METRICS_ID DOUBLE N Unique identifier for the lighthouse Urinary Incontinence 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.
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.
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
PERINEAL_SKIN_INTACT_IND DOUBLE Y Identifies patients that have perineal skin intact
PLAN_INITIATED_DT_TM DATETIME Y The date/time on which the PowerPlan or Orderset was ordered.
PLAN_INITIATED_IND DOUBLE Y Identifies patients that had the Urinary Incontinence PowerPlan or order set initiated.
PLAN_INITIATED_UTC_DT_TM DATETIME Y The date/time on which the PowerPlan or Orderset was ordered; normalized to GMT
PLAN_PRIOR_TO_FALL_IND DOUBLE Y Identifies patients that had a Urinary Incontinence Plan or Problem documented prior to a Fall
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.
PROVIDER_NOTIFIED_DT_TM DATETIME Y The date/time on which the Provider was notified of the symptoms for the patient.
PROVIDER_NOTIFIED_UTC_DT_TM DATETIME Y The date/time on which the Provider was notified of the symptoms for the patient; normalized to GMT.
SUPRAPUBIC_PAIN_DT_TM DATETIME Y The date/time on which Suprapubic Pain first occurred for the patient.
SUPRAPUBIC_PAIN_UTC_DT_TM DATETIME Y The date/time on which the Suprapubic Pain first occurred for the patient; normalized to GMT.
UI_IND DOUBLE Y Identifies patients that had a Urinary Incontinence problem documented
UI_SYMPTOMS_DT_TM DATETIME Y The date/time on which the Urinary Incontinence first occurred for the patient.
UI_SYMPTOMS_UTC_DT_TM DATETIME Y The date/time on which the Urinary Incontinence first occurred for the patient; 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.
UTI_SYMPTOMS_DT_TM DATETIME Y The date/time on which the Urinary Tract Infection first occurred for the patient.
UTI_SYMPTOMS_UTC_DT_TM DATETIME Y The date/time on which the Urinary Tract Infection first occurred for the patient; normalized to GMT.



Relationship Detail - LH_F_UI_METRICS


Child Column in LH_F_UI_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