TASK_TREE table

TASK_TREE table

The TASK_TREE³ stores the master task IDs and the task tree structure information from Set System Security > Manage Views in ISIM Console.
Column Name Description Data type

PARENT The unique ID of the parent task. Character (500)

TASK_ID^* The unique ID of the task. Primary key. Character (500)

SEQUENCE_NO The sequence number of the task for ordering purpose. Numeric

ADMIN_ONLY The flag indicates whether the task is exposed from Set System Security > Manage Views in ISIM Console. Values include:
Y – not exposed and therefore not configurable.
N – exposed and configurable for each view.
Character (1)

^* Indicates the column is required and not null.
³ Indicates the table is added in ISIM 6.0.
Parent topic: Others

Column Name	Description	Data type
PARENT	The unique ID of the parent task.	Character (500)
TASK_ID^*	The unique ID of the task. Primary key.	Character (500)
SEQUENCE_NO	The sequence number of the task for ordering purpose.	Numeric
ADMIN_ONLY	The flag indicates whether the task is exposed from Set System Security > Manage Views in ISIM Console. Values include: Y – not exposed and therefore not configurable. N – exposed and configurable for each view.	Character (1)