Notifications
Clear all
Trading Post
3
Posts
2
Users
0
Reactions
116
Views
Topic starter
How can I generate a list of documents that are on hold that also have unsigned clinical list changes?
Thanks!
Posted : August 14, 2014 6:17 am
I'm not certain, but this might provide the result set you're looking for:
SELECT p.patientid,p.First,p.Last
,dbo.Convert_ID_to_date(d.CLINICALDATE) AS DocumentDate
,d.SUMMARY
,d.STATUS
FROM DOCUMENT d
INNER JOIN PatientProfile p
ON d.PID=p.PId
WHERE d.STATUS='H'
AND p.masterlock IS NOT NULL
Justin
Posted : September 8, 2014 8:17 am
Topic starter
Thank you!
Posted : September 10, 2014 3:36 am
