Notifications
Clear all
Topic starter
Hello All,
I am trying to determine which "Document Types" within CPS EMR have zero documents indexed.
Is there a query tool that would help?
Thank you!
Luke
Posted : December 27, 2016 6:16 am
I usually use the Inquiries built into the EMR to find documents that were indexed. I look for documents with phrases in the document text that include "Imported By:" and "External Attachment:"
You can add other criteria to include document type, date, etc.
Posted : December 27, 2016 8:16 am
This query will give you a list of all your document attachments. If everything you use is DocuTrak (Document Management) this this will give you all the document types that HAVE been used. You could change this up to group and count to just get a list and then compare it to the document types you have set up in DocuTrak and see which haven't been used.
select e.moniker, e.description,dt.DESCRIPTION from extreferences e
left outer join DOCUMENT d on e.docid = d.sdid
left outer join DOCTYPES dt on d.doctype = dt.dtid
where e.REFERENCETYPE = 3
Posted : December 27, 2016 1:06 pm
