Rippling

Explore the interactive ERD

Table & Field Reference

work_location

Column	Type	Keys
`id`	Unknown	PK
`address_country`	Unknown
`address_formatted`	Unknown
`address_locality`	Unknown
`address_postal_code`	Unknown
`address_region`	Unknown
`address_street_address`	Unknown
`address_type`	Unknown
`created_at`	Unknown
`name`	Unknown
`updated_at`	Instant

candidate

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`phone_number`	Unknown
`timezone`	Unknown
`updated_at`	Instant

company_legal_entity_id

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`legal_entities_id`	Unknown

company

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`doing_business_as_name`	Unknown
`legal_entities`	Unknown
`legal_name`	Unknown
`name`	Unknown
`parent_legal_entity_id`	Unknown
`phone`	Unknown
`physical_address_country`	Unknown
`physical_address_formatted`	Unknown
`physical_address_locality`	Unknown
`physical_address_postal_code`	Unknown
`physical_address_region`	Unknown
`physical_address_street_address`	Unknown
`physical_address_type`	Unknown
`primary_email`	Unknown
`updated_at`	Instant

department

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`created_at`	Unknown
`name`	Unknown
`reference_code`	Unknown
`updated_at`	Instant

worker_team

Column	Type	Keys
`team_id`	Unknown	PKFK
`worker_id`	Unknown	PKFK

worker_custom_field

Column	Type	Keys
`index`	Unknown	PK
`worker_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown
`value`	Json

worker

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`level_id`	Unknown	FK
`manager_id`	Unknown	FK
`user_id`	Unknown	FK
`work_location_id`	Unknown	FK
`citizenship`	Unknown
`country`	Unknown
`created_at`	Unknown
`date_of_birth`	Unknown
`end_date`	Unknown
`ethnicity`	Unknown
`gender`	Unknown
`legal_entity_id`	Unknown
`location_type`	Unknown
`number`	Unknown
`overtime_exemption`	Unknown
`personal_email`	Unknown
`race`	Unknown
`start_date`	Unknown
`status`	Unknown
`termination_reason`	Unknown
`termination_type`	Unknown
`title`	Unknown
`updated_at`	Instant
`work_email`	Unknown

custom_field

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`required`	Unknown
`type`	Unknown
`updated_at`	Instant

candidate_application

Column	Type	Keys
`id`	Unknown	PK
`candidate_id`	Unknown	PKFK
`job_requisition_id`	Unknown	FK
`applied_at`	Unknown
`created_at`	Unknown
`stage`	Unknown
`status`	Unknown
`updated_at`	Instant
`url`	Unknown

level

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`global_level`	Unknown
`name`	Unknown
`rank`	Unknown
`track_created_at`	Unknown
`track_id`	Unknown
`track_name`	Unknown
`track_updated_at`	Unknown
`updated_at`	Instant

job_requisition

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`status`	Unknown
`updated_at`	Instant

timecard

Column	Type	Keys
`id`	Unknown	PK
`worker_id`	Unknown	FK
`created_at`	Unknown
`pay_period_end_date`	Unknown
`pay_period_schedule_id`	Unknown
`pay_period_start_date`	Unknown
`summary_approved_hours`	Unknown
`summary_double_overtime_hours`	Unknown
`summary_earnings`	Json
`summary_hours_worked_by_job_code`	Json
`summary_overtime_hours`	Unknown
`summary_paid_hours`	Unknown
`summary_premiums`	Json
`summary_regular_hours`	Unknown
`summary_total_holiday_hours`	Unknown
`summary_total_hours`	Unknown
`summary_total_paid_time_off_hours`	Unknown
`summary_total_unpaid_time_off_hours`	Unknown
`summary_unpaid_break_hours_by_entry`	Json
`updated_at`	Instant

worker_detail

Column	Type	Keys
`id`	Unknown	PKFK
`compensation_worker_id`	Unknown	FK
`annual_compensation_currency_type`	Unknown
`annual_compensation_value`	Unknown
`compensation_annual_salary_equivalent`	Unknown
`compensation_bonus_schedule`	Unknown
`compensation_created_at`	Unknown
`compensation_id`	Unknown
`compensation_payment_term`	Unknown
`compensation_payment_type`	Unknown
`compensation_target_annual_bonus_percent`	Unknown
`compensation_updated_at`	Unknown
`employment_type_amount_worked`	Unknown
`employment_type_compensation_time_period`	Unknown
`employment_type_created_at`	Unknown
`employment_type_id`	Unknown
`employment_type_label`	Unknown
`employment_type_name`	Unknown
`employment_type_type`	Unknown
`employment_type_updated_at`	Unknown
`hourly_wage_currency_type`	Unknown
`hourly_wage_value`	Unknown
`monthly_compensation_currency_type`	Unknown
`monthly_compensation_value`	Unknown
`on_target_commission_currency_type`	Unknown
`on_target_commission_value`	Unknown
`relocation_reimbursement_currency_type`	Unknown
`relocation_reimbursement_value`	Unknown
`signing_bonus_currency_type`	Unknown
`signing_bonus_value`	Unknown
`target_annual_bonus_currency_type`	Unknown
`target_annual_bonus_value`	Unknown
`updated_at`	Instant
`weekly_compensation_currency_type`	Unknown
`weekly_compensation_value`	Unknown

team

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Instant

time_entry_comment

Column	Type	Keys
`author_id`	Unknown	PKFK
`time_entry_id`	Unknown	PKFK
`created_at`	Unknown
`text`	Unknown

time_entry_job_shift

Column	Type	Keys
`index`	Unknown	PK
`time_entry_id`	Unknown	PKFK
`end_time`	Unknown
`is_hours_only_input`	Unknown
`job_codes_id`	Json
`original_end_time`	Unknown
`original_start_time`	Unknown
`start_time`	Unknown

time_entry_break

Column	Type	Keys
`break_type_id`	Unknown	PK
`time_entry_id`	Unknown	PKFK
`end_time`	Unknown
`original_end_time`	Unknown
`original_start_time`	Unknown
`start_time`	Unknown

time_entry_segment

Column	Type	Keys
`index`	Unknown	PK
`time_entry_id`	Unknown	PKFK
`break_type_id`	Unknown
`display_name`	Unknown
`end_time`	Unknown
`job_codes_id`	Json
`ot_multiplier`	Unknown
`pay_rate`	Unknown
`start_time`	Unknown

time_entry

Column	Type	Keys
`id`	Unknown	PK
`time_card_id`	Unknown	FK
`worker_id`	Unknown	FK
`create_extra_hours_run`	Unknown
`created_at`	Unknown
`end_time`	Unknown
`idempotency_key`	Unknown
`pay_period_end_date`	Unknown
`pay_period_schedule_id`	Unknown
`pay_period_start_date`	Unknown
`piece_rate_premiums`	Json
`premiums`	Json
`shift_input_values`	Json
`start_time`	Unknown
`status`	Unknown
`tags`	Json
`time_entry_summary_double_over_time_hours`	Unknown
`time_entry_summary_duration`	Unknown
`time_entry_summary_over_time_hours`	Unknown
`time_entry_summary_regular_hours`	Unknown
`updated_at`	Instant

user_email

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`display`	Unknown
`type`	Unknown
`value`	Unknown

user_phone_number

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`display`	Unknown
`type`	Unknown
`value`	Unknown

user_address

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`country`	Unknown
`formatted`	Unknown
`locality`	Unknown
`postal_code`	Unknown
`region`	Unknown
`street_address`	Unknown
`type`	Unknown

user_photo

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`type`	Unknown
`value`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`created_at`	Unknown
`display_name`	Unknown
`locale`	Unknown
`name_family_name`	Unknown
`name_formatted`	Unknown
`name_given_name`	Unknown
`name_middle_name`	Unknown
`name_preferred_family_name`	Unknown
`name_preferred_given_name`	Unknown
`number`	Unknown
`preferred_language`	Unknown
`timezone`	Unknown
`updated_at`	Instant
`username`	Unknown

schedule_manager

Column	Type	Keys
`index`	Unknown	PK
`schedule_id`	Unknown	PKFK
`manager_id`	Unknown	FK

schedule_observer

Column	Type	Keys
`index`	Unknown	PK
`schedule_id`	Unknown	PKFK
`observer_id`	Unknown	FK

schedule_member

Column	Type	Keys
`index`	Unknown	PK
`schedule_id`	Unknown	PKFK
`member_id`	Unknown	FK

schedule

Column	Type	Keys
`id`	Unknown	PK
`can_edit`	Unknown
`created_at`	Unknown
`name`	Unknown
`settings_timezone`	Unknown
`updated_at`	Instant

shift_assignment_segment

Column	Type	Keys
`index`	Unknown	PK
`shift_assignment_id`	Unknown	PKFK
`duration_minutes`	Unknown
`end_time`	Unknown
`job_codes_id`	Json
`start_time`	Unknown

shift_assignment_break

Column	Type	Keys
`index`	Unknown	PK
`shift_assignment_id`	Unknown	PKFK
`duration_minutes`	Unknown
`end_time`	Unknown
`start_time`	Unknown
`type`	Unknown

shift_assignment_published_segment

Column	Type	Keys
`index`	Unknown	PK
`shift_assignment_id`	Unknown	PKFK
`duration_minutes`	Unknown
`end_time`	Unknown
`job_codes_id`	Json
`start_time`	Unknown

shift_assignment_published_break

Column	Type	Keys
`index`	Unknown	PK
`shift_assignment_id`	Unknown	PKFK
`duration_minutes`	Unknown
`end_time`	Unknown
`start_time`	Unknown
`type`	Unknown

shift_assignment

Column	Type	Keys
`id`	Unknown	PK
`schedule_id`	Unknown	FK
`worker_id`	Unknown	FK
`can_edit`	Unknown
`created_at`	Unknown
`custom_fields`	Json
`is_published`	Unknown
`published_version_end_time`	Unknown
`published_version_notes`	Unknown
`published_version_start_time`	Unknown
`shift_data_end_time`	Unknown
`shift_data_notes`	Unknown
`shift_data_start_time`	Unknown
`updated_at`	Instant

headcount_position

Column	Type	Keys
`id`	Unknown	PK
`backfill_for_id`	Unknown	FK
`department_id`	Unknown	FK
`headcount_owner_id`	Unknown	FK
`job_requisition_id`	Unknown	FK
`level_id`	Unknown	FK
`priority_id`	Unknown	FK
`recruiter_id`	Unknown	FK
`work_location_id`	Unknown	FK
`worker_id`	Unknown	FK
`created_at`	Unknown
`current_start_date`	Unknown
`employment_type_id`	Unknown
`end_date`	Unknown
`in_budget`	Unknown
`job_function_id`	Unknown
`location_factor_id`	Unknown
`notes`	Unknown
`position_id`	Unknown
`position_sub_type`	Unknown
`position_type`	Unknown
`target_start_date`	Unknown
`title`	Unknown
`updated_at`	Instant

leave_type

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`is_managed_by_external_system`	Unknown
`is_paid`	Unknown
`name`	Unknown
`type`	Unknown
`updated_at`	Instant

headcount_priority

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Instant

leave_request_day_take_off

Column	Type	Keys
`date`	Unknown	PK
`leave_request_id`	Unknown	PKFK
`number_of_minutes_taken_off`	Unknown

leave_request

Column	Type	Keys
`id`	Unknown	PK
`leave_type_id`	Unknown	FK
`requester_id`	Unknown	FK
`reviewer_id`	Unknown	FK
`worker_id`	Unknown	FK
`comments`	Unknown
`created_at`	Unknown
`end_date`	Unknown
`end_time`	Unknown
`is_managed_by_external_system`	Unknown
`leave_event_id`	Unknown
`leave_policy_id`	Unknown
`number_of_minutes_requested`	Unknown
`reason_for_leave`	Unknown
`requester`	Unknown
`reviewed_at`	Unknown
`reviewer`	Unknown
`start_date`	Unknown
`start_time`	Unknown
`status`	Unknown
`updated_at`	Instant
`worker`	Unknown