Contrats : Contrats Simplicate
read only REST
- Catalogue :
Simplicate - Schéma :
HRM - Libellé : Contrats
Récupère tous les contrats
Permet uniquement de récupérer des données.
Source de l'API
- Point de terminaison :
/hrm/contract - Opération :
get /hrm/contract
Colonnes de table
Les colonnes de la table Contracts sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | 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 |
Créé le | |||
days_ |
double |
Jours de congés | |||
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 |
ID d'employé | |||
employee_ |
char |
itgen_spe_employee_is_user | |||
employee_ |
varchar2 |
itgen_spe_employee_marital_status | |||
employee_ |
varchar2 |
itgen_spe_employee_modified | |||
employee_ |
varchar2 |
Nom de l’employé | |||
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 |
Numéro d'identification de l’employé | |||
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 |
ID de l'employeur | |||
employer_ |
varchar2 |
Nom de l'employeur | |||
employment_ |
char |
itgen_spe_employment_type_blocked | |||
employment_ |
varchar2 |
itgen_spe_employment_type_id | |||
employment_ |
varchar2 |
itgen_spe_employment_type_name | |||
end_ |
varchar2 |
Date de fin | |||
id |
varchar2 |
ID | |||
last_ |
varchar2 |
Dernière mise à jour | |||
parttime_ |
double |
Pourcentage de temps partiel | |||
salary_ |
double |
Salaire à temps plein | |||
start_ |
varchar2 |
Date de début | |||
updated_ |
varchar2 |
Mise à jour à |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :