Water Rates (Non-metered)
Introduction
Water Charges are recurring charges levied for a pre-defined billing period. The billing period is configurable as per the state or ULB requirement. The rate for calculation of water charges vary widely and is dependent upon various parameters. Charges for water are dependent upon either plot size slab or No. of taps combined with property usage type. In some cases, they can also be solely dependent upon the property usage type.
Data Table
Sr. No. | *Property Usage Type | *Calculation attribute | Slab value from (units) | Slab value to (units) | *Charges |
---|---|---|---|---|---|
1 | Residential | Property Size | 1 | 150 | Rs 5/ unit |
2 | Residential | No. of taps | 1 | 5 | Rs100/ unit |
4 | Commercial | Flat fee (in Rs) | NA | NA | Rs 300 |
Note: The table above contains sample non-metered water rates data.
Procedure
Data Definition
Sr. No. | Column Name | Data Type | Data Size | Mandatory | Description |
---|---|---|---|---|---|
1 | Property usage type | Alphanumeric | 64 | Yes | Specifies the property usage type |
2 | Calculation attribute | Alphanumeric | 64 | Yes | Charges can be based on different cases. Record the calculation attribute based on which charges are calculated. |
2 | Slab value from and to | Decimal | (10,2) | Yes | From and to value for property size or for no. of taps |
4 | Charges | Decimal | (3,2) | Yes | Consumption charges per unit corresponding to the usage type |
Steps to fill data
Download the data template attached to this page.
Refer to the ‘Data Definition’ section of this document to learn more about the template sheet, data type, size, and definitions.
Please reach out to the person who has shared this template with you to discuss and clear your doubts.
Select the property type from the drop-down list available in the Property Usage Type column.
Select the calculation parameter based on which charges are calculated.
Enter the Slab range details in the From and To Value.
Enter the Rate or the per-unit water consumption charges that will be applicable for the listed parameters.
Verify the data once again by going through the checklist and making sure that each and every point mentioned in the checklist is covered.
Checklist
The checklist contains a set of activities to be performed once the data is filled into a template to ensure data entry requirements are met. These activities have been divided into 2 groups as given below.
Common Checklist
This checklist covers all the activities which are common across the entities.
Sr. No. | Checklist Parameter | Example |
---|---|---|
1 | Make sure that each and every point in this reference list has been taken care of. |
Entity Specific Checklist
Separate Entity Specific Checklist is not required for this module data.
Attachments
Configuration data template - Water rates (Non metered)
2. Sample configuration data - Water rates (Non metered)
@Omkar Ghatpande data table and template files are not matching. Same with sample file.