SELECT p.Patient_Id, p.Last_Name_M0040, p.First_Name_M0040, p.Middle_Initial_M0040, p.Status, p.MSA_Code ,p.Zip_M0060, p.City, p.State_M0050 ,an.Assessment_Id, an.Assessment_Tracker_Id ,an.Start_of_Care_M0030, an.Certification_Start, an.Certification_End ,an.SN_Visit_Orders, an.HHA_Visit_Orders, an.Therapy_Visit_Orders ,an.Assessment_Reason_M0100, an.Date_Discharge_M0906, an.Previous_Assessment_Number ,py.PayName, py.Payer_Id FROM #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Payer py, #Request.prefix_db_lookup#.Physician ph, #Request.prefix_db_agency#.Assessment_New an WHERE p.Agency_Id = '#session.AgencyId#' AND an.Patient_Id = p.Patient_Id AND p.Status <> 'deleted' AND (an.Deleted = 0 or an.Deleted IS NULL) AND (an.Archive = 0 or an.Archive IS NULL) AND py.Payer_Id = an.Payer_Id AND ph.Physician_Id = p.Primary_ReferringPhys_ID_M0072 AND p.Status <> 'deleted' AND an.Assessment_Reason_M0100 IN ( '1 - Start of Care - further visits planned' ,'4 - Recertification (follow-up) reassessment' ,'Hospice Comprehensive' ,'Hospice Comprehensive Comprehensive' ,'SN Adult Evaluation' ) AND an.Certification_Start BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND an.SN_Visit_Orders LIKE '%w%' AND an.HHA_Visit_Orders LIKE '%w%' AND an.THERAPY_Visit_Orders LIKE '%w%' AND an.NotAdmitted = 1 AND an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND (an.Assessment_Reason_M0100 Like '7%' OR an.Assessment_Reason_M0100 Like '8%' OR an.Assessment_Reason_M0100 Like '9%') AND an.Date_Discharge_M0906 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND an.Assessment_Reason_M0100 = 'Discharge Non-OASIS' AND an.Date_Discharge_M0906 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND an.Assessment_Reason_M0100 IN ( '1 - Start of Care - further visits planned' ,'Hospice Comprehensive' ,'Hospice Comprehensive Comprehensive' ,'SN Adult Evaluation' ) AND an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND an.Assessment_Reason_M0100 IN ( '1 - Start of Care - further visits planned' ,'4 - Recertification (follow-up) reassessment' ,'Hospice Comprehensive' ,'Hospice Comprehensive Comprehensive' ,'SN Adult Evaluation' ) AND an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND py.PayerType IN ( ) Group by #groupby# SELECT p.Patient_Id, p.Last_Name_M0040, p.First_Name_M0040, p.Middle_Initial_M0040, p.Status, p.MSA_Code ,p.Zip_M0060, p.City, p.State_M0050 ,an.Assessment_Id, an.Assessment_Tracker_Id ,an.Start_of_Care_M0030, an.Certification_Start, an.Certification_End ,an.SN_Visit_Orders, an.HHA_Visit_Orders, an.Therapy_Visit_Orders ,an.Assessment_Reason_M0100, an.Date_Discharge_M0906, an.Previous_Assessment_Number ,py.PayName, py.Payer_Id FROM #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Payer py, #Request.prefix_db_lookup#.Physician ph, #Request.prefix_db_lookup#.archive_assessments an WHERE p.Agency_Id = '#session.AgencyId#' AND an.Patient_Id = p.Patient_Id AND p.Status <> 'deleted' AND (an.Deleted = 0 or an.Deleted IS NULL) AND py.Payer_Id = an.Payer_Id AND ph.Physician_Id = p.Primary_ReferringPhys_ID_M0072 AND p.Status <> 'deleted' AND an.Assessment_Reason_M0100 IN ( '1 - Start of Care - further visits planned' ,'4 - Recertification (follow-up) reassessment' ,'Hospice Comprehensive' ,'Hospice Comprehensive Comprehensive' ,'SN Adult Evaluation' ) AND an.Certification_Start BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND an.SN_Visit_Orders LIKE '%w%' AND an.HHA_Visit_Orders LIKE '%w%' AND an.THERAPY_Visit_Orders LIKE '%w%' AND an.NotAdmitted = 1 AND an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND (an.Assessment_Reason_M0100 Like '%7%' OR an.Assessment_Reason_M0100 Like '%8%' OR an.Assessment_Reason_M0100 Like '%9%') AND an.Date_Discharge_M0906 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND an.Assessment_Reason_M0100 IN ( '1 - Start of Care - further visits planned' ,'Hospice Comprehensive' ,'Hospice Comprehensive Comprehensive' ,'SN Adult Evaluation' ) AND an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND an.Assessment_Reason_M0100 IN ( '1 - Start of Care - further visits planned' ,'4 - Recertification (follow-up) reassessment' ,'Hospice Comprehensive' ,'Hospice Comprehensive Comprehensive' ,'SN Adult Evaluation' ) AND an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND py.PayerType IN ( ) Group by #groupby# SELECT Patient_Id, Assessment_Id, Assessment_Tracker_Id, Certification_Start, Certification_End ,Date_Discharge_M0906, Start_of_Care_M0030, Last_Name_M0040, First_Name_M0040, Middle_Initial_M0040 ,Zip_M0060, MSA_Code, City, State_M0050, Status, PayName, Payer_Id ,Assessment_Reason_M0100, Previous_Assessment_Number, SN_Visit_Orders, HHA_Visit_Orders, Therapy_Visit_Orders FROM getNameQuery Order by #orderby# no