Agmt06 KorTech Consulting - Laserfiche WebLink

Browse Search

location of the customer's building complex (e.g. house, garage, etc.), and all associated land. It is generally one parcel. For MFR customers, a site is the location of the building complex and all associated land. For Comm customers, a site is all of the buildings to which the customer supplies water at a location, and all associated land. Water is allocated to a site, not to an account, meter, or customer. However water consumption is measured at a meter, and billed to an account that represents that meter. This misalignment creates issues in dealing with allocations that must be resolved. 1. City of Redwood City currently communicates with its water customers at the level of the account1 (if summary billing applies, then several accounts may be aggregated on one bill). Since accounts are not currently grouped to a site, new mechanisms for communicating allocation information must be developed. This would apply to informational messages (e.g. advisory messages about allocations or comparisons of consumption and allocation) and possibly penalty bills when consumption exceeds allocation. 2. Site allocation will be calculated based on site-wide factors such as landscape area, number of occupants, etc. Allocations will apply to a 3D-day or 50-day period2, depending on the billing period of the designated primary account at the site. However, it is possible that a site may have accounts with different billing periods and with different billing dates. If this occurs, comparing allocation to consumption will be difficult. A remedy to this problem would be to require that all accounts at a site have the same billing period and date. 3. A proposed allocation factor for Comm customers is Business Type. However it is conceivable that many different businesses could be located at a site, and Business Type must apply to the entire site. 4. If penalties are imposed based on consumption exceeding allocation, a formula will be needed to calculate the penalties. Because allocation applies to the site, it will be impossible to prorate excess consumption to the meter. Hence a site-wide rate penalty structure will be required. This requirement to redesign the data model provides an opportunity to improve significantly the linkage with UBS, Redwood City's Utility Billing System. Rather than importing account updates monthly from UBS as it currently does, the WAP database will link to the newly available UtilityBilis SOL database that contains current account data for all utility customers. In order to support the new data model, both the UBS and the UtilityBilis database will have to be enhanced. The following tasks will be performed to implement the new data model: . Redesign the data model to support the customer - site - account - meter relationship. Some of this work must be performed by Redwood City IT. . Modify all processing relating to managing allocation factors to accommodate MFR and Comm customers. 1 Landscape Water Use Reports prepared by BMP 5 Services are sent to some Comm customers. They describe water consumption and water budget for a site. 2 To be exact, billing periods run from a given day of one month to the same day of the next month (if monthly) or 2 months out (if bimonthly). Thus the number of days in a billing period is a function of the number of days in the current and next month. Agreement over $10K City Attorney Approved Version 111803 11