Notifications
Clear all
Topic starter
Anyone know of a specific query I can run to find the patient volume and the amount of documents in a CPS database? We're prepping for a major merge and a group that's helping us needs this information before they can move forward. Any help is appreciated.
Posted : September 8, 2015 3:49 am
Are you looking for a SQL query, or a query from the Inquiries module? The SQL queries are very simple:
SELECT COUNT(*) FROM PatientProfile
SELECT COUNT(*) FROM DOCUMENT
Posted : September 8, 2015 7:49 am
Topic starter
Ron,
Thanks for the answer. Shortly after posting this I actually found out that there was an inquiry for both within CPS by checking the status of each type.
Posted : September 9, 2015 3:44 am
