Queries Table - trillium_discovery - trillium_quality

entity


ENTITY_SYSTEM_NAME	ENTITY_UUID	HUMANISED_NAME
SCHEMA_NAME	STATE	STATE_CHANGED_DATE
STATE_CHANGED_BY	SOURCE_TYPE_CODE	SOURCE_TYPE
DATA_SOURCE	NUMBER_ATTRIBUTES	LOADED_ROWS
LOAD_SAMPLE	LOADED_VALUES

entity_name(entity_ID)

ODBC only	non-default columns returned depend on the entity.
	Row	Row Length	Group Number
	Row Value Count

show_all_br

OLE DB
	Entity ID	Entity	Attribute ID
	Attribute	Rule Name	Seqno
	Description	Threshold	Derived
	Library	Enabled	Result
	Passing Fraction	Status	Total Rows
	Rows Processed	Failing Rows	Passing Rows
	Filtering	Filter Error Count	Filter First Error Row
	Filter First Error	Sequence Number	Identifier
	Local Identifier	Referenced Attributes	Failing Fraction
	Grouping	Group Count	Group Limit
	Group Error Count	Group First Error Row	Group First Error
	Aggregating	Passing Aggregate	Failing Aggregate
	Aggregate Method	Aggregate Error Count	Aggregate First Error Row
	Aggregate First Error	Created By	Date Created
	Edited By	Date Changed	Error Count
	First Error Row	First Error	Predicate
	Filter Predicate	Group Function	Aggregate Function
	Actual Predicate	Priority	Priority Name
	Priority Description	Categories
ODBC
	Date Changed	Created By	Entity ID
	Attribute ID	Entity	Attribute
	Rule Name	Seqno	Description
	Threshold	Derived	Library
	Enabled	Result	Total Rows
	Rows Processed	Passing Fraction	Failing Fraction
	Status	Failing Rows	Passing Rows
	Error Count	First Error Row	First Error
	Filtering	Filter Error Count	Filter First Error Row
	Filter First Error	Grouping	Group Count
	Group Error Count	Group Limit	Group First Error Row
	Group First Error	Aggregating	Passing Aggregate
	Failing Aggregate	Aggregate Method	Date Created
	Edited By	Predicate	Filter Predicate
	Group Function	Aggregate Function	Actual Predicate
	Aggregate Error Count	Aggregate First Error Row	Aggregate First Error
	Priority	Priority Name	Priority Description
	Categories	Sequence Number	Identifier
	tsa	generations	show_disabled
	type	eid	pid
	Referenced Attributes

show_attribute_names


Unique Entity Name	Entity ID	Entity Name
Attribute Name	Attribute ID	eid (ODBC only)
aid (ODBC only)

show_attribute_trend


Project ID	Project Name	Unique Entity Name
Entity ID	Entity Name	Attribute ID
Attribute Name	Transformation	Values
Values Distribution	Unique Count	Unique Distribution
Null Count	Null Distribution	pid (ODBC only)

show_baseline

OLE DB
	Group ID	Group Name	Description
	Entities	Notes	Permanent Joins
	Discovered Joins	Created By	Date Created
	Edited By	Date Changed	Entity IDs
ODBC
	Description	Created By	Date Created
	Edited By	Date Changed	Group ID
	Group Name	Entities	Notes
	Entity IDs	Permanent Joins	Discovered Joins
	baseline

show_br_groups

OLE DB
	Entity ID	Rule Name	Seqno
	Passing Fraction	Failing Rows	Passing Rows
	Entity Name	Value	Failing Fraction
	Total Rows	Aggregating	Aggregate Pass
	Aggregate Fail	Aggregate Method
ODBC
	pid	tsa	generations
	ebr	eid	Aggregating
	Aggregate over Passing Rows	Aggregate over Failing Rows	Aggregate Method
	Entity ID	Rule Name	Passing Fraction
	Failing Rows	Passing Rows	Total Rows
	Value	Failing Fraction	Seqence number

show_br_metadata

OLE DB
	Entity_name	Attribute Id	Attribute Name
	Rule Name	Category Id	Keyword Id
	Category	Keyword	Seqno
	Entity Id
ODBC
	Entity ID	Entity Name	Attribute ID
	Attribute Name	Seqno	Rule Name
	Category ID	Keyword ID	Category
	Keyword	eid	pid
	tsa	generations	type

show_entity_member_attributes

OLE DB
	ENTITY	ENTITY_ID	ATTRIBUTE_ID
	ATTRIBUTE	VALUES	VALUE_DISTRIBUTION
	PATTERNS	MIN	MAX
	MIN_LEN	MAX_LEN	NULL_COUNT
	NULL_DISTRIBUTION	SCHEMA_NULL_RULE	SPACE_COUNT
	SPACE_DISTRIBUTION	INFERRED_DATATYPE	DEFINITION
	STRINGS	STRING_DISTRIBUTION	STRING_MIN
	STRING_MAX	DECIMALS	DECIMAL_DISTRIBUTION
	DECIMAL_MIN	DECIMAL_MAX	INTEGERS
	INTEGER_DISTRIBUTION	INTEGER_MIN	INTEGER_MAX
	VALUES_TRUNC	TRUNC_DISTRIBUTION	VARIABLE_SPACES
	METAPHONES	MASKS	SOUNDEXES
	PHRASES	PERMANENT_KEYS	DISCOVERED_KEYS
	PERMANENT_ DEPENDENCIES	DISCOVERED_ DEPENDENCIES	BUSINESS_DESCRIPTION
	DOCUMENTED_DATATYPE	TARGET_DATATYPE	SCHEMA_NAME
	SCHEMA_LEN	SCHEMA_PRECISION	SCHEMA_SCALE
	SCHEMA_BYTE_OFFSET	SCHEMA_BYTE_LENGTH	INFERRED_PRECISION
	INFERRED_SCALE	VALUE_COUNT	NOTES
	ARRAY	CREATED_BY	EDITED_BY
	AVG	DECIMAL_AVG	DEPS_ANALYSIS
	ENCODING	DEPS_ANALYSIS	KEYS_ANALYSIS
	JOINS_ANALYSIS	ENTITY_STATE_CHANGE_DATE	ENTITY_STATE_CHANGED_BY
	ENTITY_STATUS	GROUP	INDEX_STATUS
	INTEGER_AVG	MASK_SHORTEST	MASK_LONGEST
	MASK_MIN	MASK_MAX	MASK_MODE
	MASK_VALUES	MAX_TRUNC	MIN_TRUNC
	METAPHONE_SHORTEST	METAPHONE_LONGEST	METAPHONE_MIN
	METAPHONE_MAX	METAPHONE_MODE	METAPHONE_VALUES
	PATTERN	PATTERN_SHORTEST	PATTERN_LONGEST
	PATTERN_MIN	PATTERN_MAX	PATTERN_MODE
	PATTERN_VALUES	PRIORITY	REDEFINES
	SCHEMA_SCALE_FACTOR	SOUNDEX_SHORTEST	SOUNDEX_LONGEST
	SOUNDEX_MIN	SOUNDEX_MAX	SOUNDEX_MODE
	SOUNDEX_VALUES	SOURCE_TYPE	SPC_MIN_LEN
	SPC_MAX_LEN	SUM	TYPE
	STANDARD_DEVIATION	COLUMN_NAME	MEDIAN
ODBC
	Entity ID	eid	pid
	tsa	generations	Entity
	Attribute ID	Attribute	Values
	Value Distribution	Patterns	Min
	Max	Min Len	Max Len
	Null Count	Null Distribution	Schema Null Rule
	Space Count	Space Distribution	Inferred Datatype
	Definition	Strings	String Distribution
	String Min	String Max	Decimals
	Decimal Distribution	Decimal Min	Decimal Max
	Integers	Integer Distribution	Integer Min
	Integer Max	Values Trunc	Trunc Distribution
	Variable Spaces	Metaphones	Masks
	Soundexes	Phrases	Permanent Keys
	Discovered Keys	Permanent Dependencies	Discovered Dependencies
	Business Description	Documented Datatype	Target Datatype
	Schema Name	Schema Len	Schema Precision
	Schema Scale	Schema Byte Offset	Schema Byte length
	Inferred Precision	Inferred Scale	Value Count
	Notes	Array	Attribute Created By
	Attribute Edited By	Avg	Decimal Avg
	Deps Analysis	Encoding	Attribute Date Created
	Attribute Date Edited	Entity Loaded Date	Deps Analysis2
	Key Analysis	Joins Analysis	Entity State Change Date
	Entity State Changed By	Entity Status	Group
	Index Status	Integer Avg	Mask Shortest
	Mask Longest	Mask Min	Mask Max
	Mask Mode	Mask Values	Max Trunc
	Min Trunc	Metaphone Shortest	Metaphone Longest
	Metaphone Min	Metaphone Max	Metaphone Mode
	Metaphone Values	Pattern	Pattern Shortest
	Pattern Longest	Pattern Min	Pattern Max
	Pattern Mode	Pattern Values	Priority
	Redefines	Schema Scale Factor	Soundex Shortest
	Soundex Longest	Soundex Min	Soundex Max
	Soundex Mode	Soundex Values	Source Type
	Spc Min Len	Spc Max Len	Sum
	Type	Standard Deviation	Column Name
	Median	BR Compliance %

show_entity_metadata

OLE DB	ENTITY_ID	ENTITY_NAME	ENTITY_SCHEMA_NAME
	ATTRIBUTES	ROWS	VALUES
	ROW_MIN_LEN	ROW_MAX_LEN	DATA_SOURCE
	CONNECTION_DATA	ENCODING	SCHEMA
	PERMANENT_KEYS	DISCOVERED_KEYS	PERMANENT_ DEPENDENCIES
	DISCOVERED_ DEPENDENCIES	BUSINESS_DESCRIPTION	DELIMITER
	QUOTE_CHAR	SAMPLE_CRITERIA	CRLF
	ROW_AVG_LENGTH	PRE_PROCESSING_RULE	ENTITY_PRIORITY
	UNSIGNED_PACKED	REDEFINES	CHARSET
	ENDIAN	QUOTE_ESC_CHAR
ODBC
	Entity ID	Values	Permanent Keys
	Discovered Keys	Permanent Dependencies	Discovered Dependencies
	Business Description	Encoding	Redefines
	eid	pid	tsa
	generations	Entity Name	Entity Schema Name
	Attributes	Rows	Row Min Len
	Row Max Len	Data Source	Connection Data
	Schema	Delimiter	Quote Char
	Sample Criteria	CrLf	Row Avg Length
	Pre-Processing Rule	Entity Priority	Unsigned Packed
	Charset	Endian	Quote Esc Char
	Entity State	Values	Permanent Keys

show_entity_names

OLE DB & ODBC
	Unique Entity Name	Entity ID	Entity Name
	eid (ODBC only)

show_entity_trend


Project ID	Project Name	Unique Entity Name
Entity ID	Entity Name	Entity Schema Name
Attributes	Rows	Values
Row Min Length	Row Max Length	Data Source
Connection Data	Encoding	Schema
Permanent Keys	Discovered Keys	Permanent Dependencies
Discovered Dependencies	Entity State	eid (ODBC only)
pid (ODBC Only)

show_failing_br


Entity	Entity ID	Rule Name
Description	Rule ID	Expression
Total Rows	Passing Threshold	Passing Rows
Passing Percent	Failing Rows	Failing Percent
Priority	Priority Description	Categories
Derived	Library	Status
Rows Processed	Date Created	Created By
Date Changed	Edited By	Grouping
Group Count	Group Limit	Group Function
Aggregating	Aggregate Method	Aggregate Function
Passing Aggregate	Failing Aggregate	Filtering
eid (ODBC only)

show_project

OLE DB
	Project ID	Name	Type
	Description	Created By	Date Created
	Edited By	Edited Date
ODBC
	Project ID	Name	Type
	Description	Created By	Date Created
	Edited By	Edited Date	pid
	proj_type

show_project_failing_br


Project Type	Project ID	Project Name
Entity	Entity ID	Rule Name
Description	Rule ID	Expression
Total Rows	Passing Threshold	Passing Rows
Passing Percent	Failing Rows	Failing Percent
Priority	Priority Description	Categories
Derived	Library	Status
Rows Processed	Date Created	Created By
Date Changed	Edited By	Grouping
Group Count	Group Limit	Group Function
Aggregating	Aggregate Method	Aggregate Function
Passing Aggregate	Failing Aggregate	Filtering

show_project_membership

OLE DB & ODBC
	Project ID	Entity ID

show_tsq_project_names

OLE DB & ODBC
	Unique Project Name	Project ID	Project Name
	eid (ODBC only)

view_attribute_decimal_values

OLE DB
	Frequency	Dist %	Length
	Soundex	Metaphone	Pattern
	Mask	Value	Percent Rank
	Row ID	Deviation
ODBC
	Frequency	Dist %	Length
	Soundex	Metaphone	Pattern
	Mask	Value	Percent Rank
	Row ID	Deviation	Entity ID
	Attribute ID	eid	aid
	max_rows	add_key

view_attribute_integer_values

OLE DB
	Value	Frequency	Dist %
	Length	Soundex	Metaphone
	Pattern	Mask	Percent Rank
	Row ID	Deviation
ODBC
	Entity ID	Attribute ID	eid
	aid	max_rows	add_key
	Value	Frequency	Dist%
	Length	Soundex	Metaphone
	Pattern	Mask	Percent Rank
	Deviation	Row ID

view_attribute_null_values_rows

OLE DB only	Non-default columns returned depend on the entity.
	Row	Row Length	Group Number
	Row Value Count

view_attribute_string_values

OLE DB
	Value	Frequency	Dist %
	Length	Soundex	Metaphone
	Pattern	Mask	Percent Rank
	Row Id	Deviation
ODBC
	Value	Frequency	Dist %
	Length	Soundex	Metaphone
	Pattern	Mask	Percent Rank
	Row ID	Deviation	Entity ID
	Attribute ID	eid	aid
	max_rows	add_key

view_attribute_values


Value	Frequency	Dist %
Length	Soundex	Metaphone
Pattern	Mask	Percent Rank
Deviation	Row ID

view_attribute_values_discovered_dependencies

OLE DB
	Lh Attrs	Rh Attr	Status
	Verified	Job	Quality %
	Confirming LR Values	Conflicting LH Values	Resolved %
	Conflicting Rows	Verified Date	Verified By
ODBC
	Status	Created By	Created Date
	Entity ID	Attribute ID	eid
	aid	max_rows	add_key
	Lh Attrs	Rh Attr	Verified
	Job	Quality %	Confirming LR Values
	Conflicting LH Values	Resolved %	Normalise Flag
	Conflicting Rows	Verified Date	Verified By
	Dependency Key

view_attribute_values_discovered_joins

OLE DB
	Status	Left Entity	Left Expression
	Right Entity	Right Expression	Matching Values
	Inner joined rows	Outer joined rows	Left Non-Matching Values
	Left Non-Matching Rows	Left outer joined rows	Right Non-Matching Values
	Right Non-Matching Rows	Right outer joined rows	Left Loaded Rows
	Left Filter	Left Selected Rows	Right Loaded Rows
	Right Filter	Right Selected Rows	Join Type
	Actual Cardinality	Inferred Cardinality	Exact Cardinality
	Match Best	Match Values	Match LHrows
	Match RHrows	Left Join Rows	Left Join Cardinality
	Right Join Rows	Right Join Cardinality	Analyzed Date
	Analyzed By	Created By	Created Date
	Performed By	Performed Date	Edited By
	Edited Date	Note Count	Join Job
	Join Result Segment	Left No Matching Row Action	Right No Matching Row Action
ODBC
	Status	Created Date	Created By
	Entity ID	Attribute ID	eid
	aid	max_rows	add_key
	Left Entity Id	Left Attribute List	Right Entity Id
	Right Attribute List	Sequence	Left Entity
	Left Expression	Right Entity	Right Expression
	Matching Values	Inner joined rows	Outer joined rows
	Left Non-Matching Values	Left Non-Matching Rows	Left outer joined rows
	Right Non-Matching Values	Right Non-Matching Rows	Right outer joined rows
	Left Loaded Rows	Left Filter	Left Selected Rows
	Right Loaded Rows	Right Filter	Right Selected Rows
	Join Type	Actual Cardinality	Inferred Cardinality
	Exact Cardinality	Match Best	Match Values
	Match LHrows	Match RHrows	Left Join Rows
	Left Join Cardinality	Right Join Rows	Right Join Cardinality
	Join Card One One	Join Card One Many	Join Rows One Many
	Join Card Many One	Join Rows Many One	Join Card Many Many
	Join Rows Many Many	Analyzed Date	Analyzed By
	Performed By	Performed Date	Edited By
	Edited Date	Note Count	Join Job
	Join Index	Join Result Segment	Left No Matching Row Action
	Right No Matching Row Action	Join key

view_attribute_values_discovered_keys

OLE DB
	Lh Attrs	Status	Verified
	Ref	Quality %	Keys
	Duplicate Keys	Duplicate Rows	Verified Date
	Verified By
ODBC
	Lh Attrs	Status	Keys
	Verified	Ref	Quality %
	Duplicate Keys	Duplicate Rows	Verified Date
	Verified By	Created Date	Created By
	Entity ID	Attribute ID	eid
	aid	max_rows	add_key

view_attribute_values_mask

OLE DB
	Mask	Mask Stats	Value Count
	Frequency	Dist %
ODBC
	Mask	Mask Stats	Value Count
	Frequency	Dist %	Entity ID
	Attribute ID	eid	aid
	max_rows	add_key

view_attribute_values_metaphone

OLE DB
	Metaphone	Value Count	Frequency
	Dist %	Entity ID	Attribute ID
ODBC
	eid	aid	max_rows
	add_key	Metaphone	Value Count
	Frequency	Dist %	Entity ID
	Attribute ID

view_attribute_values_pattern

OLE DB
	Pattern	Value Length	Value Count
	Frequency	Dist %
ODBC
	Pattern	Value Length	Value Count
	Frequency	Dist %	Entity ID
	Attribute ID	eid	aid
	max_rows	add_key

view_attribute_values_permanent_dependencies

OLE DB
	Lh Attrs	Rh Attr	Status
	Verified	Job	Quality %
	Confirming LR Values	Conflicting LH Values	Resolved %
	Conflicting Rows	Verified Date	Verified By
ODBC
	Lh Attrs	Rh Attr	Quality %
	Status	Verified	Job
	Confirming LR Values	Conflicting LH Values	Resolved %
	Normalise Flag	Conflicting Rows	Verified Date
	Verified By	Created Date	Created By
	Dependency Key	Entity ID	Attribute ID
	eid	aid	max_rows
	add_key

view_attribute_values_permanent_joins

OLE DB
	Status	Left Entity	Left Expression
	Right Entity	Right Expression	Matching Values
	Inner joined rows	Outer joined rows	Left Non-Matching Values
	Left Non-Matching Rows	Left outer joined rows	Right Non-Matching Values
	Right Non-Matching Rows	Right outer joined rows	Left Loaded Rows
	Left Filter	Left Selected Rows	Right Loaded Rows
	Right Filter	Right Selected Rows	Join Type
	Actual Cardinality	Inferred Cardinality	Exact Cardinality
	Match Best	Match Values	Match LHrows
	Match RHrows	Left Join Rows	Left Join Cardinality
	Right Join Rows	Right Join Cardinality	Analyzed Date
	Analyzed By	Created By	Created Date
	Performed By	Performed Date	Edited By
	Edited Date	Note Count	Join Job
	Join Result Segment	Left No Matching Row Action	Right No Matching Row Action
	Left Entity ID	Left Attribute List	Right Entity ID
	Right Attribute List	Sequence	Join Index
	Join Key	Entity ID	Attribute ID
	Join Card One One	Join Card One Many	Join Rows One Many
	Join Card Many One	Join Rows Many One	Join Card Many Many
	Join Rows Many Many
ODBC
	Status	Created Date	Created By
	Entity ID	Attribute ID	eid
	aid	max_rows	add_key
	Left Entity Id	Left Attribute List	Right Entity Id
	Right Attribute List	Sequence	Left Entity
	Left Expression	Right Entity	Right Expression
	Matching Values	Inner joined rows	Outer joined rows
	Left Non-Matching Values	Left Non-Matching Rows	Left outer joined rows
	Right Non-Matching Values	Right Non-Matching Rows	Right outer joined rows
	Left Loaded Rows	Left Filter	Left Selected Rows
	Right Loaded Rows	Right Filter	Right Selected Rows
	Join Type	Actual Cardinality	Inferred Cardinality
	Exact Cardinality	Match Best	Match Values
	Match LHrows	Match RHrows	Left Join Rows
	Left Join Cardinality	Right Join Rows	Right Join Cardinality
	Join Card One One	Join Card One Many	Join Rows One Many
	Join Card Many One	Join Rows Many One	Join Card Many Many
	Join Rows Many Many	Analyzed Date	Analyzed By
	Performed By	Performed Date	Edited By
	Edited Date	Note Count	Join Job
	Join Index	Join Result Segment	Left No Matching Row Action
	Right No Matching Row Action	Join key

view_attribute_values_permanent_keys

OLE DB
	Lh Attrs	Status	Verified
	Ref	Quality %	Keys
	Duplicate Keys	Duplicate Rows	Verified Date
	Verified By
ODBC
	Lh Attrs	Status	Verified
	Ref	Quality %	Keys
	Duplicate Keys	Duplicate Rows	Verified Date
	Verified By	Created Date	Created By
	Entity ID	Attribute ID	eid
	aid	max_rows	add_key

view_attribute_values_soundex

OLE DB
	Soundex	Value Count	Frequency
	Dist %
ODBC
	Soundex	Value Count	Frequency
	Dist %	Entity ID	Attribute ID
	eid	aid	max_rows
	add_key

view_br_fail

OLE DB only	Non-default columns returned depend on the entity
	Row	Row Length	Group Number
	Row Value Count

view_entity_fail

OLE DB only	Non-default columns returned depend on the entity
	Row	Row Length	Group Number
	Row Value Count

view_entity_values


Status	Verified	Lh Attrs
Ref	Quality %	Keys
Verified Date	Duplicate Keys	Duplicate Rows
Created Date	Created By	Verified By

view_entity_values_discovered_dependencies

OLE DB
	Lh Attrs	Rh Attr	Status
	Verified	Job	Quality %
	Confirming LR Values	Conflicting LH Values	Resolved %
	Conflicting Rows	Verified Date	Verified By
	Entity ID	Normalise Flag	Dependency Key
ODBC
	Lh Attrs	Rh Attr	Status
	Verified	Job	Quality %
	Confirming LR Values	Conflicting LH Values	Resolved %
	Normalise Flag	Conflicting Rows	Verified Date
	Verified By	Created Date	Created By
	Dependency Key	Entity ID	eid
	pid	tsa	generations
	max_rows	add_key

view_entity_values_discovered_joins

OLE DB
	Status	Left Entity	Left Expression
	Right Entity	Right Expression	Matching Values
	Inner joined rows	Outer joined rows	Left Non-Matching Values
	Left Non-Matching Rows	Left outer joined rows	Right Non-Matching Values
	Right Non-Matching Rows	Right outer joined rows	Left Loaded Rows
	Left Filter	Left Selected Rows	Right Loaded Rows
	Right Filter	Right Selected Rows	Join Type
	Actual Cardinality	Inferred Cardinality	Exact Cardinality
	Match Best	Match Values	Match LHrows
	Match RHrows	Left Join Rows	Left Join Cardinality
	Right Join Rows	Right Join Cardinality	Analyzed Date
	Analyzed By	Created By	Created Date
	Performed By	Performed Date	Edited By
	Edited Date	Note Count	Join Job
	Join Result Segment	Left No Matching Row Action	Right No Matching Row Action
ODBC
	Status	Entity ID	Left Entity Id
	Left Attribute List	Right Entity Id	Right Attribute List
	Sequence	Left Entity	Left Expression
	Right Entity	Right Expression	Matching Values
	Inner joined rows	Outer joined rows	Left Non-Matching Values
	Left Non-Matching Rows	Left outer joined rows	Right Non-Matching Values
	Right Non-Matching Rows	Right outer joined rows	Left Loaded Rows
	Left Filter	Left Selected Rows	Right Loaded Rows
	Right Filter	Right Selected Rows	Join Type
	Actual Cardinality	Inferred Cardinality	Exact Cardinality
	Match Best	Match Values	Match LHrows
	Match RHrows	Left Join Rows	Left Join Cardinality
	Right Join Rows	Right Join Cardinality	Join Card One One
	Join Card One Many	Join Rows One Many	Join Card Many One
	Join Rows Many One	Join Card Many Many	Join Rows Many Many
	Analyzed Date	Analyzed By	Created By
	Created Date	Performed By	Performed Date
	Edited By	Edited Date	Note Count
	Join Job	Join Index	Join Result Segment
	Left No Matching Row Action	Right No Matching Row Action	Join key
	eid	pid	tsa
	generations	max_rows	add_key

view_entity_values_discovered_keys

OLE DB
	Lh Attrs	Status	Verified
	Ref	Quality %	Keys
	Duplicate Keys	Duplicate Rows	Verified Date
	Verified By
ODBC
	Lh Attrs	Status	Verified
	Ref	Quality %	Keys
	Duplicate Keys	Duplicate Rows	Verified Date
	Verified By	Created Date	Created By
	Entity ID	eid	pid
	tsa	generations	max_rows
	add_key

view_entity_values_permanent_dependencies

OLE DB
	Status	Lh Attrs	Rh Attr
	Verified	Job	Quality %
	Confirming LR Values	Conflicting LH Values	Resolved %
	Conflicting Rows	Verified Date	Verified By
	Dependency Key	Normalise Flag	Create Date
	Created By	Entity ID
ODBC
	Status	Lh Attrs	Rh Attr
	Verified	Job	Quality %
	Confirming LR Values	Conflicting LH Values	Resolved %
	Normalise Flag	Conflicting Rows	Verified Date
	Verified By	Created Date	Created By
	Dependency Key	Entity ID	eid
	pid	tsa	generations
	max_rows	add_key

view_entity_values_permanent_joins

OLE DB
	Status	Left Entity	Left Expression
	Right Entity	Right Expression	Matching Values
	Inner joined rows	Outer joined rows	Left Non-Matching Values
	Left Non-Matching Rows	Left outer joined rows	Right Non-Matching Values
	Right Non-Matching Rows	Right outer joined rows	Left Loaded Rows
	Left Filter	Left Selected Rows	Right Loaded Rows
	Right Filter	Right Selected Rows	Join Type
	Actual Cardinality	Inferred Cardinality	Exact Cardinality
	Match Best	Match Values	Match LHrows
	Match RHrows	Left Join Rows	Left Join Cardinality
	Right Join Rows	Right Join Cardinality	Analyzed Date
	Analyzed By	Created By	Created Date
	Performed By	Performed Date	Edited By
	Edited Date	Note Count	Join Job
	Join Result Segment	Left No Matching Row Action	Right No Matching Row Action
ODBC
	Left Entity Id	Left Attribute List	Right Entity Id
	Right Attribute List	Sequence	Status
	Left Entity	Left Expression	Right Entity
	Right Expression	Matching Values	Inner joined rows
	Outer joined rows	Left Non-Matching Values	Left Non-Matching Rows
	Left outer joined rows	Right Non-Matching Values	Right Non-Matching Rows
	Right outer joined rows	Left Loaded Rows	Left Filter
	Left Selected Rows	Right Loaded Rows	Right Filter
	Right Selected Rows	Join Type	Actual Cardinality
	Inferred Cardinality	Exact Cardinality	Match Best
	Match Values	Match LHrows	Match RHrows
	Left Join Rows	Left Join Cardinality	Right Join Rows
	Right Join Cardinality	Join Card One One	Join Card One Many
	Join Rows One Many	Join Card Many One	Join Rows Many One
	Join Card Many Many	Join Rows Many Many	Analyzed Date
	Analyzed By	Created By	Created Date
	Performed By	Performed Date	Edited By
	Edited Date	Note Count	Join Job
	Join Index	Join Result Segment	Left No Matching Row Action
	Right No Matching Row Action	Join key	Entity ID
	eid	pid	tsa
	generations	max_rows	add_key

view_entity_values_permanent_keys

OLE DB
	Lh Attrs	Status	Verified
	Ref	Quality %	Keys
	Duplicate Keys	Duplicate Rows	Verified Date
	Verified By	Created Date	Created By
	Entity ID
ODBC
	Lh Attrs	Status	Verified
	Ref	Quality %	Keys
	Duplicate Keys	Duplicate Rows	Verified Date
	Verified By	Created Date	Created By
	Entity ID	eid	pid
	tsa	generations	max_rows
	add_key	Rh Attr Id	Lh Attr Id

view_notes


Type	Name	Subject
Metrics	Class	Subclass
Project Impact	Business Impact	Created By
Created Date	Text

view_rows

OLE DB only	Non-default columns returned depend on the entity
	Row	Row Length	Group Number
	Row Value Count

Queries Table - trillium_discovery - trillium_quality - 17.1

Trillium Reporting Adapter for Excel Guide