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 |