Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: HRM > Tables

Contracts: Simplicate Contracts

Contents Previous Home Next More

Fetches all contracts

Catalog: Simplicate

Schema: HRM

Label: Contracts

This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.

Select Simplicate API URL: /hrm/contract

Insert Simplicate API URL: /hrm/contract

Update Simplicate API URL: /hrm/contract

Delete Simplicate API URL: /hrm/contract

Field Selection Method: NotRequired

Base Path: data[*]

Select Simplicate API Operation: get /hrm/contract

Table Function Columns

The columns of the table function 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 at

 

created

string

Created

 

days_off

float

 

 

employee_avatar_color

string

 

 

employee_avatar_initials

string

 

 

employee_avatar_url_large

string

 

 

employee_avatar_url_small

string

 

 

employee_bank_account

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_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_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_1

string

 

 

employee_person_id

string

 

 

employee_person_initials

string

 

 

employee_person_invoice_receiver

string

 

 

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_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_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_1

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_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_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_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_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_name

string

 

 

employment_type_blocked

boolean

 

 

employment_type_id

string

 

 

employment_type_name

string

 

 

end_date

string

End Date

 

id

string

ID

 

last_updated

string

 

 

parttime_percentage

float

 

 

salary_fulltime

float

 

 

start_date

string

Start Date

 

updated_at

string

Updated at

 

 

06-04-2021 14:59 Version 20.1.393-BETA+3152