Table Detail Report

TRACK_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Action
Definition: Holds individual actions that can be launched from toolbars, menus, columns, the depart process, or user actions.
Table Type: REFERENCE





Column Detail - TRACK_ACTION


Column Name Type Null? Definition
ACTION_ENUM DOUBLE N Identifies what the action will do.
ACTION_NAME VARCHAR(128) N Configured Display Name for the action
ACTION_SEQ DOUBLE N If this action is part of an action group, this specifies where in the group the action belongs.
BEHAVIOR_BIT_MAP DOUBLE N A bitmask that configures the way this action behaves.
ICON_ENUM DOUBLE N An idex to a FirstNet icon to display on this action. There could be hundreds of possible values.
PARENT_ENTITY_ID DOUBLE N Primary Key from the parent table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Specifies whether this action is part of a track_action_group or a direct child of a track_field_spec
TRACK_ACTION_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_ACTION




Parent Column in TRACK_ACTION (PK) Child Table Name Child Column Name
Children: TRACK_ACTION_ID TRACK_ACTION_REFINEMENT TRACK_ACTION_ID


TRACK_ACTION_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Action Group
Definition: Holds configurations for toolbars, menus, and other groups of actions that can be launched.
Table Type: REFERENCE





Column Detail - TRACK_ACTION_GROUP


Column Name Type Null? Definition
GROUP_NAME VARCHAR(128) N The configured name for this group of actions
GROUP_TYPE_FLAG DOUBLE N Indicates whether this group represents a toolbar, menu, etc.
LIST_TYPE_FLAG DOUBLE N Group List, Bed List, Pick List, etc.GROUP=1, BED=2, LOCATION=4, PROVIDER=8, CASE TRACKING = 16
TRACK_ACTION_GROUP_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_ACTION_GROUP




Parent Column in TRACK_ACTION_GROUP (PK) Child Table Name Child Column Name
Children: TRACK_ACTION_GROUP_ID TRACK_ACTION_GROUP_RELTN TRACK_ACTION_GROUP_ID


TRACK_ACTION_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Action Group Relation
Definition: Associates a group of actions to a tracking list or depart configuration.
Table Type: REFERENCE





Column Detail - TRACK_ACTION_GROUP_RELTN


Column Name Type Null? Definition
GROUP_TYPE_FLAG DOUBLE N Indicates whether this group represents a toolbar, menu, etc.0=TOOLBAR, 1=MENU, 2=DEPART PROCESS, 3=USER ACTIONS
PARENT_ENTITY_ID DOUBLE N The track_list_id, position_cd, prsnl_id, or tracking_ref_id that this action group is being assigned to.
PARENT_ENTITY_NAME VARCHAR(30) N Parent Entity Name for the group function
TRACK_ACTION_GROUP_ID DOUBLE N The action group that is associated
TRACK_ACTION_GROUP_RELTN_ID DOUBLE N PRIMAR 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_ACTION_GROUP_RELTN


Child Column in TRACK_ACTION_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: TRACK_ACTION_GROUP_ID TRACK_ACTION_GROUP TRACK_ACTION_GROUP_ID


TRACK_ACTION_LINK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Action Link
Definition: This table stores the Track Action Link Records.
Table Type: REFERENCE





Column Detail - TRACK_ACTION_LINK


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.
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 N 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.
FOLLOWUP_ACTION_STATUS DOUBLE N Similar to primary action status
FOLLOWUP_TRACK_COLLECTION_ID DOUBLE N Track_Collection_id from track_collection table
LINK_TYPE_CD DOUBLE N From code set 20321Ex: EVT_EVT_TRIG Defines the link type.
PRIMARY_ACTION_STATUS DOUBLE N Based on action_value if its an event it will have a status otherwise this field will be empty.
PRIMARY_TRACK_COLLECTION_ID DOUBLE N Track_collection_id from Track_collection table.
TRACKING_GROUP_CD DOUBLE N Tracking Group Code from code set 16370.
TRACK_ACTION_LINK_ID DOUBLE N Primary Key
TRIGGER_ALWAYS_IND DOUBLE N If Indicator is set then triggering happens all the time other wise only once.
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_ACTION_LINK


Child Column in TRACK_ACTION_LINK(FK) Parent Table Name Parent Column Name
Parents: FOLLOWUP_TRACK_COLLECTION_ID TRACK_COLLECTION TRACK_COLLECTION_ID
PRIMARY_TRACK_COLLECTION_ID TRACK_COLLECTION TRACK_COLLECTION_ID




Parent Column in TRACK_ACTION_LINK (PK) Child Table Name Child Column Name
Children: TRACK_ACTION_LINK_ID TRACK_ACTION_LINK_ACTIVITY TRACK_ACTION_LINK_ID


TRACK_ACTION_LINK_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Action Link Activity
Definition: This table stores the Tracking Action Link Activity Records.
Table Type: ACTIVITY





Column Detail - TRACK_ACTION_LINK_ACTIVITY


Column Name Type Null? Definition
LINKED_DT_TM DATETIME Y Linked Date and TimeColumn
TRACKING_ID DOUBLE N Foreign Key from Tracking_Item table
TRACK_ACTION_LINK_ACTIVITY_ID DOUBLE N Primary key of table
TRACK_ACTION_LINK_ID DOUBLE N Action Link Id from tracking_action_link table
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 - TRACK_ACTION_LINK_ACTIVITY


Child Column in TRACK_ACTION_LINK_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: TRACKING_ID TRACKING_ITEM TRACKING_ID
TRACK_ACTION_LINK_ID TRACK_ACTION_LINK TRACK_ACTION_LINK_ID