The Schedule Adherence calculations in PureConnect are done through the adherence DLL, not in SQL programing. We have struggled with the limitations this introduces to custom reporting but I believe there are some things you can leverage in calling the DLL for reporting. One of the big limitations was we could only call the DLL for one scheduling unit at a time.
It sounds like that may not help here as you're trying to using the logic elsewhere. I don't believe there is any posted documentation on this DLL and it's use, we had to contact support(development) for details on proper usage and available options.
Not sure if any of that helps, hope so.
------------------------------
Chris Mayo
Director, Technical Services
Altivon
------------------------------
Original Message:
Sent: 01-28-2019 13:46
From: James Shepherd
Subject: Schedule Adherence Reporting.
Has anyone calculated Schedule Adherence outside of Genesys. We pull data into an Athena Data lake and I have a need for a SQL statement or some direction on how to calculate Schedule Adherence per day per associate from the raw data. I have looked at the reports and found what I believe are the tables, but I can't figure out how it is calculated. Thanks in advance if someone can assist me.
#Reporting/Analytics
------------------------------
James Shepherd
The Coca-Cola CompanyCCNA
------------------------------