About : the criteria_expiry view

The criteria_expiry materialized views are snapshots of a pivoted view of the criteria_state table within the nwc_history database provided with the data and analytics connector that contains information on all targets and their criteria

Each row represents a target (target ID) and the columns show the criteria ID number, criteria state, and criteria_expiry_date for each single criteria for a particular target group.

The criteria_expiry views are most commonly used to display a list of targets that have criteria outstanding so further action can be taken.