Release Notes

April 2025

Effective April 23, 2025 we use a new April 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`REPORT_COUNTY_CRIMINAL_SEARCH_RECORD_CHARGE`
column	Primary Key Change	`id` 🔑	`id`	No longer primary key.
column	Primary Key Change		`index` 🔑	New primary key.

September 2024

We no longer capture deletes for the CANDIDATE table and its child tables.

Effective September 12, 2024 we use a new September 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

24 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name
`REPORT`
column	Discontinued Column	`geos`
column	New Column		`federal_district_civil_search_ids`
column	New Column		`federal_district_criminal_search_ids`
column	New Column		`skipped_screening_ids`
`REPORT_COUNTY_CRIMINAL_SEARCH`
column	New Column		`assessment`
`REPORT_FEDERAL_CRIMINAL_SEARCH`
table	New Table		`REPORT_FEDERAL_CRIMINAL_SEARCH`
`REPORT_GEO`
table	New Table		`REPORT_GEO`
`REPORT_GLOBAL_WATCHLIST_SEARCH`
column	New Column		`assessment`
`REPORT_INTERNATIONAL_ADVERSE_MEDIA_SEARCH`
table	New Table		`REPORT_INTERNATIONAL_ADVERSE_MEDIA_SEARCH`
`REPORT_INTERNATIONAL_CRIMINAL_SEARCH`
table	New Table		`REPORT_INTERNATIONAL_CRIMINAL_SEARCH`
`REPORT_INTERNATIONAL_EDUCATION_VERIFICATION`
table	New Table		`REPORT_INTERNATIONAL_EDUCATION_VERIFICATION`
`REPORT_INTERNATIONAL_EDUCATION_VERIFICATION_RECORD`
table	New Table		`REPORT_INTERNATIONAL_EDUCATION_VERIFICATION_RECORD`
`REPORT_INTERNATIONAL_EDUCATION_VERIFICATION_RECORD_EVENT`
table	New Table		`REPORT_INTERNATIONAL_EDUCATION_VERIFICATION_RECORD_EVENT`
`REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION`
table	New Table		`REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION`
`REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION_HISTORY`
table	New Table		`REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION_HISTORY`
`REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION_RECORD`
table	New Table		`REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION_RECORD`
`REPORT_INTERNATIONAL_GLOBAL_WATCHLIST_SEARCH`
table	New Table		`REPORT_INTERNATIONAL_GLOBAL_WATCHLIST_SEARCH`
`REPORT_INTERNATIONAL_IDENTITY_DOCUMENT_VALIDATION`
table	New Table		`REPORT_INTERNATIONAL_IDENTITY_DOCUMENT_VALIDATION`
`REPORT_INTERNATIONAL_MOTOR_VEHICLE`
table	New Table		`REPORT_INTERNATIONAL_MOTOR_VEHICLE`
`REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE`
table	New Table		`REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE`
`REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE_INFO`
table	New Table		`REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE_INFO`
`REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE_VIOLATION`
table	New Table		`REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE_VIOLATION`
`REPORT_STATE_CRIMINAL_SEARCH`
column	New Column		`assessment`
`REPORT_TERRORIST_WATCHLIST_SEARCH`
column	New Column		`assessment`

March 2024

We have renamed the ruleset_id column to id in the ASSESSMENT table .

We have changed the primary key of the ASSESSMENT table. The new primary key is the _fivetran_id column. Previously, the primary key was a combination of the report_id and ruleset_id columns.

We have changed the primary key of the REPORT_ADDRESS table. The new primary key is the _fivetran_id column. Previously, the primary key was a combination of the _fivetran_id and report_id columns.

We have changed the composite primary key of the ASSESSMENT_RESULT table. The new composite primary key is a combination of the index and _fivetran_id columns. Previously, we used the index, report_id, and ruleset_id columns as the composite primary key.

We have changed the composite primary key of the ASSESSMENT_RESULT_ASSESSED_OBJECT table. The new composite primary key is a combination of the object_id, assessment_result_index, and _fivetran_id columns. Previously, we used the index, assessment_result_index, report_id, and ruleset_id columns as the composite primary key.

February 2024

Lite connectors are now available for the following sources: