Target Match History

The DATA_TARGET_HISTORY table contains historical match count data for all Targets with a maximum granularity of a one day period. If there is more than one scan data point within a 24-hour period, the latest data point captured within that period will be retained.

Column Number	Key	Column Name	Data Type	Description
1	Yes	TUID	numeric NOT NULL	Target UID. See DATA_TARGET table for more information.
2	-	WHEN	timestamp NOT NULL	Timestamp when the data point was recorded.
3	-	QUANTITY	numeric NOT NULL	Sum of matches with data privacy breaches and matches containing prohibited PCI data; does not include test data matches.

Sample data:

TUID	WHEN	QUANTITY
6622288671022978211	3/9/2020 2:45:16 PM	7439
6622288671022978211	25/8/2020 2:35:05 PM	209800
7372383963774995752	3/9/2020 2:40:41 PM	9458
7372383963774995752	28/8/2020 2:27:31 PM	18902
8283249956251157105	23/7/2020 7:52:33 PM	2543586
8283249956251157105	17/7/2020 10:56:20 PM	3095985