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 |