Appendix A - Table Names
List of tables in Remedy used by the Task Engine
Table Names and Descriptions
KS_TSK_Category
- Stores the category values configured on the Task Admin Console. These are the categories seen in the Task Builder.
KS_TSK_CUSTSRV_TaskInstance_join
- Join of the KS_TSK_Task and KS_TSK_Instance forms
KS_TSK_CUSTSRV_TaskInstance_Msg_join
- Join of the KS_TSK_CUSTSRV_TaskInstance_join and KS_TSK_Instance_Messages forms
KS_TSK_Def
Contains one entry for each task handler written
- The primary component is an XML document (stored in a Remedy field) that defines the following:
- The questions that appear during task node configuration in the task builder
- The parameters passed to the handler code
- The field mappings between Kinetic and your destination form/application
KS_TSK_Def_Info
- Contains entries related to the entry in the TSK_Def form.
- These entries define login parameters used by the task handler.
KS_TSK_Exception_Handler
- Error situations caught by the Task Engine are written here.
KS_TSK_Instance
- Task Engine processing creates entries in this form
- There will be an entry in this form for each task node configured within the tree
- Entries here can be seen with a Work in Progress status when the task node is configured as deferred. When the next trigger comes along, the task engine will change this status to closed.
KS_TSK_Instance_Messages
- These entries will be created by the Task Engine based on configuration done on the Node element.
- Often used as an area to collect work info data from Incident or Change Request
- Useful for displaying nformation on the portal page
KS_TSK_List
- Contains XML code to define the node list which displays in the task builder.
KS_TSK_Lock
- A Task Engine instance flags a trigger as being processed to prevent other instances from duplicating the execution.
KS_TSK_Relationship
- Represents the relationship to the Task and Category. The relationship is maintained on the Task Admin Console.
KS_TSK_Tree
- Task Builder stores the Task Tree to this form. The Tree is represented as one entry in this form as an XML document.
KS_TSK_Trigger
- Task engine queries this form to obtain list of processes to be performed
- If task nodes are configured as deferred, an event in Remedy will be responsible for creating the next trigger to advance the processing to the next level in the Tree
KS_TSK_Trigger_Lock_join
- Join of the KS_TSK_Trigger and KS_TSK_Lock forms
KS_TSK_Wait
- These entries are created by the Wait task engine handler
- A Remedy Escalation checks the date/time on these entries to determine when to create a task trigger
- They are useful for reminders or to automatically cancel an approval after a set number of days.