ContractById: Simplicate Contract by ID
read only REST
- Catalog:
Simplicate - Schema:
HRM - Label: Contract by ID
Fetches a single contract by id
Can only retrieve data.
API Source
- Endpoint:
/hrm/contract/{id} - Operation:
get /hrm/contract/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | The template's id |
Table Columns
The columns of the table ContractById 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 |
|---|---|---|---|---|---|
contract_ |
char |
itgen_spe_contract_type_blocked | |||
contract_ |
varchar2 |
itgen_spe_contract_type_id | |||
contract_ |
varchar2 |
itgen_spe_contract_type_name | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Created at | |||
days_ |
double |
Days Off | |||
employee_ |
varchar2 |
itgen_spe_employee_avatar_color | |||
employee_ |
varchar2 |
itgen_spe_employee_avatar_initials | |||
employee_ |
varchar2 |
itgen_spe_employee_avatar_url_large | |||
employee_ |
varchar2 |
itgen_spe_employee_avatar_url_small | |||
employee_ |
varchar2 |
itgen_spe_employee_bank_account | |||
employee_ |
varchar2 |
itgen_spe_employee_civil_status | |||
employee_ |
varchar2 |
itgen_spe_employee_created | |||
employee_ |
varchar2 |
itgen_spe_employee_created_at | |||
employee_ |
varchar2 |
itgen_spe_employee_employment_status | |||
employee_ |
varchar2 |
itgen_spe_employee_function | |||
employee_ |
double |
itgen_spe_employee_hourly_cost_tariff | |||
employee_ |
double |
itgen_spe_employee_hourly_sales_tariff | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
char |
itgen_spe_employee_is_user | |||
employee_ |
varchar2 |
itgen_spe_employee_marital_status | |||
employee_ |
varchar2 |
itgen_spe_employee_modified | |||
employee_ |
varchar2 |
Employee Name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_country | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_country_code | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_country_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_line_1 | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_line_2 | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_locality | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_postal_code | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_province | |||
employee_ |
varchar2 |
itgen_spe_employee_person_address_type | |||
employee_ |
varchar2 |
itgen_spe_employee_person_avatar_color | |||
employee_ |
varchar2 |
itgen_spe_employee_person_avatar_initials | |||
employee_ |
varchar2 |
itgen_spe_employee_person_avatar_url_large | |||
employee_ |
varchar2 |
itgen_spe_employee_person_avatar_url_small | |||
employee_ |
varchar2 |
itgen_spe_employee_person_bank_account | |||
employee_ |
varchar2 |
itgen_spe_employee_person_bank_bic | |||
employee_ |
varchar2 |
itgen_spe_employee_person_created_at | |||
employee_ |
varchar2 |
itgen_spe_employee_person_custom_salutation | |||
employee_ |
varchar2 |
itgen_spe_employee_person_date_of_birth | |||
employee_ |
varchar2 |
itgen_spe_employee_person_email | |||
employee_ |
varchar2 |
itgen_spe_employee_person_facebook_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_family_name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_family_name_prefix | |||
employee_ |
varchar2 |
itgen_spe_employee_person_first_name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_full_name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_gender | |||
employee_ |
varchar2 |
itgen_spe_employee_person_gender_id | |||
employee_ |
varchar2 |
Employee Person ID | |||
employee_ |
varchar2 |
itgen_spe_employee_person_id_2 | |||
employee_ |
varchar2 |
itgen_spe_employee_person_initials | |||
employee_ |
varchar2 |
itgen_spe_employee_person_invoice_receiver | |||
employee_ |
char |
itgen_spe_employee_person_is_active | |||
employee_ |
int64 |
itgen_spe_employee_person_is_employee | |||
employee_ |
varchar2 |
itgen_spe_employee_person_linkedin_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_mailing_list_email | |||
employee_ |
varchar2 |
itgen_spe_employee_person_note | |||
employee_ |
varchar2 |
itgen_spe_employee_person_phone | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_avatar_color | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_avatar_initials | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_avatar_url_large | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_avatar_url_small | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_bank_account | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_civil_status | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_created | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_created_at | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_employment_status | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_function | |||
employee_ |
double |
itgen_spe_employee_person_relation_manager_hourly_cost_tariff | |||
employee_ |
double |
itgen_spe_employee_person_relation_manager_hourly_sales_tariff | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_id | |||
employee_ |
char |
itgen_spe_employee_person_relation_manager_is_user | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_marital_status | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_modified | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_country | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_country_code | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_country_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_line_1 | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_line_2 | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_locality | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_postal_code | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_province | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_address_type | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_avatar_color | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_avatar_initials | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_avatar_url_large | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_avatar_url_small | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_bank_account | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_bank_bic | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_created_at | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_custom_salutation | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_date_of_birth | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_email | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_facebook_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_family_name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_family_name_prefix | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_first_name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_full_name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_gender | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_gender_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_id_2 | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_initials | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_invoice_receiver | |||
employee_ |
char |
itgen_spe_employee_person_relation_manager_person_is_active | |||
employee_ |
int64 |
itgen_spe_employee_person_relation_manager_person_is_employee | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_linkedin_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_mailing_list_email | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_note | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_phone | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_bank_account | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_civil_status | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_created | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_created_at | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_employment_status | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_function | |||
employee_ |
double |
itgen_spe_employee_person_relation_manager_person_relation_manager_hourly_cost_tariff | |||
employee_ |
double |
itgen_spe_employee_person_relation_manager_person_relation_manager_hourly_sales_tariff | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_id | |||
employee_ |
char |
itgen_spe_employee_person_relation_manager_person_relation_manager_is_user | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_marital_status | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_modified | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_name | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_person_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_simplicate_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_social_security_number | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_timeline_email_address | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_updated_at | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_work_email | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_work_mobile | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_manager_work_phone | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_number | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_type_color | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_type_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_type_label | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_relation_type_type | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_simplicate_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_timeline_email_address | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_twitter_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_updated_at | |||
employee_ |
char |
itgen_spe_employee_person_relation_manager_person_use_custom_salutation | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_person_website_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_simplicate_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_social_security_number | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_status_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_status_label | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_timeline_email_address | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_type_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_type_label | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_updated_at | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_work_email | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_work_mobile | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_manager_work_phone | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_number | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_type_color | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_type_id | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_type_label | |||
employee_ |
varchar2 |
itgen_spe_employee_person_relation_type_type | |||
employee_ |
varchar2 |
itgen_spe_employee_person_simplicate_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_timeline_email_address | |||
employee_ |
varchar2 |
itgen_spe_employee_person_twitter_url | |||
employee_ |
varchar2 |
itgen_spe_employee_person_updated_at | |||
employee_ |
char |
itgen_spe_employee_person_use_custom_salutation | |||
employee_ |
varchar2 |
itgen_spe_employee_person_website_url | |||
employee_ |
varchar2 |
itgen_spe_employee_simplicate_url | |||
employee_ |
varchar2 |
itgen_spe_employee_social_security_number | |||
employee_ |
varchar2 |
itgen_spe_employee_status_id | |||
employee_ |
varchar2 |
itgen_spe_employee_status_label | |||
employee_ |
varchar2 |
itgen_spe_employee_timeline_email_address | |||
employee_ |
varchar2 |
itgen_spe_employee_type_id | |||
employee_ |
varchar2 |
itgen_spe_employee_type_label | |||
employee_ |
varchar2 |
itgen_spe_employee_updated_at | |||
employee_ |
varchar2 |
itgen_spe_employee_work_email | |||
employee_ |
varchar2 |
itgen_spe_employee_work_mobile | |||
employee_ |
varchar2 |
itgen_spe_employee_work_phone | |||
employer_ |
varchar2 |
Employer ID | |||
employer_ |
varchar2 |
Employer Name | |||
employment_ |
char |
itgen_spe_employment_type_blocked | |||
employment_ |
varchar2 |
itgen_spe_employment_type_id | |||
employment_ |
varchar2 |
itgen_spe_employment_type_name | |||
end_ |
varchar2 |
End Date | |||
id |
varchar2 |
ID | |||
last_ |
varchar2 |
Last Updated | |||
parttime_ |
double |
Parttime Percentage | |||
salary_ |
double |
Salary Fulltime | |||
start_ |
varchar2 |
Start Date | |||
updated_ |
varchar2 |
Updated at |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: