UPDATE #Request.prefix_db_agency#.Pathway_Details set Deleted=1 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 #Request.prefix_db_lookup#.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 ) 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#' ) 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, pvd.Description as pvd_description,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#' AND (pd.Deleted IS NULL) AND pd.Resolved_Date IS NULL Group by pd.Description ORDER BY pd.Record_Creation_Date, pd.Description
Print CarePlan
#GetA.Assessment_Reason_M0100# #DateFormat(GetA.Certification_Start,'mmm dd, yyyy')# - #DateFormat(GetA.Certification_End,'mmm dd, yyyy')#

#titlecode#

#title#

Last Visit: #dateformat(GetPath.Visit_Date,"MM/DD/YY")#

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.PID#&code=#url.code#&detail='+detail);"> Show All Deleted Items Resolved Items Add Items

#item1#

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


    #item1#

     SELECT * from GetPath where pvd_type IS NULL
    SeverityDescriptionDateEmployeeNotesReadings
    #Severity##Description##dateformat(Record_Creation_Date,"MM/DD/YY")# #Last_Name##Notes#(-#Reading1# #Reading2#)