Water & Sewer Utility Billing > $50,000 Sewer Annually

Greg Trout filed this request with the Nashville Metro Water Services of Nashville, TN.

It is a clone of this request.

Est. Completion None
Status
Withdrawn

Communications

From: Carlton Purvis

To Whom It May Concern:

Pursuant to Tennessee's Public Records Act, I hereby request the following records:

Actual copies or histories of all water and sewer bills for the previous 12 months for any and all accounts or meters tied to customers spending over $50,000 annually on sewer services.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 7 business days, as the statute requires.

Please note that I am a citizen of Tennessee, and am using MuckRock's services to help manage and track my request.

Sincerely,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

The original request was sent to the Police Department. The first request MWS received was on August 12, 2016 from Greg Trout. On August 17, 2016, I asked for proof of TN citizenship.

A second request was made on August 22, 2016 from Alexander Smith.. On that same day, I requested proof of Tennessee citizenship from Mr. Smith.

I have not received proof of citizenship from either of the previous requestors.

Please provide proof of TN citizenship for the current request received on October 12, 2016.

Sincerely,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Allman, Sonia (WS)

Thank you Mr. Purvis.

Could you please provide responses to the questions below so we can be sure to gather the appropriate data?

Do you want records for $50,000 in water and sewer charges combined or sewer charges alone?
Should we include taxes, etc. in that amount?
Should we include sewer surcharges in that amount?
Would you like this based on individual meter or by account?
Is this previous 12 months from current date?
The term "spending" is used in the request, does that mean billed and paid?

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

Records specific to facilities receiving over $50,000 in annual sewer charges alone would be ideal - the inclusion of surcharges and taxes would be preferable.

If it's practically feasible to sort the responsive data to include facilities with multiple accounts adding up to over the $50,000 threshold, that would be great, but if not, by account should be fine.

Yes, if possible, 12 months from the current date would be perfect!

Spending was intended to refer to facilities which were billed for and paid for $50,000+ in sewer service-related charges in the previous 12 months - my apologies for the confusion.

Please let me know if you should need any additional information in order to proceed - I hope this message finds you well!

Sincerely,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

We are still awaiting clarification regarding your records request.

Will you please clarify your request by answering the questions below?

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

I apologize - my reply must not have sent correctly. It was as follows:

Records specific to facilities receiving over $50,000 in annual sewer charges alone would be ideal - the inclusion of surcharges and taxes would be preferable.

If it's practically feasible to sort the responsive data to include facilities with multiple accounts adding up to over the $50,000 threshold, that would be great, but if not, by account should be fine.

Yes, if possible, 12 months from the current date would be perfect!

Spending was intended to refer to facilities which were billed for and paid for $50,000+ in sewer service-related charges in the previous 12 months - my apologies for the confusion.

Please let me know if you should need any additional information in order to proceed - I hope this message finds you well!

Sincerely,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

Thank you for the clarification.

It will take us approximately 10 hours to gather, sort and redact the requested information at a cost of $394.65. ( $43.85 x 9 )

Please advise if this is acceptable and if we should proceed?

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

Would you be able to advise as to what information might be redacted in this case?

Additionally, would it be more readily practicable (or cost-effective) if I were to alter my request to a list of names and addresses for any customers meeting my initial criteria, then requested location-specific billing data from the list?

Thank you,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

We are creating a list of service addresses (by account number) that have > $50,000 in sewer billing for the past year, as requested.
The customer name and account number will be redacted.

Please advise if this is not what you have requested.

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Allman, Sonia (WS)

Mr. Purvis,

Your request, including account number, customer name, address and amount is being gathered.

Would you prefer the invoice for $394.65 be mailed to you at Apt 486 ; 104 Sawyer Circle, Memphis, TN 38103 or emailed?

Once the payment has been received, I will email the excel spreadsheet with the requested data.

Sincerely,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

It was my understanding that the invoice for $394.65 pertained to my original request for 12 months of billing data - does the same cost apply to the compiled list of service addresses?

My apologies for any confusion, but if the case is that $394.65 is to be the cost, I would greatly appreciate it if you would give me until next Friday to determine how and whether to proceed.

Best,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

Yes, $394.65 will be the cost to gather the requested data.

We can wait until next Friday to proceed.

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

Would you possibly be able to advise as to why it's been estimated that the list of names and addresses would take the same amount of time to compile as 12 months of billing for each such service address?

Additionally, would you be able to provide an estimate of how many service addresses would be included in a response to my request?

I'm unsure if it's been noted to this point, but if the (hypothetical at this point) final decision was that I would be going with the billing records as opposed to just the list of service addresses, I'd also like to ensure that the consumption used to calculate water and sewer billings is included - would that affect the charges incurred?

I again apologize for any confusion - I just want to ensure the charges incurred in proceeding with my request are reasonable with regards to the amount of data I would be receiving. Either way, I sincerely appreciate your patience, and hope this message finds you well.

Thank you,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

Responses to your questions are below. Please let me know how you would like to proceed.

Would you possibly be able to advise as to why it's been estimated that the list of names and addresses would take the same amount of time to compile as 12 months of billing for each such service address? There may be some confusion here, the name and address is included as part of the listing of customer accounts with sewer charge totals that exceed $50,000.00 for the past 12 months.
Additionally, would you be able to provide an estimate of how many service addresses would be included in a response to my request? No, not until the report is ran and then filtered for totals that exceed $50,000.00.
I'm unsure if it's been noted to this point, but if the (hypothetical at this point) final decision was that I would be going with the billing records as opposed to just the list of service addresses, I'd also like to ensure that the consumption used to calculate water and sewer billings is included - would that affect the charges incurred? Sewer flow totals was not in your original request when the custom report development assessment was calculated and the quote provided to you. Yes, it could possibly increase the amount quoted since the original request was for sewer charge totals for the past 12 months that exceed $50,000.00. Please advise if you would like to proceed with the original request or modify that request to also include sewer flow.
Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

Upon further review, I would like to wholly revise my request - if possible, rather than going the route of requesting data on all locations spending above $50,000 annually on sewer, I am now looking to obtain a history of all water/sewer billing (including consumption) for the previous 12 months for any and all accounts and meters tied to the following 30 locations (please note that service address may vary):

Carlex Glass Company
7200 Centennial Blvd, Nashville, TN

Nashville State Community College
120 White Bridge Rd (Campus), Nashville, TN

The Mall at Green Hills
2126 Abbott Martin Rd, Nashville, TN

TriStar Centennial Medical Center
3901 Granny White Pike (Campus), Nashville, TN

Tennessee State University
3500 John A Merritt Blvd (Campus), Nashville, TN

Vanderbilt University
2201 West End Ave (Campus), Nashville, TN

Tennessee Valley Healthcare System - Nashville Campus
1310 24th Ave S, Nashville, TN

Vanderbilt University Medical Center
201 Light Hall, 2200 Children's Way, 2200 Pierce Ave, Nashville TN

Belmont University
1900 Belmont Blvd (Campus), Nashville, TN

Broadcast Music Inc.
10 Music Square E, Nashville, TN

Coca-Cola Bottling Co.
407 Craighead St, Nashville, TN

Nissan Stadium
1 Titans Way, Nashville, TN

Country Music Hall of Fame & Museum
222 5th Ave S, Nashville, TN

State of Tenn
310 Rosa L Parks Ave, Nashville, TN

The Tennessean Building
1100 Broadway , Nashville, TN

Regions Bank
1600 Division St, Nashville, TN

Andrew Johnson Tower
710 James Robertson Pkwy, Nashville, TN

Bank of America
414 Union St, Nashville, TN

DoubleTree by Hilton
315 4th Ave N, Nashville, TN

UBS Tower
315 Deaderick St, Nashville, TN

BellSouth Telecommunications Inc
185 2nd Ave N, Nashville, TN

Hilton Nashville Downtown
121 4th Ave S, Nashville, TN

Bridgestone Arena
501 Broadway, Nashville, TN

The Pinnacle at Symphony Place
150 3rd Ave S, Nashville, TN

Purity Dairies LLC
360 Murfreesboro Pike, Nashville, TN

Glencliff High School
160 Antioch Pike, Nashville, TN

UniFirst Uniform Services
813 Massman Dr, Nashville, TN

Supreme Oil Company
189 Spence Ln, Nashville, TN

Grand Ole Opry
2804 Opryland Dr, Nashville, TN

Gaylord Opryland Resort & Convention Center
2800 Opryland Dr, Nashville, TN

Again, I apologize for the confusion - hopefully this marks the last change to my request. Thank you very much for your patience. I hope you enjoy the holiday!

Sincerely,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

There are numerous meters tied to the locations listed and acquiring the account numbers for each will be a manual process.

It will take staff approximately 51.67 hours to research and identify the accounts and build the query, resulting in a total cost of $2,221.88 (50.67*$43.85).

Please advise if you would like us to proceed.

Sincerely,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

I'm surprised to see that the request for specific locations would incur more labor charges than the request for all locations spending above $50,000 - my intent in revising the request was to make the process of gathering information more expedient. Would you be able to provide any suggestions as to what changes to the request could be made to decrease the labor hours, and accordingly, the costs involved?

Thank you,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

For custom report development the cost will not be any cheaper than the original quote of $394.65 as that request was general enough in nature and would not require a lot of manual effort other than the query configuration with custom filtering and logic.

The amount will significantly increase the more specific the request becomes as the report analysis and development will then require a manual process to visually collect and validate the account identifiers. In this case, the request was changed to wanting data on 30 locations. Our Customer database contains in excess of 200k customer accounts that have variable customer data with a one to many relationship. Meaning, there is not a defined structure in the customer name or service address and one customer can have multiple accounts as could the service address.

Examples in name variations: T.S.U., TSU, T S U, Tennessee State University, Tennessee State, State of Tennessee-TSU, TSU/Football Practice Facility

Examples in address variations: 3204 JOHN A MERRITT BLVD, 2700 JOHN A MERRITT BLV, 3800 ALBION ST, 1721 ED TEMPLE BLV, 3200 JOHN A MERRITT BLV, 3500 JOHN A MERRITT BLV, 3400 JOHN A MERRITT BLV, 2800 JOHN A MERRITT BLV, 3100 JOHN A MERRITT BLV, 3700 JOHN A MERRITT BLV, 3700 ALAMEDA ST, 3511 JOHN L DRIVER AVE, 1120 35TH AVE N, 1115 37TH AVE N, 1220 37TH AVE N

Sincerely,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

From: Greg Trout

Ms. Allman,

I see - I appreciate the clarification. Considering the cost, I think it's unlikely that I'll want to proceed with the more specific request.

Based on prior correspondences, it is my understanding that the 10-hour estimate for the general request would include gathering, sorting and redacting the information requested. Would you be able to advise as to how you came to the estimate of 10 hours?

Additionally, I would presume that increasing the threshold for the more general request (for instance, to $100,000 annually) would decrease the number of results returned - would that modification result in a decreased labor requirement for the request?

Thank you,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

The estimate is based on the amount of time it will take to develop the custom report. As stated on 12/02 the cost for custom report development will not be any cheaper than the original quote of $394.65 as that request was general enough in nature and would not require a lot of manual effort other than the query configuration with custom filtering and logic. As mentioned on 11/22 there is no redaction as the customer name and address were included in the original report request quote.

There would not be any expected changes in the quote by reducing or increasing the total annual sewer charges filter as the filter would still have to be configured during the report development.

Please advise as to whether or not we shall proceed with the report.

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

You had advised on 11/7 that it would take approximately 10 hours to gather, sort and redact the requested information at a cost of $394.65.

You then noted on 11/8 that the customer name and service address were to be redacted.

You now indicate that no redaction is required. As the case now appears to be that the customer names and service addresses are not to be redacted in response to this request, I would think that the manual effort required to redact would no longer be a factor in calculation of costs, and that the labor requirement should decrease from the 10-hour estimate you'd provided.

With regards to the labor estimate, I would request a more detailed breakdown as to how you arrived at the 10 hours you advised. While I understand that is the time you estimate the development of the report will take, considering the estimated cost, I will need more in-depth information as to what you anticipate this 10 hours to entail to determine whether the estimate appears to be reasonable in accordance with Tennessee code.

Thank you,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

The report will be done by one of our Customer Service database professional as I do not have access to the database. In my earlier email, I erroneously stated that redaction was included in the estimated time.

The 10 hours quoted are for custom report development for extracting electronic data and preparation of a deliverable report. It includes defining data needed in report, reviewing metadata to determine needed tables and joins, creating the query, creating report parameters, creating custom filters and aggregate conditions, setting up controls, validating results, etc.

Sincerely,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

My apologies for the delay in response. I am considering proceeding with this request at the $394.65 estimate - would you possibly be able to provide a sample report of some sort just to confirm the format and the data points which would be contained in the report for each customer to be included in the final response?

To reiterate, I am looking to obtain 12 months of water/sewer billing (itemized if possible and including all relevant consumption information) for all customers who were billed $50,000 or more annually for sewer service (including those customers with multiple accounts which would add up to $50,000 or more annually).

Thank you,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

The following information will be provided in and Excel spreadsheet:

ACCOUNT CUSTOMER NAME ADDRESS UNIT ZIP AMOUNT

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

To clarify, would the "amount" that you refer to be the total annual sewer billing for a particular customer?

As was noted in my previous e-mail, I'm looking to obtain a full 12 months of billing (set out per bill period, with columns for water and sewer bill amounts and the associated consumption) for each customer included in this report, and noting that the data responsive should include customers with multiple accounts adding up to the $50,000 annual sewer spend threshold. So long as those data points are included, we should be willing to accept the charges you estimated. Could you confirm or advise as to how those adjustments might affect pricing?

Thank you,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

Once again, you have revised your request and the custom development amount originally quoted will need to be re-scoped and re-quoted. Please advise if you would like to proceed with the original request made on Oct. 24, 2016 (below)at the previously quoted cost of $394.65 or if you would like for us to re-scope the effort and re-quote based on your February 10th response.

Ms. Allman,
Records specific to facilities receiving over $50,000 in annual sewer charges alone would be ideal - the inclusion of surcharges and taxes would be preferable.
If it's practically feasible to sort the responsive data to include facilities with multiple accounts adding up to over the $50,000 threshold, that would be great, but if not, by account should be fine.
Yes, if possible, 12 months from the current date would be perfect!
Spending was intended to refer to facilities which were billed for and paid for $50,000+ in sewer service-related charges in the previous 12 months - my apologies for the confusion.
Please let me know if you should need any additional information in order to proceed - I hope this message finds you well!

To reiterate our past communications:

On October 20th MWS requested that you clarify your request by answering a series of questions for us to complete our report analysis.

On October 24th, 2016 you clarified your request as "Records specific to facilities receiving over $50,000 in annual sewer charges alone would be ideal - the inclusion of surcharges and taxes would be preferable.
If it's practically feasible to sort the responsive data to include facilities with multiple accounts adding up to over the $50,000 threshold, that would be great, but if not, by account should be fine.
Yes, if possible, 12 months from the current date would be perfect!
Spending was intended to refer to facilities which were billed for and paid for $50,000+ in sewer service-related charges in the previous 12 months - my apologies for the confusion."

On November 7th MWS quoted the cost for the customer report development to be $394.65
On November 8th MWS advised that "we are creating a list of service addresses (by account number) that have > $50,000 in sewer billing for the past year, as requested.
On November 9th MWS followed up advising that "Your request, including account number, customer name, address and amount is being gathered."

On November 17th you advised that you wanted the water and sewer consumption included.

On November 22nd, MWS advised you that your request to include "sewer flow totals was not in your original request when the custom report development assessment was calculated and the quote provided to you. Yes, it could possibly increase the amount quoted since the original request was for sewer charge totals for the past 12 months that exceed $50,000.00."

On February 2nd you responded "To reiterate, I am looking to obtain 12 months of water/sewer billing (itemized if possible and including all relevant consumption information) for all customers who were billed $50,000 or more annually for sewer service (including those customers with multiple accounts which would add up to $50,000 or more annually)."

On February 10th MWS responded "The following information will be provided in and Excel spreadsheet:
ACCOUNT CUSTOMER NAME ADDRESS UNIT ZIP AMOUNT"

On February 10th your request changed "As was noted in my previous e-mail, I'm looking to obtain a full 12 months of billing (set out per bill period, with columns for water and sewer bill amounts and the associated consumption) for each customer included in this report, and noting that the data responsive should include customers with multiple accounts adding up to the $50,000 annual sewer spend threshold. So long as those data points are included, we should be willing to accept the charges you estimated. Could you confirm or advise as to how those adjustments might affect pricing?"

We will not proceed until direction is given and if request is to remain as previously stated on October 24, you advise if the invoice for $394.65 is to be mailed to you at Apt 486 ; 104 Sawyer Circle, Memphis, TN 38103 or emailed.

Sincerely,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

I apologize for the confusion, but would like to go the route of the data requested in my February 10th revision. If the case is that the estimate will need revision, that is acceptable - I will await further information on that front.

Thank you,

Carlton Purvis

From: Allman, Sonia (WS)

Mr. Purvis,

Based on what was originally quoted and the revision to the request, we have some additional questions and clarifications before we can complete the re-quote. Will you please respond to the following?

* Should the water charges include any applicable billed taxes?
* Should the report include only the water and sewer total usage or should it show the actual usage for each meter/service for each bill period?
* A single account may have one or more meters/services. Only singular accounts with sewerage charges greater than $50,000 will be selected based on the filter request. As stated on 11/29/2016 linking multiple accounts together would be a manual process. Are you requesting that we link accounts?

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Ms. Allman,

My apologies for the confusion! I have addressed below:

• If possible, billed taxes should be included.

• Total usage per bill period would most likely be fine if that is what you mean - if it helps to clarify, there is no need to separate usage by meter, so long as it is possible to calculate each of the billed amounts given rates and the respective water and sewer consumption.

• Understood. Would it be possible to obtain an estimate both ways with regards to linking accounts? Ideally accounts would be linked in the interest of receiving complete data for each facility, but if costs are significant to do so, it might be more practical to simply go the route of singular accounts.

Further, could you advise as to whether it would require the same amount of effort as linking accounts to obtain a total for the threshold assessment to instead simply include all accounts for a customer with a single account which meets the threshold?

I apologize for the complexity of this request - I'm just trying to ensure that the responsive data is complete on a per-facility basis, and that the costs of obtaining the data are not unreasonably high. Either way, thank you for your help.

Best,

Carlton Purvis

From: Greg Trout

Good morning Ms. Allman,

I thought I'd check in to see whether any further information was available regarding estimated costs for my updated request. I hope this message finds you well.

Best,

Carlton Purvis

From: Allman, Sonia (WS)

Carlton,

We are still not completely clear on what you are requesting….

The vast majority of all sewer billings are based on implied registered water usage (meaning sewer is not metered for 99.9% of our customers). If you’re trying to back into the water charges based on usage then we would need to include the customer class and meter size as that is how our rates are configured. Would you agree and is this what you’re attempting to do?

In the matter of linking accounts, what common thing would we be linking on as the account numbers would be different as well as most likely the customer name and property address too? As indicated on 11/29 this may become a manual process and would more than likely meet or exceed the original quote of 51.67 hours to research and identify the accounts and build the query.

Regarding the next question which is not real clear, please clarify what you mean by “total for the threshold assessment” and “include all accounts for a customer with a single account which meets the threshold”.

Best,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Sonia,

Understood.

Yes, that should be perfect - I am indeed trying to back into water (and sewer) charges based on usages. As such, I think customer class and meter size would be helpful!

I'm actually not certain what item would be most useful in linking accounts, especially in the case that customer names would differ on an account-to-account basis. Is it possible that the mail-care-of name or mailing address for bills would be the same for a particular customer regardless of customer name and service address? If not, could you advise as to how best I might go about linking accounts otherwise?

Short of trying to sort out a method of linking accounts, I might simply go the route of requesting individual accounts that exceed the threshold. In that case, it might be helpful to lower the threshold in order to capture accounts for customers with multiple significant billing accounts. As most of the processing of this request seems as if it will be done via a database search query, I don't imagine that lowering the threshold (for example, to $25,000 in sewer billing annually) would have too much impact on the costs - could you advise?

Please feel free to disregard my other question - if I recall, I was trying to go one step beyond linking accounts by customer and see whether sewer billing could be totalled on a per-customer basis. This seems to be less practical than I'd thought, especially if customer name and similar are unlikely to be consistent for all of a particular customer's accounts.

Thanks again,

Carlton Purvis

From: Allman, Sonia (WS)

Carlton,
Please see the response to your questions below in blue.
I'm actually not certain what item would be most useful in linking accounts, especially in the case that customer names would differ on an account-to-account basis. Is it possible that the mail-care-of name or mailing address for bills would be the same for a particular customer regardless of customer name and service address? If not, could you advise as to how best I might go about linking accounts otherwise? Not necessarily, commercial accounts are subject to have a different mailing address for each account based on the responsible party that oversees the billing or remits payment for the department, branch, etc. of the commercial customer. As stated previously, this would become a manual process to research and identify a way to link individual accounts.
Short of trying to sort out a method of linking accounts, I might simply go the route of requesting individual accounts that exceed the threshold. In that case, it might be helpful to lower the threshold in order to capture accounts for customers with multiple significant billing accounts. As most of the processing of this request seems as if it will be done via a database search query, I don't imagine that lowering the threshold (for example, to $25,000 in sewer billing annually) would have too much impact on the costs - could you advise? As mentioned previously, there would not be any expected changes in the quote by reducing or increasing the total annual sewer charges filter as the filter would still have to be configured during the report development.
Please advise if you would like a revised quote for the development of a custom report of all accounts where sewer exceeds $50,000 annually in charges. The report would include total billed sewer flow and associated water charges and consumption broken out by billing period and would also include rate configuration data such as; customer class and meter size for the requestor to back into the charges for consumption/flow.
Best,
Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Sonia,

Ah, I see - thank you for the clarification. In that case, a revised quote to meet the specifications you noted sounds perfect! I will await further information.

Best,

Carlton Purvis

From: Allman, Sonia (WS)

Carlton,

A custom report of all accounts where sewer exceeds $50,000 annually in charges and includes total billed sewer flow and associated water charges and consumption broken out by billing period and also rate configuration data such as; customer class and meter size for the requestor to back into the charges for consumption/flow will take approximately 15 hours to create at a cost of $613.90. ($43.85 x 14).

If you would like to proceed, please advise if the invoice should be mailed to you at Apt 486 ; 104 Sawyer Circle, Memphis, TN 38103 or emailed to requests@muckrock.com<mailto:requests@muckrock.com>

Sincerely,

Sonia Allman
Manager of Strategic Communications
Metro Water Services
(615) 862-4494

Access account information and pay your bill online<https://mwsonline.nashville.gov/iwr/user/login.seam>

From: Greg Trout

Sonia,

I appreciate the estimate. Given the cost, I think it's best if I hold off on proceeding with this request for now, though I may revitalize the conversation in a few months - my apologies for the confusion.

Best,

Carlton Purvis

Files