Table Detail Report

LH_F_REST_HST_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_REST_HST_METRICS
Definition: Fact table for Restraint Management History Lighthouse Reporting
Table Type: ACTIVITY





Column Detail - LH_F_REST_HST_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the unit
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the unit.; normalized to GMT
AT_RISK_IND DOUBLE Y Identifies if the patient is at risk.
DEPART_DT_TM DATETIME Y The date/time on which the patient left the unit.
DEPART_UTC_DT_TM DATETIME Y The date/time on which the patient left the unit; normalized to GMT.
D_BUILDING_ID DOUBLE N The building the patient spent time in.
D_FACILITY_ID DOUBLE N The facility the patient spent time in.
D_NURSE_UNIT_ID DOUBLE N The nurse unit the patient spent time in.
EDUCATION_IND DOUBLE Y Identifies if the patient has received restraint education.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
F_REST_HST_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_REST_HST_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 the logical domain. This identifier allows the data to be grouped by logical domain.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged.
PLAN_INITIATED_IND DOUBLE Y Identifies if patient has a restraint prevention plan of care was initiated
RESTRAINT_IND DOUBLE Y Identify if the patient has the restraint in the unit.
RISK_PRIOR_RESTRAINT_IND DOUBLE Y Identifies patients that are at risk- had an restrained document- and were at risk prior to the restraint
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_REST_HST_METRICS


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


LH_F_REST_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_REST_METRICS
Definition: Fact table for Restraint Management Lighthouse Reporting
Table Type: ACTIVITY





Column Detail - LH_F_REST_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.
AT_RISK_IND DOUBLE Y Identifies if the patient is at risk.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged; normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter during the visit.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N The conditions under which the patient left the facility at the time of discharge.
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type- surgery- general resources- or others.
D_METRIC_10_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_11_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_12_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_13_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_14_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_15_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_16_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_17_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_18_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_19_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_20_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_6_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_7_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_8_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_9_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
D_PRIN_DIAGNOSIS_ID DOUBLE N Identifies the principle diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Identifies the principle procedure associated with the encounter.
EDUCATION_IND DOUBLE Y Identifies patients that has restraint at risk education documented.
ED_ENCNTR_ID DOUBLE Y Identifies if the current or previous encounter was admitted to the ED. In order to qualify- the previous encounter should have been discharged within 30 minutes.
ED_RESTRAINT_IND DOUBLE Y Identifies patients who were restrained on admission to ED
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_REST_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_REST_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 the logical domain. This identifier allows the data to be grouped by logical domain.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PLAN_INITIATED_IND DOUBLE Y Identifies patients if the PowerPlan has been initiated or the order set has been ordered.
POPULATION_IND DOUBLE Y Identifies patients that qualify for the ventilated 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
RESTRAINT_IND DOUBLE Y Identifies patients who are restrained
RISK_DT_TM DATETIME Y Identifies when the first at risk document for restraint for patients
RISK_PRIOR_RESTRAINT_IND DOUBLE Y Identifies patients that are at risk- had an restrained document- and were at risk prior to the restraint
RISK_UTC_DT_TM DATETIME Y Identifies when the first at risk document for restraint for patients; normalized to GMT
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_F_REST_METRICS


Child Column in LH_F_REST_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_RRT_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_RRT_METRICS
Definition: Fact table for Rapid Response Team Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_F_RRT_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.
CODE_BLUE_CNT DOUBLE Y Number of RRT-related code blues during the visit
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 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.
EXPIRED_IND DOUBLE Y Identifies if the patient expired during the visit.
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_RRT_METRICS_ID DOUBLE N Unique identifier for the lighthouse rapid response team metrics
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time 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.
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.
RRT_ACT_CNT DOUBLE Y Number of RRT activations during the visit
RRT_ACT_REASON_MASK DOUBLE Y Identifies the reason for RRT activation 1 = Activation w/out reason 2 = Systolic blood pressure 4 = Heart rate range 8 = Respiratory evaluation 16 = Neurological evaluation 32 = Blood glucose evaluation 64 = Staff concern
RRT_ACT_TO_BEDSIDE_CNT DOUBLE Y The number of RRT activations where arrival at bedside is documented.
RRT_ACT_TO_BEDSIDE_MIN DOUBLE Y The number of minutes from RRT activation to arrival at bedside.
RRT_ACT_TO_DEPART_CNT DOUBLE Y The number of RRT activations where departure from bedside is documented.
RRT_ACT_TO_DEPART_MIN DOUBLE Y The total duration of the RRT event.
RRT_ACT_TO_ICU_CNT DOUBLE Y The number of RRT activations where the patient was transferred to the ICU.
RRT_ACT_TO_ICU_DAYS DOUBLE Y The total number of days in the ICU after an RRT transfer.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. 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_RRT_METRICS


Child Column in LH_F_RRT_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_SCIP_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_SCIP_METRICS
Definition: This table is used to store metrics for the Lighthouse Surgical Care Improvement quality measure.
Table Type: ACTIVITY





Column Detail - LH_F_SCIP_METRICS


Column Name Type Null? Definition
ABX_EXTEND_REASON_MASK DOUBLE Y Identifies the reasons to extend antibiotics
ABX_RECD_MASK DOUBLE Y Identifies when the patient received antibiotics.
AB_24H_ANES_EXCL_IND DOUBLE Y Identified all antibiotic does administrated date/time are more than 24 hours after anesthesia end date.
AB_ADMIN_IND DOUBLE Y Identified patient has antibiotic dose(s) administered
AB_ALLERGY_FLAG DOUBLE Y Identifies patients that have allergies, sensitivities or intolerance to beta-lactam/penicillin antibiotic or cephalosporin medications
AB_ANES_EXCL_IND DOUBLE Y Identifiedall antibiotic does administrated date are not in propertiy days range after anesthesia end date.
AB_DISC_24H_IND DOUBLE Y Identifies if the patient had antibiotics discontinued within 24 hours of the end of surgery.
AB_DISC_MORE_24H_IND DOUBLE Y Identifies patients that had any antibiotics discontinue more than 24 hours of surgery end.
AB_NAME_3_11_EXCL_IND DOUBLE Y Identified patient has antibiotic name on table 3.11
AB_RECD_24H_ADM_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
AB_RECD_24H_SURG_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
AB_RECD_WIN_1H_IND DOUBLE Y Identifies if the patient received an antibiotic within 1 hour of surgical incision.
AB_ROUTE_IM_EXCL_IND DOUBLE Y Identified patient all of Antibiotic Administration Route are IM (Intramuscular) or other not oral/IV.
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.
ACTIVE_WARMING_IND DOUBLE Y Identifies patients that had active warming performed intraoperatively.
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.
AGE_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
ANES_END_DT_TM DATETIME Y The anesthesia end date/time for the principle procedure.
ANES_END_UTC_DT_TM DATETIME Y The anesthesia end date/time for the principle procedure.
ANES_START_DT_TM DATETIME Y The anesthesia start date/time for the principle procedure.
ANES_START_UTC_DT_TM DATETIME Y The anesthesia start date/time for the principle procedure.
ANES_TYPE_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
ANES_TYPE_FLAG DOUBLE Y Identifies the type of anesthesia received.
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.
BASE_POPULATION_IND DOUBLE Y Identifies the patients that qualify for the SCIP base population.
BETA_BLK_PERIOP_FLAG DOUBLE Y Identifies patients that received a beta blocker perioperatively.
BETA_BLK_PERIOP_MASK DOUBLE Y Identifies patients that received beta blocker perioperatively.
BETA_BLK_PREG_FLAG DOUBLE Y Identifies female patients that are on a beta blocker during pregnancy.
BETA_BLK_PRIOR_FLAG DOUBLE Y Identifies patients that were on a beta blocker prior to arrival.
BETA_PERIOP_INCL_IND DOUBLE Y Identifies patients that received a beta blocker perioperatively.
BETA_PREG_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
BETA_PRIOR_ADMIT_INCL_IND DOUBLE Y Identifies patients that were on a beta blocker prior to arrival.
BURN_DX_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
CARD_2_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
CARD_PROC_IND DOUBLE Y Identifies patients that had cardiac procedures performed.
CLIN_TRIAL_EXCL_FLAG DOUBLE Y Identifies if the patient is excluded from the measure due to participation in a clinical trial.
CLIN_TRIAL_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
COLON_PROC_ORAL_ABX_FLAG DOUBLE Y Identifies color surgery patients that received oral antibiotics
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CONTROLLED_GLUCOSE_FLAG DOUBLE Y Identifies patients with a controlled post-operative blood glucose level.
CONTROLLED_GLUCOSE_IND DOUBLE Y Identifies patients with controlled glucose levels.
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_CARD_2_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
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_INF_10_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
D_INF_1_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
D_INF_2_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
D_INF_3_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
D_INF_4_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
D_INF_6_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
D_INF_9_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
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.
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.
D_PROC_GROUP_ID DOUBLE N Identifies the surgical procedure group associated with the principle procedure.
D_VTE_1_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
D_VTE_2_METRIC_ID DOUBLE N The unique identifier for the SCIP metric.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_CARD_2_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_INF_10_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_INF_1_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_INF_2_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_INF_3_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_INF_4_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_INF_6_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_INF_9_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_VTE_1_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_VTE_2_IND DOUBLE Y Identifies if the patient is excluded from the measure.
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_SCIP_METRICS_ID DOUBLE N Unique identifier for the lighthouse PN Metrics
HAIR_REMOVAL_MASK DOUBLE Y Identifies the preoperative hair removal method.
HAIR_REMOVE_APPROP_IND DOUBLE Y Identifies patients that had hair removed via an appropriate method.
HAIR_REMOVE_PT_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
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.
HIP_FRAC_DX_IND DOUBLE Y Identifies Hip Fracture diagnosis patients.
HYST_WITH_CSECT_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
INF_10_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
INF_1_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
INF_2_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
INF_3_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
INF_4_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
INF_6_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
INF_9_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
INF_DISEASE_DX_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
INF_PRIOR_ANES_EXCEPT_FLAG DOUBLE Y Identifies if a patient has infection exceptions prior to anesthesia documented
INF_PRIOR_ANES_EXCL_FLAG DOUBLE Y Identifies patients that had an infection prior to anesthesia
INF_PRIOR_ANES_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
INTENT_HYPOTHERM_EXCL_FLAG DOUBLE Y Identifies patients that had intentional hypothermia documented.
INTENT_HYPOTHERM_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
JOINT_REVISION_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
LAPAROSCOPE_EXCL_FLAG DOUBLE Y Identifies patients that had the procedure performed entirely by laparoscope.
LAPAROSCOPE_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
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.
LOS_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
LVAD_PROC_IND DOUBLE Y Identifies patients with Ventricular Assist Devices or Heart Transplantation procedure
NHIQM_VERSION DOUBLE Y Identifies the version of NHIQM for which the row qualifies.
NO_AB_RECD_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
NO_BETA_BLK_REASON_FLAG DOUBLE Y Identifies patients with a valid reason documented for not receiving a beta blocker perioperatively.
NO_BETA_BLK_REASON_MASK DOUBLE Y Identifies patients with valid reason documented for not receiving a beta blocker perioperatively.
NO_BETA_REASON_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
NO_PROPH_AB_RECD_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
NO_PROPH_RECD_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
NO_VTE_MECH_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
NO_VTE_PHARM_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
NO_VTE_PROPH_REASON_MASK DOUBLE Y Identifies the reasons documented for not administering VTE prophylaxis.
NO_VTE_PROPH_RECD_FLAG DOUBLE Y Identifies patients that did not receive VTE prophylaxis.
NUMERATOR_CARD_2_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_INF_10_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_INF_1_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_INF_2_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_INF_3_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_INF_4_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_INF_6_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_INF_9_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_VTE_1_IND DOUBLE Y Identifies if the patient qualifies for the measure.
NUMERATOR_VTE_2_IND DOUBLE Y Identifies if the patient qualifies for the measure.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTHER_SURG_PROC_EXCL_FLAG DOUBLE Y Identifies patients that had other surgical procedures performed within days of the current procedure.
OTHER_SURG_PROC_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PERIOP_DEATH_EXCL_FLAG DOUBLE Y Identifies patients that suffered a perioperative death.
PERIOP_DEATH_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
POSTOP_CATH_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
POSTOP_CATH_INCL_IND DOUBLE Y Identifies patients that received an indwelling catheter post-op.
POST_OP_INF_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
PREOP_CATH_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
PRE_WARFARIN_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP 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.
PROC_GROUP_MEANING VARCHAR(50) Y Identifies the Cerner-defined meaning associated with the procedure group.
PROPH_AB_SELECTED_IND DOUBLE Y Identifies if the patient had a prophylactic antibiotic selected.
SURG_INCISION_DT_TM DATETIME Y Identifies if the date/time that the incision for the principal procedure was made
SURG_INCISION_UTC_DT_TM DATETIME Y Identifies if the date/time that the incision for the principal procedure was made
TEMP_CONTROL_MASK DOUBLE Y Identifies how the temperature was controlled during surgery.
TRANSPLANT_DX_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
UC_CONTINUE_REASON_FLAG DOUBLE Y Identifies the reasons for continuing the urinary catheter
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.
URINARY_ANTI_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
URINARY_CATHETER_FLAG DOUBLE Y Identifies when the urinary catheter was placed.
URO_GYN_PROC_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
UR_CATH_NO_RMV_EXCL_IND DOUBLE Y Identifies patients excluded from the SCIP metric.
UR_CATH_RMV_DT_TM DATETIME Y The date abd time the urinary catheter was removed.
UR_CATH_RMV_UTC_DT_TM DATETIME Y The date abd time the urinary catheter was removed.normalized to GMT.
VANCOMYCIN_MASK DOUBLE Y Identifies the VTE prophylaxis selected.
VTE_1_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
VTE_2_REJECT_IND DOUBLE Y Identifies if the patient record was rejected from the SCIP metric due to missing data.
VTE_PROC VARCHAR(50) Y Identifies patients with procedures specific to the VTE metrics.
VTE_PROC_IND DOUBLE Y Identifies if the patient had a principle procedure specific to the VTE metric.
VTE_PROPHYLAXIS_MASK DOUBLE Y Identifies the VTE prophylaxis selected.
VTE_PROPH_IND DOUBLE Y Identifies patients that had VTE prophylaxis ordered and documented.
VTE_PROPH_RECD_IND DOUBLE Y Identifies patients that received VTE prophylaxis.
VTE_TIMELY_MASK DOUBLE Y Identifies VTE prophylaxis selected with timely document
WARFARIN_PRIOR_ADMIT_FLAG DOUBLE Y Identifies patients that were on warfarin prior to admission.



Relationship Detail - LH_F_SCIP_METRICS


Child Column in LH_F_SCIP_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_PROC_GROUP_ID LH_D_GROUP D_GROUP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_GROUP 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_CARD_2_METRIC_ID LH_D_METRIC D_METRIC_ID
D_INF_10_METRIC_ID LH_D_METRIC D_METRIC_ID
D_INF_1_METRIC_ID LH_D_METRIC D_METRIC_ID
D_INF_2_METRIC_ID LH_D_METRIC D_METRIC_ID
D_INF_3_METRIC_ID LH_D_METRIC D_METRIC_ID
D_INF_4_METRIC_ID LH_D_METRIC D_METRIC_ID
D_INF_6_METRIC_ID LH_D_METRIC D_METRIC_ID
D_INF_9_METRIC_ID LH_D_METRIC D_METRIC_ID
D_VTE_1_METRIC_ID LH_D_METRIC D_METRIC_ID
D_VTE_2_METRIC_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
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_CCPS_METRICS



Column Section Top of Page


Table-level Detail

Description: LH_F_SEPSIS_CCPS_METRICS
Definition: This table is used to store Sepsis_CCPS . This table is at the Alert Grain.
Table Type: ACTIVITY





Column Detail - LH_F_SEPSIS_CCPS_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.
CE_RESULT_COMMENT VARCHAR(4000) Y The Resulu_Comment of the Alert Containing the Vital Signs that contribute to the Alert.
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_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_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
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.
LH_F_SEPSIS_CCPS_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_SEPSIS_CCPS_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_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.
POPULATION_IND DOUBLE Y Identifies if the encounter is qualified initial population for Sepsis CCPS Audit Report
SEPSIS_BAND_MANUAL DOUBLE N Value of the Band Manual Vital Sign
SEPSIS_BAND_MANUAL_UNIT VARCHAR(20) Y The Unit of the Band Manual Vital Sign
SEPSIS_BILI DOUBLE N Value of the Bilirubin Vital Sign
SEPSIS_BILI_UNIT VARCHAR(20) Y The Unit of the Bilirubin Vital Sign
SEPSIS_BODY_TEMP DOUBLE N Value of the Body Temperature Vital Sign
SEPSIS_BODY_TEMP_UNIT VARCHAR(20) Y The Unit of the Body Temperature Vital Sign
SEPSIS_CORE_TEMP DOUBLE N Value of the Core Temperature Vital Sign
SEPSIS_CORE_TEMP_UNIT VARCHAR(20) Y The Unit of the Core Temperature Vital Sign
SEPSIS_CREATININE DOUBLE N Value of the Creatinine Vital Sign
SEPSIS_CREATININE_UNIT VARCHAR(20) Y The Unit of the Creatinine Vital Sign
SEPSIS_GLUCOSE DOUBLE N Value of the Gulcose Vital Sign
SEPSIS_GLUCOSE_UNIT VARCHAR(20) Y The Unit of the Gulcose Vital Sign
SEPSIS_HR DOUBLE N Value of the Heart Rate Vital Sign
SEPSIS_HR_UNIT VARCHAR(20) Y The Unit of the Heart Rate Vital Sign
SEPSIS_LACTIC_ACID DOUBLE N Value of the Lactic Acid Vital Sign
SEPSIS_LACTIC_ACID_UNIT VARCHAR(20) Y The Unit of the Lactic Acid Vital Sign
SEPSIS_MAP DOUBLE N Value of the Mean Aerital Pressure Vital Sign
SEPSIS_MAP_UNIT VARCHAR(20) Y The Unit of the Mean Aerital Pressure Vital Sign
SEPSIS_PERIPH_PR DOUBLE N Value of the Peripheral Pulse Rate Vital Sign
SEPSIS_PERIPH_PR_UNIT VARCHAR(20) Y The Unit of the Peripheral Pulse Rate Vital Sign
SEPSIS_PERIPH_TEMP DOUBLE N Value of the Peripheral Temperature Vital Sign
SEPSIS_PERIPH_TEMP_UNIT VARCHAR(20) Y The Unit of the Peripheral Temperature Vital Sign
SEPSIS_RR DOUBLE N Value of the Respiratory Rate Vital Sign
SEPSIS_RR_UNIT VARCHAR(20) Y The Unit of the Respiratory Rate Vital Sign
SEPSIS_SBP DOUBLE N Value of the Systolic Blood Pressure Vital Sign
SEPSIS_SBP_UNIT VARCHAR(20) Y The Unit of the Systolic Blood Pressure Vital Sign
SEPSIS_TEMP DOUBLE N Value of the Temperature Vital Sign
SEPSIS_TEMP_UNIT VARCHAR(20) Y The Unit of the Temperature Vital Sign
SEPSIS_WBC DOUBLE N Value of the WBC Vital Sign
SEPSIS_WBC_UNIT VARCHAR(20) Y The Unit of the WBC Vital Sign
SEVERE_DX VARCHAR(255) Y The Name of the Most Severe Diagnosis.
SEVERE_DX_CODE VARCHAR(50) Y The Code of the Most Severe Diagnosis.
SEVERE_DX_TYPE VARCHAR(40) Y The Type of the Most Severe 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. 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.