Contents

This table contains records which are made when recordings from the IVR are sent by E-Mail or FTP. It must be used in conjunction with Table Reference - StatisticsPartR2

Fields

Field

Type

Meaning

ID

INT

A unique ID assigned to each record.

dtSent

TIMESTAMP

The date and time the recordings were sent.

ServiceNumbersID

INT

The ID of the ServiceNumber which was associated with the calls in which the recordings were made.

ClientsID

INT

The ID of the Client associated with the calls in which the recordings were made.

RoutingApplicationsID

INT

The ID of the routing application (Table RoutingApplications) associated with the calls in which the recordings were made.

RoutingApplicationFilesID

INT

The ID of the routing application version (Table RoutingApplicationFiles) associated with the calls in which the recordings were made.

RoutingApplicationObjectsID

INT

The ID of the routing application object in the application associated with the calls in which the recordings were made.

StorageType

VARCHAR

The type of storage which was requested. The following values are defined:

SaveRecordings.StorageType1 - SMTP

SaveRecordings.StorageType2 - FTP

IntervalType

VARCHAR

Internal field, for managing the job. Specifies the interval type which was selected in the IVR application.

FTPDirectory

VARCHAR

The FTP directory to which the recordings were saved for FTP uploads.

SMTPRecipient

VARCHAR

The SMTP recipient to which the recordings were sent for SMTP jobs.

SMTPSubject

VARCHAR

The email subject for SMTP jobs.

SMTPMessage

TEXT

The email message for SMTP jobs.

nCount

INT

The count of recordings sent.

Weekdays

VARCHAR

Internal field, for managing the job. Specifies the weekdays on which the job should be executed.

tTime

VARCHAR

Internal field, for managing the job. Specifies the time at which the job should be executed.

dtBeginDate

TIMESTAMP

Internal field, for managing the job. Specifies the begin date at which the job should be first executed.

dtDateTime

TIMESTAMP

The date and time at which the job was executed.

Fileformat

VARCHAR

The file format used when the job was sent.

The following values are defined: wav and mp3

bZIP

BOOLEAN

TRUE (1) if the recordings were sent as a ZIP file, FALSE (0) otherwise.

  • No labels