Zoho People
Explore the interactive ERD
Table & Field Reference
running_timer
| Column | Type | Keys |
|---|---|---|
timelog_id | Unknown | PK |
job_id | Unknown | FK |
billing_status | Unknown | |
date | Unknown | |
diff | Unknown | |
employee_name | Unknown | |
erecno | Unknown | |
from_time | Unknown | |
hour | Unknown | |
is_completed | Unknown | |
is_running | Unknown | |
job_is_active | Unknown | |
task_name | Unknown | |
timer_id | Unknown | |
total_time | Unknown | |
work_date | Unknown |
project_manager
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
project_id | Unknown | PKFK |
employee_id | Unknown | FK |
erecno | Unknown | |
name | Unknown | |
rate | Unknown |
project_user
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
project_id | Unknown | PKFK |
employee_id | Unknown | FK |
erecno | Unknown | |
name | Unknown | |
rate | Unknown |
project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
client_id | Unknown | FK |
project_head_employee_id | Unknown | FK |
cost | Unknown | |
is_delete_allowed | Unknown | |
name | Unknown | |
owner_id | Unknown | |
owner_name | Unknown | |
project_head_erec_no | Unknown | |
project_head_name | Unknown | |
project_head_rate | Unknown | |
status | Unknown | |
users_count | Unknown |
salary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
package_id | Unknown | FK |
ctc | Unknown | |
currency | Unknown | |
effective_from | Unknown | |
erecno | Unknown | |
formatted_ctc | Unknown | |
salary_package | Unknown |
employee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
added_by | Unknown | |
added_time | Unknown | |
blood_group | Unknown | |
created_time | Unknown | |
email_address | Unknown | |
employee_status | Unknown | |
first_name | Unknown | |
gender | Unknown | |
last_name | Unknown | |
modified_by | Unknown | |
modified_ip_address | Unknown | |
modified_time | Unknown | |
owner_id | Unknown | |
zoho_role | Unknown |
client
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address_street | Unknown | |
city | Unknown | |
client_name | Unknown | |
company_size | Unknown | |
country | Unknown | |
currency_code | Unknown | |
description | Unknown | |
email_id | Unknown | |
fax_no | Unknown | |
first_name | Unknown | |
industry | Unknown | |
last_name | Unknown | |
mobile_no | Unknown | |
phone_no | Unknown | |
pincode | Unknown | |
state | Unknown |
lms_room_facility
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
lms_room_id | Unknown | PKFK |
facility | Unknown |
lms_room
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
capacity | Unknown | |
location_id | Unknown | |
location_name | Unknown | |
name | Unknown |
component_benefit
| Column | Type | Keys |
|---|---|---|
component_id | Unknown | PK |
calculation_type | Unknown | |
calculation_type_id | Unknown | |
component_category_id | Unknown | |
component_code | Unknown | |
component_name | Unknown | |
description | Unknown | |
location | Json | |
part_of_ctc | Unknown | |
payment_frequency | Unknown | |
payment_frequency_id | Unknown | |
payment_type | Unknown | |
payment_type_id | Unknown | |
status | Unknown |
ctc_component
| Column | Type | Keys |
|---|---|---|
component_id | Unknown | PK |
calculation_type | Unknown | |
calculation_type_id | Unknown | |
component_category_id | Unknown | |
component_code | Unknown | |
component_name | Unknown | |
description | Unknown | |
location | Json | |
part_of_ctc | Unknown | |
payment_frequency | Unknown | |
payment_frequency_id | Unknown | |
payment_type | Unknown | |
payment_type_id | Unknown | |
status | Unknown |
package
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | |
created_date | Unknown | |
ctc | Unknown | |
currency_code | Unknown | |
currency_id | Unknown | |
description | Unknown | |
exchange_rate | Unknown | |
formatted_ctc | Unknown | |
is_default | Unknown | |
modified_by | Unknown | |
modified_date | Unknown | |
name | Unknown | |
status | Unknown | |
custom_** |
timesheet
| Column | Type | Keys |
|---|---|---|
record_id | Unknown | PK |
employee_id | Unknown | FK |
form_id | Unknown | FK |
approved_rate_per_hour | Unknown | |
approved_total_amount | Unknown | |
currency | Unknown | |
description | Unknown | |
erecno | Unknown | |
from_date | Unknown | |
list_id | Unknown | |
owner | Unknown | |
rate_per_hour | Unknown | |
status | Unknown | |
timesheet_name | Unknown | |
to_date | Unknown | |
total_amount | Unknown |
form
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
component_id | Unknown | FK |
add | Unknown | |
display_name | Unknown | |
edit | Unknown | |
form_link_name | Unknown | |
is_custom | Unknown | |
is_visible | Unknown | |
view | Unknown | |
view_id | Unknown | |
view_name | Unknown |
learning_plan
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_time | Unknown | |
disabled | Unknown | |
duration | Unknown | |
duration_label | Unknown | |
duration_type | Unknown | |
image | Unknown | |
image_url | Unknown | |
is_plan_owner | Unknown | |
is_system_image | Unknown | |
mandatory_course_count | Unknown | |
name | Unknown | |
owner_id | Unknown | |
publish_status | Unknown |
organization
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
address_line_1 | Unknown | |
address_line_2 | Unknown | |
city | Unknown | |
company | Unknown | |
contact_mail_id | Unknown | |
contact_number | Unknown | |
contact_person | Unknown | |
country | Unknown | |
date_format | Unknown | |
postal_code | Unknown | |
state | Unknown | |
time_format | Unknown | |
time_zone | Unknown | |
website | Unknown |
lms_trainer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
display_name | Unknown | |
display_picture_url | Unknown | |
erecno | Unknown |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
client_id | Unknown | FK |
project_id | Unknown | FK |
assigned_by | Unknown | |
assignee_count | Unknown | |
billable_status | Unknown | |
description | Unknown | |
from_date | Unknown | |
hours | Unknown | |
is_delete_allowed | Unknown | |
name | Unknown | |
owner | Unknown | |
rate_per_hour | Unknown | |
status | Unknown | |
to_date | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
is_favourite | Unknown | |
name | Unknown |
attendance_entry
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
check_in | Unknown | |
check_in_building | Unknown | |
check_in_latitude | Unknown | |
check_in_location | Unknown | |
check_in_longitude | Unknown | |
check_out | Unknown | |
check_out_building | Unknown | |
check_out_latitude | Unknown | |
check_out_location | Unknown | |
check_out_longitude | Unknown | |
created_user | Unknown | |
modified_user | Unknown | |
source_of_punch_in | Unknown | |
source_of_punch_out | Unknown |
attendance
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
allowed_to_check_in | Unknown | |
entry_timezone | Unknown | |
first_in | Unknown | |
first_in_building | Unknown | |
first_in_latitude | Unknown | |
first_in_location | Unknown | |
first_in_longitude | Unknown | |
last_out | Unknown | |
last_out_building | Unknown | |
last_out_latitude | Unknown | |
last_out_location | Unknown | |
last_out_longitude | Unknown | |
paid_break | Unknown | |
response_timezone | Unknown | |
status | Unknown | |
unpaid_break | Unknown |
regularization_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
regularization_id | Unknown | PKFK |
date | Unknown | |
ind_app_status | Unknown | |
ind_approval_status | Unknown | |
is_old_data_available | Unknown | |
new_att_status | Unknown | |
new_check_in_time | Unknown | |
new_check_out_time | Unknown | |
old_att_status | Unknown | |
old_check_in_time | Unknown | |
old_check_out_time | Unknown | |
reason | Unknown | |
reason_not_enc | Unknown |
regularization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
app_status | Unknown | |
approval_status | Unknown | |
emp_photo | Unknown | |
end_date | Unknown | |
is_next_record_available | Unknown | |
start_date | Unknown |
lms_course
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
can_user_delete | Unknown | |
can_user_disable | Unknown | |
can_user_share | Unknown | |
course_image_url | Unknown | |
current_user_role_admin | Unknown | |
current_user_role_course_admin | Unknown | |
current_user_role_course_owner | Unknown | |
current_user_role_data_admin | Unknown | |
current_user_role_learner | Unknown | |
current_user_role_setting_admin | Unknown | |
current_user_role_shared_user | Unknown | |
current_user_role_trainer | Unknown | |
description | Unknown | |
duration | Unknown | |
is_disabled | Unknown | |
is_favourite | Unknown | |
is_shared_course | Unknown | |
name | Unknown | |
publish_status | Unknown | |
status | Unknown | |
status_as_display_string | Unknown | |
type | Unknown | |
type_as_display_string | Unknown |
leave
| Column | Type | Keys |
|---|---|---|
leave_type_id | Unknown | PK |
zoho_id | Unknown | PK |
employee_id | Unknown | PKFK |
approval_status | Unknown | |
date_of_request | Unknown | |
day | Json | |
from_date | Unknown | |
leave_type | Unknown | |
reason | Unknown | |
to_date | Unknown | |
type | Unknown | |
unit | Unknown | |
zuid | Unknown |
revision
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
approval_status | Unknown | |
created_time | Unknown | |
currency | Unknown | |
effective_from | Unknown | |
erecno | Unknown | |
modified_time | Unknown | |
reason_for_revision | Unknown | |
remark | Unknown | |
revised_amount | Unknown | |
revised_ctc | Unknown | |
revised_ctc_formatted | Unknown | |
revised_percentage | Unknown | |
salary_package | Unknown | |
status | Unknown |
lms_module_entity_data_resource
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
lms_module_entity_data_module_id | Unknown | PK |
lms_module_entity_data_index | Unknown | PKFK |
name | Unknown | |
url | Unknown |
lms_module_entity_data
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
module_id | Unknown | FK |
room_id | Unknown | FK |
can_user_delete | Unknown | |
can_user_edit | Unknown | |
description | Unknown | |
grade_category_id | Unknown | |
grade_category_name | Unknown | |
is_locked | Unknown | |
is_session_completed | Unknown | |
lock_until | Unknown | |
present_learner_count | Unknown | |
session_end_time | Unknown | |
session_id | Unknown | |
session_name | Unknown | |
session_start_date | Unknown | |
session_start_time | Unknown | |
session_trainer | Unknown | |
session_type | Unknown | |
trainer_erecno | Unknown | |
type | Unknown |
lms_module
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lms_course_id | Unknown | PKFK |
description | Unknown | |
duration | Unknown | |
is_locked | Unknown | |
lock_type | Unknown | |
lock_until | Unknown | |
module_name | Unknown |
batch_location
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
lms_batch_id | Unknown | PKFK |
location_id | Unknown | |
name | Unknown |
lms_batch
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
course_id | Unknown | FK |
allow_wait_listing | Unknown | |
cancel_batch_when_minimum_capacity_is_not_met | Unknown | |
end_date | Unknown | |
maximum_capacity | Unknown | |
minimum_capacity | Unknown | |
name | Unknown | |
publish_status | Unknown | |
start_date | Unknown |