FreshTeam
Explore the interactive ERD
Table & Field Reference
candidate_skill
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
candidate_id | Unknown | PKFK |
skill | Unknown |
candidate_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
candidate_id | Unknown | PKFK |
tags | Unknown |
candidate_profile_link
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
candidate_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
candidate_qualification
| Column | Type | Keys |
|---|---|---|
degree | Unknown | PK |
candidate_id | Unknown | PKFK |
end_date | Unknown | |
field_of_study | Unknown | |
grade | Unknown | |
is_current | Unknown | |
school_name | Unknown | |
start_date | Unknown | |
summary | Unknown |
candidate_position
| Column | Type | Keys |
|---|---|---|
title | Unknown | PK |
candidate_id | Unknown | PKFK |
company | Unknown | |
end_date | Unknown | |
is_current | Unknown | |
start_date | Unknown | |
summary | Unknown |
candidate_resume
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | PKFK |
content_file_name | Unknown | |
content_file_size | Unknown | |
description | Unknown | |
url | Unknown |
candidate_cover_letter
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | PKFK |
content_file_name | Unknown | |
content_file_size | Unknown | |
description | Unknown | |
url | Unknown |
candidate_portfolios
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | PKFK |
content_file_name | Unknown | |
content_file_size | Unknown | |
description | Unknown | |
url | Unknown |
candidate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
owner_id | Unknown | FK |
source_category_id | Unknown | FK |
source_id | Unknown | FK |
cool_off_date | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
deleted | Unknown | |
description | Unknown | |
eeo_disabled | Unknown | |
eeo_ethnicity | Unknown | |
eeo_gender | Unknown | |
eeo_veteran | Unknown | |
email | Unknown | |
first_name | Unknown | |
gender | Unknown | |
last_name | Unknown | |
location_city | Unknown | |
location_country_code | Unknown | |
location_state | Unknown | |
location_street | Unknown | |
location_zip_code | Unknown | |
middle_name | Unknown | |
mobile | Unknown | |
other_attachment | Json | |
phone | Unknown | |
skype_id | Unknown | |
spam | Unknown | |
total_experience_in_month | Unknown | |
updated_at | Unknown |
source_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
is_default | Unknown | |
label | Unknown | |
leads_count | Unknown | |
updated_at | Unknown |
new_hire_work_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
name | Unknown | |
number | Unknown |
new_hire_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
masked | Unknown | |
name | Unknown | |
number | Unknown |
new_hire_emergency_contact
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
address | Unknown | |
contact_number | Unknown | |
email | Unknown | |
name | Unknown | |
relationship | Unknown |
new_hire_social_profile
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
new_hire_time_off
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
availed | Unknown | |
credit | Unknown | |
name | Unknown |
new_hire_dependent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
date_of_birth | Unknown | |
deleted | Unknown | |
gender | Unknown | |
name | Unknown | |
relationship | Unknown |
new_hire_previous_employment_reference
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
previous_employment_id | Unknown | PKFK |
contact_number | Unknown | |
name | Unknown |
new_hire_previous_employment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
company | Unknown | |
deleted | Unknown | |
description | Unknown | |
end_date | Unknown | |
job_type | Unknown | |
other_salary_components | Unknown | |
role | Unknown | |
salary_value | Unknown | |
start_date | Unknown |
new_hire_qualification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
course | Unknown | |
degree | Unknown | |
deleted | Unknown | |
description | Unknown | |
end_date | Unknown | |
grade_average | Unknown | |
institue_name | Unknown | |
pass_out_date | Unknown | |
start_date | Unknown |
new_hire_bank_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
account_number | Unknown | |
bank_name | Unknown | |
branch_code | Unknown | |
deleted | Unknown | |
name_as_per_account | Unknown |
new_hire_compensation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
annual_amount | Unknown | |
cost_center_id | Unknown | |
cost_center_value | Unknown | |
currency | Unknown | |
current | Unknown | |
deleted | Unknown | |
description | Unknown | |
effective_date | Unknown | |
eligible_work_hour | Unknown | |
other_component | Unknown | |
pay_factor | Unknown | |
pay_group_id | Unknown | |
pay_group_value | Unknown | |
pay_method_id | Unknown | |
pay_method_value | Unknown | |
pay_rate_id | Unknown | |
pay_rate_name | Unknown | |
pay_rate_value | Unknown | |
pay_schedule_id | Unknown | |
pay_schedule_name | Unknown | |
reason_id | Unknown | |
reason_value | Unknown | |
variable_pay | Unknown | |
variable_pay_detail | Unknown | |
variable_pay_frequency_id | Unknown | |
variable_pay_frequency_name | Unknown | |
work_hour_rate_id | Unknown | |
work_hour_rate_value | Unknown |
new_hire_bonus
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
additional_detail | Unknown | |
bonus_type_id | Unknown | |
bonus_type_value | Unknown | |
currency | Unknown | |
deleted | Unknown | |
effective_date | Unknown | |
value | Unknown |
new_hire_stock
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
currency | Unknown | |
deleted | Unknown | |
description | Unknown | |
effective_date | Unknown | |
exercise_price | Unknown | |
exercise_price_discount | Unknown | |
expiration_date | Unknown | |
grant_date | Unknown | |
grant_number | Unknown | |
grant_reason_id | Unknown | |
grant_reason_value | Unknown | |
grant_type_id | Unknown | |
grant_type_value | Unknown | |
pay_rate_id | Unknown | |
pay_rate_name | Unknown | |
total_stock_units | Unknown | |
value_per_share | Unknown | |
vesting_period | Unknown | |
vesting_rate | Unknown | |
vesting_schedule | Unknown | |
vesting_type | Unknown | |
with_in_range | Unknown |
new_hire_award
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
awarded_by | Unknown | |
deleted | Unknown | |
name | Unknown |
new_hire_honor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
awarded_by | Unknown | |
deleted | Unknown | |
name | Unknown |
new_hire_certificate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
awarded_by | Unknown | |
deleted | Unknown | |
grade | Unknown | |
name | Unknown |
new_hire_license
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
deleted | Unknown | |
expiry_date | Unknown | |
name | Unknown | |
restrictions | Unknown |
new_hire_background_verification_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
completion_date | Unknown | |
deleted | Unknown | |
initiation_date | Unknown | |
notes | Unknown | |
status | Unknown | |
vendor | Unknown |
new_hire_visa
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
country_code | Unknown | |
deleted | Unknown | |
valid_from | Unknown | |
valid_to | Unknown | |
visa_number | Unknown | |
visa_type | Unknown |
new_hire_government_document
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
country_code | Unknown | |
deleted | Unknown | |
expiry_date | Unknown | |
issuing_authority | Unknown | |
issuing_date | Unknown | |
name | Unknown | |
number | Unknown | |
type_id | Unknown | |
type_position | Unknown | |
type_value | Unknown |
new_hire_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
new_hire_employee_id | Unknown | PKFK |
new_hire
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_id | Unknown | FK |
business_unit_id | Unknown | FK |
department_id | Unknown | FK |
employee_id | Unknown | FK |
hr_incharge_id | Unknown | FK |
job_role_id | Unknown | FK |
level_id | Unknown | FK |
reporting_to_id | Unknown | FK |
sub_department_id | Unknown | FK |
team_id | Unknown | FK |
user_function_id | Unknown | FK |
actual_retirement_date | Unknown | |
additional_hr_manager | Json | |
additional_manager | Json | |
additional_team | Json | |
address_city | Unknown | |
address_country_code | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
address_zip_code | Unknown | |
blood_group | Unknown | |
citizenship_status_id | Unknown | |
citizenship_status_value | Unknown | |
communication_address_city | Unknown | |
communication_address_country_code | Unknown | |
communication_address_same_as_residential | Unknown | |
communication_address_state | Unknown | |
communication_address_street | Unknown | |
communication_address_zip_code | Unknown | |
cost_center | Json | |
cost_center_id | Unknown | |
cost_center_value | Unknown | |
country_of_birth | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
deleted | Unknown | |
designation | Unknown | |
eeo_company_code | Unknown | |
eeo_disabled | Unknown | |
eeo_ethnicity | Unknown | |
eeo_job_category | Unknown | |
eeo_vetran | Unknown | |
employee_type | Unknown | |
employment_end_date | Unknown | |
end_time | Unknown | |
expected_retirement_date | Unknown | |
first_name | Unknown | |
flsa_required | Unknown | |
gender | Unknown | |
hereditary_last_name | Unknown | |
hire_reason | Unknown | |
id_card_detail | Unknown | |
im_address | Unknown | |
job_code | Unknown | |
job_exempt | Unknown | |
job_role_value | Unknown | |
joining_date | Unknown | |
languages | Json | |
last_name | Unknown | |
legal_name | Unknown | |
marital_status | Unknown | |
middle_name | Unknown | |
nick_name | Unknown | |
notice_end_date | Unknown | |
notice_period | Unknown | |
notice_start_date | Unknown | |
official_email | Unknown | |
personal_email | Unknown | |
place_of_birth | Unknown | |
previous_name | Unknown | |
previous_name_change_date | Unknown | |
probation_end_date | Unknown | |
probation_start_date | Unknown | |
retirement_eligibility_date | Unknown | |
retirement_status_id | Unknown | |
retirement_status_value | Unknown | |
scheduled_weekly_hour | Unknown | |
secondary_business_email | Unknown | |
secondary_last_name | Unknown | |
shift_id | Unknown | |
shift_value | Unknown | |
start_time | Unknown | |
status | Unknown | |
termination_category_id | Unknown | |
termination_category_value | Unknown | |
termination_date | Unknown | |
termination_reason | Unknown | |
updated_at | Instant | |
user_academic_suffix_id | Unknown | |
user_academic_suffix_value | Unknown | |
user_honorary_suffix_id | Unknown | |
user_honorary_suffix_value | Unknown | |
user_professional_suffix_id | Unknown | |
user_professional_suffix_value | Unknown | |
user_suffix_id | Unknown | |
user_suffix_value | Unknown | |
user_title_id | Unknown | |
user_title_value | Unknown | |
work_hour | Unknown | |
workstation_number | Unknown | |
custom_** |
department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
name | Unknown | |
updated_at | Unknown |
level
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
name | Unknown | |
updated_at | Unknown |
business_unit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
description | Unknown | |
name | Unknown | |
updated_at | Unknown |
source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
is_deault | Unknown | |
label | Unknown | |
leads_count | Unknown | |
updated_at | Unknown |
time_off
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
applied_by_id | Unknown | FK |
approved_by_id | Unknown | FK |
cancelled_by_id | Unknown | FK |
rejected_by_id | Unknown | FK |
time_off_type_id | Unknown | FK |
user_id | Unknown | FK |
cancelled_at | Unknown | |
comments | Unknown | |
created_at | Unknown | |
end_date | LocalDate | |
leave_units | Unknown | |
optional_leave_units | Unknown | |
rejected_at | Unknown | |
start_date | LocalDate | |
status | Unknown | |
status_comments | Unknown | |
updated_at | Unknown |
time_off_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
applicable_for | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
description | Unknown | |
is_default | Unknown | |
marital_status | Unknown | |
name | Unknown | |
updated_at | Unknown |
job_posting_field_picklist_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
field_id | Unknown | PKFK |
pickable_id | Unknown | |
pickable_type | Unknown | |
position | Unknown | |
value | Unknown |
job_posting_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
field_type | Unknown | |
is_default | Unknown | |
job_form_id | Unknown | |
label | Unknown | |
name | Unknown | |
position | Unknown | |
public | Unknown | |
required | Unknown | |
restricted | Unknown | |
updated_at | Unknown |
role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
description | Unknown | |
is_default | Unknown | |
name | Unknown | |
sensitive | Unknown | |
updated_at | Unknown |
user_function
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
updated_at | Unknown | |
value | Unknown |
sub_department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
name | Unknown | |
updated_at | Unknown |
branch
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
city | Unknown | |
contact_info | Unknown | |
country_code | Unknown | |
created_at | Unknown | |
currency | Unknown | |
date_format | Unknown | |
deleted | Unknown | |
languages | Unknown | |
main_office | Unknown | |
name | Unknown | |
state | Unknown | |
street | Unknown | |
time_zone | Unknown | |
updated_at | Unknown | |
zip | Unknown |
employee_work_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown | |
number | Unknown |
employee_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
masked | Unknown | |
name | Unknown | |
number | Unknown |
employee_emergency_contact
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
address | Unknown | |
contact_number | Unknown | |
email | Unknown | |
name | Unknown | |
relationship | Unknown |
employee_social_profile
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
employee_time_off
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
availed | Unknown | |
credit | Unknown | |
name | Unknown |
employee_dependent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
date_of_birth | Unknown | |
deleted | Unknown | |
gender | Unknown | |
name | Unknown | |
relationship | Unknown |
employee_previous_employment_reference
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
previous_employment_id | Unknown | PKFK |
contact_number | Unknown | |
name | Unknown |
employee_previous_employment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
company | Unknown | |
deleted | Unknown | |
description | Unknown | |
end_date | Unknown | |
job_type | Unknown | |
other_salary_components | Unknown | |
role | Unknown | |
salary_value | Unknown | |
start_date | Unknown |
employee_qualification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
course | Unknown | |
degree | Unknown | |
deleted | Unknown | |
description | Unknown | |
end_date | Unknown | |
grade_average | Unknown | |
institue_name | Unknown | |
pass_out_date | Unknown | |
start_date | Unknown |
employee_bank_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
account_number | Unknown | |
bank_name | Unknown | |
branch_code | Unknown | |
deleted | Unknown | |
name_as_per_account | Unknown |
employee_compensation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
annual_amount | Unknown | |
cost_center_id | Unknown | |
cost_center_value | Unknown | |
currency | Unknown | |
current | Unknown | |
deleted | Unknown | |
description | Unknown | |
effective_date | Unknown | |
eligible_work_hour | Unknown | |
other_component | Unknown | |
pay_factor | Unknown | |
pay_group_id | Unknown | |
pay_group_value | Unknown | |
pay_method_id | Unknown | |
pay_method_value | Unknown | |
pay_rate_id | Unknown | |
pay_rate_name | Unknown | |
pay_rate_value | Unknown | |
pay_schedule_id | Unknown | |
pay_schedule_name | Unknown | |
reason_id | Unknown | |
reason_value | Unknown | |
variable_pay | Unknown | |
variable_pay_detail | Unknown | |
variable_pay_frequency_id | Unknown | |
variable_pay_frequency_name | Unknown | |
work_hour_rate_id | Unknown | |
work_hour_rate_value | Unknown |
employee_bonus
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
additional_detail | Unknown | |
bonus_type_id | Unknown | |
bonus_type_value | Unknown | |
currency | Unknown | |
deleted | Unknown | |
effective_date | Unknown | |
value | Unknown |
employee_stock
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
currency | Unknown | |
deleted | Unknown | |
description | Unknown | |
effective_date | Unknown | |
exercise_price | Unknown | |
exercise_price_discount | Unknown | |
expiration_date | Unknown | |
grant_date | Unknown | |
grant_number | Unknown | |
grant_reason_id | Unknown | |
grant_reason_value | Unknown | |
grant_type_id | Unknown | |
grant_type_value | Unknown | |
pay_rate_id | Unknown | |
pay_rate_name | Unknown | |
total_stock_units | Unknown | |
value_per_share | Unknown | |
vesting_period | Unknown | |
vesting_rate | Unknown | |
vesting_schedule | Unknown | |
vesting_type | Unknown | |
with_in_range | Unknown |
employee_award
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
awarded_by | Unknown | |
deleted | Unknown | |
name | Unknown |
employee_honor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
awarded_by | Unknown | |
deleted | Unknown | |
name | Unknown |
employee_certificate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
awarded_by | Unknown | |
deleted | Unknown | |
grade | Unknown | |
name | Unknown |
employee_license
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
deleted | Unknown | |
expiry_date | Unknown | |
name | Unknown | |
restrictions | Unknown |
employee_background_verification_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
completion_date | Unknown | |
deleted | Unknown | |
initiation_date | Unknown | |
notes | Unknown | |
status | Unknown | |
vendor | Unknown |
employee_visa
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
country_code | Unknown | |
deleted | Unknown | |
valid_from | Unknown | |
valid_to | Unknown | |
visa_number | Unknown | |
visa_type | Unknown |
employee_government_document
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
country_code | Unknown | |
deleted | Unknown | |
expiry_date | Unknown | |
issuing_authority | Unknown | |
issuing_date | Unknown | |
name | Unknown | |
number | Unknown | |
type_id | Unknown | |
type_position | Unknown | |
type_value | Unknown |
employee_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
employee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_id | Unknown | FK |
business_unit_id | Unknown | FK |
department_id | Unknown | FK |
hr_incharge_id | Unknown | FK |
job_role_id | Unknown | FK |
level_id | Unknown | FK |
reporting_to_id | Unknown | FK |
sub_department_id | Unknown | FK |
team_id | Unknown | FK |
user_function_id | Unknown | FK |
actual_retirement_date | Unknown | |
additional_hr_manager | Json | |
additional_manager | Json | |
additional_team | Json | |
address_city | Unknown | |
address_country_code | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
address_zip_code | Unknown | |
blood_group | Unknown | |
citizenship_status_id | Unknown | |
citizenship_status_value | Unknown | |
communication_address_city | Unknown | |
communication_address_country_code | Unknown | |
communication_address_same_as_residential | Unknown | |
communication_address_state | Unknown | |
communication_address_street | Unknown | |
communication_address_zip_code | Unknown | |
cost_center | Json | |
cost_center_id | Unknown | |
cost_center_value | Unknown | |
country_of_birth | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
deleted | Unknown | |
designation | Unknown | |
draft | Unknown | |
eeo_company_code | Unknown | |
eeo_disabled | Unknown | |
eeo_ethnicity | Unknown | |
eeo_job_category | Unknown | |
eeo_vetran | Unknown | |
employee_id | Unknown | |
employee_type | Unknown | |
employment_end_date | Unknown | |
end_time | Unknown | |
expected_retirement_date | Unknown | |
first_name | Unknown | |
flsa_required | Unknown | |
gender | Unknown | |
hereditary_last_name | Unknown | |
hire_reason | Unknown | |
hired_on | Unknown | |
id_card_detail | Unknown | |
im_address | Unknown | |
job_code | Unknown | |
job_exempt | Unknown | |
job_role_value | Unknown | |
joining_date | Unknown | |
languages | Json | |
last_name | Unknown | |
legal_name | Unknown | |
marital_status | Unknown | |
middle_name | Unknown | |
nick_name | Unknown | |
notice_end_date | Unknown | |
notice_period | Unknown | |
notice_start_date | Unknown | |
official_email | Unknown | |
personal_email | Unknown | |
place_of_birth | Unknown | |
previous_name | Unknown | |
previous_name_change_date | Unknown | |
probation_end_date | Unknown | |
probation_start_date | Unknown | |
retirement_eligibility_date | Unknown | |
retirement_status_id | Unknown | |
retirement_status_value | Unknown | |
scheduled_weekly_hour | Unknown | |
secondary_business_email | Unknown | |
secondary_last_name | Unknown | |
shift_id | Unknown | |
shift_value | Unknown | |
start_time | Unknown | |
status | Unknown | |
termination_category_id | Unknown | |
termination_category_value | Unknown | |
termination_date | Unknown | |
termination_reason | Unknown | |
updated_at | Instant | |
user_academic_suffix_id | Unknown | |
user_academic_suffix_value | Unknown | |
user_honorary_suffix_id | Unknown | |
user_honorary_suffix_value | Unknown | |
user_professional_suffix_id | Unknown | |
user_professional_suffix_value | Unknown | |
user_suffix_id | Unknown | |
user_suffix_value | Unknown | |
user_title_id | Unknown | |
user_title_value | Unknown | |
work_hour | Unknown | |
workstation_number | Unknown | |
custom_** |
applicant_follower
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
applicant_id | Unknown | PKFK |
user_id | Unknown | FK |
applicant
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | FK |
job_id | Unknown | FK |
requisition_id | Unknown | FK |
source_category_id | Unknown | FK |
source_id | Unknown | FK |
sub_stage_id | Unknown | FK |
archived_at | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
job_title | Unknown | |
moved_at | Unknown | |
on_hold_at | Unknown | |
on_hold_till | Unknown | |
rejected_at | Unknown | |
stage | Unknown | |
status | Unknown | |
updated_at | Unknown | |
custom_** |
employee_field_scope
| Column | Type | Keys |
|---|---|---|
scopable_id | Unknown | PK |
employee_field_id | Unknown | PKFK |
scopable_lable | Unknown | |
scopable_type | Unknown |
employee_field_picklist
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_field_id | Unknown | PKFK |
pickable_id | Unknown | |
pickable_type | Unknown | |
position | Unknown | |
value | Unknown |
employee_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
editable_by | Unknown | |
employee_form_id | Unknown | |
field_type | Json | |
is_default | Unknown | |
label | Unknown | |
name | Unknown | |
position | Unknown | |
required | Unknown | |
section_label | Unknown | |
tab | Unknown | |
updated_at | Unknown | |
viewable_by | Unknown |
job_post_skill
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
job_posting_id | Unknown | PKFK |
skill | Unknown |
job_remote_branch
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
job_posting_id | Unknown | PKFK |
remote_branch | Unknown |
recruiter
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
job_posting_id | Unknown | PKFK |
requisition_id | Unknown | PKFK |
hiring_manager
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
job_posting_id | Unknown | PKFK |
requisition_id | Unknown | PKFK |
panel_member
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
job_posting_id | Unknown | PKFK |
requisition_id | Unknown | PKFK |
job_post_requisition
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_posting_id | Unknown | PKFK |
deleted | Unknown | |
title | Unknown |
job_post_sub_stage
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_posting_id | Unknown | PKFK |
deleted | Unknown | |
is_default | Unknown | |
name | Unknown | |
position | Unknown | |
stage | Unknown |
job_posting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_id | Unknown | FK |
department_id | Unknown | FK |
applicant_access_type | Unknown | |
applicant_apply_link | Unknown | |
closing_date | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
description | Unknown | |
experience | Unknown | |
interview_process_id | Unknown | |
interview_process_name | Unknown | |
remote | Unknown | |
salary_currency | Unknown | |
salary_max | Unknown | |
salary_min | Unknown | |
show_pursue_as_career | Unknown | |
status | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Unknown |
applicant_field_picklist_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
field_id | Unknown | FK |
job_posting_id | Unknown | FK |
pickable_id | Unknown | |
pickable_type | Unknown | |
position | Unknown | |
value | Unknown |
applicant_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_posting_id | Unknown | PKFK |
applicant_form_id | Unknown | |
base_model | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
external_field | Unknown | |
field_type | Unknown | |
group_label | Unknown | |
group_name | Unknown | |
group_position | Unknown | |
is_default | Unknown | |
label | Unknown | |
name | Unknown | |
position | Unknown | |
recruiter_field | Unknown | |
required_in_external_form | Unknown | |
required_in_recruiter_form | Unknown | |
required_in_vendor_form | Unknown | |
updated_at | Unknown | |
vendor_field | Unknown | |
viewable_by | Unknown |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
deleted | Unknown | |
name | Unknown | |
updated_at | Unknown |