Guidance
Specification codes - file format
Updated 13 September 2023
Download CSV 1.6 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
|---|---|---|---|---|
| Year | Year the data relates to, for example 2023 | 1 | ^\d{4}$ | Four digit integer accepted |
| ReportingDate | Date the file was due to be submitted regardless of when it was actually uploaded. Format accepted 120 ODBC canonical yyyy-mm-dd | 2 | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| AwardingOrganisation | Name of the awarding organisation | 3 | ^.{1,100}$ | 1 to 100 characters accepted |
| QAN | Qualification Accreditation Number, for example 123/1234/1 | 4 | ^.{1,10}$ | 1 to 10 characters accepted |
| SpecificationCode | Specification code | 5 | ^.{1,7}$ | 1 to 7 characters accepted |
| SpecificationTitle | Specification title also known as subject title | 6 | ^.{1,150}$ | 1 to 150 characters accepted |
| CertificationCode | Certification code also known as cash-in or entry code | 7 | ^.{1,7}$ | 1 to 7 characters accepted |
| QualificationLevel | Level of qualification, for example GCSE | 8 | ^(GCSE|AS|A level|Project L1|Project L2|Project L3)$ | One of the following list: GCSE, AS, A level, Project L1, Project L2, Project L3 |
| Tier | To indicate tier if applicable | 9 | ^(F|H|-2)$ | One of the following list: F, H, -2 |
| DoubleOrSingleAward | To indicate whether subject is a double or single award | 10 | ^(DBL|SGL)$ | One of the following list: DBL, SGL |
| FullOrShortCourse | To indicate whether subject is a full or short course | 11 | ^(FC|SC|-2)$ | One of the following list: FC, SC, -2 |
| Applied | To indicate whether subject is applied | 12 | ^(Y|N)$ | One of the following list: Y, N |