eGov Release Specification for Pay - Water & Sewerage in Punjab
Revision - 0.5 (after feedback from Ajoy)
CAVEAT - Yet to be signed off by Ajoy Sharma, CEO PMIDC

Release Specification

We will follow the Agile philosophy of making the first release as soon as possible and following it up with frequent releases

	Release 1 (Target date - May end assuming f2f sign-off of FWSD, and availability of Punjab W&S SME by April 23)	Release 2 (+ approximately 1 month) and 3
Goal	Replace current handwritten, book based, counter payment system to software based for limited number of ULBs and limited number of use cases Identify thematic data and process problems in target ULBs to help with PMIDC future plan for Uniform Water Policy (UWP) implementation Allow citizens to pay using web (must work well for mobile app based browsers) Handle metered connections and different payment schemes Get in sync with Ajoy figure out sewerage registry Minimal business process reengineering (by selecting target ULBs carefully) PDF bill & receipt printing will replace pre-printed stationery Employees will carry tablet / mobile and when collecting bills in the field will handout a handwritten receipt but system generated receipt number	Mobile App? Punjab wide Release 2 More revenue Release 2 Our understanding is incomplete but we are almost certain that some business process reengineering will be required in ULBs with the deployment of eGov platform. Here are some examples (this is not comprehensive) Every ULB will be required to specify a common billing structure ULB wide (possibly UWP) Bill grouping strategy for printing & distribution may have to change Standard property, water, sewerage id format across state Current software systems will be replaced by eGov system
Target ULBs	In order to enable aggressive schedule, 5 or more target ULBs that are similar to each other in terms of connection types, water & sewerage billing logic, and bill generation process will be selected. We assume these ULBs have: Only non-metered water connections Water bill calculation(for both residential and commercial) is common through out the ULB and is plot based Sewerage bill is equal to water bill One billing frequency per ULBs All bills are generated in the same batch (one batch per quarter) There is no software being used and all bills are hand written Property and Sewerage connections are separately maintained 5 target ULBs	Deployed in all 167 ULBs in a phased manner Bill collection is tap based - Release 2 Replaces existing software system in ULBs that have them - Release 2
Limitations	Pay W& S only. Not Apply
Identify data & process issues	Will identify following gaps in data & processes (based on our understand UWP) Missing phone number(for better communication + distribution) Plot size (for consistent bill calculation logic across the state) Address (to allow integration with property tax and for bill distribution) Associating water connections with sewerage and both with property	Will identify additional revenue opportunities, e.g., property with water but no sewerage and vice versa - Release 2
Database / Registry	Property Citizen Water Connections Sewerage Connections Employee
Data Import	Excel data uploader with data validations for all registries Authorized employee can edit demands - to be able to correct errors in historical data and introduced during data digitization exercise	Data migration kit to allow replacement of existing software systems - Release 2
Water Bill Calculation	Non-metered - Plot based billing (only one per ULB) If plot size is available - Plot size based If plot size is not available - Fixed fee (Rs. 200 per connection) Fixed per connection (but configurable) Metered Bill Base	Tap based billing - Release 2 Metered Connections - send out bill based on reading - Release 2 Ad-hoc charges - Release 2
Sewerage Bill Calc	Equal to water bill	Based on number of seats - Release 2 Based on plot size - Release 2
Rebates, Penalties, Exemption, Interests	Exemptions : exempted upto plot size of 125 sq.yds Rebates : 10% ; date based Penalties : 10% ; date based Interest : to be figured out Configurations : ULB can enable / disable the ERPI from a list Can change the values of the ERPIs Can change the rule(number of days) for rebate & penalty
Bill Printing	System generates bills in PDF format
Bill Generation	Separate bills for water & sewerage One frequency per ULB (either bi-monthly or quarterly ) Bills grouped based on the logic as being followed	Batch wise grouping (for distribution) - to be thought through
Bill Distribution	No change	Bills sent to mobile app or email - Release 2
Update Bill	Authorized employees can edit / update demands to account for data errors (past / migration)
Payments & Collections	Integrate with payment gateway Handling cheque bounce cases Receipt generation	Part & advance payment
Meter Reader	Search and view connections Capture current reading / Mark no reading taken
Counter Collections	Search and View connections Collect payment and log payment details Generate and print receipts Collect cash / card / cheque / DD	UPI integration - Release 2 Integrate with wallets - Release 2
Field Collections	Search and View connections Collect payment and log payment details Hand out manual receipts with digital-receipt number Collect cash / card / cheque / DD	UPI integration - Release 2 Integrate with wallets - Release 2
Citizen - self pay	Pay through website Cards, net-banking	Pay through mobile app UPI and wallets - Release 2
Notification	Sent by SMS if mobile number available	In app notifications - Release 2 Email notifications - Release 2
Reports & Dashboard	Region and date-wise reports on collections, demands, defaulters	Visual and time-series charts for demand and collections - Release 2 Region-wise drill down - Release 2

62307c16344324cc7b7ee/images/c99e291a-60c7-4102-b809-e3ed48b32287.png" style="border: 0px ; width: 150px; height: 123px; in: 0px;" width="100" /></span></span></strong></span><br />
</p>

Browser not supported