# Paychex schema ERD

Table and field reference for the Fivetran Paychex connector.

## Table & Field Reference

### worker_pay_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| worker_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| balance | Unknown |  |
| measure | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### worker_deposit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| worker_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| worker_id | Unknown | PK, FK |
| job_id | Unknown |  |
| value | Unknown |  |

### worker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| organization_id | Unknown | FK |
| level | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |

### pay_period

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| status_reason | Unknown |  |
| status_type | Unknown |  |

### company_job_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| company_id | Unknown | PK, FK |
| pay_period_id | Unknown | PK, FK |
| 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 | PK, FK |
| company_id | Unknown | PK, FK |
| pay_period_id | Unknown | PK, FK |
| 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 | PK, FK |
| company_id | Unknown | PK, FK |
| pay_period_id | Unknown | PK, FK |
| 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 | PK, FK |
| company_id | Unknown | PK, FK |
| pay_period_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- worker_pay_component(calculation_base_id) → company_calculation(id)
- worker_pay_component(worker_id) → worker(id)
- company_pay_frequency(company_id) → company(id)
- company_job_title(job_title_id) → worker(job_title_id)
- company_job_title(company_id) → company(id)
- worker_time_off(worker_id) → worker(id)
- worker_deposit(worker_id) → worker(id)
- communication(company_id) → company(id)
- company(legal_id_type) → worker(legal_id_type)
- worker_assignment(labor_assignment_id) → company_labour_assignment(id)
- worker_assignment(worker_id) → worker(id)
- worker(job_title_id) → company_job_title(id)
- worker(company_id) → company(id)
- worker_custom_field(worker_id) → worker(id)
- company_organization(organization_id) → worker(organization_id)
- company_organization(company_id) → company(id)
- pay_period(original_pay_period_id) → pay_period(id)
- pay_period(company_id) → company(id)
- company_worker_status(company_id) → company(id)
- company_job_segment(company_id) → company(id)
- worker_pay_standard(worker_id) → worker(id)
- company_contact_type(company_id) → company(id)
- company_labour_assignment(organization_id) → company_organization(id)
- company_labour_assignment(location_id) → company_location(id)
- company_labour_assignment(company_id) → company(id)
- company_check_earning(company_check_id) → company_check(id)
- company_check_earning(company_id) → company_check(company_id)
- company_check_earning(pay_period_id) → company_check(pay_period_id)
- company_check_deduction(company_check_id) → company_check(id)
- company_check_deduction(company_id) → company_check(company_id)
- company_check_deduction(pay_period_id) → company_check(pay_period_id)
- company_check_tax(company_check_id) → company_check(id)
- company_check_tax(company_id) → company_check(company_id)
- company_check_tax(pay_period_id) → company_check(pay_period_id)
- company_check_informational(company_check_id) → company_check(id)
- company_check_informational(company_id) → company_check(company_id)
- company_check_informational(pay_period_id) → company_check(pay_period_id)
- company_check(worker_id) → worker(id)
- company_check(company_id) → pay_period(company_id)
- worker_federal_tax(worker_id) → worker(id)
- worker_communication(worker_id) → worker(id)
- company_location(location_id) → worker(location_id)
- company_location(company_id) → company(id)
- worker_payrate(worker_id) → worker(id)