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
1Centre Issued Candidate IdentifierTextNo
2First NameTextYes
3Middle NameTextNo
4SurnameTextYes
5E-mail AddressTextNo
6Date of Birth dd-mm-yyyyTextYes
7Gender M/F/OtherTextYes
8Learning Difficulty and/or Disability CodeTextYes
9Cultural Origin CodeTextYes

Learning Difficulty and/or Disability Codes
CodeDescription
1Has a learning difficulty and/or disability
2Does not have a learning difficulty and/or disability
3No information provided by candidate

Cultural Origin Codes
CodeCultural Origin
01White-British
02White-Irish
03Other white background
04Mixed white and black Caribbean (British or otherwise)
05Mixed white and black African (British or otherwise)
06Mixed white and Asian (British or otherwise)
07Other mixed background (British or otherwise)
08Indian (British or otherwise)
09Pakistani (British or otherwise)
10Bangladeshi (British or otherwise)
11Other Asian background (British or otherwise)
12Black-Caribbean (British or otherwise)
13Black-African (British or otherwise)
14Black Other (British or otherwise)
15Chinese (British or otherwise)
16Other (British or otherwise)
17No 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