SELECT p.Patient_Id, p.Last_Name_M0040 AS Last_Name, p.First_Name_M0040 AS First_Name, p.Middle_Initial_M0040 AS Middle, p.Payer_Id
,a.Agency_Name
FROM #Request.prefix_db_agency#.patient p, #Request.prefix_db_lookup#.Agency a
WHERE p.Patient_Id = '#session.cs.patientid#'
AND p.Agency_Id = '#session.AgencyId#'
AND a.Agency_Id = p.Agency_Id
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
#DateFormat(Now(),"dddd, mmmm d, yyyy")#
#TimeFormat(Now())#
#GetP.First_Name# #GetP.Last_Name#
#GetP.Agency_Name#
#url.code# Progress Note Page 1
#reason# Date : #DateFormat(Cert.Certification_Start,"mm/dd/yyyy")#