--->
#session.cs.AssessmentId#
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
Date_Most_Recent_M0903,
Date_Discharge_M0906,
Discharged_From_M0175,
Medical_or_Treatment_Change_M0200,
Conditions_Prior_M0220,
Therapies_Home_M0250,
Record_Created_By
FROM #Request.prefix_db_agency#.Assessment_New
where 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#, Discharge Non-OASIS