TDQ_V_LAST_ANALYSIS_EXEC
: contains the primary key of the last execution of each analysis. This view usesTDQ_V_ALL_RUN_ANALYSIS
TDQ_V_ALL_RUN_ANALYSIS
: contains all analysis primary keys with the calendar timeTDQ_V_LAST_RUN_ANALYSIS
: contains the primary key of the last execution of each analysis alongside with the time execution information and the foreign keys to calendar and time dimensionsTDQ_V_IND_HISTO
: contains all historized values of indicator computations on column analysis alongside all readable information such as labels from all the dimensions
Detailed description of views:
TDQ_V_LAST_ANALYSIS_EXEC
ANALYSIS_PK
: foreign keys to the analysis dimension tablesLAST_RUNTIME
: count of last version of the analyzed element
TDQ_V_ALL_RUN_ANALYSIS
and TDQ_V_LAST_RUN_ANALYSIS
ANALYSIS_PK
: foreign keys to the analysis dimension tableCAL_PK
: foreign keys to the execution date of the analysisTIME_PK
: foreign keys to the execution time of the analysisAN_RUNTIME
: execution date of the analysis
TDQ_V_IND_HISTO
REP_UUID
: report identifierAN_UUID
: analysis identifierREP_LABEL
: report nameAN_CREATION_DATE
: analysis creation dateAN_AUTHOR
: analysis authorAN_DATA_FILTER
: analysis data filterREP_CREATION_DATE
: report creation dateREP_AUTHOR
: report authorREP_STATUS
: report statusELT_UUID
: identifier of analyzed elementELT_CONNECTION_UUID
: connection identifierELT_CONNECTION_NAME
: connection nameELT_CATALOG_NAME
: catalog nameELT_SCHEMA_NAME
: schema nameELT_TABLE_NAME
: table nameELT_COLUMN_NAME
: column nameIND_UUID
: indicator identifierIND_LABEL
: indicator labelIND_CATEG_UUID
: identifier of categoryIND_CATEGORY
: category of identifierINO_REGEXP
: regular expressionCAL_DATE
: dateTIME_HOUR
: hour (0-23)TIME_MINUTE
: minutes (0-59)RUN_TIME
: execution date of the analysisINDV_INT_VALUE
: integer value of indicatorINDV_ROW_COUNT
: total row count when evaluating the indicator