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 |