CPCAB Database File Specification
Your file must be a Comma Separated Variable (CSV) file, with no field headings. Each field must be followed by a comma.
The data in each field must not contain commas. Each complete candidate record must be terminated by a carriage return and line feed (new line). Where codes are specified, they must conform exactly to those listed below.
Where dates are supplied, they must be in the format dd-mm-yyyy.
The file must be plain text, containing no control characters or special formatting.
Field List
| Field No. |
Description |
Type |
Mandatory |
| 1 | Centre Issued Candidate Identifier | Text | No |
| 2 | First Name | Text | Yes |
| 3 | Middle Name | Text | No |
| 4 | Surname | Text | Yes |
| 5 | E-mail Address | Text | No |
| 6 | Date of Birth dd-mm-yyyy | Text | Yes |
| 7 | Gender M/F/Other | Text | Yes |
| 8 | Learning Difficulty and/or Disability Code | Text | Yes |
| 9 | Cultural Origin Code | Text | Yes |
Learning Difficulty and/or Disability Codes
| Code | Description |
| 1 | Has a learning difficulty and/or disability |
| 2 | Does not have a learning difficulty and/or disability |
| 3 | No information provided by candidate |
Cultural Origin Codes
| Code | Cultural Origin |
| 01 | White-British |
| 02 | White-Irish |
| 03 | Other white background |
| 04 | Mixed white and black Caribbean (British or otherwise) |
| 05 | Mixed white and black African (British or otherwise) |
| 06 | Mixed white and Asian (British or otherwise) |
| 07 | Other mixed background (British or otherwise) |
| 08 | Indian (British or otherwise) |
| 09 | Pakistani (British or otherwise) |
| 10 | Bangladeshi (British or otherwise) |
| 11 | Other Asian background (British or otherwise) |
| 12 | Black-Caribbean (British or otherwise) |
| 13 | Black-African (British or otherwise) |
| 14 | Black Other (British or otherwise) |
| 15 | Chinese (British or otherwise) |
| 16 | Other (British or otherwise) |
| 17 | No Information Given |
Example file format:
ABC001,John,,Smith,john@thesmiths.com,17-09-1980,M,3,01
2161,Leslie,Mary,Jones,leslie@thejones.com,21-03-1977,F,3,03
ABC003,Deborah,,Weaver,debbie.weaver@aol.com,03-06-1968,F,3,07
OX12230,Milan,,Kratchovila,milan_k@hotmail.com,14-10-1964,M,1,08
,David,,Beer,davebeer@yahoo.co.uk,22-11-1977,M,3,14
219456,Jason,,Barlow,,03-06-1965,M,3,17