request.general = CreateObject("component","components.general.general").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'); SELECT pAssessments.*,pPatients.*, CASE WHEN F26 = '1 - Start of care - further visits planned' THEN "1 - SOC - SN" WHEN F26 = '1 - Start of care - further visits planned - Physical Therapy' THEN "1 - SOC - PT" WHEN F26 = '3 - Resumption of care (after inpatient stay' THEN "3 - ROC - SN" WHEN F26 = '4 - Recertification (follow-up) reassessment' THEN '4 - Recertification' WHEN F26 = '4 - Recertification (follow-up) reassessment - PT' THEN '4 - Recertification PT' WHEN F26 = '4 - Recertification (follow-up) reassessment - OT' THEN '4 - Recertification OT' WHEN F26 = 'PT Adult Evaluation' THEN "PT Eval" WHEN F26 = 'OT Adult Evaluation' THEN "OT Eval" WHEN F26 = 'ST Adult Evaluation' THEN "ST Eval" WHEN F26 = 'SN Adult Evaluation' THEN "SN Eval" WHEN F26 = 'MSW Evaluation' THEN "MSW Eval" WHEN F26 = 'PT Followup' THEN "PT FU Eval" WHEN F26 = 'OT Followup' THEN "OT FU Eval" WHEN F26 = 'ST Followup' THEN "ST FU Eval" WHEN F26 = 'MSW Followup' THEN "MSW FU Eval" WHEN F26 = 'SN Followup' THEN "SN FU Eval" WHEN F26 = 'Hospice Comprehensive' THEN "Hospice Comprehensive" WHEN F26 = 'SN Hospice' THEN "SN Hospice" WHEN F26 = 'Chaplain Comprehensive Evaluation' THEN "Chaplain Comprehensive Evaluation" WHEN F26 = 'Hospice Discharge' THEN "Hospice Discharge" WHEN F26 = '5 - Other follow-up' THEN "5 - Other follow-up" WHEN F26 = '6 - Transferred to an inpatient facility - patient not discharged from agency' THEN "6 - Transfer no discharge" WHEN F26 = '7 - Transferred to an inpatient facility - patient discharged from agency' THEN "7 - Transfer discharged" WHEN F26 = '8 - Death at home' THEN "8 - Death" WHEN F26 = '9 - Discharge from agency' THEN "9 - Discharge from agency" ELSE 0 END AS assesments FROM #Request.prefix_db_agency#.pAssessments INNER join #Request.prefix_db_agency#.pPatients ON pAssessments.patient_id = pPatients.patient_id WHERE pAssessments.Assmt_ID = AND pAssessments.Patient_ID = AND pAssessments.Status = 0 AND pPatients.Status < 2 SELECT pWoundsVitals.*,pWoundsVitals.ID AS woundsid FROM #Request.prefix_db_agency#.pWoundsVitals WHERE pWoundsVitals.Assmt_ID = AND pWoundsVitals.Status = 0 AND VitalOrWound = 'vital' ORDER BY pWoundsVitals.Item_ID ASC SELECT pWoundsVitals.*,pWoundsVitals.ID AS woundsid FROM #Request.prefix_db_agency#.pWoundsVitals JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pWoundsVitals.Assmt_ID AND pAssessments.Status = 0 WHERE pAssessments.Admit_ID = AND pWoundsVitals.Status = 0 AND VitalOrWound = 'wound' ORDER BY pWoundsVitals.Item_ID ASC SELECT Emp_Last, Emp_First, Skill_1, Skill_2, Skill_3 FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = '#Assform.Record_Created_By#' SELECT * FROM #Request.prefix_db_agency#.pAdmit JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Phys_ID = pAdmit.Render_Phys_ID WHERE pAdmit.Patient_ID = #session.cs.PATIENTID# AND pAdmit.Status = 0 ORDER BY pAdmit.M0030_START_CARE_DT DESC LIMIT 1 SELECT * FROM #Request.prefix_db_lookup#.#Request.assessment_questions_lookup# WHERE Deleted <> 1 AND assessment_reason = '#Request.assessmenttype#' AND answer_label != 'F175' ORDER BY wizard,order_id SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE patient_id = #AssForm.patient_id# SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE Status = 0 AND Assmt_ID = AND M0_No like 'M102%' ORDER BY dx_order ASC SELECT pSchedules.Visit_Date, pSchedules.Assmt_ID, pEmployee.Emp_First, pEmployee.Emp_Last, pEmployee.Skill_1, pEmployee.Skill_2, pEmployee.Skill_3 FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID WHERE pSchedules.Status = AND pSchedules.Patient_ID = '#session.cs.PATIENTID#' AND ( pSchedules.Assmt_ID = OR ( pSchedules.Visit_Type = '#AssForm.assesments#' AND pSchedules.Followup_visit = 1 ) ) ORDER BY CASE WHEN pSchedules.Assmt_ID = THEN 0 ELSE 1 END, pSchedules.Visit_Date DESC
#Assform.Pt_First# #Assform.Pt_Last# - DOB: #DateFormat(Assform.Pt_DOB,"mm/dd/yyyy")# #Request.assessmenttype#  - #DateFormat(printCompletedDate,"mm/dd/yyyy")#
' AND len(title) gt 6>
#title#
#title#
(#ques_identifier#) #questions# #Evaluate(Variables.cheked_value)# -
VITAL SIGNS
#(GetVitals.Description)# #GetVitals.Reading1# - #GetVitals.Notes#
No Vital Sign Records were Found
WOUNDS
#GetWounds.WoundType# Length: #Length# cm, Width:#Width# cm, Depth: #Depth# cm,
Severity: #HealingStage#,#GetWounds.Notes#
Location: #Location#
No Wound Records were Found
Comments #Assform.F175#


Physician Signature:
(#GetPhysician.Phys_First#,#GetPhysician.Phys_Last#,#GetPhysician.Phys_Credentials#)
Completed & Digitally Signed by #completed_by# on #DateFormat(printCompletedDate,"mm/dd/yyyy")#
Page #cfdocument.currentpagenumber# 6 - Transferred to an inpatient facility #Request.assessmenttype# for #AssForm.Pt_First# #AssForm.Pt_Last#