# Paylocity schema ERD

Table and field reference for the Fivetran Paylocity connector.

## Table & Field Reference

### employee_punch_details_segments_costcenter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| employee_punch_relative_end | Unknown | PK, FK |
| employee_punch_relative_start | Unknown | PK, FK |
| employee_punch_segment_index | Unknown | PK, FK |
| code | Unknown |  |
| cost_center_id | Unknown |  |
| id | Unknown |  |
| is_active | Unknown |  |
| level | Unknown |  |
| name | Unknown |  |

### employee_punch_details_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| employee_punch_relative_end | Unknown | PK, FK |
| employee_punch_relative_start | Unknown | PK, FK |
| date | Unknown |  |
| duration_seconds | Unknown |  |
| earnings | Unknown |  |
| origin | Unknown |  |
| punch_id | Unknown |  |
| punch_type | Unknown |  |
| relative_end | Unknown |  |
| relative_original_end | Unknown |  |
| relative_original_start | Unknown |  |
| relative_start | Unknown |  |

### employee_punch_detail

| Column | Type | Keys |
| --- | --- | --- |
| relative_end | Unknown | PK |
| relative_start | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| badge_number | Unknown |  |

### employee_deduction_cost_center

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_deduction_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| additional_prop | Unknown |  |
| code | Unknown |  |
| level | Unknown |  |

### employee_deduction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| agency_code | Unknown |  |
| arrear | Unknown |  |
| begin_check_date | Unknown |  |
| calculation_code | Unknown |  |
| code | Unknown |  |
| effective_date | Unknown |  |
| end_check_date | Unknown |  |
| frequency | Unknown |  |
| limits_annual_maximum | Unknown |  |
| limits_goal | Unknown |  |
| limits_paid_to_date | Unknown |  |
| limits_paid_year_to_date | Unknown |  |
| limits_pay_period_maximum | Unknown |  |
| limits_pay_period_minimum | Unknown |  |
| loan_additional_prop | Unknown |  |
| loan_first_payment_date | Unknown |  |
| loan_issue_date | Unknown |  |
| loan_number | Unknown |  |
| miscellaneous_info | Unknown |  |
| note | Unknown |  |
| priority | Unknown |  |
| rate | Unknown |  |
| record_type | Unknown |  |
| self_insured | Unknown |  |
| type | Unknown |  |

### employee_future_pay_rate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| additional_prop | Json |  |
| annual_salary | Unknown |  |
| begin_check_date | Unknown |  |
| change_reason | Unknown |  |
| effective_date | Unknown |  |
| is_auto_pay | Unknown |  |
| pay_frequency | Unknown |  |
| pay_rate_description | Unknown |  |
| pay_type | Unknown |  |
| salary | Unknown |  |

### employee_position_family

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| additional_prop | Json |  |
| code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK |
| id | Unknown | PK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| adjusted_seniority_date | Unknown |  |
| city | Unknown |  |
| clock_badge | Unknown |  |
| country | Unknown |  |
| county | Unknown |  |
| current_pay_rate_annual_salary | Unknown |  |
| current_pay_rate_base_rate | Unknown |  |
| current_pay_rate_begin_check_date | Unknown |  |
| current_pay_rate_default_hours | Unknown |  |
| current_pay_rate_effective_date | Unknown |  |
| current_pay_rate_frequency | Unknown |  |
| current_pay_rate_grade | Unknown |  |
| current_pay_rate_is_auto_pay | Unknown |  |
| current_pay_rate_per | Unknown |  |
| current_pay_rate_salary | Unknown |  |
| current_pay_rate_type | Unknown |  |
| current_status_additional_prop | Json |  |
| current_status_change_reason | Unknown |  |
| current_status_change_reason_code | Unknown |  |
| current_status_effective_date | Unknown |  |
| date_of_birth | Unknown |  |
| display_name | Unknown |  |
| eeo_class | Unknown |  |
| eligible_for_rehire | Unknown |  |
| ethnicity_race | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| hire_date | Unknown |  |
| home_phone | Unknown |  |
| info_additional_prop | Json |  |
| info_address_additional_prop | Json |  |
| is_supervisor | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| marital_status | Unknown |  |
| middle_name | Unknown |  |
| min_wage_exempt | Unknown |  |
| mobile_phone | Unknown |  |
| ot_exempt | Unknown |  |
| pay_group | Unknown |  |
| personal_email | Unknown |  |
| position_additional_prop | Json |  |
| position_career_level_code | Unknown |  |
| position_career_level_description | Unknown |  |
| position_change_reason | Unknown |  |
| position_code | Unknown |  |
| position_cost_center_1 | Unknown |  |
| position_cost_center_2 | Unknown |  |
| position_cost_center_3 | Unknown |  |
| position_description | Unknown |  |
| position_effective_date | Unknown |  |
| position_employee_type | Unknown |  |
| postal_code | Unknown |  |
| preferred_name | Unknown |  |
| relationship_id | Unknown |  |
| reviewer | Unknown |  |
| reviewer_co | Unknown |  |
| shift | Unknown |  |
| ssn | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| status_type | Unknown |  |
| suffix | Unknown |  |
| supervisor | Unknown |  |
| supervisor_co | Unknown |  |
| tipped | Unknown |  |
| wcc | Unknown |  |
| work_location_additional_prop | Json |  |
| work_location_address_1 | Unknown |  |
| work_location_address_2 | Unknown |  |
| work_location_address_additional_prop | Json |  |
| work_location_city | Unknown |  |
| work_location_country | Unknown |  |
| work_location_county | Unknown |  |
| work_location_email | Unknown |  |
| work_location_mobile_phone | Unknown |  |
| work_location_phone | Unknown |  |
| work_location_phone_ext | Unknown |  |
| work_location_postal_code | Unknown |  |
| work_location_state | Unknown |  |

### employee_earning_cost_center

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_earning_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| additional_prop | Json |  |
| code | Unknown |  |
| level | Unknown |  |

### employee_earning

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |
| additional_prop | Json |  |
| agency | Unknown |  |
| amount | Unknown |  |
| begin_check_date | Unknown |  |
| calculation_code | Unknown |  |
| code | Unknown |  |
| distribution_additional_prop | Json |  |
| distribution_job_code | Unknown |  |
| effective_date | Unknown |  |
| end_check_date | Unknown |  |
| frequency | Unknown |  |
| limits_additional_prop | Json |  |
| limits_annual_maximum | Unknown |  |
| limits_goal | Unknown |  |
| limits_paid_to_date | Unknown |  |
| limits_paid_year_to_date | Unknown |  |
| limits_pay_period_maximum | Unknown |  |
| limits_pay_period_minimum | Unknown |  |
| miscellaneous_info | Unknown |  |
| rate | Unknown |  |
| rate_code | Unknown |  |
| record_type | Unknown |  |
| self_insured | Unknown |  |
| units | Unknown |  |

## Relationships

- employee_punch_details_segments_costcenter(company_id) → employee_punch_details_segment(company_id)
- employee_punch_details_segments_costcenter(employee_punch_relative_start) → employee_punch_details_segment(employee_punch_relative_start)
- employee_punch_details_segments_costcenter(employee_punch_relative_end) → employee_punch_details_segment(employee_punch_relative_end)
- employee_punch_details_segments_costcenter(employee_punch_segment_index) → employee_punch_details_segment(index)
- employee_punch_details_segments_costcenter(employee_id) → employee_punch_details_segment(employee_id)
- employee_punch_details_segment(company_id) → employee_punch_detail(company_id)
- employee_punch_details_segment(employee_id) → employee_punch_detail(employee_id)
- employee_punch_details_segment(employee_punch_relative_start) → employee_punch_detail(relative_start)
- employee_punch_details_segment(employee_punch_relative_end) → employee_punch_detail(relative_end)
- employee_punch_detail(employee_id) → employee(id)
- employee_punch_detail(company_id) → employee(company_id)
- employee_deduction_cost_center(company_id) → employee_deduction(company_id)
- employee_deduction_cost_center(employee_deduction_id) → employee_deduction(id)
- employee_deduction_cost_center(employee_id) → employee_deduction(employee_id)
- employee_deduction(employee_id) → employee(id)
- employee_deduction(company_id) → employee(company_id)
- employee_future_pay_rate(company_id) → employee(company_id)
- employee_future_pay_rate(employee_id) → employee(id)
- employee_position_family(company_id) → employee(company_id)
- employee_position_family(employee_id) → employee(id)
- employee_earning_cost_center(company_id) → employee_earning(company_id)
- employee_earning_cost_center(employee_earning_id) → employee_earning(id)
- employee_earning_cost_center(employee_id) → employee_earning(employee_id)
- employee_earning(employee_id) → employee(id)
- employee_earning(company_id) → employee(company_id)