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 |