# Zoho People schema ERD

Table and field reference for the Fivetran Zoho People connector.

## 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 | PK, FK |
| employee_id | Unknown | FK |
| erecno | Unknown |  |
| name | Unknown |  |
| rate | Unknown |  |

### project_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- running_timer(job_id) → job(id)
- project_manager(employee_id) → employee(id)
- project_manager(project_id) → project(id)
- project_user(employee_id) → employee(id)
- project_user(project_id) → project(id)
- project(client_id) → client(id)
- project(project_head_employee_id) → employee(id)
- salary(employee_id) → employee(id)
- salary(package_id) → package(id)
- lms_room_facility(lms_room_id) → lms_room(id)
- timesheet(form_id) → form(_fivetran_id)
- timesheet(employee_id) → employee(id)
- form(component_id) → ctc_component(component_id)
- lms_trainer(employee_id) → employee(id)
- job(project_id) → project(id)
- job(client_id) → client(id)
- attendance_entry(_fivetran_id) → attendance(_fivetran_id)
- regularization_detail(regularization_id) → regularization(id)
- regularization(employee_id) → employee(id)
- leave(employee_id) → employee(id)
- revision(employee_id) → employee(id)
- lms_module_entity_data_resource(lms_module_entity_data_index) → lms_module_entity_data(index)
- lms_module_entity_data(room_id) → lms_room(id)
- lms_module_entity_data(module_id) → lms_module(id)
- lms_module(lms_course_id) → lms_course(id)
- batch_location(lms_batch_id) → lms_batch(id)
- lms_batch(course_id) → lms_course(id)