SELECT si.ScheduleItems_Id, si.Assessment_Tracker_Id, si.Employee_Id, ti.Call_TelephonyId FROM #Request.prefix_db_agency#.ScheduleItems si, #Request.prefix_db_agency#.telephony_input ti WHERE si.ScheduleItems_Id = '#url.ScheduleItems_Id#' AND si.Agency_Id = '#session.AgencyId#' AND ti.Call_TelephonyId = si.Telephony_Id SELECT si.ScheduleItems_Id, si.Assessment_Tracker_Id, si.Employee_Id FROM #Request.prefix_db_agency#.ScheduleItems si WHERE si.ScheduleItems_Id = '#url.ScheduleItems_Id#' AND si.Agency_Id = '#session.AgencyId#' AND si.Telephony_Yes = 1 SELECT Employee.Employee_Id, Employee.Last_Name, Employee.First_Name, patient.Patient_Id, patient.Last_Name_M0040, patient.First_Name_M0040, patient.Agency_Assigned_Id, ScheduleItems.ScheduleItems_Id, ScheduleItems.Visit_Date, ScheduleItems.Visit_Type, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Mileage, ScheduleItems.Visit_Notes FROM #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems WHERE ScheduleItems.ScheduleItems_Id = '#url.ScheduleItems_Id#' And patient.Patient_Id = ScheduleItems.Patient_Id And ScheduleItems.Employee_Id = Employee.Employee_Id AND Employee.EmployeeType != 'Physician' SELECT DISTINCT pvd.Type, pvd.Description, pvd.Notes, pvd.general_assessment FROM #Request.prefix_db_agency#.ScheduleItems si, #Request.prefix_db_agency#.PatientVisitDetails pvd WHERE si.ScheduleItems_Id = '#url.ScheduleItems_Id#' AND pvd.ScheduleItems_Id = si.ScheduleItems_Id ORDER BY pvd.Type Desc, pvd.Description Asc, pvd.Notes Desc Select Agency_Name,Agency_Address1,Agency_City,Agency_State,Agency_Zip,Agency_Contact_Phone,Agency_Fax,Natl_Provider_ID from #Request.prefix_db_lookup#.Agency Where Agency_ID=#Session.AgencyID# SELECT Employee.Employee_Id, Employee.Last_Name, Employee.First_Name, patient.Patient_Id, patient.Last_Name_M0040, patient.First_Name_M0040, patient.Agency_Assigned_Id,patient.Location, ScheduleItems.ScheduleItems_Id, ScheduleItems.Visit_Date, ScheduleItems.Visit_Type, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Mileage, ScheduleItems.Visit_Notes FROM #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems WHERE ScheduleItems.ScheduleItems_Id = '#url.ScheduleItems_ID#' And patient.Patient_Id = ScheduleItems.Patient_Id And ScheduleItems.Employee_Id = Employee.Employee_Id AND Employee.EmployeeType != 'Physician' SELECT * FROM #Request.prefix_db_agency#.Locations WHERE Location_ID = '#GetSchedule.Location#' SELECT DISTINCT pvd.Type, pvd.Description, pvd.Notes, pvd.general_assessment FROM #Request.prefix_db_agency#.ScheduleItems si, #Request.prefix_db_agency#.PatientVisitDetails pvd WHERE si.ScheduleItems_Id = '#url.ScheduleItems_ID#' AND pvd.ScheduleItems_Id = si.ScheduleItems_Id ORDER BY pvd.Type Desc, pvd.Description Asc, pvd.Notes Desc select pd.Pathway_Details_Id,pvd.Progress_Details_Id,pvd.Description,pvd.Performed,pvd.Reading1,pvd.Severity,pvd.Notes,pd.Resolved_Date from #Request.prefix_db_agency#.PatientVisitDetails pvd Inner Join #Request.prefix_db_agency#.Pathway_Details pd on pvd.Pathway_Details_Id=pd.Pathway_Details_Id where pvd.Type like '%vital%' and pvd.ScheduleItems_ID='#url.ScheduleItems_ID#' select pd.Pathway_Details_Id,pvd.Progress_Details_Id,pvd.Description,pvd.Performed,pvd.Reading1,pvd.Severity,pvd.Notes,pd.Resolved_Date from #Request.prefix_db_agency#.PatientVisitDetails pvd Inner Join #Request.prefix_db_agency#.Pathway_Details pd on pvd.Pathway_Details_Id=pd.Pathway_Details_Id where pvd.Type like '%lab%' and pvd.ScheduleItems_ID='#url.ScheduleItems_ID#'

#Trim(Agency_Name)# #Trim(Agency_Address1)# #Trim(Agency_City)#, #Trim(Agency_State)# #Trim(Agency_Zip)# phone: #Trim(Agency_Contact_Phone)# fax: #Trim(Agency_Fax)# NPI: #Trim(Natl_Provider_ID)#		#Agency_Name# #Agency_Address1# #Agency_City#,#Agency_State# #Agency_Zip# #Agency_Contact_Phone# #Agency_Fax# #Natl_Provider_ID#
#session.Display# (#session.AgencyLogin#)	#url.code# Progress Note: #DateFormat(GetSchedule.Visit_Date,"mm/dd/yyyy")#
Time In : #GetSchedule.StartTime# Time Out : #GetSchedule.EndTime# General Notes : #HTMLEditFormat(GetSchedule.Visit_Notes)#
SELECT pd.Assessment_Id, pd.Skill, pd.Description, pd.Created_By, pd.Record_Creation_Date,pd.Type as pd_type ,pd.Pathway_Details_Id, pd.Assessment_Tracker_Id, pd.M0_Answer as Diagnosis,pd.Care_Pathway, pd.Resolved_Date ,pvd.Description as pvd_description, pvd.Performed, pvd.Severity,pvd.general_assessment, pvd.Notes, pvd.Reading1, pvd.Type as pvd_type,pvd.Reading2, pvd.Progress_Details_Id,pvd.Record_creation_date as pvdtest,si.Visit_Date ,e.Last_Name,pl.Item_Id AS PathwayListItemId, pl.CopyIntoProgressNote,pvd.generalassnotes 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 LEFT OUTER JOIN #Request.prefix_db_lookup#.pathway_list pl ON pl.Pathway_Id = pd.Care_Pathway WHERE pd.Assessment_Id = '#url.assid#' and pvd.ScheduleItems_ID = '#url.ScheduleItems_ID#' and si.Visit_Date='#dateformat(GetSchedule.Visit_Date,'yyyy-mm-dd')#' AND pd.Skill = '#url.code#' AND pd.Care_Pathway IN (#nt2[i]#) AND pd.Type IN ('Goal', 'Intervention', 'Symptom') GROUP BY pd.Description ORDER BY pd.Type DESC, pd.Record_Creation_Date, pd.Description SELECT * FROM GetPath WHERE UPPER(pd_type) ='#UCASE(item2)#' SELECT Generalassessment_ID,genaralassessment,generalassessmentnotes FROM #Request.prefix_db_agency#.patient_generalassessment where ScheduleItems_ID='#url.ScheduleItems_ID#' and Skill='#url.code#' and category='#nt0[i]#' select pd.Pathway_Details_Id,pd.Resolved_Date,pvd.Progress_Details_Id,pvd.Patient_ID, pvd.Description,pvd.Wnd_Type,pd.Skill from #Request.prefix_db_agency#.PatientVisitDetails pvd left outer join #Request.prefix_db_agency#.Pathway_Details pd on pvd.Pathway_Details_Id=pd.Pathway_Details_Id WHERE pd.Assessment_Id ='#url.assid#' and pd.Skill='SSN' and Wnd_Type like '%#i#%' and pvd.Type like '%wound%' and Care_PathWay in(25,34,35,38,39) group by Wnd_Type Select Progress_Details_ID, Agency_ID, Patient_ID, Assessment_ID, Assessment_Tracker_ID, Reading2, Wnd_Type, Wnd_Stage, Wnd_Status, Wnd_Location, Record_Creation_Date, Record_Created_By, Wnd_Len_1, Wnd_Len_2, Wnd_Wid_1, Wnd_Wid_2, Wnd_Dep_1, Wnd_Dep_2, Wnd_Chara, Notes, Wnd_Surr_Tiss from #Request.prefix_db_agency#.PatientVisitDetails where Progress_Details_ID='#woundlist.Progress_Details_Id#' SELECT Generalassessment_ID,genaralassessment,generalassessmentnotes FROM #Request.prefix_db_agency#.patient_generalassessment where ScheduleItems_ID='#url.ScheduleItems_ID#' and Skill='#url.code#' and category='#nt0[i]#' select pd.Pathway_Details_Id,pd.Resolved_Date,pvd.Progress_Details_Id,pvd.Patient_ID, pvd.Description,pvd.Wnd_Type,pd.Skill from #Request.prefix_db_agency#.PatientVisitDetails pvd left outer join #Request.prefix_db_agency#.Pathway_Details pd on pvd.Pathway_Details_Id=pd.Pathway_Details_Id WHERE pd.Assessment_Id ='#url.assid#' and pd.Skill='SSN' and Wnd_Type like '%#i#%' and pvd.Type like '%wound%' and Care_PathWay in(25,34,35,38,39) group by Wnd_Type Select Progress_Details_ID, Agency_ID, Patient_ID, Assessment_ID, Assessment_Tracker_ID, Reading2, Wnd_Type, Wnd_Stage, Wnd_Status, Wnd_Location, Record_Creation_Date, Record_Created_By, Wnd_Len_1, Wnd_Len_2, Wnd_Wid_1, Wnd_Wid_2, Wnd_Dep_1, Wnd_Dep_2, Wnd_Chara, Notes, Wnd_Surr_Tiss from #Request.prefix_db_agency#.PatientVisitDetails where Progress_Details_ID='#woundlist.Progress_Details_Id#' VITAL SIGNS #UCASE(GetVital.Description)# #GetVital.Notes# No Vital Sign Records were Found LABORATORY #UCASE(GetLab.Description)# #GetLab.Notes# No Lab Work Records were Found #UCASE(nt1[i])# #nt0[i]# General Assessment #SelectGeneralAssessment.genaralassessment# #SelectGeneralAssessment.generalassessmentnotes# #UCASE(item1)# No #item2# records were found #Description# #Notes# WOUNDS #UCASE(i)# Length #Wnd_Len_1# - #Wnd_Len_2# cm Width #Wnd_Wid_1# - #Wnd_Wid_2# cm Depth #Wnd_Dep_1# - #Wnd_Dep_2# cm Surrounding Tissue #Wnd_Surr_Tiss# Characteristics #Wnd_Chara# Notes #Trim(GetWounds.Notes)# Resolve?(Remove from future Notes) YesNo No Wounds records were found #UCASE(nt1[i])# #nt0[i]# General Assessment #SelectGeneralAssessment.genaralassessment# #SelectGeneralAssessment.generalassessmentnotes# SYMPTOMS No Symptoms records were found INTERVENTIONS No Interventions records were found GOALS No Goals records were found WOUNDS #UCASE(i)# Length #Wnd_Len_1# - #Wnd_Len_2# cm Width #Wnd_Wid_1# - #Wnd_Wid_2# cm Depth #Wnd_Dep_1# - #Wnd_Dep_2# cm Surrounding Tissue #Wnd_Surr_Tiss# Characteristics #Wnd_Chara# Notes #Trim(GetWounds.Notes)# Resolve?(Remove from future Notes) YesNo No Wounds records were found

No Record(s) Found