request.general = CreateObject("component","components.general.general").init(); request.ass = CreateObject("component","components.general.assessments").init(); request.soc_wizard = CreateObject("component","components.general.soc_wizard").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#); getparentass = request.ass.get_assess(#url.ID#,#AssForm.parent_id#); SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Status = AND Patient_ID = AND Admit_ID = ORDER BY F178 DESC 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 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 #form.assessment_type#
Back