Overview
The Learner Database report allows you to view and export key learner information. Each column in the report pulls data from specific areas within OneFile. Use this guide to understand where each data point originates.
Column Reference Table
| 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 |
| Last 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 |
| Anticipated 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 |
Tips
- Use filters in the Learner Database report to narrow down results.
- Export the report for offline analysis or compliance checks.
Troubleshooting
| Issue | Solution |
|---|---|
| Column missing | Ensure the report includes all relevant fields. |
| Incorrect data | Verify the source tab for accuracy (e.g., Episode, Profile, Learning Aims). |
Terminology
Please note that the terminology used in this article may be different depending on your Centre.
❓Need Help?
If you encounter any issues or have questions, please contact Onefile Support or your internal support channels.