How to read the new reporting

Here is a quick guide on how to read the reporting CSV file.

This table is based on the elearning report, however, the fields are common to most reports.

Column Header in CSV	Data field
user_team_id	Hierarchy = team ID
User ID	Academy ID
Username	Learners user name
First name	Leaners first name
Last name	Learners Last name
Email	Learners Email Address
Division	Hierarchy= Division Name
Region	Hierarchy= Region Name
Branch	Hierarchy= Branch Name
Team	Hierarchy= Team Name
Group ID	Content group ID/s
External ID	External ID field
Position	Learners positions from their profile
Line Mgr ID	Line Managers Academy ID
Line Mgr Email	Line managers Email
Offline Date	If user is expired, the offline date
Deleted user	Is the user deleted (leaver)? Blank if active
Level	Current level ID
eLearning ID	Content piece ID
eLearning title	Content piece title
eLearning views	Number of views on that content
Start date	Start date of the content
End date	End date of the content
Status	Passed/Failed
Duration	Duration taken
Score %	If content had questions, score of the attempt