Notifications
Clear all
Topic starter
FOR CPS 9.5
We have started using labels for specimen labeling. I've been asked if we can add the Date of Service on the label.
Can someone tell me how to add this to the current query:
/*Chart Label*/
SET NOCOUNT ON
SELECT dbo.FormatName(pp.Prefix, pp.First, pp.Middle, pp.Last, pp.Suffix) AS Name,
pp.PatientId,
pp.MedicalRecordNumber,
pp.Birthdate,
d.ListName AS Doctor,
fc.Description AS [Financial Class],
pp.Sex
FROM Appointments a
JOIN PatientProfile pp ON a.OwnerId = pp.PatientProfileId
LEFT JOIN DoctorFacility d ON a.DoctorId = d.DoctorFacilityId
LEFT JOIN Medlists fc ON pp.FinancialClassMID = fc.MedlistsId
WHERE ?SCHEDULE_APPOINTMENT.ITEMDATA.U? = a.AppointmentsId
Thank-you for any help.
Nancy
Posted : April 25, 2012 4:36 am
