Dictionary Enrolments

All the codes you can use for an excel export of enrolments

Wouter Huybrighs avatar
Written by Wouter Huybrighs
Updated over a week ago

About the project

{{PROJECT_NAME}}

Name

{{PROJECT_DESCRIPTION}}

Description

{{PROJECT_START_DATE}}

Start date

{{PROJECT_END_DATE}}

End date

{{PROJECT_CUSTOMER_NAME}}

Customer name

{{PROJECT_CUSTOMER_LEGAL_FORM}}

Customer legal form

{{PROJECT_CUSTOMER_ENTERPRISE_NUMBER}}

Customer enterprise number

{{PROJECT_CUSTOMER_CONTACT_EMAIL}}

Customer email

{{PROJECT_CUSTOMER_PHONE_NUMBER}}

Customer phone number

{{PROJECT_CUSTOMER_ADDRESS}}

Customer address

{{PROJECT_CUSTOMER_STREET}}

Customer street

{{PROJECT_CUSTOMER_MAILBOX}}

Customer mailbox

{{PROJECT_CUSTOMER_ZIP}}

Customer zip

{{PROJECT_CUSTOMER_CITY}}

Customer city

{{PROJECT_CUSTOMER_COUNTRY}}

Customer country

{{PROJECT_CUSTOMER_CONTACT_PERSON_NAME}}

Custtomer contact person name

{{PROJECT_CUSTOMER_CONTACT_PERSON_PHONE_NUMBER}}

Customer contact person phone number

{{PROJECT_DEPARTMENT_NAME}}

Department

{{PROJECT_DEPARTMENT_DESCRIPTION}}

Department description

About the subproject:

{{SUBPROJECT_NAME}}

Name

{{SUBPROJECT_CUSTOMER_CONTACT_PERSON_NAME}}

Customer contact person name

{{SUBPROJECT_CUSTOMER_CONTACT_PERSON_PHONE_NUMBER}}

Customer contact person phone number

About the team:

{{TEAM_FULL_NAME}}

Project name /subproject name/ team name

{{TEAM_NAME}}

Name

{{TEAM_FUNCTION_NAME}}

Function name

{{TEAM_FUNCTION_DESCRIPTION}}

Function description

{{TEAM_PRACTICAL_INFO}}

Practical info

{{TEAM_NUMBER_OF_PERSONS}}

Number of persons

{{TEAM_CUSTOMER_CONTACT_PERSON_NAME}}

Customer contact person name

{{TEAM_CUSTOMER_CONTACT_PERSON_PHONE_NUMBER}}

Customer contact person phone number

{{TEAM_WORK_STATION_ADDRESS}}

Work station full address

{{TEAM_WORK_STATION_NAME}}

Work station name

{{TEAM_WORK_STATION_STREET}}

Work station street

{{TEAM_WORK_STATION_MAILBOX}}

Work station mailbox

{{TEAM_WORK_STATION_ZIP}}

Work station zip

{{TEAM_WORK_STATION_CITY}}

Work station city

{{TEAM_WORK_STATION_COUNTRY}}

Work station country

{{TEAM_WORK_STATION_ADDITION}}

Work station addition

{{TEAM_CHECK_IN_START_DAY}}

Check-in start day

{{TEAM_CHECK_IN_START_DATE}}

Check-in start date

{{TEAM_CHECK_IN_START_TIME}}

Check-in start time

{{TEAM_CHECK_IN_START}}

Check-in start date + time

{{TEAM_CHECK_IN_END_DAY}}

Check-in end day

{{TEAM_CHECK_IN_END_DATE}}

Check-in end date

{{TEAM_CHECK_IN_END_TIME}}

Check-in einduur

{{TEAM_CHECK_IN_END}}

Check-in end date + time

{{TEAM_CHECK_IN_ADDRESS}}

Check-in full address

{{TEAM_CHECK_IN_NAME}}

Check-in name

{{TEAM_CHECK_IN_STREET}}

Check-in street

{{TEAM_CHECK_IN_MAILBOX}}

Check-in mailbox

{{TEAM_CHECK_IN_ZIP}}

Check-in zip

{{TEAM_CHECK_IN_CITY}}

Check-in city

{{TEAM_CHECK_IN_COUNTRY}}

Check-in country

{{TEAM_CHECK_IN_ADDITION}}

Check-in addition

{{TEAM_SUMMARY}}

Team summary (progress)

About the first shift of the team:

{{TEAM_FIRST_SHIFT_START_DAY}}

Day first shift

{{TEAM_FIRST_SHIFT_START_DATE}}

Start date

{{TEAM_FIRST_SHIFT_START_TIME}}

Start time

{{TEAM_FIRST_SHIFT_START}}

Start date + time

{{TEAM_FIRST_SHIFT_END_DAY}}

Day end date

{{TEAM_FIRST_SHIFT_END_DATE}}

End date

{{TEAM_FIRST_SHIFT_END_TIME}}

End time

{{TEAM_FIRST_SHIFT_END}}

End date + time

{{TEAM_FIRST_SHIFT_DURATION}}

Duration

{{TEAM_FIRST_SHIFT_BREAK_DURATION}}

Break

{{TEAM_FIRST_SHIFT_WORK_DURATION}}

Work duration

About the last shift of the team:

{{TEAM_LAST_SHIFT_START_DAY}}

Start day

{{TEAM_LAST_SHIFT_START_DATE}}

Start date

{{TEAM_LAST_SHIFT_START_TIME}}

Start time

{{TEAM_LAST_SHIFT_START}}

Start date + time

{{TEAM_LAST_SHIFT_END_DAY}}

End day

{{TEAM_LAST_SHIFT_END_DATE}}

End date

{{TEAM_LAST_SHIFT_END_TIME}}

End time

{{TEAM_LAST_SHIFT_END}}

Einddate + time

{{TEAM_LAST_SHIFT_DURATION}}

Duration

{{TEAM_LAST_SHIFT_BREAK_DURATION}}

Break

{{TEAM_LAST_SHIFT_WORK_DURATION}}

Work duration

About the supervisor of the team

{{TEAM_SUPERVISOR_BEEPLE_CODE}}

Beeple code

{{TEAM_SUPERVISOR_FIRST_NAME}}

First name

{{TEAM_SUPERVISOR_LAST_NAME}}

Last name

{{TEAM_SUPERVISOR_FULL_NAME}}

Full name

{{TEAM_SUPERVISOR_EMAIL}}

E-mail

{{TEAM_SUPERVISOR_MOBILE}}

Mobile

{{TEAM_SUPERVISOR_PHONE_NUMBER}}

Phone number

{{TEAM_SUPERVISOR_GENDER}}

Gender

{{TEAM_SUPERVISOR_NATIONALITY}}

Nationality

{{TEAM_SUPERVISOR_NATIONAL_REGISTRATION_NUMBER_BE}}

National number Belgium (Rijksregisternummer)

{{TEAM_SUPERVISOR_NATIONAL_REGISTRATION_NUMBER_NL}}

National number The Netherlands (Burgerservicenummer)

{{TEAM_SUPERVISOR_BIRTH_DATE}}

Birth date

{{TEAM_SUPERVISOR_AGE}}

Age

{{TEAM_SUPERVISOR_BIRTH_PLACE}}

Birth place

{{TEAM_SUPERVISOR_BIRTH_COUNTRY}}

Country

{{TEAM_SUPERVISOR_BANK_ACCOUNT_IBAN}}

Bank account IBAN number

{{TEAM_SUPERVISOR_BANK_ACCOUNT_BIC}}

Bank account BIC-code

{{TEAM_SUPERVISOR_DEPARTMENTS}}

Departments (seperated by a comma)

{{TEAM_SUPERVISOR_SOCIAL_STATUTE}}

Social status

{{TEAM_SUPERVISOR_CONTACT_PERSON_NAME}}

Contactperson name

{{TEAM_SUPERVISOR_CONTACT_PERSON_MOBILE}}

Contract person mobile

{{TEAM_SUPERVISOR_CONTACT_PERSON_RELATIONSHIP}}

Contact person relationship

{{TEAM_SUPERVISOR_ADDRESS}}

Full address

{{TEAM_SUPERVISOR_STREET}}

Street

{{TEAM_SUPERVISOR_MAILBOX}}

Mailox

{{TEAM_SUPERVISOR_ZIP}}

ZIP code

{{TEAM_SUPERVISOR_CITY}}

City

{{TEAM_SUPERVISOR_BE_PROVINCE}}

Province (only for Belgian tenants)

{{TEAM_SUPERVISOR_BE_REGION}}

Region (only for Belgian tenants)

{{TEAM_SUPERVISOR_COUNTRY}}

Country

{{TEAM_SUPERVISOR_OWN_REMARK}}

Remark of the collaborator

{{TEAM_SUPERVISOR_ADMIN_REMARK}}

Remark of the admin about the collaborator

{{TEAM_SUPERVISOR_EXTERNAL_CODE}}

Payroll identification of the collaborator (only applicable when there is only 1 payroll integration on the tenant)

About the collaborator:

{{COLLABORATOR_BEEPLE_CODE}}

Beeple code

{{COLLABORATOR_FIRST_NAME}}

First name

{{COLLABORATOR_LAST_NAME}}

Last name

{{COLLABORATOR_FULL_NAME}}

Full name

{{COLLABORATOR_EMAIL}}

Email

{{COLLABORATOR_MOBILE}}

Mobile

{{COLLABORATOR_PHONE_NUMBER}}

Telephone number

{{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_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}}


Departments (seperated by a comma)

{{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_CONTRACT_TYPES}}

Contract types

{{COLLABORATOR_DEFAULT_CONTRACT_TYPE}}

Default contract type

About the enrolment:

{{ENROLMENT_ID}}

Enrolment ID

{{ENROLMENT_POSITION}}

Position

{{ENROLMENT_REMARK}}

Remark of the admin

{{ENROLMENT_COLLABORATOR_REMARK}}

Remark of the collaborator

{{ENROLMENT_COLLABORATOR_EXTERNAL_CODE}}

Payroll identification of the collaborator

{{ENROLMENT_CONTRACT_TYPE}}

Contract type

{{ENROLMENT_CONTRACT_STATUTE}}

Statute

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_NAME}}

Legal employer name

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_LEGAL_FORM}}

Legal employer legal form

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_ENTERPRISE_NUMBER}}

Legal employer enterprise number

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_CONTACT_EMAIL}}

Legal employer contact email

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_PHONE_NUMBER}}

Legal employer phone number

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_MISSION}}

Legal employer mission

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_ADDRESS}}

Legal employer address

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_STREET}}

Legal employer street

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_MAILBOX}}

Legal employer mailbox

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_ZIP}}

Legal employer zip

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_CITY}}

Legal employer city

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_COUNTRY}}

Legal employer country

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_LIABILITY_INSURANCE_COMPANY}}

Legal employer liability insurance company

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_LIABILITY_INSURANCE_POLICY_NUMBER}}

Legal employer liability insurance policy number

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_ACCIDENT_INSURANCE_COMPANY}}

Legal employer liability accident insurance company

{{ENROLMENT_CONTRACT_LEGAL_EMPLOYER_ACCIDENT_INSURANCE_POLICY_NUMBER}}

Legal employer liability accident insurance policy number

{{ENROLMENT_HOURLY_COMPENSATION}}

Hourly compensation

{{ENROLMENT_DAILY_COMPENSATION}}

Daily compensation

{{ENROLMENT_TEAM_COMPENSATION}}

Team compensation

{{ENROLMENT_TOTAL_COMPENSATION}}

Total compensation

{{ENROLMENT_PAYROLL_INTEGRATION}}

Payroll integration

{{ENROLMENT_PAYROLL_INTEGRATION_BRANCH}}

Payroll integration branch

{{ENROLMENT_CALLSHEET_DOCUMENT_NUMBER}}

Callsheet document number

{{ENROLMENT_CONTRACT_DOCUMENT_NUMBER}}

Volunteer contract document number

{{ENROLMENT_CALLSHEET_DOCUMENT_VERSION}}

Callsheet document version

{{ENROLMENT_CONTRACT_DOCUMENT_VERSION}}

Volunteer contract document version

{{ENROLMENT_DEPARTMENT_ENTERPRISE_NUMBER}}

Company identification of the payroll configuration of the department

{{ENROLMENT_REMAINING_TIME}}

Remaing time to confirm the enrolment (only applicable when the setting 'Enrolment by administration needs confirmation by collaborator' = yes)

{{ENROLMENT_STATUS}}

Status of the enrolment

About the cancellation

{{CANCEL_PREDEFINED_REASON_NAME}}

The predefined reason of the cancellation (only applicable when the setting 'Cancellation reasons' = 'Predefined reasons')

{{CANCEL_REASON}}

The free text reason of the cancellation

{{CANCEL_REMARK}}

The remark of the cancellation

About the check-in

{{CHECK_IN_REGISTERED_AT}}

Check-in timestamp (date + time)

{{CHECK_IN_REGISTERED_BY}}

Check-in registered by

{{CHECK_IN_REGISTERED_SELF}}

Check-in by the collaborator yes/no

{{CHECK_OUT_REGISTERED_AT}}

Check-out timestamp (date + time)

{{CHECK_OUT_REGISTERED_BY}}

Check-out registered by

{{CHECK_IN_REGISTERED_SELF}}

Check-out by the collaborator yes/no

Did this answer your question?