Database View Reference

Back Next

IDPV_TOP_10_FREQUENCIES

This view exposes the ten most frequent values for all columns you ran a profile on.

The following table describes the columns in the IDPV_TOP_10_FREQUENCIES view:

Column	Description
PROFILE_ID*	ID of the profile.
PROFILE_NAME	Name of the profile.
FIELD_NAME	Name of the data source column.
FIELD_VALUE	Value in the FIELD_NAME column.
FREQUENCY_COUNT	Number of occurrences of the FIELD_VALUE in the FIELD_NAME column.
LAST_TIME_RUN	Date and time of the last profile run.
*Indicates that the column is a key column.