Table Detail Report
LH_F_IC_ANTIBGRM_DTL
Column Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_ANTIBGRM_DTL |
Definition: | This fact table is used to store Infection Control Antibiogram Dtail Lighthouse Report. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_ANTIBGRM_DTL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
D_ANTIBIOTIC_ID | DOUBLE | N | Identifies the antibiotic for microbiology susceptibility results |
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 that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
INTERPRETATION_RESULT | VARCHAR(10) | Y | Identifies susceptibility interpretation of the particular antibiotic. (S, I, R..etc.) |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_F_IC_ANTIBGRM_DTL_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_IC_ANTIBGRM_DTL table. |
LH_F_IC_ANTIBGRM_METRICS_ID | DOUBLE | N | Unique identifier for the infection control antibiogram master. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
RESULT_DT_TM | DATETIME | Y | The date and time of the results |
RESULT_UTC_DT_TM | DATETIME | Y | The date and time of the results; normalized to GMT. |
SUSCEP_SEQ_NBR | DOUBLE | Y | The sequence of the susceptibility results |
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. |
LH_F_IC_ANTIBGRM_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_ANTIBGRM_METRICS |
Definition: | This fact table is used to store Infection Control Antibiogram Lighthouse Report. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_ANTIBGRM_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted normalized to GMT. |
COLLECT_DT_TM | DATETIME | Y | Date and time of the specimen source collected for the organism |
COLLECT_UTC_DT_TM | DATETIME | Y | Date and time of the specimen source collected for the organism; normalized to GMT. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged normalized to GMT. |
D_COLL_BUILDING_ID | DOUBLE | N | Identifies the building of specimen source collected for the organism. |
D_COLL_ENCNTR_TYPE_ID | DOUBLE | N | Identifies the encounter type of specimen source collected for the organism. |
D_COLL_FACILITY_ID | DOUBLE | N | Identifies the facility of specimen source collected for the organism. |
D_COLL_NURSE_UNIT_ID | DOUBLE | N | Identifies the nurse unit of specimen source collected for the organism. |
D_ORGANISM_ID | DOUBLE | N | Identifies the reported organism |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
D_SOURCE_ID | DOUBLE | N | Identifies the body site for the organism. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EVENT_ID | DOUBLE | N | The event_id (from clinical_event) associated with the organism result. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_F_IC_ANTIBGRM_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_IC_ANTIBGRM_METRICS table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
MICRO_SEQ_NBR | DOUBLE | Y | The sequence of the microbiology result; 0 if serology. |
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 |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_F_IC_ANTIBGRM_METRICS
Child Column in LH_F_IC_ANTIBGRM_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_COLL_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_COLL_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_COLL_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_COLL_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_ORGANISM_ID | LH_D_ORGANISM | D_ORGANISM_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ORGANISM | HEALTH_SYSTEM_SOURCE_ID | |
D_SOURCE_ID | LH_D_SOURCE | D_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_SOURCE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_IC_HAI
Column Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_HAI |
Definition: | Infection control hospital associated infection metrics. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_HAI
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. |
BSI_DEVICE_LATERALITY | VARCHAR(100) | Y | The location/laterality of the device. |
COLLECT_DT_TM | DATETIME | Y | The specimen collection date/time associated with the infection. |
COLLECT_LOCATION | VARCHAR(255) | Y | The location of the patient at the time of the specimen collection. |
COLLECT_UTC_DT_TM | DATETIME | Y | The specimen collection date/time associated with the infection. |
DEVICE_INSERT_DAYS | DOUBLE | Y | The total number of days from device insertion to infection. |
DEVICE_INSERT_DT_TM | DATETIME | Y | The date/time on which the device associated with the HAI event was inserted. |
DEVICE_INSERT_UTC_DT_TM | DATETIME | Y | The date/time on which the device associated with the HAI event was inserted. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. |
EVENT_DT_TM | DATETIME | Y | The date/time of the HAI event. |
EVENT_LOCATION | VARCHAR(255) | Y | The location of the patient at the time of the HAI event. |
EVENT_UTC_DT_TM | DATETIME | Y | The date/time of the HAI event. |
EXTRACT_DT_TM | DATETIME | Y | The date/time the record was extracted from the source system. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
F_IC_HAI_ID | DOUBLE | N | Unique identifier for the infection control HAI metrics. |
F_IC_METRICS_ID | DOUBLE | N | Unique identifier for the infection control metrics. |
HAI_EVENT_ID | DOUBLE | N | The clinical event associated with the HAI event. |
HAI_SUBTYPE | VARCHAR(100) | Y | Identifies the sub-type of infection. |
HAI_TYPE | VARCHAR(50) | Y | Identifies the type of infection. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
ORGANISM | VARCHAR(255) | Y | The organisms associated with the HAI event. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
SPECIMEN_SOURCE | VARCHAR(100) | Y | The specimen source for the HAI. |
SSI_NHSN_PROC_DESC | VARCHAR(50) | Y | The NHSN procedure code associated with the SSI infection. |
SSI_ORGAN | VARCHAR(100) | Y | The organ identified for the SSI infection type of organ/space. |
SSI_PROC_CODE | VARCHAR(50) | Y | The NHSN procedure code associated with the SSI infection. |
SSI_PROC_DESC | VARCHAR(100) | Y | The surgical procedure associated with the SSI infection. |
SURGEON_NAME | VARCHAR(100) | Y | The surgeon associated with the SSI infection. |
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. |
LH_F_IC_HAI_DTL_METRICS
Column Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_HAI_DTL_METRICS |
Definition: | This table is used to store Infection Control HAI metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_HAI_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. |
COLLECT_DT_TM | DATETIME | Y | Date/Time when the organism was collected |
COLLECT_FACILITY_TXT | VARCHAR(100) | Y | Where the patient was located when the specimen was collected |
COLLECT_NURSE_UNIT_TXT | VARCHAR(100) | Y | Where the patient was located when the specimen was collected |
COLLECT_UTC_DT_TM | DATETIME | Y | Date/Time when the organism was collected |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EVENT_DT_TM | DATETIME | Y | Date/Time when the event occurred |
EVENT_FACILITY_TXT | VARCHAR(100) | Y | Where the event took place |
EVENT_ID | DOUBLE | N | ID of the Advisor Event. From the clinical_event table. |
EVENT_NURSE_UNIT_TXT | VARCHAR(100) | Y | Where the event took place |
EVENT_UTC_DT_TM | DATETIME | Y | Date/Time when the event occurred |
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 that the first ETL process started that created this record. |
HAI_CATEGORY_TXT | VARCHAR(100) | Y | BSI/UTI/PN/SSI |
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. |
ICD9_CODE_DESC_TXT | VARCHAR(100) | Y | SSI Only: ICD9 Procedure Code Description |
ICD9_CODE_TXT | VARCHAR(100) | Y | SSI Only: ICD9 Procedure Code |
INSERT_DT_TM | DATETIME | Y | BSI/UTI/PN Only: Line insertion date/time |
INSERT_UTC_DT_TM | DATETIME | Y | BSI/UTI/PN Only: Line insertion date/time |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_F_IC_HAI_DTL_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_IC_HAI_DTL_METRICS table. |
LOCATION_LATERALITY_TXT | VARCHAR(100) | Y | BSI/UTI/PN Only: Location and Laterality of Line (i.e. Hand R) |
NBR_DAYS_INSERT_INFECT | DOUBLE | Y | BSI/UTI/PN Only: Number of days from insertion of line to infection |
ORGANISM_TXT | VARCHAR(100) | Y | Organism Name |
ORGAN_TYPE_TXT | VARCHAR(100) | Y | SSI Only: Organ being operated on |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
SPECIFIC_HAI_TXT | VARCHAR(100) | Y | Specific HAI (Central Line, Other, Procedure, etc.) |
SPECIMEN_SOURCE_TXT | VARCHAR(100) | Y | How the specimen was collected (i.e. Blood) |
SSI_NHSN_PROC_TXT | VARCHAR(100) | Y | COLO, HYST, KSPRO, HPRO, CBGC |
SURGEON_NAME_TXT | VARCHAR(100) | Y | SSI Only: Surgeon performing operation |
UNIT_OF_ORIGIN_TXT | VARCHAR(100) | Y | BSI/UTI/PN Only: Patient Location When Line was Inserted |
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. |
LH_F_IC_HAI_ENCNTR_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_HAI_ENCNTR_METRICS |
Definition: | This table is used to store Infection Control HAI metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_HAI_ENCNTR_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted. |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility normalized to GMT. |
ASM_BACT_IND | DOUBLE | Y | Indicates Asymptomatic Bacteremic Urinary Tract Infection |
ASP_PN_IND | DOUBLE | Y | Indicates Aspiration Pneumonia |
CAUTI_IND | DOUBLE | Y | Indicates Catheter Associated Urinary Tract Infection |
CLABSI_IND | DOUBLE | Y | Indicates patient had Central Line Associated Blood Stream Infection |
CL_DAYS | DOUBLE | Y | Total Central Line Days |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DIP_IND | DOUBLE | Y | Indicates Deep Incisional Primary Infection |
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. |
DIS_IND | DOUBLE | Y | Indicates Deep Incisional Secondary Infection |
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_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_METRIC_10_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_11_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_12_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_13_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_14_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_15_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_16_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_17_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_18_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_19_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_1_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_20_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_3_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_4_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_5_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_6_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_7_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_8_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_9_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HAP_IND | DOUBLE | Y | Indicates Hospital Acquired 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. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LCBI_IND | DOUBLE | Y | Indicates Laboratory Confirmed Blood Infection |
LH_F_IC_HAI_ENCNTR_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_IC_HAI_ENCNTR_METRICS table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NBR_PROC | DOUBLE | Y | Number of Procedures for this encounter |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
OSI_IND | DOUBLE | Y | Indicates Organ, Space Infection |
OTHER_UTI_IND | DOUBLE | Y | Indicates Other Urinary Tract Infection |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PAT_DAYS | DOUBLE | Y | Total Patient Days |
POST_PROC_PN_IND | DOUBLE | Y | Indicates Post Procedure Pneumonia |
SEPSIS_IND | DOUBLE | Y | Indicates Clinical Sepsis |
SIP_IND | DOUBLE | Y | Indicates Superficial Incisional Primary Infection |
SIS_IND | DOUBLE | Y | Indicates Superficial Incisional Secondary Infection |
SUTI_IND | DOUBLE | Y | Indicates Symptomatic Urinary Tract Infection |
UC_DAYS | DOUBLE | Y | Total Urinary Catheter Days |
UL_DAYS | DOUBLE | Y | Total Umbilical Line Days |
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. |
VAP_IND | DOUBLE | Y | Indicates Ventilator Acquired Pneumonia |
VENT_DAYS | DOUBLE | Y | Total Ventilator Days |
Relationship Detail - LH_F_IC_HAI_ENCNTR_METRICS
Child Column in LH_F_IC_HAI_ENCNTR_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | 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_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_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 |