Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Introduction

Sewerage Charges are recurring charges which are levied on a pre-defined billing period. Billing period can be configurable as per the requirement. The rate for calculation of sewerage charges can vary widely and can be dependent upon various parameters. For eg. they can be dependent upon either plot size slab combined with property usage type or solely dependent upon property usage type. In some cases sewerage charges can also be levied as some percentage of water charges.

Data Table

Sr. No.

*Property Usage Type

...

*Flat fee (in Rs)

...

1

...

Residential

...

200

...

...

Commercial

...

500

...

Sr. No.

...

*Property Usage Type

Property size slab from (units)

...

Property size slab to (units)

Percentage of water charges (%)

...

Flat fee (in Rs

...

)

*Rate

1

Residential

0

150

...

2

...

 

...

Residential

...

150

...

300

...

2.5

...

30

200

5

Commercial

...

150

...

300

...

40

...

500

...

Commercial

...

150

...

300

...

10

Note: Data given in the above table is a sample data.

Procedure

Data Definition

Sr. No.

...

*Percentage of water charges (%)

...

 1

...

 30

...

 

...

 

Procedure

Data Definition

...

Sr. No. : Defines the serial no of the line item.

...

Column Name

Data Type

Data Size

Mandatory

Description

1

Property usage type

Reference

 

Yes

Specifies the property usage type

2

Slab

...

(Property size value)

Decimal

 

Conditional Mandatory

From and to value for

...

property size

3

Flat fee

...

Decimal

Conditional Mandatory

Flat sewerage charges collected based on property usage type

...

4

Percentage of water charges

Decimal

Conditional Mandatory

Percent value

5

Rate

Decimal

 

Yes

Consumption charges per unit corresponding to the usage type

...

Percentage of water charges : Percent value

Steps to fill this data

  1. Download the data template attached to this page.

  2. Get a good understanding of all the headers in the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.

  3. In case of any doubt, please reach out to the person who has shared this template with you to discuss and clear your doubts.

  4. Get information about charges levied for sewerage connection as a part of bill

  5. Get slab range and rate information for corresponding property usage type if applicable

  6. Get percentage value for calculating sewerage charges based on water charges

  7. Property usage type collected from State/ULB should be mapped with DIGIT property module

...

Validation

  • Data should be collected at ULB level

...

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

Checklist

Entity Specific Checklist

This checklist covers the activities which are specific to the entity.

Sr. No.

Checklist Parameter

Example

1

Property usage type should be mapped to ontology present in property module

‘Domestic’ in W&S = ‘Residential’ in PT

2

Slab (Property size value) should be a decimal value

120 : [Allowed]

120 sq. mt. : [Not allowed]

Attachments

  1. Configuration data template - Sewerage rates

View file
name

...

Configuration data template - Sewerage rates.xlsx

2. Sample configuration data - Sewerage rates

View file
nameSample configuration data - Sewerage rates.xlsx