Notifications
Clear all
Topic starter
is there a way to see how many statements have been send out between a certain time frame? example: how many statements have we sent from Jan 01 to Jun 01
Posted : June 22, 2012 1:24 am
You can query the ActivityLog table to get the list of statement dates that appear on the Payment Plan tab. Below pulls the name, id, date the statement was generated, and the criteria (if any) that generated the statement for dates from 01/01/2012 up to and including 06/01/2012.
SELECT dbo.FormatName(pp.Prefix, pp.First, pp.Middle, pp.Last, pp.Suffix) AS PatientName,
pp.PatientId,
al.Created,
al.Value2 AS Criteria
FROM PatientProfile pp
JOIN ActivityLog al ON pp.PatientProfileId = al.PatientProfileId
WHERE al.FunctionName LIKE '%Statements%'
AND al.Created >= '01/01/2012' AND al.Created < DATEADD(d,1,'06/01/2012')
Posted : July 3, 2012 6:20 am
