EmployeeCustomFieldOptions: Simplicate itgen_spe_employeecustomfieldoptions_plural
read only REST
- Catalogo:
Simplicate - Schema:
HRM - Etichetta: itgen_spe_employeecustomfieldoptions_plural
Recupera tutti i dipendenti
È possibile solo recuperare i dati.
Codice sorgente dell'API
- Punto finale:
/hrm/employee - Operazione:
get /hrm/employee
Colonne della tabella
Di seguito sono riportate le colonne della tabella EmployeeCustomFieldOptions. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
avatar_ |
varchar2 |
Colore dell'avatar | |||
avatar_ |
varchar2 |
Iniziali dell'avatar | |||
avatar_ |
varchar2 |
Avatar grande (URL) | |||
avatar_ |
varchar2 |
Avatar piccolo (URL) | |||
bank_ |
varchar2 |
Conto bancario | |||
civil_ |
varchar2 |
Stato civile | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Creato il | |||
custom_ |
varchar2 |
ID del gruppo di campi personalizzato | |||
custom_ |
varchar2 |
ID del modello del gruppo di campi personalizzato | |||
custom_ |
varchar2 |
Etichetta modello gruppo di campi personalizzati | |||
custom_ |
varchar2 |
Nome del gruppo di campi personalizzato | |||
custom_ |
varchar2 |
Posizione del gruppo di campi personalizzato | |||
custom_ |
varchar2 |
Tipo di gruppo di campi personalizzato | |||
employment_ |
varchar2 |
Situazione occupazionale | |||
filterable |
char |
Filterable | |||
function |
varchar2 |
Function | |||
hourly_ |
double |
Tariffa oraria | |||
hourly_ |
double |
Tariffa oraria di vendita | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
id_3 |
varchar2 |
itgen_spe_id_3 | |||
is_ |
char |
È utente | |||
label |
varchar2 |
Label | |||
label_ |
varchar2 |
itgen_spe_label_2 | |||
mandatory |
char |
itgen_spe_mandatory | |||
marital_ |
varchar2 |
Stato civile | |||
modified |
varchar2 |
Modified | |||
name |
varchar2 |
Name | |||
name_2 |
varchar2 |
itgen_spe_name_2 | |||
person_ |
varchar2 |
Paese dell'indirizzo della persona | |||
person_ |
varchar2 |
itgen_spe_person_address_country_code | |||
person_ |
varchar2 |
itgen_spe_person_address_country_id | |||
person_ |
varchar2 |
ID indirizzo persona | |||
person_ |
varchar2 |
itgen_spe_person_address_line_1 | |||
person_ |
varchar2 |
itgen_spe_person_address_line_2 | |||
person_ |
varchar2 |
Indirizzo della persona Località | |||
person_ |
varchar2 |
Indirizzo della persona Codice postale | |||
person_ |
varchar2 |
Indirizzo persona Provincia | |||
person_ |
varchar2 |
Tipo di indirizzo della persona | |||
person_ |
varchar2 |
Colore dell'avatar della persona | |||
person_ |
varchar2 |
Iniziali dell'avatar della persona | |||
person_ |
varchar2 |
URL dell'avatar della persona grande | |||
person_ |
varchar2 |
URL dell'avatar della persona: piccolo | |||
person_ |
varchar2 |
itgen_spe_person_bank_account | |||
person_ |
varchar2 |
itgen_spe_person_bank_bic | |||
person_ |
varchar2 |
itgen_spe_person_created_at | |||
person_ |
varchar2 |
itgen_spe_person_custom_salutation | |||
person_ |
varchar2 |
itgen_spe_person_date_of_birth | |||
person_ |
varchar2 |
itgen_spe_person_email | |||
person_ |
varchar2 |
itgen_spe_person_facebook_url | |||
person_ |
varchar2 |
itgen_spe_person_family_name | |||
person_ |
varchar2 |
itgen_spe_person_family_name_prefix | |||
person_ |
varchar2 |
itgen_spe_person_first_name | |||
person_ |
varchar2 |
Nome completo della persona | |||
person_ |
varchar2 |
itgen_spe_person_gender | |||
person_ |
varchar2 |
itgen_spe_person_gender_id | |||
person_ |
varchar2 |
ID persona | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_initials | |||
person_ |
varchar2 |
itgen_spe_person_invoice_receiver | |||
person_ |
char |
itgen_spe_person_is_active | |||
person_ |
int64 |
itgen_spe_person_is_employee | |||
person_ |
varchar2 |
itgen_spe_person_linkedin_url | |||
person_ |
varchar2 |
itgen_spe_person_mailing_list_email | |||
person_ |
varchar2 |
itgen_spe_person_note | |||
person_ |
varchar2 |
itgen_spe_person_phone | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_avatar_color | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_avatar_initials | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_avatar_url_large | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_avatar_url_small | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_bank_account | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_civil_status | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_created | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_created_at | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_employment_status | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_function | |||
person_ |
double |
itgen_spe_person_relation_manager_hourly_cost_tariff | |||
person_ |
double |
itgen_spe_person_relation_manager_hourly_sales_tariff | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_id | |||
person_ |
char |
itgen_spe_person_relation_manager_is_user | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_marital_status | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_modified | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_name | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_country | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_country_code | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_country_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_line_1 | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_line_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_locality | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_postal_code | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_province | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_address_type | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_avatar_color | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_avatar_initials | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_avatar_url_large | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_avatar_url_small | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_bank_account | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_bank_bic | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_created_at | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_custom_salutation | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_date_of_birth | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_email | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_facebook_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_family_name | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_family_name_prefix | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_first_name | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_full_name | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_gender | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_gender_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_initials | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_invoice_receiver | |||
person_ |
char |
itgen_spe_person_relation_manager_person_is_active | |||
person_ |
int64 |
itgen_spe_person_relation_manager_person_is_employee | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_linkedin_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_mailing_list_email | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_note | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_phone | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_avatar_color | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_avatar_initials | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_avatar_url_large | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_avatar_url_small | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_bank_account | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_civil_status | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_created | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_created_at | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_employment_status | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_function | |||
person_ |
double |
itgen_spe_person_relation_manager_person_relation_manager_hourly_cost_tariff | |||
person_ |
double |
itgen_spe_person_relation_manager_person_relation_manager_hourly_sales_tariff | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_id | |||
person_ |
char |
itgen_spe_person_relation_manager_person_relation_manager_is_user | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_marital_status | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_modified | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_name | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_bank_account | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_bank_bic | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_created_at | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_custom_salutation | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_date_of_birth | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_email | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_facebook_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_family_name | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_family_name_prefix | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_first_name | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_full_name | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_gender | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_gender_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_initials | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_invoice_receiver | |||
person_ |
char |
itgen_spe_person_relation_manager_person_relation_manager_person_is_active | |||
person_ |
int64 |
itgen_spe_person_relation_manager_person_relation_manager_person_is_employee | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_linkedin_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_mailing_list_email | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_note | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_phone | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_relation_number | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_simplicate_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_timeline_email_address | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_twitter_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_updated_at | |||
person_ |
char |
itgen_spe_person_relation_manager_person_relation_manager_person_use_custom_salutation | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_person_website_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_simplicate_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_social_security_number | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_status_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_status_label | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_timeline_email_address | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_type_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_type_label | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_updated_at | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_work_email | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_work_mobile | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_manager_work_phone | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_number | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_type_color | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_type_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_type_label | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_relation_type_type | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_simplicate_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_timeline_email_address | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_twitter_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_updated_at | |||
person_ |
char |
itgen_spe_person_relation_manager_person_use_custom_salutation | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_person_website_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_simplicate_url | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_social_security_number | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_status_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_status_label | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_timeline_email_address | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_type_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_type_label | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_updated_at | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_work_email | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_work_mobile | |||
person_ |
varchar2 |
itgen_spe_person_relation_manager_work_phone | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
person_ |
varchar2 |
itgen_spe_person_relation_type_color | |||
person_ |
varchar2 |
itgen_spe_person_relation_type_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_type_label | |||
person_ |
varchar2 |
itgen_spe_person_relation_type_type | |||
person_ |
varchar2 |
itgen_spe_person_simplicate_url | |||
person_ |
varchar2 |
itgen_spe_person_timeline_email_address | |||
person_ |
varchar2 |
itgen_spe_person_twitter_url | |||
person_ |
varchar2 |
itgen_spe_person_updated_at | |||
person_ |
char |
itgen_spe_person_use_custom_salutation | |||
person_ |
varchar2 |
itgen_spe_person_website_url | |||
position |
int64 |
Position | |||
position_ |
int64 |
itgen_spe_position_2 | |||
render_ |
varchar2 |
Tipo di rendering | |||
searchable |
char |
Searchable | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
social_ |
varchar2 |
Numero della sicurezza sociale | |||
status_ |
varchar2 |
ID dello stato | |||
status_ |
varchar2 |
Etichetta dello stato | |||
timeline_ |
varchar2 |
Indirizzo e-mail della timeline | |||
type |
varchar2 |
Type | |||
type_ |
varchar2 |
itgen_spe_type_2_id | |||
type_ |
varchar2 |
itgen_spe_type_2_label | |||
updated_ |
varchar2 |
Aggiornato il | |||
value |
varchar2 |
Value | |||
value_ |
varchar2 |
itgen_spe_value_2 | |||
value_ |
varchar2 |
Tipo di valore | |||
work_ |
varchar2 |
Email di lavoro | |||
work_ |
varchar2 |
Cellulare lavoro | |||
work_ |
varchar2 |
Telefono di lavoro |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: