SELECT DISTINCT MAX(an.Start_of_Care_M0030) AS MAXDATE,an.Assessment_Id, an.Admission_Status, an.Assessment_Reason_M0100, an.Start_of_Care_M0030,an.M1040_Influ,an.M1050_Pneu, an.Assessment_Tracker_Id,an.Certification_Start, an.Certification_End,p.Patient_ID,p.*,pd.* FROM #Request.prefix_db_agency#.patient p left outer join #Request.prefix_db_agency#.Assessment_New an on an.Patient_Id = p.Patient_Id left outer join #Request.prefix_db_agency#.Pathway_Details pd on an.Assessment_ID = pd.Assessment_ID WHERE p.Agency_Id = AND an.Patient_Id = p.Patient_Id AND an.deleted <> 1 ANd pd.Description like 'M1041%' and pd.Deleted is null Group by p.Patient_ID ORDER BY p.Last_Name_M0040, p.First_Name_M0040, MAXDATE ASC
Influenza vaccine status

   checked onclick="if (this.checked) active=1;else active=0;secureHREF('index.cfm?page=reports&cat=patients&rpt=influenza_vaccine&active='+active);"> Active  checked onclick="if (this.checked) Inactive=1;else Inactive=0;secureHREF('index.cfm?page=reports&cat=patients&rpt=influenza_vaccine&Inactive='+Inactive);"> In Active  checked onclick="if (this.checked) all=1;else all=0;secureHREF('index.cfm?page=reports&cat=patients&rpt=influenza_vaccine&all='+all);"> ALL Patients

Patients Start of Care Date M1041
#Last_Name_M0040#, #First_Name_M0040# #Middle_Initial_M0040#(#Agency_Assigned_ID#)
 #DateFormat(MAXDATE,"mm/dd/yyyy")# #M1040_Influ#

Total patients:    #Patient_Ctr#