Table of contents

TABLE OF CONTENTS.....................................................................................1
BAB I INTRODUCTION.....................................................................................5
1.1. BACKGROUND................................................................................................................................................5
1.2. OBJECTIVE.....................................................................................................................................................5
1.2.1. Evaluating Existing Conditions............................................................................................................5
1.2.2. Determining Information System Needs.............................................................................................5
1.2.3. Develop an Implementation Plan........................................................................................................5
1.3. SCOPE.......................................................................................................................................................... 6
1.3.1. Analysis of Existing Conditions............................................................................................................6
1.3.2. Needs Analysis....................................................................................................................................6
1.3.3. Implementation Plan..........................................................................................................................6
1.3.4. Documentation and Reporting...........................................................................................................6
BAB II EXISTING CONDITIONS.........................................................................7
2.1. EXISTING BUMD-AM PERFORMANCE ASSESSMENT SYSTEM..................................................................................7
2.2. EXISTING INFORMATION SYSTEM RELATED TO PERFORMANCE INDICATORS OR SPAM..................................................7
2.2.1. EVKIN (Performance Evaluation)........................................................................................................7
2.2.2. SIPD (Regional Government Information System) by the Ministry of Home Affairs............................9
2.2.3. e-BUMD (Electronic Regional Owned Enterprise) by the Ministry of Home Affairs...........................11
2.2.4. SIMSPAM (Drinking Water Supply System Management Information System) by the PUPR Ministry.
................................................................................................................................................................... 13
2.2.5. SIPEKAM (Drinking Water Performance Assessment Information System) by the Ministry of Health
................................................................................................................................................................... 15
2.2.6. SIMAMAD (Village Safe Drinking Water Management Information System)....................................17
2.2.7. PUPR Open Data...............................................................................................................................18
2.2.8. One Indonesian Data (SDI)................................................................................................................20
2.3. WEAKNESSES AND LIMITATIONS.......................................................................................................................25
2.4. INFORMATION TECHNOLOGY INFRASTRUCTURE...................................................................................................25
BAB III NEEDS ANALYSIS..............................................................................27
3.1. FUNCTIONAL REQUIREMENTS..........................................................................................................................27
3.1.1. Utilization of BUMD AM Performance Assessment Results data......................................................27
3.1.2. BUMD AM Performance Assessment Indicators...............................................................................27
3.1.3. Data Validation and Verification......................................................................................................29
3.1.4. Reporting and Analytics....................................................................................................................30
3.1.5. Security and Access...........................................................................................................................30
3.1.6. Integrated Data................................................................................................................................30
3.2. NON-FUNCTIONAL REQUIREMENTS..................................................................................................................31
3.2.1. Requirement: System Responsiveness and Response Time...............................................................31
3.2.2. Scalability.........................................................................................................................................32
3.2.3. Reliability..........................................................................................................................................32
3.2.4. Ease of Use.......................................................................................................................................32
3.3. NEEDS FOR INTEGRATED BUMD-AM PERFORMANCE BENCHMARKING SYSTEM MANAGERS.......................................32
BAB IV FINDINGS AND RECOMMENDATIONS..................................................39
4.1. KEY FINDINGS..............................................................................................................................................39

1
 4.2. RECOMMENDATION.......................................................................................................................................39
BAB V IMPLEMENTATION PLAN.....................................................................44
5.1. PROJECT PREPARATION..................................................................................................................................44
5.1.1. Identify Stakeholders........................................................................................................................44
5.1.2. Formation of the Project Team ........................................................................................................44
5.1.3. Determining the Scope and Specific Objectives of System Development .........................................44
5.2. SYSTEM DEVELOPMENT..................................................................................................................................45
5.2.1. System Architecture Design Based on Functional and Non-Functional Requirements......................45
5.2.2. Development or Adaptation of Information System Modules...........................................................45
5.2.3. System Testing..................................................................................................................................46
5.3. DATA MIGRATION.........................................................................................................................................46
5.3.1. Collection and Verification of Existing Data......................................................................................46
5.3.2. Data Migration From Old System to New System.............................................................................46
5.3.3. Post-Migration Data Validity Testing................................................................................................47
5.4. TRAINING AND SOCIALIZATION.........................................................................................................................47
5.4.1. Training For End Users Regarding The Use Of The New System.......................................................47
5.4.2. Socialization to all stakeholders regarding the benefits and changes expected from system
implementation..........................................................................................................................................47
5.5. SYSTEM IMPLEMENTATION..............................................................................................................................47
5.5.1. Implementation in stages or in full (big bang or phased rollout)......................................................47
5.5.2. Initial Monitoring to Identify and Correct Problems that Arise.........................................................47
5.6. EVALUATION AND ADJUSTMENT.......................................................................................................................47
5.6.1. System Performance Evaluation after Implementation....................................................................47
5.6.2. System adjustments and improvements based on user feedback.....................................................48
5.7. SCHEDULE AND TIME.....................................................................................................................................48
5.8. REQUIRED RESOURCES...................................................................................................................................49
5.8.1. Human Resources:............................................................................................................................49
5.8.2. Technology Infrastructure:...............................................................................................................49
5.8.3. Budget:.............................................................................................................................................49
BAB VI CONCLUSIONS AND RECOMMENDATIONS...........................................50
6.1. CONCLUSION................................................................................................................................................50
6.2. RECOMMENDATION.......................................................................................................................................50
ATTACHMENT TO PROPOSED BPPSPAM PERFORMANCE INDICATORS AND
CONTEXTUAL INFORMATION.........................................................................53
ATTACHMENT TO PROPOSED PERFORMANCE INDICATORS FOR MINISTER OF
HOME AFFAIRS DECREE 47/1999 AND CONTEXTUAL INFORMATION.................64
APPENDIX PROPOSED IUWASH PERFORMANCE INDICATORS........................78
ATTACHMENT PROPOSED DATA INPUT SCHEME BY BUMD-AM........................82
Performance Assessment Results data
3.1.2. BUMD AM Performance Assessment Indicators
3.1.3. Data Validation and Verification
3.1.4. Reporting and Analytics
3.1.5. Security and Access
3.1.6. Integrated Data
3.2. NON-FUNCTIONAL REQUIREMENTS
3.2.1. Requirement: System Responsiveness and Response Time

2
 3.2.2. Scalability
3.2.3. Reliability
3.2.4. Ease of Use
3.3. NEEDS FOR INTEGRATED BUMD-AM PERFORMANCE BENCHMARKING SYSTEM MANAGERS
CHAPTER IV FINDINGS AND RECOMMENDATIONS
4.1. KEY FINDINGS
4.2. RECOMMENDATION
CHAPTER V IMPLEMENTATION PLAN
5.1. PROJECT PREPARATION
5.1.1. Identify Stakeholders.
5.1.2. Project Team Formation.
5.1.3. Determining the Scope and Specific Objectives of System Development.
5.2. SYSTEM DEVELOPMENT
5.2.1. System Architecture Design Based on Functional and Non-Functional Requirements.
5.2.2. Development or Adaptation of Information System Modules.
5.2.3. System Testing
5.3. DATA MIGRATION
5.3.1. Collection and Verification of Existing Data.
5.3.2. Data Migration From Old System to New System.
5.3.3. Post-Migration Data Validity Testing.
5.4. TRAINING AND SOCIALIZATION
5.4.1. Training For End Users Regarding The Use Of The New System.
5.4.2. Socialization to all stakeholders regarding the benefits and changes expected from system
implementation.
5.5. SYSTEM IMPLEMENTATION
5.5.1. Implementation in stages or in full (big bang or phased rollout).
5.5.2. Initial Monitoring to Identify and Correct Problems that Arise.
5.6. EVALUATION AND ADJUSTMENT
5.6.1. System Performance Evaluation after Implementation.
5.6.2. System adjustments and improvements based on user feedback.
5.7. SCHEDULE AND TIME
5.8. REQUIRED RESOURCES
5.8.1. Human Resources:
5.8.2. Technology Infrastructure:
5.8.3. Budget:
CHAPTER VI CONCLUSIONS AND RECOMMENDATIONS
6.1. CONCLUSION
6.2. RECOMMENDATION
ATTACHMENT TO PROPOSED BPPSPAM PERFORMANCE INDICATORS AND
CONTEXTUAL INFORMATION
ATTACHMENT TO PROPOSED PERFORMANCE INDICATORS FOR MINISTER OF
HOME AFFAIRS DECREE 47/1999 AND CONTEXTUAL INFORMATION
ATTACHMENT TO PROPOSED IUWASH PERFORMANCE INDICATORS
ATTACHMENT TO PROPOSED DATA INPUT SCHEME BY BUMD-AM

25

3
 BAB I
Introduction
I.1. Background
BUMD-AM Performance Benchmarking is an important instrument for measuring
the performance of Regional Drinking Water Companies (BUMD-AM) in Indonesia.
This assessment is based on performance indicators from Kepmendagri 47 of
1999 and BPPSPAM, with the aim of ensuring BUMD-AM can provide quality
drinking water services to the community. However, with the times and
increasingly complex needs, it is necessary to review the relevance of these
indicators and add elements such as GEDSI (Gender Equality, Disability and
Social Inclusion), climate change and credit worthiness.

The main task in this study is to examine the information system related to
performance indicators, ensuring that the system can be accessed by various
stakeholders such as BUMD-AM, regional government, central government, and
financial institutions in real-time and safely.

I.2. Objective
I.2.1. Evaluating Existing Conditions
Identify the weaknesses and limitations of the BUMD-AM performance
assessment system currently used and evaluate the condition of the
information technology infrastructure that supports the current
performance assessment system.

I.2.2. Determining Information System Needs

Identify the functional requirements that must be met by the new
information system, such as data collection, validation, reporting, and
security , as well as identify non-functional requirements such as
performance, scalability, reliability, and ease of use. Because this system
will involve many stakeholders in the future, it is necessary to formulate the
needs of various stakeholders, including the central government, regional
government, BUMD-AM and financial /investment institutions and
associations such as Perpamsi.

I.2.3. Develop an Implementation Plan

Develop a plan of steps for the development and implementation of an
integrated information system and prepare a schedule and resources for
each implementation stage as well as identify the resources needed and
select the methodology used to collect data and analyze needs (for
example, interviews, surveys , literature study).

4
 I.3. Scope
I.3.1. Analysis of Existing Conditions
Analysis of the performance assessment system currently used by BUMD-
AM, including software, hardware, and procedures , identifying weaknesses
and limitations in the existing system, such as problems with data validity,
form fillability, and system integration , evaluating the condition of the
technological infrastructure which supports the performance assessment
system, including servers, networks, and data storage as well as collecting
data about the frequency of system use and user satisfaction with the
existing system.

I.3.2. Needs Analysis

Determining functional requirements for information systems, including
data collection, validation, reporting and security . Non-functional
requirements such as performance, scalability, reliability and ease of use ,
identifying the needs of key stakeholders, including central government,
regional government, BUMD-AM, financial and investment associations and
institutions , identifying the need for Integrated Information Systems
Determining the need for system integration, data management, and
technology infrastructure .

In this needs analysis, qualified institutions/institutions/bodies are identified

that can manage the BUMD-AM Performance Indicators from various
aspects, such as legal or regulatory aspects, authority aspects and other
aspects.

I.3.3. Implementation Plan

For the implementation plan, it is necessary to arrange the steps needed to
develop and implement a new information system, prepare a time schedule
for each implementation stage, including development, testing, training and
launch and plan the necessary resources, such as budget, technology, and
workforce.

I.3.4. Documentation and Reporting

Collecting and compiling supporting documentation such as additional data,
interview results, surveys and other relevant documents as well as
preparing a final report which includes needs analysis, existing conditions,
recommendations and implementation plans.

BAB II
Existing Conditions
II.1. Existing BUMD-AM Performance Assessment System
Currently, the BUMD-AM performance assessment system in Indonesia uses a
variety of separate tools and applications to collect and manage performance
data. This system aims to measure and evaluate the performance of BUMD-AM in

5
 managing drinking water supplies where the data collected is used to see the
extent to which the condition of BUMD-AM is seen from various aspects, both
based on Kepmendagri 47 of 1999 and based on BPPSPAM.

In the BUMD-AM performance assessment system currently using an application

called EVKIN developed by BPKP. BUMD-AM accompanied by BPKP fills out the
performance assessment form online once a year , which includes various
performance indicators based on Kepmendagri 47 of 1999 and BPPSPAM. This
form collects performance indicator data for financial aspects, operational
aspects and administrative aspects based on Decree of the Minister of Home
Affairs 47 of 1999, while based on BPPSPAM the data collected is performance
data which includes financial, service, operational and HR aspects .

The data collected through EVKIN is evaluated by BPKP and the results based on
BPPSPAM are submitted to the PUPR Ministry based on the MOU between BPKP
and the PUPR Ministry. Apart from being reported to the PUPR Ministry,
performance reports based on Kepemendagri 47/1999 are also submitted to the
Ministry of Home Affairs, especially the Directorate General of Regional Finance.

II.2. Existing Information System related to Performance

Indicators or SPAM
II.2.1. EVKIN (Performance Evaluation)
As previously stated, the application currently used to accommodate BUMD-AM
performance data is EVKIN . The EVKIN (Performance Evaluation) application
from the Financial and Development Supervisory Agency (BPKP) is a system
designed to facilitate the process of evaluating the performance of government
agencies in Indonesia. This application aims to increase transparency,
accountability and efficiency in managing government performance.

Some of the main functions of the EVKIN application related to BUMD-AM include:

 Performance Data Collection: Collect data related to BUMD-AM

performance in a systematic and structured manner.
 Performance Analysis: Enables performance analysis based on predefined
indicators, making it easier to identify areas that need improvement.
 Reporting: Provides comprehensive performance reports for various levels
of management, assisting in decision making and performance
improvement.
 Monitoring and Evaluation: Enables regular monitoring of the performance
of government agencies and evaluation of work results on an ongoing
basis.

With the EVKIN application, BPKP seeks to ensure that BUMD-AM can manage
their performance more effectively, as well as increase accountability and
transparency in the management of public resources.

6
 Figure 1. EVKIN screenshot

Table 1. EVKIN Overview

General description
Application name BUMD-AM Performance Evaluation (EVKIN)

Objective Facilitate the process of implementing national

performance evaluations
Main features  Performance evaluation data by BUMD-AM
 Review and evaluation
 Validate Reports and Attachments
 Report to the Directorate of Drinking Water.

Development Year 2019, August by the BPKP Developer Internship

Team, Deputy State Accountant
Primary Data Source BUMD-AM
Currently Used for Benchmarking BUMD-AM
Performance Indicators

Data integration -
it is managed by Pusinfo (IT Division of BPKP)

Technical specifications Desktop based application, with SQL SERVER 2000

database, using BPKP WAN VPN connection, for
BUMD-AM users

7
 Challenges and yet be integrated with applications in other
opportunities ministries , it will be developed on a web- based
platform
User Regional Government, BUMD-AM, BPKP, Ministry of
PUPR
Data/Information Flow Data input from: BUMD-AM
Data: BUMD-AM Performance Indicator base for
Kepmendagri 47 and BPPSPAM
Output: BUMD-AM Performance Report
Resources Interview with Mr. Agung BPKP
Access Address Client Server

II.2.2. SIPD (Regional Government Information System) by the Ministry of

Home Affairs.
The Regional Government Information System (SIPD) is a system developed by
the Indonesian government, in this case the Ministry of Home Affairs, to increase
transparency, accountability and efficiency in regional government management.
SIPD is used to integrate various data and information needed in the planning,
budgeting, implementation and reporting processes of government activities at
the regional level.

The main functions of SIPD include:

 Planning: Assist local governments in preparing short, medium and long

term development plans.
 Budgeting: Supports the process of preparing and managing regional
budgets, ensuring more efficient and transparent allocation of funds.
 Implementation: Monitor the implementation of programs and activities
that have been planned and budgeted.
 Reporting: Provide performance and financial reports that can be accessed
by various stakeholders for evaluation and monitoring.
 With SIPD, it is hoped that there will be an increase in the quality of public
services and regional government performance through better use of
information technology.

The screenshot and general overview are presented in the figure and table
below:

8
 Figure 2. SIPD screenshot

Table 2. SIPD Overview

General description
Application name Regional Government Information System (SIPD)

Objective Support for the Duties and Functions of the

Ministry of Home Affairs to supervise regional
development
Main features  Regional Development Information
 Regional Financial Information
 Other Regional Government Information

Development Year 2018 by the Directorate General of Regional

Development (Bangda)
Primary Data Source  Regional Government, not directly related to
BUMD-AM
 Not Yet Accommodating Performance
Indicators based on Ministerial Decree 47/99
 Performance Indicators based on Ministerial
Decree 47/99 are reported to the Directorate
General of Regional Financial Development
by BPKP
Data integration SIMSPAM and EVKIN are not realtime
it is managed by Directorate General of Regional Development in
Collaboration with Pusdatin and National Data
Center (PDN)
Technical specifications Web Base developed using PHP, PostgreSql,
PostGIS, Javascript

9
 Challenges and opportunities Compliance in data entry is very minimal,
generally not connected to local government
information systems. Supports integration with
BUMD-AM performance indicator data

User Regional Government, Ministry of Home Affairs

Data/Information Flow Input data from: Local Government
Data: Local Government Profile all sectors,
Regional Planning Proposals
Output: Monitoring and Evaluation of Regional
Development
Resources Interview with SIPD Manager (19 July 2024)
Access Address [Link]

II.2.3. e-BUMD (Electronic Regional Owned Enterprise) by the Ministry of

Home Affairs.
This e-BUMD application is part of the government's efforts to improve good
governance and support regional economic development through more
professional and accountable BUMD management .

The e-BUMD (Regional Owned Enterprises) application is a system developed by

the Ministry of Home Affairs (Kemendagri) of the Republic of Indonesia to
facilitate the management and supervision of Regional Owned Enterprises. The
following is some general information regarding the e-BUMD application:

Main Function:

 This application aims to facilitate the collection, management and

monitoring of BUMD data centrally.
 Increase transparency and accountability in the management of BUMD by
providing information that can be accessed by the central, regional and
community governments.
 Facilitate the process of monitoring and evaluating BUMD performance by
regional and central governments.

The screenshot and general overview are presented in the figure and table
below:

10
 Figure 3. Screenshot of e-BUMD

Table 3. Overview of e-BUMD

General description
Application name e-BUMD (Regional Owned Enterprise Information
System)
Objective Profile, Monitoring and Evaluation of BUMD in
Indonesia
Main features BUMD data

Development Year Directorate General of Regional Finance (Keuda)

Primary Data Source Accommodates Performance Indicator data
based on Ministerial Decree 47/99

Data integration -
Managed by Directorate of BUMD, BLUD & BMD –
Ministry of Home Affairs of the Republic of
Indonesia with Pusdatin and National Data
Center (PDN)
Technical Specifications Web Base developed using PHP, PostgreSql,
PostGIS, Javascript

Challenges and opportunities Not yet integrated with SIPD. Supports

integration with BUMD-AM performance
indicator data
User Regional Government, Ministry of Home Affairs,
especially the Directorate General of Regional
Development
Data/Information Flow Input From: BUMDs, BUMD-AM
Data: BUMDs Profile, Performance Audit Report
from BPKP Based on Ministry of Home Affairs

11
 47/99 (Hardcopy), need check about softcopy
Output: Monitoring and Evaluation of BUMDs
User: BUMDs, BUMD-AM, Ministry of Home
Affairs
Resources Interview with Mr Sujadmiko (24 July 2024)

Access Address [Link]

II.2.4. SIMSPAM (Drinking Water Supply System Management Information

System) by the PUPR Ministry.
The SIMSPAM application (Drinking Water Supply System Management
Information System) is a platform developed by the Ministry of Public Works and
Public Housing (PUPR) to monitor and manage drinking water supply systems in
Indonesia. Here is some important information regarding this application:

Main Function :

 The SIMSPAM application is designed to update profile data on drinking

water supply systems (SPAM) that have been built, both in urban and rural
areas. This includes technical and operational data from drinking water
supply installations ( [Link]) ( PDFCoffee) .
 Enables real-time monitoring of the condition and performance of drinking
water supply systems, making it easier to evaluate and plan repairs or
service improvements.

The screenshot and general overview are presented in the figure and table
below:

Figure 4. SIM SPAM screenshot.

12
 Table 4. SPAM SIM Overview

General description
Application name SPAM Management Information System (SPAM SIM)
Objective To meet the national need for information on
access to drinking water, both in terms of quantity
and quality, so that it can assist in formulating
strategies, planning and development of drinking
water supplies to achieve 100% access to drinking
water .
Main features  General data of SPAM managers
 SPAM Technical Data
 Beneficiary data
 SPAM planning and development

Development Year 2018

Primary Data Source BUMD-AM
BPS (Central Statistics Agency)
Performance Book of PDAM
Data integration BPS ( population , number of family heads )
it is managed by Ditam PUPR collaborates with PDN (National Data
Center)
Technical specifications Linux OS, PHP, Laravel, Lumen, Nginx, PostgreSql
Challenges and Fulfillment of data entry is still minimal , not yet
opportunities integrated with performance indicator data (EVKIN)
, SIPD and SIPEKAM directly , in the future it can be
integrated via API (Application Protocol Interface)
User Central/Provincial/Regency/City Level SPAM
Manager
Data/Information Flow  Data input from: BUMD-AM, SPAM Non BUMD-
AM (BPPW, SPAM JP, SPAM Non JP, Pamsimas)
 Data: SPAM Organizer Profile includes BUMD-
AM, SPAM Unit, SPAM Planning and
Development
 Output: Your monitoring Evaluation: Access to
water drinking
Resources SIMSPAM Handbook
Access Address [Link]

II.2.5. SIPEKAM (Drinking Water Performance Assessment Information

System) by the Ministry of Health
SIPEKAM (Drinking Water Quality Monitoring Information System) is a platform
managed by the Indonesian Ministry of Health to monitor and ensure the quality
of drinking water consumed by the public meets established health standards.

13
This application is designed to collect, store and analyze data related to drinking
water quality from various sources throughout Indonesia.

SIPEKAM facilitates monitoring of drinking water quality through various

mechanisms, including sanitation inspections, water sampling, and water quality
testing. The collected data is used to monitor and evaluate the quality of
drinking water, as well as to ensure that the water consumed by the public is
safe and healthy.

Main Function:

Monitoring and maintaining safe and healthy drinking water quality for the
community. The following is a screenshot of the SIPEKAM General Overview
display and table:

Figure 5. SIPEKAM screenshot

Table 5. SIPEKAM Overview

General description
Application name Drinking Water Quality Monitoring System
(SIPEKAM)
Objective To provide the latest solutions in monitoring and
maintenance efforts safe and healthy drinking
water quality for the community
Main features  Internal (BUMD-AM/BUMD-AM, PASIMAS and
NON-PAMSIMAS)
 External Module (DINKES)
 KAMRT (HOUSEHOLD) Module

Development Year 2018, Directorate of Environmental Health

Primary Data Source BUMD-AM
PUSKESMAS
Data integration -
Managed by Ministry of Health

14
 Technical specifications Web based application, PHP
Challenges and Not all users have entered the data entered , The
opportunities One Data feature already exists
User BUMD-AM, SPAM Management Group (KPSPAM),
Lab Managers, Health Offices at Various Levels
Data/Information Flow Data input from: BUMD-AM, SPAM Non BUMD-AM
Data: SPAM Organizer Profile, SPAM Unit, Water
Quality
Output: Monitoring Drinking Water Quality
Resources SIPEKAM Guidebook and Video Tutorial
Access Address [Link]

II.2.6. SIMAMAD (Village Safe Drinking Water Management Information

System)
To ensure that post-PAMSIMAS Rural SPAM data
can still be updated according to conditions in the
field, now The Drinking Water Directorate has
developed a sustainability application called the
SIMAMAD Application, which has a function to
record community-based SPAM sustainability
village data (SPAM-BM). This application will be
used by officers at the level Village/Kelurahan or
Village SPAM. This application was developed
based on a smartphone with the Android platform,
making it easier updating data in the field by
Village level officers/village officials/KPSPAM. With
the development of smartphone-based
applications It is hoped that the data will be
updated accurately and in real-time so that it will
also contribute to National Drinking Water
achievements, in particular for pipe networks in Gambar 6. Screenshoot SIMAMAD
rural areas. In the future, this application is also expected to be used by
community-based SPAM in general.

Main Function:

Assisting in the management of Rural SPAM or community-based SPAM. The

following is a general overview table of SIMAMAD.
Table 6. SIMAMAD Overview

General description
Application name Village Safe Drinking Water Management Information
System (SIMAMAD)
Objective Assisting in the management of SPAM BM ( Community
Based ) / Rural

15
 Main features  National drinking access data
 Home Connection Data
 Functionality Data
 Contribution /payment data

Development Year Not yet known

Primary Data Community Based SPAM / Rural SPAM
Source
Data integration SIMSPAM
it is managed by Ditam PUPR collaborates with PDN (National Data Center)
Technical Linux OS, PHP, Laravel, Lumen, Nginx, PostgreSql
specifications
Challenges and cannot be used by SPAM providers as a whole . Can be
opportunities integrated with SIMSPAM as a whole

User Rural SPAM, Ministry of PUPR

Data Flow Input SPAM Manager Profile data, National Drinking
Water Access Data, Customer Data ,Functionality
of ,SPAM Payment Data
Output: Monitoring your evaluation
Resources SIMAMAD Video Tutorial (Youtube)
Access Address The Android application can be downloaded on Playstore

II.2.7. PUPR Open Data

The PUPR Open Data application is an initiative from the Indonesian Ministry of
Public Works and Public Housing (PUPR) which provides open access to various
data managed by this ministry. The main goal of this application is to increase
transparency, accountability and public participation in the management of
public infrastructure.

The following are the main functions regarding the PUPR Open Data application:

 One of the features contains information regarding Indonesian BUMD-AM

Performance Data.
 By providing access to data related to PUPR projects, the public can see
how public funds are used in infrastructure development such as roads,
bridges, housing and water resources.
 This application allows users to access data such as project budget,
development status, technical data, and others. This data can be
downloaded and used by the public, researchers, academics, or other
interested parties.
 These applications are often equipped with interactive features, such as
digital maps, graphs, and dashboards that make it easier for users to
navigate and understand the available data.

16
  PUPR Open Data also supports collaboration between government, the
private sector and the community in planning and monitoring
infrastructure projects. With open data access, communities and NGOs can
participate in monitoring project implementation.
 This application helps the government formulate better policies based on
existing data, as well as simplifying the process of evaluating and
monitoring infrastructure projects.

This application is part of the government's efforts to implement the principle of

openness of public information, so as to create a government that is more open,
responsive and responsible to the public.

Main Function:

To increase accountability and transparency, as well as support data-based

planning and decision making in the PUPR sector . Screenshots of the PUPR Open
Data Application and General Description can be seen in the following figure and
table:

Figure 7. Screenshot of PUPR Open Data

Table 7. PUPR Open Data Overview

General description
Application name PUPR Open Data
Objective To increase accountability and transparency, as well as
support data-based planning and decision making in the
PUPR sector

17
 Main features  Interactive Dashboard
 Open Data
 Data Search
Development Year 2016

Primary Data Internal Source Ministry of PUPR

Source Other Government Agencies (ex: BPPSPAM, BPKP)
performance data in the form of healthy,
unhealthy, sick categories and the number of
BUMD-AM in each province
Data integration Not yet, but an API is provided for integration
it is managed by Ministry of PUPR

Technical Platform : Web-based

specifications Technology : HTML5, CSS3, and JavaScript , PHP,
Python, or similar technology
Database : Relational database
Challenges and consistency and quality, as well as the need to maintain
opportunities data security and privacy ,
Can be integrated with other systems via API

User General Public, Regional Government and OPD, Private

Data Flow Data from the Directorate General of Highways,
Directorate General of Water Resources, Directorate
General of Human Settlements, Directorate General of
Housing, Directorate General of Public Works and
Housing Infrastructure Financing, Balitbang PUPR (PUPR
Research and Development Agency, Regional
Infrastructure Development Agency, Regional Work
Units, Collaboration with Other Institutions (BPS,
BAPPENAS).
Specifically, BUMD-AM performance data comes from
BPKP, to the PUPR Ministry and the general public.
Resources [Link]
Access Address [Link]

II.2.8. One Indonesian Data (SDI)

Satu Data Indonesia is a government initiative that aims to unite and integrate
data from various government agencies in one centralized portal. Launched in
2019, the portal is designed to ensure that data used in government decision-
making is accurate, up-to-date and consistent. By adopting strict metadata
standards, every agency is required to upload and publish their data in
accordance with established guidelines.

18
The One Data Indonesia Portal is managed by the Ministry of National
Development Planning/National Development Planning Agency (Bappenas) with
support from the Central Statistics Agency (BPS), the Ministry of Communication
and Information, and the Ministry of Finance. The main features of this portal
include data visualization, APIs for data integration between systems, and tools
for report creation and analysis. The available data covers various sectors such
as education, health, economy, environment and infrastructure, which can be
accessed by governments, academics, NGOs and the general public.

With One Data Indonesia, the government is trying to increase transparency,

data openness and the quality of public data. Despite challenges such as data
standardization and security, the initiative opens up huge opportunities for
better decision making and data-driven innovation across sectors. This portal is
an important foundation for more effective data governance in Indonesia.

Main Function:

Increase government transparency, provide open access to public data, and

encourage innovation by providing data that can be used by citizens,
researchers, and developers for a variety of purposes . The following is a
screenshot and general overview of the Satu Data Indonesia application:

Figure 8. Screenshot of Satu Data Indonesia

Table 8. An Overview of One Indonesian Data

General description
Application name One Indonesian Data (SDI)
Objective To increase government transparency, provide open
access to public data, and encourage innovation by
providing data that can be used by citizens, researchers,

19
 and developers for a variety of purposes
Main features  Data Catalog / Dataset
 Data Access API
 Data Visualization
 Search and Filters

Development Year 2019

Primary Data Various government agencies

Source Summary of BUMD-AM performance
Data integration Data from various government sources
it is managed by Ministry of National Development Planning/Bappenas
Technical Data Format : CSV, JSON, XML, and other formats.
specifications Infrastructure : Uses web servers and content
management systems to manage and present data.
Challenges and Need to improve integration, there are still data link
opportunities misses, security, privacy
As the dataset grows, various important data can be
added

User Users of One Data Indonesia include central and regional

governments, researchers, non-governmental
organizations (NGOs), academics, and the general public
who need data access for analysis or decision making

Data Flow  Data Source: Data is collected from various

government agencies.
 Processing Process: Data is uploaded to the portal by
the relevant agency after going through a metadata
verification and standardization process.
 Integration and Storage: Standardized data is stored
in the cloud and can be accessed through a portal.
 Output: Data can be accessed via the portal
dashboard, API, or downloaded by interested users.
Resources One Data Indonesia official website
([Link] national policy documents related to
data, publications from Bappenas, BPS, as well as
various articles and journals discussing government data
management in Indonesia.
Access Address [Link]

Overall, the existing information system related directly and indirectly to BUMD-
AM Performance Indicators is as follows: (A larger picture can be seen in the
Appendix)

20
 Figure 9. Existing Systems Related to Performance Indicators Either Directly or Indirectly

The explanation of the image above is as follows:

From the results of interviews and document studies, there were 7 (seven)
information systems identified that were either directly related to performance
indicators or indirectly.

Following are the seven information systems:

1) EVKIN (Performance Evaluation)

2) SIPD (Regional Government Information System) by the Ministry of Home
Affairs.
3) e-BUMD (Electronic Regional Owned Enterprise) by the Ministry of Home
Affairs.
4) SIMSPAM (Drinking Water Supply System Management Information
System) by the PUPR Ministry.
5) SIPEKAM (Drinking Water Performance Assessment Information System)
by the Ministry of Health
6) SIMAMAD (Village Safe Drinking Water Management Information System)

7) PUPR Open Data

8) One Indonesian Data (SDI)

Of the seven information systems above, the data flow in the image above can
be briefly explained as follows:

 EVKIN is an application built by BPKP whose purpose is to accommodate

information regarding performance data inputted by BUMD-AM throughout
Indonesia and BPKP reports this data to the PUPR Ministry and is made
into a BUMD-AM Performance book throughout Indonesia. Evkin is

21
 managed by BPKP regarding BUMD-AM performance data based on
Ministry of Home Affairs number 47 of 1999 and also based on
performance assessments from BPPSPAM, BPKP interaction with EVKIN
where BPKP apart from getting performance data inputted by BUMD-AM,
BPKP is also tasked with maintaining BUMD performance data -AM from
the EVKIN application then BPKP reports not only to the Ministry of PUPR
for BPPSPAM-based performance data, it also reports to the Ministry of
Home Affairs for performance data based on Kepmendagri 47/1999, but
also reports to the Regional Government where the BUMD-AM is located.
 Regional Government and OPD (Regional Apparatus Organizations)
receive performance reports from BPKP as a source of evaluation for
BUMD-AM and also a source of planning for Regional Development which
will be reported through the Regional Government Information System or
SIPD which is managed by the Ministry of Home Affairs., SIPD which is
managed by The Ministry of Home Affairs provides information about
regional development in city districts throughout Indonesia, but in SIPD,
BUMD-AM performance data is not accommodated in this application but
rather in an application called e-BUMD (e-Regional Owned Usama Agency)
which is still managed by the Ministry of Home Affairs but managed by the
Directorate General of Regional Financial Development while SIPD is
managed by the Directorate General of Regional Development.
 The Ministry of Home Affairs manages and maintains data from both
applications, namely BUMD and SIPD, which in the future are planned to
be integrated into one SIPD application.
 Apart from inputting data about the performance of each BUMD-AM
through the EVKIN application, they are also required to input SPAM data
through SIMSPAM which is managed by the PUPR Ministry. Apart from that,
BUMD-AM must also fill in data regarding drinking water quality through
the SIPEKAM application (Drinking Water Quality Monitoring Information
System ) which is managed by the Ministry of Health, so in this case
BUMD-AM entered data three times with different information. The
following data is input via the available applications:
 Input BUMD-AM Performance Data based on Ministry of Home Affairs 47/99
and BPPSPAM as well as additional information and BUMD-AM profile via
the EVKIN application.
 Input data/information about BUMD-AM and SPAM profiles that are
managed including the functioning, planning and development of SPAM
through the SIMSPAM application
 Input data/information about BUMD-AM Profiles, SPAM Units and Drinking
Water Quality Test Results, both in production and at
households/customers
 The PUPR Ministry obtains data/information from BUMD-AM in the form of
offline Performance Data from BPKP reports and also data input by BUMD-
AM via SIMSPAM. This performance data from BPKP is used as material to
create the BUMD-AM Performance Book every year. Apart from managing
SIMSPAM, the PUPR Ministry also manages a mobile application called
SIMAMAD (Village Safe Drinking Water Management Information System)

22
 to help manage BM (Community Based) SPAM. SIMAMAD is integrated with
SIMSPAM. Also, BUMD-AM Performance Data is also published on the PUPR
Ministry website under the name PUPR Open Data.
 The Ministry of Finance and BAPPENAS receive information both offline in
the form of performance books from the Ministry of PUPR and also the
Ministry of Home Affairs.
 Other agencies and institutions such as PERPAMSI, Financial and
Investment Institutions, other Ministries obtain BUMD-AM Performance
information from the BUMD-AM Performance Book published by the PUPR
Ministry.

II.3. Weaknesses and Limitations

The performance appraisal systems currently in use face several major
weaknesses and limitations:

 Data Validity Issues : There are concerns regarding the validity of the data
inputted by BUMD-AM. Data quality is often questionable due to the lack of
automated validation mechanisms and quality control in the data collection
process.
 Form Completeness : Many BUMD-AM have not filled out the performance
appraisal form completely and on time. This is caused by a variety of factors,
including a lack of understanding of the form, technical difficulties in using
the system, and a lack of incentives or sanctions for compliance.
 Redundancy and Integration : Existing systems are not fully integrated,
leading to data redundancy and difficulty in combining information from
multiple sources. This hinders comprehensive data analysis and integration of
reports between agencies.
 Infrastructure Limitations : The information technology infrastructure that
supports performance appraisal systems is often inadequate. These problems
include limitations in server capacity, unstable networks, and deficiencies in
backup and disaster recovery systems.
 Level of Use and Satisfaction : Data regarding the level of use and user
satisfaction shows that the majority of BUMD-AM can operate well, but is still
hampered in several ways, namely:
1. Data Security, in several cases BUMD-AM lost the data it had input
2. Slow access in the EVKIN application is due to limited time resulting in
a bottle neck connection access to the server, where many users use
almost the same time.

II.4. Information Technology Infrastructure

The infrastructure that supports the current performance appraisal system
includes:

23
  Servers and Storage : Servers used to store data are often not equipped
with adequate redundancy systems as well as adequate security and
backup.
 Network : The network used to access the system uses the internet and
some use VPN (Virtual Private Network). The speed and reliability of data
access depends on the internet connection of both parties, both on the
server and the user.
 Hardware and Software : The use of outdated or incompatible hardware
and software also becomes an obstacle in system operation.

Overall, the performance appraisal system currently in use requires

improvement to increase data validity, overcome form fill problems, and improve
integration and technology infrastructure. Evaluation and updating of integrated
information systems is needed to overcome these weaknesses and ensure that
BUMD-AM performance data can be collected, managed and used effectively.

24
 BAB III
Needs Analysis
III.1. Functional Requirements
III.1.1. Utilization of BUMD AM Performance Assessment Results data
This BUMD AM performance benchmark data/information is utilized in
accordance with the duties and functions of the relevant parties as follows:

 BUMD AM uses performance benchmarks to formulate an internal

performance improvement process, namely by including performance
indicators in KPIs and Action Plans for each sector.
 This BUMD AM Performance Report is used by Dewas for MonEv and also
for reporting to KPM, Regional Heads also use it to assess the performance
of the BUMD AM Director
 DitAM, Bappenas, Ministry of Home Affairs, Donor Institutions,
Private/Banks use data from performance assessment results as
supporting information, but the Ministry of Health has not used data from
performance assessment results
 BAPPENAS: important indicators for BAPPENAS related to planning
programs in the drinking water sector are service coverage (coverage),
safe access (safely manage) and pipe networks
 DitAM/KemenPUPR: all performance benchmarks are actually relevant to
the role of DitAM, but the most relevant is the Operational Aspect
 Ministry of Health: The Ministry of Health hopes that the objectives of this
assessment will focus on protecting public health, as well as the standard
parameters and monitoring of drinking water quality that have been
regulated in the Minister of Health Regulation can be implemented by
BUMD-AM/BUMD AM and Regional Governments
 PERPAMSI: the main priority is the service aspect, and whatever the
indicator, the performance objective refers to "Service"
 BPKP: suggests that there are 4 performance priorities to be assessed,
namely (i) NRW, (ii) K3, (iii) Coverage, (iv) FCR

III.1.2. BUMD AM Performance Assessment Indicators

Based on interviews with related parties, the data/information regarding BUMD-
AM Performance Indicators needed is as follows:

 Opinion about current BUMD-AM Performance Indicators. Almost all

stakeholders visited (especially BUMD-AM) did not object to the Current
Performance Indicators, both those referred to by BPPSPAM and the
Ministry of Home Affairs 47/1999. However, the majority proposed that the
assessment process be carried out according to the BUMD-AM category,
especially on the basis of size and location (City/Regency).
 Proposed new Aspects/Indicators being studied by DitAM/KIAT-PPB (Private
participation, Credit worthiness, Climate Change, GEDSI, Sanitation
Services): (i) most consider them relevant and do not mind being added as

25
 additional new indicators in the assessment of BUMD performance AM and
(ii) propose alternative parameters/indicators for assessment (detailed
comments per indicator are in the Appendix)
 New proposals for Aspects/Indicators being studied by DitAM/IUWASH: (i)
the majority suggest that the old indicators should still be maintained,
while the proposed new indicators could be included as additional new
indicators in the performance assessment of BUMD AM; (ii) propose
several improvements in the assessment methodology (a list of new
aspects/indicators along with detailed comments per indicator are in the
Appendix)
 Another new indicator proposal from BUMD AM. Apart from the new
aspects/indicators above, there are other new indicators proposed by
BUMD AM (a complete list of proposals is in the Appendix)

However, until now it has not been concluded or determined what indicators will
be used, what information is needed and what variables will be included in this
performance calculation. Quoting from IWA (International Water Association)
data/information is divided into 3 types, namely Performance Indicator, Context
Indicator and Variable.

The following is an explanation of these three terms according to the

International Water Association (IWA):

 Performance Indicator (Performance Indicator)

Definition: Performance Indicator (PI) is a metric used to measure the

effectiveness and efficiency of a system or organization, in this case, the
water supply system. PI provides information about how well a system or
organization achieves its goals.

Example: Some examples of PI in the context of water supply include the

percentage of water loss (Non-Revenue Water), operational cost recovery
ratio, customer service level, and quality of distributed water.

 Context Information

Definition: Context Information is an information used to provide about

environmental conditions or situations that influence the performance of a
system or organization. These indicators help in understanding the context in
which performance is measured and enable a deeper analysis of the external
factors that influence performance.

Example: Examples of context indicators could be annual rainfall levels,

population density levels in the service area, regional economic conditions,
and the quality of raw water sources.

 Variable (Variable)

Definition: Variables are data or values that can be measured and used in
calculations or analysis to produce performance and context indicators.
These variables are the basic components needed to calculate the PI and CI
and allow for more detailed and specific assessments.

26
 Example: Example variables include the amount of water produced, the
number of customers served, the amount of water sold, and operational
costs. These variables are processed and analyzed to produce various
indicators that are relevant to the performance and context of the water
supply system.

These three terms play an important role in benchmarking and performance

evaluation systems, because together they provide a comprehensive picture of
how a system or organization operates and what factors influence it.

III.1.3. Data Validation and Verification

Overcoming the problem of data validity and verification currently still needs to
be improved and therefore requires a systematic and sustainable approach.
Appropriate steps in data collection design, training, use of verification tools, and
data audits can help ensure that the data used is valid and verifiable, which in
turn improves the quality of analyzes and decisions made based on that data .
The current validity problem is due to:

 The data collected may be inaccurate due to inappropriate measurement

tools or methods.
 Biases in data collection can affect validity, such as respondent bias or
unrepresentative sampling.
 The data collected does not match the concept or variable that should be
measured.
 Understanding of terms where there is still differentiation between users.
 Missing or incomplete data may affect the validity of the analysis.

If the management of these benchmarks is still carried out by BPKP, there needs
to be changes to the SOP in carrying out data validation, for example
suggestions regarding data validation can be seen in the Attachment regarding
Proposed Data Input Schemes by BUMD-AM.

Meanwhile, data verification problems still occur in cases of:

 Errors that occur when entering data into the system.

 The same data is entered more than once, resulting in waste of energy,
time and costs.
 Inconsistent data between different sources.
 Data is still not integrated between one system and another.

III.1.4. Reporting and Analytics

Reporting and analytics functional requirements cover a wide range of aspects
from report creation and customization, accessibility, and security, to deep and
predictive data analysis capabilities. Understanding and implementing these
needs will help organizations like BUMD-AM manage data more effectively, make
decisions based on accurate data, and improve overall performance. Currently

27
 reporting is still manual, where data needs to be reprocessed to become a
report, there is no report format related to each stakeholder.

Likewise with data analysis, currently carried out by each interested stakeholder.

III.1.5. Security and Access

Security and access issues in reporting and analytics systems are critical aspects
that need to be addressed with a comprehensive approach. By implementing
strict security measures, properly managing access rights, and involving all
members of the organization in maintaining security, BUMD-AM can ensure that
their data is secure and can only be accessed by authorized individuals. This will
help maintain the integrity and reliability of data used for decision making and
daily operations. Increased security measures can be taken with data encryption
to protect data when stored and in transit. This ensures that the data cannot be
read by unauthorized parties if they manage to obtain it. Use firewalls to protect
the network from unauthorized access and intrusion detection systems to
monitor and respond to suspicious activity and Ensure all systems and software
are regularly updated to protect against known security vulnerabilities.

Currently, several ministries and BPKP have implemented data backup, although
this still needs to be improved. In terms of access, each user must be registered
in their application but still needs to be improved, for example with Multi-Factor
Authentication (MFA): Using MFA to add an additional layer of security, ensuring
that only authorized users can access the system. Access Rights Management,
establishing role-based access rights policies to ensure that users can only
access the data and functions they need for their jobs and conducting regular
monitoring and auditing of data access to detect and respond to unauthorized or
suspicious activity.

III.1.6. Integrated Data

Currently there is still redundant data input, and access to data still involves
many ministries and some access is not automatic, so a system with integrated
data is needed. Therefore, integrated data is a need for various stakeholders.

In the context of data management in BUMD-AM and the need for data access
involving many ministries and other institutions/agencies, data integration
becomes very important. Redundant data input and non-automatic data access
can cause inefficiencies, errors and delays in decision making. The following is an
explanation of why a system with integrated data is needed and how to
implement it:

 Efficiency and Redundancy Reduction:

o Integrated data reduces the need for repeated data entry across
multiple systems, thereby reducing the risk of errors and saving time.
o With one centralized data source, information only needs to be entered
once and can be accessed by all authorized parties.
 Data Accuracy and Consistency:

28
 o Data integration ensures that all parties are working with the same
information, reducing inconsistencies that can arise from different data
sources.
o Minimizes the risk of errors caused by out-of-sync data between
different systems.
 Accessibility and Ease of Use:
o Integrated data can be easily accessed by various stakeholders,
including relevant ministries, through a user-friendly interface.
o Eliminates data access barriers, enabling faster decision making based
on accurate information.
 Better Analytics and Reporting:
o Integrated systems enable more comprehensive and holistic data
analysis, providing deeper insights.
o Reports can be generated automatically and faster, with data that is
always up-to-date.
 Collaboration between Ministries/Institutions/Agencies:
o Enables multiple government agencies to collaborate more effectively
with access to the same data.
o Reducing bureaucracy and speeding up the communication and
decision-making process between ministries.

III.2. Non-Functional Requirements

Non-functional requirements such as performance, scalability, reliability, and
ease of use are critical to ensuring that the system functions well and meets user
expectations. By focusing on these aspects, organizations can ensure that
systems not only perform their functions well, but also provide a positive user
experience, can handle increased loads, and remain available and reliable under
a variety of conditions.

III.2.1. Requirement: System Responsiveness and Response Time

o Responsiveness: The system must be able to provide fast responses to
user requests, whether in the form of data queries, transaction processes,
or interaction with the user interface. Good performance ensures that the
system does not experience delays or interruptions that can affect user
productivity.
o Response Time: Measures the time required by the system to process a
request and provide results. This includes the time it takes to load a page,
run a report, or complete a transaction. Optimal response times improve
user experience and operational efficiency.

III.2.2. Scalability
The longer the data, the greater the capacity, so it is called Big Data
management, as well as the Performance Indicator data, which becomes larger
over time, therefore scalability is needed. In future, this scalability must have the
ability to increase system capacity by increasing hardware resources on existing
servers, such as adding RAM, CPU, or storage and also the ability to increase
system capacity by increasing the number of servers or nodes in the system.

29
 This allows the system to handle increased load by distributing processes across
more units.

III.2.3. Reliability
As complained by several EVKIN users who at certain times cannot access the
application, therefore the need for reliability is important, where the system
must be designed to provide high availability, minimizing downtime. High uptime
ensures that the system is always available and accessible to users without
significant disruption , and no less important is the existence of mechanisms for
effective disaster recovery, including regular data backup and recovery
procedures to overcome damage or loss of data due to disasters or system
failures.

III.2.4. Ease of Use

One of the causes of inaccurate validity and minimal content, one of which is
caused by the application not being easy to use by users, therefore an intuitive
user interface (UI) is needed where the system must have a user interface that is
easy to use and understand. by end users. In addition to the causes of validity
and poor occupancy, an intuitive UI reduces the learning curve and increases
user productivity.

Apart from that, data managers need to provide responsive and effective user
support to help users solve problems, answer questions, and provide technical
assistance.

III.3. Needs for Integrated BUMD-AM Performance Benchmarking

System Managers
Currently, the determination of who is most likely to be the manager of the
BUMD-AM performance benchmarking system is being studied. From the table
below, there are several aspects that will be taken into consideration by the
institution/institution that will manage it.

30
Table 9. Assessment of Ministries/Non-Ministerial Institutions proposed to become managers

31
However, until this report was written, it had not been decided who was most
likely to become the manager, it will be studied in a Focus Group Discussion at
the end of August.

The following is the flow of information on Performance Indicators from BUMD-AM

if managed by several alternative managers.

32
 Figure 10. Data Flow If BPKP is the Manager of BUMD-AM Performance Benchmarks

Figure 11. Data Flow If BAPPENAS Becomes the Manager of BUMD-AM Performance Benchmarks

33
Figure 12. . Data Flow If the Ministry of PUPR becomes the Manager of BUMD-AM Performance
Benchmarks

34
35
Figure 13. . Data Flow If the Ministry of Home Affairs is the Manager of BUMD-AM Performance
Benchmarks

Figure 14. . Data Flow If PERPAMSI Becomes BUMD-AM Performance Benchmark Manager

36
Figure 15. . Data Flow if the new agency becomes BUMD-AM Performance Benchmark Manager

37
 BAB IV
Findings and Recommendations
IV.1. Key Findings
From the results of interviews and field visits regarding BUMD-AM performance
indicators and the applications used, several key findings are as follows:

1. Data produced and input by BUMD-AM regarding performance indicators is

needed by various stakeholders, including BAPPENAS, Ministry of PUPR,
Ministry of Home Affairs, Ministry of Health, PERPAMSI, Financial and
Investment Institutions, Ministry of Environment and Forestry, Regional
Government and Regional Apparatus Organizations ( OPD). At the
implementation stage, BUMD-AM must be able to serve these stakeholders
one by one, even though there is the same data that does not have to be
entered repeatedly, for example company profile data, SPAM data, planning
and development data, collaboration data with private parties or other parties,
etc. -other .
2. The data required for integration is spread across various ministries and BPKP
3. Regarding data security, some institutions/agencies or ministries have
provided their own backups, but others still don't have one .
4. Limited and Non-Real-Time Data Access: Without an integrated system,
access to data is often slow and not always updated in real-time, so decision
making can be hampered.
5. Lack of Data Standardization: Without integration, data standards used by
various stakeholders may differ, causing difficulties in data consolidation and
analysis.
6. Reliance on Manual Processing: Without integration, many data processing
processes are still done manually, increasing the risk of human error and
reducing efficiency.
7. Lack of Interoperability: Disparate systems often cannot communicate with
each other or share data, hindering collaboration and synchronization between
agencies.
8. Data content, especially in the SIPEKAM, SIPD, e-BUMD and SIMSPAM
applications, is still not as expected.

IV.2. Recommendation
To overcome these findings, the following can be proposed:

1. Integrated System Development (Integrated System) . Design and

Implementation: Building a unified data integration platform that can
accommodate various data needs from stakeholders. This system must be
able to handle a single data input that can be accessed by all stakeholders.
This integrated system is divided into 2 (two) alternatives, namely an
Integrated System with a database spread across each of the main
stakeholders (BPKP, Ministry of PUPR, Ministry of Home Affairs and Ministry of

38
Health) and an Integrated System with a centralized database (There is a
database specifically for the management body) .

Figure 1. Integrated System with Distributed Database

Figure 2. Integrated System with Centralized Database

Of course, these 2 (two) alternatives have advantages and disadvantages,

but the concept of an integrated system can be seen in the scheme below:

39
 Figure 3. Integrated System Concept

The following can be explained the advantages and disadvantages of an

Integrated System with Distributed and Centralized Databases:

Integrated System with Integrated System with

Distributed Database Centralized Database

Excess: Excess:
 Data is spread across several  It is easier to ensure data
locations, thereby reducing the consistency because all data is
risk of data loss due to system stored in one place.
failure in one location.  System management,
 It's easy to add more data and maintenance and updates are
storage capacity because each easier because all data is in one
unit can manage its own location.
database.  It is easier to secure data
 Data access can be faster because there is only one access
because data is stored close to point that needs to be protected.
the user or application that needs  Lower operational and
it. maintenance costs because it
 If one server or location does not require a lot of
experiences a problem, other infrastructure.
systems can still function,
increasing overall reliability.
Lack:
Lack :  If the central server fails, the
 Requires complex entire system can come to a halt,
synchronization mechanisms to increasing the risk of total failure.
ensure data across locations  Data access can be slower for
remains consistent. users located far from the central
 Managing and maintaining server.
multiple databases in various  Adding storage or processing
locations can be a complex task capacity may be more difficult
and require more resources. and expensive due to limited
 More potential points of physical scale at a single
vulnerability that can be location.

40
 exploited, increasing security  If a problem occurs in the data
risks. center, the entire system can be
 Higher implementation and impacted, reducing overall
maintenance costs due to reliability.
infrastructure requirements in
multiple locations.

2. Develop APIs that can be used by various applications and systems to

communicate and share data.
3. Establish clear and uniform data standards for all stakeholders to ensure
data consistency and compatibility.
4. Develop a comprehensive guide for filling in data that is easy to understand
and follow by all parties involved.
5. Develop and implement strong security protocols to protect data from
security threats, including regular data backups.
6. Organizing regular training programs to increase BUMD-AM staff's
understanding of terms and the process of filling in data and conducting
outreach regarding the new integrated system and its benefits for all
stakeholders.
7. Assistance by experts to users for a long time until the system can be used
according to expectations.
8. Using technology to automate data input and processing processes, which
can reduce manual errors, and increase efficiency.
9. Adopt a system that allows real-time data processing, so that data is always
up-to-date and can be accessed at any time.
10. To optimize data content, the following recommendations can be proposed:
a) Conduct regular outreach regarding the importance of filling out
performance appraisal forms. Use various media, such as webinars,
workshops and digital outreach materials.
b) Provide technical training to BUMD-AM staff on how to fill out online
performance assessment forms. Make sure they understand each
indicator and how to fill in correctly.
c) Forming an accompanying team tasked with assisting BUMD-AM in filling
out performance assessment forms. This team can provide direct support
via site visits or remote assistance via telephone and email.
d) Providing a helpdesk that can be accessed by BUMD-AM to obtain
technical and non-technical assistance regarding filling out forms.
e) Implement technology that can automate data collection. For example,
the use of sensors and IoT devices to collect operational data
automatically.
f) Simplify the performance appraisal form to make it easier to understand
and fill out. Focus on the most relevant and important indicators.
g) Provide financial incentives to BUMD-AM who consistently fill out
performance appraisal forms on time and accurately.
h) Give awards and recognition to BUMD-AM who show good performance in
filling out forms. Awards can take the form of certificates, trophies, or
public recognition.

41
i) Create regulations that require BUMD-AM to fill out a performance
assessment form. This regulation can be integrated into regional
regulations or national policies.
j) Implement administrative sanctions for BUMD-AM who do not fill out the
performance assessment form. This sanction could take the form of a
downgrade or restriction of access to aid funds.
k) Carry out regular monitoring of the fill level of performance assessment
forms. Identify inactive BUMD-AMs and provide special assistance.
l) Evaluate the form filling process and provide feedback to BUMD-AM. Use
evaluation results to continually improve processes.

42
 BAB V
IMPLEMENTATION PLAN
V.1. Project Preparation
V.1.1. Identify Stakeholders.
The first step in this project is to identify all parties involved or affected by the
implementation of the information system. In this case, stakeholders must be
ascertained at the beginning, whether in the previous analysis all stakeholders
will be involved or not, including existing information systems . Meanwhile, the
stakeholders involved are the Ministry of PUPR, Ministry of Home Affairs, Ministry
of National Development Planning/Bappenas, Ministry of Finance, Ministry of
Health, Regional Government and OPD, BUMD-AM, Financial/Investment
Institutions, Perpamsi, BPKP. Every stakeholder It is important to understand the
interests , needs and expectations to ensure optimal support for the system to
be built . Apart from that, it is necessary to first ensure that data/information
from existing systems will be integrated with the system to be developed.

V.1.2. Formation of the Project Team .

Next is to form a project team that will be responsible for planning, developing,
implementing and monitoring the system. This team usually consists of technical
experts, project managers, business analysts, as well as representatives of end
users. Selection of team members who have the right skills and experience is
very important for the success of the system to be developed.

V.1.3. Determining the Scope and Specific Objectives of System

Development .
In this stage, the scope and specific objectives of the system development must
be clearly defined. This includes the definition of business requirements, project
constraints, as well as expected results. A clear scope will help in managing the
project's time, budget, and resources, as well as ensuring that all parties have
the same understanding of the end goal of the project.

The system to be developed is a development of the EVKIN application which is

managed by BPKP, but there are several enrichments so that the scope of
system development is:

a. Combining Performance Indicators based on Kepmendagri 47/99 and

BPPSPAM with the addition of other indicators such as the inclusion of GEDSI
elements, Climate Resilience and Sanitation, which will be determined later,
as well as the results of a review of all the indicators that will be used,
including procedures for data collection, validity, value calculation indicator
b. The new system will accommodate all performance indicator data including
Contextual Information, where the data will be input by BUMD-AM .
c. Each stakeholder can access all of this data to be used according to the
needs of each stakeholder and the system will facilitate the selection and
retrieval of performance indicators and Contextual Information from each
BUMD-AM.

43
 d. Every information system in each stakeholder can access this data via the
API protocol.

The aim of developing this system is to provide validated, accountable and up-
to-date data on BUMD-AM performance indicators and Contextual Information
that can be utilized by every stakeholder for investment, evaluation and
monitoring, SPAM development and other purposes.

V.2. System Development

V.2.1. System Architecture Design Based on Functional and Non-
Functional Requirements.
At the beginning of this report we discussed needs analysis, both functional and
non-functional. Based on this, the system to be developed needs to be designed
based on functional (features and services required by the system) and non-
functional (performance, security, scalability, etc.) requirements. This design
includes the structure of system components, the relationships between
components, and the technology that will be used. Good architectural design will
ensure the system can meet current and future business needs.

The architectural design that must be built is:

 Database Architecture
 Integration Architecture
 Infrastructure Architecture
 Security Architecture
 UI/UX Architecture
 Reporting & Analytics Architecture
 Development Architecture

This architectural design must be approved by the competent authority, in this

case by the Project Team Leader.

V.2.2. Development or Adaptation of Information System Modules.

Based on the system design, information system modules will be built which will
be developed or adjusted. The main modules that are expected to be present
include:

V.2.2.1. System Admin Module

This module is a module that is used to manage the system so that it runs well,
usually in the form of:

 User Management
 Content Management
 Reporting and Analysis
 File Management
 Integration
 Backup Management

44
 V.2.2.2. BUMD-AM Module
This module is a module used to manage data input for Performance Indicators
and Contextual Information, in the form of:

 Indicator Data Input and Management Module

 Report
 Backup Management

V.2.2.3. User/Stake Holder Module

This module is a module used by stakeholders for BUMD-AM Performance
Indicator and Contextual Indicator data, in the form of:

 Stakeholder Registration Module

 Indicator Data Access Module (Selection, Data Retrieval, API, Data Export)

This process involves writing code, initial testing, and integration with other
existing modules. Each module must be able to function independently but can
still be integrated with other modules to achieve overall system goals.

V.2.3. System Testing

System testing is carried out to ensure that each system component and module
functions according to specifications. Testing includes:

 Unit Testing: Testing the smallest pieces of code to ensure the system
works well individually.
 Integration Testing: Testing to ensure that different modules can work
together well.
 User Acceptance Testing (UAT): Testing performed by end users to ensure
that the system meets their needs and expectations.

V.3. Data Migration

V.3.1. Collection and Verification of Existing Data.
Before data migration is carried out, data from the old system (EVKIN) must be
collected and verified. This process involves checking the accuracy,
completeness, and consistency of data to ensure that the data to be migrated is
ready and error-free.

V.3.2. Data Migration From Old System to New System.

The verified data is then moved from the old system to the new system. This
process can be done manually or automatically, depending on the complexity
and volume of data. It is important to ensure that data is transferred accurately
and that no data is lost during the migration process.

V.3.3. Post-Migration Data Validity Testing.

After migration, the validity of the data in the new system must be tested to
ensure that the data has been moved correctly and is still valid. This includes
checking the accuracy, integrity and consistency of data, as well as testing
system functions that rely on that data

45
 V.4. Training and Socialization
V.4.1. Training For End Users Regarding The Use Of The New System.
End users (System Manager/Admin), BUMD-AM, Stakeholders must be given
adequate training on how to use the new system. This training covers basic
operational practices, as well as specific features relevant to the role of each
stakeholder . The goal is to ensure that users feel comfortable and competent in
using the system to support their work.

V.4.2. Socialization to all stakeholders regarding the benefits and

changes expected from system implementation.
Apart from training, it is also important to provide outreach to all stakeholders
regarding the expected benefits of the new system and the changes that will
occur. This socialization aims to build support and minimize resistance to
change, by ensuring that all parties understand and accept the reasons behind
implementing the system.

V.5. System Implementation

V.5.1. Implementation in stages or in full (big bang or phased rollout).
System implementation can be done in stages (phased rollout) or all at once (big
bang). Phased implementation allows an organization to test and adjust the
system in stages, while full implementation involves rolling out the entire system
at one time. The choice between these two approaches must be adjusted to the
needs and readiness of the system manager.

V.5.2. Initial Monitoring to Identify and Correct Problems that Arise.

After the system is implemented, an important first step is to carry out
monitoring to identify problems or errors that may arise. This monitoring is
carried out in real-time to ensure that the system is functioning properly and that
any issues can be resolved as quickly as possible to minimize disruption to
business operations.

V.6. Evaluation and Adjustment

V.6.1. System Performance Evaluation after Implementation.
After the system has been running for some time, a system performance
evaluation is carried out to assess whether the system meets the stated
objectives. This evaluation involves measuring performance, reliability, user
satisfaction, and the business benefits that have been achieved.

V.6.2. System adjustments and improvements based on user feedback.

Based on the evaluation results and feedback from users, system adjustments
and improvements can be made. This may include bug fixes, adding new
features, or changes to business processes related to using the system. These
adjustments aim to ensure that the system continues to meet the organization's
needs and can evolve as the business environment changes.

46
V.7. Schedule and Time
The following is a schedule of activities and time required to build the new
BUMD-AM Performance Indicator Information System.

Table 10, Schedule of System Development and Implementation Activities

Month to
No Stages Activity 1 2 3 4 5 6 7 8 9 1
0
1 Preparation  Team building x
 Preparation of project
documents
 Determination of
Performance Indicators,
Functional & Non-
Functional Requirements
2 Development  System Design x x x
o Database Architecture
o Integration
Architecture
o Infrastructure
Architecture
o Security Architecture
o UI/UX Architecture
o Reporting & Analytics
Architecture
o Development
Architecture
o Design Approval
 Coding/Scripting
 Testing
3 Data  Data Migration x x
Migration &  System Testing
Testing (functional, non-
functional, resilience,
recovery, security,
maintenance)
 Data Validation
4 Documentati  End-User Training, x
on, Training System Socialization
&
Socialization
5 Implementati  System Implementation x x
on / Deploy  Initial Monitoring
6 Evaluation  System Performance x
Evaluation
 Adjustment

47
 V.8. Required Resources
V.8.1. Human Resources:
To develop an integrated performance indicator system, experts are needed,
namely:
 1 system analyst for 3 months
 2 programmers for 9 months
 1 person to test for 1 month
 1 person as a trainer for 1 month

V.8.2. Technology Infrastructure:

To support an integrated performance indicator system, technological
infrastructure support is needed in the form of:

 Servers and supporting hardware.

 Software (software) required for development and testing.
 Adequate network and connectivity.

V.8.3. Budget:
For system development and implementation, a budget is required for:
 System development budget.
 Budget for training and outreach.
 Budget for post-implementation care, mentoring and support.

48
 BAB VI
CONCLUSIONS AND RECOMMENDATIONS
VI.1. Conclusion
From the results of the interim study of BUMD-AM Performance Indicators,
where the study will produce performance indicators and Contextual
Information which will be agreed upon especially by the Ministry of PUPR as
well as determining functional and non-functional requirements for the
BUMD-AM performance indicator information system, then to develop an
indicator information system The performance of the new BUMD-AM needs to
pay attention to the following existing conditions:
1. There are repeated requests for data: BUMD-AM must serve various
stakeholders such as BAPPENAS, Ministry of PUPR, Ministry of Home
Affairs, etc., with the same data. This causes duplication of data input
such as company profiles, SPAM data, and collaboration data, which
could actually be avoided with an integrated system.
2. The data required for integration is spread across various ministries
and BPKP, making it difficult to carry out efficient consolidation.
3. Some institutions already have data backup, but there are still some
that don't have a backup system, thereby threatening overall data
security.
4. Slow and Non-Real-Time Data Access: Without an integrated system,
access to data is often slow and not always updated in real-time,
hindering fast and precise decision-making processes.
5. Lack of Data Standardization: Different stakeholders use different data
standards, causing difficulties in data consolidation and analysis.
6. Some data processing processes are still carried out manually without
an integrated system, increasing the risk of errors and reducing
efficiency.
7. Lack of Interoperability: Current systems are disparate and unable to
communicate with each other or share data, hindering collaboration
and synchronization between agencies.
8. Inadequate Data Content: Applications such as SIPEKAM, SIPD, e-
BUMD, and SIMSPAM have not been able to meet expectations in
terms of data content.

VI.2. Recommendation
The following are recommendations for overcoming the weaknesses of the old
system based on key findings:

1. To be able to develop an integrated data management system that

can collect and store data from various stakeholder sources
simultaneously. This system must allow data input only once for use
by various parties. By reducing duplication of data input, making data

49
 access and processing easier, and reducing the administrative burden
on BUMD-AM.
2. Implement a data integration solution that allows data synchronization
between ministries, BPKP, and BUMD-AM. APIs or middleware
platforms can be used to connect different systems. This will make it
easier to consolidate data from various sources, increasing the
accuracy and completeness of available data.
3. Implement a centralized and secure data backup system, as well as a
comprehensive security system to protect data from unauthorized
access and loss. In order to ensure data security and integrity, reduce
the risk of losing important data.
4. Implement technology that enables real-time data access and
automatic updates. Consider using a web-based dashboard or mobile
application to facilitate data access , thereby speeding up decision
making, increasing responsiveness to information needs.
5. Establish uniform data standards and data management policies that
must be followed by all stakeholders. Create consistent guidelines and
templates for data input so as to reduce difficulties in data
consolidation and analysis, increasing data consistency between
agencies.
6. Develop or select a system that allows automation in data processing
to reduce dependence on manual processes. Use technology such as
robotic process automation (RPA) if necessary so you can reduce the
risk of human error, increase efficiency and accuracy in data
processing.
7. Choose a system that supports interoperability with other systems
through compatible communications and data standards. Consider
using solutions based on international standards so that they can
increase collaboration and synchronization between various agencies,
making data exchange easier.
8. Carry out audits and updates on the SIPEKAM, SIPD, e-BUMD, and
SIMSPAM applications to ensure data content is in accordance with
expected standards. It is hoped that implementing training for users to
improve the accuracy of data input with this step can be achieved
ensure that the data in the application is more complete and accurate,
improving the quality of data used for analysis and decision making.

50
Attachment to Existing Information Systems Related Directly or Indirectly to BUMD-AM Performance Indicators

51
 Attachment
to Proposed BPPSPAM Performance Indicators and Contextual Information
BPPSPAM PERFORMANCE UNDERSTANDING SYMBO FORMULA VARIABLES WEIG INDICATOR
INDICATORS LS | DATA HT VALUE (NI)
SOURCE
1 Profitability BUMD-AM's ability to create
A.
FINANCE

profits or obtain profits and

ensure operational continuity
(going concern)

1 ROE (Return on Ratio to measure the level of RoE  RoE=LB/JE LB | Income 0.05 RoE >=10 (%);
a Equity) ability to earn profits from  JE=MOD + CAD statement NI=5
existing capital (equity). RoE >7 (%);
Where : MOD, CAD | NI=4
LB = Net Profit Balance RoE >=3(%);
After Tax Sheet Report NI=3
JE = Total Equity RoE>=0(%);
MOD=Capital NI=2
CAD=Reserve RoE<0 (%); NI=1
1 Operating Ratio A ratio to measure the level of RO RO=BO/PO BO | Income 0.05 RO>1; NI=1
b efficiency of expenses incurred statement RO<1; NI=2
to generate income Where : RO<0.85; NI=3
BO=Operating P O | Income RO<0.65; NI=4
Expenses statement RO<=0.5; NI=5
PO=Operating
Income
2 Liquidity BUMD-AM's ability to fulfill its
short-term obligations or in
other words BUMD- AM's ability
to fulfill obligations or
obligations that must be paid

52
 immediately with its current
assets
2 Cash Ratio Ratio to measure cash ability to R.K RK = (JK+SK)/JKL JK, SK, SJKL | 0.05 RK>=100,NI=5
a guarantee short-term Balance RK>=80, NI=4
obligations Where : Sheet Report RK>=60,NI=3
JK=Total Ka RK>=40, NI=2
SK= Cash RK<40, NI=1
Equivalents
JKL=Total Current
Liabilities
2 Billing Effectiveness Measures for measuring the E.P EP = JPRA | Billed 0.05 EP>=90, NI=5
b effectiveness of billing activities JPRA/JRA*100% Account Data EP>=85, NI=4
for water sales proceeds Report RP>=80, NI=3
Where : RP>=75, NI=2
JPRA=Total Water JRA | Annual RP<75, NI=1
Account Receipts DRD report
JRA=Number of
Water Accounts
3 Solvency BUMD-AM's ability to guarantee SV SV = JA/JW*100% JA | Balance 0.03 SV>=200, NI=5
long-term obligations with its Sheet Report SV>=170, NI=4
assets Where : JK | Balance SV>=135, NI=3
JA=Total Asset Sheet Report SV>=100, NI=2
Value SV<100, NI=1
JK=Amount of
liabilities

53
 1 Coverage of A measure to find out what CKP CKP=JPT/ JSR | 0.05 CKP>=80, NI=5
B. SERVICE
Engineering Services percentage of the population JPWP*100% Subscription CKP>=60, NI=4
served by BUMD-AM is Reports CKP>=40, NI=3
compared to the total JPT=JSR*KK CKP >=20, NI=2
population in the BUMD-AM KK | BPS CKP<2-, NI=1
service area Where :
JPT= Number of JPT |
people served Engineering
(people) Report
JSR = Number of
Household
Connections

KK=Number of
Souls per KK

JPWP=Number of
residents in the
service area
(people)
2 Customer Growth Percentage increase in the PP PP=(JPPI-JPPL)/ JPPI, JPPL | 0.05 PP>=10, NI=5
number of BUMD-AM customers JPPL*100% Subscription PP>=8, NI=4
in one period (monthly, Reports PP>=6, NI=3
quarterly, semester or yearly) Where : PP>=4, NI=2
JPPI=Number of PP<4, NI=1
customers this
period (SR)
JPPL=number of
customers last
period (SR)
3 Complaint A measure to assess BUMD- landfill TPA=JPP/JP*100% JPP, JP | 0.025 TPA>=80, NI=5
Resolution Rate AM's response to customer Customer TPA>=60, NI=4
complaints Where : Complaint TPA>=40, NI=3

54
 JPP=Number of Report TPA>=20, NI=3
customer TPA<20, NI=1
complaints handled
JP=Number of
complaints
4 Customer Water The measure used to determine HOOD KAP=JUPS/ JUPS, JU | 0.075 KAP>=80, NI=5
Quality whether the quality of water JU*100% Wipe. Lab KAP>=60, NI=4
distributed by BUMD-AM to Test Results KAP>=40, NI=3
customers meets the quality of Where : KAP>=20, NI=2
drinking water as stipulated in JUPS=Number of KAP<20, NI=1
Minister of Health Regulation eligible tests
Number JU=Amount tested
492/MENKES/PER/V/2010
Concerning Drinking Water
Quality Requirements
5 Water Consumption A measure used to describe the KART KART=JATPD/JPD JATPD | 0.05 KART>=30,
R. Stairs level of water usage by Water NI=5
domestic (household) Where : Account KART>=25,
customers JATPD=Amount of Overview NI=4
water sold to KART>=20,
domestic customers JPD | NI=3
on average (m3) Subscription KART>=15,
per month Reports NI=2
JPD=Number of KART<15, NI=1
domestic customers
(SR)
1 Production Efficiency Measuring the efficiency of the E.P EP=RP/KT * 100% EP, KT | 0.07 EP>=90, NI=5
C.
OPERATIONAL

production system Engineering EP>=80, NI=4

Where : Report EP>=70, NI=3
RP=Realized EP>=60, NI=2
Production (m3) EP<60, NI=1
KT=Installed
Capacity (m3)

55
2 Water Loss (ATR) The difference between the ATR ATR=(AD-AT)/AD AD | 0.07 ATR<=25, NI=5
water entering the distribution * 100 % Engineering ATR<=30, NI=4
unit and the water billed over a Report ATR<=35, NI=3
period of time during the Where : AT | Water ATR<=40, NI=2
evaluation period AD=Water Account ATR>40, NI=1
distribution (m3) Overview
AT=Water sold
(m3)
3 Service Operating Measuring overall system JOP JOP=WD/PERIOD WD | 0.08 JOP>=21, NI=5
Hours efficiency and its relationship to Engineering JOP>=18, NI=4
service continuity Where : Report JOP>=16, NI=3
WD = Water JOP>=12, NI=2
distribution time to JOP<12, NI=1
customers during
the evaluation
period
PERIOD =
Evaluation period
(days)
4 Farthest Connection Measuring the number of TST TST=JPT/JP*100% JP | 0.065 TST>=80, NI=5
Pressure customers served with pressure Engineering TST>=60, NI=4
according to the specified Where : Report TST>=40, NI=3
minimum pressure JPT=Number of JP | TST>=20, NI=2
customers served Subscription TS<20, NI=1
with a minimum Reports
pressure of 0.7 bar
(SR)
JP= number of
customers (SR)
5 Customer Water Measuring the level of KMA KMA= JMG | 0.065 KMA>=20, NI=5
Meter precision/accuracy of customer JMG/JP*100% Engineering KMA>=15, NI=4
Replacement/Calibra water meters Report KMA>=10, NI=3
tion Where : KMA>=5, NI=2

56
 JMG= Number of JP | KMA<5, NI=1
customer water Subscription
meters replaced Reports
(SR)
JP=number of
customers (SR)
D. 1 Ratio of Number of Describes the level of efficiency lesson RPP=JPEG/(JP/1000) JPEG | 0.07 RPP<=6, NI=5
HR Employees/1000 and effectiveness of using labor plan Personnel RPP<=8, NI=4
Customers to provide services to customers Where : Report RPP<=10, NI=3
JPEG=Number of RPP<=12, NI=2
employees JP | RPP>12, NI=1
JP=Number of Subscription
customers Reports
2 Certified Employee How high is the employee RPS RPS=JPS/JPEG * JPS, JPEG | 0.04 RPS>=80, NI=5
Ratio competency level owned by 100% Personnel RPS>=60, NI=4
BUMD-AM so that it can have a Report RPS>=40, NI=3
positive impact on improving Where : RPS>=20, NI=2
service to customers JPS=Number of RPS<20, NI=1
employees taking
part in training
(people)
JPEG=Number of
employees (people)
3 Employee Training Measuring the company's RDP RDP=JBD/ JBD | 0.04 RDP>=10, NI=5
Ratio efforts to increase employee JBP*100% Personnel RDP>=7.5, NI=4
competency Report RDP>=5, NI=3
Where : JBP | Income RDP>2.5, NI=2
JBD=Total training statement RDP<2.5, NI=1
expenses (Rp)
JBP=Total
employee expenses
(Rp)

57
Performance Value Calculation:
18
NK = ∑ ( Bobot∗¿)
indikator=1

Where:

NK= Performance Value

Weight = Weight of each indicator
NI=Indicator Value

BUMD-AM Health Category

Performance Category
Value
> 2.8 HEALTHY
2.2 - 2.8 UNWELL
< 2.2 SICK

Additional information
To provide a complete picture of BUMD-AM's performance conditions, there is some additional information that needs to be sought and
data collected. This additional information can be used to complete the information needed to analyze BUMD-AM performance conditions
more comprehensively. This additional information is:

NO INFORMATION INFORMATION
1 Average rate (Rp/m3) The average tariff is data obtained from the division between total water
sales revenue and the volume of water sold. Water sales income is the sum
of water and non-water sales (fixed and administrative expenses).
2 HPP / Basic Cost with standard NRW (Rp/m3) The basic load with standard NRW is obtained from the total operating
expenses divided by the volume of produced water minus the volume of

58
 standard water losses (by 20%).
3 HPP / Basic Cost with Real NRW (Rp/m3) The basic load with Real NRW is obtained from the total operating expenses
divided by the volume of produced water minus the volume of real water
losses.
4 COGS Excluding Depreciation/Amortization and Basic expenses (excluding depreciation/amortization and interest expenses)
Interest Costs (Rp/m3) with Real NRW are obtained from total operating expenses excluding
depreciation expenses and interest expenses divided by the volume of
produced water minus the volume of real water losses.
5 Total Fixed Assets (Rp.000) BUMD-AM's total fixed assets are the asset value as of the evaluation
balance sheet date.
6 Total Assets (Rp.000) Total assets are the value of assets at the balance sheet date which consists
of current assets and fixed assets
7 Current Liabilities (Rp.000) Total BUMD-AM short-term liabilities with a maturity of less than one year
8 Long Term Debt (Rp.000) The total long-term liabilities of BUMD-AM are more than a year.
9 Other payables (Rp. 000)
10 Total Equity (Rp.000) Total equity of BUMD-AM as of balance sheet date.
11 Net Profit after Tax (Rp.000) Total net profit/loss after tax obtained by BUMD-AM during the year.
12 Total income (Rp.000)
13 Chemical Costs (Rp) The amount of chemical load released by BUMD-AM to produce 1 (one) m3
of water.
14 Energy Cost (Rp) Energy costs incurred by BUMD-AM to produce 1 (one) m3 of water. The
energy loads in question are: electricity, diesel, gas and other fuel loads.
15 Maintenance Fee (Rp) The amount of maintenance expenses incurred by BUMD-AM for 1 (one)
year
16 Profit Margins Profit margin is net profit after tax divided by operating income.
17 Asset Turnover Asset turnover is total income divided by total assets
18 Return on Assets Return on assets is net profit after tax divided by total assets
19 Asset Per SR Ratio (Rp/SR)
20 Admin Expense Ratio. General: Total Income (%) This ratio is the percentage of general administrative expenses incurred by
BUMD-AM to its total income.
21 Installed Capacity (L/sec) Installed capacity is the capacity of BUMD-AM production units installed
according to plan (L/sec).

59
22 Real Production Volume (L/sec) Real production volume is the volume of water produced in real terms by
BUMD-AM in a year which is converted into liters per second (L/sec).
23 Number of Customers (SL Units) Represents the number of BUMD-AM's domestic and non-domestic
customers as of the balance sheet date
24 Number of Population in the Administrative Area The number of residents living in the district/city administrative area at the
(People) time of evaluation
25 Number of Population in the Service Area (People) Number of residents residing in the BUMD-AM technical service area at the
time of evaluation.
26 Served Population (people) Number of residents served by BUMD-AM at the time of evaluation.
27 Number of Employees (people) Number of BUMD-AM employees for a year.
28 Average Employee Costs (Rp/employee/month) This is the average employee burden incurred by BUMD-AM every month.

29 Number of customers last year

30 Real production volume
31 Installed Product Capacity
32 Water Distribution Volume
33 Water distributor time to customers in 1 year
34 Transmission Pipe Length (m)
35 Distribution Pipe Length (m)
36 Reservoir Volume (m3)
37 Depreciation/Provision/Amortization Expenses
38 Regional Government Capital to Date
39 Inclusion of YBDS Central Government
40 RPAM Whether or not there is an RPAM Document
41 RISPAM Whether or not there is a RISPAM Document
42 BUSINESS PLAN Whether or not there is a Business Plan Document

60
 Attachment
to Proposed Performance Indicators for Minister of Home Affairs Decree
47/1999 and Contextual Information
INDICATORS OF THE UNDERSTANDING SYMBO FORMULA VARIABLE | DATA INDICATOR
KEPMENDAGR 47 OF 1999 LS SOURCE VALUE (NI)
1 Profit/Productive RLA RLA=EBT/AP BL, BAU, BNO, PNO, RLA>10, NI=5
A. FINANCE

Assets Ratio PPA, PNA | Income RLA>7, NI=4

PBT=PO+PNO-BO statement RLA>3, NI=3
PO=PPA+PNA RLA>0, NI=2
BO=BL+BAU-BNO RLA<=0,
NA=1
Where:
EBT = Profit Before Tax
PO=Operating Income
PPA=Water Sales Revenue
PNA=Non-Water Revenue
BO=Operating Costs
BL=Direct Costs
BAU=Administrative and
General Costs
BNO=Non-Operating Costs

Bonus Value=5 Increase in Profit Ratio PS NB=RLATI-RLATL NB>12%, NI=5

to productive assets NB>=9%,NI=4
NB>=6%,
NI=3
NB>=5%,
NI=2
NB<5%, NI=1
2 Profit/Sales Ratio RLTP RLTP=EBT/SELL

61
3 Ratio of Current
Assets/Current Debt
4 JP Debt Ratio/ Equity
5 Ratio Total RTATU RTATU=TA/TU AL, IJP, AT, AL, UL, RTATU>2,
Assets/Total Debt UJP, UL | Financial NI=5
TA=AL+IJP+AT+AL statements RTATU>=1.7,
TU=UL+UJP+UL NI=4
RTATU>=1.3,
Where: NI=3
TA=Total Assets RTATU>=1.0,
TU=Total Debt NI=2
AL=Current Assets RTATU<=1,
IJP=Long Term Investment NI=1
AT=Fixed Assets
AL=Current Assets
UL=Current Debt
UJP=Long Term Debt
UL=Other Debts
6 Operating RBOPO RBOPO=BO/PO | Financial RBPO<=0.5,
Cost/Operating BO=BL+BAU statements NI=5
Income Ratio PO=PPA+PNA RBPO>=0.65,
BL=BSA+BPA+BTD NI=4
RBPO>=0.85,
BAU=BPEG+BK+BHL+BPP NI=3
+BKEU+BPML+BPENY RBPO>=1,
+BOOM+BS NI=2
RBPO>1, NI=1
PPA=HAIR+JA+SM+PPAL
PNA=PSB+SI+PDE

Where:
BO=Operating Costs
PO=Operating Income

62
 BL=Direct Costs
BSA=Water Source Fee
BPA=Water Treatment Cost
BTD=Transmission &
Distribution Costs
BAU=General Administration
Fee
BPEG=Employee Costs
BK=Office Costs
BHL = Hublang Costs
BPP=Research &
Development Costs
BKEU=Finance Cost
BPML=Maintenance Cost
BPENY=Allowance Fee/Write-
off of Receivables
BUM=Miscellaneous General
Biaua
BS=Depreciation Expense
PPA=Water Sales Revenue
HAIR=Price of Water
JA=Administrative Services
SM=Meter Rental
PPAL=Other Water Sales
Income
PNA=Non-Water Revenue
PSB=New Connection
Revenue
SI=Installation Rental Income
PDE=Penalty Revenue
7 EBITDA RLOAP RLOAP=EBITDA/(AP+ | Financial RLOAP<0.5,
Ratio/Principal FLOWER) statements NI=5
Installment+Interest RLOAP>=0.5,

63
 EBITDA=PO-BOSP NI=4
RLOAP>=0.65,
PO=PPA+PNA NI=5
BOSP=BL+BAUSP RLOAP>=0.85,
NI=5
Where: RLOAP>=1,
EBITDA=Operating Profit NI=5
Before Depreciation
AP=Long Term Debt Principal
Installments due including
arrears
INTEREST=Long-term interest
due including arrears
PO=Operating Income
PPA=Water Sales Revenue
PNA=Non-Water Income
BOSP=Operating Costs
Before Depreciation
BL=Direct Costs
BAUSP=Administrative and
General Costs Before
Depreciation
8 Water Product/Sales RAPPA RAPPA=APRO/PPA | Financial RAPPA<=2.0,
Asset Ratio APRO=AL+IJP+AT statements NI=5
PPA=HAIR+JA+SM+PPAL RAPPA >2,
NI=4
Where: RAPPA >4,
APRO=Productive Assets NI=3
PPA=Water Sales Revenue RAPPA >6,
AL=Current Assets NI=2
IJP=Long Term Investment RAPPA >8,
AT=Fixed assets (Book Value) NI=1
does not include fixed assets

64
 in progress
HAIR=Price of Water
JA=Administrative Services
SM=Meter Rental
PPAL=Other Water Sales
Income

9 Receivables collection JWPP JWPP=PUS/JPH | Financial JWPP<=60,

period PUS=PUNA+PUNA+ statements NI=5
PRR+PPU JWPP >60,
JPH=PO/365 NI=4
PO=PPA+PNA JWPP<90,
NI=3
Where: JWPP>150,
PUS=Accounts Receivable NI=2
PUAIR=Water Receivables JWPP>180,
PINA=Non-Water Receivables NI=1
PRR=Doubtful Receivables
PPU=Allowance for Accounts
Receivable
JPH=Number of Sales per Day
PO=Operating Income

1 Billing Effectiveness E.P EP=RT/PA*100% | Financial EP>90%, NI=5

0 statements EP>85%, NI=4
Where: EP>80%, NI=3
RT=Receivable Account, the EP>75%, NI=2
amount of receipts from EP<=75%,
water sales invoices issued NI=1
during 1 financial year
PPA=Water Sales Revenue

65
 1 Service Coverage CP CP=JPT/JP*100% | Subscription If BUMD-AM
B. OPERATIONAL
Reports City
Where: CP>80%, NI=5
JPT=Number of Served CP>60%, NI=4
Population, the number of CP>40%, NI=3
people who have received CP>20%, NI=4
clean water in the CP<=20%,
administrative area of the NI=1
district/city that owns the
BUMD-AM. If Regency
Assumed number of people BUMD-AM
for each connection: CP>60%, NI=5
- Home Connection = 6 CP>45%, NI=4
people CP>30%, NI=3
- Public Faucet/Water CP>15%, NI=4
Hydrant = 100 people
CP<=15%,
- Can use other
appropriate and NI=1
accurate assumptions

JP=Number of Population in
the administrative area of the
district/city that owns the
BUMD-AM.
Bonus Value for Assess if there is an NBCP NBCP=CPTI-CPTL If BUMD-AM
Increased Service increase in service Where: City
Coverage coverage CPTI=Service Coverage This NBCP>12%,
Year NI=5
CPTL=Last Year Service NBCP>9%,
Coverage NI=4
NBCP>6%,
NI=3
NBCP >3%,
NI=4

66
 NBCP<=3%,
NI=1

If Regency
BUMD-AM
NBCP>8%,
NI=5
NBCP>6%,
NI=4
NBCP>4%,
NI=3
NBCP>2%,
NI=4
NBCP<=2%,
NI=1

2 Distribution Water Fulfillment of KWAA A=Meets drinking water KA=A, NI=3

Quality requirements set by the requirements KA=B, NI=2
competent authority B=Meets clean water KA=C, NI=1
regarding the quality of requirements
water consumed by the C=Does not meet
public requirements
3 Water Continuity Customers Get Full KONA KONA=24
Water Flow or not hours, NI=2
KONA<24
hours, NI=1
4 Productivity of PIPE PIPE=CAPPROD/ | Engineering PIPE>90%,
Natural Science COTTON*100% Report NI=4
Utilization PIPE>80%,
Where: NI=3
KAPROD = Operated PIPE>70%,
Production Capacity NI=2
COTTON=Installed Capacity PIPE<=70%,

67
 (Design Capacity) NI=1
5 Water Loss Rate TKA TKA=(VDIS-VSELL)/ VDIS | Engineering TKA<=20%,NI
VDIS*100% Report =4
VSELL | Financial TKA<=30%,
Where: statements NI=3
VDIS=Volume recorded in the TKA<=40%,
main meter installed in the NI=2
output pipe (outlet) of the TKA>40%,
water storage tank produced NI=1
to be distributed

VSELL=The volume of water

sold recorded on the
customer's water meter
through the billing account
TKA Bonus Value NBTKA NBTKA TKATL | See
Performance Report Attachment
Where: TKA Bonus
TKA=Water Loss Rate this Values
Year
TKATL=Last Year's Water
Loss Rate
6 Water Meter The number of customer PMA PMA=JPMT/JPEL*100% JPMT | Technical PMA>20% -
Information water meter installations Where: Report PMA<25%,
in a year does not JPMT = Number of Customers JPEL | Subscription NI=3
include new water whose Water Meters are Reports PMA>10%,
meters checked in a year NI=2
JPEL= Total Number of PMA<10% or
Customers PMA>25%,
NI=1
7 New Connection Speed of providing KSB | Subscription KSB<=6
Speed service to customers in Reports monkey days,
installing new NI=2

68
 connections. The signing KSB>6
of the new connection working days,
contract between BUMD- NI=1
AM and the applicant
has begun
8 Handling BUMD-AM's ability to KPP KPP=JPS/JPM*100 | Customer KPP>=90%,
complaints/month resolve customer Complaint Report NI=2
complaints Where: KPP<90%,
JPS=Number of Completed NI=1
Complaints
JPM=Number of Incoming
Complaints
9 Ease of Service Availability of supporting KPEL KPEL=Availabl
facilities to provide easy e, NI=2
services for making KEPL<>Availa
payments and ble, NI=1
complaints
1 Employee Ratio/ 1000 Describes the level of lesson RPP=JPEG/(JP/1000) JPEG | Personnel If BUMD-AM
0 Plg efficiency and plan Report City:
effectiveness of using Where : RPP<=5, NI=5
labor to provide services JPEG= The number of active JP | Subscription RPP<=7, NI=4
to customers employees at the end of the Reports RPP<=9, NI=3
financial year consists of RPP<=10,
BUMD-AM, Honorary, NI=2
Seconded and other RPP>10, NI=1
employees who are active in
BUMD-AM If District
BUMD-AM:
JP=Number of active RPP<=8, NI=5
connection customers at the RPP<=11,
end of the year NI=4
RPP<=15,
NI=3

69
 RPP<=18,
NI=2
RPP>18, NI=1
1 Long Term Plan To see to what extent CPR CPR { RJP=A,NI=4
ADMINISTRATIO
C.

(Corplan) BUMD-AM's long-term A=Fully Guided | RJP=B,NI=3

planning is guided B=Partially Guided | RJP=C,NI=2
C=Has Not Been Guided | RJP=D,NI=1
D=Doesn't Have}

2 Org Plan & Job Implementation of the ROUT ROUT { ROUT=A,NI=4

Description Organizational Plan and A=Fully Guided | ROUT=B,NI=3
Job Description to the B=Partially Guided | ROUT=C,NI=2
extent that it is guided C=Has Not Been Guided | ROUT=D,NI=1
by the Organizational D=Doesn't Have}
Plan and Job Description,
organizational structure
and organizational work
procedures owned by
BUMD-AM and approved
by the Regional Head

3 Standard Operating Implementation of POPS POPS { POPS=A,NI=4

Procedures standard operating A=Fully Guided | POPS=B,NI=3
procedures to the extent B=Partially Guided | POPS=C,NI=2
that they are guided. C=Has Not Been Guided | POPS=D,NI=1
Standard Operating D=Doesn't Have}
Procedures are
guidelines (manuals)
that include procedures
for handling company
operations

70
4 Actual Images Actual To see to what extent ABD ABD { ABD=A,NI=4
real drawings are A=Fully Guided | ABD=B,NI=3
provided and guided as B=Partially Guided | ABD=C,NI=2
a management tool. C=Has Not Been Guided | ABD=D,NI=1
Real Drawings (As Built D=Doesn't Have}
Drawings) for the entire
distribution system are a
measure of good
implementation of
production and
distribution
management.

5 Employee Implementation of the PPPKK PPPKK { PPPKK=A,NI=4

Performance Employee Job Appraisal A=Fully Guided | PPPKK=B,NI=3
Appraisal Guidelines Guidelines Employee Job B=Partially Guided | PPPKK=C,NI=2
Appraisal Guidelines are C=Has Not Been Guided | PPPKK=D,NI=1
a tool/media for D=Doesn't Have}
assessing the work
performance of
company employees

6 RKAP Company Work Plan and RKAP RKAP { RKAP=A,NI=4

Budget A=Fully Guided | RKAP=B,NI=3
The implementation of B=Partially Guided | RKAP=C,NI=2
the RKAP is as far as it is C=Has Not Been Guided | RAKP=D,NI=1
guided D=Doesn't Have}
RAKP is an annual
elaboration of the Long
Term Plan which
includes RKAP
7 Orderly Internal Carrying out regular TLI TLI {A=Made On Time | TLI=A, NI=2

71
 Reporting reporting in the fields of B=Not on time } TLI=B, NI=1
finance, operations and
administration from
implementers to
decision makers
8 Orderly External Submission of periodic TLE TLE {A=Made On Time | TLE=A, NI=2
Reports external party reports B=Not on time } TLE=B, NI=1
on time, reports in the
form of:
- Annual Financial
Report to the
Supervisory Body
- Reports for Tax
Purposes
9 Independent Auditor's Independent examiner's OAI OAI {A=Unqualified | B=Fair OAI=A, NI=4
Opinion opinion regarding the with Exceptions | C=Does Not OAI=B, NI=3
fairness of the financial Give Opinion | OAI=C, NI=2
statements presented D=Unreasonable opinion} OAI=D, NI=1
by management
1 Follow-up on Results of the TLHP TLHP {A=No Findings | TLHP=A, NI=4
0 Examination Results achievement of follow- Followed up, all completed | TLHP=B, NI=3
up efforts on Followed up, partially TLHP=C, NI=2
findings/recommendatio completed | Not Followed TLHP=D, NI=1
ns by the Examining Up }
Agency

Attachment of TKA Bonus Value

Foreign Foreign NBTK Foreign Foreign NBTK Foreign Foreign NBTKA

Workers Last Workers This A Workers Last Workers This A Workers Workers
Year (%) Year (%) Year (%) Year (%) Last Year This Year
(%) (%)
>60 <=20 10 >60 >25-27 4 >60 >30-40 2

72
 >60 >20-21 9 >50-60 >24-25 4 >50-60 >27-30 2
>50-60 <=20 9 >40-50 >23-24 4 >40-50 >25-27 2
>60 >21-22 8 >30-40 >22-23 4 >30-40 >24-25 2
>50-60 >20-21 8 >27-30 >21-22 4 >27-30 >23-24 2
>40-50 <=20 8 >24-27 >20-21 4 >24-27 >22-23 2
>60 >22-23 7 >23-24 >=20 4 >23-24 >21-22 2
>50-60 >21-22 7 >60 >27-30 3 >22-23 >20-21 2
>40-50 >20-21 7 >50-60 >25-27 3 >21-22 >=20 2
>30-40 >=20 7 >40-50 >24-25 3 >60 >40-50 1
>60 >23-24 6 >30-40 >23-24 3 >50-60 >30-40 1
>50-60 >22-23 6 >27-30 >22-23 3 >40-50 >27-30 1
>40-50 >21-22 6 >24-27 >21-22 3 >30-40 >25-27 1
>30-40 >20-21 6 >23-24 >20-21 3 >27-30 >24-25 1
>27-30 >=20 6 >22-23 >=20 3 >24-27 >23-24 1
>60 >24-25 5 >23-24 >22-23 1
>50-60 >23-24 5 >22-23 >21-22 1
>40-50 >22-23 5 >21-22 >20-21 1
>30-40 >21-22 5 <=21 >=20 1
>27-30 >20-21 5
>24-27 >=20 5

Classification of BUMD-AM Success Levels

A. PERFORMANCE VALUE
10

∑ Nilai Indikator
FINANCIAL ASPECTS = i=1
x 45
60
10

OPERATIONAL ASPECTS = i=1

∑ Nilai Indikator
x 40
47

73
 10

∑ Nilai Indikator
ADMINISTRATIVE ASPECT = i=1
x 15
36

PERFORMANCE VALUE = FINANCIAL ASPECTS + OPERATIONAL ASPECTS + ADMINISTRATIVE ASPECTS

B. PERFORMANCE CLASSIFICATION

PERFORMANCE PERFORMANCE
VALUE
>75 VERY WELL
>60 – 75 GOOD
>45 - 60 ENOUGH
>30 – 45 NOT ENOUGH
<=30 NOT GOOD

Appendix
Proposed IUWASH Performance Indicators
PROPOSED INDICATORS FROM UNDERSTANDI SYMBO FORMULA VARIABLE | INDICATOR
IUWASH NG LS DATA VALUE (NI)
SOURCE

74
 1 Return on Assets ROA is a tool ROA ROA=LBAP/JA LBAP, JA |
FINANCE
that has the Financial
function of Where: statements
assessing the LBAP = Net Profit After Tax
ability of JA=Total Assets
company assets
to gain profits

2 FCR Tariff Drinking water FCR FCCR=TR/BD TR, BD |

tariffs are set by Financial
BUMD-AM to Where: i statements
cover all TR=Average rate per m 3

operational BD=Basic Cost per m3

costs
3 Number of JHPU JHPU=PU/JP
Receivables
Collection Days Where:
PU = Accounts Receivable
JP = Number of Sales per Day

4 Increased Water PPVA PPVA=(VATI-VATL)/VATL*100%

SERVICE

Volume Sales
Where:
VATI=Volume of Water Sold This
Period (m 3 )
VATL=Volume of Water Sold Last
Period (m 3 )

75
 5 Effective Volume of VERD VERD=VR/DR*FHM*86.4

AL
OPERATION
Distribution
Reservoirs Where:
VR = Reservoir Volume
DR=Average Discharge
FHM=Maximum Daily Factor
6 Production Water RKAPR RKAPR=VPMS/TVP*100%
Quality Ratio
Where:
VPMS = Production Volume Fulfills
Minister of Health Regulation
Requirements (m3)
TVP=Total Production Volume (m 3 )
7 Implementation of SOUP SOP=JSOP/TSOP*100%
HR &

S
PROCEDURE

SOPs
Where:
JSOP=Number of SOPs applied
TSOP=Total SOP

8 Application of PSI PSI=JSIP/JSI*100%

Information Systems
Where:
JSIP = Number of Information
Systems implemented
JSI = Number of Information Systems

76
 Attachment
PROPOSED DATA INPUT SCHEME by BUMD-AM
The following is a revised data input scheme which includes who is responsible
for each validation stage and the validation methods used:

1. Data Collection by BUMD-AM

Data Source: Data was collected from various departments within BUMD-AM,
including finance, operations and services, technical and human resources
departments.

Data Type: Performance Indicators, Context Indicators, Variables to be

determined and agreed upon later.

2. Data Pre-validation by BUMD-AM

Carried out by the BUMD-AM data entry team to ensure all necessary data
has been collected. The BUMD-AM data entry team ensures the data is in the
correct format (for example, numbers, text, dates, etc.).

3. Inputting Data into the System by BUMD-AM

Data is entered by the BUMD-AM data entry team through a specially

designed user interface in the form of an online application where the system
automatically validates the data entered to ensure (1) Data conforms to
established standards (for example, numbers within a reasonable range,
appropriate date format Correct). (2) All fields must be filled in or completed.

4. Manual Verification by BUMD-AM Verification Team

Validated data is automatically checked by the BUMD-AM verification team

consisting of competent personnel in each department. Data is verified with
other data sources to ensure there are no discrepancies.

5. Data Storage by BUMD-AM

Data that has been validated is stored in a secure centralized database by the
BUMD-AM IT team through an application built, carrying out regular data
backups by the BUMD-AM IT team to avoid data loss.

6. Monitoring and Audit by BPKP

Periodic Audit: Data that has been stored is audited by the Financial and
Development Supervisory Agency (BPKP) periodically to ensure integrity and
accuracy.

Error Report: Any errors or discrepancies discovered during the audit are
reported and followed up by the BUMD-AM team.

7. Reporting and Analysis by BUMD-AM

77
 The system generates automatic reports based on validated data. Data is
analyzed by the BUMD-AM analysis team to produce insights and
recommendations that are useful for decision making.

Data Input and Validation Scheme Flow Diagram

Inputting data into

Data Collected by Pre-validation by
the system by the
BUMD-AM from the BUMD-AM Data
BUMD-AM Data
sections Entry Team
Entry Team

Automatic Manual Verification

Data Backup by
Validation by the by BUMD-AM
BUMD-AM IT TEAM
System Verification Team

Reporting and
Monitoring and
Analysis by BUMD-
Audit by BPKP
AM Analyst Team

Data Validation Method

1. Automatic Validation:

The system automatically checks whether the data meets predetermined

rules, such as correct formatting and required fields. The system checks
whether the data complies with applicable business logic, for example there
are no negative numbers for the number of customers.

2. Manual Verification:

The verification team checks supporting documents to ensure the data

entered is correct. Data is verified with data from other sources to ensure
accuracy, for example matching financial statements with bank statements.

3. Audit by BPKP:

BPKP conducts audits to ensure that BUMD-AM complies with all applicable
regulations and standards. Audit to ensure that financial, operational, service
and HR data are accurate and reflect actual conditions.

78