select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name, DATEDIFF(a.M0102_Physician_SOC ,a.Start_of_Care_M0030) as M0102, DATEDIFF(a.M0104_Date_of_Referral ,a.Start_of_Care_M0030) as M0104, M0102_Physician_SOC, M0104_Date_of_Referral from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id left join Employee e on e.Employee_ID = a.Record_Created_By where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and a.Agency_ID = #session.AgencyID# select count(a.M2010_Med_Edu) as M2010_Med_Edu from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 and (p.status != "deleted") and a.Deleted != 1 and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2010_Med_Edu like '%Yes' and a.Agency_ID=#session.AgencyID# select count(a.M2010_Med_Edu) as M2010_Med_Edu from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2010_Med_Edu like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1910_Fall_Risk) as M1910_Fall_Risk from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1910_Fall_Risk like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1910_Fall_Risk) as M1910_Fall_Risk from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1910_Fall_Risk like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1730_Depression) as M1730_Depression from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1730_Depression like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1730_Depression) as M1730_Depression from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1730_Depression like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M2250b_Diabetic) as M2250b_Diabetic from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2250b_Diabetic like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M2250b_Diabetic) as M2250b_Diabetic from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2250b_Diabetic like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1240_Pain_Assess) as M1240_Pain_Assess from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1240_Pain_Assess like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1240_Pain_Assess) as M1240_Pain_Assess from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1240_Pain_Assess like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M2250e_Pain) as M2250e_Pain from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2250e_Pain like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M2250e_Pain) as M2250e_Pain from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2250e_Pain like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M2250g_PressUlcMoist) as M2250g_PressUlcMoist from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2250g_PressUlcMoist like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M2250g_PressUlcMoist) as M2250g_PressUlcMoist from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2250g_PressUlcMoist like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M2250f_PressUlc) as M2250f_PressUlc from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2250f_PressUlc like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M2250f_PressUlc) as M2250f_PressUlc from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M2250f_PressUlc like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1300_Pressure) as M1300_Pressure from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1300_Pressure like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1300_Pressure) as M1300_Pressure from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1300_Pressure like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1040_Influ) as M1040_Influ from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where (Assessment_Reason_M0100 like '6 - Transferred%' or Assessment_Reason_M0100 like '9 - Discharge%' or Assessment_Reason_M0100 like '7 - Transferred%') and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (M1040_Influ like '%Yes%' ) and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1040_Influ) as M1040_Influ from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where (Assessment_Reason_M0100 like '6 - Transferred%' or Assessment_Reason_M0100 like '9 - Discharge%' or Assessment_Reason_M0100 like '7 - Transferred%') and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (M1040_Influ like '%No' and M1045_Influ not like '7%') and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1050_Pneu) as M1050_Pneu from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where (Assessment_Reason_M0100 like '6 - Transferred%' or Assessment_Reason_M0100 like '9 - Discharge%' or Assessment_Reason_M0100 like '7 - Transferred%') and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (M1050_Pneu like '%Yes%') and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1050_Pneu) as M1050_Pneu from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where (Assessment_Reason_M0100 like '6 - Transferred%' or Assessment_Reason_M0100 like '9 - Discharge%' or Assessment_Reason_M0100 like '7 - Transferred%') and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (M1050_Pneu like '%No' and M1055_Pneu not like '5%') and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1500_Symptoms) as M1500_Symptoms from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where (Assessment_Reason_M0100 like '6 - Transferred%' or Assessment_Reason_M0100 like '9 - Discharge%' or Assessment_Reason_M0100 like '7 - Transferred%') and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1500_Symptoms like '%Yes%' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1500_Symptoms) as M1500_Symptoms from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where (Assessment_Reason_M0100 like '6 - Transferred%' or Assessment_Reason_M0100 like '9 - Discharge%' or Assessment_Reason_M0100 like '7 - Transferred%') and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and M1500_Symptoms like '%No' and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1040_Influ) as M1040_Influ from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where (Assessment_Reason_M0100 like '6 - Transferred%' or Assessment_Reason_M0100 like '9 - Discharge%' or Assessment_Reason_M0100 like '7 - Transferred%') and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (M1040_Influ like '%Yes%') and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select count(a.M1050_Pneu) as M1050_Pneu from #Request.prefix_db_agency#.Assessment_New a left join #Request.prefix_db_agency#.patient p on a.patient_Id = p.patient_Id where (Assessment_Reason_M0100 like '6 - Transferred%' or Assessment_Reason_M0100 like '9 - Discharge%' or Assessment_Reason_M0100 like '7 - Transferred%') and Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (M1050_Pneu like '%Yes%') and (p.status != "deleted") and a.Deleted != 1 and a.Agency_ID=#session.AgencyID# select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M2010_Med_Edu from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M2010_Med_Edu like '%Yes%' or a.M2010_Med_Edu like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M1910_Fall_Risk from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M1910_Fall_Risk like '%Yes%' or a.M1910_Fall_Risk like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M1730_Depression from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M1730_Depression like '%Yes%' or a.M1730_Depression like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M2250b_Diabetic from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M2250b_Diabetic like '%Yes%' or a.M2250b_Diabetic like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M1240_Pain_Assess from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M1240_Pain_Assess like '%Yes%' or a.M1240_Pain_Assess like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M2250e_Pain from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M2250e_Pain like '%Yes%' or a.M2250e_Pain like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M2250g_PressUlcMoist from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M2250g_PressUlcMoist like '%Yes%' or a.M2250g_PressUlcMoist like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M2250f_PressUlc from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M2250f_PressUlc like '%Yes%' or a.M2250f_PressUlc like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M1300_Pressure from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where a.Assessment_Reason_M0100 like '1 - Start of care - further visits planned' and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M1300_Pressure like '%Yes%' or a.M1300_Pressure like '%No') and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M1040_Influ, a.M1045_Influ from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where (a.Assessment_Reason_M0100 like '6 - Transferred%' or a.Assessment_Reason_M0100 like '9 - Discharge%' or a.Assessment_Reason_M0100 like '7 - Transferred%') and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M1040_Influ like '%Yes%' ) and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M1050_Pneu, a.M1055_Pneu from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where (a.Assessment_Reason_M0100 like '6 - Transferred%' or a.Assessment_Reason_M0100 like '9 - Discharge%' or a.Assessment_Reason_M0100 like '7 - Transferred%') and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M1050_Pneu like '%Yes%' ) and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc select p.Last_Name_M0040,p.First_Name_M0040,a.Start_of_Care_M0030,e.Last_Name,e.First_Name,a.M1500_Symptoms from #Request.prefix_db_agency#.Assessment_New a left join Employee e on e.Employee_ID = a.Record_Created_By left join `#Request.prefix_db_agency#`.`patient` p on a.patient_Id = p.patient_Id where (a.Assessment_Reason_M0100 like '6 - Transferred%' or a.Assessment_Reason_M0100 like '9 - Discharge%' or a.Assessment_Reason_M0100 like '7 - Transferred%') and (p.status != "deleted") and a.Deleted != 1 and a.Start_of_Care_M0030 between #createODBCDate(FORM.date)# and #createODBCDate(FORM.end)# and (a.M1500_Symptoms like '%Yes%' ) and a.Agency_ID=#session.AgencyID# order by Start_of_Care_M0030 asc

Start of Care OASIS - I by Patient

Percentage Description Total

#M0102_Physician_SOC_R# % How often the home health team began care in a timely manner (M0102) #M0102_Yes#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	No	#Last_Name_M0040# #First_Name_M0040#
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	Yes	#Last_Name_M0040# #First_Name_M0040#
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	No	#Last_Name_M0040# #First_Name_M0040#
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	Yes	#Last_Name_M0040# #First_Name_M0040#

#M2010_Med_Edu_R#% How often the home health team taught patient (or their family caregiver) about their drugs(M2010) #M2010_Med_Edu_.M2010_Med_Edu#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M2010_Med_Edu, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

#M1910_Fall_Risk_R#% How often the home health team checked patients risk of falling (M1910) #M1910_Fall_Risk_.M1910_Fall_Risk#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1910_Fall_Risk, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

#M1730_Depression_R#% How often the home health team checked patient for depression (M1730) #M1730_Depression_.M1730_Depression#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1730_Depression, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

#M2250b_Diabetic_R#% For patient with diabetes, how often the home health team got doctor orders, gave foot care, and taught patient about foot care (M2250b) #M2250b_Diabetic_.M2250b_Diabetic#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M2250b_Diabetic, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

#M1240_Pain_Assess_R#% How often the home health team checked patient for pain (M1240) #M1240_Pain_Assess_.M1240_Pain_Assess#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1240_Pain_Assess, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

#M2250e_Pain_R# % How often the home health team treated patient for pain (M2250e) #M2250e_Pain_.M2250e_Pain#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M2250e_Pain, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

#M2250g_PressUlcMoist_R# % How often the home health team took doctor-ordered action to prevent pressure ulcers (M2250g) #M2250g_PressUlcMoist_.M2250g_PressUlcMoist#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M2250g_PressUlcMoist, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

#M2250f_PressUlc_R#% How often the home health team included treatment to prevent pressure ulcers the plan of care (M2250f) #M2250f_PressUlc_.M2250f_PressUlc#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M2250f_PressUlc, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

#M1300_Pressure_R#% How often the home health team checked patient for the risk of developing pressure ulcer (M1300) #M1300_Pressure_.M1300_Pressure#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1300_Pressure, 7),3)#	#Last_Name_M0040# #First_Name_M0040#

100% How often the home health team determined whether patient received a flu-shot for the current flu season(M1040) #M1040_Influ_re.M1040_Influ#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1040_Influ, 7),3)#	#Last_Name_M0040# #First_Name_M0040#
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1040_Influ, 7),3)#	#Last_Name_M0040# #First_Name_M0040#
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	NA	#Last_Name_M0040# #First_Name_M0040#

100% How often the home health team determined whether their patient received a pneumococcal vaccine(M1050) #M1050_Pneu_re.M1050_Pneu#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1050_Pneu, 7),3)#	#Last_Name_M0040# #First_Name_M0040#
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1050_Pneu, 7),3)#	#Last_Name_M0040# #First_Name_M0040#
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	NA	#Last_Name_M0040# #First_Name_M0040#

100% How often the home health team treated heart failure (weakening of the heart) patient symptoms(M1500) #M1500_Symptoms_.M1500_Symptoms#

	SOC Date	Employee Name	Status	Patient Name
	#Dateformat(Start_of_Care_M0030,'mm/dd/yyyy')#	#Last_Name# #First_Name#	#Right(Left(M1500_Symptoms, 7),3)#	#Last_Name_M0040# #First_Name_M0040#