Database View Reference

Back Next

IDPV_DATA_DOMAIN_DETAILS

This view exposes the latest data domain discovery results from the enterprise discovery results of a profile model.

The following table describes the columns in the IDPV_DATA_DOMAIN_DETAILS view:

Column	Description
PROFILE_MODEL_ID*	ID of the profile model.
PROFILE_TASK_ID	ID of the profile task.
PROFILE_TASK_NAME	Name of the profile task.
PROFILEABLE_RECORD_ID	ID of the source in the profile definition.
PROFILEABLE_RECORD_NAME	Name of the source in the profile definition.
SOURCE_NAME	Name of the data source.
SOURCE_ID	ID of the data source.
CONNECTION_NAME	Name of the connection.
ROW_IDENTIFIER	System-generated row ID.
FIELD_NAME	Name of the data source column.
NATIVE_FIELD_TYPE	Specified datatype for the FIELD_NAME column for data source import.
DATA_DOMAIN_TYPE	Type of data domain inference.
DATA_DOMAIN_NAME	Name of the data domain.
SATISFIED_COUNT	The number of rows that match data domain conformance percentage.
SATISFIED_COUNT_PERCENT	The number of rows that match data domain conformance percentage, expressed as a percentage of the total number of rows.
NULL_COUNT	The number of null values in the data source.
NULL_COUNT_PERCENT	The number of null values in the data source, expressed as a percentage of the total number of rows.
TOTAL_ROWS	The total number of rows in the data source.
LAST_TIME_RUN	Date and time of the last profile model run.
DATA_DOMAIN_KEY	ID of the data domain.
*Indicates that the column is a key column.