derivations sheet contains information about the units of other nomenclatures
that have been used to create a new nomenclature. This file can exist only for derived nomenclatures (produced
using statistical units of other nomenclatures) and is optional. Establishing links with original units will
allow the application to convert data between related nomenclatures.
Tree types of links can be established between the original and the derived units in the current version of the
specification. These types must be indicated in the
derivations sheet. They are the
The derived unit can be a union of two or more original units, representing an aggregation or a generalization of the original units. In this case (parent relationship), the label "INCLUDES" must be used.
The derived unit can be equal to the original. The label to use is "EQUALS".
Two or more derived units can represent parts of the original unit, so as the union of the derived units is equal to the original one. In this case (child relationship), the label to use is "INCLUDED".
derivations sheet must respect layout shown in Table 2.11 example.
In this example, the original units (
LU) are used by
a derived nomenclature to form an aggregated unit having the code
BENELUX in this custom nomenclature.
The aggregated unit can be characterized as a super-structure, a parent for the original ones, existing inside the described
Derivations sheet layout example
The lines of the tables must be read and understood as follows:
the unit encoded
Details of columns are given below:
Contains the code of the original unit used to produce the unit of the described nomenclature. The original unit must be already registered in the Database and its code must be valid.
Contains the level label of the original unit used to produce the unit of the described nomenclature. The original level must be already registered in the Database and its code must be valid. An empty value references the default level of a non-hierarchical nomenclature.
Contains the literal of the nomenclature where the original unit exists. This column is added to the file layout because a custom nomenclature can derive from more that one others.
Contains the title of the version of the nomenclature where the original unit exists. This column is added to the file layout because a custom nomenclature can derive from more that one others.
Must contain the code of the unit from the described nomenclature version
(it must be present in the
units sheet, see Section 2.3).
Contains the level label of the present unit. An empty value references the default level of a non-hierarchical nomenclature.
Characterizes the link between
the units referenced in the currently described nomenclature (
unit_derived_code column) and the
units described by the three columns A (existing unit code) B (existing nomenclature code) C (existing nomenclature version).
The possible values in this
relationship column are:
INCLUDES - if the current derived unit fully includes (is a parent of) the original unit.
EQUALS - if the current derived unit and the original unit are equal.
INCLUDED - if the current derived unit is included (is a child of) in the original unit.
INTERSECTS - if the derived unit and the original one intersect without full inclusion or equality.