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 |