SELECT at.*,si.visit_date,sum(si.Total_units) as total,si.rev_code,si.rev_codeid FROM #Request.prefix_db_lookup#.Assessment_TimeAuthorizations at left outer join #Request.prefix_db_agency#.ScheduleItems si on at.assessment_tracker_id = si.assessment_tracker_id where at.Assessment_Tracker_ID = #attributes.atid# and at.Assessment_ID = #attributes.aid# and at.revcode_id = #attributes.rid# and at.revcode_id = si.rev_codeid and si.visit_date > #CreateODBCDate(attributes.date)# group by si.rev_code order by si.rev_code SELECT at.*,si.visit_date,sum(si.Total_units) as total,si.rev_code,si.rev_codeid FROM #Request.prefix_db_lookup#.Assessment_TimeAuthorizations at left outer join #Request.prefix_db_agency#.ScheduleItems si on at.assessment_tracker_id = si.assessment_tracker_id where at.Assessment_Tracker_ID = #attributes.atid# and at.Assessment_ID = #attributes.aid# and at.revcode_id = #attributes.rid# and at.revcode_id = si.rev_codeid and si.visit_date <= #CreateODBCDate(attributes.date)# group by rev_code order by si.rev_code Hours:
  Approved: #approvedhours#
  Avail: #avl##avl#
  Used: #usedhours#
  Sched: #scheduledhours#