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.  |