SELECT a.Assmt_ID, a.F176, 'admission status' as Admission_Status, '' as Admission_Description, '' as Transmission_Status, a.F26 ,a.F176, a.F177, a.F178, a.Assmt_ID,a.Assmt_ID,a.Patient_ID FROM #Request.prefix_db_agency#.pAssessments a WHERE a.Patient_ID = '#session.cs.patientid#' AND a.status != 1 AND a.F26 Not LIKE '' Order By a.F177 DESC, a.F176 ASC // request.loc = CreateObject("component","components.general.locations").init(); //get_loc = request.loc.get_locations(#client.loc_id#); request.pat = CreateObject("component","components.general.patients").init(); getadmit = request.pat.get_admit(#session.cs.patientid#); request.ass = CreateObject("component","components.general.assessments").init(); GetA = request.ass.get_assessments(#session.cs.patientid#);
Assessment SOC Completed Status Trans Status
#thereason# #DateFormat(F179,"mm/dd/yyyy")# #DateFormat(F176,"mm/dd/yyyy")# CompleteIncomplete dataset transmittednot transmitted