# EmployeeById: Simplicate Employee by ID Fetches a single employee by id This is a read-only table function. The Simplicate API may not support modifying the data, or the Invantive UniversalSQL driver for Simplicate does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Simplicate API. - Catalog: `Simplicate` - Schema: `HRM` - Label: Employee by ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☑ | | The id of the template | ## Columns The columns of the table `EmployeeById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `avatar_color` | `string` | Avatar Colour | ☐ | | | `avatar_initials` | `string` | Avatar Initials | ☐ | | | `avatar_url_large` | `string` | Avatar Large (URL) | ☐ | | | `avatar_url_small` | `string` | Avatar Small (URL) | ☐ | | | `bank_account` | `string` | Bank Account | ☐ | | | `civil_status` | `string` | Civil Status | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `created` | `string` | Created | ☐ | | | `employment_status` | `string` | Employment Status | ☐ | | | `function` | `string` | Job Title | ☐ | | | `hourly_cost_tariff` | `float` | Hourly Rate | ☐ | | | `hourly_sales_tariff` | `float` | Hourly Sales Rate | ☐ | | | `id` | `string` | ID | ☐ | | | `is_user` | `boolean` | Is User | ☐ | | | `marital_status` | `string` | Civil Status | ☐ | | | `modified` | `string` | Modified | ☐ | | | `name` | `string` | Name | ☐ | | | `person_address_country_code` | `string` | | ☐ | | | `person_address_country_id` | `string` | | ☐ | | | `person_address_country` | `string` | Person Address Country | ☐ | | | `person_address_id` | `string` | Person Address ID | ☐ | | | `person_address_line_1` | `string` | | ☐ | | | `person_address_line_2` | `string` | | ☐ | | | `person_address_locality` | `string` | Person Address City | ☐ | | | `person_address_postal_code` | `string` | Person Address Postal Code | ☐ | | | `person_address_province` | `string` | Person Address Province | ☐ | | | `person_address_type` | `string` | Person Address Type | ☐ | | | `person_avatar_color` | `string` | Person Avatar Colour | ☐ | | | `person_avatar_initials` | `string` | Person Avatar Initials | ☐ | | | `person_avatar_url_large` | `string` | Person Avatar URL Large | ☐ | | | `person_avatar_url_small` | `string` | Person Avatar URL Small | ☐ | | | `person_bank_account` | `string` | | ☐ | | | `person_bank_bic` | `string` | | ☐ | | | `person_created_at` | `string` | | ☐ | | | `person_custom_salutation` | `string` | | ☐ | | | `person_date_of_birth` | `string` | | ☐ | | | `person_email` | `string` | | ☐ | | | `person_facebook_url` | `string` | | ☐ | | | `person_family_name_prefix` | `string` | | ☐ | | | `person_family_name` | `string` | | ☐ | | | `person_first_name` | `string` | | ☐ | | | `person_full_name` | `string` | Person Full Name | ☐ | | | `person_gender_id` | `string` | | ☐ | | | `person_gender` | `string` | | ☐ | | | `person_id_2` | `string` | | ☐ | | | `person_id` | `string` | Person ID | ☐ | | | `person_initials` | `string` | | ☐ | | | `person_invoice_receiver` | `string` | | ☐ | | | `person_is_active` | `boolean` | | ☐ | | | `person_is_employee` | `int64` | | ☐ | | | `person_linkedin_url` | `string` | | ☐ | | | `person_mailing_list_email` | `string` | | ☐ | | | `person_note` | `string` | | ☐ | | | `person_phone` | `string` | | ☐ | | | `person_relation_manager_avatar_color` | `string` | | ☐ | | | `person_relation_manager_avatar_initials` | `string` | | ☐ | | | `person_relation_manager_avatar_url_large` | `string` | | ☐ | | | `person_relation_manager_avatar_url_small` | `string` | | ☐ | | | `person_relation_manager_bank_account` | `string` | | ☐ | | | `person_relation_manager_civil_status` | `string` | | ☐ | | | `person_relation_manager_created_at` | `string` | | ☐ | | | `person_relation_manager_created` | `string` | | ☐ | | | `person_relation_manager_employment_status` | `string` | | ☐ | | | `person_relation_manager_function` | `string` | | ☐ | | | `person_relation_manager_hourly_cost_tariff` | `float` | | ☐ | | | `person_relation_manager_hourly_sales_tariff` | `float` | | ☐ | | | `person_relation_manager_id` | `string` | | ☐ | | | `person_relation_manager_is_user` | `boolean` | | ☐ | | | `person_relation_manager_marital_status` | `string` | | ☐ | | | `person_relation_manager_modified` | `string` | | ☐ | | | `person_relation_manager_name` | `string` | | ☐ | | | `person_relation_manager_person_address_country_code` | `string` | | ☐ | | | `person_relation_manager_person_address_country_id` | `string` | | ☐ | | | `person_relation_manager_person_address_country` | `string` | | ☐ | | | `person_relation_manager_person_address_id` | `string` | | ☐ | | | `person_relation_manager_person_address_line_1` | `string` | | ☐ | | | `person_relation_manager_person_address_line_2` | `string` | | ☐ | | | `person_relation_manager_person_address_locality` | `string` | | ☐ | | | `person_relation_manager_person_address_postal_code` | `string` | | ☐ | | | `person_relation_manager_person_address_province` | `string` | | ☐ | | | `person_relation_manager_person_address_type` | `string` | | ☐ | | | `person_relation_manager_person_avatar_color` | `string` | | ☐ | | | `person_relation_manager_person_avatar_initials` | `string` | | ☐ | | | `person_relation_manager_person_avatar_url_large` | `string` | | ☐ | | | `person_relation_manager_person_avatar_url_small` | `string` | | ☐ | | | `person_relation_manager_person_bank_account` | `string` | | ☐ | | | `person_relation_manager_person_bank_bic` | `string` | | ☐ | | | `person_relation_manager_person_created_at` | `string` | | ☐ | | | `person_relation_manager_person_custom_salutation` | `string` | | ☐ | | | `person_relation_manager_person_date_of_birth` | `string` | | ☐ | | | `person_relation_manager_person_email` | `string` | | ☐ | | | `person_relation_manager_person_facebook_url` | `string` | | ☐ | | | `person_relation_manager_person_family_name_prefix` | `string` | | ☐ | | | `person_relation_manager_person_family_name` | `string` | | ☐ | | | `person_relation_manager_person_first_name` | `string` | | ☐ | | | `person_relation_manager_person_full_name` | `string` | | ☐ | | | `person_relation_manager_person_gender_id` | `string` | | ☐ | | | `person_relation_manager_person_gender` | `string` | | ☐ | | | `person_relation_manager_person_id_2` | `string` | | ☐ | | | `person_relation_manager_person_id` | `string` | | ☐ | | | `person_relation_manager_person_initials` | `string` | | ☐ | | | `person_relation_manager_person_invoice_receiver` | `string` | | ☐ | | | `person_relation_manager_person_is_active` | `boolean` | | ☐ | | | `person_relation_manager_person_is_employee` | `int64` | | ☐ | | | `person_relation_manager_person_linkedin_url` | `string` | | ☐ | | | `person_relation_manager_person_mailing_list_email` | `string` | | ☐ | | | `person_relation_manager_person_note` | `string` | | ☐ | | | `person_relation_manager_person_phone` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_avatar_color` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_avatar_initials` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_avatar_url_large` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_avatar_url_small` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_bank_account` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_civil_status` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_created_at` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_created` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_employment_status` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_function` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_hourly_cost_tariff` | `float` | | ☐ | | | `person_relation_manager_person_relation_manager_hourly_sales_tariff` | `float` | | ☐ | | | `person_relation_manager_person_relation_manager_id` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_is_user` | `boolean` | | ☐ | | | `person_relation_manager_person_relation_manager_marital_status` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_modified` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_name` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_bank_account` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_bank_bic` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_created_at` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_custom_salutation` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_date_of_birth` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_email` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_facebook_url` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_family_name_prefix` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_family_name` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_first_name` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_full_name` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_gender_id` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_gender` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_id_2` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_id` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_initials` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_invoice_receiver` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_is_active` | `boolean` | | ☐ | | | `person_relation_manager_person_relation_manager_person_is_employee` | `int64` | | ☐ | | | `person_relation_manager_person_relation_manager_person_linkedin_url` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_mailing_list_email` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_note` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_phone` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_relation_number` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_simplicate_url` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_timeline_email_address` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_twitter_url` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_updated_at` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_person_use_custom_salutation` | `boolean` | | ☐ | | | `person_relation_manager_person_relation_manager_person_website_url` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_simplicate_url` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_social_security_number` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_status_id` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_status_label` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_timeline_email_address` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_type_id` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_type_label` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_updated_at` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_work_email` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_work_mobile` | `string` | | ☐ | | | `person_relation_manager_person_relation_manager_work_phone` | `string` | | ☐ | | | `person_relation_manager_person_relation_number` | `string` | | ☐ | | | `person_relation_manager_person_relation_type_color` | `string` | | ☐ | | | `person_relation_manager_person_relation_type_id` | `string` | | ☐ | | | `person_relation_manager_person_relation_type_label` | `string` | | ☐ | | | `person_relation_manager_person_relation_type_type` | `string` | | ☐ | | | `person_relation_manager_person_simplicate_url` | `string` | | ☐ | | | `person_relation_manager_person_timeline_email_address` | `string` | | ☐ | | | `person_relation_manager_person_twitter_url` | `string` | | ☐ | | | `person_relation_manager_person_updated_at` | `string` | | ☐ | | | `person_relation_manager_person_use_custom_salutation` | `boolean` | | ☐ | | | `person_relation_manager_person_website_url` | `string` | | ☐ | | | `person_relation_manager_simplicate_url` | `string` | | ☐ | | | `person_relation_manager_social_security_number` | `string` | | ☐ | | | `person_relation_manager_status_id` | `string` | | ☐ | | | `person_relation_manager_status_label` | `string` | | ☐ | | | `person_relation_manager_timeline_email_address` | `string` | | ☐ | | | `person_relation_manager_type_id` | `string` | | ☐ | | | `person_relation_manager_type_label` | `string` | | ☐ | | | `person_relation_manager_updated_at` | `string` | | ☐ | | | `person_relation_manager_work_email` | `string` | | ☐ | | | `person_relation_manager_work_mobile` | `string` | | ☐ | | | `person_relation_manager_work_phone` | `string` | | ☐ | | | `person_relation_number` | `string` | | ☐ | | | `person_relation_type_color` | `string` | | ☐ | | | `person_relation_type_id` | `string` | | ☐ | | | `person_relation_type_label` | `string` | | ☐ | | | `person_relation_type_type` | `string` | | ☐ | | | `person_simplicate_url` | `string` | | ☐ | | | `person_timeline_email_address` | `string` | | ☐ | | | `person_twitter_url` | `string` | | ☐ | | | `person_updated_at` | `string` | | ☐ | | | `person_use_custom_salutation` | `boolean` | | ☐ | | | `person_website_url` | `string` | | ☐ | | | `simplicate_url` | `string` | Simplicate URL | ☐ | | | `social_security_number` | `string` | Citizen Service Number | ☐ | | | `status_id` | `string` | Status ID | ☐ | | | `status_label` | `string` | Status Label | ☐ | | | `timeline_email_address` | `string` | Timeline Email Address | ☐ | | | `type_id` | `string` | Type ID | ☐ | | | `type_label` | `string` | Type Label | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `work_email` | `string` | Work Email | ☐ | | | `work_mobile` | `string` | Work Mobile | ☐ | | | `work_phone` | `string` | Work Phone | ☐ | |