Employees: Simplicate Werknemers |
Fetches all employees
Catalogus: Simplicate
Schema: HRM
Label: Werknemers
Ophalen: true
Invoegen: true
Bijwerken: false
Verwijderen: false
Tabelkolommen
De kolommen van de tabel Employees worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet tijdens het invoegen steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
avatar_color |
string |
Avatarkleur |
☐ |
|
avatar_initials |
string |
Avatar initialen |
☐ |
|
avatar_url_large |
string |
Avatar Groot (URL) |
☐ |
|
avatar_url_small |
string |
Avatar klein (URL) |
☐ |
|
bank_account |
string |
Bankrekening |
☐ |
|
civil_status |
string |
Burgerlijke Staat |
☐ |
|
created_at |
string |
Aangemaakt op |
☐ |
|
created |
string |
Gemaakt |
☐ |
|
employment_status |
string |
Dienstverbandstatus |
☐ |
|
function |
string |
Functie |
☐ |
|
hourly_cost_tariff |
float |
Tarief per Uur |
☐ |
|
hourly_sales_tariff |
float |
Verkooptarief per Uur |
☐ |
|
id |
string |
ID |
☐ |
|
is_user |
boolean |
Is Gebruiker |
☐ |
|
marital_status |
string |
Burgerlijke Staat |
☐ |
|
modified |
string |
Gewijzigd |
☐ |
|
name |
string |
Naam |
☐ |
|
person_address_country_code |
string |
|
☐ |
|
person_address_country_id |
string |
|
☐ |
|
person_address_country |
string |
Persoon Adres Land |
☐ |
|
person_address_id |
string |
Persoonadres ID |
☐ |
|
person_address_line_1 |
string |
|
☐ |
|
person_address_line_2 |
string |
|
☐ |
|
person_address_locality |
string |
Persoon Adres Plaats |
☐ |
|
person_address_postal_code |
string |
Persoon Adres Postcode |
☐ |
|
person_address_province |
string |
Persoon Adres Provincie |
☐ |
|
person_address_type |
string |
Persoonadres Type |
☐ |
|
person_avatar_color |
string |
Persoon Avatar Kleur |
☐ |
|
person_avatar_initials |
string |
Avatar-initialen van Persoon |
☐ |
|
person_avatar_url_large |
string |
Persoon Avatar URL Groot |
☐ |
|
person_avatar_url_small |
string |
Persoon Avatar URL Klein |
☐ |
|
person_bank_account |
string |
|
☐ |
|
person_bank_bic |
string |
|
☐ |
|
person_created_at |
string |
|
☐ |
|
person_custom_salutation |
string |
|
☐ |
|
person_date_of_birth |
string |
|
☐ |
|
person_email |
string |
|
☐ |
|
person_facebook_url |
string |
|
☐ |
|
person_family_name_prefix |
string |
|
☐ |
|
person_family_name |
string |
|
☐ |
|
person_first_name |
string |
|
☐ |
|
person_full_name |
string |
Volledige Naam Persoon |
☐ |
|
person_gender_id |
string |
|
☐ |
|
person_gender |
string |
|
☐ |
|
person_id_2 |
string |
|
☐ |
|
person_id |
string |
Persoon ID |
☐ |
|
person_initials |
string |
|
☐ |
|
person_invoice_receiver |
string |
|
☐ |
|
person_is_active |
boolean |
|
☐ |
|
person_is_employee |
int64 |
|
☐ |
|
person_linkedin_url |
string |
|
☐ |
|
person_mailing_list_email |
string |
|
☐ |
|
person_note |
string |
|
☐ |
|
person_phone |
string |
|
☐ |
|
person_relation_manager_avatar_color |
string |
|
☐ |
|
person_relation_manager_avatar_initials |
string |
|
☐ |
|
person_relation_manager_avatar_url_large |
string |
|
☐ |
|
person_relation_manager_avatar_url_small |
string |
|
☐ |
|
person_relation_manager_bank_account |
string |
|
☐ |
|
person_relation_manager_civil_status |
string |
|
☐ |
|
person_relation_manager_created_at |
string |
|
☐ |
|
person_relation_manager_created |
string |
|
☐ |
|
person_relation_manager_employment_status |
string |
|
☐ |
|
person_relation_manager_function |
string |
|
☐ |
|
person_relation_manager_hourly_cost_tariff |
float |
|
☐ |
|
person_relation_manager_hourly_sales_tariff |
float |
|
☐ |
|
person_relation_manager_id |
string |
|
☐ |
|
person_relation_manager_is_user |
boolean |
|
☐ |
|
person_relation_manager_marital_status |
string |
|
☐ |
|
person_relation_manager_modified |
string |
|
☐ |
|
person_relation_manager_name |
string |
|
☐ |
|
person_relation_manager_person_address_country_code |
string |
|
☐ |
|
person_relation_manager_person_address_country_id |
string |
|
☐ |
|
person_relation_manager_person_address_country |
string |
|
☐ |
|
person_relation_manager_person_address_id |
string |
|
☐ |
|
person_relation_manager_person_address_line_1 |
string |
|
☐ |
|
person_relation_manager_person_address_line_2 |
string |
|
☐ |
|
person_relation_manager_person_address_locality |
string |
|
☐ |
|
person_relation_manager_person_address_postal_code |
string |
|
☐ |
|
person_relation_manager_person_address_province |
string |
|
☐ |
|
person_relation_manager_person_address_type |
string |
|
☐ |
|
person_relation_manager_person_avatar_color |
string |
|
☐ |
|
person_relation_manager_person_avatar_initials |
string |
|
☐ |
|
person_relation_manager_person_avatar_url_large |
string |
|
☐ |
|
person_relation_manager_person_avatar_url_small |
string |
|
☐ |
|
person_relation_manager_person_bank_account |
string |
|
☐ |
|
person_relation_manager_person_bank_bic |
string |
|
☐ |
|
person_relation_manager_person_created_at |
string |
|
☐ |
|
person_relation_manager_person_custom_salutation |
string |
|
☐ |
|
person_relation_manager_person_date_of_birth |
string |
|
☐ |
|
person_relation_manager_person_email |
string |
|
☐ |
|
person_relation_manager_person_facebook_url |
string |
|
☐ |
|
person_relation_manager_person_family_name_prefix |
string |
|
☐ |
|
person_relation_manager_person_family_name |
string |
|
☐ |
|
person_relation_manager_person_first_name |
string |
|
☐ |
|
person_relation_manager_person_full_name |
string |
|
☐ |
|
person_relation_manager_person_gender_id |
string |
|
☐ |
|
person_relation_manager_person_gender |
string |
|
☐ |
|
person_relation_manager_person_id_2 |
string |
|
☐ |
|
person_relation_manager_person_id |
string |
|
☐ |
|
person_relation_manager_person_initials |
string |
|
☐ |
|
person_relation_manager_person_invoice_receiver |
string |
|
☐ |
|
person_relation_manager_person_is_active |
boolean |
|
☐ |
|
person_relation_manager_person_is_employee |
int64 |
|
☐ |
|
person_relation_manager_person_linkedin_url |
string |
|
☐ |
|
person_relation_manager_person_mailing_list_email |
string |
|
☐ |
|
person_relation_manager_person_note |
string |
|
☐ |
|
person_relation_manager_person_phone |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_avatar_color |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_avatar_initials |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_avatar_url_large |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_avatar_url_small |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_bank_account |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_civil_status |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_created_at |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_created |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_employment_status |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_function |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_hourly_cost_tariff |
float |
|
☐ |
|
person_relation_manager_person_relation_manager_hourly_sales_tariff |
float |
|
☐ |
|
person_relation_manager_person_relation_manager_id |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_is_user |
boolean |
|
☐ |
|
person_relation_manager_person_relation_manager_marital_status |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_modified |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_name |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_bank_account |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_bank_bic |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_created_at |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_custom_salutation |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_date_of_birth |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_email |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_facebook_url |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_family_name_prefix |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_family_name |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_first_name |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_full_name |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_gender_id |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_gender |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_id_2 |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_id |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_initials |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_invoice_receiver |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_is_active |
boolean |
|
☐ |
|
person_relation_manager_person_relation_manager_person_is_employee |
int64 |
|
☐ |
|
person_relation_manager_person_relation_manager_person_linkedin_url |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_mailing_list_email |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_note |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_phone |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_relation_number |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_simplicate_url |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_timeline_email_address |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_twitter_url |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_updated_at |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_person_use_custom_salutation |
boolean |
|
☐ |
|
person_relation_manager_person_relation_manager_person_website_url |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_simplicate_url |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_social_security_number |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_status_id |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_status_label |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_timeline_email_address |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_type_id |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_type_label |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_updated_at |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_work_email |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_work_mobile |
string |
|
☐ |
|
person_relation_manager_person_relation_manager_work_phone |
string |
|
☐ |
|
person_relation_manager_person_relation_number |
string |
|
☐ |
|
person_relation_manager_person_relation_type_color |
string |
|
☐ |
|
person_relation_manager_person_relation_type_id |
string |
|
☐ |
|
person_relation_manager_person_relation_type_label |
string |
|
☐ |
|
person_relation_manager_person_relation_type_type |
string |
|
☐ |
|
person_relation_manager_person_simplicate_url |
string |
|
☐ |
|
person_relation_manager_person_timeline_email_address |
string |
|
☐ |
|
person_relation_manager_person_twitter_url |
string |
|
☐ |
|
person_relation_manager_person_updated_at |
string |
|
☐ |
|
person_relation_manager_person_use_custom_salutation |
boolean |
|
☐ |
|
person_relation_manager_person_website_url |
string |
|
☐ |
|
person_relation_manager_simplicate_url |
string |
|
☐ |
|
person_relation_manager_social_security_number |
string |
|
☐ |
|
person_relation_manager_status_id |
string |
|
☐ |
|
person_relation_manager_status_label |
string |
|
☐ |
|
person_relation_manager_timeline_email_address |
string |
|
☐ |
|
person_relation_manager_type_id |
string |
|
☐ |
|
person_relation_manager_type_label |
string |
|
☐ |
|
person_relation_manager_updated_at |
string |
|
☐ |
|
person_relation_manager_work_email |
string |
|
☐ |
|
person_relation_manager_work_mobile |
string |
|
☐ |
|
person_relation_manager_work_phone |
string |
|
☐ |
|
person_relation_number |
string |
|
☐ |
|
person_relation_type_color |
string |
|
☐ |
|
person_relation_type_id |
string |
|
☐ |
|
person_relation_type_label |
string |
|
☐ |
|
person_relation_type_type |
string |
|
☐ |
|
person_simplicate_url |
string |
|
☐ |
|
person_timeline_email_address |
string |
|
☐ |
|
person_twitter_url |
string |
|
☐ |
|
person_updated_at |
string |
|
☐ |
|
person_use_custom_salutation |
boolean |
|
☐ |
|
person_website_url |
string |
|
☐ |
|
simplicate_url |
string |
Simplicate URL |
☐ |
|
social_security_number |
string |
Burgerservicenummer |
☐ |
|
status_id |
string |
Status-ID |
☐ |
|
status_label |
string |
Statuslabel |
☐ |
|
timeline_email_address |
string |
Tijdlijn e-mailadres |
☐ |
|
type_id |
string |
Type ID |
☐ |
|
type_label |
string |
Soort Label |
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
work_email |
string |
Werk E-mail |
☐ |
|
work_mobile |
string |
Werk Mobiel |
☐ |
|
work_phone |
string |
Werktelefoon |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945