Water Supply Information Support System (WSISS)
The WSISS is another value-added module within the IMIS, designed to enhance the management of water supply services and fee collection. The WSISS includes a data importing tool that allows municipalities to upload water supply customer data, including their last fee payment date, in CSV format. Based on this imported data, the WSISS module generates and maintains records of water supply customers along with their fee payment status. It also provides tools to export building data with their water supply service and fee payment statuses and highlights discrepancies by identifying records present in the municipality’s water supply customer database but missing in IMIS.
Using the imported data, the UMDSS in IMIS enables municipal authorities to visualize the water supply fee payment status of buildings in maps of the City within IMIS. This capability allows municipalities to monitor fee collection statuses and assess geographic trends in water supply fee payments. By integrating water supply customer data with building information in IMIS, the WSISS module equips municipal authorities with actionable insights to make informed decisions regarding water supply services.
The visualized data provided by WSISS supports the development of policies aimed at improving water supply fee collection processes, optimizing resource allocation, and enhancing overall service delivery. This integration helps municipalities target areas requiring attention, ensuring more effective and equitable water supply service management.
Currently, as with the PTCISS and SWISS modules, the integration of data into WSISS must be carried out manually on a periodic basis to maintain accuracy.
17.1 Water Supply ISS
The Water Supply Information Support System sub-module maintains information on Water Supply Bill Payment data.
· Open the sidebar and select the Water Supply ISS.
Overview:
· The user can view the lists of water supply payment data.
· User can import the data via CSV of water supply payment data by clicking on the ‘Import from CSV (refer to section 17.1.2 Import Water Supply ISS)
· The user can download the CSV Template to import the water supply payment data (refer to section 17.1.3 Download CSV Template).
· Export the data (refer to chapter 8 Tools) and filter data (refer to chapter 5 Filters).
Figure 17- 1 List of Water Supply ISS
17.1.2 Import Water Supply ISS
The Water Supply Information Support System List displays key attributes of the imported Water Supply Information Support System data. The Filter tools enable the user to filter out data as required. The Tools provide the user with the ability to import data from csv records and export them in CSV.
· Click on ‘Import from CSV’ at the Top Left of the Water Supply Information Support System page.
Overview:
· The user can upload the water supply payment data including the last payment date in csv format to this module.
Figure 17- 2 Import Water Supply ISS CSV File
· Once the user selects the CSV file to be imported, they must click the Upload button to import the data. The user will then be notified with a pop-up message indicating Successful import, refer to section 7.3 Successfully Imported for more details.
· The system currently does not allow user to import data from any other format than csv and must the system specified data structure. In case of attempt to import data from other format system will prompt red error message of mismatched format, refer to section 7.4 Import Format Error for more details.
Note:
- The format for the Last Payment Date must be of mm/dd/yyyy (eg: 8/21/2022 which implies August 21st 2022).
17.1.3 Download CSV Template
· Click on the ‘Download CSV Template’ button at the top left of the Water Supply Information Support System page.
Overview:
· A csv template file containing the sample data and required headers will be downloaded, which are essential for importing the csv file.
· Download CSV Template is available only in the Property Tax Collection ISS and Water Supply ISS Modules, and Solid Waste ISS module.
Figure 17- 3 Downloaded Water Supply ISS CSV Template
No Comments