Guidance
File format
Updated 22 November 2023
Download CSV 3.98 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
|---|---|---|---|---|
| Exam series | Exam series data relates to, for example June 2019 | 1 | ^(June)([ ][0-9][0-9][0-9][0-9])$ | Full month name of exam series and year. |
| Reporting date | 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). |
| Awarding Organisation | Name of the awarding organisation | 3 | ^.{1,100}$ | One to 100 characters accepted |
| Centre No. | Centre number (NCN) | 4 | ^\d{1,5}$ | Up to 5 digit integer accepted |
| Request identifier | Unique request identifier issued by AOs special consideration systems. | 5 | ^.{1,25}$ | One to 25 characters accepted |
| Unique Candidate Identifier | Unique Candidate Identifier (UCI) | 6 | ^.{1,13}$ | Alpha numeric 13 characters accepted |
| QAN | Qualification Accreditation Number, for example 123/1234/1 | 7 | ^.{1,10}$ | One to 10 characters accepted -2 also accepted for candidates not certificating, taking units that can be used against either AS or A level specifications. |
| Specification title | Specification title also known as subject title | 8 | ^.{1,150}$ | One to 150 characters accepted -2 also accepted |
| Specification code | Specification code also known as Subject Award Code and Cash-in Code | 9 | ^.{1,7}$ | One to 7 characters accepted -2 also accepted |
| Qualification level | Level of qualification, for example GCSE | 10 | ^(GCSE|GCSE linear|GCSE short course|GCSE full course|AS|A level||App A Level Dbl|App A Level Sgl|App AS Dbl|App AS Sgl|GCE A level)$ | One of the following list: GCSE, GCSE linear, GCSE short course, GCSE full course, AS, A level, App A Level Dbl, App A Level Sgl, App AS Dbl or App AS Sgl. ‘GCE A level’ also accepted for candidates not certificating, taking units that can be used against either AS or A level specifications. |
| Unit/component description | Unit or component identifier | 11 | ^.{1,10}$ | One to 10 characters accepted |
| Assessment type | To indicate type of assessment, internal or external. | 12 | ^(Internal|External)$ | Internal or External accepted |
| Request date | Date request made. Format accepted 120 ODBC canonical yyyy-mm-dd. | 13 | ^(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) |
| Exam/coursework date | Data assessment taken. Format accepted 120 ODBC canonical yyyy-mm-dd. | 14 | ^(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) |
| Special consideration type | To indicate type of special consideration applied for | 15 | ^(Present but disadvantaged|Absent with good reason)$ | One of the following will be accepted: Present but disadvantaged; Absent with good reason |
| Disadvantage category | To indicate disadvantage category | 16 | Accepted values as per pre-agreed list | Accepted values – See annex A. 'Absent with good reason' also accepted for absent candidates. |
| Specific disadvantage | To indicate specific disadvantage | 17 | Accepted values as per pre-agreed list | Accepted values – See annex A 'Absent with good reason' also accepted for absent candidates. |
| Tariff | Percentage allowance given to candidates that were present but disadvantaged. | 18 | ^([0-5]|-2)$ | Values 0-5 accepted. -2 also accepted for absent candidates. |
| Status | To indicate status of request when data reported, for example Accepted | 19 | ^(Accepted|Rejected|Pending|Withdrawn)$ | One of the following: Accepted, Rejected, Pending, or Withdrawn |
| Rejection reason | Reason request rejected if applicable | 20 | Accepted values as per pre-agreed list. | Accepted values list – See annex B 'Approved' also accepted for cases that were approved. -2 accepted for withdrawn cases. |
| Evidence requested | To indicate if evidence requested | 21 | ^(Y|N)$ | Y or N accepted. |
| Evidence received | To indicate if evidence received | 22 | ^(Y|N)$ | Y or N accepted |