Tuning Tools Database Tables
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
| Name | Description |
|---|---|
Annotations |
Contains fields for user data and calculated values that are related to an occurrence of a session, task, or turn. Data is added through Analytics and Tuning Studio to individual instances of a session, task, or turn. |
ApplicationData |
Contains the data logged by instances of the ApplicationDataEvent class. |
Applications |
Contains application type, name, and version information. |
ApplicationTasks |
Contains the names of tasks. |
ApplicationTurns |
Contains the names of turns. |
CommandTypes |
Contains the types of commands used in turns. |
Cultures |
Describes the language of a turn instance. |
Databases |
Stores the identity of the database holding the data. This table is used for Business Intelligence import scenarios. |
Dates |
A reference table holding dates. |
Devices |
Describes the calling device and the called device (phone numbers). |
DtmfInstanceRequests |
Reference table for each instance of a dual tone multi-frequency (DTMF) request. |
DtmfRecognitions |
Contains the properties of a DTMF input result. |
EngineRecoAudio |
Contains the properties of the audio recorded by the recognition engine for an input turn. |
EngineRecoAudioData |
Contains the audio data recorded by the recognition engine. |
EventTypes |
Contains the names of different Speech Server event types as imported into the database. |
GrammarData |
Stores binary grammar streams associated with an audio record. |
Grammars |
Contains the properties of grammars logged for recognitions. |
ImportFiles |
Reference and fingerprint table for trace file data previously imported into the database. |
ImportSessions |
Tracks the history of each import session or batch. As multiple trace logs might be imported for any given session and trace logs might be reimported under certain scenarios, there is a many-to-many relationship between this table and the ImportFiles table. |
ImportTokens |
Intersection table for the many-to-many relationship between the ImportFiles and ImportSessions tables. It provides an audit mechanism for associating tuning data with the trace log from which it originated. The possible values for TimeZoneOffset are between 0 to 12 and 244 to 255. This is because this value is calculated from a signed BYTE. It stores time zone offsets in term of hour differences; that is +12 to -12. |
Instances |
Reference table for prompt instance requests. |
Messages |
Contains the data from Speech Server events or messages imported into the database. |
NonEngineRecoAudio |
Contains the properties of the audio recorded when Recognizer is not active. This data is used for session playback. |
NonEngineRecoAudioData |
Contains the audio data recorded when the recognition engine is not active. This data is used for session playback. |
PromptAudio |
Contains the properties of the output audio of a prompt. This data is used for session playback. |
PromptAudioData |
Contains the audio data recorded for a prompt. This data is used for session playback. |
PromptData |
Contains the plain text and markup of prompt content. |
PromptInstanceRequests |
Reference table for prompt instance requests. |
Prompts |
Describes the execution of a prompt request. |
RecognitionData |
Contains binary data associated with a speech recognition request. |
RecognitionGroups |
Holds properties of speech recognition cycles, both original and Re-recognition cycles. |
RecognitionResults |
Holds properties of speech recognition results. |
RecognitionWords |
Contains words and transcription comparison information for individual recognition results. |
ResponseTypes |
Contains the characterization of the user responses for a turn; typically Answered, Confirmed, Corrected, or Denied. |
Runtime |
Contains the type and version of the Speech Server runtime from which the data is generated. |
SemanticAnswers |
Details the state changes of a semantic item as occurring within a turn. |
SemanticItems |
Reference table for semantic items. |
Servers |
Reference table for servers running Speech Server. |
SessionAggregate |
An aggregation holding the latest session time stamp in the data. |
SessionErrorCounts |
Contains counts of any errors for each session. |
SessionErrors |
Contains the list of error types. |
Sessions |
Contains the properties associated with a session, including called and calling parties, time stamps, ending status, and other information. |
SpeechGrammarUsage |
Contains references to the grammars used for speech recognitions. |
SpeechInstanceRequests |
Reference table for speech recognition instance requests. |
SpeechRecognitions |
Contains the properties of individual speech recognitions, including configuration information and ending status. |
SpeechTranscriptions |
Contains the transcription for a given turn, as entered in Analytics and Tuning Studio. |
Subtasks |
Reference table for subtask information held by sessions and tasks. |
Tasks |
Contains the properties of task instances, including name reference, ending status, duration, and turn count. |
Times |
A reference table holding times of day. |
Turns |
Contains the properties associated with turns, including name reference, ending status, and duration. |
TurnTypes |
Contains the purposes of a turn, if known; typically Ask, Confirm, or Statement. |
UserEvents |
Contains the data logged by instances of the SessionLabelEvent event and used for reporting with an application-specific custom filter. |
UserEventTypes |
Reference table for SessionLabelEvent types. |