Notifications
Clear all
Topic starter
Has anyone had experience pulling a report of all BMI's with their last date of service with the patient information?
Posted : October 29, 2019 4:56 am
Would be fairly straight-forward with Crystal. I guess, depending on your requirement for 'with the patient information'
Do you have Crystal Reports?
Posted : October 29, 2019 6:31 am
See T-SQL script below. Should work (CPS), but disclaimer, I haven't done a thorough job of testing it.
DECLARE @S DATE
SET @S = '1/1/2019'
SELECT DISTINCT P.PatientId, P.First, P.Last, P.Birthdate, O.OBSDATE AS ObservationDate, O.OBSVALUE AS BMI
FROM PatientProfile P
INNER JOIN OBS O ON O.PID = P.PId
INNER JOIN OBSHEAD H ON O.HDID = H.HDID
WHERE H.NAME = 'BMI'
AND CAST(O.OBSDATE AS DATE) >= @S
ORDER BY P.PatientId, O.OBSDATE
Posted : November 4, 2019 3:48 am
