Table Detail Report
LH_F_CRI_ENCNTR_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_CRI_ENCNTR_METRICS |
Definition: | This table is used to store metrics for the Lighthouse CRI quality measure. |
Table Type: | ACTIVITY |
Column Detail - LH_F_CRI_ENCNTR_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACT_ART_CNT | DOUBLE | Y | Identifies the number of arterial lines inserted during the visit. |
ACT_IABP_CNT | DOUBLE | Y | Identifies the number of IABP lines inserted during the visit. . |
ACT_LA_CNT | DOUBLE | Y | Identifies the number of left atrial lines inserted during the visit. . |
ACT_PA_CNT | DOUBLE | Y | Identifies the number of pulmonary artery lines inserted during the visit. |
ACT_PERIPH_CNT | DOUBLE | Y | Identifies the number of peripheral IV lines inserted during the visit. . |
ADMIT_DT_TM | DATETIME | Y | The date and time when the patient was admitted to the hospital |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility; normalized to GMT. |
ART_LINE_DAYS | DOUBLE | Y | The total number of arterial line days during this visit. |
CENTRAL_LINE_DAYS | DOUBLE | Y | Identifies the number of central line days during the visit. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
CONTRA_REASON_IND | DOUBLE | Y | Identifies if patient has preferred site contraindication reason documented. |
CVL_CHK_CNT | DOUBLE | Y | Identifies the number of times the central venous line checklist was used during the visit. |
CVL_CHK_RECOMMEND_CNT | DOUBLE | Y | Identifies the number of times the central line checklist recommendations were followed during the visit. |
CVL_DAILY_ASSESS_CNT | DOUBLE | Y | Identifies the number of central lines that were assessed daily during the visit. |
CVL_DIALYSIS_CNT | DOUBLE | Y | Identifies the number of dialysis central lines inserted during the visit. . |
CVL_DIALYSIS_LINE_DAYS | DOUBLE | Y | The total number of dialysis central line days during this visit. |
CVL_IMP_PORT_CNT | DOUBLE | Y | Identifies the number of implanted prot central lines inserted during the visit. . |
CVL_IMP_PORT_LINE_DAYS | DOUBLE | Y | The total number of implanted prot central line days during this visit. |
CVL_INFECTION_CNT | DOUBLE | Y | Identifies the number of central venous lines that resulted in an infection during the visit. |
CVL_INSERTED_CNT | DOUBLE | Y | Identifies the number of central venous lines that were inserted during the visit. |
CVL_INT_SHEATH_CNT | DOUBLE | Y | Identifies the number of introducer sheath central lines inserted during the visit. |
CVL_INT_SHEATH_LINE_DAYS | DOUBLE | Y | The total number of introducer sheath central line days during this visit. |
CVL_PICC_CNT | DOUBLE | Y | Identifies the number of PICC central lines inserted during the visit. |
CVL_PICC_LINE_DAYS | DOUBLE | Y | The total number of PICC central line days during this visit |
CVL_POA_IND | DOUBLE | Y | Identifies if the patient had a central venous line present upon admission. |
CVL_TUNNEL_CNT | DOUBLE | Y | Identifies the number of tunneled central lines inserted during the visit. |
CVL_TUNNEL_LINE_DAYS | DOUBLE | Y | The total number of tunneled central line days during this visit |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged; normalized to GMT. |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_ENCNTR_TYPE_ID | DOUBLE | N | Unique identifier for the encounter type. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_01_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_02_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_03_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_04_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_05_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_06_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_07_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_08_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_09_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_10_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_11_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_12_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_13_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_14_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_15_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_16_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_17_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_18_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_19_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_20_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
FOLEY_DAILY_ASSESS_CNT | DOUBLE | Y | Identifies the number of foley catheter that were appropriately assessed daily. |
FOLEY_DAYS | DOUBLE | Y | Identifies the number of indwelling catheter days during the visit. |
FOLEY_DOC_INDICATION_CNT | DOUBLE | Y | Identifies the number of times an indication reason was documented for hospital inserted indwelling catheters. |
FOLEY_INFECTION_CNT | DOUBLE | Y | Identifies the number of urinary tract infections that result from hospital insertions of an indwelling catheter. |
FOLEY_INSERTED_CNT | DOUBLE | Y | Identifies the number of indwelling urinary catheters that were inserted during the visit. |
FOLEY_POA_IND | DOUBLE | Y | Identifies if an indwelling urinary catheter was present upon admission. |
F_CRI_ENCNTR_METRICS_ID | DOUBLE | N | Identifier for the lighthouse CRI encounter metrics. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
IABP_LINE_DAYS | DOUBLE | Y | The total number of IABP line days during this visit. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LA_LINE_DAYS | DOUBLE | Y | The total number of left atrial line days during this visit. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PA_LINE_DAYS | DOUBLE | Y | The total number of pulmonary arterial line days during this visit. |
PERIPH_LINE_DAYS | DOUBLE | Y | The total number of peripheral IV line days during this visit. |
POPULATION_IND | DOUBLE | Y | Identifies if the encounter qualifies for the falls population. |
SITE_FEM_IND | DOUBLE | Y | Identifies the patient has non-tunneled central line with site femoral inserted during the visit. |
SITE_SUB_IND | DOUBLE | Y | Identifies tif the patient has non-tunneled central line with site subclavian inserted during the visit. |
SITE_UMB_ART_CNT | DOUBLE | Y | Identifies the number of central line with site umbilical artery inserted during the visit. |
SITE_UMB_VEIN_CNT | DOUBLE | Y | Identifies the number of central line with site umbilical vein inserted during the visit. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_F_CRI_ENCNTR_METRICS
Child Column in LH_F_CRI_ENCNTR_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_MED_SERVICE_ID | LH_D_MED_SERVICE | D_MED_SERVICE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_MED_SERVICE | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_01_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_02_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_03_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_04_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_05_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_06_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_07_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_08_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_09_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_10_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_11_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_12_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_13_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_14_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_15_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_16_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_17_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_18_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_19_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_20_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID |
Parent Column in LH_F_CRI_ENCNTR_METRICS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | F_CRI_ENCNTR_METRICS_ID | LH_F_CRI_CE_METRICS | F_CRI_ENCNTR_METRICS_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CRI_CE_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_F_DELIRIUM_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_DELIRIUM_METRICS |
Definition: | Fact table for Delirium Lighthouse Report |
Table Type: | ACTIVITY |
Column Detail - LH_F_DELIRIUM_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date and time when the patient was admitted to the hospital |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility; normalized to GMT. |
ASSESS_HRS_IND | DOUBLE | Y | Identifies the client configurable number of hours prior to assessment |
ASSESS_MET_IND | DOUBLE | Y | Identifies if the patient received an assessment within the defined assessed hours timeframe |
AT_RISK_TIME_IND | DOUBLE | Y | Identifies if the patient was identified at risk of Delirium with Delirium |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DELIR_CONFIRMED_FLAG | DOUBLE | Y | Identifies if the patient had a confirmed Delirium status. 0 - No; 1 - Yes; 999 - Missing |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged; normalized to GMT. |
DX_PROB_IND | DOUBLE | Y | Identifies if the patient had a Delirium diagnosis or problem |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID | DOUBLE | N | Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | The conditions under which the patient left the facility at the time of discharge. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_10_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_11_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_12_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_13_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_14_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_15_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_16_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_17_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_18_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_19_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_1_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_20_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_2_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_3_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_4_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_5_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_6_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_7_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_8_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_9_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Describes the principle procedure that was performed during the patient visit. |
EDUCATION_FLAG | DOUBLE | Y | Identifies if the patient had Delirium education documented. 0 - No; 1 - Yes; 999 - Missing |
EDUCATION_TIMING_IND | DOUBLE | Y | Identifies if the patient had a responsible learner present no later than 5 minutes after the Delirium education. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
FALL_IND | DOUBLE | Y | Identifies if the patient had a Delirium fall after delirium was identified |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
F_DELIRIUM_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_DELIRIUM_METRICS table. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LOC_ICU_DIAG_IND | DOUBLE | Y | Identifies if the patient's first delirium diagnosis occurred in the ICU |
LOC_ICU_FALL_IND | DOUBLE | Y | Identifies if the patient's documented Delirium fall occurred in the ICU |
LOC_ICU_RESTRAINT_IND | DOUBLE | Y | Identifies if the patient's documented restraint occurred in the ICU |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
MENTAL_STATUS_IND | DOUBLE | Y | Identifies if the patient has had a mental status disturbances screening documented |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PLAN_IND | DOUBLE | Y | Identifies if the patient was on a plan |
POPULATION_IND | DOUBLE | Y | Identifies patients that qualify for the base population for the Lighthouse metric. |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed; normalized to GMT |
RESPONSIBLE_LEARNER_FLAG | DOUBLE | Y | Identifies if the patient had a responsible learner present during education. 0 - No; 1 - Yes; 999 - Missing |
RESTRAINT_IND | DOUBLE | Y | Identifies if restraints were ordered for the patient |
RISK_IND | DOUBLE | Y | Identifies if the patient is at risk for Delirium |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_F_DELIRIUM_METRICS
Child Column in LH_F_DELIRIUM_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_PRIN_DIAGNOSIS_ID | LH_D_DIAGNOSIS | D_DIAGNOSIS_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DIAGNOSIS | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_MED_SERVICE_ID | LH_D_MED_SERVICE | D_MED_SERVICE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_MED_SERVICE | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_10_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_11_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_12_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_13_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_14_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_15_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_16_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_17_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_18_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_19_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_20_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_3_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_4_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_5_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_6_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_7_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_8_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_9_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_DEPRESSION_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_DEPRESSION_METRICS |
Definition: | Fact table for Depression Lighthouse Report |
Table Type: | ACTIVITY |
Column Detail - LH_F_DEPRESSION_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date and time when the patient was admitted to the hospital |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility; normalized to GMT. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
COM_RES_EDU_IND | DOUBLE | Y | Identifies if the patient had suicide prevention community Resources Education Documented |
COM_RES_PT_UNDERSTAND_IND | DOUBLE | Y | Identifies if the patient had verbalized understanding of community resources |
DEPR_INIT_SCREEN_IND | DOUBLE | Y | Identifies if the patient had actual or suspected pain during their visit. |
DEPR_INIT_SCREEN_SCORE | DOUBLE | Y | Identifies the depression symptom score |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged; normalized to GMT. |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID | DOUBLE | N | Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | The conditions under which the patient left the facility at the time of discharge. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_10_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_11_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_12_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_13_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_14_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_15_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_16_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_17_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_18_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_19_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_1_ID | DOUBLE | Y | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_20_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_2_ID | DOUBLE | Y | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_3_ID | DOUBLE | Y | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_4_ID | DOUBLE | Y | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_5_ID | DOUBLE | Y | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_6_ID | DOUBLE | Y | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_7_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_8_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_9_ID | DOUBLE | N | Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Describes the principle procedure that was performed during the patient visit. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
F_DEPRESSION_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_DEPRESSION_METRICS table. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NEG_POS_SCREEN_SCORE_IND | DOUBLE | Y | FIRST Initial Depression Screen score (documented within 24 hrs of admission) is negative and total depression screen score is positive |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PLAN_TIME_8H_IND | DOUBLE | Y | Identifies if the patient was placed on a depressive symptom-suicide prevention plan within 8 hr of a positive score |
POPULATION_IND | DOUBLE | Y | Identifies if the patient was screened for depressive symptoms within 24 hrs |
POS_24H_IND | DOUBLE | Y | Identifies if the patient was screened for total depressive symptoms within 24 hours of admission with a positive score |
POS_TOTAL_DEPR_IND | DOUBLE | Y | Identifies if the patient had a total depression screen documented >=5 |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed; normalized to GMT |
SUICIDE_PRECAUTIONS_IND | DOUBLE | Y | Identifies if the patient had Suicide Precaution ordered |
SUICIDE_PREVENT_EDU_IND | DOUBLE | Y | Identifies if the patient had suicide prevention Education Documented |
SYMPT_MGMT_EDU_IND | DOUBLE | Y | Identifies if the patient had depressive symptom Mgmt Education Documented |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_F_DEPRESSION_METRICS
Child Column in LH_F_DEPRESSION_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_PRIN_DIAGNOSIS_ID | LH_D_DIAGNOSIS | D_DIAGNOSIS_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DIAGNOSIS | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_MED_SERVICE_ID | LH_D_MED_SERVICE | D_MED_SERVICE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_MED_SERVICE | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_10_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_11_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_12_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_13_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_14_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_15_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_16_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_17_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_18_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_19_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_20_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_3_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_4_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_5_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_6_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_7_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_8_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_9_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_DYSPHAGIA_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_DYSPHAGIA_METRICS |
Definition: | Fact table for Dysphagia Lighthouse Report. |
Table Type: | ACTIVITY |
Column Detail - LH_F_DYSPHAGIA_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted. |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility; normalized to GMT. |
CARDIAC_SURG_FLAG | DOUBLE | Y | Identifies if the patient was a cardiac surgery patient.0 = Patient did not have cardiac surgery; 1 = Cardiac surgery defined in SurgiNet; 2 = Cardiac procedure defined through HIM |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged; normalized to GMT. |
DYS_EDUCATION_IND | DOUBLE | Y | Identifies if dysphagia education was documented. |
DYS_PLAN_IND | DOUBLE | Y | Identifies if the patient was on a dysphagia management plan |
DYS_PROB_DX_DT_TM | DATETIME | Y | Identifies the onset date/time of the dysphagia diagnosis/problem. |
DYS_PROB_DX_IND | DOUBLE | Y | Identifies if the patient had a dysphagia diagnosis or problem. |
DYS_PROB_DX_UTC_DT_TM | DATETIME | Y | Identifies the onset date/time of the dysphagia diagnosis/problem. |
DYS_SYMPTOM_MASK | DOUBLE | Y | The dysphagia symptoms documented on the patient.0 = No dysphagia symptoms1 = Slow or slurred speech2 = Speech disturbance4 = Absence of gag reflex8 = Choking with swallowing16 = Coughing with swallowing32 = Throat clearing64 = Absent or weak voluntary cough |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID | DOUBLE | N | Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | The conditions under which the patient left the facility at the time of discharge. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type, surgery, general resources, or others. |
D_METRIC_10_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_11_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_12_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_13_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_14_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_15_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_16_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_17_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_18_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_19_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_1_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_20_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_2_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_3_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_4_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_5_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_6_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_7_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_8_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_9_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Identifies the principle procedure associated with the encounter. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
F_DYSPHAGIA_METRICS_ID | DOUBLE | N | Unique identifier for the lighthouse dysphagia metrics |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
INPATIENT_ADMIT_DT_TM | DATETIME | Y | Identifies the date/time on which the patient became an inpatient. |
INPATIENT_ADMIT_UTC_DT_TM | DATETIME | Y | Identifies the date/time on which the patient became an inpatient. |
INTUBATION_DURATION_IND | DOUBLE | Y | Identifies if intubation lasted longer than 48 hours. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NO_ASPIRATION_SYMPTOM_IND | DOUBLE | Y | Identifies if there were no symptoms of aspiration documented. |
NPO_DURATION_IND | DOUBLE | Y | Identifies if the patient was NPO longer than 48 hours. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
POPULATION_IND | DOUBLE | Y | Identifies patients that qualify for the base population for the Lighthouse metric. |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed; normalized to GMT. |
SLP_EVAL_IND | DOUBLE | Y | Identifies if a speech language pathology order was placed. |
STK_DX_DT_TM | DATETIME | Y | Identifies the onset date/time of the stroke diagnosis. |
STK_DX_IND | DOUBLE | Y | Identifies if the patient had a stroke diagnosis. |
STK_DX_UTC_DT_TM | DATETIME | Y | Identifies the onset date/time of the stroke diagnosis. |
SWALLOW_EVAL_IND | DOUBLE | Y | Identifies if a swallow evaluation was ordered. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_F_DYSPHAGIA_METRICS
Child Column in LH_F_DYSPHAGIA_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_PRIN_DIAGNOSIS_ID | LH_D_DIAGNOSIS | D_DIAGNOSIS_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DIAGNOSIS | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_MED_SERVICE_ID | LH_D_MED_SERVICE | D_MED_SERVICE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_MED_SERVICE | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_10_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_11_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_12_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_13_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_14_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_15_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_16_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_17_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_18_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_19_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_20_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_3_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_4_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_5_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_6_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_7_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_8_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_9_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_FALLS_DTL_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_FALLS_DTL_METRICS |
Definition: | Fact table for Falls Detail Lighthouse Report |
Table Type: | ACTIVITY |
Column Detail - LH_F_FALLS_DTL_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
D_FALL_BUILDING_ID | DOUBLE | Y | The building in which the patient had a fall. |
D_FALL_DOCU_PRSNL_ID | DOUBLE | N | Identifies the person that documented the fall. |
D_FALL_FACILITY_ID | DOUBLE | Y | The facility in which the patient had a fall. |
D_FALL_NURSE_UNIT_ID | DOUBLE | Y | The nurse unit in which the patient had a fall. |
ENCNTR_ID | DOUBLE | Y | Identifies the encounter against which the quality measure is associated. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
FALL_ACTIVITY_MASK | DOUBLE | Y | Identifies the activity at the time of the fall |
FALL_CONDITION_MASK | DOUBLE | Y | Identifies the condition(s) at the time of the fall |
FALL_DEV_IND | DOUBLE | N | Identifies if the fall was a developmental fall. |
FALL_IND | DOUBLE | Y | Identifies each fall |
FALL_LOCATION_MASK | DOUBLE | Y | Identifies the location(s) at the time of the fall |
FALL_NON_DEV_IND | DOUBLE | N | Identifies if the fall was a non-developmental fall. |
FALL_UNASSISTED_IND | DOUBLE | Y | Identifies if the fall was unassisted |
FALL_UNWITNESSED_IND | DOUBLE | Y | Identifies if the fall was unwitnessed |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
F_FALLS_DTL_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_FALLS_DTL_METRICS table. |
HEALTH_SYSTEM_ID | DOUBLE | Y | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
INCDNT_DT_TM | DATETIME | Y | The date/time on which the incident occurred for the patient. |
INCDNT_UTC_DT_TM | DATETIME | Y | The date/time on which the incident first occurred for the patient; normalized to GMT. |
INJURY_IND | DOUBLE | Y | Identifies if the fall resulted in an injury |
INJURY_LEVEL_TXT | VARCHAR(50) | Y | Identifies the injury level of the fall |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LOGICAL_DOMAIN_ID | DOUBLE | Y | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
MOD_SEVERE_INJURY_IND | DOUBLE | Y | Identifies if the fall resulted in a moderate or severe injury |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
PRIOR_ASSESS_DT_TM | DATETIME | Y | Date time of the most recent assessment prior to the fall |
PRIOR_ASSESS_UTC_DT_TM | DATETIME | Y | Date time of the most recent assessment prior to the fall; normalized to GMT |
RISK_PRIOR_FALL_IND | DOUBLE | Y | Identifies if the patient was at risk prior to this incident. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_F_FALLS_DTL_METRICS
Child Column in LH_F_FALLS_DTL_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_FALL_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_FALL_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_FALL_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_FALL_DOCU_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |