Permission needed
To view and run the Full Employee Data Extract report you will need the permissions 'Reports', 'Menu Reports' and 'Report Full Employee Data Extract Standard Report'.
These permissions can be added for you by your manager or any System Owner user by following the steps in our article on adding permissions.
The 'Report Full Employee Data Extract Standard Report' will need to be added using the Filters option:
Search for the employee and go to their profile.
Go to Security and select Permissions.
Click Edit Employee Permissions.
Click Filters and then Options.
Select Reports and click Filter.
Search for 'Report Full Employee Data Extract Standard Report' and click on the eye icon so that it is set to green.
Click Save.
Run the Full Employee Data Extract report
To run the Full Employee Data Extract report:
Click Reports and then Standard Reports.
Click Data Extract and then Full Employee Data Extract Report.
Expand the Organisation Structure and select the divison or sections you need to run the report for.
(Optional) You can also run the report based on employee status by select an option from the Employment Status dropdown.
Click Generate Extract.
Information included in the Full Employee Data Extract report
Below is all the information included on the report:
Employee Number
Primary Employee Number
Status (Current / Former)
Department, Division, Section and SubSection
Job Title
Salutation (Ms. / Mrs. / Mr. / Dr. etc.)
Full Name
Username
Forename, Surname and Preferred Name
Age and Date of Birth
Start Date
Length of service
Continuous Service Date
Gender
Pronoun
Marital Status
Etnicity, Religion and Disability
Address
Personal Email and Home Address
Work Email and Work Address
Next of Kin (Emergency Contacts)
Notice Period and Probation
End Date
Reason for leaving
Nationality
Passport number and Passport end date
Visa End Date
Settled Date and PreSettled
NI Number
Tax Code
Contract Type and Contract Basis
Contract End Date
Payroll
Payment Type (BACS) and Pay Type (Salary / Hourly)
Actual Salary
Contract Days and Contract Hours
FTE hours and FTE
Negotiating Body, Grade and Payscale
Worked and Total Term Time Fraction
OSP Group
Absence Scheme
Holiday entitlement (full days on the template)
Sickness and Leave in days or hours (lets you know if the employee's sickness and leave are added in days or hours)
Teacher Number
Qualifications