# Checkr schema ERD

Table and field reference for the Fivetran Checkr connector.

## Table & Field Reference

### school

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| address_unit | Unknown |  |
| address_zipcode | Unknown |  |
| current | Unknown |  |
| degree | Unknown |  |
| end_date | Unknown |  |
| major | Unknown |  |
| minor | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| phone | Unknown |  |
| school_url | Unknown |  |
| start_date | Unknown |  |
| uri | Unknown |  |
| year_awarded | Unknown |  |

### candidate_geo

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| geo_id | Unknown |  |

### candidate_report

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| report_id | Unknown | FK |

### candidate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adjudication | Unknown |  |
| copy_requested | Unknown |  |
| created_at | Unknown |  |
| dob | Unknown |  |
| driver_license_number | Unknown |  |
| driver_license_state | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| locale | Unknown |  |
| middle_name | Unknown |  |
| mother_maiden_name | Unknown |  |
| no_middle_name | Unknown |  |
| object | Unknown |  |
| phone | Unknown |  |
| previous_driver_license_number | Unknown |  |
| previous_driver_license_state | Unknown |  |
| ssn | Unknown |  |
| updated_at | Unknown |  |
| uri | Unknown |  |
| zipcode | Unknown |  |
| custom_** |  |  |

### account_available_screening

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| available_screening | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_deauthorization_reason | Unknown |  |
| adverse_action_email | Unknown |  |
| api_authorized | Unknown |  |
| authorized | Unknown |  |
| billing_email | Unknown |  |
| company_city | Unknown |  |
| company_dba_name | Unknown |  |
| company_incorporation_state | Unknown |  |
| company_incorporation_type | Unknown |  |
| company_industry | Unknown |  |
| company_name | Unknown |  |
| company_phone | Unknown |  |
| company_state | Unknown |  |
| company_street | Unknown |  |
| company_website | Unknown |  |
| company_zipcode | Unknown |  |
| compliance_contact_email | Unknown |  |
| created_at | Unknown |  |
| default_compliance_city | Unknown |  |
| default_compliance_state | Unknown |  |
| geos_required | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| purpose | Unknown |  |
| segmentation_enabled | Unknown |  |
| support_email | Unknown |  |
| support_phone | Unknown |  |
| technical_contact_email | Unknown |  |
| uri | Unknown |  |
| uri_name | Unknown |  |

### package_screening

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| package_id | Unknown | PK, FK |
| subtype | Unknown |  |
| type | Unknown |  |

### package_enabled_exam_service

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| package_enabled_exam_index | Unknown | PK, FK |
| package_id | Unknown | PK, FK |
| counter_part_slug | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |

### package_enabled_exam

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| package_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |
| screening_type | Unknown |  |

### package

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| apply_url | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| drug_screening_price | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| price | Unknown |  |
| requires_observed_drug_test | Unknown |  |
| slug | Unknown |  |
| uri | Unknown |  |

### report_address

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| report_id | Unknown | FK |
| city | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |

### continuous_check_work_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| continuous_check_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| state | Unknown |  |

### continuous_check

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| created_at | Unknown |  |
| node | Unknown |  |
| object | Unknown |  |
| type | Unknown |  |

### invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| report_id | Unknown | FK |
| archived | Unknown |  |
| archived_info_time | Unknown |  |
| archived_info_user_email | Unknown |  |
| archived_info_user_id | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| expires_at | Unknown |  |
| invitation_url | Unknown |  |
| locale | Unknown |  |
| object | Unknown |  |
| package | Unknown |  |
| status | Unknown |  |
| tags | Json |  |
| uri | Unknown |  |

### adverse_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| assessment_rule_name | Unknown |  |
| assessment_rule_type | Unknown |  |
| assessment_value | Unknown |  |
| object | Unknown |  |
| text | Unknown |  |

### users_role

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| users_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| full_name | Unknown |  |

### program_package

| Column | Type | Keys |
| --- | --- | --- |
| package_id | Unknown | PK |
| program_id | Unknown | PK, FK |

### program_geo

| Column | Type | Keys |
| --- | --- | --- |
| geo_id | Unknown | PK |
| program_id | Unknown | PK, FK |

### program

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |

### verification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | FK |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| object | Unknown |  |
| processed_at | Unknown |  |
| uri | Unknown |  |
| verification_type | Unknown |  |
| verification_url | Unknown |  |

### subscription_work_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| state | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| canceled_at | Unknown |  |
| created_at | Unknown |  |
| interval_count | Unknown |  |
| interval_unit | Unknown |  |
| next_occurrence_date | Unknown |  |
| node | Unknown |  |
| object | Unknown |  |
| package | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| uri | Unknown |  |

### driver_license_issued_date

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| driver_license_id | Unknown | PK, FK |
| source | Unknown |  |
| value | Unknown |  |

### driver_license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| current | Unknown |  |
| number | Unknown |  |
| object | Unknown |  |
| state | Unknown |  |
| uri | Unknown |  |

### report_county_criminal_search_record_charge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| county_criminal_report_id | Unknown | PK, FK |
| county_criminal_search_id | Unknown | PK, FK |
| record_id | Unknown | PK, FK |
| arrest_date | Unknown |  |
| assessment | Unknown |  |
| charge | Unknown |  |
| charge_date | Unknown |  |
| charge_id | Unknown |  |
| charge_type | Unknown |  |
| classification | Unknown |  |
| conviction_date | Unknown |  |
| court | Unknown |  |
| defendant | Unknown |  |
| deposition | Unknown |  |
| deposition_date | Unknown |  |
| disposition | Unknown |  |
| disposition_date | Unknown |  |
| id | Unknown |  |
| jail_time | Unknown |  |
| next_court_date | Unknown |  |
| offense_date | Unknown |  |
| plaintiff | Unknown |  |
| plea | Unknown |  |
| prison_time | Unknown |  |
| probation_status | Unknown |  |
| probation_time | Unknown |  |
| release_date | Unknown |  |
| restitution | Unknown |  |
| sentence | Unknown |  |
| sentence_date | Unknown |  |

### report_county_criminal_search_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| county_criminal_report_id | Unknown | PK, FK |
| county_criminal_search_id | Unknown | PK, FK |
| address | Unknown |  |
| arresting_agency | Unknown |  |
| case_number | Unknown |  |
| county | Unknown |  |
| court_jurisdiction | Unknown |  |
| court_of_record | Unknown |  |
| dob | Unknown |  |
| file_date | Unknown |  |
| filtered_by_positive_adjudication_charges | Json |  |
| full_name | Unknown |  |
| state | Unknown |  |
| yob | Unknown |  |

### report_county_criminal_search_screening_pointer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| county_criminal_report_id | Unknown | PK, FK |
| county_criminal_search_id | Unknown | PK, FK |
| screening_pointer | Unknown |  |

### report_county_criminal_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| assessment | Unknown |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| county | Unknown |  |
| created_at | Unknown |  |
| filtered_by_positive_adjudication_records | Json |  |
| object | Unknown |  |
| result | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |
| uri | Unknown |  |

### report_state_criminal_search_screening_pointer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| report_state_criminal_search_id | Unknown | PK, FK |
| screening_pointer | Unknown |  |

### report_state_criminal_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| assessment | Unknown |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| filtered_by_positive_adjudication_records | Json |  |
| in_lieu_of_county | Unknown |  |
| object | Unknown |  |
| records | Json |  |
| result | Unknown |  |
| state | Unknown |  |
| state_source_name | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |
| uri | Unknown |  |

### report_candidate_story

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |
| documents | Json |  |
| object | Unknown |  |
| record_case_number | Unknown |  |
| record_charge | Unknown |  |
| record_id | Unknown |  |
| record_location | Unknown |  |
| record_offense_date | Unknown |  |
| reviewed_at | Unknown |  |
| reviewer | Unknown |  |
| uri | Unknown |  |

### report_work_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| state | Unknown |  |

### report_federal_criminal_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| assessment | Unknown |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| filtered_by_positive_adjudication_records | Json |  |
| records | Json |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |

### report_international_global_watchlist_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| assessment | Unknown |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| pdf_url | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |

### report_international_employment_verification_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| verification_history_id | Unknown | PK, FK |
| candidate_employer_id | Unknown | FK |
| cancellation_reason | Unknown |  |
| candidate_explanation | Unknown |  |
| candidate_proof_requested_at | Unknown |  |
| contract_type | Unknown |  |
| contract_type_ignored | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| do_not_contact | Unknown |  |
| employment_verifiable_id | Unknown |  |
| employment_verifiable_type | Unknown |  |
| from_date | Unknown |  |
| from_date_ignored | Unknown |  |
| internal_state | Unknown |  |
| modifier_id | Unknown |  |
| name_commonality_lookup_cache | Json |  |
| name_first_name | Unknown |  |
| name_id | Unknown |  |
| name_last_name | Unknown |  |
| name_middle_name | Unknown |  |
| name_middle_name_rank | Unknown |  |
| name_suffix | Unknown |  |
| pdf_url | Unknown |  |
| position | Unknown |  |
| position_ignored | Unknown |  |
| provider | Unknown |  |
| provider_requested_at | Unknown |  |
| reason_for_leaving_ignored | Unknown |  |
| salary | Unknown |  |
| salary_ignored | Unknown |  |
| sent_to_qa_at | Unknown |  |
| status | Unknown |  |
| task_id | Unknown |  |
| to_date | Unknown |  |
| to_date_ignored | Unknown |  |
| updated_at | Unknown |  |
| version | Unknown |  |

### report_international_employment_verification_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| verification_history_id | Unknown | PK, FK |
| employer_id | Unknown | FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| events | Json |  |
| pdf_url | Unknown |  |
| result_contract_type_comment | Unknown |  |
| result_contract_type_ignored | Unknown |  |
| result_contract_type_verified | Unknown |  |
| result_dot_compliant | Unknown |  |
| result_end_date_comment | Unknown |  |
| result_end_date_ignored | Unknown |  |
| result_end_date_verified | Unknown |  |
| result_question | Json |  |
| result_reason_for_leaving_comment | Unknown |  |
| result_reason_for_leaving_ignored | Unknown |  |
| result_reason_for_leaving_verified | Unknown |  |
| result_salary_comment | Unknown |  |
| result_salary_ignored | Unknown |  |
| result_salary_verified | Unknown |  |
| result_start_date_comment | Unknown |  |
| result_start_date_ignored | Unknown |  |
| result_start_date_verified | Unknown |  |
| status | Unknown |  |

### report_international_employment_verification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| assessment | Unknown |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |

### report_international_adverse_media_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| pdf_url | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |

### report_international_education_verification_record_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| record_id | Unknown | PK, FK |
| report_id | Unknown | PK, FK |
| verification_id | Unknown | PK, FK |
| created_at | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |

### report_international_education_verification_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| verification_id | Unknown | PK, FK |
| school_id | Unknown | FK |
| country | Unknown |  |
| pdf_url | Unknown |  |
| result_verified | Unknown |  |
| status | Unknown |  |

### report_international_education_verification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |

### report_international_identity_document_validation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| pdf_url | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |

### report_international_motor_vehicle_license_info

| Column | Type | Keys |
| --- | --- | --- |
| license_number | Unknown | PK, FK |
| report_id | Unknown | PK, FK |
| report_international_motor_vehicle_license_index | Unknown | PK, FK |
| vehicle_id | Unknown | PK, FK |
| country | Unknown |  |
| expiration_date | Unknown |  |
| is_current | Unknown |  |
| license_class | Unknown |  |
| sub_division | Unknown |  |

### report_international_motor_vehicle_license_violation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| report_international_motor_vehicle_license_index | Unknown | PK, FK |
| vehicle_id | Unknown | PK, FK |
| description | Unknown |  |
| issued_date | Unknown |  |

### report_international_motor_vehicle_license

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| vehicle_id | Unknown | PK, FK |
| actual_license_class | Unknown |  |
| is_valid_license_class | Unknown |  |
| license_status | Unknown |  |

### report_international_motor_vehicle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| pdf_url | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |

### report_international_criminal_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| pdf_url | Unknown |  |
| record | Unknown |  |
| result | Unknown |  |
| result_sub_status | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |

### report_segment_stamp

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| segment_stamp | Unknown |  |

### report_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| content_type | Unknown |  |
| created_at | Unknown |  |
| download_uri | Unknown |  |
| filename | Unknown |  |
| filesize | Unknown |  |
| locale | Unknown |  |
| object | Unknown |  |
| type | Unknown |  |

### report_global_watchlist_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| assessment | Unknown |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| object | Unknown |  |
| records | Json |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |
| uri | Unknown |  |

### report_terrorist_watchlist_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| assessment | Unknown |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| object | Unknown |  |
| records | Json |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |
| uri | Unknown |  |

### report_ssn_trace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| addresses | Json |  |
| aliases | Json |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| data_mismatch | Unknown |  |
| death_index | Unknown |  |
| dob_mismatch | Unknown |  |
| fake_ssn | Unknown |  |
| invalid_issuance_year | Unknown |  |
| issued_state | Unknown |  |
| issued_year | Unknown |  |
| name_mismatch | Unknown |  |
| no_data | Unknown |  |
| object | Unknown |  |
| result | Unknown |  |
| ssn | Unknown |  |
| ssn_already_taken | Unknown |  |
| status | Unknown |  |
| thin_file | Unknown |  |
| turnaround_time | Unknown |  |
| uri | Unknown |  |

### report_geo

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |

### report_sex_offender_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| object | Unknown |  |
| records | Json |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |
| uri | Unknown |  |

### report_national_criminal_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| filtered_by_positive_adjudication_records | Json |  |
| object | Unknown |  |
| records | Json |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |
| uri | Unknown |  |

### report_motor_vehicle_restriction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_motor_vehicle_id | Unknown | PK, FK |
| report_motor_vehicle_report_id | Unknown | PK, FK |
| restriction | Unknown |  |

### report_motor_vehicle_violation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_motor_vehicle_id | Unknown | PK, FK |
| report_motor_vehicle_report_id | Unknown | PK, FK |
| acd_code | Unknown |  |
| alternate_description | Unknown |  |
| category | Unknown |  |
| city | Unknown |  |
| conviction_date | Unknown |  |
| county | Unknown |  |
| court_name | Unknown |  |
| description | Unknown |  |
| disposition | Unknown |  |
| docket | Unknown |  |
| issued_date | Unknown |  |
| points | Unknown |  |
| reinstatement_date | Unknown |  |
| state | Unknown |  |
| state_code | Unknown |  |
| ticket_number | Unknown |  |
| type | Unknown |  |

### report_motor_vehicle_suspension

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_motor_vehicle_id | Unknown | PK, FK |
| report_motor_vehicle_report_id | Unknown | PK, FK |
| description | Unknown |  |
| end_date | Unknown |  |
| groups | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |

### report_motor_vehicle_accident

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_motor_vehicle_id | Unknown | PK, FK |
| report_motor_vehicle_report_id | Unknown | PK, FK |
| accident_date | Unknown |  |
| acd_code | Unknown |  |
| action_taken | Unknown |  |
| category | Unknown |  |
| city | Unknown |  |
| county | Unknown |  |
| description | Unknown |  |
| enforcing_agency | Unknown |  |
| fatality_accident | Unknown |  |
| fatality_count | Unknown |  |
| fine_amount | Unknown |  |
| groups | Unknown |  |
| injury_accident | Unknown |  |
| injury_count | Unknown |  |
| jurisdiction | Unknown |  |
| license_plate | Unknown |  |
| note | Unknown |  |
| order_number | Unknown |  |
| points | Unknown |  |
| policy_number | Unknown |  |
| reinstatement_date | Unknown |  |
| report_number | Unknown |  |
| severity | Unknown |  |
| state | Unknown |  |
| state_code | Unknown |  |
| ticket_number | Unknown |  |
| vehicle_speed | Unknown |  |
| vehicles_involved_count | Unknown |  |
| violation_number | Unknown |  |

### report_motor_vehicle_miscellaneous_incident

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_motor_vehicle_id | Unknown | PK, FK |
| report_motor_vehicle_report_id | Unknown | PK, FK |
| date | Unknown |  |
| description | Unknown |  |

### report_motor_vehicle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| custom_rules | Json |  |
| dob | Unknown |  |
| endorsements | Json |  |
| experience_failed | Unknown |  |
| expiration_date | Unknown |  |
| first_issued_date | Unknown |  |
| full_name | Unknown |  |
| inferred_issued_date | Unknown |  |
| issued_date | Unknown |  |
| license_class | Unknown |  |
| license_number | Unknown |  |
| license_state | Unknown |  |
| license_status | Unknown |  |
| license_type | Unknown |  |
| not_found | Unknown |  |
| object | Unknown |  |
| previous_license_number | Unknown |  |
| previous_license_state | Unknown |  |
| privilege_to_drive | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |
| uri | Unknown |  |

### report_drug_screening_analyte

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_drug_screening_id | Unknown | PK, FK |
| report_drug_screening_report_id | Unknown | PK, FK |
| disposition | Unknown |  |
| name | Unknown |  |
| quantity | Unknown |  |
| slug | Unknown |  |
| specimen_type | Unknown |  |

### report_drug_screening_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_drug_screening_id | Unknown | PK, FK |
| report_drug_screening_report_id | Unknown | PK, FK |
| created_at | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |

### report_drug_screening

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_id | Unknown | PK, FK |
| appointment_id | Unknown |  |
| appointment_updateable | Unknown |  |
| cancellation_reason | Unknown |  |
| cancellation_reason_description | Unknown |  |
| disposition | Unknown |  |
| location_city | Unknown |  |
| location_distance | Unknown |  |
| location_distance_unit | Unknown |  |
| location_electronically_enabled | Unknown |  |
| location_fax_number | Unknown |  |
| location_hours_closed_for_lunch_friday | Unknown |  |
| location_hours_closed_for_lunch_monday | Unknown |  |
| location_hours_closed_for_lunch_saturday | Unknown |  |
| location_hours_closed_for_lunch_sunday | Unknown |  |
| location_hours_closed_for_lunch_thursday | Unknown |  |
| location_hours_closed_for_lunch_tuesday | Unknown |  |
| location_hours_closed_for_lunch_wednesday | Unknown |  |
| location_hours_closed_friday | Unknown |  |
| location_hours_closed_monday | Unknown |  |
| location_hours_closed_saturday | Unknown |  |
| location_hours_closed_sunday | Unknown |  |
| location_hours_closed_thursday | Unknown |  |
| location_hours_closed_tuesday | Unknown |  |
| location_hours_closed_wednesday | Unknown |  |
| location_hours_friday_hours_close | Unknown |  |
| location_hours_friday_hours_open | Unknown |  |
| location_hours_friday_lunch_from | Unknown |  |
| location_hours_friday_lunch_to | Unknown |  |
| location_hours_monday_hours_close | Unknown |  |
| location_hours_monday_hours_open | Unknown |  |
| location_hours_monday_lunch_from | Unknown |  |
| location_hours_monday_lunch_to | Unknown |  |
| location_hours_normal_hours_close | Unknown |  |
| location_hours_normal_hours_open | Unknown |  |
| location_hours_saturday_hours_close | Unknown |  |
| location_hours_saturday_hours_open | Unknown |  |
| location_hours_saturday_lunch_from | Unknown |  |
| location_hours_saturday_lunch_to | Unknown |  |
| location_hours_sunday_hours_close | Unknown |  |
| location_hours_sunday_hours_open | Unknown |  |
| location_hours_sunday_lunch_from | Unknown |  |
| location_hours_sunday_lunch_to | Unknown |  |
| location_hours_thursday_hours_close | Unknown |  |
| location_hours_thursday_hours_open | Unknown |  |
| location_hours_thursday_lunch_from | Unknown |  |
| location_hours_thursday_lunch_to | Unknown |  |
| location_hours_truck_access | Unknown |  |
| location_hours_tuesday_hours_close | Unknown |  |
| location_hours_tuesday_hours_open | Unknown |  |
| location_hours_tuesday_lunch_from | Unknown |  |
| location_hours_tuesday_lunch_to | Unknown |  |
| location_hours_twenty_four_hours | Unknown |  |
| location_hours_wednesday_hours_close | Unknown |  |
| location_hours_wednesday_hours_open | Unknown |  |
| location_hours_wednesday_lunch_from | Unknown |  |
| location_hours_wednesday_lunch_to | Unknown |  |
| location_latitude | Unknown |  |
| location_longitude | Unknown |  |
| location_metadata | Unknown |  |
| location_name | Unknown |  |
| location_phone_number | Unknown |  |
| location_state | Unknown |  |
| location_street | Unknown |  |
| location_unit | Unknown |  |
| location_zipcode | Unknown |  |
| mro_notes | Unknown |  |
| object | Unknown |  |
| order_id | Unknown |  |
| result | Unknown |  |
| screening_pass_expires_at | Unknown |  |
| status | Unknown |  |

### report_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_id | Unknown | PK, FK |
| tags | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| program_id | Unknown | FK |
| adjudication | Unknown |  |
| archived | Unknown |  |
| arrest_search | Unknown |  |
| assessment | Unknown |  |
| billing_entity | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| due_time | Unknown |  |
| estimated_completion_time | Unknown |  |
| facis_search | Unknown |  |
| federal_district_civil_search_ids | Json |  |
| federal_district_criminal_search_ids | Json |  |
| includes_canceled | Unknown |  |
| municipal_criminal_searches | Json |  |
| object | Unknown |  |
| package | Unknown |  |
| personal_reference_verifications | Json |  |
| pointer_state_criminal_searches | Json |  |
| professional_license_verifications | Json |  |
| professional_reference_verifications | Json |  |
| result | Unknown |  |
| revised_at | Unknown |  |
| self_disclosures | Json |  |
| skipped_screening_ids | Json |  |
| source | Unknown |  |
| status | Unknown |  |
| turnaround_time | Unknown |  |
| upgraded_at | Unknown |  |
| uri | Unknown |  |

### employer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| address_unit | Unknown |  |
| address_zipcode | Unknown |  |
| contract_type | Unknown |  |
| do_not_contact | Unknown |  |
| employer_url | Unknown |  |
| end_date | Unknown |  |
| manager_email | Unknown |  |
| manager_name | Unknown |  |
| manager_phone | Unknown |  |
| manager_title | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| position | Unknown |  |
| salary | Unknown |  |
| start_date | Unknown |  |
| uri | Unknown |  |

### assessment_result_assessed_object

| Column | Type | Keys |
| --- | --- | --- |
| object_id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| assessment_result_index | Unknown | PK, FK |
| object_type | Unknown |  |

### assessment_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| rule_name | Unknown |  |
| rule_type | Unknown |  |
| value | Unknown |  |

### assessment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| report_id | Unknown | FK |
| created_at | Unknown |  |
| id | Unknown |  |
| ruleset_name | Unknown |  |
| ruleset_version_number | Unknown |  |
| value | Unknown |  |

## Relationships

- school(candidate_id) → candidate(id)
- candidate_geo(candidate_id) → candidate(id)
- candidate_report(report_id) → report(id)
- candidate_report(candidate_id) → candidate(id)
- account_available_screening(account_id) → account(id)
- package_screening(package_id) → package(id)
- package_enabled_exam_service(package_id) → package_enabled_exam(package_id)
- package_enabled_exam_service(package_enabled_exam_index) → package_enabled_exam(index)
- package_enabled_exam(package_id) → package(id)
- report_address(report_id) → report(id)
- continuous_check_work_location(continuous_check_id) → continuous_check(id)
- continuous_check(candidate_id) → candidate(id)
- invitation(report_id) → report(id)
- invitation(candidate_id) → candidate(id)
- adverse_item(report_id) → report(id)
- users_role(users_id) → users(id)
- program_package(program_id) → program(id)
- program_geo(program_id) → program(id)
- verification(report_id) → report(id)
- subscription_work_location(subscription_id) → subscription(id)
- subscription(candidate_id) → candidate(id)
- driver_license_issued_date(driver_license_id) → driver_license(id)
- driver_license(candidate_id) → candidate(id)
- report_county_criminal_search_record_charge(record_id) → report_county_criminal_search_record(id)
- report_county_criminal_search_record_charge(county_criminal_search_id) → report_county_criminal_search_record(county_criminal_search_id)
- report_county_criminal_search_record_charge(county_criminal_report_id) → report_county_criminal_search_record(county_criminal_report_id)
- report_county_criminal_search_record(county_criminal_search_id) → report_county_criminal_search(id)
- report_county_criminal_search_record(county_criminal_report_id) → report_county_criminal_search(report_id)
- report_county_criminal_search_screening_pointer(county_criminal_report_id) → report_county_criminal_search(report_id)
- report_county_criminal_search_screening_pointer(county_criminal_search_id) → report_county_criminal_search(id)
- report_county_criminal_search(report_id) → report(id)
- report_state_criminal_search_screening_pointer(report_state_criminal_search_id) → report_state_criminal_search(id)
- report_state_criminal_search_screening_pointer(report_id) → report_state_criminal_search(report_id)
- report_state_criminal_search(report_id) → report(id)
- report_candidate_story(report_id) → report(id)
- report_work_location(report_id) → report(id)
- report_federal_criminal_search(report_id) → report(id)
- report_international_global_watchlist_search(report_id) → report(id)
- report_international_employment_verification_history(candidate_employer_id) → employer(id)
- report_international_employment_verification_history(verification_history_id) → report_international_employment_verification(id)
- report_international_employment_verification_history(report_id) → report_international_employment_verification(report_id)
- report_international_employment_verification_record(employer_id) → employer(id)
- report_international_employment_verification_record(verification_history_id) → report_international_employment_verification(id)
- report_international_employment_verification_record(report_id) → report_international_employment_verification(report_id)
- report_international_employment_verification(report_id) → report(id)
- report_international_adverse_media_search(report_id) → report(id)
- report_international_education_verification_record_event(record_id) → report_international_education_verification_record(id)
- report_international_education_verification_record_event(verification_id) → report_international_education_verification_record(verification_id)
- report_international_education_verification_record_event(report_id) → report_international_education_verification_record(report_id)
- report_international_education_verification_record(school_id) → school(id)
- report_international_education_verification_record(verification_id) → report_international_education_verification(id)
- report_international_education_verification_record(report_id) → report_international_education_verification(report_id)
- report_international_education_verification(report_id) → report(id)
- report_international_identity_document_validation(report_id) → report(id)
- report_international_motor_vehicle_license_info(license_number) → driver_license(id)
- report_international_motor_vehicle_license_info(report_international_motor_vehicle_license_index) → report_international_motor_vehicle_license(index)
- report_international_motor_vehicle_license_info(report_id) → report_international_motor_vehicle_license(report_id)
- report_international_motor_vehicle_license_info(vehicle_id) → report_international_motor_vehicle_license(vehicle_id)
- report_international_motor_vehicle_license_violation(report_international_motor_vehicle_license_index) → report_international_motor_vehicle_license(index)
- report_international_motor_vehicle_license_violation(report_id) → report_international_motor_vehicle_license(report_id)
- report_international_motor_vehicle_license_violation(vehicle_id) → report_international_motor_vehicle_license(vehicle_id)
- report_international_motor_vehicle_license(report_id) → report_international_motor_vehicle(report_id)
- report_international_motor_vehicle_license(vehicle_id) → report_international_motor_vehicle(id)
- report_international_motor_vehicle(report_id) → report(id)
- report_international_criminal_search(report_id) → report(id)
- report_segment_stamp(report_id) → report(id)
- report_document(report_id) → report(id)
- report_global_watchlist_search(report_id) → report(id)
- report_terrorist_watchlist_search(report_id) → report(id)
- report_ssn_trace(report_id) → report(id)
- report_geo(report_id) → report(id)
- report_sex_offender_search(report_id) → report(id)
- report_national_criminal_search(report_id) → report(id)
- report_motor_vehicle_restriction(report_motor_vehicle_report_id) → report_motor_vehicle(report_id)
- report_motor_vehicle_restriction(report_motor_vehicle_id) → report_motor_vehicle(id)
- report_motor_vehicle_violation(report_motor_vehicle_report_id) → report_motor_vehicle(report_id)
- report_motor_vehicle_violation(report_motor_vehicle_id) → report_motor_vehicle(id)
- report_motor_vehicle_suspension(report_motor_vehicle_report_id) → report_motor_vehicle(report_id)
- report_motor_vehicle_suspension(report_motor_vehicle_id) → report_motor_vehicle(id)
- report_motor_vehicle_accident(report_motor_vehicle_report_id) → report_motor_vehicle(report_id)
- report_motor_vehicle_accident(report_motor_vehicle_id) → report_motor_vehicle(id)
- report_motor_vehicle_miscellaneous_incident(report_motor_vehicle_report_id) → report_motor_vehicle(report_id)
- report_motor_vehicle_miscellaneous_incident(report_motor_vehicle_id) → report_motor_vehicle(id)
- report_motor_vehicle(report_id) → report(id)
- report_drug_screening_analyte(report_drug_screening_report_id) → report_drug_screening(report_id)
- report_drug_screening_analyte(report_drug_screening_id) → report_drug_screening(id)
- report_drug_screening_event(report_drug_screening_report_id) → report_drug_screening(report_id)
- report_drug_screening_event(report_drug_screening_id) → report_drug_screening(id)
- report_drug_screening(report_id) → report(id)
- report_tag(report_id) → report(id)
- report(program_id) → program(id)
- report(candidate_id) → candidate(id)
- employer(candidate_id) → candidate(id)
- assessment_result_assessed_object(assessment_result_index) → assessment_result(index)
- assessment_result_assessed_object(_fivetran_id) → assessment_result(_fivetran_id)
- assessment_result(_fivetran_id) → assessment(_fivetran_id)
- assessment(report_id) → report(id)