Table Detail Report
LH_F_IC_ISOLATION
Column Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_ISOLATION |
Definition: | Infection control isolation metrics. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_ISOLATION
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. |
BEG_DT_TM | DATETIME | Y | The date/time on which the isolation period started for the location/type. |
BEG_UTC_DT_TM | DATETIME | Y | The date/time on which the isolation period started for the location/type. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. |
END_DT_TM | DATETIME | Y | The date/time on which the isolation period ended for the location/type. |
END_UTC_DT_TM | DATETIME | Y | The date/time on which the isolation period ended for the location/type. |
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_ISOLATION_ID | DOUBLE | N | Unique identifier for the infection control isolation metrics. |
F_IC_METRICS_ID | DOUBLE | N | Unique identifier for the infection control metrics. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
ISOLATION_TYPE_MASK | DOUBLE | Y | The type of isolation within which the patient has been placed. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LOC_BED_CD | DOUBLE | N | The location associated with the patient during the isolation period. |
LOC_BUILDING_CD | DOUBLE | N | The location associated with the patient during the isolation period. |
LOC_FACILITY_CD | DOUBLE | N | The location associated with the patient during the isolation period. |
LOC_NURSE_UNIT_CD | DOUBLE | N | The location associated with the patient during the isolation period. |
LOC_ROOM_CD | DOUBLE | N | The location associated with the patient during the isolation period. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
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_MDRO_DTL_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_MDRO_DTL_METRICS |
Definition: | This fact table is used to store Infection Control MDRO DTAIL Lighthouse Report. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_MDRO_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. |
CAI_HAI_FLAG | DOUBLE | Y | identify CAI or HAI |
CDI_DESIGNATION_TXT | VARCHAR(100) | Y | CDIFF Designation |
COLLECT_DT_TM | DATETIME | Y | Identifies the specimen source for the organism. |
COLLECT_UTC_DT_TM | DATETIME | Y | Identifies the specimen source for the organism; normalized to GMT. |
D_BODY_SITE_ID | DOUBLE | N | Identifies the specimen source for the organism. |
D_COLL_BED_ID | DOUBLE | N | Identifies the bed of specimen source collected for the organism. |
D_COLL_BUILDING_ID | DOUBLE | N | Identifies the building 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_COLL_PREV_BED_ID | DOUBLE | N | Identifies the bed location prior to the collection of the specimen source for the organism. |
D_COLL_PREV_BUILDING_ID | DOUBLE | N | Identifies the building location prior to the collection of the specimen source for the organism. |
D_COLL_PREV_FACILITY_ID | DOUBLE | N | Identifies the facility location prior to the collection of the specimen source for the organism. |
D_COLL_PREV_NURSE_UNIT_ID | DOUBLE | N | Identifies the nurse unit location prior to the collection of the specimen source for the organism. |
D_COLL_PREV_ROOM_ID | DOUBLE | N | Identifies the room location prior to the collection of the specimen source for the organism. |
D_COLL_ROOM_ID | DOUBLE | N | Identifies the room of specimen source collected for the organism. |
D_ORGANISM_ID | DOUBLE | N | Identifies the reported organism or serology |
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 associated with the organism/serology result. From the clinical_event 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. |
HAI_DEVICE_LATERALITY | VARCHAR(100) | Y | Identifies the laterality of the device. |
HAI_DEVICE_LOCATION | VARCHAR(100) | Y | Identifies the location of the device. |
HAI_EVENT_ID | DOUBLE | N | Identifies the clinical event of the HAI event |
HAI_SUBTYPE | VARCHAR(100) | Y | Identifies the specific HAI within the HAI type. |
HAI_TYPE | VARCHAR(50) | Y | Identifies the HAI type of infection (BSI, UTI, PN, SSI , MDRO CDI) |
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_MDRO_DTL_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_IC_MDRO_DTL_METRICS table. |
MDRO_CAT_NAME | VARCHAR(150) | Y | Identified the mdro category name which setting in bedrock . |
MDRO_TYPE_FLAG | DOUBLE | Y | Identifies the type of MDRO |
MICRO_SEQ_NBR | DOUBLE | N | The sequence of the microbiology result; 0 if serology. |
ORGANISM_ENTITY_NAME | VARCHAR(50) | Y | ORGANISM or SEROLOGY |
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_MDRO_DTL_METRICS
Child Column in LH_F_IC_MDRO_DTL_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_COLL_BED_ID | LH_D_BED | D_BED_ID |
D_COLL_PREV_BED_ID | LH_D_BED | D_BED_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BED | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BED | HEALTH_SYSTEM_SOURCE_ID | |
D_BODY_SITE_ID | LH_D_BODY_SITE | D_BODY_SITE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BODY_SITE | HEALTH_SYSTEM_SOURCE_ID | |
D_COLL_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_COLL_PREV_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_COLL_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_COLL_PREV_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_COLL_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_COLL_PREV_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_ORGANISM_ID | LH_D_ORGANISM | D_ORGANISM_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ORGANISM | HEALTH_SYSTEM_SOURCE_ID | |
D_COLL_PREV_ROOM_ID | LH_D_ROOM | D_ROOM_ID | |
D_COLL_ROOM_ID | LH_D_ROOM | D_ROOM_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ROOM | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ROOM | 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_MDRO_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_MDRO_METRICS |
Definition: | This fact table is used to store Infection Control MDRO Lighthouse Report. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_MDRO_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. |
CAI_TYPE_IND | DOUBLE | Y | Identifies whether the encounter qualifies Community Associated Infection (CAI) Type |
CDIFF_IND | DOUBLE | Y | Identifies whether the encounter qualifies C Difficile MDRO |
CD_1_IND | DOUBLE | Y | Identifies whether the encounter qualifies client defined MDRO #1 |
CD_2_IND | DOUBLE | Y | Identifies whether the encounter qualifies client defined MDRO #2 |
CD_3_IND | DOUBLE | Y | Identifies whether the encounter qualifies client defined MDRO #3 |
CD_4_IND | DOUBLE | Y | Identifies whether the encounter qualifies client defined MDRO #4 |
CD_5_IND | DOUBLE | Y | Identifies whether the encounter qualifies client defined MDRO #5 |
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. |
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_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 | The person that qualified for the quality metric. |
D_PREV_DISCH_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged from previous encounter |
D_PREV_DISCH_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged from previous encounter |
D_PREV_DISCH_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged from previous encounter |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Identifies the principle procedure associated with the encounter. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
INPATIENT_TYPE_IND | DOUBLE | Y | Identifies whether the encounter is inpatient. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_F_IC_MDRO_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_IC_MDRO_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. |
MRSA_IND | DOUBLE | Y | Identifies whether the encounter qualifies MRSA MDRO |
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 |
PREV_DISCH_DT_TM | DATETIME | Y | The date/time on which the patient was discharged from previous encounter |
PREV_DISCH_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged from previous encounter; normalized to GMT. |
PREV_ENCNTR_ID | DOUBLE | N | Identifies the patient's previous discharge encounter |
PREV_INPATIENT_ENC_IND | DOUBLE | Y | Identifies whether the previous encounter is inpatient type. |
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. |
VRE_IND | DOUBLE | Y | Identifies whether the encounter qualifies VRE MDRO |
Relationship Detail - LH_F_IC_MDRO_METRICS
Child Column in LH_F_IC_MDRO_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 | |
D_PREV_DISCH_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 | |
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 | |
D_PREV_DISCH_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 | |
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_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_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 | |
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 | |
D_PREV_DISCH_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 | |
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_IC_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_METRICS |
Definition: | Infection control metrics. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_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_BED_CD | DOUBLE | N | Identifies the bed to which the patient was admitted. |
ADMIT_BUILDING_CD | DOUBLE | N | Identifies the building to which the patient was admitted. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted to the facility. |
ADMIT_FACILITY_CD | DOUBLE | N | Identifies the facility to which the patient was admitted. |
ADMIT_NURSE_UNIT_CD | DOUBLE | N | Identifies the nurse unit to which the patient was admitted. |
ADMIT_ROOM_CD | DOUBLE | N | Identifies the room to which the patient was admitted. |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted to the facility. |
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. |
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 from the facility. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged from the facility. |
DISC_BED_CD | DOUBLE | N | Identifies the bed from which the patient was discharged. |
DISC_BUILDING_CD | DOUBLE | N | Identifies the building from which the patient was discharged. |
DISC_FACILITY_CD | DOUBLE | N | Identifies the facility from which the patient was discharged. |
DISC_NURSE_UNIT_CD | DOUBLE | N | Identifies the nurse unit from which the patient was discharged. |
DISC_ROOM_CD | DOUBLE | N | Identifies the room from which the patient was discharged. |
D_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. |
ENCNTR_TYPE_FLAG | DOUBLE | Y | The type of encounter: 1=Inpatient, 2=Outpatient |
EXTRACT_DT_TM | DATETIME | Y | The date/time the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | N | Identifies the financial number of the patient. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
F_IC_METRICS_ID | DOUBLE | N | Unique identifier for the infection control metrics. |
HAI_BSI_CL_CNT | DOUBLE | Y | Identifies the number of central line related bloodstream infections. |
HAI_BSI_CNT | DOUBLE | Y | Identifies the number of bloodstream infections for the patient. |
HAI_BSI_LAB_CNT | DOUBLE | Y | Identifies the number of lab confirmed blood stream infections. |
HAI_BSI_SEP_CNT | DOUBLE | Y | Identifies the number of sepsis related bloodstream infections. |
HAI_ON_ADMIT_IND | DOUBLE | Y | Identifies if the patient had a hospital associated infection on admission. |
HAI_PN_ASP_CNT | DOUBLE | Y | Identifies the number of aspiration pneumonia infections. |
HAI_PN_CNT | DOUBLE | Y | Identifies the number of pneumonia infections for the patient. |
HAI_PN_HAP_CNT | DOUBLE | Y | Identifies the number of hospital associated pneumonia infections. |
HAI_PN_PROC_CNT | DOUBLE | Y | Identifies the number of procedure related pneumonia infections. |
HAI_PN_VAP_CNT | DOUBLE | Y | Identifies the number of ventilator associated pneumonia infections. |
HAI_SSI_CNT | DOUBLE | Y | Identifies the number of surgical site infections. |
HAI_SSI_DIP_CNT | DOUBLE | Y | Identifies the number of deep incision primary infections. |
HAI_SSI_DIS_CNT | DOUBLE | Y | Identifies the number of deep incision secondary infections. |
HAI_SSI_ORGAN_CNT | DOUBLE | Y | Identifies the number of organ/space infections. |
HAI_SSI_SIP_CNT | DOUBLE | Y | Identifies the number of superficial incision primary infections. |
HAI_SSI_SIS_CNT | DOUBLE | Y | Identifies the number of superficial incision secondary infections. |
HAI_UTI_ASYMP_CNT | DOUBLE | Y | Identifies the number of asymptomatic urinary tract infections. |
HAI_UTI_CATH_CNT | DOUBLE | Y | Identifies the number of catheter related urinary tract infections. |
HAI_UTI_CNT | DOUBLE | Y | Identifies the number of urinary tract infections for the patient. |
HAI_UTI_OTHER_CNT | DOUBLE | Y | Identifies the number of other urinary tract infections. |
HAI_UTI_SYMP_CNT | DOUBLE | Y | Identifies the number of symptomatic urinary tract infections. |
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. |
ISOLATION_IND | DOUBLE | Y | Identifies if the patient was in isolation during their visit. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
ORGANISM_IND | DOUBLE | Y | Identifies if the patient is to be included in the organism summary. |
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. |
PERSON_ID | DOUBLE | N | Identifiers the person against which the quality measure is associated. |
REPORTABLE_CONDITION_IND | DOUBLE | Y | Identifies if the patient had a reportable condition. |
TB_COLLECT_BED_CD | DOUBLE | N | Identifies the location of the patient when the TB specimen was collected. |
TB_COLLECT_BUILDING_CD | DOUBLE | N | Identifies the location of the patient when the TB specimen was collected. |
TB_COLLECT_DT_TM | DATETIME | Y | Identifies the date/time on which the tb specimen was collected. |
TB_COLLECT_FACILITY_CD | DOUBLE | N | Identifies the location of the patient when the TB specimen was collected. |
TB_COLLECT_NURSE_UNIT_CD | DOUBLE | N | Identifies the location of the patient when the TB specimen was collected. |
TB_COLLECT_ROOM_CD | DOUBLE | N | Identifies the location of the patient when the TB specimen was collected. |
TB_COLLECT_UTC_DT_TM | DATETIME | Y | Identifies the date/time on which the tb specimen was collected. |
TB_EVENT_ID | DOUBLE | N | Identifies the clinical event record associated with the TB result. |
TB_FLAG | DOUBLE | Y | Identifies if the patient had a positive result for TB. |
TB_RESULT_DT_TM | DATETIME | Y | Identifies the date/time of the positive result. |
TB_RESULT_UTC_DT_TM | DATETIME | Y | Identifies the date/time of the positive result. |
TB_SPECIMEN_SOURCE_CD | DOUBLE | N | Identifies the code value associated with the tb specimen source. |
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 | 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) | 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_IC_METRICS
Child Column in LH_F_IC_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_PERSON_ID | LH_D_PERSON | D_PERSON_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID |
LH_F_IC_ORG_SMRY
Column Section | Top of Page |
Table-level Detail
Description: | LH_F_IC_ORG_SMRY |
Definition: | Infection control organism summary metrics. |
Table Type: | ACTIVITY |
Column Detail - LH_F_IC_ORG_SMRY
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. |
BODY_SITE_CD | DOUBLE | N | The body site associated with the organism. |
CAI_IND | DOUBLE | Y | Community Associated Infection Indicator |
CDI_DESIGNATION_FLAG | DOUBLE | Y | The CDI Designation: 1=Recurrent, 2=Indeterminate, 3=CO-HC Facility Associated, 4=HO-HC Facility Associated, 5=Community Associated |
COLLECT_BED_CD | DOUBLE | N | The location of the patient at the time that the specimen was collected. |
COLLECT_BUILDING_CD | DOUBLE | N | The location of the patient at the time that the specimen was collected. |
COLLECT_DT_TM | DATETIME | Y | The date/time on which the specimen was collected. |
COLLECT_FACILITY_CD | DOUBLE | N | The location of the patient at the time that the specimen was collected. |
COLLECT_NURSE_UNIT_CD | DOUBLE | N | The location of the patient at the time that the specimen was collected. |
COLLECT_PREV_BED_CD | DOUBLE | N | The location of the patient just prior to the time that the specimen was collected. |
COLLECT_PREV_BUILDING_CD | DOUBLE | N | The location of the patient just prior to the time that the specimen was collected. |
COLLECT_PREV_FACILITY_CD | DOUBLE | N | The location of the patient just prior to the time that the specimen was collected. |
COLLECT_PREV_NURSE_UNIT_CD | DOUBLE | N | The location of the patient just prior to the time that the specimen was collected. |
COLLECT_PREV_ROOM_CD | DOUBLE | N | The location of the patient just prior to the time that the specimen was collected. |
COLLECT_ROOM_CD | DOUBLE | N | The location of the patient at the time that the specimen was collected. |
COLLECT_UTC_DT_TM | DATETIME | Y | The date/time on which the specimen was collected. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. |
EVENT_ID | DOUBLE | N | The event identifier associated with the organism. From the clinical_event table. |
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_METRICS_ID | DOUBLE | N | Unique identifier for the infection control metrics. |
F_IC_ORG_SMRY_ID | DOUBLE | N | Unique identifier for the infection control organism summary metrics. |
HAI_IND | DOUBLE | Y | Healthcare Associated Infection Indicator |
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. |
MDRO_TYPE_FLAG | DOUBLE | Y | The type of MDRO: 0=Non MDRO, 1=MDRO, 2=MRSA, 3=VRE, 4=CDIFF, 5=Other |
MICRO_SEQ_NBR | DOUBLE | N | The microbiology sequence number associated with the organism. |
ORGANISM_CNT | DOUBLE | Y | Identifies the number of organisms. |
ORGANISM_ENTITY_ID | DOUBLE | N | The unique identifier associated with the organism. |
ORGANISM_ENTITY_NAME | VARCHAR(50) | Y | Identifies whether the organism is part of a Serology or not. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
SPECIMEN_SOURCE_CD | DOUBLE | N | The specimen source associated with the organism. |
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. |