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.*, pAdmit.*, pEmployee.*, 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 = '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 INNER join #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID LEFT OUTER join #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pAdmit.Clinical_Manager WHERE pAssessments.Assmt_ID = AND pAssessments.Patient_ID = AND pPatients.status < 2 AND pAdmit.status = 0 AND pAssessments.status = 0 GROUP BY pAssessments.Assmt_ID 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 * FROM #Request.prefix_db_agency#.pSchedules INNER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID WHERE pSchedules.Assmt_ID = AND pSchedules.status = AND pSchedules.Initial_visit = 1 SELECT pSchedules.* , pEmployee.Emp_First, pEmployee.Emp_Last 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.Visit_Type = '#AssForm.assesments#' AND pSchedules.Followup_visit = 1 ORDER BY pSchedules.Visit_Date DESC select Emp_Last, Emp_First from #Request.prefix_db_lookup#.pEmployee where Emp_ID = '#Assform.Record_Created_By#' SELECT * FROM #Request.prefix_db_lookup#.assessment_questions_lookup WHERE Deleted <> 1 AND assessment_reason = '1 - Start of care - further visits planned' 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
#Assform.Pt_First# #Assform.Pt_Last# - DOB: #DateFormat(Assform.Pt_DOB,"mm/dd/yyyy")# 1 - Start Of Care#AssForm.F26#
#DateFormat(AssForm.F177,"mm/dd/yyyy")# - #DateFormat(AssForm.F178,"mm/dd/yyyy")#
completed #DateFormat(AssForm.F176,"mm/dd/yyyy")#
DIAGNOSIS
#getproblem.Description# #getproblem.Answer# -
#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
Completed & Digitally Signed by #completed_by# on #DateFormat(AssForm.F176,"mm/dd/yyyy")#
Page #cfdocument.currentpagenumber# SOC for #AssForm.Pt_First# #AssForm.Pt_Last#