Data Scrubber

Outline Essential Functions / Job Duties:

Summary of tasks for Lead and Copper Project for Temporary Employees (must be computer savvy & know excel)

These tasks will be taught to Temporary Employees using the current SOP, “Lead and Copper Rule Revision: How to Reduce Service Line “Unknown” and Null Pipe Material.”

1. How to use Geocortex – to identify relevant As Built for Service Line information

2. How to Review As Built information - to identify Service Line information

3. How to Review INFOR

   1. Use INFOR Work Order module to identify service line replacements not captured in Geocortex or an as built

   2. Use INFOR Asset Management module for existing service line data

   3. Use INFOR Billing Lookup Account data (if access provided) to ensure service line has active account

4. How to Research Service Line Address Build date - using online real estate search providers when needed

5. How to Track and Update Service Line information in Excel file provided by GIS

   4. Material

   5. As Built

   6. In stall Date

   7. Possibly property build date