select agency_id from #Request.prefix_db_lookup#.Agency where status='active' ORDER BY agency_id
Date and Time Added Billing Period End date Elapsed Visit_Date Payer Patient First Patient Last Agency Login
#dateTimeFormat(Record_Creation_Date,"mm/dd/yy HH:nn")# #dateFormat(bill_period_enddate,"mm/dd/yyyy")#
#Elapsed#
#dateFormat(Visit_Date,"mm/dd/yyyy")# #Pay_Name# #Pt_Last# #Pt_First# #Agency_Name# #Agency_Login#