Introduction
Sewerage 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 sewerage charges can vary widely and is dependent upon various parameters. For instance, they can be dependent either upon 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 a percentage of water charges.
Data Table
Sr. No. | *Property Usage Type | *Property size slab Calculation attribute | Slab value from (units) | *Property size slab Slab value to (units) | *Percentage of water charges (%) | *Flat fee (in Rs) | *Rate | Charges | |
|---|---|---|---|---|---|---|---|---|---|
1 | Residential | Property Size | 1 | 150 | 30 | 200 | 5Rs 5/ unit | ||
2 | Residential | 151 | 300 | 40 | 500 | 10Percentage of water charges (%) | NA | NA | 10 % |
3 | Commercial | Flat fee (in Rs) | NA | NA | Rs 300 |
Note: The above table contains sample data for sewerage rates.
Procedure
Data Definition
Sr. No. | Column Name | Data Type | Data Size | Mandatory | Description |
|---|---|---|---|---|---|
1 | Property usage type | Text | 64 | Yes | Refer to property usage type |
2 | Calculation Attribute | Text | 64 | Yes | Depending on the case, calculation attribute can be Property Size value, percentage of water charges or a flat amount. |
3 | Slab (Property size value) | Decimal | (10,2) | Yes | Conditional mandatory. From and to value for property size |
34 | Flat feeCharges | Decimal | (3,2) | Yes | Flat sewerage charges collected based on property usage type |
4 | Percentage of water charges | Decimal | (3,2) | Yes | Percent value |
5 | Rate | Decimal | (3,2) | Yes | Consumption Depending on the calculation attribute charges can be consumption charges per unit corresponding to the usage type or a percentage or a flat amount. |
Steps to
create Sewerage Rates masterfill data
tableDownload 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 relevant Property Usage Type from the available drop-down list.
Enter the From and To value for property size to specify the range applicable for the selected property.
Enter the Flat Fee applicable for the selected property and Slab.
Enter the applicable Percentage of Water Charges value applicable. The sewerage charges will be calculated as a percentage of the water charges.
Enter the corresponding consumption Rate per unit.
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.