DO - 158 - s2022 Data Governance Program
DO - 158 - s2022 Data Governance Program
DO - 158 - s2022 Data Governance Program
13 bPWR
Republic of the Philippines
0'1. 11, '2() '2.2..
DEPARTMENT OF PUBLIC WORKS AND HIGHWAYS
OFFICE OF THE SECRETARY
. Manila
JUL 08 2022
DEPARTMENT ORDER ) SUBJECT: Implementation of a Data Governance
Program
NO. 158 l
)
Series of 2022 ~ ~\ 11 hb2.'2.
I
In recognition that data is a valuable asset and quality data is critical in meeting the mandate of
the Department, and in the interest of improving and ensuring data quality, the Department-wide
Data Governance Program shall establish, implement, operate, monitor, review, maintain and
improve a Data Governance framework to ensure that appropriate controls are applied to data,
and that the data is accurately collected, used, and reported in line with its legislative and other
compliance obligations.
Data shall be categorized according to subject areas. It shall be managed and protected as a
Department resource. It shall be named and defined consistently across the Department to be
readily accessible to all, except where restrictions can be justified. It shall not be collected
redundantly without justification, it shall be assigned to an organizational unit "data steward" and
it shall be created and maintained as close to the source as feasible. This policy will be
implemented through a Data Governance Program which was prepared and developed jointly by
the Data Governance Program Office (DGPO) and the Data Governance Technical Working Group
(TWG) of Information Management Service and can be downloaded at the DPWH Intranet
(http://dpwhweb/DataGovernanceProgram/DPWHDataGovernanceProqram .pdD, for easy
reference.
The aforementioned Program outlines the goals, structure, participants, data owners, and
responsibilities involved over data assets. This program applies to all data users, processes and
systems that collect, analyze, use, disseminate, and store data. It guides the Department in
handling data as an enterprise asset and ensuring sound data management practices through
partnerships with the different data stakeholders of the Department. This document should be
disseminated throughout the Department and to new employees during the employee orientation
training.
All data assets shall be clearly identified and maintained. All data assets shall b~ assigned
a dedicated owner and steward.
Data Collection should be obtained only for a specific purpose. It should be adequate,
relevant, accurate, up to date, and should not be held for any longer than necessary. It
must be processed following the rights of data subjects under the RA 10173, Data
Privacy Act of 2012, applicable Government mandates, and Department Policies.
Da'ta:shaO be collected once and must be used by many to minimize the cost of data
collection and avoid duplication of efforts.
Data should be validated to ensure that the finished data meets a set of quality
standards.
For sharing within agencies, a Data Sharing Agreement shall be signed by both parties
and properly reviewed by the Department's Legal Service to ensure compliance with
applicable Philippine Government mandates, legislation, and Department Policies.
For the data sharing workflow, refer to Department Order No. 144. Series of 2018.
Disclosure of data to authorized parties in line with the RA 10173, Data Privacy. Act of
2012, the Freedom of Information (FOI) Executive Order No.2, 2016, and other
applicable legislation, Philippine government mandates, and Department policies shall
be ensured.
Per Department Memorandum Circular CDMe) No. 47. Series of 2012 and DMC No. 16.
Series of 2014, data shall be retained and disposed of lawfully and appropriately.
Appropriate controls shall be applied to ensure that data remains available to bona fide
persons as per applicable laws, rules and regulations, and Department's policies.
D.O. No. \Se ,·Serr~.sof 2022
Implementation of a Data GovernanCe Program
Page 3 of 5
The Department shall have a Business Continuity and Disaster Recovery Plan to ensure
resilience and risk management. The purpose of the business continuity policy is to
organize what is required to keep the Department's ICT Infrastructure running on
normal business days as well as during emergencies.
Appropriate controls shall be applied to ensure that data remains complete and
accurate.
Data Governance involves the processes associated with the management of data as an asset.
Data Governance ensures that data can be trusted and that people can be made accountable for
any adverse event that happens because of low data quality.
To ensure the quality and value of the Department's data assets, the partners responsible for
realizing these are the following:
a) Secretary
The Secretary has ultimate authority and re:sponsibility for the data governance program
ensuring that data governance efforts address all relevant and mission-critical needs of the
Department.
The Performance Governance System (PGS) Committee shall serve as the Data Governance
Steering Committee (DGSC) and review Data Governance policies to improve the quality,
accuracy, and integrity of data.
The Chief Information Officer (CIO) is responsible for the development of the Data Governance
Program and ensure it is published and communicated to all relevant employees and relevant
D.O. No.j5B.:, Serie's of 2022
Implementation of a Data Governance 'program
Page 4 of 5
external parties. The CIO is the Undersecretary of the Information Management Service who
shall also serve on the DGSC.
The Data Administration Section (DAS) of the IMS is designated as the Data Governance
Program Office (DGPO) responsible for running the Data Governance Program including
documentation, communication, and enforcement. The Section Chief of the DAS serves as the
Chief Data Steward.
The Business Data Stewards, being the data owners and having the understanding of what
data is held by the Department, shall provide the business knowledge of what data needs to
be collected and stored, applicable business rules to ensure data quality, and who should have
access to which data. They shall be responsible for ensuring the overall quality of data in the
Department. Some categories of data have both Primary and Secondary Business Data
Stewards to ensure coordination and collaboration for data used across organizational
boundaries.
The primary role of the Technical Data Stewards is to provide technical expertise in support of
the Data Governance efforts concerning applications and application impact analysis for
proposed changes and data quality issues. Responding to requests for assistance from the
Data Governance Program Office promptly shall be part of their regular duties. These
individuals are led by the Business Analysts (BA).
g) Data Users
The Data Users are all personnel of the Department collecting, updating, and utilizing the Data.
A Data Governance Guidebook, which emphasizes the above roles, shall be made available by
the Data Governance Program Office and shall be posted on the Department's intranet website.
Special Orders shall be issued for the assignment of personnel for these responsibilities along
with the accountable office/entity by data domain/category.
This Order supersedes Department Order No. 20, Series of 2016, and shall take effect
immediately.
11.1.1 EMS/ETC/MNP/RBC
Department of Public Works and Highways
Office of the Secretary
Version 1.0
This document outlines the purpose, structure, goals, participants, and responsibilities of the
data governance program of the Department of Public Works and Highways (DPWH). This
document should be disseminated throughout the Department and given to new employees
during the orientation training. It should be updated regularly whenever it is necessary.
Prepared by:
Data Governance Program Office and Data Governance Technical Working Group
Information Management Service
Page 2 of 32
Table of Contents
1 Introduction............................................................................................................... 5
1.1 Data Governance Definition .................................................................................. 5
1.2 Mission, Vision, Goals, and Success Measures......................................................... 5
1.2.1 Mission ......................................................................................................... 6
1.2.2 Vision ........................................................................................................... 6
1.2.3 Goals ............................................................................................................ 6
1.2.4 Success Measures .......................................................................................... 6
2 Data Governance Framework ...................................................................................... 8
3 Data Categories ......................................................................................................... 9
4 Data Governance Guidelines....................................................................................... 12
4.1 Data Inventory and Ownership.............................................................................12
4.2 Data Collection ...................................................................................................12
4.3 Data Validation ...................................................................................................12
4.4 Data Sharing ......................................................................................................12
4.5 Data Integration .................................................................................................12
4.6 Data Security......................................................................................................12
4.7 Data Privacy .......................................................................................................13
4.8 Data Availability, Retention, and Disposal ..............................................................13
4.9 Business Continuity and Disaster Recovery ............................................................13
4.10 Data Integrity ...................................................................................................13
4.11 Data Compliance ...............................................................................................13
5 Data Governance Accountability ................................................................................. 14
5.1 Data Governance Roles .......................................................................................14
5.2 Data Governance Organizational Chart..................................................................16
5.3 Decision Rights ...................................................................................................17
6 Data Governance Program Products/Services............................................................... 18
6.1 Information Repository ........................................................................................18
6.2 Enterprise Data Glossary .....................................................................................18
6.3 IT Glossary.........................................................................................................19
6.4 Data Inventory ...................................................................................................19
6.5 Data Dictionary ...................................................................................................20
6.6 GIS Data Dictionary ............................................................................................21
6.7 DPWH Enterprise Data Architecture ......................................................................23
6.8 Training and Awareness ......................................................................................23
7 Data Governance Policies and Procedures ................................................................... 24
7.1 Definition of Terms in the Enterprise Data Glossary ...............................................24
Page 3 of 32
7.2 Data Assets Renaming in Primary Application Systems ...........................................25
7.3 Effectivity Dates in the Creation and Renaming of DEO Names ...............................25
7.4 Data Recovery ....................................................................................................27
7.5 Data Issue Resolution .........................................................................................28
8 Definition of Terms.................................................................................................... 30
9 References ............................................................................................................... 31
10 Appendices ............................................................................................................. 32
10.1. Figures ........................................................................................................32
10.2. Tables .........................................................................................................32
Page 4 of 32
1 Introduction
In accordance with the Department Order No. 20, Series of 2016” Implementation of a Data
Governance Program”, the Data Governance Program Technical Working Group and the Data
Governance Program Office (DGPO) developed the Data Governance Program. This program
applies to all data users, processes, and systems that collect, analyze, use, disseminate, and
store data. It guides the Department in handling data as an enterprise asset and ensuring
sound data management.
“Organizations that do not understand the overwhelming importance of managing data and
information as tangible assets in the new economy will not survive”.1 Tom Peters, 2001
Data Governance is the exercise of decision-making and authority for data-related matters.
It is a system of decision rights and accountabilities for information-related processes,
executed according to agreed-upon models which describe who can take what actions with
what information, and when, under what circumstances, using what methods.2
Data Governance includes the people, processes, and technologies needed to manage and
protect the organization’s data assets to guarantee generally understandable, correct,
complete, trustworthy, secure, and discoverable corporate data.
Data governance is important to ensure quality data which is critical for the following reasons:
Accurate and timely information to manage services and accountability.
Determine and manage service and mandate effectiveness.
To prioritize and ensure the best use of resources.
Report to management, auditors, oversight agencies, and the public, who will make
judgments about the Department’s performance and governance.
Data governance ensures that data can be trusted and that people can be made accountable
for any adverse event that happens because of low data quality. Through data governance,
organizations are looking to exercise positive control over the processes and methods used
by their data stewards and data custodians to handle data.
Understanding what data governance is not can help focus on what it is.
Data governance is NOT terms definition, database design, data warehousing, project
management, data cleansing or extract, transform, and load data. While each of these is
affected by or related to the data governance program, data governance addresses more than
these disciplines and each of these areas has facets beyond data governance, such as
technological and architectural solutions.
1 The DAMA Guide to Data Management Body of Knowledge, 1st Edition, 2010
2 Data Stewardship: An Actionable Guide to effective Data Management and Data Governance, 2014
Page 5 of 32
1.2.1 Mission
To institutionalize Data Governance by ensuring the data quality, security, and privacy
across the Department.
1.2.2 Vision
By 2030, Department data is consistent, secured, accurate, and readily available across
the Department.
1.2.3 Goals
The ability to measure success will be crucial to maturing data governance. Articulating
success will ensure continued commitment from stakeholders at all levels. Success
measures are best described by statements of quantifiable business value and will be
determined by the Data Governance Steering Committee. Metrics can help get an
organization aligned with a set of shared goals and can also provide an opportunity for
engagement with stakeholders.
There are two (2) distinct categories to measure Data Governance Program performance:
Page 6 of 32
- Data Protection
Success will be measured over ten years, with specific deliverables set for each Goal.
2022
2023
2024
2025
2026
2027
2028
2029
2030
No. Goals (2030)
1 Provide an 100%
environment Awareness
of
that promotes a
Enterprise
common
METRICS
application Developed Developed Developed Developed Developed Developed Developed Developed Developed
development Performance PGS Apps PGS Apps PGS Apps PGS Apps PGS Apps PGS Apps PGS Apps PGS Apps
responsive to Governance
changing System
business needs. (PGS) Apps
B B B B B B B B B
4 Reduce Publish Establish a Awareness 100%
redundancy to DPWH Platform of Data Awareness
Data for Inventory of Data
minimize the
METRICS
activities to Policy on
guarantee the Data
authenticity and Integration
accuracy of and
Validation
information.
B B A
7 Establish Establish Revisit Revisit Revisit Revisit Revisit
business the DPWH DPWH DPWH DPWH DPWH DPWH
Business Business Business Business Business Business
continuity
METRICS
Page 7 of 32
2 Data Governance Framework
According to the Data Governance Institute (DGI), Data Governance is a practical and actionable
framework to help data stakeholders across any organization identify and meet their information needs.
To operate the Data Governance Program sustainably, the Department will adopt the Data Governance
Institute (DGI) Framework which provides a comprehensive process for establishing and sustaining a
data governance initiative. At a high level, the Data Governance Framework describes how the Data
Governance Program Office (DGPO) proposes to manage the Department’s data.
The Data Governance Institute recommends ten (10) universal components of data governance that
organizations should include to build a successful data governance foundation following the “who,
what, when, why, and how” model and broken into three (3) main areas.3
3 http://www.datagovernance.com/fwk_dgi_data_governance_framework_components.html
Page 8 of 32
Area 1: Rules and Rules of Engagement
These describe rules in terms of policies, requirements, standards, accountabilities, and
controls. Rules of engagement then describe how different groups will share and delegate
responsibilities for establishing these rules and executing them.
7. Data Stakeholders
8. A Data Governance Office
9. Data Stewards
Area 3: Processes
These are the processes, methods, and procedures for creating and maintaining a sustained
effort in data governance.
This framework will help the Department move toward the goal of implementing data
governance and will help to identify potential organizational models–characteristics for
effectively institutionalizing the management of Department’s data resources.
3 Data Categories
Data shall be categorized according to Department’s Subject Areas. It shall be managed and
protected as a Department resource. It shall be named and defined consistently across the
Department to be readily accessible to all, except where restrictions can be justified. It shall
not be maintained redundantly without justification. It shall be assigned to an organizational
unit “data steward” and it shall be created and maintained as close to the source as feasible.
The Subject Areas are presented in the diagram shown in the DPWH Enterprise Data
Architecture.
Page 9 of 32
Figure 3: DPWH Enterprise Data Architecture-Global Data Categories
3.1 Organization
This contains the subject entity representing the administrative and functional structure of a
private sector business or other governmental agency associated with the Department, and
the Department itself, as well as related participant entities including a person.
3.2 Location
This contains a view of entities representing both real-world and mapped (geographical)
positions and sites. This category is a generic type for point, line, and area features, including
the Road Network (made up of points and lines).
3.3 Plan
This is a formulation and means to resolve a gap between an existing situation and needs for
the future, as related to goals, objectives, and strategy. Also included are reference entities
to indicate both specific needs and the degree of achievement of requirements.
Page 10 of 32
3.4 Program
This category is closely related to Plan and includes the subject entity which is an allocation
and sequencing of solutions and resources. It also includes related entities for assessment
and feasibility as used for the definition of programs and projects.
3.5 Infrastructure
This represents actual, ‘on the ground’ objects such as structures, pavement, fixtures, and
traffic events with entities to help locate and position them, by links to related entities in the
Location category.
3.6 Budget
This represents the level of expenditures at which an organization can perform its basic
function, and related entities including budget agency, appropriation, and allotment, with
subtypes of cash and fund.
3.7 Finance
This focuses on account for recording classified financial transactions, as well as different
types of transactions. Also included are related entities representing books of original and final
entry and financial statements.
3.8 Staff
This represents Employee’s Record which is the record of facts relevant to a specific employee
of the Department, and related entities representing compensation, performance, position,
and training.
3.9 Inventory
This represents the subject entity of Inventory Item, which is a member of a set of physical
resources that contribute to the net worth of the Department. Related entities represent
events of requisition, assignment, and maintenance.
3.10 Contract
This is organized around the subject entity, which is an enforceable agreement between two
or more participants, and the closely related Bid entity, and their related entities representing
eligibility to bid and assessment of work.
Page 11 of 32
4 Data Governance Guidelines
For a successful implementation of the Data Governance Program, the following shall be
observed:
All data assets shall be clearly identified and maintained. All data assets shall be
assigned a dedicated owner and steward.
Data Collection should be obtained only for a specific purpose. It should be adequate,
relevant, accurate, up to date, and should not be held for any longer than necessary.
It must be processed following the rights of data subjects under the RA 10173, Data
Privacy Act of 2012, applicable Government mandates, and Department Policies.
Data shall be collected once and must be used by many to minimize the cost of data
collection and avoid duplication of efforts.
Data should be validated to ensure that the finished data meets a set of quality
standards.
For sharing within agencies, a Data Sharing Agreement shall be signed by both
parties and properly reviewed by the Department’s Legal Service to ensure
compliance with applicable Philippine Government mandates, legislation, and
Department Policies.
For the data sharing workflow, refer to Department Order No. 144, Series of 2018.
Data shall remain protected and secured following the requirements of applicable
legislation, Philippine government mandates, and Department policies.
Page 12 of 32
4.7 Data Privacy
Disclosure of data to authorized parties in line with the RA 10173, Data Privacy Act
of 2012, the Freedom of Information (FOI) Executive Order No. 2, 2016, and other
applicable legislation, Philippine government mandates, and Department policies
shall be ensured.
Per Department Memorandum Circular (DMC) No. 47, Series of 2012 and DMC No.
16, Series of 2014, data shall be retained and disposed of lawfully and appropriately.
Appropriate controls shall be applied to ensure that data remains available to bona
fide persons as per applicable laws, rules and regulations, and Department’s policies.
The Department shall have a Business Continuity and Disaster Recovery Plan to
ensure resilience and risk management. The purpose of the business continuity policy
is to organize what is required to keep the Department’s ICT Infrastructure running
on normal business days as well as during emergencies.
Appropriate controls shall be applied to ensure that data remains complete and
accurate.
Data shall remain compliant with the Department’s various obligations including
those specified within relevant legislation Philippine government mandates and
Department’s policies and procedures, as well as other obligations such as
contractual or Memorandum of Agreement requirements.
Page 13 of 32
5 Data Governance Accountability
Data Governance involves the processes associated with the management of data as an asset.
Data Governance ensures that data can be trusted and that people can be made accountable
for any adverse event that happens because of low data quality.
To ensure the quality and value of the Department’s data assets, the partners responsible for
realizing these are the following:
a) Secretary
The Secretary has ultimate authority and responsibility for the data governance program
ensuring that data governance efforts address all relevant and mission-critical needs of the
Department.
The Performance Governance System (PGS) Committee shall serve as the Data Governance
Steering Committee (DGSC) and review Data Governance policies to improve the quality,
accuracy, and integrity of data. 4
Articulate the mission and strategic goals of the data governance program.
Secure the support, resources, and cooperation needed to operate the program.
Resolve problems and unresolved issues that are escalated from the Data
Governance Program Office.
The Chief Information Officer (CIO) is responsible for the development of the Data
Governance Program and ensuring it is published and communicated to all relevant
employees and relevant external parties. The CIO is the Undersecretary for the Information
Management Service who shall also serve as the Chairperson of the DGSC.
The Data Administration Section (DAS) of the IMS is designated as the Data Governance
Program Office (DGPO) responsible for running the Data Governance Program including
documentation, communication, and enforcement. The Section Chief of the DAS serves as
the Chief Data Steward.
4
Department Order No. 06 Series of 2018: Alignment of the Reform Institutionalization and Management
Support Systems Steering Committee with Performance Governance System, Designation and Roles of Project
Managers, and Responsibility of Head of Offices
Page 14 of 32
Disseminates the Data Governance Program of the Department to include its
mission, vision, goals, strategy, processes, and value.
Creates and makes available education curricula and training delivery programs to
support Data Governance, including training for Data Stewards, Application Project
Managers, Application Development Team, and IT support staff.
Enforces data-related policies and procedures, and escalates where necessary. This
would include data analysis on compliance with business rules and quality
standards.
Manages logs to document risks and issues.
Documents, publishes and maintains data-related policies, procedures, and
standards.
Maintains and publishes the Data Architecture and Data Glossary.
The Business Data Stewards, being the data owners and having the understanding of what
data is held by the Department, shall provide the business knowledge of what data needs
to be collected and stored, applicable business rules to ensure data quality, and who should
have access to which data. They shall be responsible for ensuring the overall quality of data
in the Department. Some categories of data have both Primary and Secondary Business
Data Stewards to ensure coordination and collaboration for data used across organizational
boundaries.
The primary role of the Technical Data Stewards is to provide technical expertise in support
of the Data Governance efforts concerning applications and application impact analysis for
proposed changes and data quality issues. Responding to requests for assistance from the
Data Governance Program Office promptly shall be part of their regular duties. These
individuals are led by the Business Analysts (BA).
Page 15 of 32
Provide application impact analysis for proposed changes and data quality issues.
Respond to requests for assistance from the Data Governance Program promptly as
part of their regular duties.
Secure and safeguard the Department’s database structure and content.
g) Data Users
The Data Users are all personnel of the Department collecting, updating, and utilizing the
Data.
Secretary
Page 16 of 32
5.3 Decision Rights
A responsibility assignment matrix is a simple roles and responsibilities matrix. The persons
involved in a project activity will be Responsible, Accountable, Consulted, or Informed (RACI)
for the relevant task, milestone, or decision, according to a RACI chart.
Sponsorship A R R C C C I
and Charter
Data A C R R A A I
Ownership
Policies and A C A R A A I
Standards
Business Rules I I A R C A I
and Guidelines
Data Quality I I R R A A I
Issues, Reports
and Metrics
Data Models I I A R C C I
Data I I A R C C I
Dictionaries
Processes and I I R R A A I
Procedures
A RACI chart indicates the roles assigned to different team members involved with each task. A detailed
description of each role is as follows:
Responsible: Those assigned the role of responsible are actively involved in completing a
specific task. At a minimum, one team member should be responsible for each task, but you
may have more than one, depending on the project scope. That said, there should never be
more people assigned to this role than needed.
Accountable: The member assigned to the accountable role is responsible for signing off on
the task, i.e., approving its completion. It is almost always best that this is a single person.
This role typically falls on the project manager, but it might be assigned to someone else.
Consulted: Consulted team members may be leveraged for their expertise, or contribute in
other ways, for example, when it comes to verifying information or reviewing the work product
and how it fits in with the larger scope of the overall project. There is no minimum or a
maximum number of members who may fall into the consulted category; need determines this
designation.
5 https://www.workfront.com/project-management/life-cycle/planning/raci-chart
Page 17 of 32
6 Data Governance Program Products/Services
The following lists the Data Governance program products and/or services that the
Department will need:
The Data Administration Section maintains detailed records of all the Department’s
enterprise data in standard documents such as Process Models, Data Models, Enterprise
Data Glossary, and Enterprise Architecture, which form the “Information Repository”. This
includes details of every item of data, and which of the software applications users make
use of which data.
The Data Administration Section will maintain and use most of the detailed information
held in the Information Repository, and interpret and explain this information to the Data
Stewards whenever required.
The part of the Information Repository of most direct relevance to the Data Stewards is
the Enterprise Glossary. This glossary will be a summary of standard business terms to be
used throughout the Department, presented in terminology understandable by business
data users rather than computer specialists.
A business term is defined as a word or phrase used to identify a process, event, or thing
of importance to the Department.
All Data Stewards have an understanding of what data is held by the Department and
understand in principle why each different type of data is held, who needs to use the data,
and how it is used.
The Data Stewards must be familiar with which types of data are in each of these
categories.
The Data Administration Section maintains and updates the Enterprise Data Glossary at least
once a year or when a new application is developed and implemented in the Department. It
contains definitive descriptions of common business terms and data items used in major
processes and applications in the Department. Business terms are common words, phrases,
or vocabularies used by the Department in its day-to-day operation and/or in the conduct of
its business.
Page 18 of 32
6.3 IT Glossary
This consists of common technical words, phrases, or vocabularies used by the Department
in its day-to-day operation and/or in the conduct of its business.
A data inventory is a list of datasets with metadata that describes their contents, source,
licensing, and other useful information.
Improve data governance – the process of compiling and managing a data inventory
can help the user to take stock of the data that the Department is managing. Creating
an inventory is often the first step in improving data governance. The inventory can
help to identify duplicates, be used to improve best practices, and ensure that there
are clear roles and responsibilities associated with managing data as an asset.
Create a legal record – an inventory can provide a legal record of the data that the
Department manages. The Department may have to do this for compliance reasons,
such as maintaining a data asset register for the recently introduced Data Privacy Act
of 2012 or maintaining a list of third-party datasets the Department accesses and the
licensing and data sharing agreements that govern their use.6
The Data Administration Section (DAS) has established the DPWH Data Inventory based on
the Department’s Application Systems and complies with the Data Privacy Act of 2012.
Maintenance of the data inventory will be performed once new applications are to be
developed.
6 https://www.researchgate.net/publication/327631764_How_to_create_a_data_inventory#pf3
Page 19 of 32
Figure 6: DPWH Data Inventory
The Data Dictionary is part of the overall Information Repository. The Data Dictionary contains
organizational metadata, including data definitions, relationships, user privileges, etc.
For each data item, the Data Dictionary contains the following:
Name of the data item
Definition of the data item
Enterprise Data Category to which it belongs (if any)
Aliases for the data item
List of attributes
Identifying key
Physical database in which it is held
Any known data redundancy relating to this item
Access rights for the data item
Relationships with other data items
Page 20 of 32
The Data Dictionary is useful for application and project-level data administration activities.
The seven major uses of a Data Dictionary are:
1. Project planning: As a part of the planning phase, a high-level data model should be
created. The Data Dictionary is a design aid and data map to support planning. The outputs
are documented in the data dictionary.
3. Database design and testing: The data dictionary is used as a documentation tool,
design aid, schema generator, and data map during these two phases. Database design
results in a conceptual data model that can be implemented in the target DBMS. During
testing, the data model is tested in terms of database operations and integrity controls.
The data dictionary is used as a design aid and data map in developing data models. The
Data Dictionary is also used to generate schemas for DBMS and application programs, and
to generate data to test database operations and controls. Finally, the conceptual data
model and physical database are documented in the data dictionary and used to generate
application documentation.
5. Database use: Database use involves the ongoing update and retrieval of data from a
database. A data map created by the Data Dictionary helps users locate and understand
stored data. It also becomes a primary control tool when it is used to enforce integrity
controls such as data validation.
6. Database evolution: The data dictionary is useful for planning growth change. Data
administration utilizes performance monitoring software to document use and evaluate
performance. This information, plus user’s change requests, leads to potential
enhancements to database systems. The Data Dictionary is a primary tool for planning
and evaluating these enhancements. For example, it can be employed to perform an
impact analysis of proposed changes, such as adding new relationships or data items.
The GIS Data Dictionary is a compilation of information about the geospatial datasets available
in the Department. It provides a definition of terms, feature class table definition, names, and
descriptions of attribute tables and fields in each layer, plus additional details, like
the type and length of each data element. The dictionary also shares the naming conventions
and data standards used by the Department.
The table below shows the format and table definition of the DPWH GIS Data Dictionary:
Page 21 of 32
Table 1: Feature Class Table Definition
The GIS Data Dictionary contains additional information not usually found in a data dictionary
for tabular data. This includes:
Projection of the spatial data
Source of the spatial data
Page 22 of 32
6.7 DPWH Enterprise Data Architecture
The Data Administration Section shall promote the use of the Enterprise Data Architecture as
a means to greatly assist in the integration of new business applications and with legacy
systems.
The Data Architecture is the conceptual description of the data needed to support the business
process of the Department. It is a forward-looking model that emphasizes the data needed
not the data that exists. It represents the framework that should be used for directing future
business application developments.
The Data Governance Program Office (DGPO) shall define and implement the training and
education necessary for effective data management.
A one-day training will be provided for Business and Technical Data Stewards. This training
will outline the role of the Data Stewards and explain their duties to the Data Users.
The Chief Information Officer (CIO) and Data Governance Steering Committee (DGSC) shall
actively participate and provide business insights in the Department’s Strategic Information
Systems Planning efforts.
Page 23 of 32
7 Data Governance Policies and Procedures
A great deal of time, effort, and cost go into collecting and organizing data, and Data
Governance activities seek to ensure that:
The quality of data is maintained.
Data collection is not duplicated.
Data is properly structured.
Data is available where and when it is needed.
Data is secured.
Standard definitions of data are used throughout the Department.
The Business Data Stewards provide the business knowledge of what data needs to be
collected and stored, and who should have access to which data.
Important data that is relevant to more than one Department’s organizational unit is referred
to as “enterprise data”.
All Offices and personnel are instructed through Department Order No. 134, Series of 2018
(See Annex D. DPWH Enterprise Data Glossary) to refer and use the terms and definitions
prescribed in the Enterprise Data Glossary when creating manuals, policies, reports, and
applications. Further, existing documents and applications should be reviewed and revised
accordingly to ensure consistency with the terms and definitions in the Enterprise Data
Glossary.
The definition of business terms is to be coordinated with the Data Administration Section
(DAS), Business Innovation Division (BID), Information Management Service (IMS) by the
respective Business Data Stewards as identified in Special Order No. 4, Series of 2017.
Roles such as Project Manager, Project Engineer, Bridge Engineer, etc. are not included in
the Enterprise Data Glossary. The Enterprise Data Glossary shall be updated at least once
a year or when a new application is developed and implemented in the Department.
The updated Enterprise Data Glossary is available at the DPWH Intranet Site.
Page 24 of 32
Figure 8: Intranet's Enterprise Data Glossary
The respective Business Data Stewards shall coordinate with the Data Administration Section
to conduct an impact analysis report.
The Primary Data Steward may need to consider requests for changes to what is defined as
enterprise data for the category of data that they are responsible for. The Data Administration
Section will be able to offer advice and guidance on processing any such request.
Requests for considering changes to the enterprise data may come either from data users
through their Local Data Steward or from developers and implementers setting up new
business applications.
The Department’s District Engineering Offices (DEOs) are created or renamed through
legislation, and Department Orders (DOs) are issued for its implementation. This results in
inconsistencies of current and historical data used by the application systems. To address this,
the following effectivity of implementation are prescribed:
1. For DOs on the creation and/or renaming of DEOs released in January to June of the
current year, the implementation in the (a) preparation of the Department’s Infrastructure
Program using Multi-Year Planning and Scheduling (MYPS) and Road and Bridge
Information Application (RBIA), (b) Finance process using Electronic New Government
Accounting System (eNGAS) and Electronic Budget System (eBudget), and (c) Human
Resource (HR) process using Personnel Information System (PIS), Time and Attendance
System (TAS), Training Management System (TMS), and Regular Payroll System (RPS)
shall be the following fiscal year.
Page 25 of 32
Whereas, all other activities conducted for funding purposes as well as advance
procurement such as Program of Works (POW) using Cost Estimation Application (CEA),
Preliminary Engineering Design (PED) using Design Management Application (DMA),
Indicative Project Procurement Management Plan (PPMP) using Project Procurement
Management Plan Application (PPMPA), and Eligibility Processing using Civil Works
Application (CWA), the implementation shall be the current year.
Example 1
Release of DO: May 2022
Table 2: Example 1-Effectivity Dates in the Creation and Renaming of DEO Names
HR
Human Resource (HR) Management PIS, TAS, TMS, January 2023
RPS
Construct
Contract Management PCMA January 2023
Acronyms
APP: Annual Procurement Plan
CEA: Cost Estimation Application
CWA: Civil Works Application
DMA: Design Management Application
eBudget: Electronic Budget System
eNGAS: Electronic New Government
Accounting System
MYPS: Multi-Year Planning and Scheduling
PCMA: Project and Contract Management
Application
PIS: Personnel Information System
PPMPA: Project Procurement Management
Plan Application
RBIA: Road and Bridge Information
Application
RPS: Regular Payroll System
TAS: Time and Attendance System
TMS: Training Management System
Page 26 of 32
2. For DOs released in July to December of the current year, the implementation in the
preparation of the Department’s Infrastructure Program using MYPS and RBIA, (b) Finance
process using eNGAS and eBudget, and (c) Human Resource (HR) data using PIS, TAS,
TMS, and RPS shall be the year after the following fiscal year.
Whereas, all other activities conducted for funding purposes as well as advance
procurement, such as Program of Works (POW) using CEA, Preliminary Engineering Design
(PED) using DMA, and Indicative PPMP using PPMPA, and Eligibility Processing using CWA,
the implementation shall be the following fiscal year.
Example 2
Release of DO: November 2022
Table 3: Example 2-Effectivity Dates in the Creation and Renaming of DEO Names
The IMS shall develop a Business Continuity and Disaster Recovery Plan that outlines all of
the procedures that must be followed in the event of a disaster, regardless of whether natural
or man-made, that may result in data loss, for the Department to resume regular ICT
operations in a short time.
Page 27 of 32
7.5 Data Issue Resolution
All issues will be logged and addressed through the DGPO’s established Issue Resolution
Process as detailed in below Figure 9.
START
Page 28 of 32
Process Flow Responsible Details
Person
Approve the Memo for the resolution of Approve the Memorandum for the
Data-Related Requests/Issues IMS Director resolution of Data-related
Requests/Issues.
END
Page 29 of 32
8 Definition of Terms
1. Data Governance. The exercise of decision-making and authority for data-related
matters. It is a system of decision rights and accountabilities for information-related
processes, executed according to agreed-upon models which describe who can take
what actions with what information, and when, under what circumstances, using what
methods.
Page 30 of 32
9 References
Department Order No. 20, Series of 2016 - Implementation of Data Governance Program
Special Order No. 04, Series of 2017 - Assignment of Business Stewards for Data
Governance
Department Order No. 06, Series of 2018 - Alignment of the Reform Institutionalization
and Management Support Systems Steering Committee with the Performance Governance
System, Designation and Roles of Project Managers, and Responsibilities of Head of
Offices
Department Order No. 134, Series of 2018 - DPWH Enterprise Data Glossary
Department Order No. 144, Series of 2018 - Issuance of Freedom of Information (FOI)
People's Manual and Re-issuance of FOI Agency Manual, Section V
Page 31 of 32
10 Appendices
10.1. Figures
10.2. Tables
Page 32 of 32