The document of “User Manual for the Vietnam Urban Water Supply and Sewerage Sector Database Website – Version 2.0” has been prepared for training and guidance on the use of Database Website, including 54 pages in both Vietnamese and English. The PDF version of this document can be downloaded by all users when accessing to the Website’s homepage.
CHAPTER 9: DEVELOPMENT OF IBNet TOOLKIT FOR VIETNAM DATABASE
9.1. Development of IBNet Toolkit for Vietnam Database
9.1.1. IBNET Toolkit
In the website www.IBNET.ORG, there exist a toolkit that helped in filling and checking data (true/false) in easily and accurately manner.
The Toolkit has been applied in some countries with IBNET using file temples including code of questions, code of indicator and unit ….
9.1.2. Application of IBNet Toolkit for Vietnam
Vietnam sector database included the following characteristic:
The databases included both indicators that used for benchmarking and sector management;
In many countries. a utility provides both water supply and wastewater treatment services while in Vietnam these services can be provided by various utilities (may be 3. 2 or 1 utility)
Therefore. WB specialist in coordination with MABUTIP and Consultant developed IBnet Toolkit for Vietnam. The Toolkit is:
Developed based on Vietnam’s questionnaire and indicators set;
Separated into 02 eexcel files for water supply and wastewater services;
To facilitate in filling and comparison data between indicators calculation that developed by Mabutip (automatic calculation in Excel File) may insert questionnaire and indicators set into Toolkit without impact to the functions: checking and detection of data input errors of the Toolkit.
Adding Vietnamese language, users required to have skills in excel software and understand the nature of the data inputs as filling numbers or letters, data unit, conventional units ... so they can completely use this Toolkit.
9.2. Application of IBNet Toolkit for Vietnam Sector Database
9.2.1. Application of IBNet Toolkit for Sector Database
Mabutip, Consultant and WB specialist aapplied the Toolkit as testing for water service data in 2013, 2014 and wastewater 2014. The results calculation of the Toolkit have basically matched with the database. Some errors has been detected and to be finalized.
The IBnet Toolkit has been integrated with the sector database at the website: www.vnwd.vn and www.vnw.gov.vn.
Users (Utilities) may download:
Toolkit sample from the website at the icon ''Download Vietnamese Toolkit '' and select “Water Toolkit” or Wastewater Toolkit”.
All the data related to water services in 2013. 2014 provided by 88 utilities and wastewater treatment service in 2014 by 13 utilities have filled in each respective Toolkit. Users can download the data in the folder ''Data Toolkit'' in the field of water and wastewater treatment services in the Toolbar.
CHAPTER 10: CONCLUSIONS AND RECOMMENDATIONS
10.1.1. Completed Tasks
In the contract “ MoC-01-Consulting service for Development of Water and Sewerage Sector Performance Database”. Consultant completed their assignment compliance with the signed contract to maintain, update and improve the sector database as including:
Update the data for water utilities for years of 2013 and 2014;
Development of Sewerage Database
Prepare performance indicators and questionnaire for wastewater treatment services;
Develop sewerage database for year 2014;
Update and improve the developed website
Develop the IBNet Toolkit (World Bank) for Vietnam Water and Sewerage Sector Database and put into operation;
Update and develop a comprehensive website based on http://www.vnwd.vn for publication of water and sewerage sector database which provides an overview of sector performance and investment in water and drainage sector.
10.1.2. Overall assessment
The questionnaire and indicators set for water and wastewater treatment services focused on the data provided by the utilities. Therefore, the updating data for year 2013 and 2014 did not meet many difficulties of which the quality of data has been improved with higher accuracy and reliability.
With participation of 88 key utilities out of 104 water utilities and 13/15 wastewater treatment utilities, the water sector database for years of 2013 and 2014 and sewerage database for year 2014 seem to be considered as national sector database. It noted that this is first (benchmarking) database on wastewater treatment services.
10.2.1. Overall recommendations on sector database
Based on the analysis and evaluation of water and sewerage sector database, some recommendations were presented in the Chapter 4 (Water Utility’s Assessment and Recommendations) and Chapter 7 (Wastewater Utility’s Assessment and Recommendations). Additional recommendations are as shown in the below:
Recommendation A1: Measures taken to maintain the sector database in sustainable
The development and maintenance of sector database are essential to ensure the interests of the parties (the community. services providers and local authorities). However it is clear that the update and maintenance of database in regular basic will require a certain resources from the utilities as well as the management agency. On the other hand, the disclosure of transparent information can make anxious for some utilities.
To maintain sustainable of the sector database, it required to take the action plans as following:
For Utilities in charge of water and wastewater treatment services
The utilities should be:
Improve awareness of the necessity and benefits of maintaining their own database: indicators in the database will provide a good framework to evaluate the performance of utility (similar to the financial statements report) that used in daily execution and production and will help to create economic and technical benefits as well as investment promotion;
Develop a data management system for the assigned functions of the department/units in the utility in data collection, processing, consolidation and reporting;
Prepare and issue specific procedures for the data collection, processing, consolidation and reporting;
Provide training on these procedures and paid much attention to the new staffs to be in charge;
Implement and evaluate the result of performance in regular basis and improve the procedures as needed;
For state management agencies:
The local authorities should ensure the legal basis in data reporting as mandatory requirement for the service providers.
The water and drainage activities considered as essential and exclusive services for the whole of the local community. So acted as Client in the Agreement/Service Contracts. the local authorities should include the terms related to providing performance data in the signed contracts;
At central level, the Government should issue the provisions on reporting of database in the legal documents on water sector (Amendment Decree or Law);
Acting as sector management and oversight functions, MoC should issue guidance on providing and updating sector database including data standardization. Having good experiences in development of safety water supply plans under WHO program, after testing period, the MoC issued Decision No.16/2008/QĐ-BXD and then replaced with Circular No. 08/2012/TT-BXD and up to now almost (56) utilities (by end of year 2015) in the 45 provinces/cities have developed safety water supply plans;
Ensure the human resources to update annually database and maintain the developed website
Acting as management agency and oversight functions in the sector, the Ministry of Construction should arrange the assigned staff, equipment and budget to maintain the sector database and the developed website.
In addition to the improvements of collecting and processing procedures, the combination and reporting data should also be required to pay much attention.
Recommendation A2: Improve reliability of sector database
In the report of water sector database (2011 and 2012), it indicated that the reliability of the data was not high. It is common not only in our country but also happening in many other countries. The data cannot be accurate in the early years of database development and that will be improved over the years. The reliability of the data for years 2013 and 2014 has been improved significantly. During annual updated, it may correct prompt the unreasonable data provided in the last years. In fact, it found that Urban Water Supply Benchmarking Program carried out by VWSA with the support of WSP/WB conducted from 2002 to 2010, including four benchmarking courses and of which 4th course (2010) for 2009 benchmarking but also included the review and data correction for year 2007 that carried out in 2008 (3th course).
Therefore, the comparison of indicator values in years seems to be relative meanings as they replied on reliable data. Along with improvement of the input data, the reliability of indicators will be improved gradually during years. The input data after the correction will be higher reliability (less deviation or less ridiculous) but did not sure to be corrected. In some cases, there is inconsistency between values of an indicator for same year in various reports (Report of Department of Construction and report of VWSA) although they are based on data provided by the utility, even occurred in the reports of that utility. Therefore, it recommended as following:
Utilities should paid much attention to improve the filling, verification and data provision;
MoC should pay much attention to review, correction of data inputs provided by the utilities.
In the national statistical index system (issued at Decision No. 43/2010/QD-TTg dated 2/6/2010 by the Prime Minister): collect and publish socio-economic indicators of the city/province and nationwide that served for developing and monitoring of socio-economic programs. These data submitted to the DoCs for consolidation and reporting to the relevant ministries and the General Statistics Office.
In sector database: collected and published performance indicators of the utilities that served for Benchmarking aimed at improving the utility’s performance in term of technical and economic. The data provided by the utilities directly to the MoC and used to calculate the (automatic) indicators including indicators of each utility and the composite indicators of the database in that year.
10.2.1. Recommendations for Water Service
The recommendations for water service are presented in the Chapter 4.
10.2.1. Recommendations for Wastewater Treatment Services
The recommendations for wastewater treatment services are shown in the Chapter 7.
PART II: ANNEXES
Annexes of Chapter 2 – Indicators Set and Questionnaires for Water Services (2015)
Questionnaires/Data Sheets for Water Services (version 2015)
Performance Indicators Set for Water Services (version 2015)
Annexes of Chapter 3 – Water Sector Performance Database for Years 2013, 2014