OVERVIEW

Purpose: Displays how much has been spent on water/sewer utilities for work done by CPS staff but paid for by other departments

Link: H:\Shared\Reporting\OneOff\UE_Water&Sewer\

End User: Tony Hardenbrook

CONTACT US

FASS@uoregon.edu
541-346-2455
FASS SERVICE PORTAL
Finance and Administration Shared Services website

DETAILS

Date Created: 9/13/2019

Created By: Alex Koleber

Approved By: Justin Porter

Notes / Assumptions:

This sort criteria used in the SQL query filters based on the words 'water', 'sewer', 'repair', and 'replace' in the description; this may not capture all workorders related to those utilities

This report includes work done by UE staff that was paid for by RXCPS just for reference.

SQL can be modified upon request to remove the filter for the words 'repair' or 'replace' in the description field to widen the results

TECHNICAL NOTES

Platform: Excel

Data Source: AiM Prod

CHANGE LOG

Edit Date	Edits Made

Browser not supported