OWNER |
VARCHAR2(30) |
|
Owner of the task |
TASK_ID |
NUMBER |
NOT NULL |
Identifier of the task |
TASK_NAME |
VARCHAR2(30) |
|
Name of the task |
EXECUTION_START |
DATE |
|
Execution start date and time of the task |
EXECUTION_END |
DATE |
|
Execution end date and time of the task |
STATUS |
VARCHAR2(11) |
|
Current operational status of the task:
-
INITIAL - Initial state of the task; no recommendations are present
-
EXECUTING - Task is currently running
-
COMPLETED - Task successfully completed the analysis operation. Recommendation data can be viewed and reported.
-
INTERRUPTED - Task analysis was interrupted by the user. Recommendation data, if present, can be viewed and reported at this time.
-
CANCELLED
-
FATAL ERROR - A fatal error occurred during the analysis operation. All recommendation data is unusable.
|
STATUS_MESSAGE |
VARCHAR2(4000) |
|
Informational message provided by the advisor regarding the status |
PCT_COMPLETION_TIME |
NUMBER |
|
Percent completion, in terms of time, of the task when it is executing |
PROGRESS_METRIC |
NUMBER |
|
Metric that measures the progress of the task in terms of quality. Each advisor could have its own metric. |
METRIC_UNITS |
VARCHAR2(64) |
|
Unit of the metric used to measure progress |
ACTIVITY_COUNTER |
NUMBER |
|
Counter that is updated frequently by the advisor, denoting that useful work is being performed |
RECOMMENDATION_COUNT |
NUMBER |
|
Number of recommendations produced |
ERROR_MESSAGE |
VARCHAR2(4000) |
|
Informational message or an error message indicating the current operation or condition |