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 = '#session.cs.patientid#'
AND Agency_Id = '#session.AgencyId#'
SELECT *
FROM #Request.prefix_db_agency#.Assessment_New
WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#'
select Last_Name,First_Name from #Request.prefix_db_lookup#.Employee where Employee_ID = '#AssForm.Record_Created_By#'
#GetP.First_Name# #GetP.Last_Name#, Transfer Discharge