Table Detail Report

TRACKING_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Event Table
Definition: Tracking table used to store the events that are Requested, Started, or Completed for a tracking item.
Table Type: ACTIVITY





Column Detail - TRACKING_EVENT


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.
CLINICAL_EVENT_CD DOUBLE N Contains the associated clinical event
COLLECTED_DT_TM DATETIME Y Date n time at which the event when to this statusColumn
COLLECTED_ID DOUBLE N ID of the person who collectedthe tracking event.
COMNOTREW_DT_TM DATETIME Y Date n time at which the event when to this statusColumn
COMNOTREW_ID DOUBLE N ID of the person who collectedthe tracking event.Column
COMPLETE_DT_TM DATETIME Y Date and time the tracking event was completed.
COMPLETE_ID DOUBLE N ID of the person who completed the tracking event.
COMPLETE_ON_EXIT_IND DOUBLE Y Indicator used to identify that this event should be auto completed once the patient leaves.
EVENT_STATUS_CD DOUBLE N Code value used to identify if the event status is to be set to Request, Onset, Complete, or Hold.
INLAB_DT_TM DATETIME Y Date n time at which the event when to this statusColumn
INLAB_ID DOUBLE N ID of the person who inlab the tracking event.Column
ONSET_DT_TM DATETIME Y Date and time the tracking event was started.
ONSET_ID DOUBLE N ID of the person who started the tracking event.
REQUESTED_DT_TM DATETIME Y Date and time the tracking event was requested.
REQUESTED_ID DOUBLE N ID of the person who requested the tracking event.
TRACKING_EVENT_ID DOUBLE N Tracking Event Identifier used to associated a Tracking Event to a Tracking Item
TRACKING_GROUP_CD DOUBLE N Tracking Group Code used to identify which tracking group this patient is currently checked into.
TRACKING_ID DOUBLE N Tracking ItemColumn
TRACK_EVENT_ID DOUBLE N Tracking Event Assigned
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_EVENT


Child Column in TRACKING_EVENT(FK) Parent Table Name Parent Column Name
Parents: EVENT_STATUS_CD CODE_VALUE CODE_VALUE
TRACKING_GROUP_CD CODE_VALUE CODE_VALUE
TRACKING_ID TRACKING_ITEM TRACKING_ID
TRACK_EVENT_ID TRACK_EVENT TRACK_EVENT_ID




Parent Column in TRACKING_EVENT (PK) Child Table Name Child Column Name
Children: TRACKING_EVENT_ID RAD_TRACK_EVENT_DETAIL TRACKING_EVENT_ID
TRACKING_EVENT_HISTORY TRACKING_EVENT_ID
TRACKING_EVENT_ORD TRACKING_EVENT_ID
TRACKING_EVT_CMT TRACKING_EVENT_ID


TRACKING_EVENT_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Event History
Definition: THE Tracking Event History
Table Type: ACTIVITY





Column Detail - TRACKING_EVENT_HISTORY


Column Name Type Null? Definition
MODIFY_REASON VARCHAR(100) Y This field stores comment or reason why an instance of event is modified.
NEW_DT_TM DATETIME N corrected date and time of an event instance.
NEW_EVENT_STATUS_CD DOUBLE N corrected event status if modified. Otherwise will match the old_event_status_cd.
NEW_USER_ID DOUBLE N The user id if the person who set the event if modified otherwise will match old_user_id
OLD_DT_TM DATETIME Y Original date and time of an event instance
OLD_EVENT_STATUS_CD DOUBLE N Original status of the event instance.
OLD_USER_ID DOUBLE N The user_id of person who originally set the instance of the event.
TRACKING_EVENT_HISTORY_ID DOUBLE N Primary key of the table.
TRACKING_EVENT_ID DOUBLE N Key from tracking_event 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_EVENT_HISTORY


Child Column in TRACKING_EVENT_HISTORY(FK) Parent Table Name Parent Column Name
Parents: NEW_USER_ID PRSNL PERSON_ID
OLD_USER_ID PRSNL PERSON_ID
TRACKING_EVENT_ID TRACKING_EVENT TRACKING_EVENT_ID


TRACKING_EVENT_ORD



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACKING EVENT ORD
Definition: table is a activity table , define all the orders contributed to a tracking id
Table Type: ACTIVITY





Column Detail - TRACKING_EVENT_ORD


Column Name Type Null? Definition
ORDER_ID DOUBLE N Order id from orders tableColumn
TRACKING_EVENT_ID DOUBLE N Tracking event id from the tracking event table , this is activity dataColumn
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_EVENT_ORD


Child Column in TRACKING_EVENT_ORD(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
TRACKING_EVENT_ID TRACKING_EVENT TRACKING_EVENT_ID


TRACKING_EVT_CMT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Event Comment Table
Definition: Tracking table used to store the events comments that are associated with a tracking event.
Table Type: ACTIVITY





Column Detail - TRACKING_EVT_CMT


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.
EVT_COMMENT_SEQUENCE DOUBLE Y Sequence number associated with each Event Comment to identify the comment entry order.
EVT_COMMENT_TEXT LONGTEXT Y Actual Event Comment Text
EVT_COMMENT_TYPE_CD DOUBLE N Code used to identify what type of comment this is to be delivered as.
TRACKING_EVENT_ID DOUBLE N Tracking Event Identifier of the tracking event that is associated with a tracking item.
TRACKING_EVT_COMMENT_ID DOUBLE N Unique tracking event comment identifier used to define the tracking event comment.
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_EVT_CMT


Child Column in TRACKING_EVT_CMT(FK) Parent Table Name Parent Column Name
Parents: EVT_COMMENT_TYPE_CD CODE_VALUE CODE_VALUE
TRACKING_EVENT_ID TRACKING_EVENT TRACKING_EVENT_ID


TRACKING_HOLD



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACKING HOLD
Definition: Table used to hold a listing of all locations that are being held for a patient
Table Type: ACTIVITY





Column Detail - TRACKING_HOLD


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.
BED_STATUS_CD DOUBLE N Bed Status CodeColumn
HOLD_DT_TM DATETIME Y Hold Date and TimeColumn
HOLD_ID DOUBLE N Person ID of the user who set the hold status on this locationColumn
LOCATION_CD DOUBLE N Location being heldColumn
TRACKING_HOLD_COMMENT VARCHAR(200) Y Comment as to why the bed is being held.Column
TRACKING_HOLD_ID DOUBLE N Unique id used to define the relation between the tracking id and the locationColumn
TRACKING_ID DOUBLE N Tracking 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.



Relationship Detail - TRACKING_HOLD


Child Column in TRACKING_HOLD(FK) Parent Table Name Parent Column Name
Parents: BED_STATUS_CD CODE_VALUE CODE_VALUE
LOCATION_CD CODE_VALUE CODE_VALUE
HOLD_ID PRSNL PERSON_ID
TRACKING_ID TRACKING_ITEM TRACKING_ID