How long data takes to reach a report, by stage.
| Stage | Typical time |
|---|---|
| Practice management system to Aiwyn — all integrations other than CCH Axcess | Approximately every 5 |
| Practice management system to Aiwyn — CCH Axcess via DAU | Every 4 hours, starting at 5 a.m. local time |
| Aiwyn to the reporting data warehouse | About 60 minutes |
| Reporting data warehouse to report | Live — reports query the warehouse directly and are not cached |
Once data reaches Aiwyn, it appears in a report within about an hour. For CCH Axcess firms, the practice management system sync runs every 4 hours, starting at 5 a.m. local time; allow about another hour for the data to reach reports.
Billing Performance, Employee Performance, and Payment Performance query the reporting data warehouse live and are not cached. Reports do not have a last-updated indicator.
If a processing run fails
Processing runs in hourly batches. If a run fails, that hour’s update does not reach reports, which continue to show data from the last successful run. The next successful run resumes from where the last one left off and picks up the missed data. Records are not dropped individually, and the delay is typically an hour or two.
Failed runs are monitored internally. Reports do not indicate when a run has failed or show a last-updated time.
Related
- Where report data comes from and which system is your source of truth
- Check why a report figure does not match your practice management system