# Views on column analysis results

Available in...

* Big Data Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Real-Time Big Data Platform

* TDQ\_V\_LAST\_ANALYSIS\_EXEC: contains the primary key of the last execution of each analysis. This view uses TDQ\_V\_ALL\_RUN\_ANALYSIS

* TDQ\_V\_ALL\_RUN\_ANALYSIS: contains all analysis primary keys with the calendar time

* TDQ\_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 dimensions

* TDQ\_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 tables

* LAST\_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 table

* CAL\_PK: foreign keys to the execution date of the analysis

* TIME\_PK: foreign keys to the execution time of the analysis

* AN\_RUNTIME: execution date of the analysis

TDQ\_V\_IND\_HISTO

* REP\_UUID: report identifier

* AN\_UUID: analysis identifier

* REP\_LABEL: report name

* AN\_CREATION\_DATE: analysis creation date

* AN\_AUTHOR: analysis author

* AN\_DATA\_FILTER: analysis data filter

* REP\_CREATION\_DATE: report creation date

* REP\_AUTHOR: report author

* REP\_STATUS: report status

* ELT\_UUID: identifier of analyzed element

* ELT\_CONNECTION\_UUID: connection identifier

* ELT\_CONNECTION\_NAME: connection name

* ELT\_CATALOG\_NAME: catalog name

* ELT\_SCHEMA\_NAME: schema name

* ELT\_TABLE\_NAME: table name

* ELT\_COLUMN\_NAME: column name

* IND\_UUID: indicator identifier

* IND\_LABEL: indicator label

* IND\_CATEG\_UUID: identifier of category

* IND\_CATEGORY: category of identifier

* INO\_REGEXP: regular expression

* CAL\_DATE: date

* TIME\_HOUR: hour (0-23)

* TIME\_MINUTE: minutes (0-59)

* RUN\_TIME: execution date of the analysis

* INDV\_INT\_VALUE: integer value of indicator

* INDV\_ROW\_COUNT: total row count when evaluating the indicator