Myhomecarebiz.com

SELECT pd.Pathway_Details_ID, pd.Description, pd.Skill, pd.Assessment_Tracker_ID, an.Assessment_Tracker_ID, an.Assessment_Reason_M0100, an.Certification_Start, an.Certification_End, an.Patient_ID, p.Patient_ID, p.Last_Name_M0040, p.First_Name_M0040 FROM #Request.prefix_db_agency#.Pathway_Details pd, #Request.prefix_db_agency#.Assessment_New an, #Request.prefix_db_agency#.patient p WHERE pd.Pathway_Details_ID = AND pd.Assessment_Tracker_ID = an.Assessment_Tracker_ID AND an.Patient_ID = p.Patient_ID SELECT pvd.Progress_Details_ID, pvd.Pathway_Details_ID, pvd.Type, pvd.Notes, pvd.Record_Creation_Date, pvd.Description, pvd.Record_Created_by, e.Employee_ID, e.Last_Name, e.First_Name FROM #Request.prefix_db_agency#.PatientVisitDetails pvd, #Request.prefix_db_lookup#.Employee e WHERE pvd.Pathway_Details_ID = AND e.Employee_ID = pvd.Record_Created_by ORDER BY pvd.Record_Creation_Date Myhomecarebiz.com

#GetPathway.Last_Name_M0040#, #GetPathway.First_Name_M0040#
#GetPathway.Assessment_Reason_M0100#
#DateFormat(GetPathway.Certification_Start,"mm/dd/yyyy")# - #DateFormat(GetPathway.Certification_End,"mm/dd/yyyy")#

#GetPathway.Description# - #GetPathway.Skill#

#DateFormat(GetDetails.Record_Creation_Date,"mm/dd/yyyy")# -

#GetDetails.Notes# -

#GetDetails.Last_Name#, #GetDetails.First_Name#

#GetPathway.Last_Name_M0040#, #GetPathway.First_Name_M0040# #GetPathway.Assessment_Reason_M0100# #DateFormat(GetPathway.Certification_Start,"mm/dd/yyyy")# - #DateFormat(GetPathway.Certification_End,"mm/dd/yyyy")#

#GetPathway.Description# - #GetPathway.Skill#

#GetPathway.Last_Name_M0040#, #GetPathway.First_Name_M0040#
#GetPathway.Assessment_Reason_M0100#
#DateFormat(GetPathway.Certification_Start,"mm/dd/yyyy")# - #DateFormat(GetPathway.Certification_End,"mm/dd/yyyy")#