teachplan_component = CreateObject("Component", "teachplan"); get_Teach_diagnoses = teachplan_component.Get_Teach_diagnoses_list_employee(patient_id="#url.ID#", AgencyID="#session.AgencyID#", Assmt_ID="#url.AID#"); Groupby_Teach_diagnoses = teachplan_component.Groupby_Teach_diagnoses_list(patient_id="#url.ID#", AgencyID="#session.AgencyID#", Assmt_ID="#url.AID#"); SELECT CASE WHEN (pSchedules.Visit_Type = "1 - SOC - SN") THEN '1 - Start of care - further visits planned' WHEN (pSchedules.Visit_Type = "1 - SOC - PT" ) THEN '1 - Start of care - further visits planned - Physical Therapy' WHEN (pSchedules.Visit_Type = "1 - SOC - OT" ) THEN '1 - Start of care - further visits planned - Occupational Therapy' WHEN (pSchedules.Visit_Type = "3 - ROC - SN" || pSchedules.Visit_Type = "3 - ROC - PT") THEN '3 - Resumption of care (after inpatient stay)' WHEN (pSchedules.Visit_Type = "PT Eval" ) THEN 'PT Adult Evaluation' WHEN (pSchedules.Visit_Type = "OT Eval" ) THEN 'OT Adult Evaluation' WHEN (pSchedules.Visit_Type = "ST Eval" ) THEN 'ST Adult Evaluation' WHEN (pSchedules.Visit_Type = "SN Eval" ) THEN 'SN Adult Evaluation' WHEN (pSchedules.Visit_Type = "MSW Eval" ) THEN 'MSW Evaluation' WHEN (pSchedules.Visit_Type = "PT FU Eval" ) THEN 'PT Followup' WHEN (pSchedules.Visit_Type = "OT FU Eval" ) THEN 'OT Followup' WHEN (pSchedules.Visit_Type = "ST FU Eval" ) THEN 'ST Followup' WHEN (pSchedules.Visit_Type = "MSW FU Eval" ) THEN 'MSW Followup' WHEN (pSchedules.Visit_Type = "SN FU Eval" ) THEN 'SN Followup' WHEN (pSchedules.Visit_Type = "Hospice Comprehensive" ) THEN 'Hospice Comprehensive' WHEN (pSchedules.Visit_Type = "Hospice admission" ) THEN 'Hospice admission' WHEN (pSchedules.Visit_Type = "SN Hospice" ) THEN 'SN Hospice' WHEN (pSchedules.Visit_Type = "Chaplain Comprehensive Evaluation" ) THEN 'Chaplain Comprehensive Evaluation' WHEN (pSchedules.Visit_Type = "Hospice Discharge" ) THEN 'Hospice Discharge' WHEN (pSchedules.Visit_Type = "4 - Recertification" ) THEN '4 - Recertification (follow-up) reassessment' WHEN (pSchedules.Visit_Type = "4 - Recertification PT" ) THEN '4 - Recertification (follow-up) reassessment - PT' WHEN (pSchedules.Visit_Type = "4 - Recertification OT" ) THEN '4 - Recertification (follow-up) reassessment - OT' WHEN (pSchedules.Visit_Type = "5 - Other follow-up" ) THEN '5 - Other follow-up' WHEN (pSchedules.Visit_Type = "6 - Transfer no discharge" ) THEN '6 - Transferred to an inpatient facility - patient not discharged from agency' WHEN (pSchedules.Visit_Type = "7 - Transfer discharged" ) THEN '7 - Transferred to an inpatient facility - patient discharged from agency' WHEN (pSchedules.Visit_Type = "8 - Death" ) THEN '8 - Death at home' WHEN (pSchedules.Visit_Type = "9 - Discharge from agency" ) THEN '9 - Discharge from agency' ELSE 0 END AS assesments ,pSchedules.*,pAssessments.*,pEmployee.Emp_Last,pEmployee.Emp_First FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pSchedules.Assmt_ID = pAssessments.Assmt_ID JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID WHERE pSchedules.Status = 0 AND pAssessments.Status = 0 AND pSchedules.Patient_ID = #url.ID# AND pSchedules.Skill = '#URL.Skill#' AND Followup_visit = 1 GROUP by pSchedules.Schedule_ID
Teaching Plan for
#get_Teach_diagnoses.Pt_First# #get_Teach_diagnoses.Pt_Last#
Start of CareRecertificationResumption#get_Teach_diagnoses.Assessment_Reason_M0100# #DateFormat(get_Teach_diagnoses.Assessment_Completed_M0090,"mm/dd/yy")#

Prepared by #empname#

TABLE OF CONTENTS
Groupby_DiagnosesList = teachplan_component.Group_Diagnoses_list(patient_id="#url.ID#", AgencyID="#session.AgencyID#", Assmt_ID="#url.AID#",Pathway_type="#path_type#");
Diet - #Groupby_DiagnosesList.Dg_Diagnosis# DME/supplies - #Groupby_DiagnosesList.Dg_Diagnosis# #Groupby_DiagnosesList.Dg_Diagnosis#
get_TeachSkills_type_1 = teachplan_component.Pathway_ID_based(Patient_ID="#Groupby_DiagnosesList.Dg_Patient_ID#", Assmt_ID="#Groupby_DiagnosesList.Dg_Assmt_ID#", Diagnosis_ID="#Groupby_DiagnosesList.Dg_id#",ICD="#Groupby_DiagnosesList.Dg_ICD#",sym_prev="1"); SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills WHERE Diagnosis_ID= AND Patient_ID= AND Assmt_ID= AND ICD= AND Deleted=0 AND Pathway_Type NOT LIKE 'goal%' AND Pathway_Type NOT LIKE 'intervention%' AND Pathway_Type NOT LIKE 'Source%' AND Pathway_ID <> 0 AND ( Pathway_Type = '#get_TeachSkills_type_1.Pathway_Type#' OR ( Pathway_Type = 'Title' AND Step_ID=129 AND Line_ID=0 AND Diagnosis_ID = AND Pathway_ID <> 0 ) OR ( Pathway_Type = 'Title' AND Step_ID=0 AND Line_ID=0 AND Diagnosis_ID = AND Pathway_ID <> 0 ) ) ORDER BY Order_ID ASC
#get_TeachSkills_alldata_1.Explanation#
Groupby_DiagnosesList = teachplan_component.Group_Diagnoses_list(patient_id="#url.ID#", AgencyID="#session.AgencyID#", Assmt_ID="#url.AID#",Pathway_type="#path_type#");
#Groupby_DiagnosesList.Dg_Diagnosis#
get_TeachSkills_type = teachplan_component.Pathway_ID_based(Patient_ID="#Groupby_DiagnosesList.Dg_Patient_ID#", Assmt_ID="#Groupby_DiagnosesList.Dg_Assmt_ID#", Diagnosis_ID="#Groupby_DiagnosesList.Dg_id#",ICD="#Groupby_DiagnosesList.Dg_ICD#");

SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills WHERE Diagnosis_ID= AND Patient_ID= AND Assmt_ID= AND ICD= AND Deleted=0 AND Pathway_Type NOT LIKE 'goal%' AND Pathway_Type NOT LIKE 'intervention%' AND Pathway_Type NOT LIKE 'Source%' AND Pathway_ID <> 0 AND (Pathway_Type = '#get_TeachSkills_type.Pathway_Type#' OR ( Pathway_Type = 'Title' AND Step_ID=129 AND Line_ID=0 AND Diagnosis_ID = AND Pathway_ID <> 0 ) OR ( Pathway_Type = 'Title' AND Step_ID=0 AND Line_ID=0 AND Diagnosis_ID = AND Pathway_ID <> 0 ) )
#UCase(get_TeachSkills_alldata.Explanation)#
#UCase(get_TeachSkills_alldata.Explanation)#
#get_TeachSkills_alldata.Explanation#
#get_TeachSkills_alldata.Explanation# #get_TeachSkills_alldata.Explanation#
Teaching Plan for #get_Teach_diagnoses.Pt_First# #get_Teach_diagnoses.Pt_Last#
prepared by #empname#
page #cfdocument.currentpagenumber#

Cannot be reloaded. Please go back to coding wizard reportdashboard and please print report once again