SELECT a.Agency_ID, a.Agency_Name, a.BillingSvcs, a.Status, p.Last_Name_M0040, p.First_Name_M0040, p.Medicare_Number_M0063, an.Assessment_Reason_M0100, an.Certification_Start, an.Certification_End, an.Record_Creation_Date, py.PayName FROM #Request.prefix_db_lookup#.Agency a, #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Assessment_New an, #Request.prefix_db_agency#.Payer py WHERE p.Agency_ID = a.Agency_ID AND p.Patient_ID = an.Patient_ID AND p.Status = 'active' AND an.Payer_ID = py.Payer_ID AND a.BillingSvcs = 1 AND a.Status = 'active' order by a.Agency_Name, an.Record_Creation_Date DESC HHA System Administration

Active Agency Listing

#Agency_Name#
#Last_Name_M0040#, #First_Name_M0040# #Medicare_Number_M0063#	#Assessment_Reason_M0100# #PayName#, created: #DATEFORMAT(Record_Creation_Date,"mm/dd/yyyy")#	#DATEFORMAT(Certification_Start,"mm/dd/yyyy")# - #DATEFORMAT(Certification_End,"mm/dd/yyyy")#