Table Detail Report

TRACKING_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Item Table
Definition: Tracking table used to define a tracking identifier for an item (such as a person, encounter, personnel, or inventory item) that is to be tracked. This table contains a tracking item for each time an item is to start and stop tracking.
Table Type: ACTIVITY





Column Detail - TRACKING_ITEM


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BASE_LOC_CD DOUBLE N The location where the patient is being treated. Used to indicate the location where the patient should be put after returning from an ancillary department or temporary location such as X-Ray.
BASE_LOC_DT_TM DATETIME Y The date and time when the patient was first placed in their base location. Used to calculate Treament Time.
CUR_TRACKING_LOCATOR_ID DOUBLE N Pointer to the current tracking locator record.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_TRACKING_DT_TM DATETIME Y Date and time that tracking ended for this tracking item.
END_TRACKING_ID DOUBLE N The person who caused the tracking item to end.
INVENTORY_ID DOUBLE N Inventory item to be tracked.
PARENT_ENTITY_ID DOUBLE N Table identifier from the Parent Entity Name table.
PARENT_ENTITY_NAME VARCHAR(30) Y Table Name identifier for the Parent Entity ID
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_PERSON_ID DOUBLE N Person Identifier of the provider to be tracked.
START_TRACKING_DT_TM DATETIME Y Date and time that tracking was started for this tracking item.
START_TRACKING_ID DOUBLE N The person who caused the tracking item to be started.
TRACKING_ID DOUBLE N Tracking IdentifierColumn
TRACKING_STATUS_FLAG DOUBLE Y The status of tracking on this item.
TRACKING_TYPE_FLAG DOUBLE Y A value that identifies what type of tracking is being used for this tracking item.
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 - TRACKING_ITEM


Child Column in TRACKING_ITEM(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_STATUS_CD CODE_VALUE CODE_VALUE
ENCNTR_ID ENCOUNTER ENCNTR_ID
INVENTORY_ID ITEM_MASTER ITEM_ID
BASE_LOC_CD LOCATION LOCATION_CD
PERSON_ID PERSON PERSON_ID
PRSNL_PERSON_ID PRSNL PERSON_ID




Parent Column in TRACKING_ITEM (PK) Child Table Name Child Column Name
Children: TRACKING_ID FN_OMF_ENCNTR TRACKING_ID
TRACKING_CHECKIN TRACKING_ID
TRACKING_COMMENT TRACKING_ID
TRACKING_COMPLAINT TRACKING_ID
TRACKING_ENCNTR_PRSNL_RELTN ENCNTR_TRACKING_ID
TRACKING_ENCNTR_PRSNL_RELTN PRSNL_TRACKING_ID
TRACKING_EVENT TRACKING_ID
TRACKING_HOLD TRACKING_ID
TRACKING_LOCATOR TRACKING_ID
TRACKING_TAG LAST_TRACKING_ID
TRACKING_TAG TRACKING_ID
TRACK_ACTION_LINK_ACTIVITY TRACKING_ID
TRACK_TRIGGER_ACTIVITY TRACKING_ID


TRACKING_LOCATOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Locator Table
Definition: Tracking table used to store all locations and their related information for each tracking item.
Table Type: ACTIVITY





Column Detail - TRACKING_LOCATOR


Column Name Type Null? Definition
ACTIVE_EVENTS_IND DOUBLE Y Active Events Indicator (Not Used)Column
ARRIVE_DT_TM DATETIME Y Date and time the tracking item arrived in this location.
ARRIVE_ID DOUBLE N The person who defined when the tracking item arrived in the location.
AVAILABILITY_IND DOUBLE Y An indicator defining the availability of the tracking item.
DEPART_DT_TM DATETIME Y Date and time the tracking item departed from this location.
DEPART_ID DOUBLE N Date and time the tracking item departed from this location.
LOCATION_CD DOUBLE N Location Code of the physical location the tracking item is being tracked to.
LOCATOR_CREATE_DATE DOUBLE N This columns used to identify location history sequence. The column is populated with a numeric value of the create date/time (when inserted) adjusted for time zone. It should never be modified.
LOC_BED_CD DOUBLE N Location Bed Code of the physical location the tracking item is being tracked to.
LOC_NURSE_UNIT_CD DOUBLE N Location Nurse Unit Code of the physical location the tracking item is being tracked to.
LOC_ROOM_CD DOUBLE N Location Room Code of the physical location the tracking item is being tracked to.
RANK_SEQUENCE DOUBLE Y The rank sequence of the item while it was in this location.
SCHEDULED_DT_TM DATETIME Y Date and time the tracking item is scheduled to arrived in this location.
TRACKING_ACUITY_LEVEL_ID DOUBLE N The acuity level of the tracking item while it was in this location.
TRACKING_ID DOUBLE N Tracking Identifier of the tracking item being tracked to this location.
TRACKING_LOCATOR_ID DOUBLE N Tracking Locator Identifier
TRACKING_REASON_CD DOUBLE N Value that identifies why the tracking item is in this tracking location.
TRACKING_REASON_COMMENT VARCHAR(200) Y Tracking Reason CommentColumn
UNAVAIL_TRACKING_EVENT_ID DOUBLE N Pointer to the tracking items tracking event that is not available to complete while the tracking item is in this tracking location. (Not Used)
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 - TRACKING_LOCATOR


Child Column in TRACKING_LOCATOR(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD CODE_VALUE CODE_VALUE
LOC_BED_CD CODE_VALUE CODE_VALUE
LOC_NURSE_UNIT_CD CODE_VALUE CODE_VALUE
LOC_ROOM_CD CODE_VALUE CODE_VALUE
TRACKING_REASON_CD CODE_VALUE CODE_VALUE
ARRIVE_ID PRSNL PERSON_ID
DEPART_ID PRSNL PERSON_ID
TRACKING_ID TRACKING_ITEM TRACKING_ID
TRACKING_ACUITY_LEVEL_ID TRACK_REFERENCE TRACKING_REF_ID




Parent Column in TRACKING_LOCATOR (PK) Child Table Name Child Column Name
Children: TRACKING_LOCATOR_ID TRACKING_ENCNTR_PRSNL_RELTN TRACKING_LOCATOR_ID


TRACKING_LOC_STATUS



Column Section Top of Page


Table-level Detail

Description: Tracking Location Status
Definition: Table used to store status information associated with a tracking item to be displayed on the Tracking Locator Board.
Table Type: ACTIVITY





Column Detail - TRACKING_LOC_STATUS


Column Name Type Null? Definition
DOC_STATUS_DT_TM DATETIME Y Doctor Status Date and TimeColumn
DOC_STATUS_EVT_ID DOUBLE N Doctor Status Event IdentifierColumn
LAB_STATUS_DT_TM DATETIME Y Lab Status Date and TimeColumn
LAB_STATUS_EVT_ID DOUBLE N Lab Status Event IdentifierColumn
LOCATION_CD DOUBLE N Location CodeColumn
LOC_STATUS_EVT_DT_TM DATETIME Y Location Status Event Date and TimeColumn
LOC_STATUS_EVT_ID DOUBLE N Location Status Event IdentifierColumn
LOC_STATUS_ITEM_ID DOUBLE N Location Status Tracking ItemColumn
NURSE_STATUS_DT_TM DATETIME Y Nursing Status Date and TimeColumn
NURSE_STATUS_EVT_ID DOUBLE N Nursing Status Event IdentifierColumn
TRACKING_LOC_STATUS_ID DOUBLE N Tracking Location Status IdentifierColumn
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.
URGENT_DT_TM DATETIME Y Urgent Date and TimeColumn
URGENT_IND DOUBLE Y Urgent IndicatorColumn


TRACKING_PREARRIVAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Pre-Arrival Information
Definition: Tracking Pre-Arrival Information for EMS, doctor referral patients
Table Type: ACTIVITY





Column Detail - TRACKING_PREARRIVAL


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.
AGE_TXT VARCHAR(30) N Free Text - age of patient
ATTACHED_ENCNTR_ID DOUBLE N Actual encntr_id of the pre-arrival patient. Will be back-filled after person/encounter data is available.
ATTACHED_PERSON_ID DOUBLE N Actual person_id of the pre_arrival patient. Will be back-filled after encounter/person data is available.
BIRTH_DT_TM DATETIME Y Birth Date of Patient
CHIEF_COMPLAINT VARCHAR(255) N Presenting Problem of the patient
CREATE_DT_TM DATETIME N Date time when pre-arrival record is created.
ESTIMATED_ARRIVE_DT_TM DATETIME N Patient Estimated Arrival Date and Time
FIRST_NAME VARCHAR(200) N Patient First Name - PERSON data not yet available
LAST_NAME VARCHAR(200) N Patient Last Name - PERSON data not yet available
PCP_PROVIDER_ID DOUBLE N Provider_id of the Primary care physician. FK from PRSNL
PCP_PROVIDER_NAME VARCHAR(150) N Free Text PCP Name. May be in liew of ID
PREARRIVAL_TYPE_CD DOUBLE N Prearrival type of patient
REFERRING_SOURCE_ID DOUBLE N PRSNL_ID of referring source provider
REFERRING_SOURCE_NAME VARCHAR(150) N Name of Referring Source (may be in liew of Personnel data)
REG_PRSNL_ID DOUBLE N Person id who registers the Prearrival
REG_PRSNL_NAME VARCHAR(150) N Free Text Registration Prsnl Name (may be in liew of personnel data)
SEX_CD DOUBLE N Gender Code of the Patient
TRACKING_GROUP_CD DOUBLE N Tracking Group Code
TRACKING_PREARRIVAL_ID DOUBLE N Primary Key for the table Unique id for the table.
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 - TRACKING_PREARRIVAL


Child Column in TRACKING_PREARRIVAL(FK) Parent Table Name Parent Column Name
Parents: ATTACHED_ENCNTR_ID ENCOUNTER ENCNTR_ID
ATTACHED_PERSON_ID PERSON PERSON_ID
PCP_PROVIDER_ID PRSNL PERSON_ID
REG_PRSNL_ID PRSNL PERSON_ID




Parent Column in TRACKING_PREARRIVAL (PK) Child Table Name Child Column Name
Children: TRACKING_PREARRIVAL_ID TRACKING_PREARRIVAL_USERFIELDS TRACKING_PREARRIVAL_ID


TRACKING_PREARRIVAL_USERFIELDS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Pre Arrival User Defined Fields
Definition: Tracking Pre Arrival information on customizable drop downs
Table Type: ACTIVITY





Column Detail - TRACKING_PREARRIVAL_USERFIELDS


Column Name Type Null? Definition
TRACKING_PREARRIVAL_ID DOUBLE N Foreign key to tracking_pre-arrival table
TRACKING_PREARRIVAL_USRFLD_ID DOUBLE N Unique id for the table. Primary Key
TRACK_PREARRIVAL_FIELD_ID DOUBLE N Id for the track_pre-arrival_field record defining this user-defined data
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.
USER_DATA_DT_TM DATETIME Y The date/time value for this user-defined data if the user_data_type_cd is a date type.
USER_DATA_IDENT DOUBLE N ** OBSOLETE - NO LONGER USED - JANUARY 30, 2008**Identifier from Preferences
USER_DATA_SEQ DOUBLE Y When a TRACK_PREARRIVAL_FIELD_ID occurs more than once for a particular TRACKING_PREARRIVAL_ID this field is used to determine the order in which the data should be displayed on the form.
USER_DATA_TEXT VARCHAR(255) N Short length Free Text
USER_DATA_TYPE_CD DOUBLE N Type of field Code value (20530)
USER_DATA_VALUE DOUBLE N Code_value from one of the code_sets



Relationship Detail - TRACKING_PREARRIVAL_USERFIELDS


Child Column in TRACKING_PREARRIVAL_USERFIELDS(FK) Parent Table Name Parent Column Name
Parents: TRACKING_PREARRIVAL_ID TRACKING_PREARRIVAL TRACKING_PREARRIVAL_ID
TRACK_PREARRIVAL_FIELD_ID TRACK_PREARRIVAL_FIELD TRACK_PREARRIVAL_FIELD_ID