Checkr
Explore the interactive ERD
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 | PKFK |
geo_id | Unknown |
candidate_report
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
candidate_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
subtype | Unknown | |
type | Unknown |
package_enabled_exam_service
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
package_enabled_exam_index | Unknown | PKFK |
package_id | Unknown | PKFK |
counter_part_slug | Unknown | |
label | Unknown | |
name | Unknown |
package_enabled_exam
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
package_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
program_geo
| Column | Type | Keys |
|---|---|---|
geo_id | Unknown | PK |
program_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
county_criminal_search_id | Unknown | PKFK |
record_id | Unknown | PKFK |
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 | PKFK |
county_criminal_search_id | Unknown | PKFK |
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 | PKFK |
county_criminal_search_id | Unknown | PKFK |
screening_pointer | Unknown |
report_county_criminal_search
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
report_id | Unknown | PKFK |
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 | PKFK |
report_state_criminal_search_id | Unknown | PKFK |
screening_pointer | Unknown |
report_state_criminal_search
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
report_id | Unknown | PKFK |
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 | PKFK |
city | Unknown | |
country | Unknown | |
state | Unknown |
report_federal_criminal_search
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
report_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
verification_history_id | Unknown | PKFK |
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 | PKFK |
verification_history_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
report_id | Unknown | PKFK |
verification_id | Unknown | PKFK |
created_at | Unknown | |
text | Unknown | |
type | Unknown |
report_international_education_verification_record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
report_id | Unknown | PKFK |
verification_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
report_id | Unknown | PKFK |
report_international_motor_vehicle_license_index | Unknown | PKFK |
vehicle_id | Unknown | PKFK |
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 | PKFK |
report_international_motor_vehicle_license_index | Unknown | PKFK |
vehicle_id | Unknown | PKFK |
description | Unknown | |
issued_date | Unknown |
report_international_motor_vehicle_license
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
report_id | Unknown | PKFK |
vehicle_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
segment_stamp | Unknown |
report_document
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
report_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
report_motor_vehicle_report_id | Unknown | PKFK |
restriction | Unknown |
report_motor_vehicle_violation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
report_motor_vehicle_id | Unknown | PKFK |
report_motor_vehicle_report_id | Unknown | PKFK |
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 | PKFK |
report_motor_vehicle_report_id | Unknown | PKFK |
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 | PKFK |
report_motor_vehicle_report_id | Unknown | PKFK |
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 | PKFK |
report_motor_vehicle_report_id | Unknown | PKFK |
date | Unknown | |
description | Unknown |
report_motor_vehicle
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
report_id | Unknown | PKFK |
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 | PKFK |
report_drug_screening_report_id | Unknown | PKFK |
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 | PKFK |
report_drug_screening_report_id | Unknown | PKFK |
created_at | Unknown | |
text | Unknown | |
type | Unknown |
report_drug_screening
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
report_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
assessment_result_index | Unknown | PKFK |
object_type | Unknown |
assessment_result
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
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 |