Table Detail Report

LH_CNT_NHSN_LOCATION_MAP



Column Section Top of Page


Table-level Detail

Description: NHSN LOCATION MAP
Definition: This table will hold the mapping between NHSN assigned nursing units identifier and organization to which it belongs to
Table Type: REFERENCE





Column Detail - LH_CNT_NHSN_LOCATION_MAP


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.
CDC_LOCATION_LABEL_CD DOUBLE N CDC Location Label defined by the CDC.
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.
FACILITY_CD DOUBLE N Code Value of the facility.
FACILITY_OID VARCHAR(200) N User defined value for a facility.
LH_CNT_NHSN_LOCATION_MAP_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_NHSN_LOCATION_MAP table.
NHSN_UNIT_DISP_NAME VARCHAR(200) N The textual display of either an facility or nursing unit.
NURSE_LOC_CD DOUBLE N Code Value of the nursing unit.
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.