Skip to content

Completeness Tests

TestGen completeness tests verify that all required records and values are available with no missing information and that the data is 100% complete.

Description and details

Daily Records

Tests for presence of every calendar date within minimum and maximum date range, per baseline data.

The system automatically generates this test.

Monthly Records

Tests for presence of at least one date per calendar month within minimum and maximum date range, per baseline data.

The system automatically generates this test.

Percent Missing

Tests for statistically significant shift in percentage of missing values in column compared to baseline data.

The system automatically generates this test.

Required Entry

Tests that a non-null value is present in each record for the column, consistent with baseline data.

The system automatically generates this test.

Row Count

Tests that the count of records has not decreased from the baseline count.

This test is not auto-generated. You can create it manually from the Test Definitions page.

Row Range

Tests that the count of records is within a percentage above or below the baseline count.

This test is not auto-generated. You can create it manually from the Test Definitions page.

Volume Trend

Tests that row count of all or subset of records in a table is within tolerance range.

This test is not auto-generated. You can create it manually from the Test Definitions page.

Weekly Records

Tests for presence of at least one date per calendar week within minimum and maximum date range, per baseline data.

The system automatically generates this test.