Follow-On Topics

Related Topics

# King Task Centre Data Dictionary

This Data Dictionary is intended to provide users with details of the tables available in the King Task Centre SQL database, providing an "SQL" rather than "Internal" database type is being used, so that the data may be queried and utilised either within a King Task Centre Task or within an external application or report. Any standard query tool may be used to access the data.

A list of the tables available in the SQL database is provided below. Clicking on a table name will display a list of the columns available for the table, including a description for each column.

Tasks

This table contains a list of tasks in the King Task Centre Store and provides their ID and folder locations in the store.

`TaskID` | `int` [primary key] | This is an unique task ID (primary key).
`TaskPath` | `nvarchar` (max) | This contains the task path.
`TaskName` | `nvarchar` (max) | This contains the task name.

EventLog

`EventID` | `int` [primary key] | This contains this log event identifier and is the primary key.
`EventCategory` | `tinyint` [nonclustered index] | This is the category of the event log entry (i.e. Task/Step/System/Security). The EventLogCategories table can be used to map this field to a category name.
`EventType` | `tinyint` [nonclustered index] | This is the type of the event log entry (Information/Warning/Error). The EventLogTypes table can be used to map this field to a category type.
`EventDesc` | `nvarchar`( max ) | This is a textual description of the event log entry.
`EventSource` | `nvarchar`( max ) | This is a timestamp recording the date/time the event occurred.
`EventTime` | `datetime` [nonclustered index] | This is a timestamp recording the date/time the event occurred.
`ResultCode`> | `int` | This is the event error result code.
`StepID` | `int` | This is the Step Identifier that uniquely identifies the step; Valid only for step entries, NULL otherwise.
`TaskID` | `int` [nonclustered index] | This is the Task Identifier that uniquely identifies the task (the TaskDetails table can be used to obtain more task information - only applies to Task Run or step log entries within a task) ; -1 for system logging entries, valid value for task/step entries.
`TaskInstance` | `int` [nonclustered index] | This is the Task Instance Identifier that uniquely identifies the task run. It will match the EventID for the main task log entry; steps will refer to the main log entry therefore they will be “connected” to the task run instance log entry that they are related to; NULL for system log entries.

EventLogTypes

This is a helper table for 3rd party log access providing textual representation of event type as used in the EventLog table.

`TypeID` | `tinyint` [clustered index] | This is the type ID and can be one of the following values; 0 Information, 1 Warning, 2 Error.
`TypeName` | `nvarchar` (max) | This column contains type name.

EventLogCategories

This is a helper table for 3rd party log access providing textual representation of event categories.

`CatID` | `tinyint` [clustered index] | This is the category ID and can be one of the following values; 15 System, 13 Task, 28 Step (Event), 12 Step, 19 Security.
`CatName` | `nvarchar` (max) | This column contains the name of the category identified by the CatID column.

Copyright © 2018 Quadrant Software B.V. All rights reserved.