SELECT patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name,
Middle_Initial_M0040 AS Middle, Payer_ID
FROM #Request.prefix_db_agency#.patient
WHERE patient_ID =
#description# for #First_Name# #Last_Name#
SELECT pvd.Reading1, si.Visit_Date
FROM #Request.prefix_db_agency#.PatientVisitDetails pvd
LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New assN on assN.Assessment_Tracker_ID = pvd.Assessment_Tracker_ID
LEFT OUTER JOIN #Request.prefix_db_agency#.Scheduleitems si on si.Scheduleitems_ID = pvd.Scheduleitems_ID
WHERE pvd.patient_ID =
AND pvd.Assessment_Tracker_ID =
AND pvd.description = '#description#'
AND si.Visit_Date between assN.Certification_Start and assN.Certification_End
ORDER by si.Visit_Date