Table Detail Report

WORKFLOW_TASK_QUEUE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workflow Task Queue History
Definition: Stores historical information from the WORKFLOW_TASK_QUEUE table.
Table Type: ACTIVITY





Column Detail - WORKFLOW_TASK_QUEUE_HIST


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ENTITY_ID DOUBLE Y Uniquely identifies the related Entity
ENTITY_NAME VARCHAR(30) Y Identifies the Name of the related Entity.
PRIORITY_SEQ DOUBLE N The priority sequence for all the rows. The numbering will be from 1 to 3 to determine the priority of the row.
PROCESS_DT_TM DATETIME N The date/time that the ETL process was started.
QUEUE_STATUS_CD DOUBLE N Dsiplays the status of the task queue item.
REPLY_LONG_TEXT_ID DOUBLE N Identifies the long text row in which the processing reply is stored.
REPLY_WF_TASK_QUEUE_LT_ID DOUBLE N Identifies the workflow task queue long text row in which the reply to be processed is stored.
REQUEST_LONG_TEXT_ID DOUBLE N Identifies the long text row in which the request to be processed is stored.
REQ_WF_TASK_QUEUE_LT_ID DOUBLE N Identifies the workflow task queue long text row in which the requst to be processed is stored.
RETRY_CNT DOUBLE N Counter that increments every time an attempt to process fails.
TASK_DATA_TXT VARCHAR(100) Y Data further describing the task.
TASK_IDENT VARCHAR(250) N Identifies which task is queued for processing.
TIMER_DELTA_VALUE DOUBLE Y Contains the execution time taken by each status of task.
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.
WORKFLOW_TASK_QUEUE_HIST_ID DOUBLE N Unique generated number that identifies a single row on the WORKFLOW_TASK_QUEUE_HIST table.
WORKFLOW_TASK_QUEUE_ID DOUBLE N Uniquley identifies the related WORKFLOW_TASK_QUEUE record.



Relationship Detail - WORKFLOW_TASK_QUEUE_HIST


Child Column in WORKFLOW_TASK_QUEUE_HIST(FK) Parent Table Name Parent Column Name
Parents: REPLY_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
REQUEST_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
REPLY_WF_TASK_QUEUE_LT_ID WORKFLOW_TASK_QUEUE_LT WORKFLOW_TASK_QUEUE_LT_ID
REQ_WF_TASK_QUEUE_LT_ID WORKFLOW_TASK_QUEUE_LT WORKFLOW_TASK_QUEUE_LT_ID




Parent Column in WORKFLOW_TASK_QUEUE_HIST (PK) Child Table Name Child Column Name
Children: WORKFLOW_TASK_QUEUE_HIST_ID WORKFLOW_TASK_QUEUE_LT WORKFLOW_TASK_QUEUE_HIST_ID


WORKFLOW_TASK_QUEUE_LT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workflow Task Queue Long Text
Definition: Contains long text data for requests and replies for workflow task processing
Table Type: ACTIVITY





Column Detail - WORKFLOW_TASK_QUEUE_LT


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LONG_TEXT LONGTEXT Y Used to store the text related to the workflow_task_queue_hist row.
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.
WORKFLOW_TASK_QUEUE_HIST_ID DOUBLE N Uniquely identifes the related row on the workfow_task_queue_hist table.
WORKFLOW_TASK_QUEUE_LT_ID DOUBLE N Unique generated number that identifies a single row on the WORKFLOW_TASK_QUEUE_LT TABLE.



Relationship Detail - WORKFLOW_TASK_QUEUE_LT


Child Column in WORKFLOW_TASK_QUEUE_LT(FK) Parent Table Name Parent Column Name
Parents: WORKFLOW_TASK_QUEUE_HIST_ID WORKFLOW_TASK_QUEUE_HIST WORKFLOW_TASK_QUEUE_HIST_ID




Parent Column in WORKFLOW_TASK_QUEUE_LT (PK) Child Table Name Child Column Name
Children: WORKFLOW_TASK_QUEUE_LT_ID WORKFLOW_TASK_QUEUE REPLY_WF_TASK_QUEUE_LT_ID
WORKFLOW_TASK_QUEUE REQ_WF_TASK_QUEUE_LT_ID
WORKFLOW_TASK_QUEUE_HIST REPLY_WF_TASK_QUEUE_LT_ID
WORKFLOW_TASK_QUEUE_HIST REQ_WF_TASK_QUEUE_LT_ID


WORK_ITEM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Work Item Relationship
Definition: This table is used to store and maintain work item relationships.
Table Type: REFERENCE





Column Detail - WORK_ITEM_RELTN


Column Name Type Null? Definition
ACTION_CD DOUBLE N The action that relates the entities.
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_DT_TM DATETIME N The date and time that the active_status_cd was set.
CHILD_PFT_WF_ISSUE_ID DOUBLE N Identifies the related child work item in this relationship.
PARENT_PFT_WF_ISSUE_ID DOUBLE N Identifies the related parent work item in this relationship.
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.
WORK_ITEM_RELTN_ID DOUBLE N Uniquely identifies a relationship between two workflow issue items based on the related action.



Relationship Detail - WORK_ITEM_RELTN


Child Column in WORK_ITEM_RELTN(FK) Parent Table Name Parent Column Name
Parents: CHILD_PFT_WF_ISSUE_ID PFT_WF_ISSUE PFT_WF_ISSUE_ID
PARENT_PFT_WF_ISSUE_ID PFT_WF_ISSUE PFT_WF_ISSUE_ID