request.general = CreateObject("component","components.general.general").init(); request.soc_wizard = CreateObject("component","components.general.soc_wizard").init(); request.ass = CreateObject("component","components.general.assessments").init(); get_ass = request.general.get_answers('assessment_type','assessment_form'); getmess = request.general.get_messages('assessment_form'); AssForm = request.ass.get_assess(#url.ID#,#url.assid#); SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE (M0_No like 'M1021%' OR M0_No like 'M1023%') AND Assmt_ID IN () AND status = 0 ORDER BY dx_order ASC SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Status = AND Patient_ID = AND Admit_ID = ORDER BY F178 DESC request.pat = CreateObject("component","components.general.patients").init(); GetM = request.pat.medslist(#session.cs.patientid#); SELECT * FROM GetM WHERE Status = 0 AND N0415 IS NOT NULL SELECT * FROM GetM WHERE Status = 0 AND N0415 IS NULL UPDATE #Request.prefix_db_agency#.pAssessments SET F206 = , F207 = , F208 = , F209 = , F210 = , F211 = , F212 = , F213 = , F214 = , F215 = , F216 = , F217 = , F218 = , Record_Mod_Date = WHERE Assmt_ID = INSERT IGNORE INTO #Request.prefix_db_agency#.pg_files ( Agency_Id, Patient_Id, Schedule_ID, Title, FileName, FileType, Dup_file_name, CreatedBy ) VALUES ( '#session.AgencyId#' ,'#GetP.Patient_Id#' ,'#url.assid#' ,'Wounds_assessments' ,'#filename#' ,'#File.UPLOADALLRESULTS[i].ContentType#/#File.UPLOADALLRESULTS[i].ContentSubType#' ,'#Duplicate_file_name#' ,'#session.EmployeeId#' )
#GetP.Pt_Last#, #GetP.Pt_First# - Add #title#
Back