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, M0420_Assess, Pain1, Pain2, Pain3, pain4, Pain5, Inpatient_Discharge_Date_NA_M0180, Dress_Upper_M0650, Medical_or_Treatment_Change_M0200, Surgical_Wound_M0482, Hearing_M0400, Speech_M0410, Surgical_Wound_OB_M0484, Open_Wounds_M0440, Pressure_Ulcer_M0445, Pressure_Ulcer_a_M0450, Pressure_Ulcer_b_M0450, Pressure_Ulcer_c_M0450, Pressure_Ulcer_d_M0450, Vision_M0390, Eating_M0710, Eating_M0710p, Meal_Prep_M0720, Meal_Prep_M0720p, Pressure_Ulcer_Stage_M0460, Stasis_Ulcer_Num_M0470, Stasis_Ulcer_Hidden_M0474, Stasis_Ulcer_Status_M0476, Surgical_Wound_Status_M0488, Breathing_M0490, Urinary_INcont_M0520, Resp_Treatments_M0500, Freq_of_Pain_M0420, Transport_M0730, Transport_M0730p, Laundry_M0740, Laundry_M0740p, Housekeeping_M0750, Assessment_note, Record_Created_By, Transmission_status 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#' pat = CreateObject("Component", "assessment"); get_pain_que = pat.get_pain_ques('1 - Start of care - further visits planned','pain');

#DateFormat(AssForm.Start_of_Care_M0030,'mm/dd/yyyy')# - SN Pediatric Form

Other Services Involved (By Current Agency)

Other Agencies Involved