Paylocity

Explore the interactive ERD

Table & Field Reference

employee_punch_details_segments_costcenter

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`employee_punch_relative_end`	Unknown	PKFK
`employee_punch_relative_start`	Unknown	PKFK
`employee_punch_segment_index`	Unknown	PKFK
`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	PKFK
`employee_id`	Unknown	PKFK
`employee_punch_relative_end`	Unknown	PKFK
`employee_punch_relative_start`	Unknown	PKFK
`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	PKFK
`employee_id`	Unknown	PKFK
`badge_number`	Unknown

employee_deduction_cost_center

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`employee_deduction_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`additional_prop`	Unknown
`code`	Unknown
`level`	Unknown

employee_deduction

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`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	PKFK
`employee_id`	Unknown	PKFK
`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	PKFK
`employee_id`	Unknown	PKFK
`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	PKFK
`employee_earning_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`additional_prop`	Json
`code`	Unknown
`level`	Unknown

employee_earning

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK
`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