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