Table Detail Report

TRACK_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking List configuation
Definition: Configuration data for Tracking List Views
Table Type: REFERENCE





Column Detail - TRACK_LIST


Column Name Type Null? Definition
BED_VIEW_CD DOUBLE N The list of beds to display in the tracking list
LIST_COLOR_NBR DOUBLE N Controls the color of the tab within FirstNet
LIST_DISPLAY_TXT VARCHAR(64) N The name of the tracking list that will be displayed to users
LIST_NAME VARCHAR(64) N Tracking List Name
LIST_TYPE_FLAG DOUBLE N Group List, Bed List, Pick List, etc.GROUP=1, BED=2, LOCATION=4, PROVIDER=8, CASE TRACKING = 16
LOCATION_CD DOUBLE N The nursing unit from which to show patients
LOCATION_VIEW_CD DOUBLE N The list of locations to which a patient can be moved.
REFRESH_INTERVAL DOUBLE N Seconds between auto refreshes
SCROLL_INTERVAL DOUBLE N Milliseconds between scrolling to the next row or page.
SOLUTION_FLAG DOUBLE N Enumeration that specifies for which solution this tracking list is valid
TRACK_GROUP_CD DOUBLE N Tracking Group Code
TRACK_LIST_ID DOUBLE N Primary Key
TRACK_VIEW_FIELD_LIST_ID DOUBLE N The list of fields to display in this tracking list
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 - TRACK_LIST


Child Column in TRACK_LIST(FK) Parent Table Name Parent Column Name
Parents: TRACK_VIEW_FIELD_LIST_ID TRACK_VIEW_FIELD_LIST TRACK_VIEW_FIELD_LIST_ID




Parent Column in TRACK_LIST (PK) Child Table Name Child Column Name
Children: TRACK_LIST_ID TRACK_LIST_ASSIGNMENT TRACK_LIST_ID
TRACK_LIST_FILTER_RELTN TRACK_LIST_ID
TRACK_LIST_PRSNL_RELTN TRACK_LIST_ID


TRACK_LIST_ASSIGNMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track List Assignment
Definition: Maintain list of assignments. One tracking list can be assigned to multiple positions or users.
Table Type: REFERENCE





Column Detail - TRACK_LIST_ASSIGNMENT


Column Name Type Null? Definition
LIST_SEQ DOUBLE N List Sequence
PARENT_ENTITY_ID DOUBLE N The position_cd or prsnl_id to which this list is being assigned.
PARENT_ENTITY_NAME VARCHAR(30) N Parent Entity Name which correlates with the entity id
TRACK_LIST_ASSIGNMENT_ID DOUBLE N Primary Key
TRACK_LIST_ID DOUBLE N The tracking list that is assigned Foreign Key value from TRACK_LIST.
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 - TRACK_LIST_ASSIGNMENT


Child Column in TRACK_LIST_ASSIGNMENT(FK) Parent Table Name Parent Column Name
Parents: TRACK_LIST_ID TRACK_LIST TRACK_LIST_ID


TRACK_LIST_FILTER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking List Filter Relation
Definition: Stores which tracking filters are available and defaulted for a tracking list.
Table Type: REFERENCE





Column Detail - TRACK_LIST_FILTER_RELTN


Column Name Type Null? Definition
DEFAULT_IND DOUBLE N 1 if filter is active upon initial loading of tracking list
TRACK_FILTER_ID DOUBLE N Foreign Key from TRACK_FILTER table
TRACK_LIST_FILTER_RELTN_ID DOUBLE N PRIMARY KEY
TRACK_LIST_ID DOUBLE N Foreign Key from TRACK_LIST 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 - TRACK_LIST_FILTER_RELTN


Child Column in TRACK_LIST_FILTER_RELTN(FK) Parent Table Name Parent Column Name
Parents: TRACK_FILTER_ID TRACK_FILTER TRACK_FILTER_ID
TRACK_LIST_ID TRACK_LIST TRACK_LIST_ID


TRACK_LIST_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACK_LIST PRSNL RELATIONSHIPS
Definition: Maintain Tracking List relationships added/removed by a User. This is a dynamic (real time) process.
Table Type: ACTIVITY





Column Detail - TRACK_LIST_PRSNL_RELTN


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N defines whether user has added or removed the trackinglist. 0 - user has removed the trackinglist. 1 - user has added the trackinglist assignment.
PRSNL_ID DOUBLE N This is the User Personnel ID. PERSON_ID from the PRSNL table.
TRACK_LIST_ID DOUBLE N Unique identifier for tracking list
TRACK_LIST_PRSNL_RELTN_ID DOUBLE N PRIMARY KEY
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 - TRACK_LIST_PRSNL_RELTN


Child Column in TRACK_LIST_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
TRACK_LIST_ID TRACK_LIST TRACK_LIST_ID


TRACK_LOCATION_PARAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Location Parameter Reference Table
Definition: Reference table used to store information related to tracking locations. This information is such that it will provide alerts and any location specific reference data.
Table Type: REFERENCE





Column Detail - TRACK_LOCATION_PARAM


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.
BASE_LOC_IND DOUBLE Y Flag to indicate that a tracking location can be a potential base location.
CRITICAL_COLOR VARCHAR(20) Y Critical ColorColumn
CRITICAL_ICON DOUBLE Y Critical IconColumn
CRITICAL_INTERVAL DOUBLE Y Critical IntervalColumn
LOCATION_CD DOUBLE N Location Code of the location that is to be checked.
NORMAL_COLOR CHAR(20) Y Normal Color of the locationColumn
OVERDUE_COLOR VARCHAR(20) Y Overdue ColorColumn
OVERDUE_ICON DOUBLE Y Overdue IconColumn
OVERDUE_INTERVAL DOUBLE Y Overdue IntervalColumn
TRACKING_REASON_DEF_CD DOUBLE N Tracking Reason Default Code
TRACKING_REASON_REQD_IND DOUBLE Y Tracking Reason Required Indicator
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.
UPD_BED_STATUS_IND DOUBLE N Update bed status indicator is used to determine whether or not we will automatically set bed statuses on non-base locations



Relationship Detail - TRACK_LOCATION_PARAM


Child Column in TRACK_LOCATION_PARAM(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD CODE_VALUE CODE_VALUE