Laserfiche WebLink
<br />. <br /> <br />Modify all processing relating to querying the database to accommodate MFR and <br />Comm customers. <br /> <br />The term "account" as it appears in the user interface must be converted appropriately to <br />"customer", "site", or "account." <br /> <br />. <br /> <br />. All processing that is currently implemented at the account level must be performed at <br />the customer level, requiring summarization. <br /> <br />. Implement support for monthly or bimonthly billing for all customers (residential, MFR, <br />and Comm). <br /> <br />. Modify the customer website to accommodate either monthly or bimonthly billing. <br /> <br />Deliverables. Design, implementation, unit test. <br />Work Estimate. Not to exceed 140 hours. <br /> <br />DATA LOADING <br /> <br />Task Description. Values for CustomerlD, SitelD, CustomerClass, and BusinessType must be <br />loaded into UBS and available in the AccountsExtract table. For residential and probably MFR <br />customers, determining these values will be simple and straightforward. However, it may be <br />more difficult for Comm customers. This work must be performed by Redwood City IT in <br />conjunction with Public Works Services. <br />Default values for allocation factors for MFR and Comm customers will be established, thereby <br />obviating the need to load non-default values immediately. Public Works Services can load non- <br />default values at their convenience. <br />Deliverables. None. <br />Work Estimate. 0 hours. <br /> <br />DROUGHT SCENARIOS <br /> <br />Task Description. Drought scenarios are a mechanism for determining the total annual water <br />allocations for each of the three customer classes using three different sets of allocation <br />formulas. An interface will be provided in wapadmin1 to allow the system administrator to modify <br />the drought allocation formulas and to generate the drought reports. The administrator will also <br />be able to generate a report showing the impact of changing the current allocation factors on <br />yearly allocations. <br />. Create database tables to maintain drought scenario information. <br /> <br />. Design/implement user interface for managing scenarios. <br /> <br />Deliverables. Design, implementation, unit test. <br />Work Estimate. Not to exceed 60 hours. <br /> <br />SYSTEM TEST <br /> <br />Task Description. Perform complete system test in coordination with Redwood City IT. <br />Deliverables. System test plan and results. <br />Work Estimate. Not to exceed 60 hours. <br /> <br />Agreement over $10K <br />City Attorney Approved Version 111803 <br /> <br />12 <br />