eBidding ERD
-
Draw.io diagram
The original entity-relationship diagram. Open it in draw.io to see table boxes, field rows, key markers, and their layout.
Download eBidding_ERD.drawio -
Field CSV
A flat export with one record per field row in the diagram. Use it to filter and compare fields in a spreadsheet or import them into SQL.
Download eBidding_ERD.fields.csv -
JSON catalog
The structured export that powers the explorer. It indexes candidate table names and preserves the diagram's boxes, field order, key markers, and source cell IDs.
Download eBidding_ERD.schema.json
PhilGEPS Open Data
-
Schema registry
Machine-readable export layouts, standardized column aliases, and known headerless files.
Download schema registry (JSON) -
Open Data source inventory
Lists the public export batches and their observed file formats, column layouts, and header conventions.
Download source inventory (Markdown) -
Open Data schema verification
Records how the source CSV and Excel layouts were checked against the schema registry and documents the observed variants.
Download schema verification (Markdown) -
Open Data schema history
Traces changes to column names and layouts across historical export batches. The verification report covers the layouts checked for the current collection.
Download schema history (Markdown)
OCDS mapping
-
PhilGEPS 1.5 field workbook
The original 2025 workbook for the legacy PhilGEPS system. It lists source tables and fields and maps them to OCDS paths by contracting stage.
Download PhilGEPS 1.5 field workbook (XLSX) -
mPhilGEPS field workbook
The original 2025 workbook for the modernized database. Its source inventory and stage mappings provide the workbook evidence for the eBidding ERD comparison.
Download mPhilGEPS field workbook (XLSX) -
PhilGEPS 1.5 procurement-method workbook
Lists six legacy procurement-method values and their explicit OCDS destinations where available. The workbook leaves
Download procurement-method workbook (XLSX)Shoppingunmapped. -
Upstream template notes
Explains how the Open Data pipeline uses the mPhilGEPS field workbook and the legacy procurement-method workbook as references.
Download template notes (Markdown) -
PhilGEPS 1.5 project export
The legacy field inventory and 105 populated field mappings in machine-readable form. This powers the PhilGEPS 1.5 section of the OCDS Mapping tab.
Download PhilGEPS 1.5 project (JSON) -
mPhilGEPS project export
The modernized database field inventory and 126 populated field mappings in machine-readable form. This powers the mPhilGEPS section of the OCDS Mapping tab.
Download mPhilGEPS project (JSON) -
Open Data ETL field workbook
A spreadsheet view of the mapping decisions for fields in the normalized public exports.
Download filled field workbook (XLSX) -
Open Data ETL codelist workbook
A spreadsheet view of source categories and their documented destinations in the Open Data pipeline.
Download filled codelist workbook (XLSX) -
Open Data ETL field configuration
Machine-readable targets, transformation treatments, and review status for the 66 cleaned input fields.
Download field configuration (JSON) -
Open Data ETL codelist configuration
Machine-readable mappings for five coded domains, with source values, destination values, and review status.
Download codelist configuration (JSON) -
Workbook-to-ERD comparison
Records workbook rows, exact ERD field matches, normalized candidates, and unresolved links, with source cell IDs where available.
Download ERD comparison (JSON) -
Workbook comparison method
Documents the matching rules, initial findings, and commands used to reproduce the workbook-to-ERD report.
Download comparison method (Markdown) -
Upstream mPhilGEPS template review
Compares the mPhilGEPS workbook with the public-export ETL mappings and records agreements, differences, and open questions.
Download upstream template review (Markdown)
Provenance
-
PhilGEPS Data v2 manifest
Records the pinned source commit and SHA-256 checksums for the imported export schemas, workbooks, configuration, and documentation.
Download PhilGEPS Data v2 manifest (JSON) -
OCDS Mapping Explorer manifest
Records the pinned source commit and SHA-256 checksums for the project exports and legacy workbook, and identifies the verified duplicate mPhilGEPS workbook.
Download OCDS Mapping Explorer manifest (JSON)
Four-source crosswalk
-
Four-source crosswalk report
Joins the PhilGEPS 1.5 and mPhilGEPS workbook mappings, selected Open Data fields, and eBidding ERD evidence by OCDS stage and path.
Download crosswalk report (JSON) -
Crosswalk method and findings
Explains how the sources were joined, what counts as a match or gap, and how to reproduce the report.
Download crosswalk method and findings (Markdown)