Guidance
TQ Central Learner Pipeline - Entries file format
Updated 19 March 2021
Download CSV 4.43 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression/Accepted values |
|---|---|---|---|---|
| ReportingDate | Date the file was due to be submitted to Ofqual regardless of when it was actually uploaded (this date will be made available by Ofqual) | 1 | ^ (0[1-9]|[12][0-9]|3[01])[/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4 digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| RegistrationDate | Date candidate registered for the TQ | 2 | ^ (0[1-9]|[12][0-9]|3[01])[/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4 digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| AwardingOrganisation | Acronym of the awarding organisation | 3 | ^.{1,100}$ | A valid AO Acronym. 1 to 100 characters accepted Note: value must be consistent within the file. |
| QualificationNumber | Unique identifier for the TQ as it appears in Ofqual’s Register of Regulated qualifications | 4 | ^.{1,10}$ | Valid Qualification Number. 1 to 10 characters accepted |
| QualificationTitle | Name of the TQ as it appears on the Portal and Register | 5 | ^.{1,1000}$ | 1 to 1000 characters accepted |
| Route | Name of the TQ route | 6 | ^(Agriculture, environmental and animal care|Business and administration|Care services|Catering and hospitality|Construction and the built environment|Creative and design|Education and early years|Engineering and manufacturing|Hair and beauty|Health and science|Legal, finance and accounting|Protective services|Sales, marketing and procurement|Transport and logistics)$ | Accepted values: * Agriculture, environmental and animal care * Business and administration * Care services * Catering and hospitality * Construction and the built environment * Creative and design * Education and early years * Engineering and manufacturing * Hair and beauty * Health and science * Legal, finance and accounting * Protective services * Sales, marketing and procurement * Transport and logistics |
| Pathway | Name of the TQ pathway | 7 | Not set | Accepted values: • A valid TQ Pathway Note: pathway details can be found on the Institute for Apprenticeships and Technical Education’s website: https://occupational-maps.instituteforapprenticeships.org/ |
| ULN | Unique Learner Number | 8 | ^.{0000000001,9999999999 }$ | A numeric value between 0000000001 and 9999999999 |
| UCI | Unique Learner Number | 9 | ^.{1,13}$ | Alpha-numeric 13 characters Note: enter -2 if not available |
| Forename | Candidate Forename | 10 | ^.{0,150}$ | 0 to 150 characters |
| Surname | Candidate Surname | 11 | ^.{0,150}$ | 0 to 150 characters |
| DateOfBirth | Candidate Date of Birth | 12 | ^ (0[1-9]|[12][0-9]|3[01][/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4 digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) e.g. 15/01/2020 or 2020-01-15 |
| Gender | Candidate Gender | 13 | ^(M|F|-2)$ | Accepted values: • M • F Note: enter -2 for ‘other’ or if not known |
| UKPRN | UK Provider Reference Number | 14 | ^.{10000000,99999999}$ | A numeric value between 10000000 and 99999999 |
| NCN | Centre ID – National Centre Number | 15 | ^\d{1,5}$ | Up to 5-digit integer Note: enter -2 if not available |
| AssessmentSeries | Assessment series data relates to, for example June 2023 | 16 | ^(June)([][0-9][0-9][0-9][0-9])$ | Full month name and year of Assessment series for example June 2023 |
| ComponentCode | Unique identifier for the component (assigned by the awarding organisation) | 17 | ^.{1,10}$ | 1 to 10 characters |
| SubComponentType | TQ sub-component To be used for entries at the sub-component level only (for example resits) | 18 | ^(Core Exam|Core Project|Occupational Specialism|-2)$ | Accepted Values: • Core Exam • Core Project • Occupational Specialism Note: enter -2 for entries made at the component level |
| EntryDate | Date the entry was made (may differ from the registration date) | 19 | ^ (0[1-9]|[12][0-9]|3[01])[/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4 digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) e.g. 15/01/2020 or 2020-01-15 |