Televox Call Center Integration

Export Process

The Televox export process places a file once a day at 3:00am The file consists of appointment requests from the previous day where the kyruss campaign does not contain 600 or 1061. The export also have Televox response data to be called again if they met a certain criteria

Here is the Daily Export Process Steps

1. Gather the appointment requests rom the previous 24 hours where the Kyruus Campaign does not contain either 600 or 1061 and place those leads in the daily export DE called UPMC_Schedule_Appointment_DAILY
2. Append the Televox responded callback records to UPMC_Schedule_Appointment_DAILY that are in Televox_Schedule_Appointment_Callbacks
3. Extract data and place it onto Televox’s secure FTP
4. Update the reporting data in Televox_Schedule_Appointment_IDs with the data in UPMC_Schedule_Appointment_DAILY

Here is the Daily Import Process Steps

1. Clear out the previous day’s callback list
2. Import the Televox Responses into Televox_Daily_Response
3. Append the Televox_Daily_Response into Televox_All_Response
4. Import the Response into Televox_Schedule_Appointment_IDs
5. Import the quantity of calls into Televox_Schedule_Appointment_IDs
6. Populate Televox_Schedule_Appointment_Callbacks from Televox_Schedule_Appointment_IDs where the number of calls is < 3 and the Televox Response is not Invalid Phone Number, Answered – Called Receptionist, or Answered – No