This article will try to explain all the data fields available to you in Reports. Colleague and Time off reports share fields, but Time off has all the fields under the headline "Leave" (and Colleague reports has none of these). Here you can read more about how to create a report.
Some fields are self explanatory and are missing detailed explanations.
If you need these, please let us know and we'll add them!
👥 Colleague
👥 Colleague
Personal
First name
Last name
Email - This is the Private email of the employee
Phone - This is the Private phone number of the employee
Birth date
Gender
Social security number
Pronoun
Nationality
Emergency contact - Name
Emergency contact - Email
Emergency contact - Phone
Bank - Name
Bank - Clearing number
Bank - Account number
Bank - IBAN
Bank - BIC
Bank - Country
Home Address - City
Home Address - Country
Home Address - Postal Code
Home Address - Street
Work info
Employee number
Title
Work email
Work phone
Active - True if the employee is Active, false if the user is off-boarded/archived
Has occupational pension
Hire date - First day according to the first Employment in Alexis
Offboard date - The date you set during offboarding of the employee
Offboarding comment
Manager
Manager email
Tax column
Tax table
Involuntary offboarding - True of the offboarding was set to Involontary, false if not
Cost center - Name
Cost center - Code
End date - The date that should be deemed as the employees last date and can differ to offboard date.
Division
Organization
Custom fields
You can take reports on any custom fields you have created
Company
Name
Legal name
Organization number
Email
Phone
Invoice email
VAT number
Vacation balance
Vacation year start
Vacation year end
Calculated earned days for year
Earned vacation days
Vacation day adjustment
Total spent days this year
Spent unpaid days this year
Spent paid days this year
Spent days from carry-over
All saved days
Spent saved days
Saved days
Unpaid days at the start of this year
Unpaid days left
Paid and unpaid days left
Paid days at the start of this year
Paid days and saved days left this year
Paid days left this year
Saved days total
Saved days
Saved days spent
Employment
Start date - Start date of current employment
Country
End date - End date of current employment
Note
Rate
Terminated
Type - Type of employment (i.e. permanent, probationary etc)
Office
Name
Email
Phone
Country
Department
Name
Description
Parent - Parent Department set up by an Admin/Owner in Alexis
Base Compensation
Amount
Currency
Effective date
Note
Paid overtime
Payout day - A number corresponding to the day of month
Payout frequency - Can be set to Week or Month
Payout period - Can be set to Annualy/Quarterly/Monthly/Weekly/Daily/Hourly
Salary schedule
Salary year
Salary code
👋 Time off
👋 Time off
Leave
Description
Afternoon - Yes if only afternoon, this is a setting in some leave types
Morning - Yes if only morning, this is a setting in some leave types
Approval note
Country - Country of the employment the employee has/had
Created
Days - Number of days this leave was/is, including non-working days
Start date (UTC)
End date (UTC)
Child from Leave
Child birthdate
Local start date
Local end date
Timezone
Status - Status of the Leave (i.e. Pending/Approved/Denied/Cancelled)
Type - Type of leave, like "vacation", "sick leave" etc.
Leave type code
Working days - Number of Working days this leave was/is, excl. non-working days
Denied by
Approved by
Cancelled by
Created by
Personal
First name
Last name
Email - This is the Private email of the employee
Phone - This is the Private phone number of the employee
Birth date
Gender
Social security number
Pronoun
Nationality
Emergency contact - Name
Emergency contact - Email
Emergency contact - Phone
Bank - Name
Bank - Clearing number
Bank - Account number
Bank - IBAN
Bank - BIC
Bank - Country
Home Address - City
Home Address - Country
Home Address - Postal Code
Home Address - Street
Work info
Employee number
Title
Work email
Work phone
Active - True if the employee is Active, false if the user is off-boarded/archived
Has occupational pension
Hire date - First day according to the first Employment in Alexis
Offboard date - The date you set during offboarding of the employee
Offboarding comment
Manager
Manager email
Tax column
Tax table
Involuntary offboarding - True of the offboarding was set to Involontary, false if not
Cost center - Name
Cost center - Code
End date - The date that should be deemed as the employees last date and can differ to offboard date.
Division
Organization
Custom fields
You can take reports on any custom fields you have created
Company
Name
Legal name
Organization number
Email
Phone
Invoice email
VAT number
Base Compensation
Amount
Currency
Effective date
Note
Paid overtime
Payout day - A number corresponding to the day of month
Payout frequency - Can be set to Week or Month
Payout period - Can be set to Annualy/Quarterly/Monthly/Weekly/Daily/Hourly
Salary schedule
Salary year
Salary code
Employment
Start date - Start date of current employment
Country
End date - End date of current employment
Note
Rate
Terminated
Type - Type of employment (i.e. permanent, probationary etc)
Office
Name
Email
Phone
Country
Department
Name
Description
Parent - Parent Department set up by an Admin/Owner in Alexis
⏰ Time reporting
⏰ Time reporting
Timesheet entry
Status
Timesheet entry: Date
Timesheet entry: Minutes
Timesheet entry: Note
Timesheet entry: Punch In Time
Timesheet entry: Punch Out Time
Timesheet entry: Original Punch In Time
Timesheet entry: Original Punch Out Time
Timesheet
Timesheet: Start date
Timesheet: End date
Timesheet: Note
Timesheet: Status
Timesheet: Approval date
Project
Project: Name
Project: Description
Project: Code
Project: Link
Project: Archived
Personal
First name
Last name
Email - This is the Private email of the employee
Phone - This is the Private phone number of the employee
Birth date
Gender
Social security number
Pronoun
Nationality
Emergency contact - Name
Emergency contact - Email
Emergency contact - Phone
Bank - Name
Bank - Clearing number
Bank - Account number
Bank - IBAN
Bank - BIC
Bank - Country
Home Address - City
Home Address - Country
Home Address - Postal Code
Home Address - Street
Work info
Employee number
Title
Work email
Work phone
Active - True if the employee is Active, false if the user is off-boarded/archived
Has occupational pension
Hire date - First day according to the first Employment in Alexis
Offboard date - The date you set during offboarding of the employee
Offboarding comment
Manager
Manager email
Tax column
Tax table
Involuntary offboarding - True of the offboarding was set to Involontary, false if not
Cost center - Name
Cost center - Code
End date - The date that should be deemed as the employees last date and can differ to offboard date.
Division
Organization
Custom fields
You can take reports on any custom fields you have created
Company
Name
Legal name
Organization number
Email
Phone
Invoice email
VAT number
Base Compensation
Amount
Currency
Effective date
Note
Paid overtime
Payout day - A number corresponding to the day of month
Payout frequency - Can be set to Week or Month
Payout period - Can be set to Annualy/Quarterly/Monthly/Weekly/Daily/Hourly
Salary schedule
Salary year
Salary code
Employment
Start date - Start date of current employment
Country
End date - End date of current employment
Note
Rate
Terminated
Type - Type of employment (i.e. permanent, probationary etc)
Office
Name
Email
Phone
Country
Department
Name
Description
Parent - Parent Department set up by an Admin/Owner in Alexis
💼 Remote work
💼 Remote work
Remote work
Date
Duration
Morning
Afternoon
Personal
First name
Last name
Email - This is the Private email of the employee
Phone - This is the Private phone number of the employee
Birth date
Gender
Social security number
Pronoun
Nationality
Emergency contact - Name
Emergency contact - Email
Emergency contact - Phone
Bank - Name
Bank - Clearing number
Bank - Account number
Bank - IBAN
Bank - BIC
Bank - Country
Home Address - City
Home Address - Country
Home Address - Postal Code
Home Address - Street
Work info
Employee number
Title
Work email
Work phone
Active - True if the employee is Active, false if the user is off-boarded/archived
Has occupational pension
Hire date - First day according to the first Employment in Alexis
Offboard date - The date you set during offboarding of the employee
Offboarding comment
Manager
Manager email
Tax column
Tax table
Involuntary offboarding - True of the offboarding was set to Involontary, false if not
Cost center - Name
Cost center - Code
End date - The date that should be deemed as the employees last date and can differ to offboard date.
Division
Organization
Custom fields
You can take reports on any custom fields you have created
Company
Name
Legal name
Organization number
Email
Phone
Invoice email
VAT number
Base Compensation
Amount
Currency
Effective date
Note
Paid overtime
Payout day - A number corresponding to the day of month
Payout frequency - Can be set to Week or Month
Payout period - Can be set to Annualy/Quarterly/Monthly/Weekly/Daily/Hourly
Salary schedule
Salary year
Salary code
Employment
Start date - Start date of current employment
Country
End date - End date of current employment
Note
Rate
Terminated
Type - Type of employment (i.e. permanent, probationary etc)
Office
Name
Email
Phone
Country
Department
Name
Description
Parent - Parent Department set up by an Admin/Owner in Alexis
💲 Compensation
💲 Compensation
You can get a report for an employee's compensations with an effective date in the past, current and future!
Compensation overview
Type - always selected to link data to the correct compensation type
Name
Amount
Currency
Effective date
Note
Paid overtime
Payout day - A number corresponding to the day of month
Payout frequency - Can be set to Week or Month
Payout period - Can be set to Annualy/Quarterly/Monthly/Weekly/Daily/Hourly
Salary schedule
Salary year
Salary code
Personal
First name
Last name
Email - This is the Private email of the employee
Phone - This is the Private phone number of the employee
Birth date
Gender
Social security number
Pronoun
Nationality
Emergency contact - Name
Emergency contact - Email
Emergency contact - Phone
Bank - Name
Bank - Clearing number
Bank - Account number
Bank - IBAN
Bank - BIC
Bank - Country
Home Address - City
Home Address - Country
Home Address - Postal Code
Home Address - Street
Work info
Employee number
Title
Work email
Work phone
Active - True if the employee is Active, false if the user is off-boarded/archived
Has occupational pension
Hire date - First day according to the first Employment in Alexis
Offboard date - The date you set during offboarding of the employee
Offboarding comment
Manager
Manager email
Tax column
Tax table
Involuntary offboarding - True of the offboarding was set to Involontary, false if not
Cost center - Name
Cost center - Code
End date - The date that should be deemed as the employees last date and can differ to offboard date.
Division
Organization
Custom fields
You can take reports on any custom fields you have created
Company
Name
Legal name
Organization number
Email
Phone
Invoice email
VAT number
Employment
Start date - Start date of current employment
Country
End date - End date of current employment
Note
Rate
Terminated
Type - Type of employment (i.e. permanent, probationary etc)
Office
Name
Email
Phone
Country
Department
Name
Description
Parent - Parent Department set up by an Admin/Owner in Alexis