HomeArticlesSlideshowsAsk BobLogin or Register
NewsCustom SearchContactLinks
SIMPLETASK API REFERENCE - Views
HEAP WORKFLOW
14-Aug-2013
Passive API of SIMPLETASK are solved as a set of views. Most of the views are related to particular tables enriched by useful columns.
See: SIMPLETASK API REFERENCE - Package BWTA_METADATA
See: SIMPLETASK API REFERENCE - Package BWTA_OPER

BWTA_V_ERR View to Error failover definition
ID VARCHAR2(9) Oracle error code number (e.g. -1555 for ORA-01555)
ATMPT_CNT NUMBER Number of allowed attempts
DELAY_MIN NUMBER Delay between attempts in minutes
PROLONG_KOEF NUMBER Koefficient of prolong of repeated attempts
DIVERS_MOD NUMBER Mode of diversification of delay period
BWTA_V_HEAP View to Heaps including statistics of current run
HEAP_SEQ NUMBER Sequence key of Heap
HEAP_ID VARCHAR2(100) Identifier of Heap
HEAP_NOTE VARCHAR2(500) Description of Heap
EFFECTIVE_DATE DATE Effective date of current run (round)
START_DT DATE Start date of current run
END_DT DATE End date of current run
TASKS_CNT NUMBER Total number of tasks in heap
DONE_CNT NUMBER Number of tasks in the state DONE in current run
WAIT_CNT NUMBER Number of tasks in the state WAIT in current run includes tasks in the initial state (no state) too
ACTIVE_CNT NUMBER Number of tasks in the state ACTIVE in current run
SUSPEND_CNT NUMBER Number of tasks in the state SUSPEND in current run
ERROR_CNT NUMBER Number of tasks in the state ERROR in current run
SKIP_CNT NUMBER Number of tasks in the state SKIP in current run
BWTA_V_LOG_ERR View of Failovers in realized runs (rounds) allows statistics of failover utilization
ROUND_SEQ NUMBER Sequence key of Round when failover happened
TASK_SEQ NUMBER Sequence key of failed Task
TASK_ID VARCHAR2(100) Identifier of failed Task
HEAP_SEQ NUMBER Sequence key of Heap
HEAP_ID VARCHAR2(100) Identifier of Heap
ERR_ID NUMBER Error code
DT TIMESTAMP(6) Date and time when it happened
BWTA_V_LOG_HEAP View of Heap last ( or current ) run including end of process estimation
HEAP_SEQ NUMBER Sequence key of Heap
HEAP_ID VARCHAR2(100) Identifier of Heap
HEAP_NOTE VARCHAR2(500) Description of Heap
EFFECTIVE_DATE DATE Effective date of last (current) run
START_DT DATE Start date and time of the run
END_DT DATE End date and time of the run
TASKS_CNT NUMBER Total number of tasks in the heap
DONE_CNT NUMBER Number of task in the heap in the current state DONE
WAIT_CNT NUMBER Number of task in the heap in the current state WAIT or in initial state (no state)
ACTIVE_CNT NUMBER Number of task in the heap in the current state ACTIVE
SUSPEND_CNT NUMBER Number of task in the heap in the current state SUSPEND
ERROR_CNT NUMBER Number of task in the heap in the current state ERROR
SKIP_CNT NUMBER Number of task in the heap in the current state SKIP
HEAP_END_ESTIMATION DATE Estimated end of the heap execution
BWTA_V_LOG_ROUND View of Log of Rounds (runs)
ROUND_SEQ NUMBER Sequence key of round
HEAP_SEQ NUMBER Heap the round is associated to - sequence key
HEAP_ID VARCHAR2(100) Heap the round is associated to - identifier
EFFECTIVE_DATE DATE Effective date of round
START_DT DATE Start date time of round
END_DT DATE End date time of round
BWTA_V_LOG_TASK View of task runs
TASK_SEQ NUMBER Sequence key of task
TASK_ID VARCHAR2(100) Identifier of task
HEAP_SEQ NUMBER Sequence key of Heap the task belongs to
HEAP_ID VARCHAR2(100) Identifier of Heap the task belongs to
EFFECTIVE_DATE DATE Effective date of round
ROUND_SEQ NUMBER Sequence key of round of the run
STATUS VARCHAR2(10) Final status of the run
START_DT DATE Start datetime
END_DT DATE End datetime
MINUTES NUMBER Minutes of run
ERROR_MSG VARCHAR2(4000) Error message in the case of error of message related to Suspend or Wait
BWTA_V_LOG_TASK_ACTIVE View of active tasks and their run current state
TASK_SEQ NUMBER Sequence key of task
TASK_ID VARCHAR2(100) Identifier of task
TASK_NOTE VARCHAR2(500) Description of task
TASK_PRIORITY NUMBER Priority of task
HEAP_SEQ NUMBER Sequence key of Heap the task belongs to
HEAP_ID VARCHAR2(100) Identifier of Heap the task belongs to
ROUND_SEQ NUMBER Sequence of active round
EFFECTIVE_DATE DATE Effective date of active round
STATUS VARCHAR2(10) Current status of task run
START_DT DATE Start date and time
APPROX_END_DT DATE End date and time
BWTA_V_LOG_TASK_H View of log of task runs including details of the status changes of the task round
TASK_SEQ NUMBER Sequence key of Task
TASK_ID VARCHAR2(100) Identifier of Task
HEAP_SEQ NUMBER Sequence key of Heap
HEAP_ID VARCHAR2(100) Identifier of Heap
EFFECTIVE_DATE DATE Effective date of round
ROUND_SEQ NUMBER Sequence of round
STATUS VARCHAR2(10) Status at the moment
START_DT DATE Start datetime
END_DT DATE End datetime
MINUTES NUMBER Minutes between end and start
ERROR_MSG VARCHAR2(4000) Error or auxiliary message
TS TIMESTAMP(6) Timestamp of the state snap
BWTA_V_LOG_TASK_TBD View of tasks in the state requiring attention of operator, that covers states of Errors, suspended or waiting tasks and tasks requiring manual action
TASK_SEQ NUMBER Sequence key of the task
TASK_ID VARCHAR2(100) Identifier of Task
TASK_NOTE VARCHAR2(500) Description of Task
TASK_PRIORITY NUMBER Priority of Task
HEAP_SEQ NUMBER Sequence key of the task Heap
HEAP_ID VARCHAR2(100) Identifier of the task Heap
ROUND_SEQ NUMBER Sequence key of Round
EFFECTIVE_DATE DATE Effective date of current round
STATUS VARCHAR2(10) Current status of the Task
START_DT DATE Start datetime
END_DT DATE End datetime
ERROR_MSG VARCHAR2(4000) Error or auxiliary message
BWTA_V_LOG_TASK_WIDE View of all the possible characteristics of Task run showing all the states of current or last task execution
TASK_SEQ NUMBER Sequence key of the task
TASK_ID VARCHAR2(100) Identifier of the task
TASK_NOTE VARCHAR2(500) Description of the task
TASK_PRIORITY NUMBER Prioerity of the task
HEAP_SEQ NUMBER Sequence key of the task Heap
HEAP_ID VARCHAR2(100) Identifier of the task Heap
ROUND_SEQ NUMBER Sequence key of last or current round
EFFECTIVE_DATE DATE Effective date of last or current round
ROUND_STATUS VARCHAR2(8) Final or current status of round
STATUS VARCHAR2(10) Final or current status of task
START_DT DATE Start datetime
END_DT DATE End datetime
MINUTES NUMBER Minutes between the end and start
AVG_MINUTES NUMBER Average minutes of task executions in the past
ERROR_MSG VARCHAR2(4000) Error or auxiliary message
PREDECESSOR_TASKS VARCHAR2(4000) List of predecessor tasks
BLOCKING_TASKS VARCHAR2(4000) List of still blocking predecessor tasks
RESOURCES VARCHAR2(4000) List of resources
TASK_EXEC_COND VARCHAR2(2000) Execution condition of the task
TASK_EXEC_FLAG NUMBER Execution flag of the task
TASK_SKIP_COND VARCHAR2(2000) Skip condition of the task
TASK_SKIP_FLAG NUMBER Skip flag of the task
TASK_EXEC_CODE VARCHAR2(2000) Execution code
START_DT_ESTIMATION DATE Estimation of start datetime of not ran yet tasks
BWTA_V_LOG_THREAD View of current runtime threads and their states
HEAP_ID VARCHAR2(100) Identifire to the Heap associated
HEAP_SEQ NUMBER Sequence key of the Heap associated
THREAD_SEQ NUMBER Sequence key of the Thread
ROUND_SEQ NUMBER Sequence key of the Round associated
STATUS VARCHAR2(10) Status of the thread
TASK_SEQ NUMBER Sequence key of the task if there is any just processed
TASK_ID VARCHAR2(100) Identifier of the task if there is any just processed
START_DT DATE Start datetime of the thread
COMMAND VARCHAR2(100) Command sent to the thread influencing it's next activity (e.g. STOP)
ERROR_MSG VARCHAR2(2000) Error message related to teh thread job execution
BWTA_V_RES View to Resource definition
RES_SEQ NUMBER Sequence key of the Resource
RES_ID VARCHAR2(100) Identifier of the Resource
RES_NOTE VARCHAR2(500) Description
RES_AMOUNT NUMBER Available amount of the Resource
RES_PENDING_FLAG NUMBER(1) Flag of Pending (persistent) resource
TASK_CNT NUMBER Number of Tasks consuming the resource by definition
BWTA_V_RES_USAGE View to resource definition enhanced by it's usage information useful for the required amount control
RES_SEQ NUMBER Sequence key of Resource
RES_ID VARCHAR2(100) Identifier of Resource
RES_NOTE VARCHAR2(500) Description
RES_AMOUNT NUMBER Available amount of the Resource
RES_PENDING_FLAG NUMBER(1) Flag of Pending (persistent) resource
USED_AMOUNT NUMBER Currently used amount of the Resource
USED_PCT NUMBER Percentage of current Resource usage
HEAP_ID VARCHAR2(100) Identifier of consuming Heap
TASK_ID VARCHAR2(100) Identifier of consuming task
TASK_USED_AMOUNT NUMBER Amount of the resource consumed just by the certain task
BWTA_V_TASK View to Task definition
TASK_SEQ NUMBER Sequence key of Task
TASK_ID VARCHAR2(100) Identifier of Task
TASK_NOTE VARCHAR2(500) Description of Task
TASK_PRIORITY NUMBER Priority of Task
HEAP_SEQ NUMBER Sequence key of the Heap
HEAP_ID VARCHAR2(100) Identifier of the Heap
AVG_MINUTES NUMBER Average duration of execution in minutes
PREDECESSOR_TASKS VARCHAR2(4000) List of predecessor tasks
RESOURCES VARCHAR2(4000) List of Resources
TASK_EXEC_COND VARCHAR2(2000) Execution condition of the Task
TASK_EXEC_FLAG NUMBER Execution flag of the Task
TASK_SKIP_COND VARCHAR2(2000) Skip condition of the Task
TASK_SKIP_FLAG NUMBER Skip flag of the Task
TASK_EXEC_CODE VARCHAR2(2000) Execution code specification of the task
BWTA_V_TASK_REL Vew to Relationship of two tasks showing predecessors
TASK_SEQ_1 NUMBER Heap of the successor task
TASK_ID_1 VARCHAR2(100) Successor task id
HEAP_SEQ_1 NUMBER Successor task sequence
TASK_SEQ_2 NUMBER Predecessor task sequence
TASK_ID_2 VARCHAR2(100) Predecessor task identifier
HEAP_SEQ_2 NUMBER Heap of the predecessor task
SKIP_FLAG NUMBER(1) Skip flag of the dependency to suppress it
BWTA_V_TASK_REL_CYCLIC View to cyclic fragments of graph used to alert round dependencies
PTH VARCHAR2(4000) Path of the cycle
BWTA_V_TASK_RES View to Resource consumption by tasks
TASK_SEQ NUMBER Sequence key of Task
TASK_ID VARCHAR2(100) Identifier of Task
HEAP_SEQ NUMBER Sequence key of the Heap
RES_SEQ NUMBER Sequence key of consumed Resource
RES_ID VARCHAR2(100) Identifier of consumed Resource
AMOUNT NUMBER Consumed amount of the resource
OF_AMOUNT NUMBER Available amount of the resource

Ludek Bob Jankovsky
All Right Reserved © 2007, Designed by Bob Jankovsky