update #Request.prefix_db_agency#.Pathway_Details set Resolved_Date='#DateFormat(Now(),"yyyy-mm-dd")#' ,Record_Mod_Date='#DateFormat(Now(),"yyyy-mm-dd")#' ,Record_Modified_By='#session.EmployeeID#' WHERE Pathway_Details_Id in(#form.chkUnresolved#) update #Request.prefix_db_agency#.Pathway_Details set Resolved_Date = NULL ,Record_Mod_Date='#DateFormat(Now(),"yyyy-mm-dd")#' ,Record_Modified_By='#session.EmployeeID#' WHERE Pathway_Details_Id in(#form.chkresolved#) update #Request.prefix_db_agency#.Pathway_Details set Deleted = NULL ,Record_Mod_Date='#DateFormat(Now(),"yyyy-mm-dd")#' ,Record_Modified_By='#session.EmployeeID#' WHERE Pathway_Details_Id in(#form.chkdeleted#) update #Request.prefix_db_agency#.Pathway_Details set Deleted = 'Yes' ,Record_Mod_Date='#DateFormat(Now(),"yyyy-mm-dd")#' ,Record_Modified_By='#session.EmployeeID#' WHERE Pathway_Details_Id in(#form.chkundeleted#) UPDATE #Request.prefix_db_agency#.Pathway_Details set Deleted='yes' where patient_id = #Session.PID# AND assessment_id = #Session.AID# AND assessment_tracker_id = #Session.ATID# AND pathway_details_id = #url.pdid# SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name ,Middle_Initial_M0040 AS Middle, Payer_ID FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = AND Agency_Id = '#session.AgencyId#' SELECT Assessment_Tracker_ID, Assessment_Number, Start_of_Care_M0030, Resump_of_Care_M0032, Resump_of_Care_NA_M0032, Assessment_note, Assessment_Completed_M0090, Assessment_Reason_M0100, Discharged_From_M0175, Inpatient_Discharge_Date_M0180, Source_of_Admission, Admission_Description, Certification_Start, Certification_End, HIPPS_Code, SN_Visit_Orders, Therapy_Visit_Orders, HHA_Visit_Orders, Claim_Key, Information_Release, Deleted, Archive FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID = '#Session.AID#' SELECT a.agency_login, i.* FROM #Request.prefix_db_agency#.Interventions i left outer join Agency a on i.agency_id = a.agency_id where i.intervention_id = #ind#; INSERT INTO #Request.prefix_db_agency#.Pathway_Details ( agency_id, patient_id, assessment_id, assessment_tracker_id ,skill, item_number, intervention_code, description, type, name ,record_creation_date, created_by, Record_Mod_Date, Record_Modified_By, Care_Pathway ) VALUES ( '#getinterventions.agency_login#', '#session.cs.patientid#', '#session.AID#', '#geta.assessment_tracker_id#' ,'#getinterventions.skill#', '#getinterventions.intervention_id#', '#getinterventions.code#', '#getinterventions.intervention#', '#getinterventions.type#' ,'#getP.First_Name# #getP.Middle# #getP.Last_Name#' ,#CreateODBCDate(Now())#, '#Session.EmployeeID#', #CreateODBCDate(Now())#, '#Session.EmployeeID#', #getinterventions.Pathway_ID# ) SELECT pd.Pathway_Details_ID,pvd.Wnd_Type, pvd.Wnd_Stage,pd.Assessment_ID, pd.Skill, pd.Description, pd.Created_By, pd.assessment_id, pd.Record_Creation_Date, pd.Type as pd_type, pd.Pathway_Details_ID,pd.Assessment_Tracker_ID,pd.Care_Pathway, pd.M0_Answer as Diagnosis,si.Visit_Date,e.Last_Name, e.First_Name, pvd.Description as pvd_description,pvd.Wnd_Location,pvd.Performed,pvd.Severity,pvd.Notes,pvd.Reading1,pvd.Type as pvd_type,pvd.Reading2,pvd.Progress_Details_ID,pvd.Record_creation_date as pvdtest FROM #Request.prefix_db_agency#.Pathway_Details pd LEFT OUTER JOIN #Request.prefix_db_lookup#.Employee e on pd.Created_By = e.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.PatientVisitDetails pvd on pd.Pathway_Details_ID = pvd.Pathway_Details_ID LEFT OUTER JOIN #Request.prefix_db_agency#.ScheduleItems si on pvd.ScheduleItems_ID = si.ScheduleItems_ID WHERE pd.Assessment_ID = AND (pd.Skill = '#url.code#' or pd.Skill = 'SSN') AND (pd.Deleted IS NULL or pd.Deleted ='') AND pd.Resolved_Date IS NULL ORDER BY pd.Description ASC SELECT pd.Assessment_ID, pd.Skill, pd.Description, pd.Created_By, pd.Record_Creation_Date, pd.Type as pd_type,e.Last_Name, pd.Pathway_Details_ID,pd.Assessment_Tracker_ID,pd.M0_Answer as Diagnosis,si.Visit_Date, pd.Record_Modified_By,pd.Record_Mod_Date,pd.Resolved_Date,pd.Deleted, pvd.Description as pvd_description,pvd.Performed,pvd.Severity,pvd.Notes,pvd.Reading1,pvd.Type as pvd_type,pvd.Reading2,pvd.Progress_Details_ID FROM #Request.prefix_db_agency#.Pathway_Details pd LEFT OUTER JOIN #Request.prefix_db_lookup#.Employee e on pd.Record_Modified_By = e.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.PatientVisitDetails pvd on pd.Pathway_Details_ID = pvd.Pathway_Details_ID LEFT OUTER JOIN #Request.prefix_db_agency#.ScheduleItems si on pvd.ScheduleItems_ID = si.ScheduleItems_ID WHERE pd.Assessment_ID = AND pd.Skill = '#url.code#' GROUP BY pd.Description ORDER BY pd.Type,pd.Record_Creation_Date, pd.Description

pm = CreateObject("Component", "Menu"); myArgument = 'careplan'; pm.MenuFunction(myArgument,#getP.Patient_Id#,#Session.AID#,'','',#geta.assessment_tracker_id#);

Evidence-Based Clinical Best Practices Careplan Details for #getP.Last_Name#, #getP.First_Name# #getP.Middle#

Print CarePlan View New careplan

#GetA.Assessment_Reason_M0100# - #DateFormat(GetA.Certification_Start,'mmm dd, yyyy')# - #DateFormat(GetA.Certification_End,'mmm dd, yyyy')#

#title# Careplan Pink = Outcome Measures monitored by CMS

checked onclick="if (this.checked) detail=1;else detail=0;secureHREF('index.cfm?page=patient&cat=careplan&AID=#Session.AID#&ATID=#Session.ATID#&PID=#session.cs.enc_patientid#&code=#url.code#&detail='+detail);"> Show All Careplan Add Items from careplan database New Careplan Item - patient-specific Add Outcome Measures

SELECT ALL Delete Selected Item

Deleted Items Resolved Items

#item1# Save as Save as

SELECT * from GetPath where UPPER(pd_type) ='#ucase(item2)#'


>	or Care_Pathway EQ 24 or Care_Pathway EQ 26 or Care_Pathway EQ 28 or Care_Pathway EQ 29 or Care_Pathway EQ 30 or Care_Pathway EQ 33 > #Description# (#Pathway#) #Last_Name# #DateFormat(Record_Creation_Date,'mm/dd/yy')# #Description# (#Pathway#) #Last_Name# #DateFormat(Record_Creation_Date,'mm/dd/yy')# #Description# (#Pathway#) #Last_Name# #DateFormat(Record_Creation_Date,'mm/dd/yy')# #Description# #Description# (#Pathway#) #Last_Name# #DateFormat(Record_Creation_Date,'mm/dd/yy')# #Description# (#Pathway#) #Last_Name# #DateFormat(Record_Creation_Date,'mm/dd/yy')# #Description# (#Pathway#) #Last_Name# #DateFormat(Record_Creation_Date,'mm/dd/yy')#	#Severity#

#item1#

SELECT * from GetPath where pvd_type IS NULL

Severity	Description	Date	Employee	Notes	Readings
#Severity#	#Description#	#dateformat(Record_Creation_Date,"MM/DD/YY")#	#Last_Name#	#Notes#	(- #Reading1# #Reading2#)