Table Detail Report

TRACK_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Event Reference Table
Definition: Reference table used to define the various tracking events each tracking group would like to be able to track.
Table Type: REFERENCE





Column Detail - TRACK_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.
AUTO_COMPLETE_IND DOUBLE Y An indicator whether this event should automatically go to a 'complete' status.
AUTO_START_IND DOUBLE Y An indicator whether this event should automatically go to a 'start' status.
CLINIC_EVENT_CD DOUBLE N Clinical event codesColumn
COMPLETE_COLOR_NUM DOUBLE N The color of the event in the requested state
COMPLETE_ICON_ID DOUBLE N The icon id for the completed state of the event
COMPLETE_ON_EXIT_IND DOUBLE Y An indicator on whether this event should be 'completed' if the tracking item is moved out of the current location.
CRITICAL_BLINK_IND DOUBLE Y Critical Blink IndicatorColumn
CRITICAL_COLOR VARCHAR(20) Y Critical ColorColumn
CRITICAL_ICON DOUBLE Y Critical IconColumn
CRITICAL_INTERVAL DOUBLE Y Critical IntervalColumn
DEF_BEGIN_LOC_CD DOUBLE N Location where to automatically move the patient once this event has started. This is the default location an can be reset if desired or will not be set if the tracking item is already in a bed.
DEF_NEXT_EVENT_ID DOUBLE N The next event to set as the default event once this event status is set to 'complete'.
DEF_PREVIOUS_EVENT_ID DOUBLE N The set of events to complete once this event status is set to 'request'.
DEF_REQUEST_LOC_CD DOUBLE N Location where to automatically move the patient once this event has been requested. This is the default location an can be reset if desired or will not be set if the tracking item is already in a bed.
DESCRIPTION VARCHAR(100) Y Description of the Tracking Reference Item.
DISPLAY VARCHAR(20) Y Display description
DISPLAY_KEY VARCHAR(50) Y Display Key generated from the Display field (All Uppercase, No Spaces or Special Characters).
EVENT_PRIORITY_RANK DOUBLE Y Priority rank to set as the default rank once this event is selected. This rank should also be used to set the location specific priority rank.
EVENT_USE_MEAN_CD DOUBLE N Tracking event meaning.
EXEC_NEXT_EVENT_IND DOUBLE N Contains next event preference. An indicator that the next event is available.
FINAL_TRANSACTION_IND DOUBLE Y An indicator on whether this event should close the tracking of this item.
FLEX_LOCATION_CD DOUBLE N Location code to allow the users to build different events for different locations. This field identifies what location this event is for.
HIDE_EVENT_IND DOUBLE Y means a auto trigger eventColumn
NORMAL_COLOR VARCHAR(20) Y Normal Event Color
NORMAL_ICON DOUBLE Y Normal Event Icon
OVERDUE_BLINK_IND DOUBLE Y Overdue Blink IndicatorColumn
OVERDUE_COLOR VARCHAR(20) Y Overdue ColorColumn
OVERDUE_ICON DOUBLE Y Overdue IconColumn
OVERDUE_INTERVAL DOUBLE Y Overdue IntervalColumn
REQUEST_COLOR_NUM DOUBLE N The color of the event in the requested state
REQUEST_ICON_ID DOUBLE N The icon id for the requested state of the event
SEQUENCE_NUM DOUBLE N Display order sequence of the events when the events are set at the same time.
SHOW_ON_MONITOR_IND DOUBLE Y An indicator on whether this event should be shown on the monitor.
SINGLE_STATE_IND DOUBLE N Whether the event is set with single or multiple states
SINGLE_USE_IND DOUBLE N Indicates if the event can be set multiple times or just once.
STAGE_CD DOUBLE N The code of the staging area the track event is mapped to.
START_COLOR_NUM DOUBLE N The color of the event in the started state
START_ICON_ID DOUBLE N The icon id for the started state of the event
TRACKING_EVENT_TYPE_CD DOUBLE N Value to define what type of event this is.
TRACKING_GROUP_CD DOUBLE N Tracking Group Code used to identify which tracking group this reference is currently associated with.
TRACK_EVENT_ID DOUBLE N Tracking Event Identifier
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_EVENT


Child Column in TRACK_EVENT(FK) Parent Table Name Parent Column Name
Parents: DEF_BEGIN_LOC_CD CODE_VALUE CODE_VALUE
DEF_REQUEST_LOC_CD CODE_VALUE CODE_VALUE
EVENT_USE_MEAN_CD CODE_VALUE CODE_VALUE
FLEX_LOCATION_CD CODE_VALUE CODE_VALUE
TRACKING_GROUP_CD CODE_VALUE CODE_VALUE
COMPLETE_ICON_ID SA_REF_ICON SA_REF_ICON_ID
REQUEST_ICON_ID SA_REF_ICON SA_REF_ICON_ID
START_ICON_ID SA_REF_ICON SA_REF_ICON_ID
DEF_NEXT_EVENT_ID TRACK_COLLECTION TRACK_COLLECTION_ID
DEF_PREVIOUS_EVENT_ID TRACK_COLLECTION TRACK_COLLECTION_ID




Parent Column in TRACK_EVENT (PK) Child Table Name Child Column Name
Children: TRACK_EVENT_ID SN_TRACK_EVENT_RELTN TRACK_EVENT_ID
TRACKING_EVENT TRACK_EVENT_ID


TRACK_FIELD_SPEC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Field Specification
Definition: Reference data describing a field of tracking data
Table Type: REFERENCE





Column Detail - TRACK_FIELD_SPEC


Column Name Type Null? Definition
ALIGNMENT_FLAG DOUBLE N Alignment Flag. 0= LEFT, 1= CENTER, 2= RIGHT
ASCENDING_IND DOUBLE N If SORTING_SEQ is non-negative, this field indicates whether sorting should be ascending or descending
BEHAVIOR_BIT_MAP DOUBLE N A bitmask that configures the way this field will behave.
DISPLAY_TXT VARCHAR(64) N Field Display
DISPLAY_WIDTH DOUBLE N Width in pixels available for this field
FIELD_ENUM DOUBLE N Defines what type of field this is. a unique number on the front end that defines what type of field this is. Both field_enum and interaction_enum are extensible concepts, in that we can add new implementations at any time.
FIELD_SEQ DOUBLE N The order of this field in the field list. Can be -1 if this field is for sorting only, not for display
INTERACTION_ENUM DOUBLE N Defines what type of Interaction this is. a unique number on the front end that defines the Interaction. Both field_enum and interaction_enum are extensible concepts, in that we can add new implementations at any time.
READ_ONLY_IND DOUBLE N Indicates whether a column on the front end is to be a Read Only column. A 0 means the column is not read only (default). A 1 would indicate that the column should be read only.
SORTING_SEQ DOUBLE N The order in which this field will be sorted. Can be -1 if this field is not sorted upon.
TRACK_FIELD_SPEC_ID DOUBLE N Primary Key
TRACK_VIEW_FIELD_LIST_ID DOUBLE N Foreign Key from TRACK_VIEW_FIELD_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.
WRAP_IND DOUBLE N Wrap Indicator - default is 0. 1 = if the text field should wrap to fit the column width.



Relationship Detail - TRACK_FIELD_SPEC


Child Column in TRACK_FIELD_SPEC(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_FIELD_SPEC (PK) Child Table Name Child Column Name
Children: TRACK_FIELD_SPEC_ID TRACK_FIELD_SPEC_BEHAVIOR TRACK_FIELD_SPEC_ID
TRACK_FIELD_SPEC_REFINEMENT TRACK_FIELD_SPEC_ID


TRACK_FIELD_SPEC_BEHAVIOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Field Specification Behavior
Definition: Reference data that describes the behavior of tracking fields.
Table Type: REFERENCE





Column Detail - TRACK_FIELD_SPEC_BEHAVIOR


Column Name Type Null? Definition
BEHAVIOR_NAME VARCHAR(64) N Describes which field behavior is being defined
BEHAVIOR_VALUE_TXT VARCHAR(255) N Describes the desired behavior of the field
PARENT_ENTITY_ID DOUBLE N Key from another table that describes the behavior of this field
PARENT_ENTITY_NAME VARCHAR(30) N Table name
TRACK_FIELD_SPEC_BEHAVIOR_ID DOUBLE N Primary Key
TRACK_FIELD_SPEC_ID DOUBLE N Foreign Key value from TRACK_FIELD_SPEC 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_FIELD_SPEC_BEHAVIOR


Child Column in TRACK_FIELD_SPEC_BEHAVIOR(FK) Parent Table Name Parent Column Name
Parents: TRACK_FIELD_SPEC_ID TRACK_FIELD_SPEC TRACK_FIELD_SPEC_ID


TRACK_FIELD_SPEC_REFINEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking field specification requirement
Definition: Reference data that describes custom tracking fields.
Table Type: REFERENCE





Column Detail - TRACK_FIELD_SPEC_REFINEMENT


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N ID value from the parent table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N NAME OF THE PARENT ENTITY
REFINEMENT_CONTENT VARCHAR(255) N Refinement Value CONTENT
REFINEMENT_NAME VARCHAR(64) N Field Spec refinement name
TRACK_FIELD_SPEC_ID DOUBLE N FK FROM THE TRACK_FIELD_SPEC table
TRACK_FIELD_SPEC_REFINEMENT_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_FIELD_SPEC_REFINEMENT


Child Column in TRACK_FIELD_SPEC_REFINEMENT(FK) Parent Table Name Parent Column Name
Parents: TRACK_FIELD_SPEC_ID TRACK_FIELD_SPEC TRACK_FIELD_SPEC_ID


TRACK_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACK FILTER
Definition: Stores tracking filter configurations
Table Type: REFERENCE





Column Detail - TRACK_FILTER


Column Name Type Null? Definition
AND_IND DOUBLE N Indicates that this filter is the intersection of two child filters.
FIELD_ENUM DOUBLE N If FILTER_TYPE_FLAG is 0 (FIELD), this will specify which tracking field is being filtered on.
FILTER_NAME VARCHAR(64) N A unique name for the filter describing its function.
FILTER_TYPE_FLAG DOUBLE N Filter Type. FIELD = 1, ADMITTED = 2, DISCHARGED = 3, CHECKED OUT = 4, CHECKED IN = 5, ENCOUNTER = 6, PREARRIVAL = 7, MY PATIENTS = 8, SURGINET CASE = 8, SURGINET EVENT = 10, SURGINET OP. ROOM = 11, SURGINET FIELD = 12, SURGINET ANTICIPATED DURING = 13
LIST_TYPE_FLAG DOUBLE N List Type. NOT SPECIFIED = 0, GROUP LIST = 1, BED LIST = 2, LOCATION LIST = 4, PROVIDER LIST = 8, CASE TRACKING LIST = 16
NOT_IND DOUBLE N Indicates that the result of this filter will be negated.
OR_IND DOUBLE N Indicates that this filter is the union of two child filters.
PARENT_TRACK_FILTER_ID DOUBLE N TRACK_FILTER_ID of parent filter. This creates a hierarchy of relationships of rows.
TRACK_FILTER_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_FILTER


Child Column in TRACK_FILTER(FK) Parent Table Name Parent Column Name
Parents: PARENT_TRACK_FILTER_ID TRACK_FILTER TRACK_FILTER_ID




Parent Column in TRACK_FILTER (PK) Child Table Name Child Column Name
Children: TRACK_FILTER_ID TRACK_FILTER PARENT_TRACK_FILTER_ID
TRACK_FILTER_REFINEMENT TRACK_FILTER_ID
TRACK_FILTER_VALUE TRACK_FILTER_ID
TRACK_LIST_FILTER_RELTN TRACK_FILTER_ID