---
title: "EmployeeCustomFields (Simplicate)"
description: "Employee Custom Fields"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.HRM.EmployeeCustomFields
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.HRM.EmployeeCustomFields
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# EmployeeCustomFields: Simplicate Employee Custom Fields

`read only` `REST`

- Catalog: `Simplicate`
- Schema: `HRM`
- Label: Employee Custom Fields

Fetches all employees

Can only retrieve data.

## API Source

- Endpoint: `/hrm/employee`
- Operation: `get /hrm/employee`

## Table Columns

The columns of the table `EmployeeCustomFields` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `avatar_color` | `varchar2` | Avatar Colour | [ ] |  |  |
| `avatar_initials` | `varchar2` | Avatar Initials | [ ] |  |  |
| `avatar_url_large` | `varchar2` | Avatar Large (URL) | [ ] |  |  |
| `avatar_url_small` | `varchar2` | Avatar Small (URL) | [ ] |  |  |
| `bank_account` | `varchar2` | Bank Account | [ ] |  |  |
| `civil_status` | `varchar2` | Civil Status | [ ] |  |  |
| `created` | `varchar2` | Created | [ ] |  |  |
| `created_at` | `varchar2` | Created at | [ ] |  |  |
| `custom_field_group_id` | `varchar2` | Custom Field Group ID | [ ] |  |  |
| `custom_field_group_model_id` | `varchar2` | Custom Field Group Model ID | [ ] |  |  |
| `custom_field_group_model_label` | `varchar2` | Custom Field Group Model Label | [ ] |  |  |
| `custom_field_group_name` | `varchar2` | Custom Field Group Name | [ ] |  |  |
| `custom_field_group_position` | `varchar2` | Custom Field Group Position | [ ] |  |  |
| `custom_field_group_type` | `varchar2` | Custom Field Group Type | [ ] |  |  |
| `employment_status` | `varchar2` | Employment Status | [ ] |  |  |
| `filterable` | `char` | Filterable | [ ] |  |  |
| `function` | `varchar2` | Function | [ ] |  |  |
| `hourly_cost_tariff` | `double` | Hourly Cost Tariff | [ ] |  |  |
| `hourly_sales_tariff` | `double` | Hourly Sales Tariff | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `id_2` | `varchar2` | itgen_spe_id_2 | [ ] |  |  |
| `is_user` | `char` | Is User | [ ] |  |  |
| `label` | `varchar2` | Label | [ ] |  |  |
| `mandatory` | `char` | itgen_spe_mandatory | [ ] |  |  |
| `marital_status` | `varchar2` | Marital Status | [ ] |  |  |
| `modified` | `varchar2` | Modified | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `name_2` | `varchar2` | itgen_spe_name_2 | [ ] |  |  |
| `person_address_country` | `varchar2` | Person Address Country | [ ] |  |  |
| `person_address_country_code` | `varchar2` | itgen_spe_person_address_country_code | [ ] |  |  |
| `person_address_country_id` | `varchar2` | itgen_spe_person_address_country_id | [ ] |  |  |
| `person_address_id` | `varchar2` | Person Address ID | [ ] |  |  |
| `person_address_line_1` | `varchar2` | itgen_spe_person_address_line_1 | [ ] |  |  |
| `person_address_line_2` | `varchar2` | itgen_spe_person_address_line_2 | [ ] |  |  |
| `person_address_locality` | `varchar2` | Person Address Locality | [ ] |  |  |
| `person_address_postal_code` | `varchar2` | Person Address Postal Code | [ ] |  |  |
| `person_address_province` | `varchar2` | Person Address Province | [ ] |  |  |
| `person_address_type` | `varchar2` | Person Address Type | [ ] |  |  |
| `person_avatar_color` | `varchar2` | Person Avatar Colour | [ ] |  |  |
| `person_avatar_initials` | `varchar2` | Person Avatar Initials | [ ] |  |  |
| `person_avatar_url_large` | `varchar2` | Person Avatar URL Large | [ ] |  |  |
| `person_avatar_url_small` | `varchar2` | Person Avatar URL Small | [ ] |  |  |
| `person_bank_account` | `varchar2` | itgen_spe_person_bank_account | [ ] |  |  |
| `person_bank_bic` | `varchar2` | itgen_spe_person_bank_bic | [ ] |  |  |
| `person_created_at` | `varchar2` | itgen_spe_person_created_at | [ ] |  |  |
| `person_custom_salutation` | `varchar2` | itgen_spe_person_custom_salutation | [ ] |  |  |
| `person_date_of_birth` | `varchar2` | itgen_spe_person_date_of_birth | [ ] |  |  |
| `person_email` | `varchar2` | itgen_spe_person_email | [ ] |  |  |
| `person_facebook_url` | `varchar2` | itgen_spe_person_facebook_url | [ ] |  |  |
| `person_family_name` | `varchar2` | itgen_spe_person_family_name | [ ] |  |  |
| `person_family_name_prefix` | `varchar2` | itgen_spe_person_family_name_prefix | [ ] |  |  |
| `person_first_name` | `varchar2` | itgen_spe_person_first_name | [ ] |  |  |
| `person_full_name` | `varchar2` | Person Full Name | [ ] |  |  |
| `person_gender` | `varchar2` | itgen_spe_person_gender | [ ] |  |  |
| `person_gender_id` | `varchar2` | itgen_spe_person_gender_id | [ ] |  |  |
| `person_id` | `varchar2` | Person ID | [ ] |  |  |
| `person_id_2` | `varchar2` | itgen_spe_person_id_2 | [ ] |  |  |
| `person_initials` | `varchar2` | itgen_spe_person_initials | [ ] |  |  |
| `person_invoice_receiver` | `varchar2` | itgen_spe_person_invoice_receiver | [ ] |  |  |
| `person_is_active` | `char` | itgen_spe_person_is_active | [ ] |  |  |
| `person_is_employee` | `int64` | itgen_spe_person_is_employee | [ ] |  |  |
| `person_linkedin_url` | `varchar2` | itgen_spe_person_linkedin_url | [ ] |  |  |
| `person_mailing_list_email` | `varchar2` | itgen_spe_person_mailing_list_email | [ ] |  |  |
| `person_note` | `varchar2` | itgen_spe_person_note | [ ] |  |  |
| `person_phone` | `varchar2` | itgen_spe_person_phone | [ ] |  |  |
| `person_relation_manager_avatar_color` | `varchar2` | itgen_spe_person_relation_manager_avatar_color | [ ] |  |  |
| `person_relation_manager_avatar_initials` | `varchar2` | itgen_spe_person_relation_manager_avatar_initials | [ ] |  |  |
| `person_relation_manager_avatar_url_large` | `varchar2` | itgen_spe_person_relation_manager_avatar_url_large | [ ] |  |  |
| `person_relation_manager_avatar_url_small` | `varchar2` | itgen_spe_person_relation_manager_avatar_url_small | [ ] |  |  |
| `person_relation_manager_bank_account` | `varchar2` | itgen_spe_person_relation_manager_bank_account | [ ] |  |  |
| `person_relation_manager_civil_status` | `varchar2` | itgen_spe_person_relation_manager_civil_status | [ ] |  |  |
| `person_relation_manager_created` | `varchar2` | itgen_spe_person_relation_manager_created | [ ] |  |  |
| `person_relation_manager_created_at` | `varchar2` | itgen_spe_person_relation_manager_created_at | [ ] |  |  |
| `person_relation_manager_employment_status` | `varchar2` | itgen_spe_person_relation_manager_employment_status | [ ] |  |  |
| `person_relation_manager_function` | `varchar2` | itgen_spe_person_relation_manager_function | [ ] |  |  |
| `person_relation_manager_hourly_cost_tariff` | `double` | itgen_spe_person_relation_manager_hourly_cost_tariff | [ ] |  |  |
| `person_relation_manager_hourly_sales_tariff` | `double` | itgen_spe_person_relation_manager_hourly_sales_tariff | [ ] |  |  |
| `person_relation_manager_id` | `varchar2` | itgen_spe_person_relation_manager_id | [ ] |  |  |
| `person_relation_manager_is_user` | `char` | itgen_spe_person_relation_manager_is_user | [ ] |  |  |
| `person_relation_manager_marital_status` | `varchar2` | itgen_spe_person_relation_manager_marital_status | [ ] |  |  |
| `person_relation_manager_modified` | `varchar2` | itgen_spe_person_relation_manager_modified | [ ] |  |  |
| `person_relation_manager_name` | `varchar2` | itgen_spe_person_relation_manager_name | [ ] |  |  |
| `person_relation_manager_person_address_country` | `varchar2` | itgen_spe_person_relation_manager_person_address_country | [ ] |  |  |
| `person_relation_manager_person_address_country_code` | `varchar2` | itgen_spe_person_relation_manager_person_address_country_code | [ ] |  |  |
| `person_relation_manager_person_address_country_id` | `varchar2` | itgen_spe_person_relation_manager_person_address_country_id | [ ] |  |  |
| `person_relation_manager_person_address_id` | `varchar2` | itgen_spe_person_relation_manager_person_address_id | [ ] |  |  |
| `person_relation_manager_person_address_line_1` | `varchar2` | itgen_spe_person_relation_manager_person_address_line_1 | [ ] |  |  |
| `person_relation_manager_person_address_line_2` | `varchar2` | itgen_spe_person_relation_manager_person_address_line_2 | [ ] |  |  |
| `person_relation_manager_person_address_locality` | `varchar2` | itgen_spe_person_relation_manager_person_address_locality | [ ] |  |  |
| `person_relation_manager_person_address_postal_code` | `varchar2` | itgen_spe_person_relation_manager_person_address_postal_code | [ ] |  |  |
| `person_relation_manager_person_address_province` | `varchar2` | itgen_spe_person_relation_manager_person_address_province | [ ] |  |  |
| `person_relation_manager_person_address_type` | `varchar2` | itgen_spe_person_relation_manager_person_address_type | [ ] |  |  |
| `person_relation_manager_person_avatar_color` | `varchar2` | itgen_spe_person_relation_manager_person_avatar_color | [ ] |  |  |
| `person_relation_manager_person_avatar_initials` | `varchar2` | itgen_spe_person_relation_manager_person_avatar_initials | [ ] |  |  |
| `person_relation_manager_person_avatar_url_large` | `varchar2` | itgen_spe_person_relation_manager_person_avatar_url_large | [ ] |  |  |
| `person_relation_manager_person_avatar_url_small` | `varchar2` | itgen_spe_person_relation_manager_person_avatar_url_small | [ ] |  |  |
| `person_relation_manager_person_bank_account` | `varchar2` | itgen_spe_person_relation_manager_person_bank_account | [ ] |  |  |
| `person_relation_manager_person_bank_bic` | `varchar2` | itgen_spe_person_relation_manager_person_bank_bic | [ ] |  |  |
| `person_relation_manager_person_created_at` | `varchar2` | itgen_spe_person_relation_manager_person_created_at | [ ] |  |  |
| `person_relation_manager_person_custom_salutation` | `varchar2` | itgen_spe_person_relation_manager_person_custom_salutation | [ ] |  |  |
| `person_relation_manager_person_date_of_birth` | `varchar2` | itgen_spe_person_relation_manager_person_date_of_birth | [ ] |  |  |
| `person_relation_manager_person_email` | `varchar2` | itgen_spe_person_relation_manager_person_email | [ ] |  |  |
| `person_relation_manager_person_facebook_url` | `varchar2` | itgen_spe_person_relation_manager_person_facebook_url | [ ] |  |  |
| `person_relation_manager_person_family_name` | `varchar2` | itgen_spe_person_relation_manager_person_family_name | [ ] |  |  |
| `person_relation_manager_person_family_name_prefix` | `varchar2` | itgen_spe_person_relation_manager_person_family_name_prefix | [ ] |  |  |
| `person_relation_manager_person_first_name` | `varchar2` | itgen_spe_person_relation_manager_person_first_name | [ ] |  |  |
| `person_relation_manager_person_full_name` | `varchar2` | itgen_spe_person_relation_manager_person_full_name | [ ] |  |  |
| `person_relation_manager_person_gender` | `varchar2` | itgen_spe_person_relation_manager_person_gender | [ ] |  |  |
| `person_relation_manager_person_gender_id` | `varchar2` | itgen_spe_person_relation_manager_person_gender_id | [ ] |  |  |
| `person_relation_manager_person_id` | `varchar2` | itgen_spe_person_relation_manager_person_id | [ ] |  |  |
| `person_relation_manager_person_id_2` | `varchar2` | itgen_spe_person_relation_manager_person_id_2 | [ ] |  |  |
| `person_relation_manager_person_initials` | `varchar2` | itgen_spe_person_relation_manager_person_initials | [ ] |  |  |
| `person_relation_manager_person_invoice_receiver` | `varchar2` | itgen_spe_person_relation_manager_person_invoice_receiver | [ ] |  |  |
| `person_relation_manager_person_is_active` | `char` | itgen_spe_person_relation_manager_person_is_active | [ ] |  |  |
| `person_relation_manager_person_is_employee` | `int64` | itgen_spe_person_relation_manager_person_is_employee | [ ] |  |  |
| `person_relation_manager_person_linkedin_url` | `varchar2` | itgen_spe_person_relation_manager_person_linkedin_url | [ ] |  |  |
| `person_relation_manager_person_mailing_list_email` | `varchar2` | itgen_spe_person_relation_manager_person_mailing_list_email | [ ] |  |  |
| `person_relation_manager_person_note` | `varchar2` | itgen_spe_person_relation_manager_person_note | [ ] |  |  |
| `person_relation_manager_person_phone` | `varchar2` | itgen_spe_person_relation_manager_person_phone | [ ] |  |  |
| `person_relation_manager_person_relation_manager_avatar_color` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_avatar_color | [ ] |  |  |
| `person_relation_manager_person_relation_manager_avatar_initials` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_avatar_initials | [ ] |  |  |
| `person_relation_manager_person_relation_manager_avatar_url_large` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_avatar_url_large | [ ] |  |  |
| `person_relation_manager_person_relation_manager_avatar_url_small` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_avatar_url_small | [ ] |  |  |
| `person_relation_manager_person_relation_manager_bank_account` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_bank_account | [ ] |  |  |
| `person_relation_manager_person_relation_manager_civil_status` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_civil_status | [ ] |  |  |
| `person_relation_manager_person_relation_manager_created` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_created | [ ] |  |  |
| `person_relation_manager_person_relation_manager_created_at` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_created_at | [ ] |  |  |
| `person_relation_manager_person_relation_manager_employment_status` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_employment_status | [ ] |  |  |
| `person_relation_manager_person_relation_manager_function` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_function | [ ] |  |  |
| `person_relation_manager_person_relation_manager_hourly_cost_tariff` | `double` | itgen_spe_person_relation_manager_person_relation_manager_hourly_cost_tariff | [ ] |  |  |
| `person_relation_manager_person_relation_manager_hourly_sales_tariff` | `double` | itgen_spe_person_relation_manager_person_relation_manager_hourly_sales_tariff | [ ] |  |  |
| `person_relation_manager_person_relation_manager_id` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_id | [ ] |  |  |
| `person_relation_manager_person_relation_manager_is_user` | `char` | itgen_spe_person_relation_manager_person_relation_manager_is_user | [ ] |  |  |
| `person_relation_manager_person_relation_manager_marital_status` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_marital_status | [ ] |  |  |
| `person_relation_manager_person_relation_manager_modified` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_modified | [ ] |  |  |
| `person_relation_manager_person_relation_manager_name` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_name | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_bank_account` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_bank_account | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_bank_bic` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_bank_bic | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_created_at` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_created_at | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_custom_salutation` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_custom_salutation | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_date_of_birth` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_date_of_birth | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_email` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_email | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_facebook_url` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_facebook_url | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_family_name` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_family_name | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_family_name_prefix` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_family_name_prefix | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_first_name` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_first_name | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_full_name` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_full_name | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_gender` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_gender | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_gender_id` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_gender_id | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_id` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_id | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_id_2` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_id_2 | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_initials` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_initials | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_invoice_receiver` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_invoice_receiver | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_is_active` | `char` | itgen_spe_person_relation_manager_person_relation_manager_person_is_active | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_is_employee` | `int64` | itgen_spe_person_relation_manager_person_relation_manager_person_is_employee | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_linkedin_url` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_linkedin_url | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_mailing_list_email` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_mailing_list_email | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_note` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_note | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_phone` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_phone | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_relation_number` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_relation_number | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_simplicate_url` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_simplicate_url | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_timeline_email_address` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_timeline_email_address | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_twitter_url` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_twitter_url | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_updated_at` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_updated_at | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_use_custom_salutation` | `char` | itgen_spe_person_relation_manager_person_relation_manager_person_use_custom_salutation | [ ] |  |  |
| `person_relation_manager_person_relation_manager_person_website_url` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_person_website_url | [ ] |  |  |
| `person_relation_manager_person_relation_manager_simplicate_url` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_simplicate_url | [ ] |  |  |
| `person_relation_manager_person_relation_manager_social_security_number` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_social_security_number | [ ] |  |  |
| `person_relation_manager_person_relation_manager_status_id` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_status_id | [ ] |  |  |
| `person_relation_manager_person_relation_manager_status_label` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_status_label | [ ] |  |  |
| `person_relation_manager_person_relation_manager_timeline_email_address` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_timeline_email_address | [ ] |  |  |
| `person_relation_manager_person_relation_manager_type_id` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_type_id | [ ] |  |  |
| `person_relation_manager_person_relation_manager_type_label` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_type_label | [ ] |  |  |
| `person_relation_manager_person_relation_manager_updated_at` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_updated_at | [ ] |  |  |
| `person_relation_manager_person_relation_manager_work_email` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_work_email | [ ] |  |  |
| `person_relation_manager_person_relation_manager_work_mobile` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_work_mobile | [ ] |  |  |
| `person_relation_manager_person_relation_manager_work_phone` | `varchar2` | itgen_spe_person_relation_manager_person_relation_manager_work_phone | [ ] |  |  |
| `person_relation_manager_person_relation_number` | `varchar2` | itgen_spe_person_relation_manager_person_relation_number | [ ] |  |  |
| `person_relation_manager_person_relation_type_color` | `varchar2` | itgen_spe_person_relation_manager_person_relation_type_color | [ ] |  |  |
| `person_relation_manager_person_relation_type_id` | `varchar2` | itgen_spe_person_relation_manager_person_relation_type_id | [ ] |  |  |
| `person_relation_manager_person_relation_type_label` | `varchar2` | itgen_spe_person_relation_manager_person_relation_type_label | [ ] |  |  |
| `person_relation_manager_person_relation_type_type` | `varchar2` | itgen_spe_person_relation_manager_person_relation_type_type | [ ] |  |  |
| `person_relation_manager_person_simplicate_url` | `varchar2` | itgen_spe_person_relation_manager_person_simplicate_url | [ ] |  |  |
| `person_relation_manager_person_timeline_email_address` | `varchar2` | itgen_spe_person_relation_manager_person_timeline_email_address | [ ] |  |  |
| `person_relation_manager_person_twitter_url` | `varchar2` | itgen_spe_person_relation_manager_person_twitter_url | [ ] |  |  |
| `person_relation_manager_person_updated_at` | `varchar2` | itgen_spe_person_relation_manager_person_updated_at | [ ] |  |  |
| `person_relation_manager_person_use_custom_salutation` | `char` | itgen_spe_person_relation_manager_person_use_custom_salutation | [ ] |  |  |
| `person_relation_manager_person_website_url` | `varchar2` | itgen_spe_person_relation_manager_person_website_url | [ ] |  |  |
| `person_relation_manager_simplicate_url` | `varchar2` | itgen_spe_person_relation_manager_simplicate_url | [ ] |  |  |
| `person_relation_manager_social_security_number` | `varchar2` | itgen_spe_person_relation_manager_social_security_number | [ ] |  |  |
| `person_relation_manager_status_id` | `varchar2` | itgen_spe_person_relation_manager_status_id | [ ] |  |  |
| `person_relation_manager_status_label` | `varchar2` | itgen_spe_person_relation_manager_status_label | [ ] |  |  |
| `person_relation_manager_timeline_email_address` | `varchar2` | itgen_spe_person_relation_manager_timeline_email_address | [ ] |  |  |
| `person_relation_manager_type_id` | `varchar2` | itgen_spe_person_relation_manager_type_id | [ ] |  |  |
| `person_relation_manager_type_label` | `varchar2` | itgen_spe_person_relation_manager_type_label | [ ] |  |  |
| `person_relation_manager_updated_at` | `varchar2` | itgen_spe_person_relation_manager_updated_at | [ ] |  |  |
| `person_relation_manager_work_email` | `varchar2` | itgen_spe_person_relation_manager_work_email | [ ] |  |  |
| `person_relation_manager_work_mobile` | `varchar2` | itgen_spe_person_relation_manager_work_mobile | [ ] |  |  |
| `person_relation_manager_work_phone` | `varchar2` | itgen_spe_person_relation_manager_work_phone | [ ] |  |  |
| `person_relation_number` | `varchar2` | itgen_spe_person_relation_number | [ ] |  |  |
| `person_relation_type_color` | `varchar2` | itgen_spe_person_relation_type_color | [ ] |  |  |
| `person_relation_type_id` | `varchar2` | itgen_spe_person_relation_type_id | [ ] |  |  |
| `person_relation_type_label` | `varchar2` | itgen_spe_person_relation_type_label | [ ] |  |  |
| `person_relation_type_type` | `varchar2` | itgen_spe_person_relation_type_type | [ ] |  |  |
| `person_simplicate_url` | `varchar2` | itgen_spe_person_simplicate_url | [ ] |  |  |
| `person_timeline_email_address` | `varchar2` | itgen_spe_person_timeline_email_address | [ ] |  |  |
| `person_twitter_url` | `varchar2` | itgen_spe_person_twitter_url | [ ] |  |  |
| `person_updated_at` | `varchar2` | itgen_spe_person_updated_at | [ ] |  |  |
| `person_use_custom_salutation` | `char` | itgen_spe_person_use_custom_salutation | [ ] |  |  |
| `person_website_url` | `varchar2` | itgen_spe_person_website_url | [ ] |  |  |
| `position` | `int64` | Position | [ ] |  |  |
| `render_type` | `varchar2` | Render Type | [ ] |  |  |
| `searchable` | `char` | Searchable | [ ] |  |  |
| `simplicate_url` | `varchar2` | Simplicate URL | [ ] |  |  |
| `social_security_number` | `varchar2` | Social Security Number | [ ] |  |  |
| `status_id` | `varchar2` | Status ID | [ ] |  |  |
| `status_label` | `varchar2` | Status Label | [ ] |  |  |
| `timeline_email_address` | `varchar2` | Timeline Email Address | [ ] |  |  |
| `type` | `varchar2` | Type | [ ] |  |  |
| `type_2_id` | `varchar2` | itgen_spe_type_2_id | [ ] |  |  |
| `type_2_label` | `varchar2` | itgen_spe_type_2_label | [ ] |  |  |
| `updated_at` | `varchar2` | Updated at | [ ] |  |  |
| `value` | `varchar2` | Value | [ ] |  |  |
| `value_type` | `varchar2` | Value Type | [ ] |  |  |
| `work_email` | `varchar2` | Work Email | [ ] |  |  |
| `work_mobile` | `varchar2` | Work Mobile | [ ] |  |  |
| `work_phone` | `varchar2` | Work Phone | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Simplicate](/en/release-notes/drivers?driver=simplicate)

