Notifications
Clear all
Topic starter
Hello - I was wondering if anyone knows where 'hidden' visits are stored in the Centricity database (Microsoft SQL Server). By hidden, I mean visits that are marked 'hide new visit' either from the Schedule or the Billing module.
In our setup - new visits are in the MIKPatientVisit table, and visits retrieved in practice management are in the PatientVisit table.
Thanks a bunch!
Jason
Posted : May 13, 2021 7:43 am
Hidden visits are in the appointments table. You would look at the HideNewVisit column for a 1, if they weren't hidden this will be NULL.
Here is a query to get you started.
Select Top 100 *
From Appointments
Where HideNewVisit IS NOT NULL
Posted : May 14, 2021 8:14 am
