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

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

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

  1. Download the data template attached to this page.

  2. Refer to the ‘Data Definition’ section of this document to learn more about the template sheet, data type, size, and definitions.

  3. Please reach out to the person who has shared this template with you to discuss and clear your doubts.

  4. Select the property type from the drop-down list available in the Property Usage Type column.

  5. Select the calculation parameter based on which charges are calculated.

  6. Enter the Slab range details in the From and To Value.

  7. Enter the Rate or the per-unit water consumption charges that will be applicable for the listed parameters.

  8. 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

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

  1. Configuration data template - Water rates (Non metered)

2. Sample configuration data - Water rates (Non metered)

 

Omkar Ghatpande
January 28, 2021

@Nirbhay Singh @Aditya K please review this. BEL team needs this to complete W&S deployment

Aditya K
February 27, 2021

template file should be as per data table