Open Footprint — Standalone Data Model

The polyglot data model standard for environmental reporting. 8 domains in v4.x with 3 additional domains in v5.0 preview.

Data Domains

Common Entities

Organizations, facilities, emission factors, units of measure, and shared reference data used across all domains.

~12 entities

Facility Structure

Equipment, locations, spatial data, and physical infrastructure for facilities where emissions occur.

~8 entities

Organizational Structure

Enterprise hierarchy, addresses, contacts, industry classifications, and corporate groupings.

~10 entities

Organizational Boundary

Reporting boundaries, scopes (1/2/3), ownership shares, and consolidation approach definitions.

~6 entities

Recording

Activity recording, calculation models, formulas, emission statements, and measurement methodology.

~14 entities

Product Life Cycle

Product carbon footprint (PCF), PACT methodology alignment, lifecycle stages from cradle to grave.

~11 entities

Reporting

Disclosure reports, intensity ratios, assurance statements, compliance tracking against CSRD/ESRS frameworks.

~9 entities

Data Verification

Quality rules, verification workflows, assessment methods, confidence scoring, and non-conformance tracking.

~8 entities

v5 Preview

Emission Ledger Management

E-Ledger balances, liability tracking, double-entry carbon accounting with debit/credit mechanics.

~17 entities

v5 Preview

Water

Water sourcing, usage, and quality measurements with environmental permits, water-stress classification, and water transactions.

~17 entities

v5 Preview

Circularity

Waste streams, diversion and recovery operations, recycling, and circular material flows linked to product footprints and EPDs.

~24 entities

Carbon Measures

Core attribute types used across the Open Footprint recording and ledger domains.

CO2eKg

DECIMAL(15,4)kg CO2e

Emission quantity in kilograms of CO2 equivalent. Core measure for all emission types.

O-DEFofp-sustainability:3.1~1.1_5.1

CarbonDebt

DECIMAL(15,4)kg CO2e

Accumulated CO2e debt passed through the supply chain via E-Ledger transfers.

O-DEFofp-sustainability:3.4~1.1_7.2

CarbonIntensityValue

DECIMAL(10,4)gCO2e/MJ

Carbon intensity for fuel regulation compliance (e.g., Clean Fuels Canada).

ConfidenceScore

DECIMAL(5,4)0.0 - 1.0

Verification confidence computed as passed_checks / total_checks. Higher is better.

PercentValue

DECIMAL(7,4)0 - 100%

Allocation weights, primary data share, recovery rates. Sum of allocations must equal 100%.

DataQualityRating

INTEGER1 - 5 (PACT scale)

PACT Data Quality Rating: 1 = highest quality (measured), 5 = lowest (estimated).

Recording Domain Flow

OFP Activity RecordCalculation FormulaE-Ledger Entry (Debit)Verification Request

Activity data flows through calculation formulas into E-Ledger entries, then to dVE for verification.

Database Targets

PostgreSQL

Available

abstract, master_data, reference_data, transactional_data

Neo4j

Available

Graph model — full DDL needs Enterprise/Aura

MongoDB

Available

Collections with $jsonSchema validators

Databricks

Planned

Delta Lake — validated, pending workspace run

Oracle

Planned

Relational model

Snowflake

Planned

Columnar model

Explore OFP as an OSDU DDMS

See how OFP integrates into the OSDU Data Platform as an Environment DDMS.

DDMS within OSDU