SELECT Agency.Agency_ID, ScheduleItems.Export_Date, ScheduleItems.Output_Type, Payer.PayName, Patient.Last_Name_M0040 AS PatientLast, Patient.First_Name_M0040 AS PatientFirst, Assessment_New.Assessment_Reason_M0100, Assessment_New.Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_agency#.Payer WHERE ScheduleItems.EClaimed = 1 AND ScheduleItems.Export_Date != '' AND ScheduleItems.Export_Date != '0000-00-00' AND ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID AND ScheduleItems.Payer_ID = Payer.Payer_ID AND Patient.Patient_ID = Assessment_New.Patient_ID AND ScheduleItems.Agency_ID = Agency.Agency_ID AND Agency.Agency_ID = #session.AgencyID# Group by Patient.Patient_ID, ScheduleItems.Export_Date, ScheduleItems.Output_Type Order by Export_Date DESC, PatientLast ASC

Billed Claims (sorted by date)

patient, assessment type, payer

___________________________________________
#DateFormat(Export_Date,"mm/dd/yyyy")#
#PatientLast#, #PatientFirst# #Assessment_Reason_M0100# - #PayName#