# File definitions ## Release information | File type | Content | Public scope | | --------------------- | ------------------------------------------------------------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------- | | Database Overview | Dataset, geography, impact assessment method, impact category and flow catalogs for one version | Catalogs, metadata, reference product quantities and aggregate counts; anonymously accessible | | ID Correspondence | Dataset ID correspondence and metadata comparison across versions of the same database and model | Retained IDs and differences between the two ID sets; anonymously accessible. No inferred ID changes, splits, merges or substitutions. | | Change Annex Metadata | Metadata change annex using the same inputs as ID Correspondence | Catalog counts, qualitative changes, dataset ID differences, flow catalog changes and LCIA catalog changes; anonymously accessible | | Common rule | Definition | | ----------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Unique dataset identification | Database identifier, version, system model and Dataset ID; Activity UUID alone does not identify a dataset | | Method ID | Composite key of impact assessment method UUID, impact category UUID and category indicator UUID; distinct from Method UUID alone | | Version suffix | In actual column names, `{old}` and `{new}` are replaced by the corresponding versions. AL retains its actual version `1.0`. | | Missing values | Unavailable values remain empty cells; they do not mean zero, false or not applicable. See Known gaps. | | Comparison boundary | A shared ID does not imply unchanged content. An old-only or new-only ID does not by itself mean business retirement or a new product. | | Content boundary | Excludes unit process direct exchange amounts, supplier process links, cumulative LCI/LCIA result values, and coefficients of the technosphere matrix A, intervention matrix B or characterization matrix C | | Special sources | CESI 1.2.0 is a frozen result catalog not yet listed on the data platform. AL 1.0 is a frozen historical baseline. HiQLCD 1.4.1 reuses descriptive metadata from 1.4.0. | ## Database Overview The following is the r2 structure (20261107T020200Z). Only supplied fields are listed; entirely empty columns are omitted. A model worksheet appears only when that model is available in the version. | Sheet | Scope | | ---------------------- | ----------------------------------------------------------------------------- | | Read me | Release fields, worksheet catalog and column definitions | | Cut-off AO | CUT_OFF dataset catalog | | Consequential AO | CONSEQUENTIAL dataset catalog | | EN15804 AO | EN_15804 dataset catalog | | Industries | 41 sector classifications and CUT_OFF dataset counts | | Geographies | Geographies and recorded parents | | LCIA Methods | Impact assessment method catalog | | Impact Categories | Impact category and category indicator catalog | | Intermediate Exchanges | Reference product flow catalog, excluding process-flow quantity relationships | | Elementary Exchanges | Elementary flow catalog, excluding unit process direct exchange amounts | | Known gaps | Recorded source gaps | ### Read me Every file type includes Read me. It contains three blocks: two-column release fields, a Sheet / Content / Rows worksheet catalog, and Sheet / Column / Definition / Unit column definitions. | Release field | Definition | | -------------- | ----------------------------------------------------------------------------------------------------------------------- | | Database | Database identifier | | Version | Database version | | System models | System models actually included in the file | | Release date | Official release date, retaining month precision. Empty when unavailable; not replaced by the attachment revision time. | | File revision | Attachment revision | | Generated from | Sources of published catalogs, frozen catalogs, reused metadata and cross-version comparisons | ### Known gaps | Column | Definition | | ------------- | --------------------------------- | | Sheet | Worksheet name | | Column | Column name | | Affected rows | Records affected by the gap | | Source rows | Corresponding source record count | | Issue | Recorded source gaps | ### Cut-off AO / Consequential AO / EN15804 AO The three models use the same column order. CAS Number means Chemical Abstracts Service registry number in all tables below. | Column | Definition | | ------------------------ | ----------------------------------------------------------------------------------------------------- | | Dataset ID | Dataset ID in the database, version and model | | Activity UUID | Activity identifier; one activity may have multiple datasets | | Activity Name | Dataset name in its actual source language | | Geography | Geographic code | | Time Period | Original reference period start and end dates; missing dates are not estimated | | Special Activity Type | Recorded activity type enum and label | | Industry Classification | Actual HIQ sector classification IDs and names, separated by semicolons for multiple values; not ISIC | | Product UUID | Reference product flow ID | | Reference Product Name | Reference product name | | Unit | Reference product unit | | Reference Product Amount | Reference product quantity, preserving its original value rather than normalizing it to 1 | | CAS Number | Recorded reference product CAS number | ### Industries | Column | Definition | | ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------- | | ID | Sector classification identifier | | Name | Sector classification name | | Dataset Count | Dataset IDs deduplicated in this version's Cut-off AO; a dataset is counted under each sector tag. Sector counts must not be summed as a database total. | ### Geographies | Column | Definition | | ---------------- | ----------------------------------------------------------------------------------- | | ID | Geography identifier | | Name | Geographic name | | Shortname | Geographic code or short name | | Latitude | Recorded latitude | | Longitude | Recorded longitude | | Parent Geography | Recorded parent geographic code; represents only the recorded parent-child relation | ### LCIA Methods | Column | Definition | | ----------- | ------------------------------------------------------------------------------------------ | | Method Name | Impact assessment method name | | Method UUID | Impact assessment method UUID from the original Method ID; missing components remain empty | ### Impact Categories | Column | Definition | | --------- | -------------------------------------------------------------------------------------------------------- | | Method | Impact assessment method name | | Category | Impact category name | | Indicator | Category indicator name | | Unit | Category indicator unit | | Method ID | Composite key preserved as the original string; incomplete components are not filled with invented UUIDs | ### Intermediate Exchanges | Column | Definition | | ---------- | ---------------------------------------------------------------- | | ID | Intermediate flow ID corresponding to a public reference product | | Name | Flow name | | Unit Name | Reference unit name | | CAS Number | Recorded CAS number | ### Elementary Exchanges | Column | Definition | | -------------- | ------------------------------------------------------------------------------- | | ID | Elementary flow ID | | Name | Elementary flow name | | Compartment | Recorded environmental compartment | | Subcompartment | Recorded environmental subcompartment; remains missing if it cannot be resolved | | Unit Name | Elementary flow reference unit name | | CAS Number | Recorded CAS number | | Formula | Recorded chemical formula | ## ID Correspondence Read me and Known gaps use the Database Overview definitions. Cut-off / Consequential / EN15804 are provided for the available models. Each model has 10 old-version columns, 10 new-version columns, seven field differences, Match Basis and Status, in that order. {old}/{new} are replaced by actual versions. | Column (actual order) | Definition | | ---------------------------------- | ----------------------------------------------- | | Dataset ID - {old} | Dataset identifier within the model | | Activity UUID - {old} | Activity identifier | | Activity Name - {old} | Activity name | | Geography - {old} | Geographic code | | Time Period - Start Date - {old} | Data reference period start date | | Time Period - End Date - {old} | Data reference period end date | | Special Activity Type - {old} | Activity type | | Product UUID - {old} | Reference product flow identifier | | Reference Product Name - {old} | Reference product name | | Unit - {old} | Reference unit | | Dataset ID - {new} | Dataset identifier within the model | | Activity UUID - {new} | Activity identifier | | Activity Name - {new} | Activity name | | Geography - {new} | Geographic code | | Time Period - Start Date - {new} | Data reference period start date | | Time Period - End Date - {new} | Data reference period end date | | Special Activity Type - {new} | Activity type | | Product UUID - {new} | Reference product flow identifier | | Reference Product Name - {new} | Reference product name | | Unit - {new} | Reference unit | | Activity Name different | Whether the activity name changed | | Geography different | Whether the geographic code changed | | Time Period - Start Date different | Whether the reference period start date changed | | Time Period - End Date different | Whether the reference period end date changed | | Special Activity Type different | Whether the activity type changed | | Reference Product Name different | Whether the reference product name changed | | Unit different | Whether the reference unit changed | | Match Basis | Match basis | | Status | Catalog ID or metadata change status | | Status | Definition | | ----------- | --------------------------------------------------------------------------------------- | | matched_id | The old and new dataset IDs match; content is not necessarily identical | | old_id_only | Present only in the old ID set; not automatically business retirement | | new_id_only | Present only in the new ID set; not automatically a new product | | model_added | System model added in the new version; not counted as new products in an existing model | A difference field is empty, not false, when either value is unknown. A display-language difference is not evidence of a name change. Business-confirmed splits, merges, substitutions, replacement quantities and conversion factors are not provided. ## Change Annex Metadata | Sheet | Scope | | ------------------- | ----------------------------------------------------------------------------------------------- | | Read me | Release fields, worksheet catalog and column definitions, as in Database Overview | | Summary | Catalog counts for the same input sets | | Qualitative Changes | Metadata field changes in matched datasets | | Dataset Changes | Dataset ID correspondence and differences between the two ID sets | | Flow Changes | Flow catalog changes, excluding changes to unit process direct exchanges | | LCIA Changes | Impact assessment catalog changes, not a comparison of characterization factor or result values | | Known gaps | Source gaps, as in Database Overview | ### Summary | Column | Definition | | ------------ | -------------------------------------------------------------------------------------------------------------- | | System Model | System model | | Metric | Metric: counts of dataset IDs, reference products, geographies, flow catalog entries or method catalog entries | | Old Value | Old-side count | | New Value | New-side count | | Difference | New-side count minus old-side count | ### Qualitative Changes | Column | Definition | | ------------------ | ------------------------------------------------ | | System Model | System model | | Dataset ID - {old} | Old-version dataset ID | | Dataset ID - {new} | New-version dataset ID | | Field | Changed metadata field | | Old Value | Old-side field value | | New Value | New-side field value | | Match Basis | Match basis; identical IDs use stable_dataset_id | | Status | Change status of the corresponding record | ### Dataset Changes | Column | Definition | | --------------------- | ------------------------------------------------------------------------------ | | System Model | System model | | Dataset ID - {old} | Old-version dataset ID | | Dataset ID - {new} | New-version dataset ID | | Activity Name - {old} | Old-version dataset name | | Activity Name - {new} | New-version dataset name | | Geography - {old} | Old-version geographic code | | Geography - {new} | New-version geographic code | | Status | ID match or one-sided presence; not automatically business removal or addition | ### Flow Changes | Column | Definition | | ------------ | -------------------------------------------------------------------------------- | | System Model | System model | | Flow ID | Flow ID | | Flow Type | Elementary flow or intermediate flow corresponding to a public reference product | | Field | Changed flow catalog field, such as ID, name, unit, CAS number or compartment | | New Value | New-side catalog field value | | Status | Catalog record change status, excluding changes to unit process direct exchanges | ### LCIA Changes | Column | Definition | | ----------------- | -------------------------------------------------------------------------------------------------------------- | | System Model | System model | | Method ID | Complete composite key of impact assessment method, impact category and category indicator | | Method - {old} | Old-side impact assessment method name | | Method - {new} | New-side impact assessment method name | | Category - {old} | Old-side impact category name | | Category - {new} | New-side impact category name | | Indicator - {old} | Old-side category indicator name | | Indicator - {new} | New-side category indicator name | | Unit - {old} | Old-side category indicator unit | | Unit - {new} | New-side category indicator unit | | Status | Catalog record change status; does not represent numerical changes in characterization factors or LCIA results |