Execution Report for Verification

Summary

Report AttributeValue
ProjectTest units
Report Created28-Oct-2016 13:59
DTM Data Scrubber version 1.15.06, build: Oct 8 2016 08:35:08, UNICODE, x86
Database ConnectionConnected to SQL Server Native Client 11.0: .///NorthwindOld [Local Northwind DB]
Database System and VersionMicrosoft SQL Server [ 10.50.2550 ]

Table 'dbo.Categories'

RowNo Primary KeyColumn NameWrong ValueApplied Rule
1CategoryID23302ID in range [8;60]
2CategoryID23303ID in range [8;60]
3CategoryID23304ID in range [8;60]
4CategoryID23305ID in range [8;60]
5CategoryID23306ID in range [8;60]
6CategoryID23307ID in range [8;60]
7CategoryID23308ID in range [8;60]
8CategoryID23309ID in range [8;60]
9CategoryID23310ID in range [8;60]
10CategoryID23311ID in range [8;60]
11CategoryID23312ID in range [8;60]
12CategoryID23313ID in range [8;60]
13CategoryID23314ID in range [8;60]
14CategoryID23315ID in range [8;60]
15CategoryID23316ID in range [8;60]
16CategoryID23317ID in range [8;60]
17CategoryID23318ID in range [8;60]
18CategoryID23319ID in range [8;60]
19CategoryID23320ID in range [8;60]
20CategoryID23321ID in range [8;60]

Table 'dbo.Employees'

RowNo Primary KeyColumn NameWrong ValueApplied Rule
4BirthDate1948-12-16 02:52:03.000Expect less 60 y.o.
7BirthDate1946-07-23 08:14:29.000Expect less 60 y.o.
10BirthDate1944-01-29 12:02:11.000Expect less 60 y.o.
12BirthDate1951-07-29 12:59:17.000Expect less 60 y.o.
15BirthDate1945-02-09 08:23:00.000Expect less 60 y.o.
16BirthDate1938-07-01 07:44:56.000Expect less 60 y.o.
17BirthDate1939-03-19 01:12:52.000Expect less 60 y.o.
18BirthDate1951-11-19 08:50:53.000Expect less 60 y.o.
19BirthDate1949-05-09 02:11:35.000Expect less 60 y.o.
21BirthDate1945-07-28 08:48:15.000Expect less 60 y.o.
22BirthDate1952-06-29 09:01:05.000Expect less 60 y.o.
26BirthDate1949-08-30 04:27:07.000Expect less 60 y.o.
31BirthDate1942-04-21 08:54:21.000Expect less 60 y.o.
33BirthDate1937-11-11 16:23:57.000Expect less 60 y.o.
35BirthDate1945-09-21 12:01:14.000Expect less 60 y.o.
36BirthDate1943-02-07 22:45:59.000Expect less 60 y.o.
38BirthDate1946-03-20 12:57:04.000Expect less 60 y.o.
39BirthDate1938-02-07 16:14:22.000Expect less 60 y.o.
40BirthDate1942-04-24 22:21:35.000Expect less 60 y.o.
45BirthDate1941-11-16 12:00:03.000Expect less 60 y.o.