Table Detail Report

LH_CNT_LOC_UNIT_CENSUS



Column Section Top of Page


Table-level Detail

Description: LH_CNT_LOC_NURSE_UNIT_CENSUS
Definition: Stores daily patient totals for nurse units.
Table Type: ACTIVITY





Column Detail - LH_CNT_LOC_UNIT_CENSUS


Column Name Type Null? Definition
CENSUS_DT_TM DATETIME N Date and time the census was performed.
CENSUS_PERSON_TOTAL DOUBLE N Total people present in the nurse unit at the time the census was performed.
LH_CNT_LOC_UNIT_CENSUS_ID DOUBLE N Unique generated number to identify a single row in the table - PRIMARY KEY
LOC_FACILITY_CD DOUBLE N Location facility code value. The Facility Code attributed to the census performed.
LOC_NURSE_UNIT_CD DOUBLE N Location nurse unit code value. The location attributed to the census performed.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


LH_CNT_LTD_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_LTD_DATA
Definition: Summary table for all dynamic group Lines, Tubes, and Drains.
Table Type: ACTIVITY





Column Detail - LH_CNT_LTD_DATA


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.
CE_DYNAMIC_LABEL_ID DOUBLE N Foreign key to CE_DYNAMIC_LABEL for the dynamic group the ltd was documented on.
DISC_DT_TM DATETIME Y Discontinue date and time for the ltd.
INSERT_DT_TM DATETIME Y Insertion date and time for the ltd.
INSERT_ENCNTR_ID DOUBLE N Foreign key to ENCOUNTER table for the encounter in which the line was inserted.
INSERT_LOC_BED_CD DOUBLE N Bed in which the person was located when the ltd was inserted.
INSERT_LOC_FAC_CD DOUBLE N Facility in which the person was located when the ltd was inserted
INSERT_LOC_NURSE_UNIT_CD DOUBLE N Nurse unit in which the person was located when the ltd was inserted.
INSERT_LOC_ROOM_CD DOUBLE N Room in which the person was located when the ltd was inserted.
LH_CNT_LTD_DATA_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_LTD_DATA table.
LTD_TYPE_FLAG DOUBLE N Flag indicating the ltd type. (Central line, urinary catheter, etc.)
PERSON_ID DOUBLE N Foreign key to PERSON table for whom the line belongs.
POA_DT_TM DATETIME Y Date and time of the initial present on admission documentation.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VESSEL_TYPE_FLAG DOUBLE N Flag indicating the vessel type. (Umbilical, great vessel, etc.)



Relationship Detail - LH_CNT_LTD_DATA


Child Column in LH_CNT_LTD_DATA(FK) Parent Table Name Parent Column Name
Parents: CE_DYNAMIC_LABEL_ID CE_DYNAMIC_LABEL CE_DYNAMIC_LABEL_ID
INSERT_ENCNTR_ID ENCOUNTER ENCNTR_ID
INSERT_LOC_BED_CD LOCATION LOCATION_CD
INSERT_LOC_FAC_CD LOCATION LOCATION_CD
INSERT_LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
INSERT_LOC_ROOM_CD LOCATION LOCATION_CD
PERSON_ID PERSON PERSON_ID




Parent Column in LH_CNT_LTD_DATA (PK) Child Table Name Child Column Name
Children: LH_CNT_LTD_DATA_ID LH_CNT_LTD_DATA_DETAIL LH_CNT_LTD_DATA_ID


LH_CNT_LTD_DATA_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_LTD_DATA_DETAIL
Definition: Child table to the LH_CNT_LTD_DATA summary table that stores details associated with Lines, Tubes, Drains.
Table Type: ACTIVITY





Column Detail - LH_CNT_LTD_DATA_DETAIL


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.
DETAIL_TYPE_FLAG DOUBLE Y The type of detail stored by this row. (Laterality, Description, Vent Mode, etc.)
EVENT_END_DT_TM DATETIME Y The event_end_dt_tm of the detail taken from CLINICAL_EVENT.
EVENT_ID DOUBLE N The event_id for the detail taken from CLINICAL_EVENT.
LH_CNT_LTD_DATA_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_LTD_DATA_DETAIL table.
LH_CNT_LTD_DATA_ID DOUBLE N Foreign key id link to the parent row on LH_CNT_LTD_DATA for the associated detail.
NOMEN_ID DOUBLE N The nomenclature_id for the detail associated to the event_id taken from CLINICAL_EVENT(if found).
RESULT_VAL VARCHAR(255) Y The result value for the detail taken from CLINICAL_EVENT.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_CNT_LTD_DATA_DETAIL


Child Column in LH_CNT_LTD_DATA_DETAIL(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_LTD_DATA_ID LH_CNT_LTD_DATA LH_CNT_LTD_DATA_ID
NOMEN_ID NOMENCLATURE NOMENCLATURE_ID


LH_CNT_NHSN_BENCHMARK



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_NHSN_BENCHMARK
Definition: This table will store benchmark and target mapping for each facility and nurse unit, mapped through NHSN Location mapping utility
Table Type: REFERENCE





Column Detail - LH_CNT_NHSN_BENCHMARK


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LH_CNT_NHSN_BENCHMARK_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_NHSN_BENCHMARK table.
LH_CNT_NHSN_EVENT_METRIC_ID DOUBLE N Foreign key to LH_CNT_NHSN_EVENT_METRIC table.
NHSN_TARGET_TYPE_CD DOUBLE N This is the NHSN Target Type.
REPORTING_QUARTER_FLAG DOUBLE N This is the quarter the benchmark is reported on.
REPORTING_YEAR DOUBLE N This is the year the benchmark is reported on.
TARGET_PERCENT_VALUE DOUBLE N This is the target percentage value.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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_TASK DOUBLE 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_CNT_NHSN_BENCHMARK


Child Column in LH_CNT_NHSN_BENCHMARK(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_NHSN_EVENT_METRIC_ID LH_CNT_NHSN_EVENT_METRIC LH_CNT_NHSN_EVENT_METRIC_ID


LH_CNT_NHSN_EVENT_METRIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_NHSN_EVENT_METRIC
Definition: This table will store event metric mapped for facility and nurse unit through NHSN Location mapping utility
Table Type: REFERENCE





Column Detail - LH_CNT_NHSN_EVENT_METRIC


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LH_CNT_NHSN_EVENT_METRIC_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_NHSN_EVENT_METRIC table.
LOC_FACILITY_CD DOUBLE N This is field is the facility location for the event metric
LOC_UNIT_CD DOUBLE N This is field is the unit location within a facility for the event metric
NHSN_EVENT_TYPE_CD DOUBLE N This is the NHSN event type
NHSN_METRIC_CD DOUBLE N This is the NHSN HAI Metric Type
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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_TASK DOUBLE 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_CNT_NHSN_EVENT_METRIC


Child Column in LH_CNT_NHSN_EVENT_METRIC(FK) Parent Table Name Parent Column Name
Parents: LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_UNIT_CD LOCATION LOCATION_CD




Parent Column in LH_CNT_NHSN_EVENT_METRIC (PK) Child Table Name Child Column Name
Children: LH_CNT_NHSN_EVENT_METRIC_ID LH_CNT_NHSN_BENCHMARK LH_CNT_NHSN_EVENT_METRIC_ID