TDQ_V_LAST_ANALYSIS
: contains the analysis and the report identifiers with the last version number of the analysis dimension (becauseTDQ_ANALYSIS
is a Slowly Changing Dimension, each analysis can have several versions).TDQ_V_ANALYSIS
: view on the last version of the analysis data. This view usesTDQ_V_LAST_ANALYSIS
TDQ_V_LAST_ANALYZED_ELEMENT
: contains the analyzed element identifier alongside with the last version number of the analyzed element dimensionTDQ_V_ANALYZED_ELEMENT
: view on the last version of the analyzed element. This view usesTDQ_V_LAST_ANALYZED_ELEMENT
TDQ_V_LAST_INDICATOR_DEF
: contains the indicator definition identifier alongside with the last version number of the indicator definition dimensionTDQ_V_INDICATOR_DEFINITION
: view on the last version of the indicator definition. This view usesTDQ_V_LAST_INDICATOR_DEF
TDQ_V_SIMPLE_INDICS
: This view filters the simple statistics indicators. It usesTDQ_V_INDICATOR_DEFINITION
Detailed description of views:
TDQ_V_ANALYSIS
, TDQ_V_ANALYZED_ELEMENT
and
TDQ_V_INDICATOR_DEFINITION
have the same attributes (columns) as
TDQ_ANALYSIS
, TDQ_ANALYZED_ELEMENT
and
TDQ_INDICATOR_DEFINITION
respectively. For further information, see
Detailed description of tables
TDQ_V_LAST_ANALYSIS
AN_UUID
: analysis identifierREP_UUID
: report identifierLAST_VERSION
: last version of the analysis
TDQ_V_LAST_ANALYZED_ELEMENT
ELT_UUID
: identifier of the analyzed elementLAST_VERSION
: last version of the analyzed element
TDQ_V_LAST_INDICATOR_DEF
IND_UUID
: indicator identifierLAST_VERSION
: last version of the identifier
TDQ_V_SIMPLE_INDICS
IND_PK
: primary keyIND_UUID
: indicator identifierIND_LABEL
: indicator labelIND_CATEGORY
: indicator category.Simple indicators such as count indicators belong to the Simple Statistics category, Count subcategory. Text indicators belong to the Text Statistics category. Mean, Median, Lower quartile, upper quartile, min value, max value belong to the Summary Statistics category. Mode belong to the Advanced Statistics category and Mode subcategory. Frequency table belong to the Advanced Statistics category and Frequencies subcategory.
IND_CATEG_UUID
: category identifier
And the three historization columns:
IND_BEGIN_DATE
IND_END_DATE
IND_VERSION