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*	Property size value from (units)	Property size value to (units)	No. of taps	Rate
1	Residential	1	150	1	200
2	Residential	151	200	1	300

The data given in the table is sample data for reference.

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	Slab (Property size value)	Decimal	(10,2)	Yes	From and to value for property size
3	No. of Taps	Integer	2	Yes	No. of Taps to be recorded for calculation of water charges
4	Rate	Decimal	(3,2)	Yes	Consumption charges per unit corresponding to the usage type

Sr. No.

Column Name

Data Type

Data Size

Mandatory

Description

Property usage type

Alphanumeric

Yes

Specifies the property usage type

Slab (Property size value)

Decimal

(10,2)

Yes

From and to value for property size

No. of Taps

Integer

Yes

No. of Taps to be recorded for calculation of water charges

Rate

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.
Enter the Slab (property size value) range details in the From and To Value for property size.
Enter the value for No. of Taps. The water charges will be calculated on the number of taps.
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.