Table Detail Report

LH_F_PEDS_SKIN_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_PEDS_SKIN_METRICS
Definition: Fact table for Pediatric Skin Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_PEDS_SKIN_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.
AT_RISK_IND DOUBLE Y Identifies patients who are 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.
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_PEDS_SKIN_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_PEDS_SKIN_METRICS table.
HAPU_IND DOUBLE Y Identifies patients that have one or more pressure ulcers that were NOT present on admission
HASKI_IND DOUBLE Y Identifies patients with skin integrity impairment that was not present on Admit
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.
HIGH_HAPU_STAGE_FLAG DOUBLE Y Identifies the highest stage for a hospital acquired pressure ulcer
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.
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 at risk with a plan initiated
POPULATION_IND DOUBLE Y Identifies patients that qualify for the base population for the Lighthouse metric.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT
PU_POA_FLAG DOUBLE Y Identifies patients with a pressure ulcer present on admit
RISK_ASSESS_24H_IND DOUBLE Y Identifies patients assessed for risk within 24 hours of admission
RISK_ASSESS_SHIFT_IND DOUBLE Y Identifies patients assessed for risk with ongoing assessment at least once per shift
RISK_ASSESS_TX_IND DOUBLE Y Identifies patients assessed for risk in receiving unit upon transfer
RISK_EDUCATION_IND DOUBLE Y Identifies patients at risk with skin care education documented
SKIN_ASSESS_24H_IND DOUBLE Y Identifies patients with skin assessment within 24 hours of admission
SKIN_ASSESS_SHIFT_IND DOUBLE Y Identifies patients with a skin assessment at least once per shift
SKIN_ASSESS_TX_IND DOUBLE Y Identifies patients with a skin assessment in receiving unit upon transfer
SKIN_EDUCATION_IND DOUBLE Y Identifies patients with skin integrity impairment with skin care and skin integrity education documented
SKIN_IMPAIR_FLAG DOUBLE Y Identifies patients with skin integrity impairment
SKIN_PU_FLAG DOUBLE Y Identifies patients with a skin abnormality pressure ulcer documented
SKN_ABN_PU_FLAG DOUBLE Y Identifies patients that have a skin abnormality pressure ulcer documented
TRANSFER_IND DOUBLE Y Identifies patients that have 1 or more transfers
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_PEDS_SKIN_METRICS


Child Column in LH_F_PEDS_SKIN_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_PN_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_PN_METRICS
Definition: This table is used to store metrics for the Lighthouse Pneumonia quality measure.
Table Type: ACTIVITY





Column Detail - LH_F_PN_METRICS


Column Name Type Null? Definition
ABX_RECD_MASK DOUBLE Y Identifies when antibiotics were received.
AB_ADMIN_IND DOUBLE Y Identifies patients that received the appropriate antibiotic via the appropriate route.
AB_ADMIN_PRIOR_ARR_IND DOUBLE Y Identifies patient has any antibiotic dose(s) administered prior arrival date/time
AB_ALLERGY_FLAG DOUBLE Y Identifies patients that have allergies, sensitivities or intolerance to beta-lactam/penicillin antibiotic or cephalosporin medications
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.
ADM_SRC_FLAG DOUBLE Y Identifies the admission source for the patient.
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.
BLD_CULT_COLLECT_FLAG DOUBLE Y Identifies if the blood culture was collected.
CLIN_TRIAL_EXCL_FLAG DOUBLE Y Identifies if the patient is excluded from the measure due to participation in a clinical trial.
CMO_ORDER_DT_TM DATETIME Y Identifies the date/time on which comfort measures were ordered.
CMO_ORDER_UTC_DT_TM DATETIME Y Identifies the date/time on which comfort measures were ordered.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COMPROMISED_CONDITION_FLAG DOUBLE Y Identifies patients with a compromising condition.
COMP_COND_MASK DOUBLE Y Identifies patients with a compromising condition.
CXR_CTSCAN_FLAG DOUBLE Y Identifies the result of the chest x-ray / ct scan
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISC_DISP_FLAG DOUBLE Y Identifies the discharge disposition of the patient.
DX_UNCERTAIN_EXCL_FLAG DOUBLE Y Identifies if the diagnosis is uncertain.
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_PERSON_ID DOUBLE N The person that qualified for the quality metric.
D_PN2_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN3A_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN3B_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN4_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN5C_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN5_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN6A_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN6B_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN6_METRIC_ID DOUBLE N Identifies the patient population associated with the PN metric.
D_PN7_METRIC_ID DOUBLE N Identifies the patient population associated with the PN 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.
ED_TRANS_EXCL_FLAG DOUBLE Y Identifies if the patient is excluded from the measure due to a transfer from an ED.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from the measure.
EXCLUDE_3A_IND DOUBLE Y Identifies patients excluded from the measure.
EXCLUDE_3B_IND DOUBLE Y Identifies patients excluded from the measure.
EXCLUDE_4_IND DOUBLE Y Identifies patients excluded from the measure.
EXCLUDE_5_IND DOUBLE Y Identifies patients excluded from the measure.
EXCLUDE_6A_IND DOUBLE Y Identifies patients excluded from the measure.
EXCLUDE_6B_IND DOUBLE Y Identifies patients excluded from the measure.
EXCLUDE_6_IND DOUBLE Y Identifies patients excluded from the measure.
EXCLUDE_7_IND DOUBLE Y Identifies patients 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.
FLU_VACCINE_FLAG DOUBLE Y Identifies if the patient was screened for the flu vaccine.
F_PN_METRICS_ID DOUBLE N Unique identifier for the lighthouse PN Metrics
HC_ASSOC_PN_FLAG DOUBLE Y Identifies if the patient has healthcare associated pneumonia
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.
HOSP_TRANSFER_FLAG DOUBLE Y Identifies if the patient transferred from another acute care facility.
ICU_ADMIT_TRANSFER_FLAG DOUBLE Y Identifies if the patient was admitted or transferred to the ICU within 24 hours of arrival.
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.
NHIQM_VERSION DOUBLE Y Identifies the version of NHIQM for which the patient qualified.
NUMERATOR_2_IND DOUBLE Y Identifies patients that qualify for the measure.
NUMERATOR_3A_IND DOUBLE Y Identifies patients that qualify for the measure.
NUMERATOR_3B_IND DOUBLE Y Identifies patients that qualify for the measure.
NUMERATOR_4_IND DOUBLE Y Identifies patients that qualify for the measure.
NUMERATOR_5C_IND DOUBLE Y Identifies patients that qualify for the measure.
NUMERATOR_6A_IND DOUBLE Y Identifies patients that qualify for the measure.
NUMERATOR_6B_IND DOUBLE Y Identifies patients that qualify for the measure.
NUMERATOR_6_IND DOUBLE Y Identifies patients that qualify for the measure.
NUMERATOR_7_IND DOUBLE Y Identifies patients that qualify for the measure.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTHER_INFECT_SOURCE_FLAG DOUBLE Y Identifies if there was another source of infection.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PN2_AGE_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN2_DISC_DISP_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN2_PNEUMO_VACC_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN2_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PN3A_ADM_SRC_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN3A_BLD_CULT_24H_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN3A_DISC_DISP_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN3A_ICU_ADM_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN3A_NO_BLD_CULT_IND DOUBLE Y PN3A_NO_BLD_CULT_IND column
PN3A_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PN3B_BLD_CULT_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN3B_DISC_DISP_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN3B_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PN3_BLD_CULT_DT_TM DATETIME Y Identifies the date/time of the initial blood culture.
PN3_BLD_CULT_UTC_DT_TM DATETIME Y Identifies the date/time of the initial blood culture.
PN4_DISC_DISP_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN4_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PN4_SMOKE_COUNS_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN4_SMOKE_HX_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN5_AB_RECD_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN5_ADM_DX_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN5_ADM_SRC_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN5_DISC_DISP_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN5_DX_UNCERTAIN_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN5_ED_DX_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN5_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PN6A_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PN6B_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PN6_ADM_SRC_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_COMP_COND_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_DISC_DISP_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_HC_ASSOC_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_ICU_AB_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_ICU_ADM_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_NON_ICU_AB_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_NON_ICU_ADM_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_OTH_INF_SRC_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_PATHOGEN_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_PSEUDO_RISK_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN6_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PN6_RISK_FACT_PSEUDO_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN7_AGE_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN7_DISC_DISP_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN7_FLU_VACC_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN7_INF_W_PN_DX_CODE_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN7_REJECT_IND DOUBLE Y Identifies patients that were rejected for the AMI metric.
PNEUMO_VACCINE_FLAG DOUBLE Y Identifies if the patient has been screened for pneumococcal vaccination
PN_AB_ADMIN_DT_TM DATETIME Y Identifies the initial antibiotic administration date/time.
PN_AB_ADMIN_UTC_DT_TM DATETIME Y Identifies the initial antibiotic administration date/time.
PN_AB_RECD_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_AGE_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_BASE_POPULATION_IND DOUBLE Y Identifies patients that qualify for the base AMI population.
PN_CLIN_TRIAL_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_CMO_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_CXR_CTSCAN_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_CYST_FIB_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_DX_ED_ADMIT_FLAG DOUBLE Y Identifies if the pneumonia diagnosis was in the ED or upon direct admission
PN_ED_ADM_DX_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_ED_ADM_DX_INCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_LOS_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN metric.
PN_TRANS_ED_EXCL_IND DOUBLE Y Identifies patients that qualify for this PN 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.
PSEUDO_RISK_FLAG DOUBLE Y Identifies patients with pseudomonas risk.
RISK_FACT_DR_PNEUMO_FLAG DOUBLE Y Identifies patients with risk factors for drug-resistant pneumococcus.
SMOKE_COUNS_FLAG DOUBLE Y Identifies if the patient received smoking cessation counseling.
SMOKE_HX_FLAG DOUBLE Y Identifies if the patient has a history of smoking.
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_PN_METRICS


Child Column in LH_F_PN_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_PN2_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN3A_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN3B_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN4_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN5C_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN5_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN6A_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN6B_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN6_METRIC_ID LH_D_METRIC D_METRIC_ID
D_PN7_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_READMISSION_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_READMISSION_METRICS
Definition: This table is used to store Readmission Prevention Report Metrics
Table Type: ACTIVITY





Column Detail - LH_F_READMISSION_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.
AC_RE_ED_30_DAY_NUM DOUBLE Y Indicates if there is an All Cause ED readmission in 30 Days
AC_RE_ED_X_DAY_NUM DOUBLE Y Indicates if there is an All Cause ED readmission in X Days
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_MED_REC_DT_TM DATETIME Y Date/Time of the Admission Medication Reconcilation
ADMIT_MED_REC_IND DOUBLE Y Indicator for Admission Medication Reconcilation
ADMIT_MED_REC_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
ADMIT_MED_REC_UTC_DT_TM DATETIME Y Date/Time of the Admission Medication Reconcilation Normalized to GMT
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
ALL_PROCESS_COMPLETE_IND DOUBLE Y Indicator for All Process Completed
BOOST_NEXT_INPT_DT_TM DATETIME Y Date/Time of the Next Inpatient Encounter in BOOST Population
BOOST_NEXT_INPT_ENCNTR_ID DOUBLE N Next Inpatinet Encounter Id of the Encounter in BOOST Population
BOOST_NEXT_INPT_UTC_DT_TM DATETIME Y Date/Time of the Next Inpatient Encounter in BOOST Population Normalized to GMT
BOOST_P_POP_IND DOUBLE Y Identifies if the encounter is qualified Boost P population for Readmission Prevention Report
CABG_PROC_DT_TM DATETIME Y Date/Time of the CABG Procedure
CABG_PROC_IND DOUBLE Y Indicates if there is a CABG Procedure on the Encounter
CABG_PROC_UTC_DT_TM DATETIME Y Date/Time of the CABG Procedure Normalized to GMT
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DEPART_PAT_ED_IND DOUBLE Y Indicator for Depart Patient Education.
DEPART_PAT_ED_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
DEPART_PROCESS_IND DOUBLE Y Indicator for Depart Process
DEPART_PROCESS_PAT_ED_IND DOUBLE Y Indicator for Patient Education Depart Process
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.
DISCH_MED_REC_DT_TM DATETIME Y Date/Time of the Discharge Medication Reconcilation
DISCH_MED_REC_IND DOUBLE Y Indicator for Discharge Medication Reconcilation
DISCH_MED_REC_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
DISCH_MED_REC_UTC_DT_TM DATETIME Y Date/Time of the Discharge Medication Reconcilation Normalized to GMT
DISCH_SAME_CAL_DAY_IND DOUBLE Y Indicates if the Encounter is Discharged on the Same Calendar Day.
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_CM_PRSNL_ID DOUBLE N Identifies the Care Manager 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_FOLLOWUP_APPT_SCH_IND DOUBLE Y Date/Time of the Follow Up Appointment Information Provided Normalized to GMT
D_FOLLOWUP_APPT_SCH_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
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_PCP_ID DOUBLE N Identifies the Primary Care physician associated to the encounter.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
D_SURGERY_PRSNL_ID DOUBLE N Identifies the Surgery physician associated to 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.
FINAL_PRIMARY_DX VARCHAR(50) Y Final Primary Diagnosis on the Encounter
FINAL_PRIMARY_DX_TXT VARCHAR(255) Y The Diagnosis Name.
FINAL_PRIORITY DOUBLE Y Final Priority Value
FINAL_PRIORITY_TXT VARCHAR(20) Y Final Priority Text
FINAL_RISK_FACTOR_VALUE DOUBLE N Final Risk Factor Value
FINAL_SEVERITY VARCHAR(20) Y Final Severity Text
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.
FOLLOWUP_APPT_INFO_PROV_IND DOUBLE Y Indicator for Follow Up Appointment Information Provided
FOLLOWUP_APPT_MISS_IND DOUBLE Y Indicator for Followup Appt Missd
FOLLOWUP_APPT_MISS_PREV_IND DOUBLE Y Indicator for Followup Appt_Miss Prevd
FOLLOWUP_APPT_NOT_ATTEND_IND DOUBLE Y Indicator for Followup Appt_Not Attendd
FOLLOWUP_APPT_PROV_PRSNL_ID DOUBLE N Date/Time of the Follow Up Appointment Information Provided
FOLLOWUP_APPT_SCH_DT_TM DATETIME Y Date/Time of the Follow Up Appointment Scheduled
FOLLOWUP_APPT_SCH_IND DOUBLE Y Indicator for Follow Up Appointment Scheduled
FOLLOWUP_APPT_SCH_NOT_ATT_IND DOUBLE Y Indicator for Followup Appt_Sch_Not Attd
FOLLOWUP_APPT_SCH_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
FOLLOWUP_APPT_SCH_UTC_DT_TM DATETIME Y Date/Time of the Follow Up Appointment Scheduled Normalized to GMT
FOLLOWUP_PHONE_DT_TM DATETIME Y Date/Time of the Follow Up Phone
FOLLOWUP_PHONE_IND DOUBLE Y Indicator for Follow Up Phone
FOLLOWUP_PHONE_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
FOLLOWUP_PHONE_UTC_DT_TM DATETIME Y Date/Time of the Follow Up Phone to GMT
GAP_CHECKLIST_DT_TM DATETIME Y Date/Time for GAP Checklist
GAP_CHECKLIST_IND DOUBLE Y Indicator for Gap Checklist
GAP_CHECKLIST_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
GAP_CHECKLIST_UTC_DT_TM DATETIME Y Date/Time for GAP Checklist Normalized to GMT
GAP_CHKLST_READMIT_IND DOUBLE Y Indicator for Gap Checklist and Readmission
GAP_UNIV_CHKLST_IND DOUBLE Y Indicator for Gap and Universal Discharge Checklist
GAP_UNIV_CHKLST_READMIT_IND DOUBLE Y Indicator for Gap and Universal Discharge Checklist with Readmission
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.
IA_RE_ED_30_DAY_NUM DOUBLE Y Indicates if there is an ED readmission in 30 Days(Index Population)
IA_RE_ED_X_DAY_NUM DOUBLE Y Indicates if there is an ED readmission in X Days(Index Population)
IDX_NEXT_INPT_DT_TM DATETIME Y Date/Time of the Next Inpatient Encounter in Index Population
IDX_NEXT_INPT_ENCNTR_ID DOUBLE N Next Inpatinet Encounter Id of the Encounter in Index Population
IDX_NEXT_INPT_UTC_DT_TM DATETIME Y Date/Time of the Next Inpatient Encounter in Index Population Normalized to GMT
INDEX_ADMIT_IND DOUBLE Y Identifies if the Encounter is an Index Admission.
INDEX_POP_IND DOUBLE Y Identifies if the encounter is qualified index population for Readmission Prevention Report
INITIAL_PRIORITY DOUBLE Y Initial Priority Value
INITIAL_PRIORITY_TXT VARCHAR(20) Y Initial Priority Text
INITIAL_RISK_FACTOR_VALUE DOUBLE N Initial Risk Factor Value
INITIAL_SEVERITY VARCHAR(20) Y Initial Severity Text
IPOC_INIT_DT_TM DATETIME Y Date/Time of the IPOC Initiated
IPOC_INIT_IND DOUBLE Y Indicator for IPOC Initiated
IPOC_INIT_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
IPOC_INIT_UTC_DT_TM DATETIME Y Date/Time of the IPOC Initiated Normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LENGTH_OF_STAY DOUBLE Y The Length of Stay of the Encounter
LH_F_READMISSION_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_READMISSION_METRICS table.
LIVING_SITUATION_TXT VARCHAR(255) Y The Living Situation Text of the Encounter
LOC_FACILITY_CD DOUBLE N Facilty Code of the Encounter
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_TG_READMIT DOUBLE Y Length of Stay of the Target Readmitted Encounter.
LVAD_PROC_12M_DT_TM DATETIME Y Date/Time of the LAVD Procedure
LVAD_PROC_12M_IND DOUBLE Y Indicates if there is a LAVD Procedure in the last 12 months on the Encounter
LVAD_PROC_12M_UTC_DT_TM DATETIME Y Date/Time of the LAVD Procedure Normalized to GMT
MANUALLY_REMOVED_IND DOUBLE Y Indicator for Manually Removed Patients
MANUALLY_REMOVED_REASON_TXT VARCHAR(255) Y The Reason for Manual Removal
MED_ADHERE_ADDR_DT_TM DATETIME Y Date/Time of the Medication Adherence Addressed
MED_ADHERE_ADDR_IND DOUBLE Y Indicator for Medication Adherence Addressed
MED_ADHERE_ADDR_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
MED_ADHERE_ADDR_UTC_DT_TM DATETIME Y Date/Time of the Medication Adherence Addressed Normalized to GMT
NEXT_ED_DT_TM DATETIME Y Date/Time of the Next ED Encounter.
NEXT_ED_ENCNTR_ID DOUBLE N Next ED Encounter Id of the Encounter
NEXT_ED_UTC_DT_TM DATETIME Y Date/Time of the Next ED Encounter Normalized to GMT
NEXT_INPT_DT_TM DATETIME Y Date/Time of the Next Inpatient Encounter.
NEXT_INPT_ENCNTR_ID DOUBLE N Next Inpatinet Encounter Id of the Encounter
NEXT_INPT_FACILITY_CD DOUBLE N Facility Code of the Next Inpatinet Encounter
NEXT_INPT_FINAL_PRIM_DX VARCHAR(50) Y Final Primary Diagnosis of the Next Inpatient Encounter
NEXT_INPT_UTC_DT_TM DATETIME Y Date/Time of the Next Inpatient Encounter Normalized to GMT
NO_OF_DAYS_BTWN_READMIT DOUBLE Y No of Days between discharge and readmission.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PAT_COND_DISCH_ED_PROV_IND DOUBLE Y Indicator for Condition Specific Patient Education
PAT_COND_ED_PROV_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
PAT_ED_PROV_IND DOUBLE Y Indicator for Patient Education Provided
PAT_ED_PROV_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
PLANNED_ADMIT_IND DOUBLE Y Indicates of the Encounter is a Planned Admit.
PLAN_PROC_DT_TM DATETIME Y Date/Time of the Planned Procedure
PLAN_PROC_IND DOUBLE Y Indicates if there is a Planned Procedure on the Encounter
PLAN_PROC_UTC_DT_TM DATETIME Y Date/Time of the Planned Procedure Normalized to GMT
POPULATION_IND DOUBLE Y Identifies if the encounter is qualified initial population for Readmission Prevention Report
POT_PLAN_PROC_DT_TM DATETIME Y Date/Time of the Potentially Planned Procedure
POT_PLAN_PROC_IND DOUBLE Y Indicates if there is a Potentially Planned Procedure on the Encounter
POT_PLAN_PROC_UTC_DT_TM DATETIME Y Date/Time of the Potentially Planned Procedure Normalized to GMT
PREV_INPT_IND DOUBLE Y Date/Time of the Previous Inpatient Encounter
PRIMARY_ACUTE_DX_DT_TM DATETIME Y Date/Time of the Primary Acute Diagnosis
PRIMARY_ACUTE_DX_IND DOUBLE Y Indicator for Primary Acute Diagnosis on the Encounter
PRIMARY_ACUTE_DX_UTC_DT_TM DATETIME Y Date/Time of the Primary Acute Diagnosis Normalized to GMT
PRIMARY_AMI_DX_DT_TM DATETIME Y Date/Time of the Final Primary AMI Diagnosis
PRIMARY_AMI_DX_IND DOUBLE Y Final Primary AMI Diagnosis on the Encounter
PRIMARY_AMI_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary AMI Diagnosis Normalized to GMT
PRIMARY_ASTHMA_DX_DT_TM DATETIME Y Date/Time of the Final Primary Asthma Diagnosis
PRIMARY_ASTHMA_DX_IND DOUBLE Y Final Primary Asthma Diagnosis on the Encounter
PRIMARY_ASTHMA_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary Asthma Diagnosis Normalized to GMT
PRIMARY_CF_DX_DT_TM DATETIME Y Date/Time of the Final Primary Cyctic Fibrosis Diagnosis
PRIMARY_CF_DX_IND DOUBLE Y Final Primary Cyctic Fibrosis Diagnosis on the Encounter
PRIMARY_CF_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary Cyctic Fibrosis Diagnosis Normalized to GMT
PRIMARY_COPD_DX_DT_TM DATETIME Y Date/Time of the Final Primary COPD Diagnosis
PRIMARY_COPD_DX_IND DOUBLE Y Final Primary COPD Diagnosis on the Encounter
PRIMARY_COPD_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary COPD Diagnosis Normalized to GMT
PRIMARY_HF_DX_DT_TM DATETIME Y Date/Time of the Final Primary Heart Failure Diagnosis
PRIMARY_HF_DX_IND DOUBLE Y Final Primary Heart Failure Diagnosis on the Encounter
PRIMARY_HF_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary Heart Failure Diagnosis Normalized to GMT
PRIMARY_PLAN_DX_DT_TM DATETIME Y Date/Time of the Primary Plan Diagnosis
PRIMARY_PLAN_DX_IND DOUBLE Y Indicator for Primary Plan Diagnosis on the Encounter
PRIMARY_PLAN_DX_UTC_DT_TM DATETIME Y Date/Time of the Primary Plan Diagnosis Normalized to GMT
PRIMARY_PNEU_DX_DT_TM DATETIME Y Date/Time of the Final Primary Pneumonia Diagnosis
PRIMARY_PNEU_DX_IND DOUBLE Y Final Primary Pneumonia Diagnosis on the Encounter
PRIMARY_PNEU_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary Pneumonia Diagnosis Normalized to GMT
PRIMARY_PROC_CODE VARCHAR(50) Y Primary Procedure Code of the Encounter.
PRIMARY_PROC_TXT VARCHAR(255) Y Primary Procedure Name.
PRIMARY_RESP_FAIL_DX_DT_TM DATETIME Y Date/Time of the Final Primary Respiratory Failure Diagnosis
PRIMARY_RESP_FAIL_DX_IND DOUBLE Y Final Primary Respiratory Failure Diagnosis on the Encounter
PRIMARY_RESP_FAIL_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary Respiratory Failure Diagnosis Normalized to GMT
PRIMARY_SC_DX_DT_TM DATETIME Y Date/Time of the Final Primary Sickel Cell Diagnosis
PRIMARY_SC_DX_IND DOUBLE Y Final Primary Sickel Cell Diagnosis on the Encounter
PRIMARY_SC_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary Sickel Cell Diagnosis Normalized to GMT
PRIMARY_SEPSIS_DX_DT_TM DATETIME Y Date/Time of the Final Primary Sepsis Diagnosis
PRIMARY_SEPSIS_DX_IND DOUBLE Y Final Primary Sepsis Diagnosis on the Encounter
PRIMARY_SEPSIS_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary Sepsis Diagnosis Normalized to GMT
PRIMARY_STROKE_DX_DT_TM DATETIME Y Date/Time of the Final Primary Stroke Diagnosis
PRIMARY_STROKE_DX_IND DOUBLE Y Final Primary Stroke Diagnosis on the Encounter
PRIMARY_STROKE_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Primary Stroke Diagnosis Normalized to GMT
PRIORITY_CHANGE_FLAG DOUBLE Y Flag for Priority Change : 0 - No Change, 1 - Increase, 2- Decrease
PRIORITY_CHANGE_REASON VARCHAR(50) Y Priority Change Reason
READMISSION_IND DOUBLE Y Indicates if the Encounter is Readmitted Encounter
READMIT_DOC_COMPLETED_IND DOUBLE Y Indicates if Readmission Documentation Completed
READMIT_DOC_COMPLETE_IND DOUBLE Y Indicates if Readmission Documentation Complete
READMIT_DOC_COMPLTD_DT_TM DATETIME Y Date/Time of the Readmission Documentation Completed
READMIT_DOC_COMPLTD_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
READMIT_DOC_COMPLTD_UTC_DT_TM DATETIME Y Date/Time of the Readmission Documentation Completed Normalized to GMT
READMIT_DOC_COMP_DT_TM DATETIME Y Date/Time of the Readmission Documentation Complete
READMIT_DOC_COMP_PRSNL_ID DOUBLE N Personnel Id of the person who Complete the Documentation
READMIT_DOC_COMP_UTC_DT_TM DATETIME Y Date/Time of the Readmission Documentation Complete Normalized to GMT
READMIT_ED_STATUS_DT_TM DATETIME Y Date/Time of the Education Status Documentation
READMIT_ED_STATUS_IND DOUBLE Y Indicates if Education Status is Completed
READMIT_ED_STATUS_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
READMIT_ED_STATUS_UTC_DT_TM DATETIME Y Date/Time of the Readmission Documentation Normalized to GMT
READMIT_PREV_DOC_IND DOUBLE Y Indicates if Readmission Prevention Documentation is Completed
READMIT_PREV_DOC_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
READMIT_RISK_ADDR_DT_TM DATETIME Y Date/Time of the Readmission Risk Addressed
READMIT_RISK_ADDR_IND DOUBLE Y Indicator for Readmission Risk Addressed
READMIT_RISK_ADDR_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
READMIT_RISK_ADDR_UTC_DT_TM DATETIME Y Date/Time of the Readmission Risk Addressed to GMT
READMIT_SAME_COND_IND DOUBLE Y Indicates if the Encounter is Readmitted for the Same Condition
RE_VERB_UNDERSTAND_DT_TM DATETIME Y Date/Time of the Verbalizes Understanding
RE_VERB_UNDERSTAND_IND DOUBLE Y Indicator for Verbalizes Understanding
RE_VERB_UNDERSTAND_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
RE_VERB_UNDERSTAND_UTC_DT_TM DATETIME Y Date/Time of the Verbalizes Understanding to GMT
SEC_COPD_DX_DT_TM DATETIME Y Date/Time of the Final Secondary COPD Diagnosis
SEC_COPD_DX_IND DOUBLE Y Final Secondary COPD Diagnosis on the Encounter
SEC_COPD_DX_UTC_DT_TM DATETIME Y Date/Time of the Final Secondary COPD Diagnosis Normalized to GMT
SEC_PNEU_DX_POA_DT_TM DATETIME Y Date/Time of the Final Secondary Pneumonia Diagnosis(Present on Admission)
SEC_PNEU_DX_POA_IND DOUBLE Y Final Secondary Pneumonia Diagnosis(Present on Admission) on the Encounter
SEC_PNEU_DX_POA_UTC_DT_TM DATETIME Y Date/Time of the Final Secondary Pneumonia Diagnosis(Present on Admission) Normalized to GMT
SEC_SEV_SEP_DX_POA_DT_TM DATETIME Y Date/Time of the Final Secondary Severe Sepsis Diagnosis(Present on Admission)
SEC_SEV_SEP_DX_POA_IND DOUBLE Y Final Secondary Severe Sepsis Diagnosis(Present on Admission) on the Encounter
SEC_SEV_SEP_DX_POA_UTC_DT_TM DATETIME Y Date/Time of the Final Secondary Severe Sepsis Diagnosis(Present on Admission) Normalized to GMT
SEVERITY_CHANGE_FLAG DOUBLE Y Flag for Severity Change : 0 - No Change, 1 - Increase, 2- Decrease
TARGET_POP_IND DOUBLE Y Identifies if the encounter is qualified target population for Readmission Prevention Report
TG_NEXT_INPT_DT_TM DATETIME Y Date/Time of the Next Inpatient Encounter in Target Population
TG_NEXT_INPT_ENCNTR_ID DOUBLE N Next Inpatinet Encounter Id of the Encounter in Target Population
TG_NEXT_INPT_UTC_DT_TM DATETIME Y Date/Time of the Next Inpatient Encounter in Target Population Normalized to GMT
TG_READMIT_ENCNTR_IND DOUBLE Y Indicates if the Encounter is an Target Readmit Encounter
TG_RE_30_DAY_NUM DOUBLE Y Indicates if there is an Target readmission in 30 Days
TG_RE_ED_30_DAY_NUM DOUBLE Y Indicates if there is an Target ED readmission in 30 Days
TG_RE_ED_X_DAY_NUM DOUBLE Y Indicates if there is an Target ED readmission in X Days
TG_RE_X_DAY_NUM DOUBLE Y Indicates if there is an Target readmission in X Days
THA_TKA_PROC_DT_TM DATETIME Y Date/Time of the THA,TKA Procedure
THA_TKA_PROC_IND DOUBLE Y Indicates if there is a THA,TKA Procedure on the Encounter
THA_TKA_PROC_UTC_DT_TM DATETIME Y Date/Time of the THA,TKA Procedure Normalized to GMT
TRANS_CARE_ASSESSMENT_IND DOUBLE Y Indicator for Transition Care Assessment Dcoumentation
TRANS_CARE_ASSESS_DT_TM DATETIME Y Date/Time of the Transition Care Assessment Dcoumentation
TRANS_CARE_ASSESS_PRSNL_ID DOUBLE N Personnel ID of the Person who performed the Documentation
TRANS_CARE_ASSESS_UTC_DT_TM DATETIME Y Date/Time of the Transition Care Assessment Dcoumentation Normalized to GMT
UNIVERSAL_DISCH_CHKLST_IND DOUBLE Y Indicator for Universal Discharge Checklist
UNIV_DISCH_CHKLST_DT_TM DATETIME Y Date/Time for Universal Discharge Checklist
UNIV_DISCH_CHKLST_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
UNIV_DISCH_CHKLST_UTC_DT_TM DATETIME Y Date/Time for Universal Discharge Checklist Normalized to GMT
UNPLANNED_ADMIT_IND DOUBLE Y Indicates of the Encounter is a UnPlanned Admit.
UNV_DISCH_CHKLST_READMIT_IND DOUBLE Y Indicator for Universal Discharge Checklist and Readmission
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.
UP_AC_RE_30_DAY_NUM DOUBLE Y Indicates if there is an Unplanned All Cause readmission in 30 Days
UP_AC_RE_X_DAY_NUM DOUBLE Y Indicates if there is an Unplanned All Cause readmission in X Days
UP_IA_RE_30_DAY_NUM DOUBLE Y Indicates if there is an Unplanned Index readmission in 30 Days
UP_IA_RE_X_DAY_NUM DOUBLE Y Indicates if there is an Unplanned Index readmission in X Days
VERB_AMI_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of AMI
VERB_AMI_IND DOUBLE Y Indicator for Verbalizes Understanding of AMI
VERB_AMI_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
VERB_AMI_UTC_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of AMI
VERB_ASTHMA_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Asthma
VERB_ASTHMA_IND DOUBLE Y Indicator for Verbalizes Understanding of Asthma
VERB_ASTHMA_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
VERB_ASTHMA_UTC_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Asthma
VERB_COPD_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of COPD
VERB_COPD_IND DOUBLE Y Indicator for Verbalizes Understanding of COPD
VERB_COPD_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
VERB_COPD_UTC_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of COPD
VERB_CYC_FIB_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Cystic Fibrosis
VERB_CYC_FIB_IND DOUBLE Y Indicator for Verbalizes Understanding of Cystic Fibrosis
VERB_CYC_FIB_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
VERB_CYC_FIB_UTC_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Cystic Fibrosis
VERB_HEARTFAIL_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Heart Failure
VERB_HEARTFAIL_IND DOUBLE Y Indicator for Verbalizes Understanding of Heart Failure
VERB_HEARTFAIL_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
VERB_HEARTFAIL_UTC_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Heart Failure
VERB_PNEU_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Pneumonia
VERB_PNEU_IND DOUBLE Y Indicator for Verbalizes Understanding of Pneumonia
VERB_PNEU_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
VERB_PNEU_UTC_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Pneumonia
VERB_SICKLE_CELL_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Sickel Cell
VERB_SICKLE_CELL_IND DOUBLE Y Indicator for Verbalizes Understanding of Sickel Cell
VERB_SICKLE_CELL_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
VERB_SICKLE_CELL_UTC_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Sickel Cell
VERB_STROKE_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Stroke
VERB_STROKE_IND DOUBLE Y Indicator for Verbalizes Understanding of Stroke
VERB_STROKE_PRSNL_ID DOUBLE N Personnel Id of the person who Completed the Documentation
VERB_STROKE_UTC_DT_TM DATETIME Y Date/Time for Verbalizes Understanding of Stroke



Relationship Detail - LH_F_READMISSION_METRICS


Child Column in LH_F_READMISSION_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_FINANCIAL_CLASS_ID LH_D_FINANCIAL_CLASS D_FINANCIAL_CLASS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FINANCIAL_CLASS HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_F_READMIT_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_READMIT_METRICS
Definition: This is the fact table for Readmission Prevention Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_READMIT_METRICS


Column Name Type Null? Definition
ACO_ORG_TXT VARCHAR(255) Y Identifies the ACO associated with the BOOST encounter
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.
ALL_CAUSE_READMIT_RISK_IND DOUBLE N Identifies if the encounter should be considered for the All Cause Readmissions report
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.
BOOST_ENCNTR_IND DOUBLE Y Identifies if the encounter is in the BOOST population
BOOST_P_MASK DOUBLE Y Identifies the associated P's with the BOOST encounter
BOOST_P_TXT VARCHAR(255) Y Stores the Name of the Boost P's.
CABG_PROC_IND DOUBLE N Identifies patients who had a CABG procedure documented
CMS_QUAL_IND DOUBLE N Identifies if the patient is qualified for CMS
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CURRENT_AMI_DX_IND DOUBLE N Identifies patients who had a final primary discharge diagnosis of AMI
CURRENT_CHF_DX_IND DOUBLE N Identifies patients who had a final primary discharge diagnosis of CHF
CURRENT_COPD_DX_IND DOUBLE Y Identifies patients who had a final primary discharge diagnosis of COPD
CURRENT_PN_DX_IND DOUBLE N Identifies patients who had a final primary discharge diagnosis of PN.
CURRENT_RESP_FAIL_DX_IND DOUBLE Y Identifies patients who had a final primary discharge diagnosis of Respiratory Failure
CURRENT_THA_PROC_IND DOUBLE Y Identifies patients who had a final primary discharge diagnosis of THA
CURRENT_TKA_PROC_IND DOUBLE Y Identifies patients who had a final primary discharge diagnosis of TKA
CURR_SECONDARY_COPD_DX_IND DOUBLE Y Identifies patients who had a final non-primary discharge diagnosis of COPD
DEPART_IND DOUBLE N Identifies if the depart process is used for the patient's encounter.
DEPART_PROCESS_MASK DOUBLE Y Identifies the specific education that was given to patient regarding their depart process prior to discharge.
DIAGNOSIS_TXT VARCHAR(10) N Stores the primary diagnosis code for the encounter.
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.
DISCH_DOC_IND DOUBLE N Identifies patients who had discharge documentation completed prior to discharge
DISCH_MED_REC_IND DOUBLE N Identifies patients who had discharged medication reconciliation completed prior to discharge
DX_EDUCATION_MASK DOUBLE N Identifies the specific education that was given to patient regarding their diagnoses prior to discharge
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_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_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_21_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_22_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_23_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_24_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_25_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_26_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_27_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_28_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_29_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_30_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_31_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_32_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_33_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_34_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_35_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_36_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_PCP_ID DOUBLE N Identifies the primary care provider for the patient
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
D_PRIN_DX_ID DOUBLE N Identifies the principal diagnosis for the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Identifies the principle procedure associated with the encounter.
D_SURGERY_PRSNL_ID DOUBLE N Identifies the surgeon for patients who had a procedure
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_PRIORITY VARCHAR(255) Y Identifies the final priority of the encounter
FINAL_SEVERITY VARCHAR(255) N Identifies the final severity of the encounter
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.
FOLLOWUP_APPT_MISS_IND DOUBLE N Identifies patients who missed their follow up appointment
FOLLOWUP_APPT_SCH_IND DOUBLE N Identifies patients who had a follow up appointment scheduled prior to discharge
FOLLOWUP_IND DOUBLE N Identifies patients who had follow up appointment information provided to them prior to discharge
FOLLOWUP_PHONE_IND DOUBLE N Identifies patients who had a follow up phone call
GAP_CHECKLIST_IND DOUBLE Y Identifies if the BOOST encounter had their GAP checklist completed
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.
HEART_COND_DX_IND DOUBLE N Identifies patients who had a Final Primary Discharge diagnosis of Unstable Angina, Arrhythmia or Cardiac Arrest
IA_ED_30_DAY_DENOMINATOR DOUBLE Y Stores the Denominator Indicator for the IA_ED_30_DAY Metrics
IA_ED_30_DAY_EXCLUSION DOUBLE Y Stores the Exclusion Indicator for the IA_ED_30_DAY Metrics
IA_ED_30_DAY_NUMERATOR DOUBLE Y Stores the Numerator Indicator for the IA_ED_30_DAY Metrics
INDEX_ADMIT_IND DOUBLE N Identifies if an encounter is an index admission
INITIAL_PRIORITY VARCHAR(255) Y Identifies the initial priority of the encounter
INITIAL_SEVERITY VARCHAR(255) N Identifies the initial severity of the encounter
INPT_ENCNTR_IND DOUBLE N Identifies if the encounter is an inpatient encounter.
IPOC_INIT_IND DOUBLE N Identifies patients who had the readmission management IPOC initiated prior to discharge
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LAST_RISK_FACTOR_VALUE DOUBLE Y Identifies the latest (by date/time) numerical risk factor
LH_F_READMIT_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_READMIT_METRICS table.
LIVING_SITUATION_TXT VARCHAR(255) Y Identifies the patient's living situation
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.
MANUALLY_ADDED_IND DOUBLE N Identifies patients who were manually added to the worklist
MANUALLY_REMOVED_IND DOUBLE N Identifies encounters who were manually removed from the worklist
MANUALLY_REMOVED_REASON_TXT VARCHAR(255) Y Identifies the reason for manually removing the patient from the worklist
MAX_FOLLOWUP_PHONE_DAYS DOUBLE Y Max Number of days to look back for follow-up phone calls to the patient.
MED_ADHERENCE_IND DOUBLE N Identifies patients who had medication adherence issues addressed prior to discharge
MISSED_APPT_TXT VARCHAR(100) Y Stores the response to why the patient missed the follow-upappointment
NEXT_ED_DT_TM DATETIME Y Identifies the next ED arrival date for the patient
NEXT_ED_ENCNTR_ID DOUBLE N Stores the Encounter Id of the Next Emergency Encounter
NEXT_ED_UTC_DT_TM DATETIME Y Identifies the next ED arrival date for the patient normalized to GMT
NEXT_INPT_ENCNTR_DT_TM DATETIME Y Identifies the next admission date of an inpatient encounter
NEXT_INPT_ENCNTR_ID DOUBLE N Stores the Encounter Id of the Next Inpatient Encounter
NEXT_INPT_ENCNTR_UTC_DT_TM DATETIME Y Identifies the next admission date of an inpatient encounter normalized to GMT
NEXT_RE_30_DAY_RISK_IND DOUBLE Y Stores the Risk Indicator of the Next Inpatient/Emergency Encounter
NEXT_TARGET_POP_IND DOUBLE Y Stores the Target Popolation Indicator of the Next Inpatient/Emergency Encounter
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
PAT_ED_IND DOUBLE N Identifies patients who had patient education documented prior to discharge
PAT_UNDERSTAND_IND DOUBLE N Identifies patients who verbalized understanding of readmission prevention prior to discharge
PHONE_RESPONSE_TXT VARCHAR(100) Y Stores the response to the follow up phone call
POPULATION_IND DOUBLE N Identifies patients who are in the overall population
PREV_AMI_DX_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of AMI prior to the current encounter
PREV_AMI_DX_UTC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of AMI prior to the current encounter, normalized to GMT
PREV_CHF_DX_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of CHF prior to the current encounter
PREV_CHF_DX_UTC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of CHF prior to the current encounter, normalized to GMT
PREV_COPD_DX_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of COPD prior to the current encounter
PREV_COPD_DX_UTC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of COPD prior to the current encounter, normalized to GMT
PREV_INDEX_AMI_DX_IND DOUBLE N Identifies if the previous index admission had an AMI diagnosis
PREV_INDEX_DT_TM DATETIME Y Identifies the previous date of an index admission
PREV_INDEX_UTC_DT_TM DATETIME Y Identifies the previous date of an index admission normalized to GMT
PREV_PN_DX_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of PN prior to the current encounter
PREV_PN_DX_UTC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of PN prior to the current encounter, normalized to GMT
PREV_RESP_FAIL_DX_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of Respiratory Failure prior to the current encounter
PREV_RESP_FAIL_DX_UTC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of Respiratory Failure prior to the current encounter, normalized to GMT
PREV_THA_PROC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of THA prior to the current encounter
PREV_THA_PROC_UTC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of THA prior to the current encounter, normalized to GMT
PREV_TKA_PROC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of TKA prior to the current encounter
PREV_TKA_PROC_UTC_DT_TM DATETIME Y Identifies the date of the last encounter that a patient had a discharge diagnosis of TKA prior to the current encounter, normalized to GMT
PRIORITY_CHANGE_FLAG DOUBLE N Identifies if the priority changed during the encounter
PRIORITY_CHANGE_REASON VARCHAR(255) N Identifies the reason the priority was changed
PROBLEM_MASK DOUBLE N Identifies the specific problem/diagnosis that put a patient at risk of readmission
PROB_DIAG_TXT VARCHAR(255) Y Stores the Problem or Diagnosis Text Value.
PROCEDURE_IND DOUBLE N Identifies if a patient was at risk for readmission because of a procedure
PROCEDURE_TXT VARCHAR(255) Y Stores the Name of the Procedure.
PROC_GROUP_TXT VARCHAR(255) Y Stores the Name of the Procedure Group.
PTCA_PROC_IND DOUBLE N Identifies patients who had a PTCA procedure documented
READMITTED_30_DAY_RISK_IND DOUBLE N Identifies patients who were readmitted within 30 days of a previous index encounter
READMIT_30_DAY_IND DOUBLE N Identifies patients who were at risk for readmission because they were a 30 day readmission.
READMIT_RISK_ADDR_IND DOUBLE N Identifies patients who had readmission risks addressed prior to discharge
READMIT_RISK_IND DOUBLE N Identifies if the encounter had a clinical event for readmission risk documented prior to discharge
READMIT_RULE_30_DAY_IND DOUBLE N Identifies the client is using the 30 Day Readmit Rule
RE_ED_30_DAY_DENOMINATOR DOUBLE Y Stores the Denominator Indicator for the RE_ED_30_DAY Metrics
RE_ED_30_DAY_NUMERATOR DOUBLE Y Stores the Numerator Indicator for the RE_ED_30_DAY Metrics
RE_HOSP_30_DAY_DENOMINATOR DOUBLE Y Stores the Denominator Indicator for the RE_HOSP_30_DAY Metrics
RE_HOSP_30_DAY_NUMERATOR DOUBLE Y Stores the Numerator Indicator for the RE_HOSP_30_DAY Metrics
RISK_FACTOR_VALUE DOUBLE N Identifies the numerical risk factor
SEVERITY_CHANGE_FLAG DOUBLE N Identifies if the severity changed during the encounter
TARGET_POP_IND DOUBLE N Identifies if the encounter qualifies for the target population
TRANS_CARE_ASSESSMENT_IND DOUBLE N Identifies patients who had transition care management assessment completed prior to discharge
UNIVERSAL_DISCH_CHKLST_IND DOUBLE Y Identifies if the BOOST encounter had their universal discharge checklist completed
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_READMIT_METRICS


Child Column in LH_F_READMIT_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_DX_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_FINANCIAL_CLASS_ID LH_D_FINANCIAL_CLASS D_FINANCIAL_CLASS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FINANCIAL_CLASS HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_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_21_ID LH_D_METRIC D_METRIC_ID
D_METRIC_22_ID LH_D_METRIC D_METRIC_ID
D_METRIC_23_ID LH_D_METRIC D_METRIC_ID
D_METRIC_24_ID LH_D_METRIC D_METRIC_ID
D_METRIC_25_ID LH_D_METRIC D_METRIC_ID
D_METRIC_26_ID LH_D_METRIC D_METRIC_ID
D_METRIC_27_ID LH_D_METRIC D_METRIC_ID
D_METRIC_28_ID LH_D_METRIC D_METRIC_ID
D_METRIC_29_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_30_ID LH_D_METRIC D_METRIC_ID
D_METRIC_31_ID LH_D_METRIC D_METRIC_ID
D_METRIC_32_ID LH_D_METRIC D_METRIC_ID
D_METRIC_33_ID LH_D_METRIC D_METRIC_ID
D_METRIC_34_ID LH_D_METRIC D_METRIC_ID
D_METRIC_35_ID LH_D_METRIC D_METRIC_ID
D_METRIC_36_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
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_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
D_PCP_ID LH_D_PERSONNEL D_PRSNL_ID
D_SURGERY_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_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_REST_DTL_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_F_REST_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.
ADVERSE_IND DOUBLE Y Identifies if the an adverse event was document during restraint episode
ADV_AGITATION_IND DOUBLE Y Identifies if the agitation adverse event was document during restraint episode
ADV_ESCALATION_IND DOUBLE Y Identifies if the escalation of injuryois behavior adverse event was document during restraint episode
ADV_FALL_IND DOUBLE Y Identifies if the injury related to fall adverse event was document during restraint episode
ADV_IMP_CIRCULATION_IND DOUBLE Y Identifies if the impaired circulation adverse event was document during restraint episode
ADV_REDUCTION_FUNC_IND DOUBLE Y Identifies if the severe reduction in fucnctional capacity adverse event was document during restraint episode
ADV_SKIN_BREAK_IND DOUBLE Y Identifies if the skin breakdown adverse event was document during restraint episode
D_REST_BUILDING_ID DOUBLE N The building in which the patient is restrained.
D_REST_FACILITY_ID DOUBLE N The facility in which the patient is restrained.
D_REST_NURSE_UNIT_ID DOUBLE N The nurse_unit in which the patient is restrained.
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_DTL_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_REST_DTL_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.
NONVIO_ASSESS_EXCL_IND DOUBLE Y Identifies the restraint episode is excluded for restraint non-violent assessment for continued need
NONVIO_ASSESS_IND DOUBLE Y Identifies the patient has assessment of nonviolent behavior continued performed with designated time frame during restraint episode
NONVIO_INIT_ORD_IND DOUBLE Y Identifies patient has restraint initiation nonviolent order placed with design time frame during restraint episode
NONVIO_RENEW_EXCL_IND DOUBLE Y Identifies the restraint episode is excluded for restraint non-violent renew order
NONVIO_RENEW_IND DOUBLE Y Identifies patient has assessment of nonviolent behavior continued performed with designated time frame during restraint episode
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged.
PHYS_CARE_EXCL_IND DOUBLE Y Identifies the restraint episode is excluded for restraints released to provide physical care needs
PHYS_CARE_IND DOUBLE Y Identifies the patient has restraint released to provider physical care is in designated time frame during restraint episode
RESTRAINT_BEG_DT_TM DATETIME Y The date/time on which restraint activity for restraint episode beginning date/time
RESTRAINT_BEG_UTC_DT_TM DATETIME Y The date/time on which the restraint activity for restraint episode beginning datetime; normalized to GMT.
RESTRAINT_BEH_FLAG DOUBLE Y Identifies the restraint initialization behavior reason for violent or non-violent or other was documented during restraint episode (none/other , violent, non-violent)
RESTRAINT_END_DT_TM DATETIME Y The Date/time on which the restraint discontinue for restraint episode end datetime
RESTRAINT_END_UTC_DT_TM DATETIME Y The Date/time on which the restraint discontinue for restraint episode end datetime; normalized to GMT
REST_PHYS_DT_TM DATETIME Y The date/time on which physical restraint type was document during restraint episode
REST_PHYS_UTC_DT_TM DATETIME Y The date/time on which physical restraint type was document during restraint episode; normalized to GMT
REST_SEC_DT_TM DATETIME Y The date/time on which seclusion restraint type was document during restraint episode
REST_SEC_UTC_DT_TM DATETIME Y The date/time on which seclusion restraint type was document during restraint episode; normalized to GMT
RISK_PRIOR_RESTRAINT_IND DOUBLE Y Identifies if the patient was at risk prior to this restraint episode beginning
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.
VIO_ASSESS_IND DOUBLE Y Identifies patient has face to face assessment of violent behavior performed with 1 hours of initiation of restraint
VIO_INIT_ORD_DT_TM DATETIME Y The date/time on which the restraint initiation violent order placed with design time frame during restraint episode
VIO_INIT_ORD_IND DOUBLE Y Identifies patient has restraint initiation violent order placed with design time frame during restraint episode
VIO_INIT_ORD_UTC_DT_TM DATETIME Y The date/time on which the restraint initiation violent order placed with design time frame during restraint episode; normalized to GMT
VIO_REORD_EXCL_IND DOUBLE Y INDICATOR
VIO_REORD_IND DOUBLE Y Identifies patient has restraint violent re-order at appropriate intervals during the restraint episode



Relationship Detail - LH_F_REST_DTL_METRICS


Child Column in LH_F_REST_DTL_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_REST_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_REST_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_REST_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID