ERP W & S Configuration Document
- Habil Mohammed (Unlicensed)
- Elzan Mathew
- Sathish P
The purpose of this document is to list the set of configurations which are available for Water and Sewerage Module. Configuration values are set according to the client requirements. There is no UI screen available in the application to change these values. It can be changed by updating the values in the database.
Water Charge Management
Feature | Config Key Name | Description | Datatype | Default Value | Allowed Values |
|---|---|---|---|---|---|
New water application | DESG_APP_INITIATOR | Designation for water application initiator. Only employee belonging to this designation will be able to initiate applications such as apply for new connection. If CSC/ Citizen applies for a connection, application will be forwarded to employee of this designation. | String | Clerk | Clerk |
New water application | DEPT_CODE_APP_INITIATOR | Department for water application initiator. Only employee belonging to this department will be able to initiate applications such as apply for new connection. If CSC/ Citizen applies for a connection, application will be forwarded to employee of this department. | String | DEPT_7 | DEPT_7, DEPT_15 |
New water application | WATER_APPROVE_DESIGNATION | Approver Designation for auto escalation from JE. If JE doesnt act upon till sla completes, it is deemed approved and forwarded to employee of this Designation. | String | Executive Engineer/Municipal Engineer/Corporation Engineer | Sub-Divisional Engineer/Sub-Divisional Officer/Executive Officer, Executive Engineer/Municipal Engineer/Corporation Engineer |
New water application | WATER_APPROVE_DEPARTMENT | Approver Department for auto escalation from JE. If JE doesnt act upon till sla completes, it is deemed approved and forwarded to employee of this Department. | String | Engineering Branch(O&M) -for Water and Sewerage | PWSSB/DWSSB/Engineering Branch(O&M) -for Water and Sewerage |
New water application | SLADAYS_TO_UPDATE_EXECUTIONDATE | Sla Days for deemed execution date update. If citizen does not acknowledge within the given SLA, it will be deemed executed. | Number | 10 | Any integer |
New water application | APPLICATIONSSLADAYS | Sla Days for deemed approval by JE. If JE does not act upon the application within the given SLA, it will be deemed approved and sent to next level. | Number | 5 | Any integer |
Bill Generation | BREAKDOWN_PENALTY_MULTIPLIER | Breakdown Penalty multiplier to impose breakdown penalty. While calculating breakdown penalty in case of metered connections, this value is used to derive the breakdown penalty. | Number | 2 | Any integer |
Bill Generation | FUNDSOURCECODEFORGENERATEBILL | Department code for Generate Bill. This is used to send the fund code to finance system for finance integration. | String | 01 | 01 |
Bill Generation | FUNCTIONARYCODEFORGENERATEBILL | Department code for Generate Bill. This is used to send the fund code to finance system for finance integration. | String | 01 | 01 |
Bill Generation | SERVICECODEFORGENERATEBILL | Department code for Generate Bill. This is used to send the service code to finance system for finance integration. | String | WT | WT |
Bill Generation | DEPTCODEFORGENERATEBILL | Department code for Generate Bill. This is used to send the dept code to finance system for finance integration. | String | DEPT_13 | DEPT_13/DEPT_15/DEPT_16 |
Bill Generation | INTEREST_PERCENTAGE | Interest percentage per month. Value of this field will be used while calculating the interest amount. | Number | Defined by ULB (10) | Any integer |
Bill Generation | PANALTY_PERCENTAGE | Penalty percentage. After the bill due date has crossed and consumer has not paid, penalty will be applied based on this value. | Number | Defined by ULB (15) | Any integer |
Bill Generation | INTEREST_PERIOD | Interest period in days. Number of days after which interest will start to apply. | Number | Defined by ULB (365) | Any integer |
Bill Generation | PANALTY_PERIOD | Penalty period in days. Number of days after which penalty will get applied. | Number | Defined by ULB (15) | Any integer |
Bill Generation | TAX_RATETYPE | Ratetype which is configured for the ulb. Ratetype is used to define the logic for rate calculation, e.g, based on number of taps, plotsize etc. | String | Defined by ULB | PLOT_BASED/TAP_BASED/FIXED |
New Connection/Bill Generation/Collection | SENDEMAILFORWATERTAX | Enable or disable Email Notification for Water Tax module. If YES, email notification to citizen will be enabled for different transactions of water module. If NO, email notifications wont be sent to the citizen. | String | YES | YES/NO |
New Connection/Bill Generation/Collection | SENDSMSFORWATERTAX | Enable or disable SMS Notification for Water Tax module. If YES, SMS notification to citizen will be enabled for different transactions of water module. If NO, SMS notifications wont be sent to the citizen. | String | YES | YES/NO |
Sewerage Charge Management
Feature | Config Key Name | Description | Datatype | Default Value | Allowed Values |
|---|---|---|---|---|---|
New Sewerage Application | DESG_APP_INITIATOR | Designation for sewerage application initiator. Only employee belonging to this designation will be able to initiate applications such as apply for new connection.If CSC/ Citizen applies for a connection, application will be forwarded to employee of this designation. | String | Clerk | Clerk |
New Sewerage Application | DEPT_CODE_APP_INITIATOR | Department for sewerage application initiator. Only employee belonging to this department will be able to initiate applications such as apply for new connection. If CSC/ Citizen applies for a connection, application will be forwarded to employee of this department. | String | DEPT_7 | DEPT_7, DEPT_15 |
New Sewerage Application | SEWERAGE_APPROVE_DESIGNATION | Approver Designation for auto escalation from JE. If JE doesnt act upon till sla completes, it is deemed approved and forwarded to employee of this Designation. | String | Sub-Divisional Engineer/Sub-Divisional Officer | Sub-Divisional Engineer/Sub-Divisional Officer/Executive Officer |
New Sewerage Application | SEWERAGE_APPROVE_DEPARTMENT | Approver Department for auto escalation from JE. If JE doesnt act upon till sla completes, it is deemed approved and forwarded to employee of this Department. | String | Engineering Branch(O&M) -for Water and Sewerage | PWSSB/DWSSB/Engineering Branch(O&M) -for Water and Sewerage |
New Sewerage Application | SLADAYS_TO_UPDATE_EXECUTIONDATE | Sla Days for deemed execution date update. If citizen does not acknowledge within the given SLA, it will be deemed as executed. | Number | 10 | Any integer |
New Sewerage Application | APPLICATIONSSLADAYS | Sla Days for deemed approval by JE. If JE does not act upon the application within the given SLA, it will be deemed approved and sent to next level. | Number | 5 | Any integer |
Bill Generation | FUND_CODE_FOR_GENERATE_BILL | Department code for Generate Bill. This is used to send the fund code to finance system for finance integration. | String | 01 | 01 |
Bill Generation | FUNDSOURCE_CODE_FOR_GENERATE_BILL | Department code for Generate Bill. This is used to send the fund source code to finance system for finance integration. | String | 01 | 01 |
Bill Generation | FUNCTIONARY_CODE_FOR_GENERATE_BILL | Department code for Generate Bill. This is used to send the fund code to finance system for finance integration. | String | 01 | 01 |
Bill Generation | DEPT_CODE_FOR_GENERATE_BILL | Department code for Generate Bill. This is used to send the dept code to finance system for finance integration. | String | DEPT_13 | DEPT_13/DEPT_15/DEPT_16 |
Bill Generation | INTEREST_PERCENTAGE | Interest percentage per month. Value of this field will be used while calculating the interest amount. | Number | Defined by ULB (10) | Any integer |
Bill Generation | PANALTY_PERCENTAGE | Penalty percentage. After the bill due date has crossed and consumer has not paid, penalty will be applied based on this value. | Number | Defined by ULB (15) | Any integer |
Bill Generation | INTEREST_PERIOD | Interest period in days. Number of days after which interest will start to apply. | Number | Defined by ULB (365) | Any integer |
Bill Generation | PANALTY_PERIOD | Penalty period in days. Number of days after which penalty will get applied. | Number | Defined by ULB (15) | Any integer |
Bill Generation | TAX_RATETYPE | Ratetype which is configured for the ulb. Ratetype is used to define the logic for rate calculation, e.g, based on number of seats, plotsize etc. | String | Defined by ULB | SEAT_BASED, PLOT_BASED, WATER_EQUALS_SEWERAGE,FIXED |
Commons
Feature | Config Key Name | Description | Datatype | Default Value | Allowed Values |
|---|---|---|---|---|---|
Infra | IS_DWSSB_ULB | Configuration For ULB to know DWSSB or not. Bill and receipt formats depend on this value. If YES, all the DWSS related information will be shown in the bills and receipt. If NO, default template for bills and receipts will be used. | String | NO | YES/NO |
Infra | PWSSB_CONFIGURATION | General Info for PWSSB Cities. These values are used in the bills and receipts while generating pdf | String | cityName=Punjab Water Supply and Sewerage Board,contactNo=01672-234337,emailId=ees.pwssb@punjab.gov.in,designation=PWSSB Authority | cityName=Punjab Water Supply and Sewerage Board,contactNo=01672-234337,emailId=ees.pwssb@punjab.gov.in,designation=PWSSB Authority |
Infra | IS_PWSSB_ULB | Configuration For ULB to know PWSSB or not. Bill and receipt formats depend on this value. If YES, all the PWSSB related information will be shown in the bills and receipt. If NO, default template for bills and receipts will be used. | String | NO | YES/NO |
Infra | DWSSB_CONFIGURATION | General Info for DWSS Cities. These values are used in the bills and receipts while generating pdf | String | cityName=Department of Water Supply and Sanitation,contactNo=0172-4330317,emailId=hoddwss@gmail.com,designation=DWSS Authority | cityName=Department of Water Supply and Sanitation,contactNo=0172-4330317,emailId=hoddwss@gmail.com,designation=DWSS Authority |
Collection | COLLECTIONDEPARTMENTCOLLMODES | Department Code for Collection Modes. Employee can collect charges only if he is falling in the dept specified here. | String | DEPT_15 | DEPT_15 |
Collection | THIRDPARTY_RECEIPTVOUCHER_DEPT_MAPPING | Collection Receipt voucher creation Department Code mapping for Financials integration. It is a mapping between the department codes present in W&S and Finance system used for finance integration to create voucher against a receipt in WS. | String | DEPT_13,DEPT_13 | DEPT_13,DEPT_13 |
Collection | THIRDPARTY_REMITTANCEVOUCHER_DEPT_MAPPING | Collection Remittance voucher creation Department Code mapping for Financials integration. It is a mapping between the department codes present in W&S and Finance system used for finance integration to create voucher against remittance. | String | DEPT_01,DEPT_25 | DEPT_01,DEPT_25 |
Collection | COLLECTION_BANKREMITTANCE_DEPARTMENTCODE | Collection Bank Remittance Department Code. Remittance can be done only if the employee is belonging to this department. | String | DEPT_01 | DEPT_01 |
When receipts are created from Water and Sewerage, there will be vouchers created in Finance application based on the configuration.
In egcl_servicedetails table for every business service, there is an entry, here “vouchercreation” that needs to be marked as True if one needs the integration on. In other case, it can be left False. Once all the other required parameters are set for the voucher creation, one can see the vouchers getting created instantaneously.
Application Properties
Key | Description | DataType | Default Value | Expected Values |
|---|---|---|---|---|
mail.enabled | Enable the email notification. If TRUE, email notification will be enabled across the application. If FALSE, email notification will be disabled across the application. | Boolean | FALSE | TRUE/FALSE |
sms.enabled | Enable the SMS notification. If TRUE, SMS notification will be enabled across the application. If FALSE, SMS notification will be disabled across the application. | Boolean | FALSE | TRUE/FALSE |
water.bill.oneday.due.sms.enabled | Sms on 1 day before the last date of bill for water. If TRUE, sms will be sent to citizen 1 day before the last date of his bill. If FALSE, sms will not be sent. | Boolean | TRUE | TRUE/FALSE |
water.bill.fivedays.due.sms.enabled | Sms on 5 days before the last date of bill for water. If TRUE, sms will be sent to citizen 5 days before the last date of his bill. If FALSE, sms will not be sent. | Boolean | FALSE | TRUE/FALSE |
water.bill.generation.sms.enabled | SMS on successful water bill generation. If TRUE, SMS will be sent to the consumer when the bill is generated for his connection. If FALSE, SMS will not be sent. | Boolean | TRUE | TRUE/FALSE |
sewerage.bill.oneday.due.sms.enabled | Sms on 1 day before the last date of bill for weweragesater. If TRUE, sms will be sent to citizen 1 day before the last date of his bill. If FALSE, sms will not be sent. | Boolean | TRUE | TRUE/FALSE |
sewerage.bill.fivedays.due.sms.enabled | Sms on 5 days before the last date of bill for sewerage. If TRUE, sms will be sent to citizen 5 days before the last date of his bill. If FALSE, sms will not be sent. | Boolean | FALSE | TRUE/FALSE |
sewerage.bill.generation.sms.enabled | SMS on successful sewerage bill generation. If TRUE, SMS will be sent to the consumer when the bill is generated for his connection. If FALSE, SMS will not be sent. | Boolean | TRUE | TRUE/FALSE |
location.user.role | List of comma separated roles which are permissible to do collection. | String | Collection Operator,Collection Agency | Collection Operator,Collection Agency |