Guidance
File format
Updated 11 October 2022
Download CSV 4.22 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular |
|---|---|---|---|---|
| ExamSeries | Exam series data relates to for example June 2023 | 1 | ^(June)([ ][0-9][0-9][0-9][0-9])$ | Full month name of exam series and year. -2 also accepted for unknown |
| Year | Year the complaint relates to | 2 | ^(0-9][0-9][0-9][0-9])$ | Year (4 digits). |
| ReportingDate | Date the file was due to be submitted regardless of when it was actually uploaded. Format accepted 120 ODBC canonical was actually uploaded. Format accepted 120 ODBC canonical yyyy-mm-dd | 3 | ^(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 | 4 | ^.{1,100}$ | 1 to 100 characters accepted. |
| ComplaintReferenceNo | Unique AO identifier for complaint | 5 | ^\d{1,25}$ | Up to 25-digit integer accepted. |
| QualificationLevel | Level of qualification e.g. GCSE | 6 | ^(GCSE|AS|A level| Advanced Extension Award|Other General Qualification|Project| English For Speakers of Other Languages|Function al Skills|Other Life Skills|Essential Skills (Northern Ireland)|Occupation al Qualification|Vocatio nally-Related Qualification|End- Point Assessment|Performing Arts Graded Examinations|Other Vocational|Multiple|- 2)$ | One of the following list: GCSE, AS, A level, Advanced Extension Award, Other General Qualification, Project, English For Speakers of Other Languages, Functional Skills, Other Life Skills, Essential Skills (Northern Ireland), Occupational Qualification, Vocationally- Related Qualification, End- Point Assessment, Performing Arts Graded Examinations, Other Vocational, Multiple, -2. |
| QAN | Qualification Accreditation Number e.g. 123/1234/1 | 7 | ^.{1,10}$ | 1 to 10 characters accepted. -2 accepted if unknown. 'Multiple' accepted if complaint is in relation to more than one qualification. |
| SpecificationTitle | Specification title also known as subject title | 8 | ^.{1,150}$ | 1 to 150 characters accepted. -2 accepted if unknown. 'Multiple' accepted if complaint is in relation to more than one specification title. |
| SpecificationCode | Specification code also known as Subject Award Code and Cash-in Code | 9 | ^.{1,7}$ | 1 to 7 characters accepted. 1 to 7 characters accepted. -2 accepted if unknown. 'Multiple' accepted if complaint is in relation to more than one specification code. -2 accepted if unknown. |
| UnitOrComponent Code | Unit or component identifier | 10 | ^.{1,10}$ | 1 to 10 characters accepted. -2 accepted if unknown. |
| DateComplaintMad e | Date the complaint was made. Format accepted 120 ODBC canonical yyyy-mm-dd | 11 | ^(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). '2999-12-31' accepted for cases still open at time of reporting. |
| DateComplaintClo sed | Date the complaint was closed. Format accepted 120 ODBC canonical yyyy-mm-dd | 12 | ^(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). '2999-12-31' accepted for cases still open at time of reporting. |
| NatureOfComplaint | To indicate the reason for the complaint | 13 | Accepted values as per pre-agreed list | Accepted values (see annex A) |
| SpecificNatureOfComplaint | To indicate a more detailed reason for the complaint | 14 | Accepted values as per pre-agreed list | Accepted values (see annex A) |
| Outcome | To indicate the outcome of the complaint | 15 | ^(upheld|not upheld|partially upheld|not applicable|ongoing)$ | Accepted values: * upheld * not upheld * partially upheld * not applicable * ongoing |
| ComplaintSource | To indicate the source of the complaint | 16 | ^(parent|centre|student|teacher|representative bodies|assessor|moderator|item writer|public|government|media|internal staff|contractor|private student|unknown)$ | Accepted values: parent centre student teacher representative bodies assessor moderator item writer public government media internal staff contractor private student unknown |
| MultipleOrSingleIssue | To indicate whether a complaint is in relation to a single issue or multiple | 17 | ^(multiple|single)$ | Accepted values: multiple single |
| Covid-19Related | One of the following yes, no | 18 | ^(yes|no)$ | Accepted values: yes no |