14-Exhibit A - Reports.pdf

Exhibit A – REPORTS

The following list of current Reports is provided as a reference for Responders for pricing in Exhibit E, FWWD CIS Pricing Model.

*In the column labeled “Core or Custom” indicate if these reports will be a core report or a custom report.

Ex. # Unit Report Name Report Description Core or Custom

1 Accounting Fiscal Year Collection Activity Reports - Oct.

FYXX - Sept. FYXX

Monthly reporting of payment collection via source/cashier, totals.

Additionally, reports number of cash receipt transactions per source, returns and credit impact to account totals/count.

2 Accounting Fiscal Year Collection Activity Reports - Summary

Provides the monthly totals by payment source with total dollars and counts.

Additionally, reports total dollars for returned payments or misapplied.

3 Accounting Fiscal Year Collection Activity Reports - Total Amount

Report on Collection dollar total activity per source by month for the FY.

Additionally provides total transaction amounts and percentage breakout per source for the year.

4 Accounting Fiscal Year Collection Activity Reports - Total Count

Report on Collection count activity per source by month for the FY.

Additionally, it provides total transaction counts and percentage breakout per source for the year.

5 Accounting Monthly Executive Team's Report - Collections

Provides the monthly collection totals by source, with grand totals and percentage breakdown for each source.

6 Accounting Monthly Executive Team's Report - Active Acct. Aging

Provides a monthly 30/60/90/120+ AR aging for the FY for active accounts.

Additionally provides a bar graph of the ageing by month.

7 Accounting Monthly Executive Team's Report - Overall Aged Receivables

Provides a monthly 30/60/90/120+ AR aging for the FY for all accounts.

Additionally provides a bar graph of the ageing by month.

Ex. # Unit Report Name Report Description Core or Custom

8 Accounting Monthly Executive Team's Report - Donations Provides a report of the monthly Utility Assistance Donations that have been made for the FY. Additionally, it provides a bar chart showing the monthly amounts.

9 Accounting Monthly Executive. Team's Report - Billing Statements

Provides the monthly counts in the FY for both billing statements produced and Delinquency Notices produced, with a grand total.

10 Accounting Monthly Executive Team's Report - Misc.

Revenue

Provides a monthly revenue amount and count of the following misc. fees;

Late Payment, Activation, Locked Meter, Reactivation, Returned Check, New Meter Set, Tamper, Meter Damage, Investigate 2nd Req, Contract Meter Penalty and Same Day Service. Monthly grand totals and year to date totals provided.

11 Accounting Monthly Executive Team's Report - All Revenue and Consumption

Provides a monthly reporting on IDB Revenue, Consumption (Gals) and Retail Revenue, consumption (Gals), with year-to-date grand totals.

12 Accounting Monthly Executive Team's Report - Revenue

Provides the monthly revenue for: Water Retail, Wastewater Retail, Water Wholesale, Wastewater Wholesale with grand totals per month and FY for both water and wastewater. Additionally, it provides bar chart showing both water and ww revenue by month.

13 Accounting Monthly Executive Team's Report - Write-off Provides monthly write-off amounts for the following Water & Sewer, EPF, Garbage, Stormwater with monthly grand total and FY YTD total.

14 Accounting Monthly Executive Team's Report - Adjustment

Provides the monthly adjustment amounts for the following adjustment types;

Over Read, Good Will, Leaks, MyH20 Meter Exchange, Undefined High Usage.

Additionally provides monthly grand total

15 Accounting Monthly Executive Team's Report - Billing Exception

Provides monthly count of bills produced, billing exceptions, exceptions forwarded to Meter Service and Percentage of exceptions forwarded to Meter Service.

Core or Custom

16 Accounting Monthly Executive Team's Report - Wholesale

Provides for the current month Chart and reporting of Wholesale Billing Consumption in Gallons for Reclaimed, Wastewater and Water, plus the invoiced revenue for each with grand totals and bar chart showing these numbers.

17 Accounting Monthly Executive Team's Report - % Completed Billing

Provides for the current month to date, cycle and percentage of accounts that were billed within two days, with a monthly overall percentage.

18 Accounting Monthly Executive Team's Report - AWWA Billing Accuracy

Provides billing accuracy (errors/10K bills generated) for FY broken out by Water Utility, WW Utility and Combined Utility.

19 Accounting Monthly Executive Team's Report - Avg Active Accounts

Provides totals per month active customer accounts, per FY going back to FY2020. Additionally providing an average count for the FY, % Change over previous year and note of Increase or Decrease.

20 Accounting Collection Report - Collection Agency Summary

Provides the total customers and total collection amount for Internal Collections

21 Accounting Collection Report - Collection Report (Detail)

Provides Customer ID, Name, Location ID, Location Address, Phone number, Transaction date, Transaction amount, Current balance, Termination date, Total Credit Offenses, Held (Yes/No) Location Exception, Driver's License, Spouse Name, Date of Birth

22 Accounting Write Off Update List - Write-Off Update Listing

Provides the Customer ID, Name, Location ID, Location Address, Receivable Code, Description, User, Termination Date, Current Balance, and write-off amount per receivable code with a location total. The final page of report provides the total per receivable code that was written off with a grand total.

23 Accounting Sales Tax Posted - Sales Tax Posted Provides Debit, Credit, Net, Program name and Final totals of Sales Tax Collected for Sanitation.

Core or Custom

24 Accounting Sanitation Services Sales Tax Report - Sanitation Service Sales Tax Report

Provides Sales Tax Receivable Beginning Balance, Sales Tax Billings, Sales Tax Adjustments, Bad Debt Write Off, Billing Net of Adjustments & Write-offs, Total Available for Collection, Sales Tax Receivable Ending Balance, Sales Tax Collected During period.

25 Billing Adjustment Report - Adjustment Review List Provides Customer ID, Name, Service Type, Description, Adjustment Date, Location ID, Service Address, Amount, Reference, Origin Date

26 Billing Unbilled Report - Unbilled Report Customer ID, Customer Name, Location ID, Location Address, Initiation Date, Last Bill Date, Current status, Cycle/Route.

27 Billing Cancel or Cancel Rebill - Cancel Only Transaction Listing

Customer ID, Customer Name, Location ID, Service Address, Service, Rate Comp, Type, Description, Date of transaction, amount, receivable code, user, billed date, time, Demand, Transaction amount total for bill date, transaction amount total for customer

28 Billing Credit Inactive Report - Credit Inactive Report Provides Customer ID, Location ID, Transaction Date, Amount, Other (list type of credit, Ex. Storm Water, Credit over $500)

29 Billing Off Cycle Report - Off Cycle Report Provides Date and Time report is run, cycle and count

30 Call Center Bus Plan Call Center Stats FYXX - Call Center FYXX Quarterly Stats

Report provides monthly counts for; Total Calls Offered, Total Calls Answered, AVG. TTA, Abandon Calls. Additionally provides % of Abandon Calls, % Within Service Level, % Answered Calls with YTD Totals for all of these items.

Additionally, it provides bar graph with trend line for each month.

31 Call Center Calls vs. Cases - Daily Calls vs. Cases Tab in spreadsheet for each day of the month reporting Supervisor, CSR, Created Case Count for CSR, Modified Case Count for CSR, Total Cases for CSR, Calls, Difference between Total cases less calls.

or Custom

32 Call Center CRM Report FYXX - CRM Report Reports the monthly case type/sub type report with the counts for each month. Provides totals for the year.

33 Call Center Daily Agent Performance - Daily Agent Performance (tab for each day)

Report provides totals at the top for the day and information in detail for each CSR. Information tracked; CSR, Login Time, # In Calls, Productive Level, Avg In Handle Time, Avg. Call Wait (ACW), Avg. Hold Time, RNA Lock, Avg Calls per Hour

34 Call Center FY Overview Report - FY Overview Report (Monthly Tabs for current FY)

Provides all of the information that is shown on Daily Agent Performance report for the entire month.

35 Call Center FY Phone Stats - FY XX

Provides the phone stats for each month of the FY; Calls Offered, Calls Answered, Calls Abandoned, % Abandoned, % Within Service Level, % Outside Service Level, % Answered Calls, ASA - ATA (Min: Sec), Average Handle Time (Min: Sec), with YTD Totals for each. Additionally, provides a bar chart of the above information.

36 Call Center FY Phone Stats - FY Service Level (SL) Provides the following monthly information; % Abandon, % Within Service Level, % Outside Service Level, % Answered Calls. Additionally provides a bar chart of this information.

37 Call Center FY Phone Stats - FY Time To Answer (TTA) Provides ASA - TTA and Average Handle Time for each month of the FY.

Additionally, provides a bar chart of this information.

38 Call Center FY XX Monthly WFO Scoring Analysis - Monthly Report for each month of FY

Provides CSR Name, Overall Score, Call Opening Score, Listening/Communication Skills Score, Knowledge and Effectiveness Score, Call Handling Score, Escalation Score, Call Closing Score. Report provides Group Average and the number of CSRs with a score less than 86%.

39 Call Center FY XX Monthly WFO Scoring Analysis - Monthly Recap Report for the FY

Provides the Group Average and # of CSR's with a score less than 86% for each month of the FY, with YTD Avg Score and count. Additionally, provides a bar chart showing this information.

or Custom

40 Call Center Group Performance Call Profile Monthly FYXX

- Monthly Report for each month of FY

Provides # of calls answered for the month, with percentages answered in; 0 - 30 sec, 31 - 60 sec, 1 - 1.5 min, 1.5 Min+, Avg TTA, Longest TTA.

41 Call Center Month XX Interval - Daily Report of the month on each tab

Tracks the hour, call category (Eng/Span), service level %, Offered calls, Answered calls, % Answered, Abandon calls, Abandoned %, Avg. Abandon, Avg Handle, Avg. TTA, Longest TTA with overall avgs/totals for the day.

42 Conservation All Violation List City Wide - City Wide All Violations

Report lists MDM Meter #, MDM Location ID, Street Address, City, Postal Code, Customer Name, Customer Phone, Email Address, Address 2, City, State, Postal Code, Rate Class, Total Usage, MDM Start Time/Date, Conservation Continuous Days at Least 1 Hour).

43 Conservation All Violation List City Wide - Multi Day

Report lists MDM Meter #, MDM Location ID, Street Address, City, Postal Code, Customer Name, Customer Phone, Email Address, Address 2, City, State, Postal Code, Rate Class, Total Usage, MDM Start Time/Date, Conservation Continuous Days at Least 1 Hour).

44 Conservation FW ICI (Industrial, Commercial, Institutional) Audit Tracking - Project 0318-061-06

Report list the facility where the survey was performed and the areas that are checked from Toilets to Waste Bins. Additionally, list the Company Contact, Contact Title, email, and phone number.

45 Conservation FW ICI (Industrial, Commercial, Institutional) Audit Tracking - Historical ICI Surveys

List facility, address, FY Survey was performed broken out by Commercial/Industrial, City of Fort Worth Facilities, Tarrant County Facilities.

46 Conservation FYXX Conservation Programs Water Savings Data - SmartFlush

Report provides count for SmartFlush Voucher and Care Data broken down by;

Total Number of Approved Applications, Total Number of Denied Applications, Total Number of Applications, Total Number of Toilets Approved, Total Number of Toilets Issued, Estimated Water Savings in Gallons

47 Conservation FYXX Conservation Programs Water Savings Data - SmartRepair

List the name of Customer, Address of Job, Date of Job, Invoice Date, Invoice #, Count of items Replaced; Bathroom Sink Faucet, Toilet, Shower Head, Kitchen Faucet, Bathtub Faucet, Hose Bibs, Laundry Sink Faucet, with Totals for each and Total Gallons Saved.

or Custom

48 Conservation FYXX CARE Tracking List - FYXX CARE Approved

Provides information on CARE applicant with total count of Toilets approved and Cost with Estimated Annual Savings (Gal). Additionally, it provides Date Scheduled, Date Toilet Picked Up, Supply Company Invoice Number, Plumber Invoice Date, Plumber Invoice Cost, Notes.

49 Conservation FYXX CARE Tracking List - FYXX CARE Denials Provides information on CARE applicant with Reason for Denial

50 Conservation FYXX SmartPressure Tracking - FYXX SmartPressure Tracking

Provides information on Pressure Valve applicant, size of PRV approved, size of expansion tank approved, date picked up, # picked up, invoice #, CISCO Entry, Comments.

51 Conservation SmartFlush Commercial Deliveries FYXX - In Progress Toilets

Provides the date, customer ID, CRM Case #, Property Name, Address, Contact, Phone, Email, Initial Site Visit, Toilets Requested, Toilets Approved, Delivery information; Toilet Count Delivered, Delivery Date, Invoice, Inspection Date

52 Conservation SmartRepair Tracking - Applications Provides information on applicant, customer identified issues, Timeline information, Status.

53 Conservation SmartRepair Tracking - FYXX Tracking

Provides customer information, year of home, home value, Date of application, If income verification completed, plumber information on job cost, invoices, date of job, total cost of job, if job was out of scope, out of scope cost, customer follow up information, issues, timeline

54 Conservation SmartRepair Tracking - Withdrawals Same information as above but list those customers who withdrew from program

55 Conservation SmartRepair Tracking - Denied FYXX Provides customer information and reason for denial.

Core or Custom

56 Conservation SmartRepair Tracking - FYXX Water Savings Provides customer info, date of job, invoice information, counts on fixture replacements and calculated total water savings in gallons.

57 Credit Collections

Utility Billing Balancing Worksheet

Daily Report that is used for daily Reconciliation (used on the Billed Deposit Reconciliation report & Cash Balancing Report) Data that is recorded:

- Credit Balance Refund – used to balance total refunds

- Final Bill Credit Refund – total refund

- Cash Update (Total Payments)

58 Credit Collections

Trial Balance Daily Report that is used for the Billed Deposit Recon report – it records the final total billed deposit and net total

59 Credit Collections

Utility Balance Daily report that is used for the Billed Deposit Recon Report – it records the Credit Amount Total

60 Credit Collections

Reverse/Transfer Payment Posting Daily Report used for the Cash Balancing Report – it records all payment reversals and payment transfer (i.e. misapplied payment, return payments)

61 Credit Collections

Generated Transfer Payments/system Generated Bad Check Charges

Daily report used to record reversed payment (total and item count) – (i.e.

payment transfer)

62 Credit Collections

Cancel Rebill Missing Read Report - Cancel Rebill Missing Read Report

Daily report to capture any cancel and re-bills from Billing Department (used for daily posting) – reversing charges or Custom

63 Credit Collections

Meter Reading Posting Daily report to capture any cancel and re-bills from Billing Department (used for daily posting) – reversing consumption

64 Credit Collections

Preliminary Cancel/Rebill billing Register Daily report to capture any cancel and re-bills from Billing Department (used for daily posting) – summary of cancel/re-bill

65 Credit Collections

Daily Query for Billed Deposits Daily Report – to capture total deposits billed – used for the Billed Deposit Report (records previous business day)

66 Credit Collections

Summary of Postings To Accounts Receivables

Daily Report – report is used for the Billed Deposit Reconciliation Report – the total net is recorded

67 Credit Collections

Daily Posting To Cash for Reverse Payments Daily Report – report is used for the Cash Balancing Report – the final total count is recorded

68 Credit Collections

Billing Inquiry Print as needed - to search for a customer’s billed amount (i.e. received payment without bill stub or account number, able to search for the billed amount by month)

69 Credit Collections

Payments that post to an account by creating both the charge and the payment record

Daily Report – information recorded on the Cash Balancing Report - Report the difference in the PE funds (i.e. Water Sewer & Garbage Deposits, 56001- 22800000; 54001-2280000)

70 Credit Collections

Listing of Reverse Payments with REV.PAY

COD

Daily Report – information to record any payment transfer, used on the Cash Balancing Report

71 Credit Collections

Totals by Day/Batch Number

Daily Report – report is used for the Cash Balancing Report – records payment from batch 20, 21, 22, & 23 – (misapplied, damaged checks, missing IVR payment, failed notification payments) – batch type MP (misapplied – payment type NC – non-cash) or Custom

72 Credit Collections

Total Count And Dollar Amount for each Batch

Daily Total Cashier count and dollar amount collected for each individual batch – used for Month-End totals

73 Credit Collections

List of Cash Customers List of customers that are on CASH only (i.e. return payments)

74 Credit Collections

Cash Balancing Not on UT601 by Payment Type - Cash Balancing Not on UT601 by Payment Type

Daily Report used for the Cash Balancing Report – (records donations, lab fees, lead request, return grease trap payments)

75 Credit Collections

Cash By Cashier Excluding Monthly Total Cashier count and dollar amount collected for each individual batch – used for Month-End totals

76 Credit Collections

Count/Dollar Value of Returned Checks Monthly Report – used for Month End recording the total of return payments

77 Credit Collections

Identify Payments on Non Active Accounts Daily Report – used to identify payments made on a final account

78 Customer Support

XX FY Delinquency Support - Month XX - Summary

Provides Avg. Delinquency Percentage, H2Online Request count, Outgoing Customer Correspondence Count, Return Mail - Wtr/Storm Water Count, Service Not Restored (SNR) Count, Liens Filed/Released Count, Walk-In Customers Count, Pledges Count

79 Customer Support

XX FY Delinquency Support - Month XX - Delinquency

Provides for each month of the FY; Number of Avg Active Accounts, Avg.

Delinquent Amount, % of Delinquent Accounts, YTD Totals for each.

Additionally provides a bar graph of the percentage of Delinquent accounts per month.

or Custom

80 Customer Support

XX FY Delinquency Support - Month XX - H2Online

Per month reports the number of Account adjustment, Billing Questions, Customer Invoice, Cycle/Route, Edit Master File, Main Break/Sewer, Sanitation, Set/Reactivation, Payment Arrangements, Term Account, Tech Issues/H2Online Acct Access, Other and total Email Requests for the month.

Provides Bar Graph of all of the requests per month.

81 Customer

XX FY Delinquency Support - Month XX - Outbound Correspondence (Letters)

Per month for the FY provides the number of letters sent out for the following;

Adjustments (Leak), Bank draft, Confidentiality LTRS, Field Investigation, Leak Meter Inspection, Request for Name Change, Return Check, Auto Pay Recurring Card Failure, Welcome Letters, Other and grand total. Additionally, it provides a bar graph.

82 Customer

XX FY Delinquency Support - Month XX - Return Mail (Water/Storm Water) FYXX YTD

Per month for FY provides counts for return mail for Water Department, Storm Water Utility (TPW), Return Checks, CSG - Address Validation with grand total.

Additionally provides bar graph

83 Customer

XX FY Delinquency Support - Month XX - Service Not Restored

Report provides per month for the FY, the count of Service Not Restored that were Processed and the Total number of Outbound Calls. Additionally, it provides bar graph of data.

84 Customer

XX FY Delinquency Support - Month XX - Utility Liens - Water

Report provides per month for the FY, the count of Liens Filed, Liens Released, Cost of Liens, Total Dollar Amount Filed and YTD Totals. Additionally, provides graph of data.

85 Customer

XX FY Delinquency Support - Month XX - Storm Water Liens Filed

Report provides per month for the FY, the count of Liens Filed, Liens Released, Cost of Liens, Total Dollar Amount Filed and YTD Totals. Additionally, provides graph of data.

86 Customer

XX FY Delinquency Support - Month XX - Walk- Ins

Provides the Employee's name and the number of customers who walked in for the month that they assisted, along with YTD totals and a graph.

87 Customer Support

XX FY Delinquency Support - Month XX - Pledges

Provides the Employee's name and the number of pledges and dollar amount of pledges received for the month with YTD totals. Additionally, it provides a bar graph.

or Custom

88 Customer Support

XX FY Delinquency Support - Month XX - Pledge Summary

Provides the total number of pledges and dollar amount received with YTD totals.

89 Customer Support

Misc. Charge Code Listing - Misc. Charge Code Listing List Charge Code, Charge Code Description, Amount, Receivable Code

90 Water Applications

Master Copy - Master Test

Report contains the following fields; UTCSID, F, UTSVC, UTSSTM, UTSSTD, UTSSTY, Comment, Builder, Address, Contacted, 1st Contact Date, Rep, Comments (First Contact), 2nd Contact Date, 2nd Comments, Color Codes for the following fields; WTR APPS, Has A Meter, FOP WRK, Further Review

91 Water Applications

Master Copy - New Work Order Test

Report contains the following fields; UTCSID, F, UTSVC, UTSSTM, UTSSTD, UTSSTY, Comment, Builder, Address, Contacted, 1st Contact Date, Rep, Comments (First Contact), 2nd Contact Date, 2nd Comments, Color Codes for the following fields; WTR APPS, Has A Meter, FOP WRK, Further Review

92 Water Applications

Master Copy - Need Clarification Questions on work order notes.

93 Wholesale FY Wholesale Reclaimed Tables - Wholesale Reclaimed Water Sales List customer, Contract Expiration Date, Usage (MG), Sales for the FY

94 Wholesale FY Wholesale WW Tables - Wholesale Contracts List customer, Contract Expiration Date for Water and Wastewater.

95 Wholesale FY Wholesale WW Tables - Wholesale WW - Sales

List customer, Million Gallons Amount, BOD Pounds, TSS Pounds, Invoiced Amt, Offset Fee, Sampling Charges with totals and Grand Total

96 Wholesale FY Wholesale WW Tables - Wholesale WW Cust Contributions

List Wholesale Customer, Volume (MG), % Wholesale Cust Flow, % Total Flow, BOD (PPM)+, Total Pounds of BOD, % of Wholesale Cust BOD, % of Total BOD, TSS (PPM)+, Total Pounds of TSS, % of Wholesale Cust TSS, % of Total

TSS

97 Wholesale Raw Water Payment Report

List Treatment Plants, Usage in Gallons, FY to Date, Previous FY to Date.

Second page of report list Treated Water to Outside District Accounts, Usage in Gallons, FY To Date, Previous FY to Date. Third page list Water source, Volume in Gallons, Total Volume with Total Raw Water Used All Plants.

Core or Custom

98 Wholesale Executive Team Monthly Wholesale Report FYXX - Monthly Tab

Report provides Wholesale consumption for Reclaimed, WW, Water with total and corresponding bar chart. Report provides Invoice Revenues for all three types and bar chart. Additionally, it provides Impact Fee Revenues for the Quarter for WW and Water with a Bar chart.

99 Wholesale Reclaim Retail FYXX - Reclaim Wholesale Customer, Month with Consumption amount, Grand totals for each customer.

100 Wholesale Reclaim Retail FYXX - Retail Retail Customer, Month and Consumption amount and Grand totals for each.

101 IT System Rpt. GL Export File Daily file created to send information from CIS to Financial Management Services. GL entries for Accounting

102 IT System Rpt. Cancel only Transaction Posting Listing of all cancelled bills from bill update. Provided to Accounting Services

103 IT System Rpt. Delinquency Notice reports Commercial Apartment (CA) and Comm Multi-family (CM) Accounts

104 IT System Rpt. Delinquency Exemption Report Commercial Apartment (CA) and Comm Multi-family (CM) Accounts

105 IT System Rpt.

Customer Letters Released for Printing from BILLUPD Job These counts Do Not include any letters manually released for printing

106 IT System Rpt. S Status Report Displays all accounts w/ a term date in 'S' status. It calculates how long in status.

107 IT System Rpt.

Customer Letters manually released for printing - previous business day These counts Do Not include any letters released for printing by BILLUPD job or Custom

108 IT System Rpt. Exemption Code Removal report Report showing exemption code expired accounts

109 IT System Rpt. Customers with Permanent Delinquent Day List of customers with AutoPay and delinquent day

110 IT System Rpt. Posting reports Treasury Dept reports held because of report size that are generated during the posting process each end of day

111 IT System Rpt. Bill Update reports for Treasury Balancing Worksheet, GMBA Interface, Generated Journal Entries, and Trial Balance

112 IT System Rpt. Bill Print File and Delinquent Letters Daily files sent to DataProse created in CIS from previous day's bill update and notice creation

113 IT System Rpt. Meter read download file File created for Harris MDM to gather read data by cycle

114 IT System Rpt. Meter read upload file File imported with meter read data for cycle to be billed that evening

115 IT System Rpt. Report on 1150000 and 1150003 accounts Looks at Water and Garbage services, and Suspense accts

116 IT System Rpt. Bank draft reports List of bank drafts <> current balance. Listing of pending drafts where the draft amt <> current balance (must be fixed before due date)

117 IT System Rpt. Deposit reports Billed Deposits greater than $10,000.00

118 IT System Rpt. Draft problem report Credit and Collections report or Custom

119 IT System Rpt. Off Cycle Report Off cycle stat report for billing

120 IT System Rpt. IVR reconciliation report IVR and E-Lockbox bill update report for Credit and Collections

121 IT System Rpt. 4 Excel reports created for delinquency Com Apartment, Commercial building, Commercial, and Residential reports

122 IT System Rpt.

Customers with Active WA SVC and no water meter Report for applications - WA - water service

123 IT System Rpt. Refund Checks File created for Accounting Services with listing of refund checks processed in CIS for Financial Management Services to process

124 IT System Rpt. Contract Weekly Report Weekly contract meter list, with and without Active Customers

125 IT System Rpt. Weekly deposit report Report for CC Ops

126 IT System Rpt. Dev Report Development impact & tap fee report

127 IT System Rpt. Fidelity Express Report Validates files received from 3rd party and creates export file for Credit and Collections

128 IT System Rpt. Non Cash Report Report for Credit and Collections

129 IT System Rpt. Third Party Report Report groups 3rd party accounts by Customer and Location ID

130 IT System Rpt. Confidentiality Flag Report Lists accounts that are not flagged confidential or Custom

131 IT System Rpt. Contract report Monthly contract meter list, with and without Active Customers

132 IT System Rpt. Accounting reports Balance reports, Tax reports, Water Loss

133 IT System Rpt. IVR reconciliation report Monthly IVR and E-Lockbox bill update report for Credit and Collections

134 IT System Rpt. Lab Payment Report Monthly Bill (Payment) Report for Lab Services

135 IT System Rpt. Month End Reports IDB by fund, late fees, balance summary

136 Meter Services Work Order Report Completed work order per Type, Category, Month, and Yearly total

137 Meter Services Fire Hydrant Meter Activity Monthly active accounts, work orders types, number of hydrant meter tests and results

138 Meter Services Water Loss Report Monthly water usage of hydrant meter tester

139 Meter Services Inactive Locations Activity Monthly completed Inactive Investigation, Verify Lock, and Theft of Service work orders and results

140 Meter Services Meter Activity Report Meter and meter register/chamber exchanges and installs by meter type, size, and style per month and yearly total

141 Meter Services Delinquency Report Monthly delinquency work orders completed vs reactivation (same-day and next-day)

142 Meter Services Applied fees report Number of fees and dollar amount applied to accounts per month

143 Meter Services Number of connections Number of connections to Countys or Custom

144 Meter Services MS Stat Report Number of meters in the system (active and inactive) per install year, age, rate class, and size

145 Meter Services Backlog Reports Reports showing all open work orders per type, cycle, route district, and date

146 Meter Services Associated Devices Report Report showing all meter associated devices (register and SmartPoints) serial number per account number and address

147 Meter Services Same-day Report Report of Same-day work orders dispatched with crew number and timestamp

148 Meter Services Scheduled Work Orders Report showing all open work order scheduled for a certain date, cycle, route, and district

149 Meter Services Account Usage History Report showing a specific accounts monthly water usage

150 Meter Services Closed Work Orders Report on who close out work orders, time and date

151 Meter Services Cycle/Route Report on all account within a cycle and route

152 Meter Services Days Worked Report on the time lapse between work order created date and work order completion date

153 Meter Services Future Delinquency Report Forecasts the number off accounts delinquent on an upcoming cycle per delinquency calendar

154 Meter Services Meter Test Report on meter testing results (large and hydrant meters)

155 Meter Services Customer Info Report showing customer information based on meter criteria, or cycle and route

156 Meter Services Sequence Sequence number of locations

157 Meter Services Project Report Report on project progress and number of tasks related or Custom

158 Meter Services Crew Report Number of work order completed per crew (employee)

Stormwater Cisco Query

AR_ERATEC1

This query provides the current number of commercial accounts able to bill (must run to capture the current period).

Stormwater Cisco Query

AR_ERATEC2 This query provides the current number of commercial accounts able to bill.

Stormwater

AR_ERATEC3 This query provides the current number of commercial accounts not billing.

Cisco Query

AR_ERATER1

This query provides the current number of residential accounts able to bill (must run to capture the current period).

Stormwater

AR_ERATER2 This query provides the current number of residential accounts not billing.

AR_ERATER3 This query provides the current number of residential accounts not billing.

SW_A_COUN1 This query provides the total number of active Stormwater accounts.

Cisco Query

SW_A_COUN2

This query provides the total number of active residential Stormwater accounts.

Stormwater Cisco Query

SW_A_COUN3

This query provides the total number of active commercial Stormwater accounts.

Stormwater Cisco Query

BILRVW_SW1

This query provides the number of accounts that have .0001 in the component quantity field. (must run to capture the current period).

Stormwater Cisco Query

BILRVW_SW2

This query provides the number of residential accounts that have .0001 in the component quantity field.

Stormwater Cisco Query

BILRVW_SW3

This query provides the number of commercial accounts that have .0001 in the component quantity field.

Stormwater Cisco Query

SW_NO_COM1

This query provides the total number of accounts that are missing the SW rate code and rate class (must run to capture the current period).

or Custom

Stormwater Cisco Query

SW_NO_COM2

This query provides the total number of accounts that are missing the SW rate code and rate class (must run to capture the current period).

Stormwater Cisco Query

SW_NO_COM3

This query provides the total number of accounts that are missing the SW rate code and rate class (must run to capture the current period).

Stormwater Cisco Query

SW_NO_COM4

This query provides the total number of accounts that are missing the SW rate code and rate class for residential.

Stormwater Cisco Query

SW_NO_COM5

This query provides the total number of accounts that are missing the SW rate code and rate class for commercial.

Stormwater Cisco Query

SW_NO_QTY1

This query provides the total number of accounts that are missing the SW customer service maintenance data (must run to capture the current period).

Stormwater Cisco Query

SW_NO_QTY2

This query provides the total number of accounts that are missing the SW customer service maintenance data (must run to capture the current period).

Stormwater Cisco Query

SW_NO_QTY3

This query provides the total number of accounts that are missing the SW customer service maintenance data (must run to capture the current period).

Stormwater Cisco Query

SW_NO_QTY4

This query provides the total number of accounts that are missing the SW customer service maintenance data for residential.

Stormwater Cisco Query

SW_NO_QTY5

This query provides the total number of accounts that are missing the SW customer service maintenance data for commercial.

Stormwater

WA_NOT_SW1 This query provides customer maintenance information.

WA_NOT_SW2 This query provides customer maintenance information.

WA_NOT_SW3 This query provides customer maintenance information.

WA_NOT_SW4 This query provides customer maintenance information.

or Custom

Stormwater

WA_NOT_SW5 This query provides customer maintenance information.

Cisco Query

ALOCNOSW1

This query provides the location service file for each account (must run to capture the current period).

Stormwater Cisco Query

ALOCNOSW2

This query provides the location service file for each account (must run to capture the current period).

Stormwater Cisco Query

ALOCNOSW3

This query provides the location service file for each account (must run to capture the current period).

Stormwater

ALOCNOSW3B This query provides the location service file for each account for residential.

ALOCNOSW3C This query provides the location service file for each account for commercial.

Cisco Query

LISTALLSW1

This query provides the total number of ERUs (must run to capture the current period).

Stormwater

LISTALLSW2 This query provides the total number of ERUs for residential accounts.

LISTALLSW3 This query provides the total number of ERUs for commercial accounts.

AR_BP_AMT1 This query provides the total billed amount.

AR_BP_AMT2 This query provides the total billed amount for residential accounts.

AR_BP_AMT3 This query provides the total billed amount for commercial accounts.

COUN_A_RES This query provides active residential SW.

or Custom

Stormwater

COUNT_A_SW This query provides active commercial SW.

CUST_COUNT This query provides a list of all active SW accounts.

CUST_LIST This query provides a list of all active customer accounts.

Cisco Query

CUST_LISTP

This query provides a list of all active customer accounts (excludes some fields from CUST_LIST).

Stormwater

FWSCH_SW This query provides a list of all active Fort Worth school accounts.

Cisco Query

FWSCHOOLS

This query provides a list of all active Fort Worth school accounts (excludes some fields from FWSCH_SW).

Stormwater Cisco Query

FWSCHOOLS2

This query provides a list of all active Fort Worth school accounts (excludes some fields from FWSCHOOLS).

Stormwater Cisco Query

FWSCHOOLS3

This query provides a list of all active Fort Worth school accounts (excludes some fields from FWSCHOOLS2).

Stormwater Cisco Query

FWSCHOO400

This query provides a list of all active Fort Worth school accounts (excludes some fields from FWSCHOOLS3).

Stormwater Cisco Query

FWSCHOO420

This query provides a list of all active Fort Worth school accounts (excludes some fields from FWSCHOO400).

Stormwater Cisco Query

FWSCHOO460

This query provides a list of all active Fort Worth school accounts (excludes some fields from FWSCHOO420).

Stormwater

SW_ONLY_3 This query provides a list of all active Stormwater Only accounts.

SW_SWCR This query provides a list of all active customer accounts receiving credits.

or Custom

Stormwater

TOP_TENSW1 This query provides a list of the top ten Stormwater rate payers.

Cisco Query

TOPSW_400

This query provides a list of the top Stormwater rate payers (excludes some fields from TOP_TENSW1).

Stormwater Cisco Query

TOPSW_420

This query provides a list of the top Stormwater rate payers (excludes some fields from TOPSW_400).

Stormwater Cisco Query

TOPSW_460

This query provides a list of the top Stormwater rate payers (excludes some fields from TOPSW_420).

Stormwater

TOPTENSW1 This query provides a list of the top Stormwater rate payers by sum.

Cisco Query

TOPTENSW2

This query provides a list of the top Stormwater rate payers (excludes some fields from TOPTENSW1).

Exhibit A – REPORTS