Paychex
Explore the interactive ERD
Table & Field Reference
worker_pay_component
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
worker_id | Unknown | PKFK |
calculation_base_id | Unknown | FK |
applied | Unknown | |
calculation_type | Unknown | |
classification_type | Unknown | |
component_id | Unknown | |
effect_on_pay | Unknown | |
effected_checks | Unknown | |
effective_date | Unknown | |
end_date | Unknown | |
interval_1 | Unknown | |
interval_2 | Unknown | |
name | Unknown | |
occurence | Unknown | |
start_date | Unknown | |
value | Unknown |
company_pay_frequency
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
company_id | Unknown | FK |
interval_1 | Unknown | |
interval_2 | Unknown | |
pay_component_frequency_applied | Unknown | |
pay_component_frequency_occurence | Unknown | |
pay_frequency | Unknown |
company_job_title
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
job_title_id | Unknown | FK |
end_date | Unknown | |
start_date | Unknown | |
title | Unknown |
worker_time_off
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
worker_id | Unknown | PKFK |
balance | Unknown | |
measure | Unknown | |
name | Unknown | |
type | Unknown |
worker_deposit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
worker_id | Unknown | PKFK |
account_number | Unknown | |
account_type | Unknown | |
direct_deposit_type | Unknown | |
payment_type | Unknown | |
priority | Unknown | |
routing_number | Unknown | |
start_date | Unknown | |
value | Unknown |
communication
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
company_id | Unknown | PKFK |
city | Unknown | |
type | Unknown | |
usage_type | Unknown |
company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
legal_id_type | Unknown | FK |
display_id | Unknown | |
has_permission | Unknown | |
legal_id_value | Unknown | |
legal_name | Unknown |
company_calculation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
calculation_base_name | Unknown |
worker_assignment
| Column | Type | Keys |
|---|---|---|
labor_assignment_id | Unknown | PKFK |
worker_id | Unknown | PKFK |
job_id | Unknown | |
value | Unknown |
worker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
job_title_id | Unknown | FK |
birth_date | Unknown | |
clock_id | Unknown | |
current_status_effective_date | Unknown | |
current_status_status_reason | Unknown | |
current_status_status_type | Unknown | |
employee_id | Unknown | |
employment_type | Unknown | |
ethnicity_code | Unknown | |
exemption_type | Unknown | |
hire_date | Unknown | |
job_id | Unknown | |
job_title | Unknown | |
labor_assignment_id | Unknown | |
legal_id | Unknown | |
legal_id_type | Unknown | |
location_id | Unknown | |
name_family_name | Unknown | |
name_given_name | Unknown | |
name_middle_name | Unknown | |
name_preferred_name | Unknown | |
name_qualification_affix_code | Unknown | |
name_title_affix_code | Unknown | |
organization_children | Unknown | |
organization_id | Unknown | |
organization_level | Unknown | |
organization_name | Unknown | |
organization_number | Unknown | |
sex | Unknown | |
supervisor_name_family_name | Unknown | |
supervisor_name_given_name | Unknown | |
supervisor_name_qualification_affix_code | Unknown | |
supervisor_worker_id | Unknown | |
work_state | Unknown | |
worker_corelation_id | Unknown | |
worker_status_id | Unknown | |
worker_type | Unknown |
worker_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
worker_id | Unknown | PKFK |
boolean_value | Unknown | |
check_stub | Unknown | |
custom_field_id | Unknown | |
custom_field_name | Unknown | |
date_value | Unknown | |
dropdown_id | Unknown | |
dropdown_value | Unknown | |
employee_editable | Unknown | |
numeric_value | Unknown | |
required | Unknown | |
text_value | Unknown | |
type | Unknown |
company_organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
organization_id | Unknown | FK |
level | Unknown | |
name | Unknown | |
number | Unknown |
pay_period
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
original_pay_period_id | Unknown | FK |
check_date | Instant | |
description | Unknown | |
end_date | Instant | |
interval_code | Unknown | |
start_date | Instant | |
status | Unknown | |
submit_by_date | Instant |
company_worker_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
status_reason | Unknown | |
status_type | Unknown |
company_job_segment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
name | Unknown | |
segment_length | Unknown |
worker_pay_standard
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
worker_id | Unknown | FK |
calculated_annual_salary | Unknown | |
calculated_pay_period | Unknown | |
overtime_factor | Unknown | |
pay_frequency | Unknown |
relationship_type
| Column | Type | Keys |
|---|---|---|
company_contact_type_id | Unknown | PK |
id | Unknown | PK |
relationship_type_name | Unknown |
company_contact_type
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
company_id | Unknown | FK |
contact_type_name | Unknown | |
id | Unknown |
company_labour_assignment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
location_id | Unknown | FK |
organization_id | Unknown | FK |
end_date | Unknown | |
name | Unknown | |
position_id | Unknown | |
start_date | Unknown |
company_check_earning
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_check_id | Unknown | PKFK |
company_id | Unknown | PKFK |
pay_period_id | Unknown | PKFK |
applies_to_worker_types | Json | |
calculation_type | Unknown | |
classification_type | Unknown | |
code | Unknown | |
component_id | Unknown | |
description | Unknown | |
effect_on_pay | Unknown | |
end_date | Instant | |
job_id | Unknown | |
labor_assignment_id | Unknown | |
line_date | Instant | |
memoed | Unknown | |
name | Unknown | |
organization_id | Unknown | |
pay_amount | Unknown | |
pay_hours | Unknown | |
pay_rate | Unknown | |
pay_rate_id | Unknown | |
pay_units | Unknown | |
start_date | Instant |
company_check_deduction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_check_id | Unknown | PKFK |
company_id | Unknown | PKFK |
pay_period_id | Unknown | PKFK |
applies_to_worker_types | Json | |
calculation_type | Unknown | |
classification_type | Unknown | |
code | Unknown | |
component_id | Unknown | |
description | Unknown | |
effect_on_pay | Unknown | |
end_date | Instant | |
job_id | Unknown | |
labor_assignment_id | Unknown | |
line_date | Instant | |
memoed | Unknown | |
name | Unknown | |
organization_id | Unknown | |
pay_amount | Unknown | |
pay_hours | Unknown | |
pay_rate | Unknown | |
pay_rate_id | Unknown | |
pay_units | Unknown | |
start_date | Instant |
company_check_tax
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_check_id | Unknown | PKFK |
company_id | Unknown | PKFK |
pay_period_id | Unknown | PKFK |
applies_to_worker_types | Json | |
calculation_type | Unknown | |
classification_type | Unknown | |
code | Unknown | |
component_id | Unknown | |
effect_on_pay | Unknown | |
end_date | Instant | |
job_id | Unknown | |
labor_assignment_id | Unknown | |
line_date | Instant | |
memoed | Unknown | |
name | Unknown | |
organization_id | Unknown | |
pay_amount | Unknown | |
pay_hours | Unknown | |
pay_rate | Unknown | |
pay_rate_id | Unknown | |
pay_units | Unknown | |
start_date | Instant |
company_check_informational
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_check_id | Unknown | PKFK |
company_id | Unknown | PKFK |
pay_period_id | Unknown | PKFK |
calculation_type | Unknown | |
classification_type | Unknown | |
code | Unknown | |
component_id | Unknown | |
effect_on_pay | Unknown | |
end_date | Instant | |
job_id | Unknown | |
labor_assignment_id | Unknown | |
line_date | Instant | |
memoed | Unknown | |
name | Unknown | |
organization_id | Unknown | |
pay_amount | Unknown | |
pay_hours | Unknown | |
pay_rate | Unknown | |
pay_rate_id | Unknown | |
pay_units | Unknown | |
start_date | Instant |
company_check
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
pay_period_id | Unknown | PK |
company_id | Unknown | PKFK |
worker_id | Unknown | FK |
block_auto_distribution | Unknown | |
check_correlation_id | Unknown | |
check_date | Instant |
worker_federal_tax
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
worker_id | Unknown | PKFK |
deductions_amount | Unknown | |
dependents_amount | Unknown | |
extra_withholding_amount | Unknown | |
filing_status | Unknown | |
multiple_job | Unknown | |
other_income | Unknown | |
taxes_withheld | Unknown |
worker_communication
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
worker_id | Unknown | PKFK |
city | Unknown | |
country_code | Unknown | |
country_subdivision_code | Unknown | |
dial_area | Unknown | |
dial_country | Unknown | |
dial_extension | Unknown | |
dial_number | Unknown | |
post_office_box | Unknown | |
postal_code | Unknown | |
postal_code_extension | Unknown | |
street_line_one | Unknown | |
street_line_two | Unknown | |
type | Unknown | |
uri | Unknown | |
usage_type | Unknown |
company_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
location_id | Unknown | FK |
city | Unknown | |
communication_id | Unknown | |
country_code | Unknown | |
country_subdivision_code | Unknown | |
dial_area | Unknown | |
dial_country | Unknown | |
dial_extension | Unknown | |
dial_number | Unknown | |
moved_in | Unknown | |
moved_out | Unknown | |
name | Unknown | |
post_office_box | Unknown | |
postal_code | Unknown | |
postal_code_extension | Unknown | |
street_line_one | Unknown | |
street_line_two | Unknown | |
type | Unknown | |
uri | Unknown | |
usage_type | Unknown |
worker_payrate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
worker_id | Unknown | PKFK |
amount | Unknown | |
defaults | Unknown | |
description | Unknown | |
effective_date | Unknown | |
in_progress_worker | Unknown | |
rate_number | Unknown | |
rate_type | Unknown | |
standard_hour | Unknown | |
standard_overtime | Unknown | |
start_date | Unknown |