ContractById: Simplicate Vertrag nach ID
read only REST
- Katalog:
Simplicate - Schema:
HRM - Bezeichnung: Vertrag nach ID
Ruft einen einzelnen Vertrag anhand der ID ab
Es können nur Daten abgerufen werden.
API-Quelle
- Endpunkt:
/hrm/contract/{id} - Operation:
get /hrm/contract/{id}
Parameter
| Name | Datentyp | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | Die ID der Vorlage |
Tabellenspalten
Die Spalten der Tabelle ContractById sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | 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 |
Erstellt bei | |||
days_ |
double |
Freie Tage | |||
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 |
Mitarbeiter ID | |||
employee_ |
char |
itgen_spe_employee_is_user | |||
employee_ |
varchar2 |
itgen_spe_employee_marital_status | |||
employee_ |
varchar2 |
itgen_spe_employee_modified | |||
employee_ |
varchar2 |
Mitarbeitername | |||
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 |
Mitarbeiter-Personen-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 |
Arbeitgeber-ID | |||
employer_ |
varchar2 |
Name des Arbeitsgebers | |||
employment_ |
char |
itgen_spe_employment_type_blocked | |||
employment_ |
varchar2 |
itgen_spe_employment_type_id | |||
employment_ |
varchar2 |
itgen_spe_employment_type_name | |||
end_ |
varchar2 |
Enddatum | |||
id |
varchar2 |
ID | |||
last_ |
varchar2 |
Letzte Aktualisierung | |||
parttime_ |
double |
Teilzeitanteil | |||
salary_ |
double |
Gehalt (Vollzeit) | |||
start_ |
varchar2 |
Anfangsdatum | |||
updated_ |
varchar2 |
Aktualisiert am |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: