Notifications
Clear all
Topic starter
Is there a way I can run a report to see how long it takes a provider to sign a chart?
Posted : December 7, 2015 7:52 am
Topic starter
We have providers who do not sign charts in a timely manner and I need to track how long it takes them to sign a chart once the visit is done.
Posted : December 7, 2015 7:53 am
You can run this script, change the INPUT parts to the Patient ID and the Visit Document ID
SELECT dbo.Convert_ID_to_date(ClinicalDate) AS [Clinical Date], DB_CREATE_DATE AS [Date Created], DATEDIFF(DAY,DB_CREATE_DATE,(SELECT TOP 1 DB_CREATE_DATE FROM DOCCONTB WHERE SDID = DOCUMENT.SDID AND CONTB_ACTION IN (7,8))) AS [Days Until Signed]
FROM DOCUMENT
WHERE PID IN (SELECT PID FROM PatientProfile WHERE PatientId = 'INPUT PATIENT ID HERE') AND STATUS = 'S' AND VISDOCID = 'INPUT ID HERE'
Posted : December 7, 2015 8:04 am
Topic starter
Thank you I will try that!!!!
Posted : December 7, 2015 8:09 am
please refresh the forum, I forgot to add a section of my code, it should be correct now. Should be this:
SELECT dbo.Convert_ID_to_date(ClinicalDate) AS [Clinical Date], DB_CREATE_DATE AS [Date Created], DATEDIFF(DAY,DB_CREATE_DATE,(SELECT TOP 1 DB_CREATE_DATE FROM DOCCONTB WHERE SDID = DOCUMENT.SDID AND CONTB_ACTION IN (7,8))) AS [Days Until Signed] FROM DOCUMENT WHERE PID IN (SELECT PID FROM PatientProfile WHERE PatientId = 'INPUT PATIENT ID HERE') AND STATUS = 'S' AND VISDOCID = 'INPUT ID HERE'
Posted : December 7, 2015 8:15 am
