DW_JRNY_ALLOCATED_TASK_F

This table stores details of all allocated tasks

Details

Module:

Key Columns

ALLOCATED_TASK_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ALLOCATED_TASK_ID NUMBER 38 0 True Allocated Task identifier    
SOURCE_RECORD_ID VARCHAR2 64     unique identifier for internal purpose    
ALLOCATED_CHECKLIST_ID NUMBER 38 0   Identifier of the allocated checklist to which the task belongs    
PERFORMER_PERSON_ID NUMBER 38 0   Person Id for the Performer of the task    
TASK_OWNER_PERSON_ID NUMBER 38 0   PersonId for the Owner of the task    
ENTERPRISE_ID NUMBER 38 0   Identifier of Enterprise    
DETAIL_ALLOC_CHECKLIST_ID NUMBER 38 0   Detailed allocated checklist Identifier    
DOCUMENT_TYPE_ID NUMBER 38 0   Document Type Identifier    
MANDATORY_FLAG VARCHAR2 32     Indicates whether the task is mandatory to be completed    
STATUS VARCHAR2 64     The status of the task.    
TASK_SEQUENCE NUMBER 38 0   Obsolete.    
TASK_TYPE VARCHAR2 32     Type of action    
TARGET_DURATION NUMBER 38 0   Task expiration duration    
TARGET_DURATION_UOM VARCHAR2 32     Task expiration duration unit of measure.    
REPORT_PATH VARCHAR2 999     It contains the BI Publisher report folder path    
ESIGN_TYPE VARCHAR2 32     Esignature Type    
PERFORMER_RESP_AVAILABILITY VARCHAR2 32     Indicates performer availability of selected performer type    
PERFORMER_RESP_TYPE VARCHAR2 32     Performer responsibility type    
OWNER_RESP_TYPE VARCHAR2 32     Owner responsibility type    
TARGET_START_DATE DATE       Target Start Date for the task    
TARGET_END_DATE DATE       Target End Date for the task    
ACTUAL_START_DATE DATE       Actual Start Date for the task    
ACTUAL_END_DATE DATE       Actual End Date for the task    
REOPEN_DATE DATE       Specifies Task Reopen Date    
SIGN_DATE DATE       Signature date    
DEPENDENT_ON_TASKS VARCHAR2 999     Task on which the current task is dependent on.Although this column holds single value currently, in future there is a possibility that it may store comma separated list of values    

Copyright © 2019, 2022, Oracle and/or its affiliates.