Table Detail Report

TRACKING_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Personnel Table
Definition: Tracking table used to identify each provider assigned to a tracking group.
Table Type: ACTIVITY





Column Detail - TRACKING_PRSNL


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.
AVAILABILITY_IND DOUBLE Y An indicator used to define if the selected provider is available to assign to individual patients.
DEF_ENCNTR_PRSNL_R_CD DOUBLE N The default relation code to set as the default relationship for this provider.
DEF_LOCATION_CD DOUBLE N Default Location CodeColumn
DISPLAY_NAME VARCHAR(10) Y Provider display name (default set to the provider initials)Column
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REVIEW_IND DOUBLE Y Indicates the provider could review a result or not within the tracking list.Column
TRACKING_GROUP_CD DOUBLE N Tracking Group Code used to identify which tracking group this provider is associated with.
TRACKING_PRSNL_COLOR VARCHAR(20) Y Tracking Personnel ColorColumn
TRACKING_PRSNL_COMMENT LONGTEXT Y Tracking Personnel CommentColumn
TRACKING_PRSNL_ID DOUBLE N Tracking Personnel Identifier
TRACKING_PRSNL_TASK_ID DOUBLE N The associated provider task identifier from the tracking reference table. This identifier defines the task this provider is currently assigned to perform.
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_PRSNL


Child Column in TRACKING_PRSNL(FK) Parent Table Name Parent Column Name
Parents: DEF_ENCNTR_PRSNL_R_CD CODE_VALUE CODE_VALUE
TRACKING_GROUP_CD CODE_VALUE CODE_VALUE
PERSON_ID PRSNL PERSON_ID
TRACKING_PRSNL_TASK_ID TRACK_REFERENCE TRACKING_REF_ID




Parent Column in TRACKING_PRSNL (PK) Child Table Name Child Column Name
Children: TRACKING_PRSNL_ID TRACKING_PRSNL_REF TRACKING_PRSNL_ID


TRACKING_PRSNL_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Personnel Reference Table
Definition: Tracking table used to define assigned references such as teams to each tracking personnel provider.
Table Type: ACTIVITY





Column Detail - TRACKING_PRSNL_REF


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.
TRACKING_PRSNL_ID DOUBLE N Tracking identifier of the provider that this reference is to be associated with.
TRACKING_PRSNL_REF_ID DOUBLE N Tracking Personnel Reference Identifier
TRACKING_REF_ID DOUBLE N The associated tracking reference identifier used to define which team or other tracking reference is associated with this provider.
TRACKING_REF_TYPE_CD DOUBLE N Tracking Reference Type Code used to identify the type of tracking reference being defined. This field is provided to quickly access all tracking personnel references that are of a desired reference type.
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_PRSNL_REF


Child Column in TRACKING_PRSNL_REF(FK) Parent Table Name Parent Column Name
Parents: TRACKING_REF_TYPE_CD CODE_VALUE CODE_VALUE
TRACKING_PRSNL_ID TRACKING_PRSNL TRACKING_PRSNL_ID
TRACKING_REF_ID TRACK_REFERENCE TRACKING_REF_ID


TRACKING_PRV_RELN



Column Section Top of Page


Table-level Detail

Description: TRACKING PRV RELN
Definition: This table is used to store the new provider role assignments to a patient.
Table Type: ACTIVITY





Column Detail - TRACKING_PRV_RELN


Column Name Type Null? Definition
ASSIGN_DT_TM DATETIME N Date nTime at which this provider is assigned to the patient.
TRACKING_ID DOUBLE N Tracking id of the patient. this is internal number used to identify tracking.
TRACKING_PROVIDER_ID DOUBLE N person id of the provider
TRACKING_PRV_RELN_ID DOUBLE N Primary key which uniquely defines the row and is a internal number
UNASSIGN_DT_TM DATETIME N Date n time the Provider is unassigned from the patient.
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.


TRACKING_TAG



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACKING TAG
Definition: Table used to store the cross-reference between a tracking tag and a person
Table Type: ACTIVITY





Column Detail - TRACKING_TAG


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.
BATTERY_STATE DOUBLE Y Not used
BUTTON_STATE DOUBLE Y Not UsedColumn
DUP_HIT_IND DOUBLE Y Duplicate Hit IndicatorColumn
LAST_TRACKING_ID DOUBLE N The last tracking ID from TRACKING_ITEM to which this passive tracking badge was assigned.
MANUF_TAG VARCHAR(30) Y Manufacture TagColumn
MANUF_TYPE_CD DOUBLE N Manufacture Type Code set by CernerColumn
MIA_IND DOUBLE Y Missing in Action IndicatorColumn
TAG_IN_USE_IND DOUBLE Y Indicates whether or not a tag is in use.
TAG_TYPE_CD DOUBLE N Tag Type Code (Patient, Provider, or Equipment)Column
TRACKING_ID DOUBLE N Tracking IdentifierColumn
TRACKING_TAG_ID DOUBLE N Unique identifier used to define the tracking tagColumn
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_TAG


Child Column in TRACKING_TAG(FK) Parent Table Name Parent Column Name
Parents: MANUF_TYPE_CD CODE_VALUE CODE_VALUE
TAG_TYPE_CD CODE_VALUE CODE_VALUE
LAST_TRACKING_ID TRACKING_ITEM TRACKING_ID
TRACKING_ID TRACKING_ITEM TRACKING_ID


TRACKING_TEXT_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Text Map
Definition: Provides temporary mapping of unique string/date combination to long_text or long_blob row.
Table Type: ACTIVITY





Column Detail - TRACKING_TEXT_MAP


Column Name Type Null? Definition
LONG_TEXT_ID DOUBLE N ID of the row in LONG_TEXT table.
TEXT_DT_TM DATETIME Y used to map a date to a long_text or long_blob row
TEXT_KEY VARCHAR(100) Y used to map a string to a long_text or long_blob row
TRACKING_TEXT_MAP_ID DOUBLE N Primary Key
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - TRACKING_TEXT_MAP


Child Column in TRACKING_TEXT_MAP(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID