Abstract: Various examples are directed to systems and methods of using a database management system (DBMS) to post a transaction. An enterprise resource planning (ERP) application may receive first transaction data associated with a first transaction including acquisition of a first component of a first component type. The first transaction data may describe an indicator of the first component, a cost of the first component of a first component type, and a first environmental metric associated with the first component. The ERP application may write a first transaction entry to a universal journal table of the DBMS, the first transaction entry comprising a description of the first transaction, and a component breakdown key. The ERP application may also write a first component breakdown entry to a component breakdown table of the DBMS.

Abstract: Intelligent mapping from created item information to sustainability reference content from a variety of sources can be implemented to facilitate created item footprint management and other sustainability applications. The difficult task of finding appropriate emission factors across a portfolio can be automated. Assisted search can be implemented using enhanced search techniques. Fallback mappings can be implemented to accommodate different levels of granularity during search. A machine learning model can be trained based on a variety of input data, including confirmed mappings, mapping history, and rules. The process of mapping to emission datasets can thus be simplified, enabling footprint calculations to proceed.

Abstract: Sustainability reference content from a variety of sources can be imported into a canonical format for a variety of uses. Product footprint analysis can be performed by accessing the imported sustainability reference content. The canonical format can support a variety of features relating to normalization of units, validity time window, geographical indications, and content quality. API access can be provided to facilitate content update. Automated data import from lifecycle assessment content providers can be supported along with manual input of data from arbitrary sources such as users, vendors, suppliers, or the like. Scope can go beyond footprint analysis to environmental health compliance and other use cases.

Abstract: Systems and processes for generating and managing derivation definitions for calculating sustainability footprints are provided. In a method for generating derivation definitions for calculating footprints, inputs, rulesets, and/or coded processes are determined for the derivation definition. A sequence order for applying the rulesets and/or coded processes is determined for the derivation definition, and the derivation definition is stored in a repository for selection to calculate sustainability footprints.

Abstract: Systems and processes for calculating sustainability footprints and controlling associated systems are provided herein. Activity data may be received for an organization, and emissions factors may be determined for the activity data. Absolute, relative, and/or average relative footprints may be calculated for the organization based on the activity data and the emissions factors. An indication of the absolute, relative, and/or average relative footprints may be generated for display on a graphical user interface of a computing device.