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 This column is for Oracle Internal use only. 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
CREATION_DATE TIMESTAMP Source Creation Date