{{COLLABORATOR_BEEPLE_CODE}} | Beeple code |
{{COLLABORATOR_FIRST_NAME}} | First name |
{{COLLABORATOR_PREFIX}} | Prefix ('tussenvoegsel', for Dutch clients) |
{{COLLABORATOR_LAST_NAME}} | Last name |
{{COLLABORATOR_FULL_NAME}} | Full name |
{{COLLABORATOR_EMAIL}} | |
{{COLLABORATOR_MOBILE}} | Mobile |
{{COLLABORATOR_PHONE_NUMBER}} | Telephone number |
{{COLLABORATOR_LANGUAGE}} | Language |
{{COLLABORATOR_GENDER}} | Gender |
{{COLLABORATOR_NATIONALITY}} | Nationality |
{{COLLABORATOR_NATIONAL_REGISTRATION_NUMBER_BE}} | National number Belgium (Rijksregisternummer) |
{{COLLABORATOR_NATIONAL_REGISTRATION_NUMBER_NL}} | National number The Netherlands (Burgerservicenummer) |
{{COLLABORATOR_NATIONAL_REGISTRATION_NUMBER_ES}} | National number Spain |
{{COLLABORATOR_NATIONAL_REGISTRATION_NUMBER_ES_FOREIGN}} | National number Spain (foreign) |
{{COLLABORATOR_NATIONAL_REGISTRATION_NUMBER_CL}} | National number Chile |
{{COLLABORATOR_BIRTH_DATE}} | Birth date |
{{COLLABORATOR_AGE}} | Age |
{{COLLABORATOR_BIRTH_PLACE}} | Birth place |
{{COLLABORATOR_BIRTH_COUNTRY}} | Country |
{{COLLABORATOR_BANK_ACCOUNT_IBAN}} | Bank account IBAN number |
{{COLLABORATOR_BANK_ACCOUNT_BIC}} | Bank account BIC code |
{{COLLABORATOR_DEPARTMENTS}} | |
{{COLLABORATOR_PRIMARY_DEPARTMENT}} | Primary department |
{{COLLABORATOR_SOCIAL_STATUTE}} | Social status |
{{COLLABORATOR_CONTACT_PERSON_NAME}} | Contact person name |
{{COLLABORATOR_CONTACT_PERSON_MOBILE}} | Contactperson mobile |
{{COLLABORATOR_CONTACT_PERSON_RELATIONSHIP}} | Contactperson relationship |
{{COLLABORATOR_ADDRESS}} | Full address |
{{COLLABORATOR_STREET}} | Street |
{{COLLABORATOR_MAILBOX}} | Mailbox |
{{COLLABORATOR_ZIP}} | ZIP code |
{{COLLABORATOR_CITY}} | City |
{{COLLABORATOR_BE_PROVINCE}} | Province (only for Belgian tenants) |
{{COLLABORATOR_BE_REGION}} | Region (only for Belgian tenants) |
{{COLLABORATOR_COUNTRY}} | Country |
{{COLLABORATOR_OWN_REMARK}} | Remark by the collaborator |
{{COLLABORATOR_ADMIN_REMARK}} | Remark by the admin about the collaborator |
{{COLLABORATOR_EXTERNAL_CODE}} | Payroll identification of the collaborator (only applicable when there is only 1 payroll integration on the tenant) |
{{COLLABORATOR_BLOCKED}} | Blocked (yes/no) |
{{COLLABORATOR_BLOCKED_AT}} | Blocked at (date + time) |
{{COLLABORATOR_BLOCKED_AT_DAY}} | Blocked at day (e.g. 'Monday') |
{{COLLABORATOR_BLOCKED_AT_DATE}} | Blocked at date |
{{COLLABORATOR_BLOCKED_AT_TIME}} | Blocked at time |
{{COLLABORATOR_BLOCKED_BY}} | Blocked by (name of admin user) |
{{COLLABORATOR_UNBLOCKED_AT}} | Unblocked at (date + time) |
{{COLLABORATOR_UNBLOCKED_AT_DAY}} | Unblocked at day (e.g. 'Monday') |
{{COLLABORATOR_UNBLOCKED_AT_DATE}} | Unblocked at date |
{{COLLABORATOR_UNBLOCKED_AT_TIME}} | Unblocked at time |
{{COLLABORATOR_UNBLOCKED_BY}} | Unblocked by (name of admin user) |
{{COLLABORATOR_BLOCK_RELEASE_REASON}} | The free text reason for blocking or unblocking a collaborator (only applicable when the setting 'Blocking and unblocking reasons' = Free text') |
{{COLLABORATOR_BLOCK_PREDEFINED_REASON_NAME}} | The predefined reason when blocking a collaborator (only applicable when the setting 'Blocking and unblocking reasons' = 'Predefined reasons') |
{{COLLABORATOR_RELEASE_PREDEFINED_REASON_NAME}} | The predefined reason when unblocking/releasing a collaborator (only applicable when the setting 'Blocking and unblocking reasons' = 'Predefined reasons') |
{{COLLABORATOR_BLOCK_RELEASE_REASON_REMARK}} | Remark when blocking or unblocking/releasing the collaborator |
{{COLLABORATOR_CONTRACT_TYPES}} | Contract types |
{{COLLABORATOR_DEFAULT_CONTRACT_TYPE}} | Default contract type |
{{COLLABORATOR_REJECT_APPLICATION_REASON}} | Application rejected reason |
{{COLLABORATOR_RATING}} | Rating (starts filled in by admin) |
{{COLLABORATOR_PREFERRED_FUNCTIONS}} | Preferred functions (when using the setting 'apply for functions') |
All the codes you can use for an excel export of collaborators
Written by Wouter Huybrighs
Updated over 10 months ago