SELECT Patient_ID, Last_Name_M0040, First_Name_M0040, Allergies, Primary_ReferringPhys_ID_M0072
FROM #Request.prefix_db_agency#.patient
WHERE Patient_ID = '#session.cs.patientid#'
select Certification_Start,Certification_End from #Request.prefix_db_agency#.Assessment_New where Assessment_ID =
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