3 The Physical Data Model

This chapter provides a list of all tables that are available for system logging capabilities. By default the installation process creates these tables automatically, but you can also create them manually later on. For more information refer to the Installation Guide.

Table Overview

The physical data model is divided into six fact tables, which hold variable data and are updated on each session; four aggregate tables, which hold pre-aggregated data on a higher level; and thirty-one lookup tables as well as two relationship tables, which store detailed information for the respective dimensional attributes.

Twenty-three of the lookup tables are static and do not change over time; four of them are filled on application redeploys; four of them are dynamic and are filled incrementally as new entries are observed in dialog sessions.

Table Name	Table Description
VOLDAGGRES	Aggregate table for server statistics on level Metadata Repository and server
VOLDAGGRSS	Aggregate table for server statistics on level Metadata Repository, server and server instance
VOLDAGGRSV	Aggregate table for server statistics on level Metadata Repository and service
VOLDAGGSIT	Aggregate table for session partitioning information on site level
VOLDCHANNEL	Lookup table for channels (static)
VOLDDEPLCOM	Lookup table for deployment commands (static)
VOLDDLGSTS	Fact table for dialog statistics
VOLDDRIVER	Lookup table for media platform drivers (static)
VOLDDSSEQ	Fact table for input state statistics
VOLDEXTSTS	Lookup table for the caller’s exit status (static)
VOLDEXTTYP	Lookup table for the caller’s exit type (static)
VOLDINPMODE	Lookup table for input modes (static)
VOLDINPTYPE	Lookup table for input types (static)
VOLDLAYER	Lookup table for layers (redeploy)
VOLDLNGCOD	Lookup table for the language of the dialog (static)
VOLDLOCK	For internal use only
VOLDLOGSCOPE	Lookup table for logging scopes (static)
VOLDLOGSRV	Fact table for enhanced server statistics
VOLDLYRREL	Relationship table for layer sets
VOLDLYRSET	Lookup table for layer sets (dynamic)
VOLDLYRSETSID	For internal use only
VOLDLYRSTATE	Lookup table for layer states (redeploy)
VOLDLYRTYPE	Lookup table for layer types (static)
VOLDMODSEQ	Lookup table for module sequences (dynamic)
VOLDMODSEQSID	For internal use only
VOLDMODSET	Lookup table for module sets (dynamic)
VOLDMODSETSID	For internal use only
VOLDMODULE	Lookup table for modules (redeploy)
VOLDRECCAT	Lookup table for recording categories (static)
VOLDRECLOG	Fact table for recordings
VOLDRECTYPE	Lookup table for recording types (static)
VOLDREJSES	Fact table for rejected sessions
VOLDREJTYP	Lookup table for rejection types (static)
VOLDRELMSQ	Relationship table for module sequences
VOLDREPCFG	For internal use only
VOLDREPSRC	Lookup table for the Metadata Repositories (static)
VOLDSEQREPSRCSID	For internal use only
VOLDSEQVSCUID	For internal use only
VOLDSITOBJ	Lookup table for sites (static)
VOLDSRVOBJ	Lookup table for servers (static)
VOLDSUBSEQ	Lookup table for subsequences (dynamic)
VOLDSTYPE	Lookup table for input subtypes (static)
VOLDTASK	Lookup table for business tasks (redeploy)
VOLDTASKCMPL	Lookup table for business task completion types (static)
VOLDTASKDATA	Fact table for business task data
VOLDTASKSTATS	Fact table for business tasks
VOLDTASKSTATUS	Lookup table for business task statuses (static)
VOLDTASKTYPE	Lookup table for business task types (static)
VOLDTRCAT	Lookup table for transition categories (static)
VOLDTRTYPE	Lookup table for transition types (static)
VOLDVSCOBJ	Lookup table for services (static)
VOLDVSCTYPE	Lookup table for service types (static)

Detailed Information on Tables

Detailed information includes, aside from the table name, the primary function of each table, its column names along with their data type and a short description of their purpose. An X in Primary Key indicates that the respective column is part of the table’s primary key.

VOLDAGGRES	Fact table for enhanced server statistics / one record per interval, service and server instance
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
MONTH_ID	NUMBER(6)		Month ID of snapshot taken – YYYYMM
DAY_ID	NUMBER(8)	X	Day ID of snapshot taken – YYYYMMDD
MINUTE_ID	NUMBER(4)	X	Minute ID of snapshot taken – HHMM
SECOND_ID	NUMBER(2)	X	Second ID of snapshot taken – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
NO_CON_CALLS	NUMBER(8)		Number of active sessions
NO_FIN_CALLS	NUMBER(8)		Number of finished sessions
NO_ABO_CALLS	NUMBER(8)		Number of aborted sessions
NO_REJ_CALLS	NUMBER(8)		Number of rejected sessions
ACT_SES_GAR	NUMBER(8)		Actual session guarantee
ACT_SES_FLO	NUMBER(8)		Actual floating sessions
ACT_SES_LMT	NUMBER(8)		Actual session limit
REQ_SES_GAR	NUMBER(8)		Requested session guarantee
REQ_SES_LMT	NUMBER(8)		Requested session limit
ROW_TS	DATE	X	Row timestamp – exact timestamp when the record was written into the DB

VOLDAGGRSS	Fact table for enhanced server statistics / one record per interval, service and server instance
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_INST_IP	VARCHAR(140)	X	Server IP address
SRV_INST_PORT	VARCHAR(10)	X	Server instance port
SRV_INST_NAME	VARCHAR(128)	X	Server instance name
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
MONTH_ID	NUMBER(6)		Month ID of snapshot taken – YYYYMM
DAY_ID	NUMBER(8)	X	Day ID of snapshot taken – YYYYMMDD
MINUTE_ID	NUMBER(4)	X	Minute ID of snapshot taken – HHMM
SECOND_ID	NUMBER(2)	X	Second ID of snapshot taken – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
NO_CON_CALLS	NUMBER(8)		Number of concurrent sessions
NO_FIN_CALLS	NUMBER(8)		Number of finished sessions
NO_ABO_CALLS	NUMBER(8)		Number of aborted sessions
NO_REJ_CALLS	NUMBER(8)		Number of rejected sessions
MEM_USED	NUMBER(10)		Used memory
MEM_FREE	NUMBER(10)		Free memory
ROW_TS	DATE	X	Row timestamp – exact timestamp when the record was written into the DB

VOLDAGGRSV	Fact table for enhanced server statistics / one record per interval, service and server instance
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
VSC_UID	NUMBER(7)		Service unique ID – unique ID for each deployment or restore action
MONTH_ID	NUMBER(6)		Month ID of snapshot taken – YYYYMM
DAY_ID	NUMBER(8)	X	Day ID of snapshot taken – YYYYMMDD
MINUTE_ID	NUMBER(4)	X	Minute ID of snapshot taken – HHMM
SECOND_ID	NUMBER(2)	X	Second ID of snapshot taken – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
NO_CON_CALLS	NUMBER(8)		Number of concurrent sessions
NO_FIN_CALLS	NUMBER(8)		Number of finished sessions
NO_ABO_CALLS	NUMBER(8)		Number of aborted sessions
NO_REJ_CALLS	NUMBER(8)		Number of rejected sessions
ACT_SES_GAR	NUMBER(8)		Actual session guarantee
ACT_SES_FLO	NUMBER(8)		Actual floating sessions
ACT_SES_LMT	NUMBER(8)		Actual session limit
REQ_SES_GAR	NUMBER(8)		Requested session guarantee
REQ_SES_LMT	NUMBER(8)		Requested session limit
ROW_TS	DATE	X	Row timestamp – exact timestamp when the record was written into the DB

VOLDAGGSIT	Fact table for session partitioning statistics / one record per interval and site
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SITE_SID	NUMBER(5)	X	Site surrogate ID – relates to lookup table VOLDSITOBJ
MONTH_ID	NUMBER(6)		Month ID of snapshot taken – YYYYMM
DAY_ID	NUMBER(8)	X	Day ID of snapshot taken – YYYYMMDD
MINUTE_ID	NUMBER(4)	X	Minute ID of snapshot taken – HHMM
SECOND_ID	NUMBER(2)	X	Second ID of snapshot taken – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
ACT_SES_GAR	NUMBER(8)		Actual session guarantee
ACT_SES_FLO	NUMBER(8)		Actual floating sessions
ACT_SES_LMT	NUMBER(8)		Actual session limit
REQ_SES_GAR	NUMBER(8)		Requested session guarantee
REQ_SES_LMT	NUMBER(8)		Requested session limit
ROW_TS	DATE	X	Row timestamp – exact timestamp when the record was written into the DB

VOLDCHANNEL	Lookup table for channel / one record per channel
Column Name	Data Type	Primary Key	Description
CHANNEL_ID	NUMBER(3)	X	Channel ID
CHANNEL_NAME	VARCHAR(255)		Channel name
CHANNEL_DESC	VARCHAR(255)		Channel description
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDDEPLCOM	Lookup table for deployment commands / one record per deployment command and language
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
DEPLCOM_ID	NUMBER(3)	X	Deployment command ID
DEPLCOM_NAME	VARCHAR(255)		Deployment command name
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDDLGSTS	Fact table for dialog statistics / one record per session
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)		Metadata Repository ID
SITE_SID	NUMBER(4)		Site surrogate ID – relates to table VOLDSITOBJ
SITE_GUID	CHAR(40)		GUID of the root site administrator
SRV_SID	NUMBER(5)		Server surrogate ID – relates to lookup table VOLDSRVOBJ
SRV_HOST_IP	VARCHAR(140)		Server IP address
SRV_INST_PORT	VARCHAR(10)		Server instance port
SRV_INST_NAME	VARCHAR(128)		Server instance name
VSC_SID	NUMBER(6)		Service surrogate ID – relates to lookup table VOLDVSCOBJ
VSC_UID	NUMBER(7)		Service unique ID – unique ID for each deployment or restore action
MONTH_ID	NUMBER(6)		Month ID for start of dialog – YYYYMM
DAY_ID	NUMBER(8)		Day ID for start of dialog – YYYYMMDD
MINUTE_ID	NUMBER(4)		Minute ID for start of dialog – HHMM
SECOND_ID	NUMBER(2)		Second ID for start of dialog – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
DRIVER_ID	NUMBER(3)		Media platform driver ID – relates to lookup table VOLDDRIVER
LANGUAGE_ID	NUMBER(3)		Language code ID – relates to lookup table VOLDLNGCOD
DLG_ID	CHAR(44)	X	Unique dialog ID
MASTER_DLG_ID	CHAR(44)		Dialog ID of the master session of this session. If no service chaining is used, will be the same as DLG_ID.
DLG_AAI	VARCHAR(255)		Session variable – AAI = Application 2 Application Information
DLG_ANI	VARCHAR(20)		Session variable – ANI = Automatic Number Identification
DLG_DNIS	VARCHAR(20)		Session variable – DNIS = Dialed Number Identification Service
DLG_IID	VARCHAR(50)		Session variable – IID = Information Indicator Digits (IIDigits)
DLG_RDNIS	VARCHAR(50)		Session variable – RDNIS = Redirecting Number Identification Service
DLG_SPSID	VARCHAR(50)		Session variable – MPSID = Media Platform Session ID
DLG_CRMID	VARCHAR(128)		Value that was assigned to the CRM ID using Session(CRMID, [arg])
DLG_GCID	VARCHAR(100)		Value that was assigned to the Global Call ID using Session(GCID, [arg])
DLG_CALL_DUR_MS	NUMBER(10)		Dialog call duration in milliseconds
DLG_PROC_DUR_MS	NUMBER(10)		Dialog processing duration in milliseconds (incl. dialog end processing)
DLG_EXIT_TYPE_ID	NUMBER(3)		Dialog exit type ID – relates to lookup table VOLDEXTTYP
DLG_END_PROC_ID	NUMBER(1)		Deprecated
DLG_LOG	VARCHAR(4000)		Dialog Context – custom log information up to 4000 chars
NO_NI	NUMBER(3)		Number of No Input events
NO_NM	NUMBER(3)		Number of No Match events
NO_NM_BARGEIN	NUMBER(3)		Number of No Match events that were triggered with barge-in
NO_NM_NOBARGEIN	NUMBER(3)		Number of No Match events that were triggered without barge-in
NO_NM_VOICE	NUMBER(3)		Number of No Match events with input mode voice
NO_NM_VOICE_BARGEIN	NUMBER(3)		Number of No Match events with input mode voice that were triggered with barge-in
NO_NM_VOICE_NOBARGEIN	NUMBER(3)		Number of No Match events with input mode voice that were triggered without barge-in
NO_NM_DTMF	NUMBER(3)		Number of No Match events with input mode DTMF
NO_NM_DTMF_BARGEIN	NUMBER(3)		Number of No Match events with input mode DTMF that were triggered with barge-in
NO_NM_DTMF_NOBARGEIN	NUMBER(3)		Number of No Match events with input mode DTMF that were triggered without barge-in
NO_HLP	NUMBER(3)		Number of help commands
NO_RPTS	NUMBER(3)		Number of repeat commands
NO_EXIT	NUMBER(3)		Number of exit commands
NO_PAUSE	NUMBER(3)		Number of pause commands
NO_ERRS	NUMBER(3)		Number of errors
NO_BRGD_TRANS	NUMBER(3)		Number of bridged transfers
MOD_SEQ_SID	NUMBER(9)		Module sequence ID – relates to table VOLDMODSEQ
MOD_SET_SID	NUMBER(9)		Module set ID – relates to table VOLDMODSET
IS_SEQ_SID	NUMBER(9)		Deprecated column
NO_REC	NUMBER(3)		Number of recordings for this session
REC_SIZE	NUMBER(10)		Complete size of all recordings during this session in kilobyte
REC_DUR_MS	NUMBER(10)		Complete duration of all recordings during this session in milliseconds
TRANS_DUR_MS	NUMBER(10)		Complete duration of all transfers during this session in milliseconds
CHANNEL_ID	NUMBER(3)		ID of the channel used for this session – relates to lookup table VOLDCHANNEL
LYR_SET_SID	NUMBER(9)		Layer set ID – relates to lookup table VOLDLYRSET
INP_MODE_ID	NUMBER(2)		Input mode ID – relates to lookup table VOLDINPMODE
NO_DS_STEPS	NUMBER(3)		Number of input states per dialog. Will be filled, even if Input State logging is disabled
NO_DS_STEPS_VOICE	NUMBER(3)		Number of input states with a successful recognition of voice input
NO_DS_STEPS_DTMF	NUMBER(3)		Number of input states with a successful recognition of DTMF input
NO_DS_STEPS_TEXT	NUMBER(3)		Number of input states with a successful recognition of text input
LAST_DS_STEP	NUMBER(3)		ID of the last input state for this dialog – relates to table VOLDDSSEQ
LAST_DS_NAME	VARCHAR(128)		Name of the last input state for this dialog
LAST_DS_TYPE	NUMBER(3)		ID of the type of the last input state for this dialog – elates to lookup table VOLDINPTYPE
HAS_DS_STEPS	NUMBER(3)		0 if no input states were written for this dialog, 1 if at least one input state exists
NO_CONNECTOR _EXECS	NUMBER(3)		Number of Connector object executions
CONN_EXEC_TIME _TOT	NUMBER(8)		The cumulated execution time of all Connector objects per dialog in milliseconds
CONN_EXEC_TIME _MIN	NUMBER(8)		The shortest Connector object execution time per dialog in milliseconds
CONN_EXEC_TIME _MAX	NUMBER(8)		The longest Connector object execution time per dialog in milliseconds
NO_SCRIPT_EXECS	NUMBER(3)		Number of Script object executions
SCRT_EXEC_TIME_TOT	NUMBER(8)		The cumulated execution time of all Script objects per dialog in milliseconds
SCRT_EXEC_TIME_MIN	NUMBER(8)		The shortest Script object execution time per dialog in milliseconds
SCRT_EXEC_TIME _MAX	NUMBER(8)		The longest Script object execution time per dialog in milliseconds
NO_DB_EXECS	NUMBER(3)		Number of Database object executions
DB_EXEC_TIME_TOT	NUMBER(8)		The cumulated execution time of all Database objects per dialog in milliseconds
DB_EXEC_TIME_MIN	NUMBER(8)		The shortest Database object execution time per dialog in milliseconds
DB_EXEC_TIME_MAX	NUMBER(8)		The longest Database object execution time per dialog in milliseconds
NO_TASK_EXECS	NUMBER(3)		Total number of business tasks that were activated during the dialog
NO_TASK_COMPL	NUMBER(3)		Number of business tasks that were completed successfully during the dialog
NO_TASK_INCOMPL	NUMBER(3)		Number of business tasks that were finished unsuccessfully during the dialog
NO_NOTIFICATIONS	NUMBER(3)		Number of notifications sent (SNMP or e-mail)
NO_HYPERLINKS	NUMBER(3)		Number of hyperlinks triggered per dialog
NO_BACK	NUMBER(3)		Number of back commands
NO_FORWARD	NUMBER(3)		Number of forward commands
NO_SKIP	NUMBER(3)		Number of skip commands
PAUSE_DURATION_MS	NUMBER(8)		Duration in milliseconds that the dialog was in pause mode
NO_DS_IMMEDREC	NUMBER(3)		Number of input states with an immediate recognition (i.e. a recognition event without one of the following events: No Match, No Input, error, disconnect, help, repeat)
NO_DS _NONIMMEDREC	NUMBER(3)		Number of input states with a non- immediate recognition (i.e. a recognition event with one of the following events: No Match, No Input, error, disconnect, help, repeat)
NO_DS_SUCCESS	NUMBER(3)		Number of successful input states (i.e. input states that finished with a recognition event)
NO_DS_NONSUCCESS	NUMBER(3)		Number of unsuccessful input states (i.e. input states that finished without a recognition event)
NO_DS_BARGEIN	NUMBER(3)		Number of input states in which at least one barge-in occurred
NO_DS_NOMATCH	NUMBER(3)		Number of input states with at least one No Match event
NO_DS_NOMATCH_BARGEIN	NUMBER(3)		Number of input states with at least one No Match event that was triggered with barge-in
NO_DS_NOMATCH_NOBARGEIN	NUMBER(3)		Number of input states with at least one No Match event that was triggered without barge-in
NO_DS_NM_VOICE	NUMBER(3)		Number of input states with at least one No Match voice event
NO_DS_NM_VOICE_BARGEIN	NUMBER(3)		Number of input states with at least one No Match voice event that was triggered with barge-in
NO_DS_NM_VOICE_NOBARGEIN	NUMBER(3)		Number of input states with at least one No Match voice event that was triggered without barge-in
NO_DS_NM_DTMF	NUMBER(3)		Number of input states with at least one No Match DTMF event
NO_DS_NM_DTMF_BARGEIN	NUMBER(3)		Number of input states with at least one No Match DTMF event that was triggered with barge-in
NO_DS_NM_DTMF_NOBARGEIN	NUMBER(3)		Number of input states with at least one No Match DTMF event that was triggered without barge-in
NO_DS_NOINPUT	NUMBER(3)		Number of input states with at least one No Input event
NO_DS_INV_ANS_LMT	NUMBER(3)		Number of input states in which the invalid answer limit was reached
NO_NI_1	NUMBER(3)		Number of input states with at least one No Input event
NO_NI_2	NUMBER(3)		Number of input states with at least two No Input events
NO_NI_3	NUMBER(3)		Number of input states with at least three No Input events
NO_NI_4	NUMBER(3)		Number of input states with at least four No Input events
NO_NM_1	NUMBER(3)		Number of input states with at least one No Match event
NO_NM_2	NUMBER(3)		Number of input states with at least two No Match events
NO_NM_3	NUMBER(3)		Number of input states with at least three No Match events
NO_NM_4	NUMBER(3)		Number of input states with at least four No Match events
NO_MODULES	NUMBER(3)		Number of modules used in this session – corresponds to NO_MODULES in table VOLDMODSEQ
NO_DIST_MODULES	NUMBER(3)		Number of distinct modules used in this session
FIRST_MODULE_SID	NUMBER(6)		SID of the first module used in this session – relates to lookup table VOLDMODULE
LAST_MODULE_SID	NUMBER(6)		SID of the last module used in this session – relates to lookup table VOLDMODULE
FLAG_DLG_END_PROC	NUMBER(3)		Indicates if dialog end processing was used in this session: 0 = no dialog end processing 1 = dialog end processing
NO_ERRS_MP	NUMBER(3)		Number of media platform errors
NO_ERRS_INTERNAL	NUMBER(3)		Number of internal errors
NO_ERRS_SCRIPT	NUMBER(3)		Number of script errors
NO_ERRS _CONNECTOR	NUMBER(3)		Number of connector errors
NO_REQUESTS	NUMBER(3)		Number of requests executed by VoiceObjects Server
VOL_BYTES	NUMBER(8)		Data volume sent by VoiceObjects Server in bytes
PRD_VO_MAX_MS	NUMBER(8)		Not used. Always –1
PRD_VO_MIN_MS	NUMBER(8)		Not used. Always –1
PRD_VO_TOT_MS	NUMBER(8)		Not used. Always –1
PRD_TOT_MIN_MS	NUMBER(8)		Not used. Always –1
PRD_TOT_MAX_MS	NUMBER(8)		Not used. Always –1
NO_BRGD_TRANS _FAIL	NUMBER(3)		Number of failed bridged transfers
NO_CONSULT_TRANS	NUMBER(3)		Number of successful consultation transfers
NO_CNSL_TRANS_FAIL	NUMBER(3)		Number of failed consultation transfers
NO_BLIND_TRANS	NUMBER(3)		Number of successful blind transfers
NO_SESSIONS	NUMBER(3)		Always 1
AVG_CONF_VOICE	NUMBER(3,2)		Average confidence level for all input states in this session
DLG_CHAIN_POS	NUMBER(3)		Indicates the position of this dialog in a service chain
DLG_CHAIN_IS_LAST	NUMBER(1)		Indicates if this is the last session in a service chain: 1 if it is the last session, 0 otherwise
NO_MASTER_SES	NUMBER(1)		Indicates if this session is the master session in a service chain: 1 if it is the master session, 0 otherwise
DLG_EXIT_DEST	VARCHAR(255)		The value of the exit destination. Can be a URL in case of exit type submit, a VSN in case of exit type service chaining, or the name of the Plug-In object in case of exit type Plug-In.
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDDSSEQ	Fact table for input state statistics/ one record per input state
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)		Metadata Repository ID
DLG_ID	CHAR(44)	X	Unique dialog ID
MASTER_DLG_ID	CHAR(44)		Dialog ID of the master session of this session. If no service chaining is used, will be the same as DLG_ID.
SRV_SID	NUMBER(5)		Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)		Service surrogate ID – relates to lookup table VOLDVSCOBJ
VSC_UID	NUMBER(7)		Service unique ID – unique ID for each deployment or restore action
SITE_SID	NUMBER(4)		Site surrogate ID
SITE_GUID	CHAR(40)		Site GUID – relates to lookup table VOLDSITOBJ
DS_STEP	NUMBER(3)	X	Consecutive number of each individual input state, starting at 0
MOD_SID	NUMBER(6)		Module surrogate ID – relates to lookup table VOLDMODULE
DS_NAME	VARCHAR(128)		Name of the object that initiated this input state
DS_GUID	CHAR(40)		GUID of the object that initiated this input state
DS_INP_TYPE	NUMBER(3)		Input type ID – relates to lookup table VOLDINPTYPE
DS_INP_STYPE	NUMBER(3)		Input subtype ID – relates to lookup table VOLDSTYPE
DS_TR_TYPE	NUMBER(3)		Transition type ID – relates to lookup table VOLDTRTYPE
DS_EVENT_NAME	VARCHAR(255)		Name of the event that lead to exiting the current input state
DS_TR_INP_MODE	VARCHAR(20)		Indicates the input mode
DS_TR_UTT	VARCHAR(255)		Utterance of the caller
DS_TR_CONF	NUMBER(3, 2)		Confidence of the recognition event
DS_TR_SLT	VARCHAR(255)		Comma-separated list of slot names and values that were filled in the input state
NO_NI	NUMBER(3)		Number of No Input events
NO_NM	NUMBER(3)		Number of No Match events
NO_NM_BARGEIN	NUMBER(3)		Number of No Match events that were triggered with barge-in
NO_NM_NOBARGEIN	NUMBER(3)		Number of No Match events that were triggered without barge-in
NO_NM_VOICE	NUMBER(3)		Number of No Match events for input state voice
NO_NM_VOICE_BARGEIN	NUMBER(3)		Number of No Match events for input state voice that were triggered with barge-in
NO_NM_VOICE_NOBARGEIN	NUMBER(3)		Number of No Match events for input state voice that were triggered without barge-in
NO_NM_DTMF	NUMBER(3)		Number of No Match events for input state DTMF
NO_NM_DTMF_BARGEIN	NUMBER(3)		Number of No Match events for input state DTMF that were triggered with barge-in
NO_NM_DTMF_NOBARGEIN	NUMBER(3)		Number of No Match events for input state DTMF that were triggered without barge-in
NO_HLP	NUMBER(3)		Number of help events
NO_TURNS	NUMBER(3)		Number of turns
DS_EVENT_LIST	VARCHAR(1000)		Comma-separated list of all events that occurred in an input state
INT_DUR_MS	NUMBER(10)		Internal processing duration of the current input state in milliseconds
EXT_DUR_MS	NUMBER(10)		Duration from sending the VoiceXML to the media platform until receiving the submit
MONTH_ID	NUMBER(6)		Month ID for this input state - YYYYMM
DAY_ID	NUMBER(8)		Day ID for this input state – YYYYMMDD
MINUTE_ID	NUMBER(4)		Minute ID for this input state – HHMM
SECOND_ID	NUMBER(2)		Second ID for start of dialog – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
DS_EXT_PROC_DUR_MS	NUMBER(10)		External processing duration in milliseconds
DS_REC_SIZE	NUMBER(10)		Size of recordings in kilobyte
CHANNEL_ID	NUMBER(3)		ID of the channel used for this session – relates to lookup table VOLDCHANNEL
TASK_SID	NUMBER(6)		SID of the task that was active for this input state. Defaults to –1 if no task was active. Relates to lookup table VOLDTASK.
TASK_COUNTER	NUMBER(3)		Consecutive number of multiple executions of the same task
NO_NI_1	NUMBER(3)		1 if at least one No Input event occurred, 0 otherwise
NO_NI_2	NUMBER(3)		1 if at least two No Input events occurred, 0 otherwise
NO_NI_3	NUMBER(3)		1 if at least three No Input events occurred, 0 otherwise
NO_NI_4	NUMBER(3)		1 if at least four No Input events occurred, 0 otherwise
NO_NM_1	NUMBER(3)		1 if at least one No Match event occurred, 0 otherwise
NO_NM_2	NUMBER(3)		1 if at least two No Match events occurred, 0 otherwise
NO_NM_3	NUMBER(3)		1 if at least three No Match events occurred, 0 otherwise
NO_NM_4	NUMBER(3)		1 if at least four No Match events occurred, 0 otherwise
UTT_COUNT	NUMBER(3)		Number of words in the recognized utterance
UTT_COUNT_1	NUMBER(3)		1 if the utterance consists of one word, 0 otherwise
UTT_COUNT_2	NUMBER(3)		1 if the utterance consists of two words, 0 otherwise
UTT_COUNT_3	NUMBER(3)		1 if the utterance consists of three words, 0 otherwise
UTT_COUNT_4	NUMBER(3)		1 if the utterance consists of four words, 0 otherwise
UTT_COUNT_5	NUMBER(3)		1 if the utterance consists of five words, 0 otherwise
UTT_COUNT_6	NUMBER(3)		1 if the utterance consists of six or more words, 0 otherwise
UTT_COUNT_1_CONF	NUMBER(3,2)		Contains the confidence if the utterance consists of one word, -1 otherwise
UTT_COUNT_2_CONF	NUMBER(3,2)		Contains the confidence if the utterance consists of two words, -1 otherwise
UTT_COUNT_3_CONF	NUMBER(3,2)		Contains the confidence if the utterance consists of three words, -1 otherwise
UTT_COUNT_4_CONF	NUMBER(3,2)		Contains the confidence if the utterance consists of four words, -1 otherwise
UTT_COUNT_5_CONF	NUMBER(3,2)		Contains the confidence if the utterance consists of five words, -1 otherwise
UTT_COUNT_6_CONF	NUMBER(3,2)		Contains the confidence if the utterance consists of six or more words, -1 otherwise
UTT_LEN	NUMBER(3)		Number of characters of the recognized utterance
UTT_LEN_TRIM	NUMBER(3)		Number of characters of the recognized utterance without spaces
IS_LAST_STEP	NUMBER(1)		1 if the current input state is the last one for the session, 0 otherwise
DS_BARGEIN_ENABLED	NUMBER(1)		1 if barge-in is enabled, 0 otherwise
DS_TR_BARGEIN	NUMBER(1)		1 if barge-in occurred in the concluding recognition of the input state, 0 otherwise
STD_NAV_ENABLED	NUMBER(1)		1 if at least one standard navigation command was active, 0 otherwise
NO_DS_STEPS	NUMBER(1)		Always 1
NO_DS_STEPS_VOICE	NUMBER(1)		1 if a successful recognition with input mode voice occurred, 0 otherwise
NO_DS_STEPS_DTMF	NUMBER(1)		1 if a successful recognition with input mode DTMF occurred, 0 otherwise
NO_DS_STEPS_TEXT	NUMBER(1)		1 if input mode = text, 0 otherwise
MOD_SEQ_POS	NUMBER(3)		Position of the module that the current input state belongs to in the module sequence
MOD_SEQ_MOD_SID	NUMBER(6)		SID of the module that the current input state belongs to
DS_CONF_THRS	NUMBER(3,2)		Confidence threshold that was active during the current input state. –1 if no confidence threshold was set.
DS_INV_ANS_LMT	NUMBER(3)		invalid answer limit that was active during the input state. 0 if no limit was set.
NO_NOTIFICATIONS	NUMBER(3)		Number of notifications sent
NO_HYPERLINKS	NUMBER(3)		Number of hyperlinks triggered
NO_BACK	NUMBER(3)		Number of back commands
NO_FORWARD	NUMBER(3)		Number of forward commands
NO_SKIP	NUMBER(3)		Number of skip commands
NO_RPTS	NUMBER(3)		Number of repeat commands
PAUSE_DURATION_MS	NUMBER(8)		Duration in milliseconds the system was in pause mode
NO_DS_IMMEDREC	NUMBER(1)		1 if an immediate recognition took place (i.e. a recognition event without one of the following events: No Match, No Input, error, disconnect, help, repeat), 0 otherwise
NO_DS_NONIMMEDREC	NUMBER(1)		1 if an non-immediate recognition took place (i.e. a recognition event with one of the following events: No Match, No Input, error, disconnect, help, repeat), 0 otherwise
NO_DS_SUCCESS	NUMBER(1)		1 if the input state was finished with a recognition event, 0 otherwise
NO_DS_NONSUCCESS	NUMBER(1)		1 if the input state was not finished with a recognition event, 0 otherwise
NO_DS_NOMATCH	NUMBER(1)		1 if at least one No Match event occurred, 0 otherwise
NO_DS_NOMATCH_BARGEIN	NUMBER(1)		1 if at least one No Match event occurred that was triggered with barge-in, 0 otherwise
NO_DS_NOMATCH_NOBARGEIN	NUMBER(1)		1 if at least one No Match event occurred that was triggered without barge-in, 0 otherwise
NO_DS_NM_VOICE	NUMBER(1)		1 if at least one No Match event with input mode voice occurred, 0 otherwise
NO_DS_NM_VOICE_BARGEIN	NUMBER(1)		1 if at least one No Match event with input mode voice occurred that was triggered with barge-in, 0 otherwise
NO_DS_NM_VOICE_NOBARGEIN	NUMBER(1)		1 if at least one No Match event with input mode voice occurred that was triggered without barge-in, 0 otherwise
NO_DS_NM_DTMF	NUMBER(1)		1 if at least one No Match event with input mode DTMF occurred, 0 otherwise
NO_DS_NM_DTMF_BARGEIN	NUMBER(1)		1 if at least one No Match event with input mode DTMF occurred that was triggered with barge-in, 0 otherwise
NO_DS_NM_DTMF_NOBARGEIN	NUMBER(1)		1 if at least one No Match event with input mode DTMF occurred that was triggered without barge-in, 0 otherwise
NO_DS_NOINPUT	NUMBER(1)		1 if at least one No Input event occurred, 0 otherwise
NO_DS_INV_ANS_LMT	NUMBER(1)		1 if the invalid answer limit was reached, 0 otherwise
NO_ERRS_MP	NUMBER(3)		Number of media platform errors
NO_ERRS_INTERNAL	NUMBER(3)		Number of internal errors
NO_ERRS_SCRIPT	NUMBER(3)		Number of script errors
NO_ERRS_CONNECTOR	NUMBER(3)		Number of connector errors
NO_REQUESTS	NUMBER(3)		Always 1
VOL_BYTES	NUMBER(8)		Data volume sent by VoiceObjects Server in bytes
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDDRIVER	Lookup table for media platform drivers / one record per driver
Column Name	Data Type	Primary Key	Description
DRIVER_ID	NUMBER(3)	X	Media platform driver ID
DRIVER_NAME	VARCHAR(50)		Media platform driver description
CHANNEL_ID	NUMBER(3)		ID of the channel configured for this driver – relates to lookup table VOLDCHANNEL
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDEXTSTS	Lookup table for the exit status / one record per exit status and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
DLG_EXIT_STS_ID	NUMBER(2)	X	Dialog exit status ID
DLG_EXIT_STS_DSC	VARCHAR(15)		Dialog exit status description (LOCALIZED)
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDEXTTYP	Lookup table for the exit types / one record per exit type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
DLG_EXIT_TYPE_ID	NUMBER(3)	X	Dialog exit type ID
DLG_EXIT_TYPE_CODE	VARCHAR(15)		Dialog exit type code (short description of dialog type)
DLG_EXIT_TYPE_DSC	VARCHAR(30)		Dialog exit type description (LOCALIZED)
DLG_EXIT_STS_ID	NUMBER(2)		Dialog exit status ID – relates to table VOLDEXTSTS
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDINPMODE	Lookup table for input modes / one record per input mode and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
INP_MODE_ID	NUMBER(2)	X	Input mode ID
INP_MODE_CID	VARCHAR(20)		Input mode alphanumeric ID.
INP_MODE_DESC	VARCHAR(20)		Input mode description (LOCALIZED)
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDINPTYPE	Lookup table for input types / one record per type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
DS_INP_TYPE	NUMBER(3)	X	Input type ID
DS_INP_DESC	VARCHAR(255)		Name of the input type (e.g. Input, Menu, etc.) LOCALIZED
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDLAYER	Lookup table for layers / one record per layer
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
SITE_SID	NUMBER(4)	X	Site surrogate ID – relates to lookup table VOLDSITOBJ
LYR_SID	NUMBER(6)	X	Layer surrogate ID
LYR_REFID	VARCHAR(255)		Layer reference ID
LYR_GUID	CHAR(40)		Layer GUID
LYR_NAME	VARCHAR(255)		Layer name
LYR_CRT_TS	NUMBER(14)		Layer creation timestamp
LYR_CRT_DAY_ID	NUMBER(8)		Layer creation day ID – YYYYMMDD
LYR_CRT_MINUTE_ID	NUMBER(4)		Layer creation minute ID – HHMM
LYR_MOD_TS	NUMBER(14)		Layer modification timestamp
LYR_MOD_DAY_ID	NUMBER(8)		Layer modification day ID – YYYYMMDD
LYR_MOD_MINUTE_ID	NUMBER(4)		Layer modification minute ID – HHMM
LYR_OWN_ACC_GUID	CHAR(40)		Layer owner account ID
LYR_MOD_ACC_GUID	CHAR(40)		Layer modification account ID
LYR_TYPE_ID	NUMBER(2)		Layer type ID – relates to lookup table VOLDLYRTYPE.
LYR_LOG_STATUS	NUMBER(1)		1 if logging for this layer is enabled, 0 otherwise
NO_LAYERS	NUMBER(1)		Always 1
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDLNGCOD	Lookup table for supported languages / one record per language and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
LANGUAGE_ID	NUMBER(3)	X	Language ID
LANGUAGE_CODE	VARCHAR(8)		Language code (e.g. en-US, de, etc.) LOCALIZED
LANGUAGE_DSC	VARCHAR(50)		Name of the language (e.g. Hungarian, French, etc.) LOCALIZED
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDLOCK	For internal use only
Column Name	Data Type	Primary Key	Description
LOCK_VALUE	VARCHAR(255	X	For internal use only
LOCK_KEY	VARCHAR(40)		For internal use only
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDLOGSCOPE	Lookup table for logging scopes / one record per logging scope and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
LOG_FILTERSCP_ID	NUMBER(3)	X	Logging Scope ID
LOG_FILTERSCP_NAME	VARCHAR(255)		Logging Scope name
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDLOGSRV	Fact table for enhanced server statistics / one record per interval, service, and server instance
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_INST_IP	VARCHAR(140)	X	Server IP address
SRV_INST_PORT	VARCHAR(10)	X	Server instance port
SRV_INST_NAME	VARCHAR(128)	X	Server instance name
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
VSC_UID	NUMBER(7)		Service unique ID – unique ID for each deployment or restore action
MONTH_ID	NUMBER(6)		Month ID of snapshot taken – YYYYMM
DAY_ID	NUMBER(8)	X	Day ID of snapshot taken – YYYYMMDD
MINUTE_ID	NUMBER(4)	X	Minute ID of snapshot taken – HHMM
SECOND_ID	NUMBER(2)	X	Second ID of snapshot taken – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
NO_CON_CALLS	NUMBER(8)		Number of concurrent active sessions
NO_FIN_CALLS	NUMBER(8)		Total number of finished sessions
NO_ABO_CALLS	NUMBER(8)		Total number of aborted sessions
NO_REJ_CALLS	NUMBER(8)		Total number of rejected sessions
NO_REQUESTS	NUMBER(8)		Number of requests executed by VoiceObjects Server
VOL_BYTES	NUMBER(10)		Data volume sent by VoiceObjects Server in bytes
NO_SESSIONS	NUMBER(8)		Number of finished or aborted sessions since last record
DELTA_ABO_CALLS	NUMBER(8)		Number of aborted sessions since last record
DELTA_REJ_CALLS	NUMBER(8)		Number of rejected sessions since last record
DLG_CALL_DUR_MS	NUMBER(10)		Cumulated dialog call duration in milliseconds
DLG_PROC_DUR_MS	NUMBER(10)		Cumulated dialog processing duration in milliseconds (incl. dialog end processing)
NO_CONNECTOR _EXECS	NUMBER(8)		Number of Connector object executions
CONN_EXEC_TIME _TOT	NUMBER(10)		The cumulated execution time of all Connector objects per service in milliseconds
CONN_EXEC_TIME _MIN	NUMBER(10)		The shortest Connector object execution time per service in milliseconds
CONN_EXEC_TIME _MAX	NUMBER(10)		The longest Connector object execution time per service in milliseconds
NO_SCRIPT_EXECS	NUMBER(8)		Number of Script object executions
SCRT_EXEC_TIME_TOT	NUMBER(10)		The cumulated execution time of all Script objects per service in milliseconds
SCRT_EXEC_TIME_MIN	NUMBER(10)		The shortest Script object execution time per service in milliseconds
SCRT_EXEC_TIME _MAX	NUMBER(10)		The longest Script object execution time per service in milliseconds
NO_DB_EXECS	NUMBER(8)		Number of Database object executions
DB_EXEC_TIME_TOT	NUMBER(10)		The cumulated execution time of all Database objects per service in milliseconds
DB_EXEC_TIME_MIN	NUMBER(10)		The shortest Database object execution time per service in milliseconds
DB_EXEC_TIME_MAX	NUMBER(10)		The longest Database object execution time per service in milliseconds
ROW_TS	DATE	X	Row timestamp – exact timestamp when the record was written into the DB

VOLDLYRREL	Relationship table for layer sets / one record per layer and layer set
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
SITE_SID	NUMBER(4)	X	Site surrogate ID – relates to lookup table VOLDSITOBJ
LYR_SET_SID	NUMBER(9)	X	Layer set surrogate ID
LYR_SID	NUMBER(6)	X	Layer surrogate ID – relates to table VOLDLAYER
LYRS_SID	NUMBER(6)	X	Layer state surrogate ID – relates to table VOLDLYRSTATE
LYR_NAME	VARCHAR(255)		Layer name
LYRS_NAME	VARCHAR(255)		Layer state name
ROW_TS	DATE		For internal use only

VOLDLYRSET	Lookup table for layer sets / one record per distinct layer set
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
SITE_SID	NUMBER(4)	X	Site surrogate ID – relates to lookup table VOLDSITOBJ
LYR_SET_SID	NUMBER(9)	X	Layer set surrogate ID
LYR_SET_NAME	VARCHAR(2000)		Comma-separated list of layer names
NO_LYR_SETS	NUMBER(1)		Always 1
LYR_SET_HASHID	CHAR(32)		MD5 Hash value of the layer set name
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDLYRSETSID	For internal use only
Column name	Data Type	Primary Key	Description
NEXTVAL	NUMBER(9)		For internal use only

VOLDLYRSTATE	Lookup table for layer states / one record per layer state
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
SITE_SID	NUMBER(4)	X	Site surrogate ID – relates to lookup table VOLDSITOBJ
LYR_SID	NUMBER(6)		Layer surrogate ID
LYRS_SID	NUMBER(6)	X	Layer state surrogate ID
LYRS_REFID	VARCHAR(255)		Layer state reference ID
LYRS_GUID	CHAR(40)		Layer state GUID
LYRS_NAME	VARCHAR(255)		Layer state name
NO_LYRS	NUMBER(1)		Always 1
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDLYRTYPE	Lookup table for layer types / one record per layer type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
LYR_TYPE_ID	NUMBER(2)	X	Layer type ID
LYR_TYPE_DESC	VARCHAR(20)		Layer type description (LOCALIZED)
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDMODSEQ	Lookup table for module sequences / one record per distinct sequence
Column Name	Data Type	Primary Key	Description
MOD_SEQ_SID	NUMBER(9)	X	Module sequence surrogate ID
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
SITE_SID	NUMBER(4)		Site surrogate ID – relates to lookup table VOLDSITOBJ
SITE_GUID	CHAR(40)		Site GUID
MOD_SEQ_REFID	VARCHAR(4000)		Comma-separated list of module reference IDs (size depends on DB)
MOD_SEQ_NAME	VARCHAR(4000)		Comma-separated list of module names (size depends on DB)
MOD_SEQ_GUID	VARCHAR(4000)		Comma-separated list of module GUIDs (size depends on DB)
MOD_SET_SID	NUMBER(9)		Module set surrogate ID
MOD_SEQ_HASHID	CHAR(32)		MD5 Hash value of the module sequence reference ID
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDMODSEQSID	For internal use only
Column name	Data Type	Primary Key	Description
NEXTVAL	NUMBER(3)		For internal use only

VOLDMODSET	Lookup table for module sets / one record per distinct set
Column Name	Data Type	Primary Key	Description
MOD_SET_SID	NUMBER(9)	X	Module set surrogate ID
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
SITE_SID	NUMBER(4)		Site surrogate ID – relates to lookup table VOLDSITOBJ
SITE_GUID	CHAR(40)		Site GUID
MOD_SET_REFID	VARCHAR(4000)		Comma-separated list of module reference IDs (size depends on DB)
MOD_SET_NAME	VARCHAR(4000)		Comma-separated list of module names (size depends on DB)
MOD_SET_GUID	VARCHAR(4000)		Comma-separated list of module GUIDs (size depends on DB)
MOD_SET_HASHID	CHAR(32)		MD5 Hash value of the module set reference ID
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDMODSETSID	For internal use only
Column name	Data Type	Primary Key	Description
NEXTVAL	NUMBER(3)		For internal use only

VOLDMODULE	Lookup table for modules / one record per module
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
SITE_SID	NUMBER(4)		Site surrogate ID – relates to lookup table VOLDSITOBJ
MOD_SID	NUMBER(6)	X	Module surrogate ID
MOD_REFID	VARCHAR(255)		Module reference ID
MOD_GUID	CHAR(40)		Module GUID
MOD_NAME	VARCHAR(255)		Module name
MOD_CRT_TS	NUMBER(14)		Module creation timestamp
MOD_CRT_DAY_ID	NUMBER(8)		Module creation day ID – YYYYMMDD
MOD_CRT_MINUTE_ID	NUMBER(4)		Module creation minute ID – HHMM
MOD_MOD_TS	NUMBER(14)		Module modification timestamp
MOD_MOD_DAY_ID	NUMBER(8)		Module modification day ID – YYYYMMDD
MOD_MOD_MINUTE_ID	NUMBER(4)		Module modification minute ID – HHMM
MOD_OWN_ACC_GUID	CHAR(40)		Module owner account ID
MOD_MOD_ACC_GUID	CHAR(40)		Module modification account ID
MOD_LOG_STATUS	NUMBER(1)		Specifies if the option “Enable history tracking” is enabled on the module: 1 if this setting is enabled, 0 otherwise
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDRECCAT	Lookup table for recording categories / one record per category and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(3)	X	Specifies the language of the description
REC_CAT_ID	NUMBER(3)	X	Recording category ID
REC_CAT_DESC	VARCHAR(255)		Recording category description
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDRECLOG	Fact table for recordings / one record per recording
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)		Metadata Repository ID
SRV_SID	NUMBER(5)		Server surrogate ID
VSC_SID	NUMBER(6)		Service surrogate ID
VSC_UID	NUMBER(7)		Service unique ID – unique ID for each deployment or restore action
SITE_SID	NUMBER(4)		Site surrogate ID
SITE_GUID	CHAR(40)		Site GUID
SRV_INST_IP	VARCHAR(140)		Server IP address
SRV_INST_PORT	VARCHAR(10)		Server instance port
SRV_INST_NAME	VARCHAR(128)		Server instance name
MONTH_ID	NUMBER(6)		Month ID for start of dialog
DAY_ID	NUMBER(8)		Day ID for start of dialog
MINUTE_ID	NUMBER(4)		Minute ID for start of dialog
SECOND_ID	NUMBER(2)		Second ID for start of dialog
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
MOD_SID	NUMBER(6)		Module surrogate ID
CHANNEL_ID	NUMBER(3)		Channel ID – relates to lookup table VOLDCHANNEL
DLG_ID	CHAR(44)	X	Unique dialog ID
MASTER_DLG_ID	CHAR(44)		Dialog ID of the master session of this session. If no service chaining is used, will be the same as DLG_ID.
DS_STEP	NUMBER(10)	X	Consecutive number of each individual input state
DS_NAME	VARCHAR(128)		Name of the object that initiated the input state
DS_GUID	CHAR(40)		GUID of the object that initiated the input state
DS_TR_BARGEIN	NUMBER(1)		1 if barge-in occurred in the concluding recognition of the input state, 0 otherwise
DS_INP_TYPE	NUMBER(3)		Input type ID – relates to table VOLDINPTYPE
DS_CONF_THRS	NUMBER(3,2)		Confidence threshold that was active during the current input state –1 if no confidence threshold was set
REC_UTT	VARCHAR(255)		Utterance for the recording. Maps to LASTRESULT(utterance), i.e. it is the termchar in case of a Recording object and the utterance in case of utterance and fallback recording. For call recordings this column is empty.
REC_CONF	NUMBER(3,2)		Confidence value for the recording (application.lastresult$.confidence). 0 in case of a Recording object or call recording. For call recordings this column is empty.
REC_COUNT	NUMBER(10)	X	Consecutive numbering of each recording, globally per dialog session
REC_PATH	VARCHAR(255)		Base path to the recording
REC_URL	VARCHAR(255)		Base URL to the recording
REC_NAME	VARCHAR(255)		File name of the recording, including folder structure for month, day, etc.
REC_TYPE_ID	NUMBER(3)		Type of the recording -relates to lookup table VOLDRECTYPE
REC_DUR_MS	NUMBER(10)		Duration of the recording in milliseconds
REC_SIZE	NUMBER(10)		Size of the recording in bytes
REC_OBJ_OCCUR_CNT	NUMBER(3)		Occurrence count of the Recording object
NO_RECORDINGS	NUMBER(1)		Constant used for counting records, should always be 1
TASK_SID	NUMBER(6)		Business task surrogate ID
TASK_COUNTER	NUMBER(3)		Consecutive number of multiple executions of the same task
TRANSCRIPTION	VARCHAR(255)		Column reserved for transcription of the recording; filled with the empty string by Infostore
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDRECTYPE	Lookup table for recording types / one record per type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(3)	X	Specifies the language of the description
REC_TYPE_ID	NUMBER(3)	X	Recording type ID
REC_CAT_ID	NUMBER(3)		Recording category ID – relates to lookup table VOLDRECCAT
REC_TYPE_DESC	VARCHAR(255)		Recording type description
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDREJSES	Fact table for rejected sessions / one record per rejected session
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)		Metadata Repository ID
SRV_SID	NUMBER(5)		Server surrogate ID
VSC_SID	NUMBER(6)		Service surrogate ID
VSC_UID	NUMBER(7)		Service unique ID – unique ID for each deployment or restore action
SITE_SID	NUMBER(4)		Site surrogate ID
SITE_GUID	CHAR(40)		Site GUID
SRV_HOST_IP	VARCHAR(140)		Server IP address
SRV_INST_PORT	VARCHAR(10)		Server instance port
SRV_INST_NAME	VARCHAR(128)		Server instance name
MONTH_ID	NUMBER(6)		Month ID for start of dialog
DAY_ID	NUMBER(8)		Day ID for start of dialog
MINUTE_ID	NUMBER(4)		Minute ID for start of dialog
SECOND_ID	NUMBER(2)		Second ID for start of dialog
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
DRIVER_ID	NUMBER(3)		Media platform driver ID – relates to lookup table VOLDDRIVER
CHANNEL_ID	NUMBER(3)		Channel ID – relates to lookup table VOLDCHANNEL
LANGUAGE_ID	NUMBER(3)		Language code ID – relates to lookup table VOLDLNGCOD
DLG_ID	CHAR(44)		Unique dialog ID (if available)
MASTER_DLG_ID	CHAR(44)		Dialog ID of the master session of this session. If no service chaining is used, will be the same as DLG_ID.
DLG_CHAIN_POS	NUMBER(3)		Indicates the position of this dialog in a service chain.
NO_MASTER_SES	NUMBER(1)		Indicates if this session is the master session in a service chain: 1 if it is the master session, 0 otherwise.
NO_SESSIONS	NUMBER(1)		Always 1
DLG_AAI	VARCHAR(255)		Session variable – AAI = Application 2 Application Information
DLG_ANI	VARCHAR(20)		Session variable – ANI = Automatic Number Identification
DLG_DNIS	VARCHAR(20)		Session variable – DNIS = Dialed Number Identification Service
DLG_IID	VARCHAR(50)		Session variable – IID = Information Indicator Digits (IIDigits)
DLG_RDNIS	VARCHAR(50)		Session variable – RDNIS = Redirecting Number Identification Service
DLG_SPSID	VARCHAR(50)		Session variable – MPSID = Media Platform Session ID
DLG_CRMID	VARCHAR(128)		Value that was assigned to the CRM ID using Session(CRMID, [arg])
DLG_GCID	VARCHAR(100)		Value that was assigned to the Global Call ID using Session(GCID, [arg])
REJ_TYPE_ID	NUMBER(3)		Media platform driver ID – relates to lookup table VOLDREJTYP
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDREJTYP	Lookup table for rejection types / one record per rejection type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
REJ_TYPE_ID	NUMBER(3)	X	Rejection type ID
REJ_TYPE_CODE	VARCHAR(20)		Rejection type code
REJ_TYPE_DESC	VARCHAR(30)		Description of the rejection type LOCALIZED
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDRELMSQ	Relationship table for module sequences / one record per module sequence and entry in sequence
Column Name	Data Type	Primary Key	Description
MOD_SEQ_SID	NUMBER(9)	X	Module sequence surrogate ID
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
MOD_STEP	NUMBER(3)	X	Consecutive number of module in sequence
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
SITE_SID	NUMBER(4)		Site surrogate ID – relates to lookup table VOLDSITOBJ
SITE_GUID	CHAR(40)		Site GUID
MOD_SID	NUMBER(6)		Module surrogate ID
ROW_TS	DATE		For internal use only

VOLDREPCFG	For internal use only
Column Name	Data Type	Primary Key	Description
CFG_CATG	VARCHAR(255)	X	For internal use only
CFG_PROP	VARCHAR(255)	X	For internal use only
CFG_PROP_ID	NUMBER(14)	X	For internal use only
CFG_VAL	VARCHAR(255)		For internal use only
ROW_TS	DATE		For internal use only

VOLDREPSRC	Lookup table for repository / one record per repository
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
MD_REP_NAME	VARCHAR(255)		Metadata Repository name
MD_REP_DISP_NAME	VARCHAR(255)		Metadata Repository display name
REP_SES_LMT	NUMBER(6)		The maximum number of concurrent sessions for this installation
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDSITOBJ	Lookup table for sites / one record per site
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SITE_SID	NUMBER(4)		Site surrogate ID
SITE_REFID	VARCHAR(255)		Site reference ID
SITE_GUID	CHAR(40)	X	Site GUID
SITE_NAME	VARCHAR(255)		Site name
SITE_CRT_TS	NUMBER(14)		Site creation timestamp
SITE_CRT_DAY_ID	NUMBER(8)		Site creation day ID – YYYYMMDD
SITE_CRT_MINUTE_ID	NUMBER(4)		Site creation minute ID – HHMM
SITE_MOD_TS	NUMBER(14)		Site modification timestamp
SITE_MOD_DAY_ID	NUMBER(8)		Site modification day ID – YYYYMMDD
SITE_MOD_MINUTE_ID	NUMBER(4)		Site modification minute ID – HHMM
SITE_OWN_ACC_GUID	CHAR(40)		Site owner account ID
SITE_MOD_ACC_GUID	CHAR(40)		Site modification account ID
ROW_TS	DATE		Row timestamp - exact timestamp when the record was written into the DB

VOLDSRVOBJ	Lookup table for Server object / one record per object
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SITE_SID	NUMBER(4)		Site surrogate ID
SITE_GUID	CHAR(40)		Site GUID
SRV_SID	NUMBER(5)	X	Server surrogate ID
SRV_GUID	CHAR(40)		Server GUID
SRV_REFID	VARCHAR(255)		Server reference ID
SRV_NAME	VARCHAR(255)		Server name
SRV_NAME_ALIAS	VARCHAR(255)		Server name alias
LOG_UTTR_ENABLED	NUMERIC(1)		Specifies if utterance recording is enabled: 1 if utterance recording enabled, 0 otherwise
LOG_SYS_IS_ENABLED	NUMERIC(1)		Specifies if system DB logging is enabled: 1 if system DB logging enabled, 0 otherwise
LOG_CUS_IS_ENABLED	NUMERIC(1)		Specifies if custom DB logging is enabled: 1 if custom DB logging enabled, 0 otherwise
SRV_CRT_TS	NUMBER(14)		Server creation timestamp
SRV_CRT_DAY_ID	NUMBER(8)		Server creation day ID – YYYYMMDD
SRV_CRT_MINUTE_ID	NUMBER(4)		Server creation minute ID – HHMM
SRV_MOD_TS	NUMBER(14)		Server modification timestamp
SRV_MOD_DAY_ID	NUMBER(8)		Server modification day ID – YYYYMMDD
SRV_MOD_MINUTE_ID	NUMBER(4)		Server modification minute ID – HHMM
SRV_OWN_ACC_GUID	CHAR(40)		Server owner account ID
SRV_MOD_ACC_GUID	CHAR(40)		Server modification account ID
SRV_SDSC	VARCHAR(4000)		Server short description
SRV_LDSC	VARCHAR(4000)		Server comment
SRV_IDSC	VARCHAR(4000)		Server error description
SRV_VDSC	VARCHAR(4000)		Server version description
SRV_KYWRDS	VARCHAR(4000)		Server keywords
SRV_SES_LMT	NUMBER(6)		Maximum number of concurrent sessions for this server
GRP_SES_LMT	NUMBER(6)		Maximum number of concurrent sessions for the cluster group
REQ_SES_GAR	NUMBER(8)		Requested guaranteed sessions
LOG_CC_LOGINTERVAL	NUMBER(9)		Specified Control Center snapshot interval
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDSTYPE	Lookup table for input subtypes / one record per subtype and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
DS_INP_STYPE	NUMBER(3)	X	Input subtype ID
INP_STYPE_DESC	VARCHAR(255)		Name of the subtype (e.g. Confirmation. Collection, etc.) LOCALIZED
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDSUBSEQ	Lookup table for module subsequences / one record per subsequence
Column Name	Data Type	Primary Key	Description
MOD_SEQ_SID	NUMBER(9)	X	Module sequence surrogate ID
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID
VSC_SID	NUMBER(6)	X	Service surrogate ID
SITE_SID	NUMBER(4)	X	Site surrogate ID
MOD_START_SID	NUMBER(6)	X	Surrogate ID of the first module in this subsequence
MOD_START_NAME	VARCHAR(255)		Name of the first module in this subsequence
MOD_END_SID	NUMBER(6)	X	Surrogate ID of the last module in this subsequence
MOD_END_NAME	VARCHAR(255)		Name of the last module in this subsequence
POS_IN_SEQ	NUMBER(3)	X	Position of the start module in the sequence
MOD_SUBSEQ_COUNT	NUMBER(3)	X	Number of modules between the start and end module of this subsequence
MOD_SEQ_COUNT	NUMBER(3)		Number of modules in the subsequence including start and end module
MOD_SET_COUNT	NUMBER(3)		Number of modules in the set derived from the subsequnce
MOD_SUBSEQ_MODNAME	VARCHAR(2000)		Comma-separated list of the names of the modules between the start and end module of this subsequence
MOD_SEQ_REFID	VARCHAR(4000)		Comma-separated list of module reference IDs of the module subsequence
MOD_POS2_SID	NUMBER(6)		Surrogate ID of the second module in the subsequence
MOD_POS3_SID	NUMBER(6)		Surrogate ID of the third module in the subsequence
MOD_POS4_SID	NUMBER(6)		Surrogate ID of the fourth module in the subsequence
MOD_POS5_SID	NUMBER(6)		Surrogate ID of the fifth module in the subsequence
MOD_POS6_SID	NUMBER(6)		Surrogate ID of the sixth module in the subsequence
MOD_SUBSEQ_OCCUR	NUMBER(3)		Occurrence ordinal of this subsequence in the module sequence
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDTASK	Lookup table for business tasks / one record per business task
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
TASK_SID	NUMBER(6)	X	Business task surrogate ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
SITE_SID	NUMBER(6)	X	Site surrogate ID – relates to lookup table VOLDSITOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
TASK_NAME	VARCHAR(255)		Business task name
TASK_GUID	CHAR(40)		Business task GUID
TASK_REFID	VARCHAR(255)		Business task reference ID
TASK_CRT_TS	NUMBER(14)		Business task creation timestamp
TASK_CRT_DAY_ID	NUMBER(8)		Business task creation day ID – YYYYMMDD
TASK_CRT_MINUTE_ID	NUMBER(4)		Business task creation minute ID – HHMM
TASK_MOD_TS	NUMBER(14)		Business task modification timestamp
TASK_MOD_DAY_ID	NUMBER(8)		Business task modification day ID – YYYYMMDD
TASK_MOD_MINUTE_ID	NUMBER(4)		Business task modification minute ID – HHMM
TASK_OWN_ACC_GUID	CHAR(40)		Business task owner account ID
TASK_MOD_ACC_GUID	CHAR(40)		Business task modification account ID
TASK_TYPE_ID	NUMBER(2)		Business task type ID – relates to lookup table VOLDTASKTYPE
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDTASKCMPL	Lookup table for business task completion types / one record per completion type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
TASK_CMPL_ID	NUMBER(6)	X	Completion type ID
TASK_CMPL_DSC	VARCHAR(30)		Completion type description (LOCALIZED)
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDTASKDATA	Fact table for business task parameter data / one record per session per business task and parameter
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)		Metadata Repository ID
SRV_SID	NUMBER(5)		Server surrogate ID – relates to lookup table VOLDSRVOBJ
SITE_SID	NUMBER(6)		Site surrogate ID – relates to lookup table VOLDSITOBJ
VSC_SID	NUMBER(6)		Service surrogate ID – relates to lookup table VOLDVSCOBJ
DLG_ID	CHAR(44)	X	Unique dialog ID
MASTER_DLG_ID	CHAR(44)		Dialog ID of the master session of this session. If no service chaining is used, will be the same as DLG_ID.
MONTH_ID	NUMBER(6)		Month ID for this business task – YYYYMM
DAY_ID	NUMBER(8)		Day ID for this business task – YYYYMMDD
MINUTE_ID	NUMBER(4)		Minute ID for this business task – HHMM
SECOND_ID	NUMBER(2)		Second ID for this business task – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
TASK_SID	NUMBER(6)	X	Business task surrogate ID
TASK_COUNTER	NUMBER(3)	X	Consecutive number of multiple executions of the same task
TASK_STATUS_ID	NUMBER(6)		Business task status ID – relates to lookup table VOLDTASKSTATUS
TASK_TYPE_ID	NUMBER(6)		Business task type ID – relates to lookup table VOLDTASKTYPE
DATA_KEY	VARCHAR(255)	X	Parameter name
DATA_VAL_ALPHA	VARCHAR(2000)		Parameter value as alphanumeric string
DATA_VAL_NUM	DOUBLE		Parameter value if the value is numeric, 0 otherwise.
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDTASKSTATS	Fact table for business task statistics/ one record per session and business task
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
SITE_SID	NUMBER(4)	X	Site surrogate ID
VSC_SID	NUMBER(6)	X	Service surrogate ID – relates to lookup table VOLDVSCOBJ
VSC_UID	NUMBER(7)		Service unique ID – unique ID for each deployment or restore action
DLG_ID	CHAR(44)	X	Unique dialog ID
MASTER_DLG_ID	CHAR(44)		Dialog ID of the master session of this session. If no service chaining is used, will be the same as DLG_ID.
TASK_SID	NUMBER(6)	X	Business task surrogate ID
TASK_COUNTER	NUMBER(3)	X	Consecutive number of multiple executions of the same task
TASK_START_TS	NUMBER(14)		Business task start time
MONTH_ID	NUMBER(6)		Month ID for this business task – YYYYMM
DAY_ID	NUMBER(8)		Day ID for this business task – YYYYMMDD
MINUTE_ID	NUMBER(4)		Minute ID for this business task – HHMM
SECOND_ID	NUMBER(2)		Second ID for this business task – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
TASK_END_TS	NUMBER(14)		Business task end time
TASK_DUR_ACTIVE	NUMBER(10)		Duration this task was active in milliseconds
TASK_DUR_INACTIVE	NUMBER(10)		Duration this task was inactive in milliseconds
NO_PHASES_ACTIVE	NUMBER(3)		Number of times this task was active
NO_PHASES_INACTIVE	NUMBER(3)		Number of times this task was inactive
TASK_STATUS_ID	NUMBER(6)		Task status ID – relates to lookup table VOLDTASKSTATUS.
IMPLICIT_FINISH	NUMBER(1)		0 if the task was explicitly terminated, 1 otherwise
START_MODULE_SID	NUMBER(6)		SID of the module where this task was started
END_MODULE_SID	NUMBER(6)		SID of the module where this task was finished
START_DS_STEP	NUMBER(3)		Counter of the input state where this task was started
END_DS_STEP	NUMBER(3)		Counter of the input state where this task was finished
DLG_EXIT_TYPE_ID	NUMBER(3)		Dialog exit type ID – relates to lookup table VOLDEXTTYP
NO_DS_STEPS	NUMBER(3)		Number of input states – will be filled, even if Input State logging is disabled
NO_DS_STEPS_VOICE	NUMBER(3)		Number of input states with a successful recognition of voice input
NO_DS_STEPS_DTMF	NUMBER(3)		Number of input states with a successful recognition of DTMF input
NO_DS_STEPS_TEXT	NUMBER(3)		Number of input states with a successful recognition of text input
NO_MODULES	NUMBER(3)		Number of modules used for this business task – corresponds to NO_MODULES in table VOLDMODSEQ
NO_DIST_MODULES	NUMBER(3)		Number of distinct modules used for this business task
NO_TASKS	NUMBER(3)		Always 1
NO_NI	NUMBER(3)		Number of No Input events
NO_NM	NUMBER(3)		Number of No Match events
NO_NM_BARGEIN	NUMBER(3)		Number of No Match events triggered with barge-in
NO_NM_NOBARGEIN	NUMBER(3)		Number of No Match events triggered without barge-in
NO_NM_VOICE	NUMBER(3)		Number of No Match events with input mode voice
NO_NM_VOICE_BARGEIN	NUMBER(3)		Number of No Match events with input mode voice triggered with barge-in
NO_NM_VOICE_NOBARGEIN	NUMBER(3)		Number of No Match events with input mode voice triggered without barge-in
NO_NM_DTMF	NUMBER(3)		Number of No Match events with input mode DTMF
NO_NM_DTMF_BARGEIN	NUMBER(3)		Number of No Match events with input mode DTMF triggered with barge-in
NO_NM_DTMF_NOBARGEIN	NUMBER(3)		Number of No Match events with input mode DTMF triggered without barge-in
NO_NI_1	NUMBER(3)		Number of input states with at least one No Input event
NO_NI_2	NUMBER(3)		Number of input states with at least two No Input events
NO_NI_3	NUMBER(3)		Number of input states with at least three No Input events
NO_NI_4	NUMBER(3)		Number of input states with at least four No Input events
NO_NM_1	NUMBER(3)		Number of input states with at least one No Match event
NO_NM_2	NUMBER(3)		Number of input states with at least two No Match events
NO_NM_3	NUMBER(3)		Number of input states with at least three No Match events
NO_NM_4	NUMBER(3)		Number of input states with at least four No Match events
NO_HLP	NUMBER(3)		Number of help events
NO_RPTS	NUMBER(3)		Number of repeat commands
NO_NOTIFICATIONS	NUMBER(3)		Number of notifications sent (SNMP or e-mail)
NO_HYPERLINKS	NUMBER(3)		Number of hyperlinks triggered per dialog
NO_BACK	NUMBER(3)		Number of back commands
NO_FORWARD	NUMBER(3)		Number of forward commands
NO_SKIP	NUMBER(3)		Number of skip commands
PAUSE_DURATION_MS	NUMBER(8)		Duration in milliseconds that the dialog was in pause mode
NO_DS_IMMEDREC	NUMBER(3)		Number of input states with an immediate recognition (i.e. a recognition event without one of the following events: No Match, No Input, error, disconnect, help, repeat)
NO_DS_NONIMMEDREC	NUMBER(3)		Number of input states with a non- immediate recognition (i.e. a recognition event with one of the following events: No Match, No Input, error, disconnect, help, repeat)
NO_DS_SUCCESS	NUMBER(3)		Number of successful input states (i.e. input states that finished with a recognition event)
NO_DS_NONSUCCESS	NUMBER(3)		Number of unsuccessful input states (i.e. input states that finished without a recognition event)
NO_DS_NOMATCH	NUMBER(3)		Number of input states with at least one No Match event
NO_DS_NOMATCH_BARGEIN	NUMBER(3)		Number of input states with at least one No Match event that was triggered with barge-in
NO_DS_NOMATCH_NOBARGEIN	NUMBER(3)		Number of input states with at least one No Match event that was triggered without barge-in
NO_DS_NM_VOICE	NUMBER(3)		Number of input states with at least one No Match voice event
NO_DS_NM_VOICE_BARGEIN	NUMBER(3)		Number of input states with at least one No Match voice event that was triggered with barge-in
NO_DS_NM_VOICE_NOBARGEIN	NUMBER(3)		Number of input states with at least one No Match voice event that was triggered without barge-in
NO_DS_NM_DTMF	NUMBER(3)		Number of input states with at least one No Match DTMF event
NO_DS_NM_DTMF_BARGEIN	NUMBER(3)		Number of input states with at least one No Match DTMF event that was triggered with barge-in
NO_DS_NM_DTMF_NOBARGEIN	NUMBER(3)		Number of input states with at least one No Match DTMF event that was triggered without barge-in
NO_DS_NOINPUT	NUMBER(3)		Number of input states with at least one No Input event
NO_DS_INV_ANS_LMT	NUMBER(3)		Number of input states in which invalid answer limit was reached
NO_EXIT	NUMBER(3)		Number of exit commands
NO_PAUSE	NUMBER(3)		Number of pause commands
NO_REC	NUMBER(3)		Number of recordings for this business task
REC_SIZE	NUMBER(10)		Complete size of all recordings during this business task in kilobyte
REC_DUR_MS	NUMBER(10)		Complete duration of all recordings during this business task in milliseconds
NO_ERRS	NUMBER(3)		Number of errors
NO_ERRS_MP	NUMBER(3)		Number of media platform errors
NO_ERRS_INTERNAL	NUMBER(3)		Number of internal errors
NO_ERRS_SCRIPT	NUMBER(3)		Number of script errors
NO_ERRS_CONNECTOR	NUMBER(3)		Number of connector errors
NO_CONNECTOR _EXECS	NUMBER(3)		Number of Connector object executions while the task was active
CONN_EXEC_TIME_TOT	NUMBER(8)		Cumulated execution time of all Connector objects while the task was active in milliseconds
CONN_EXEC_TIME_MIN	NUMBER(8)		Shortest Connector object execution time while the task was active in milliseconds
CONN_EXEC_TIME_MAX	NUMBER(8)		Longest Connector object execution time while the task was active in milliseconds
NO_SCRIPT_EXECS	NUMBER(3)		Number of Script object executions while the task was active
SCRT_EXEC_TIME_TOT	NUMBER(8)		Cumulated execution time of all Script objects while the task was active in milliseconds
SCRT_EXEC_TIME_MIN	NUMBER(8)		Shortest Script object execution time while the task was active in milliseconds
SCRT_EXEC_TIME_MAX	NUMBER(8)		Longest Script object execution time while the task was active in milliseconds
NO_DB_EXECS	NUMBER(3)		Number of Database object executions while the task was active
DB_EXEC_TIME_TOT	NUMBER(8)		Cumulated execution time of all Database objects while the task was active in milliseconds
DB_EXEC_TIME_MIN	NUMBER(8)		Shortest Database object execution time while the task was active in milliseconds
DB_EXEC_TIME_MAX	NUMBER(8)		Longest Database object execution time while the task was active in milliseconds
NO_BRGD_TRANS	NUMBER(3)		Number of successful bridged transfers
NO_BRGD_TRANS_FAIL	NUMBER(3)		Number of failed bridged transfers
NO_CONSULT_TRANS	NUMBER(3)		Number of successful consultation transfers
NO_CNSL_TRANS_FAIL	NUMBER(3)		Number of failed consultation transfers
NO_BLIND_TRANS	NUMBER(3)		Number of successful blind transfers
TRANS_DUR_MS	NUMBER(10)		Complete duration of all transfers during this business task in milliseconds
HAS_TASKDATA	NUMBER(1)		1 if parameter data was available for this business task, 0 otherwise
NO_REQUESTS	NUMBER(3)		Number of requests executed by VoiceObjects Server
VOL_BYTES	NUMBER(8)		Data volume sent by VoiceObjects Server in bytes
CHANNEL_ID	NUMBER(3)		ID of the channel that is configured for this service – relates to lookup table VOLDCHANNEL
AVG_CONF_VOICE	NUMBER(3,2)		Average confidence level for all input states in this session
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDTASKSTATUS	Lookup table for business task statuses / one record per status and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
TASK_STATUS_ID	NUMBER(6)	X	Business task status ID
TASK_STATUS_DSC	VARCHAR(30)		Business task status description (LOCALIZED)
TASK_CMPL_ID	NUMBER(6)		Completion type ID – relates to lookup table VOLDTASKCMPL
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDTASKTYPE	Lookup table for business task types / one record per type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
TASK_TYPE_ID	NUMBER(6)	X	Business task type ID
TASK_TYPE_DSC	VARCHAR(30)		Business task type description (LOCALIZED)
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDTRCAT	Lookup table for transition categories / one record per transition category and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
DS_TR_CAT_ID	NUMBER(3)	X	Transition category ID
DS_TR_CAT_DESC	VARCHAR(255)		Name of the transition category (LOCALIZED)
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDTRTYPE	Lookup table for transition types / one record per transition type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
DS_TR_TYPE	NUMBER(3)	X	Transition type ID
DS_TR_DESC	VARCHAR(255)		Name of the transition type (e.g. Recognition, Event, etc.) LOCALIZED
DS_TR_CAT_ID	NUMBER(3)		Transition category ID. Relates to lookup table VOLDTRCAT
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDVSCOBJ	Lookup table for Service object / one record per object
Column Name	Data Type	Primary Key	Description
MD_REP_SID	NUMBER(3)	X	Metadata Repository ID
SITE_SID	NUMBER(4)		Site surrogate ID
SITE_GUID	CHAR(40)		Site GUID
SRV_SID	NUMBER(5)	X	Server surrogate ID – relates to lookup table VOLDSRVOBJ
VSC_SID	NUMBER(6)	X	Service surrogate ID
VSC_UID	NUMBER(7)	X	Service unique ID – unique ID for each deployment or restore action
VSC_UID_KEY	CHAR(40)		Unique key for each deployment or restore action
VSC_GUID	CHAR(40)		Service GUID
VSC_REFID	VARCHAR(255)		Service reference ID
VSC_NAME	VARCHAR(255)		Service name
VSC_NAME_ALIAS	VARCHAR(255)		Service name alias
VSC_CRT_TS	NUMBER(14)		Service creation timestamp
VSC_CRT_DAY_ID	NUMBER(8)		Service creation day ID – YYYYMMDD
VSC_CRT_MINUTE_ID	NUMBER(4)		Service creation minute ID – HHMM
VSC_MOD_TS	NUMBER(14)		Service modification timestamp
VSC_MOD_DAY_ID	NUMBER(8)		Service modification day ID – YYYYMMDD
VSC_MOD_MINUTE_ID	NUMBER(4)		Service modification minute ID – HHMM
VSC_OWN_ACC_GUID	CHAR(40)		Service owner account ID
VSC_MOD_ACC_GUID	CHAR(40)		Service modification account ID
VSC_SDSC	VARCHAR(4000)		Service short description
VSC_LDSC	VARCHAR(4000)		Service comment
VCS_IDSC	VARCHAR(4000)		Service error description
VSC_VDSC	VARCHAR(4000)		Service version description
VSC_KYWRDS	VARCHAR(4000)		Service keywords
SVC_SES_LMT	NUMBER(6)		Maximum number of concurrent sessions for the service (-1 if no limit is defined)
REQ_SES_GAR	NUMBER(8)		Requested session guarantee (-1 if no guarantee is requested)
CHANNEL_ID	NUMBER(3)		ID of the channel that is configured for this service – relates to lookup table VOLDCHANNEL
DRIVER_ID	NUMBER(3)		Media platform driver ID as specified in the Service object – relates to lookup table VOLDDRIVER
LOG_COVERAGE	NUMBER(3)		The specified log coverage in percent, e.g. 70 (corresponds to a log coverage of 70%)
LOG_UTTR_ENABLED	NUMBER(1)		Specifies if utterance recording is enabled: 1 if utterance recording enabled, 0 otherwise
LOG_UTTR_COVERAGE	NUMBER(3)		The specified utterance recording coverage in percent, e.g. 70 (corresponds to a log coverage of 70%)
LOG_SYS_IS_ENABLED	NUMBER(1)		Specifies if system DB logging is enabled: 1 if system DB logging is enabled, 0 otherwise
LOG_CUS_IS_ENABLED	NUMBER(1)		Specifies if custom DB logging is enabled: 1 if custom DB logging is enabled, 0 otherwise
LOG_DS_IS_ENABLED	NUMBER(1)		Specified if Input State logging is enabled: 1 of input state logging is enabled, 0 otherwise
LOG_FILTERSCP_ID	NUMBER(1)		Specified the logging filter scope – relates to lookup table VOLDLOGSCOPE
IS_CURRENT	NUMBER(1)		Identifies if this record is the current one: 1 if this record is the current one, 0 otherwise
VSC_DEPL_DUR	NUMBER(12)		The duration in seconds, that this deployment was active. This column is not filled for a current deployment.
VSC_HAS_SLA	NUMBER(1)		Specifies if the service has active Service Level Agreements: 1 if it has Service Level Agreements, 0 otherwise
DAY_ID	NUMBER(8)		Day ID for the time of the deployment – YYYYMMDD
MINUTE_ID	NUMBER(4)		Minute ID for the time of the deployment – HHMM
SECOND_ID	NUMBER(2)		Second ID for the time of the deployment – SS
UTC_OFFSET	CHAR(6)		Time zone offset to UTC (e.g. “-05:00”)
VSC_TYPE_ID	NUMBER(2)		Type of the deployment – relates to lookup table VOLDVSCTYPE
VSC_DEPLCOM_ID	NUMBER(2)		Command that was used for deployment – relates to lookup table VOLDDEPLCOM
SO_PRO_GUID	CHAR(40)		GUID of the deployed project
SO_PRO_NAME	VARCHAR(255)		Name of the deployed project
SO_PRO_SDSC	VARCHAR(4000)*		Short description of the deployed project
SO_PROV_GUID	VARCHAR(255)		GUID of the deployed project version
SO_PROV_NAME	VARCHAR(255)		Name of the deployed project version
SO_PROV_SDSC	VARCHAR(4000)*		Short description of the deployed project version
SO_OBJ_GUID	CHAR(40)		GUID of the deployed start object
SO_OBJ_REFID	VARCHAR(255)		Reference ID of the deployed start object
SO_OBJ_NAME	VARCHAR(255)		Name of the deployed start object
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDVSCTYPE	Lookup table for service types / one record per service type and locale
Column Name	Data Type	Primary Key	Description
LOCALE_ID	NUMBER(2)	X	Specifies the language of the description
VSC_TYPE_ID	NUMBER(3)	X	Service Type ID
VSC_TYPE_NAME	VARCHAR(255)		Service Type Name
ROW_TS	DATE		Row timestamp – exact timestamp when the record was written into the DB

VOLDSEQVSCUID	For internal use only
Column name	Data Type	Primary Key	Description
NEXTVAL	NUMBER(9)		For internal use only

VOLDSEQREPSRCSID	For internal use only
Column name	Data Type	Primary Key	Description
NEXTVAL	NUMBER(3)		For internal use only