Skip to content

0512 Derived Schema Elements

Derived schema elements access other data, possibly in the same or a different asset to generate/derive the values for the attribute. Examples of this are database views and derived database columns.

UML

CalculatedValue classification

The CalculatedValue classification contains the formula attribute which is set to the query that retrieves the data, formulaType describes the notation language used to describe the formula. There are optional links to DerivedSchemaTypeQueryTarget to identify which schema elements are accessed by the formula. The formula may contain placeholders that refer to the queryId in DerivedSchemaTypeQueryTarget. Alternatively, the query can be expressed complement using the query and queryType attributes.

  • formula - Formula that describes the behaviour of the element. May include placeholders for queryIds.
  • formulaType - Format of the expression provided in the formula attribute.

DerivedSchemaTypeQueryTarget relationship

The DerivedSchemaTypeQueryTarget relationship identifies the schema elements that are queried to generate all or part of the value for the attribute at end 1.

  • query - Query used to extract data, can include placeholders.
  • queryId - Placeholder for a query.
  • queryType - Type of query used to extract data.
  • iscQualifiedName - Unique name for the associated Information Supply Chain.

Raise an issue or comment below