To view what columns can be reported on within the Learner Database reports and where the data is pulled from, please see the table below:
Column | Data Pulled From |
ULN | Episode Page |
NI Number | Episode Page |
DOB | Account Tab |
Sex | Episode Tab |
Comments | Account Tab |
Placement | Episode Tab |
Home Address | Profile Tab |
Workplace Name | Profile Tab |
Workplace Address | Profile Tab |
Profile Tab | |
Phone Number | Profile Tab |
Main Learning Aim | Learning Aims Tab |
First A.B. Reg Date | Learning Aims Tab |
Lat A.B. Reg Date | Learning Aims Tab |
A.B. Reg Nos. | Learning Aims Tab |
Learner Status | Episode Tab |
Date Centre Registered | Episode Page |
Eportfolio Start Date | Episode Tab |
Anticipate Completion Date | Learning Aims Tab |
Eportfolio Completion Date | Learning Aims Tab |
Date Archived | Learning Aims Tab |
License Type | Episode Tab |
Learner Last Activity | Activity Log |
Progress/Grade | Overall Progress |
Target Progress/Grade | Overall Progress |
Class | Episode Tab |
Provider | Episode Tab |
MIS Value | Account Tab |
LSF | Episode Tab |
Assessor Name | Assessors Tab |
Assessor Last Activity | Activity Log |
First Assessment Date | Assessments |
Last Assessment Date | Assessments |
Last Learner Assessment Date | Assessments |
Last Assessor Assessment Date | Assessments |
First Assessment Plan Date | Plans |
Last Assessment Plan Date | Plans |
Last Learner Assessment Plan Date | Plans |
Last Assessor Assessment Plan Date | Plans |
Time Elapsed from Start (Days) | Calculated from Episode Start Date - Today's Date |
Last Completed Review Date | Reviews |
Last Review Review Date | Reviews |
Last Timesheet Induction Date | Timesheets |
Last Timesheet Session Date | Timesheets |
Total Timesheet Session Duration (H : M) | Timesheets |
Last IV Assessment Sample Date | Assessments |
Last EV Assessment Sample Date | Assessments |
IV Signed Units | Overall Progress |
Total Contracted Hours | Timesheets |
Target Off-The-Job Hours | Timesheets |
Target Off-The-Job (%) | Timesheets |
Actual Off-The-job Hours | Timesheets |
Off-The-Job (%) | Timesheets |
Next Visit Start Date | Visits |
Next Visit End Date | Visits |
Next Visit Start Time | Visits |
Next Visit End Time | Visits |
Next Visit Type | Visits |
Next Visit Location | Visits |