SELECT an.Assessment_Tracker_ID, an.Certification_Start AS CertStart, an.Certification_End AS CertEnd ,an.Assessment_Reason_M0100 AS Reason, an.Assessment_ID, an.Assessment_Number ,an.SN_Visit_Orders AS SNFreq, p.Patient_Id ,an.Therapy_Visit_Orders AS TherapyFreq, an.HHA_Visit_Orders AS HHAFreq ,p.Patient_ID, p.Last_Name_M0040 AS PatientLast, p.Payer_ID, p.Primary_ReferringPhys_ID_M0072 AS DOC ,p.First_Name_M0040 AS PatientFirst, p.Status AS PatStat, si.ScheduleItems_Id ,si.Visit_Date, si.Missed ,si.Visit_Type AS Type, si.Progress_Note, si.Output_Type AS Output, si.Employee_Id ,py.Payer_ID, py.Output_Type, py.PayName ,DateDiff(#CreateODBCDate(url.df)#, an.Certification_Start) AS week FROM #Request.prefix_db_agency#.Assessment_New an, #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.ScheduleItems si, #Request.prefix_db_agency#.Payer py WHERE si.Agency_ID = '#session.AgencyId#' AND si.Patient_ID = p.Patient_ID AND p.Payer_ID = py.Payer_ID AND p.Status <> 'deleted' AND si.Assessment_Tracker_ID = an.Assessment_Tracker_ID AND si.Visit_Date <> '0000-00-00' AND an.Certification_Start <> '0000-00-00' AND an.Certification_End <> '0000-00-00' AND si.Visit_Date BETWEEN #CreateODBCDate(url.df)# and #enddate# AND si.Deleted <> 1 AND (an.Deleted IS Null OR an.Deleted = '0') AND (an.Archive IS Null OR an.Archive = '0') ORDER BY PatientLast, PatientFirst, CertEnd, Reason, Visit_Type, Visit_Date

Visit Compliance by Date Range - ALL Scheduled Visits

Displaying Visits From: #DateFormat(url.df, 'mm/dd/yy')# To: #DateFormat(enddate, 'mm/dd/yy')#

#PatientLast#, #PatientFirst# (#PatStat#) #PayName#

#Reason#

(if Medicare, visits need to be re-assigned to SOC/ROC)

#Reason#

#DateFormat(CertStart,"mm/dd/yy")# - #DateFormat(CertEnd,"mm/dd/yy")#

cert period UK

SN #SNFreq#

SN Orders UK

Therapy #TherapyFreq#

Therapy Orders UK

HHA #HHAFreq#

HHA Orders UK

Add Visit

Week #w# Visits...

Date	Type	Payer	Note	Action
#DateFormat(Visit_Date,"mm/dd/yy")#	No Visit Type #Type#	Payer UK RAP Medicare Final UB92-1450 UB82-1500	Unassigned Delete Add Order Add Comm Print Delete Delete

Displaying Visits From: #DateFormat(url.df, 'mm/dd/yy')# To: #DateFormat(enddate, 'mm/dd/yy')#

No records found From: #url.df# To: #url.dt#