# Contracts: Simplicate Contracts Fetches all contracts 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: Contracts ## Table Columns The columns of the table `Contracts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `contract_type_blocked` | `boolean` | | ☐ | | | `contract_type_id` | `string` | | ☐ | | | `contract_type_name` | `string` | | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `created` | `string` | Created | ☐ | | | `days_off` | `float` | Days Absent | ☐ | | | `employee_avatar_color` | `string` | | ☐ | | | `employee_avatar_initials` | `string` | | ☐ | | | `employee_avatar_url_large` | `string` | | ☐ | | | `employee_avatar_url_small` | `string` | | ☐ | | | `employee_bank_account` | `string` | | ☐ | | | `employee_civil_status` | `string` | | ☐ | | | `employee_created_at` | `string` | | ☐ | | | `employee_created` | `string` | | ☐ | | | `employee_employment_status` | `string` | | ☐ | | | `employee_function` | `string` | | ☐ | | | `employee_hourly_cost_tariff` | `float` | | ☐ | | | `employee_hourly_sales_tariff` | `float` | | ☐ | | | `employee_id` | `string` | Employee ID | ☐ | | | `employee_is_user` | `boolean` | | ☐ | | | `employee_marital_status` | `string` | | ☐ | | | `employee_modified` | `string` | | ☐ | | | `employee_name` | `string` | Employee Name | ☐ | | | `employee_person_address_country_code` | `string` | | ☐ | | | `employee_person_address_country_id` | `string` | | ☐ | | | `employee_person_address_country` | `string` | | ☐ | | | `employee_person_address_id` | `string` | | ☐ | | | `employee_person_address_line_1` | `string` | | ☐ | | | `employee_person_address_line_2` | `string` | | ☐ | | | `employee_person_address_locality` | `string` | | ☐ | | | `employee_person_address_postal_code` | `string` | | ☐ | | | `employee_person_address_province` | `string` | | ☐ | | | `employee_person_address_type` | `string` | | ☐ | | | `employee_person_avatar_color` | `string` | | ☐ | | | `employee_person_avatar_initials` | `string` | | ☐ | | | `employee_person_avatar_url_large` | `string` | | ☐ | | | `employee_person_avatar_url_small` | `string` | | ☐ | | | `employee_person_bank_account` | `string` | | ☐ | | | `employee_person_bank_bic` | `string` | | ☐ | | | `employee_person_created_at` | `string` | | ☐ | | | `employee_person_custom_salutation` | `string` | | ☐ | | | `employee_person_date_of_birth` | `string` | | ☐ | | | `employee_person_email` | `string` | | ☐ | | | `employee_person_facebook_url` | `string` | | ☐ | | | `employee_person_family_name_prefix` | `string` | | ☐ | | | `employee_person_family_name` | `string` | | ☐ | | | `employee_person_first_name` | `string` | | ☐ | | | `employee_person_full_name` | `string` | | ☐ | | | `employee_person_gender_id` | `string` | | ☐ | | | `employee_person_gender` | `string` | | ☐ | | | `employee_person_id_2` | `string` | | ☐ | | | `employee_person_id` | `string` | Employee Person ID | ☐ | | | `employee_person_initials` | `string` | | ☐ | | | `employee_person_invoice_receiver` | `string` | | ☐ | | | `employee_person_is_active` | `boolean` | | ☐ | | | `employee_person_is_employee` | `int64` | | ☐ | | | `employee_person_linkedin_url` | `string` | | ☐ | | | `employee_person_mailing_list_email` | `string` | | ☐ | | | `employee_person_note` | `string` | | ☐ | | | `employee_person_phone` | `string` | | ☐ | | | `employee_person_relation_manager_avatar_color` | `string` | | ☐ | | | `employee_person_relation_manager_avatar_initials` | `string` | | ☐ | | | `employee_person_relation_manager_avatar_url_large` | `string` | | ☐ | | | `employee_person_relation_manager_avatar_url_small` | `string` | | ☐ | | | `employee_person_relation_manager_bank_account` | `string` | | ☐ | | | `employee_person_relation_manager_civil_status` | `string` | | ☐ | | | `employee_person_relation_manager_created_at` | `string` | | ☐ | | | `employee_person_relation_manager_created` | `string` | | ☐ | | | `employee_person_relation_manager_employment_status` | `string` | | ☐ | | | `employee_person_relation_manager_function` | `string` | | ☐ | | | `employee_person_relation_manager_hourly_cost_tariff` | `float` | | ☐ | | | `employee_person_relation_manager_hourly_sales_tariff` | `float` | | ☐ | | | `employee_person_relation_manager_id` | `string` | | ☐ | | | `employee_person_relation_manager_is_user` | `boolean` | | ☐ | | | `employee_person_relation_manager_marital_status` | `string` | | ☐ | | | `employee_person_relation_manager_modified` | `string` | | ☐ | | | `employee_person_relation_manager_name` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_country_code` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_country_id` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_country` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_id` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_line_1` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_line_2` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_locality` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_postal_code` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_province` | `string` | | ☐ | | | `employee_person_relation_manager_person_address_type` | `string` | | ☐ | | | `employee_person_relation_manager_person_avatar_color` | `string` | | ☐ | | | `employee_person_relation_manager_person_avatar_initials` | `string` | | ☐ | | | `employee_person_relation_manager_person_avatar_url_large` | `string` | | ☐ | | | `employee_person_relation_manager_person_avatar_url_small` | `string` | | ☐ | | | `employee_person_relation_manager_person_bank_account` | `string` | | ☐ | | | `employee_person_relation_manager_person_bank_bic` | `string` | | ☐ | | | `employee_person_relation_manager_person_created_at` | `string` | | ☐ | | | `employee_person_relation_manager_person_custom_salutation` | `string` | | ☐ | | | `employee_person_relation_manager_person_date_of_birth` | `string` | | ☐ | | | `employee_person_relation_manager_person_email` | `string` | | ☐ | | | `employee_person_relation_manager_person_facebook_url` | `string` | | ☐ | | | `employee_person_relation_manager_person_family_name_prefix` | `string` | | ☐ | | | `employee_person_relation_manager_person_family_name` | `string` | | ☐ | | | `employee_person_relation_manager_person_first_name` | `string` | | ☐ | | | `employee_person_relation_manager_person_full_name` | `string` | | ☐ | | | `employee_person_relation_manager_person_gender_id` | `string` | | ☐ | | | `employee_person_relation_manager_person_gender` | `string` | | ☐ | | | `employee_person_relation_manager_person_id_2` | `string` | | ☐ | | | `employee_person_relation_manager_person_id` | `string` | | ☐ | | | `employee_person_relation_manager_person_initials` | `string` | | ☐ | | | `employee_person_relation_manager_person_invoice_receiver` | `string` | | ☐ | | | `employee_person_relation_manager_person_is_active` | `boolean` | | ☐ | | | `employee_person_relation_manager_person_is_employee` | `int64` | | ☐ | | | `employee_person_relation_manager_person_linkedin_url` | `string` | | ☐ | | | `employee_person_relation_manager_person_mailing_list_email` | `string` | | ☐ | | | `employee_person_relation_manager_person_note` | `string` | | ☐ | | | `employee_person_relation_manager_person_phone` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_bank_account` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_civil_status` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_created_at` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_created` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_employment_status` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_function` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_hourly_cost_tariff` | `float` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_hourly_sales_tariff` | `float` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_id` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_is_user` | `boolean` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_marital_status` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_modified` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_name` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_person_id` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_simplicate_url` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_social_security_number` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_timeline_email_address` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_updated_at` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_work_email` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_work_mobile` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_manager_work_phone` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_number` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_type_color` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_type_id` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_type_label` | `string` | | ☐ | | | `employee_person_relation_manager_person_relation_type_type` | `string` | | ☐ | | | `employee_person_relation_manager_person_simplicate_url` | `string` | | ☐ | | | `employee_person_relation_manager_person_timeline_email_address` | `string` | | ☐ | | | `employee_person_relation_manager_person_twitter_url` | `string` | | ☐ | | | `employee_person_relation_manager_person_updated_at` | `string` | | ☐ | | | `employee_person_relation_manager_person_use_custom_salutation` | `boolean` | | ☐ | | | `employee_person_relation_manager_person_website_url` | `string` | | ☐ | | | `employee_person_relation_manager_simplicate_url` | `string` | | ☐ | | | `employee_person_relation_manager_social_security_number` | `string` | | ☐ | | | `employee_person_relation_manager_status_id` | `string` | | ☐ | | | `employee_person_relation_manager_status_label` | `string` | | ☐ | | | `employee_person_relation_manager_timeline_email_address` | `string` | | ☐ | | | `employee_person_relation_manager_type_id` | `string` | | ☐ | | | `employee_person_relation_manager_type_label` | `string` | | ☐ | | | `employee_person_relation_manager_updated_at` | `string` | | ☐ | | | `employee_person_relation_manager_work_email` | `string` | | ☐ | | | `employee_person_relation_manager_work_mobile` | `string` | | ☐ | | | `employee_person_relation_manager_work_phone` | `string` | | ☐ | | | `employee_person_relation_number` | `string` | | ☐ | | | `employee_person_relation_type_color` | `string` | | ☐ | | | `employee_person_relation_type_id` | `string` | | ☐ | | | `employee_person_relation_type_label` | `string` | | ☐ | | | `employee_person_relation_type_type` | `string` | | ☐ | | | `employee_person_simplicate_url` | `string` | | ☐ | | | `employee_person_timeline_email_address` | `string` | | ☐ | | | `employee_person_twitter_url` | `string` | | ☐ | | | `employee_person_updated_at` | `string` | | ☐ | | | `employee_person_use_custom_salutation` | `boolean` | | ☐ | | | `employee_person_website_url` | `string` | | ☐ | | | `employee_simplicate_url` | `string` | | ☐ | | | `employee_social_security_number` | `string` | | ☐ | | | `employee_status_id` | `string` | | ☐ | | | `employee_status_label` | `string` | | ☐ | | | `employee_timeline_email_address` | `string` | | ☐ | | | `employee_type_id` | `string` | | ☐ | | | `employee_type_label` | `string` | | ☐ | | | `employee_updated_at` | `string` | | ☐ | | | `employee_work_email` | `string` | | ☐ | | | `employee_work_mobile` | `string` | | ☐ | | | `employee_work_phone` | `string` | | ☐ | | | `employer_id` | `string` | Employer ID | ☐ | | | `employer_name` | `string` | Employer Name | ☐ | | | `employment_type_blocked` | `boolean` | | ☐ | | | `employment_type_id` | `string` | | ☐ | | | `employment_type_name` | `string` | | ☐ | | | `end_date` | `string` | End Date | ☐ | | | `id` | `string` | ID | ☐ | | | `last_updated` | `string` | Last Updated | ☐ | | | `parttime_percentage` | `float` | Part-Time Percentage | ☐ | | | `salary_fulltime` | `float` | Full-Time Salary | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `updated_at` | `string` | Updated On | ☐ | |