Water Rates (Metered)
Introduction
Water Charges are levied for metered connections based on consumption. The rate for calculation of water charges varies widely and is dependent upon various parameters. In DIGIT W&S module, water charges defined are based on actual consumption and property usage type.
Data Table
Sr. No. | *Property Usage Type | *Water consumed value from (units) | *Water consumed value to (units) | *Rate (in Rs/ unit) |
|---|---|---|---|---|
1 | Residential | 1 | 150 | 3 |
2 | Residential | 150 | 300 | 4 |
Note: The above table contains sample metered water rates data.
Procedure
Data Definition
Sr. No. | Column Name | Data Type | Data Size | Mandatory | Description |
|---|---|---|---|---|---|
1 | Property usage type | Alphanumeric | 64 | Yes | Refer Usage Category Major |
2 | Water consumed value from | Decimal | (5,3) | Yes | From value for water consumed |
3 | Water consumed value to | Decimal | (5,3) | Yes | To value for water consumed |
4 | Rate | Decimal | (3,3) | 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.
Enter the Slab (water consumed) range details in the From and To Value for water consumed.
Enter the Rate for the specified slab range and property type.
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 is a set of activities to be performed one the data is filled into a template to ensure data type, size, and format of data is as per the expectation. 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. | https://digit-discuss.atlassian.net/wiki/spaces/DO/pages/502203140 |
Entity Specific Checklist
Separate Entity Specific Checklist is not required for this module data.
Attachments
Configuration data template - Water rates (metered)
2. Sample configuration data - Water rates (metered)
@Omkar Ghatpande
the consumption is a continuous value while here it has defined as discrete value which creates confusion. For example if for residential property the consumption is 150.4 then how the system will calculate.
“Water Consumed value to” is represent < or <= ( According to sample excel it represent <