SELECT pPatients.Loc_ID AS Agency, pAssessments.Assmt_ID, pAssessments.F177 ,pAssessments.F177 AS CertStart, pAssessments.F178 AS CertEnd, pAssessments.Patient_ID, pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pSchedules.Schedule_ID, pSchedules.Visit_Date AS Date, pSchedules.Skill AS Type, "" AS Bill, pSchedules.Invoice_ID, pSchedules.Export_Date FROM #Request.prefix_db_agency#.pAssessments, #Request.prefix_db_agency#.pPatients, #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Assmt_ID = pAssessments.Assmt_ID AND pPatients.Patient_ID = pSchedules.Patient_Id AND pSchedules.Assmt_ID = '#url.atid#' AND pPatients.Pt_Last LIKE '#URL.Alpha#%' AND pPatients.Loc_ID = '#session.AgencyId#' AND pSchedules.EClaimed = 0 AND pSchedules.Nonbillable = 1 ORDER BY Pt_Last, F177 ASC, Visit_Date ASC

Visits Exported to PRO32 for Active Patients

Last Name:

#ind#

checked name='allitems' value="0" onclick="window.location.replace('/managementreports/index.cfm?page=reports&cat=activity&rpt=act_nonbilledexport&checkall=ny');"> All Patients

checked id='patientitems_#Assmt_ID#' name='patientitems_#Assmt_ID#' value="1" onclick="selectPatientItems(this.form,#Assmt_ID#);"> #PatientLast#, #PatientFirst# - #DateFormat(CertStart,"mm/dd/yyyy")# - #DateFormat(CertEnd,"mm/dd/yyyy")# checked> #DateFormat(Date,"mm/dd/yyyy")#, #Type# (#DateFormat(Export_Date,"mm/dd/yyyy")#)