Release Notes

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. Also, see our Schema Migrations article for more details.

We are making these schema changes to introduce feature enhancements.

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	Deprecated 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: