equivalence sheet is optional and specifies the units of the
nomenclature that have equivalences in other nomenclatures supported by the Database. These
links with other nomenclatures are used to make automatic conversions of statistical data
An equivalence is a particular case of a derivation, whose the relationship value is
The condition of the validity of this file is the support of the referenced nomenclature and its version by the Database.
It is not necessary to establish equivalence links with the units of other versions of the same nomenclature. This will be automatically done during the integration of the nomenclature into the library.
Two statistical units are considered to be equivalent if they are equal semantically (a country referenced by a nomenclature may be equivalent to a country in another one, but not to a group of countries) and geographically (both the units have the same shape and boundaries).
equivalence sheet must respect the layout shown in Table 2.10
(examples of values are given in italics).
Equivalence sheet layout example
Details on the columns are given below:
References the code of the statistical unit
present into the
units sheet. Theoretically, a statistical unit can
be equivalent to any number of statistical units in other nomenclatures.
The expected value in this column is a
that is also present in the
units sheet (see Section 2.3).
References the level of the statistical unit present into the
An empty value references the default level of a non-hierarchical nomenclature.
References the code of the equivalent unit valid in another nomenclature. The expected value in this column must be a statistical unit code already registered by the Database.
References the level of the equivalent unit. An empty value references the default level of a non-hierarchical nomenclature.
References the nomenclature to which belongs the unit code in the previous column. The expected value in this column must be an acronym of a nomenclature supported by the Database .
References the version of the nomenclature mentioned in the previous column, where the equivalence between the units is established. The expected value must be an identifier of a nomenclature version supported by the Database .
Data constraints. Any combination of
equivalent_version is unique
in this table.