Notifications
Clear all
Topic starter
Is there a way to run an audit on how many times an encounter form was used during specific dates? I see the "Form Component Activation Audit" that can be run but it only tells me which form components are active/inactive and I'm just trying to find out how many times a specific form was used.
Thanks
Mike
Posted : September 9, 2015 4:39 am
When you say "used," do you mean an encounter was opened that includes that form, or the form was literally used to enter data? I'm not sure there's a way to do it either way, but I figured I'd clarify before I start digging.
Posted : September 10, 2015 2:46 am
Below are SQL scripts you can use to Create Views in SQL to link to your crystal. This script is to get frequency for Document Types
SELECT * FROM ( SELECT DESCRIPTION, ABBR, COUNT(ABBR) AS FREQUENCY FROM ( SELECT DTID, DESCRIPTION, ABBR FROM dbo.[DOCUMENT] INNER JOIN dbo.DOCTYPES ON dbo.[DOCUMENT].DOCTYPE = dbo.DOCTYPES.DTID) AS GETCOUNTDATA GROUP BY DTID, ABBR, DESCRIPTION) AS POSTDATA ORDER BY FREQUENCY DESC
And this is probably the closest you are going to get for the frequency of Encounter Type
SELECT * FROM ( SELECT DESCRIPTION, COUNT(DESCRIPTION) AS FREQUENCY FROM ( SELECT NAME AS DESCRIPTION FROM dbo.[DOCUMENT] INNER JOIN dbo.ENCTYPE ON dbo.[DOCUMENT].DOCTYPE = dbo.ENCTYPE.DOCTYPEID) AS GETCOUNTDATA GROUP BY DESCRIPTION) AS POSTDATA ORDER BY FREQUENCY DESC
Posted : September 11, 2015 7:02 am
Here is one I've run to get a count of how many times a particular form was inserted:
select distinct dbms_lob.substr(new_val), count(dbms_lob.substr(new_val))
from ml.doccontb
where contb_time > '01-JUN-2013' and contb_time < '1-JUN-2014' and contb_action = 25 and upper(new_val) like '%OUT-Adult Obesity%'
group by dbms_lob.substr(new_val)
order by dbms_lob.substr(new_val)
Posted : November 4, 2015 12:54 pm
