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 |