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 ASSESSMENT_ID, Start_of_Care_M0030, After_Discharge_Services_M0880, M0650_Assess, M0810_Assess, Grooming_M0640p, Meal_Prep_M0720, Patient_Behav_freq_M0620, Home_Safety_Assess, Urinary_INcont_when_M0530, M0420_Assess, Emergent_Care_Reason_M0840, Grooming_M0640, Psy_Nursing_M0630, Assessment_Note, 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#'
#DateFormat(AssForm.Start_of_Care_M0030,'mm/dd/yyyy')# - MSW Adult Evaluation