Agmt19 True Point Solutions - Laserfiche WebLink

Browse Search

Agreement for TruePoint Services Exhibit D — Water Budget Methodology d. There shall be no limit to the number of primary and secondary water use type budgets a named budget formula can be applied to. (i.e. a single budget formula can be applied to primary for WUT 12 and 5, and also secondary for WUT 5. It may also be that there is a separate formula for each WUT and each primary and secondary formula.) e. Budget formulas shall have a "save as" function, so authorized users can make copies from a known/tested starting point. f. Budget formulas shall be editable in part or whole without the need to re-create the complete formula should only one change be required. g. There shall be a way to validate the syntax of a budget formula upon or prior to saving the formula. Only validated formulas can be assigned as primary or secondary budget. 4. A water budget shall be calculated daily for each subsite for the previous day, and transmitted to the City's My Water Customer Portal for customer use. 5. Following the completion of a consumption period and prior to billing an account a water budget shall be calculated for the full consumption period within a billing cycle for each subsite. 6. A water budget shall be calculated for closing accounts from the beginning of the consumption period through the date the account is closed. This calculation shall be complete prior to the calculation of charges and printing of a closing statement. 7. There shall be a Weather Data Override Period which enables authorized users to manually enter or edit ETo and Precip data. a. The Weather Data Override Period is a dynamic date range that affects budget calculations for all accounts/subsites and prevents budgets from being recalculated in part or in whole for accounts that have been billed. Weather data is only editable for dates between today and the most recent unbilled date that falls within the consumption period for any water account. 8. TruePoint shall work with the City to establish the ideal order of operations for each step in the budget calculation process. The following provides an initial processing order which may need to be refined based upon organizational needs, changes to CIMIS and WU services, and related integrations with other software systems. a. Make initial request for ETo through the CIMIS API i. If CIMIS is unavailable or returns an error the application shall wait 5 minutes and retry. ii. A total of 3 attempts shall be made daily to retrieve ETo (1 initial, 2 retries) iii. If all 3 attempts fail to collect ETo for a target date the system shall skip the calculations for NIR and use a historical average NIR value as a placeholder for the target date (typically yesterday). iv. The application shall attempt to obtain ETo from CIMIS each day following a failure to obtain ETo for a target date until one of the following conditions are met: 1. An authorized user manually enters an ETo value for the target date. 2. The Weather Data Override Period has ended. (In this case the historical placeholder shall become a permanent part of the water budget for the target date.) b. Make initial request for Precip through the WU AN REV: 04-23-19 PR Page 39 of 64 Water Budget Methodology Page - 39 - ATTYIAGR.2019.106lrruePoint TrueBill Utility Billing System