Notifications
Clear all
Topic starter
We were looking for a crystal report that will show all the appointments made/modified after a particular date in time? For example,run a report to show all the changes made to your schedules as of 12:27 this afternoon? Also looking back at that booked appt. what changes were made to it. e.g. moved by back a week.
Posted : September 10, 2014 6:55 am
There is no XID field in the appointment for old values. You could probably pull that information up in the audit log but I don't know how to report on it. We interface our APPT with our GM system and all changes to appointments are done there and get pushed through linklogic. It looks like when a change is made in our system (I do not know if it is the same for everyone), the old appointment is cancelled and the new one is created which gives you 2 records to work with. If you sort the below report by Patient name you can see cancelled appointments together with new appointments.
It is basing the criteria on any change made to the record (including comments, reason, etc) so it is not necessarily a schedule change.
I am excluding any appointments that are arrived or noshow as simply changing to either of these statuses changes the update date which is not what you wanted to report on.
Posted : September 17, 2014 2:49 am
