Address:
Turlock Irrigation District
333 E. Canal Dr.
Turlock, CA 95380
Phone:
209-883-8300

Enterprise System Catalog:

Vendor and product:
Oracle, Customer to Meter
System purpose:

Customer Billing
Service Order Processing

Categories/types of data:

Customer contact information
Customer billing information

Dept./primary custodian:
Customer Service
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Developed internally, Financial system
System purpose:

General ledger
Purchase orders
Accounts Payable

Categories/types of data:

Vendor contact information
Purchasing / inventory
Accounts Payable

Dept./primary custodian:
Accounting
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Developed internally, Tax and Water system
System purpose:

Billing for water deliveries
Improvement District assessments

Categories/types of data:

Customer contact information
Parcel information
Water order and delivery information

Dept./primary custodian:
Water Distribution
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Developed internally, Employee Information System
System purpose:

Employee time, equipment and materials allocation tracking

Categories/types of data:

Employee contact information
Employee payroll information
Employee benefit information
Job Tracking information

Dept./primary custodian:
Human Resources
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Microsoft, SharePoint
System purpose:

Collaboration and Document Management

Categories/types of data:

Invoices
Purchase Orders
CARES (low income) applications - customer contact information
Document repository

Dept./primary custodian:
IT Services
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
ESRI, ArcGIS / ArcSDE
System purpose:

Graphical Information System

Categories/types of data:

Addresses
Parcels
Distribution assets
Canals

Dept./primary custodian:
Engineering
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Schneider Electric, ArcFM
System purpose:

Design for distribution system
Build list generation

Categories/types of data:

Distribution equipment
Design drawings

Dept./primary custodian:
Engineering
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Microsoft, Exchange
System purpose:

Email system

Categories/types of data:

Email
Attachments

Dept./primary custodian:
IT Services
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Neogov, Applicant tracking
System purpose:

Applicant tracking
Employee Performance Evaluation

Categories/types of data:

Applicant information

Dept./primary custodian:
Human Resources
Frequency of collection:
As needed
Frequency of update:
As needed
Vendor and product:
Elster, MAS
System purpose:

Collection and storage of meter data

Categories/types of data:

Meter information
Meter usage information

Dept./primary custodian:
Customer Service
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
System Innovators, iNovah
System purpose:

POS system

Categories/types of data:

Customer information
Payment information

Dept./primary custodian:
Customer Service
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Itron, MV90
System purpose:

Automated Meter Reading system

Categories/types of data:

Meter information
Meter Load Profile data

Dept./primary custodian:
IT Services
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Itron, FCS
System purpose:

Handheld Meter Reading system

Categories/types of data:

Meter Information
Customer Address information
Meter usage data

Dept./primary custodian:
Customer Service
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
ShoreTel, Phone system
System purpose:

Phone system

Categories/types of data:

Customer call information
Customer call recordings

Dept./primary custodian:
Electronics
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Developed internally, Online Water Request
System purpose:

Accepts Water Requests from customers
Presents historical Water deliveries to customers

Categories/types of data:

Parcel information
Customer information
Water deliveries

Dept./primary custodian:
Water Distribution
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Developed internally, Paystation software
System purpose:

Collect payments from customers

Categories/types of data:

Customer account number
Amount due
Payment amount

Dept./primary custodian:
Customer Service
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Oracle, DSS - Digital Self Service
System purpose:

Online bill presentment and payment

Categories/types of data:

Customer account information
Customer payment information

Dept./primary custodian:
Customer Service
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Kisters, WISKI
System purpose:

Hydro-logical data collection

Categories/types of data:

Precipitation data
Storage data
Run-off data
River flow & release data

Dept./primary custodian:
Strategic Issues and Planning
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Profit Stars, RemitPlus
System purpose:

Remittance Processor

Categories/types of data:

Customer payment data

Dept./primary custodian:
Customer Service
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Open Access Technology International, Web Trader
System purpose:

Purchase, sale and scheduling of power

Categories/types of data:

Utility data
Pricing information
Trade information

Dept./primary custodian:
Energy Strategy Department
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
Developed internally, DPFir
System purpose:

Used by Rangers for incidents

Categories/types of data:

Ranger Incidents
Customer Information

Dept./primary custodian:
Don Pedro Recreation Agency
Frequency of collection:
As needed
Frequency of update:
As needed
Vendor and product:
ArtStreet, Camava
System purpose:

POS system

Categories/types of data:

Customer information
Payment information

Dept./primary custodian:
Don Pedro Recreation Agency
Frequency of collection:
As needed
Frequency of update:
As needed
Vendor and product:
Developed internally, Bluetag
System purpose:

Service call tracking system

Categories/types of data:

Customer address information
Customer outage information

Dept./primary custodian:
Line Department
Frequency of collection:
As needed
Frequency of update:
As needed
Vendor and product:
Developed internally, Job Tracking System
System purpose:

Tracking of Jobs and Work orders

Categories/types of data:

Job information
Job Costs
Customer information

Dept./primary custodian:
Accounting
Frequency of collection:
As needed
Frequency of update:
As needed
Vendor and product:
Developed internally, Off Season Irrigation System
System purpose:

Tracking of water deliveries off season

Categories/types of data:

Customer information
Delivery information
Invoices

Dept./primary custodian:
Water Distribution
Frequency of collection:
As needed
Frequency of update:
As needed
Vendor and product:
Infosend, Statement printing
System purpose:

Statement printing

Categories/types of data:

Customer information
Usage information
Payment information

Dept./primary custodian:
IT Services
Frequency of collection:
Every day
Frequency of update:
Every day
Vendor and product:
First Data, Paypoint
System purpose:

Collection of Credit Card, Debit Card and ACH payments

Categories/types of data:

Customer Payment information

Dept./primary custodian:
Customer Service
Frequency of collection:
As needed
Frequency of update:
As needed