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 |