Notifications
Clear all
Topic starter
Does anyone know of a way to track blocks in a schedule? I have tried previously to see who has entered a block with no luck. Our office manager has not asked if there is a way to track who removed a block that she entered. I told her that I did not know of a way but that I would ask here to see if anyone else knows how to track blocks.
Posted : September 1, 2015 3:22 am
If you use "New resource appointment" to block appointments, you can run reports based on Blocked Resource appointments
Posted : September 1, 2015 3:33 am
If you are running CPS, I have a sql script that will pull that information I can share.
Just let me know.
Posted : September 1, 2015 3:42 am
Hello! We are currently on CPS 12.0.7. I am able to track "Blocked apts" by running a report. Go to the Reports Module, +Schedule, Blocked appointments. I then just enter the criteria I am interested in running the report on.
Posted : September 1, 2015 3:58 am
Topic starter
We are not using a "New resource appointment". We do have CPS. I would love to try that sql script if you could share it with me! My e-mail is [email protected]
Posted : September 1, 2015 3:59 am
Here is the sql script.
Select a.ApptStart, at.Name,a.Notes, a.ApptKind , canceled=CASE When a.canceled = 1 THEN 'Yes' else 'no' end ,df.ListName AS Doctor,df1.ListName as Location , a.LastModifiedby, df2.ListName
,a.LastModified
from Appointments a
left outer join ApptType at on a.ApptTypeId = at.ApptTypeId
left outer join DoctorFacility df1 on a.FacilityId = df1.DoctorFacilityId
left outer join DoctorFacility df on a.ResourceId = df.DoctorFacilityId
left outer join DoctorFacility df2 on a.LastModifiedby = df2.LoginUser-- Specific Date -- Replace XX/XX/XXXX date to be searched
where CONVERT(varchar(10),a.ApptStart,101) = 'XX/XX/XXXX' and a.ApptKind = '5'--Specific Doc Search
AND df.last like '%XXX%' -- REPLACE XXX WITH LAST NAME OF DOCTORorder by a.ApptStart
Posted : September 1, 2015 4:17 am
Topic starter
Will the search in the Reports Module also show blocks that had been removed?
Posted : September 1, 2015 5:15 am
