# EmployeeCustomFields: Simplicate Employee Custom Fields Fetches all employees This is a read-only table. 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 Custom Fields ## Table Columns The columns of the table `EmployeeCustomFields` 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 | ☐ | | | `custom_field_group_id` | `string` | Custom Field Group ID | ☐ | | | `custom_field_group_model_id` | `string` | Custom Field Group Model ID | ☐ | | | `custom_field_group_model_label` | `string` | Custom Field Group Model Label | ☐ | | | `custom_field_group_name` | `string` | Custom Field Group Name | ☐ | | | `custom_field_group_position` | `string` | Custom Field Group Position | ☐ | | | `custom_field_group_type` | `string` | Custom Field Group Type | ☐ | | | `employment_status` | `string` | Employment Status | ☐ | | | `filterable` | `boolean` | Filterable | ☐ | | | `function` | `string` | Job Title | ☐ | | | `hourly_cost_tariff` | `float` | Hourly Rate | ☐ | | | `hourly_sales_tariff` | `float` | Hourly Sales Rate | ☐ | | | `id_2` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `is_user` | `boolean` | Is User | ☐ | | | `label` | `string` | Label | ☐ | | | `mandatory` | `boolean` | | ☐ | | | `marital_status` | `string` | Civil Status | ☐ | | | `modified` | `string` | Modified | ☐ | | | `name_2` | `string` | | ☐ | | | `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` | | ☐ | | | `position` | `int64` | Position | ☐ | | | `render_type` | `string` | Render Type | ☐ | | | `searchable` | `boolean` | Searchable | ☐ | | | `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_2_id` | `string` | | ☐ | | | `type_2_label` | `string` | | ☐ | | | `type` | `string` | Type | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `value_type` | `string` | Value Type | ☐ | | | `value` | `string` | Value | ☐ | | | `work_email` | `string` | Work Email | ☐ | | | `work_mobile` | `string` | Work Mobile | ☐ | | | `work_phone` | `string` | Work Phone | ☐ | |