Parents Consent Format for Employment by fbu21507

VIEWS: 0 PAGES: 58

More Info
									Information relating to this spreadsheet

Title                  CBDS Specification - Pupil (Modular Format)
Version                V4.2
Filename               Pupil CBDS V4.2
Creator                Ann Wass, DSG DDU
Audience               DSG DDU, DSG TDU, Teachernet
Description            This workbook contains the pupil level CBDS broken down into modules (eg pupil
                       characteristics) and with appropriate code sets
Related.reference
Subject.category       Information Management
Date Last Updated      4-Mar-11

Notes:




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                          Page 1 of 58                          Date last updated: 3/4/2011
Key to Columns in the new CBDS Spreadsheets
Column                         Description and contents
Identifier (New CBDS Ref No)   Starting from 10000, replacing P1, P402a, S1, S2 etc
Identifier (Old CBDS Ref No)   Included for changes to numbers only eg P4 superseded by new identifier 10007
Data Element Name              The name of the data item
Description                    The description of the data item not required if description of data item is clear from Data Element Name
Business Format                All dates will be a standard format CCYY-MM-DD. For character fields with specific formats, use A and 9 for alpha and numeric characters
                               respectively. This will include the minimum and maximum number of characters if appropriate, and the structure of the data type/item. Thus
                               UPN format is A999999999999. For numeric fields, show the decimal point within a string of 9s if required. Can also use the minus sign for
                               numbers that could be negative. Thus a format of -9.99 indicates a range of values from -9.99 to +9.99.

Format.Values                  List of the acceptable values or a cross-reference to a code set. The code set will be found either in the adjacent tab or in the CBDS look up
                               table area on Teachernet.
Format.Default                 Default value
Format.Multiples (S, M)        S = Single current occurance, M = Multiple current occurance.
Format.XML_Tag                 XML tag
Format.Validation (CBDS not    The validation rules to be applied for acceptance of data e.g. ZQ postcode - error
Census validation)
Date.Periodicity (C,S,A,O,X)   C Core - data items which should be kept up to date on an event driven basis, S Standard - data items which should be kept up to date at
                               specific times of the year (including CL Core Local), A Additional - data items whch may need to be kept up to date on an ad hoc basis, O
                               Optional - data items that schools and LAs will not be required to provide but may wish to exchange with each other, or between different
                               internal software systems, X Export only - data items which will not be stored but inputted and transmitted for a particular reason

Date.Created (CCYY-MM-DD)      Date of version of CBDS data item first appeared in or last updated
Relation.Identifier            Other linked CBDS data items




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                         Page 2 of 58                                                        Date last updated: 3/4/2011
Data items and codesets by module in the new CBDS spreadsheets

Module           Date items                             Codesets               Module            Date items                                   Codesets
1 Pupil          Unique Pupil Number (UPN)                                     2 Pupil           Pupil Ethnic Code                            Ethnic code list
Identifiers      Pupil's Former UPN                                            Characteristics   Source of Pupil Ethnic Code                  Ethnicity Source/Traveller
                                                                                                                                              Source/Religion Source
                 Pupil Surname                                                                   Pupil Traveller/ Gypsy Code                  Traveller/Gypsy Code
                 Pupil Forename                                                                  Source of Pupil Traveller Indicator
                 Pupil Name Order Indicator                                                      Pupil Nationality                            Nation states and countries
                 Pupil Middle Names                                                              Pupil Refugee/
                                                                                                 Asylum Seeker Indicator
                 Pupil Date of Birth                                                             Pupil Country of Birth                       Nation states and countries
                 Pupil Gender                                                                    Pupil Religious Affiliation Code             Religion
                 Pupil former Surname                                                            Pupil Religious Education Indicator
                 Pupil Preferred Forename                                                        Pupil Collective Worship Indicator
                 Pupil Preferred Surname                                                         Pupil Home LA                                LEA list
                 Pupil Preferred Name Order Indicator                                            Pupil Free School Meal Eligibility
                 Attendance School LA Number            LEA list                                 Pupil Free School Meal Review Date
                 Attendance School DfES Establishment   Establishment list                       Pupil Free School Transport Eligibility
                 Number
                 Unique Internal Pupil Identifier                                                Connexions Agreement                         Connexions Agreement
                 ULN                                                                             Gifted & Talented indicator
                 UPN allocation date                                                             In Care Indicator
                 Sibling flag                                                                    In Care - Caring Authority Code              LEA list
                 Photograph                                                                      In Care while at current school indicator

                 On roll on census day                                                           Personal Education Plan Indicator
                 Birth certificate seen indicator                                                Child Protection Register Indicator          LEA list
                                                                                                 Pupil Child Protection Register LA Code

                                                                                                 First Language                               First Language
                                                                                                 Language Type                                Language Type
                                                                                                 Language Code                                Language code list
                                                                                                 Usual mode of travel                         Usual mode of travel
                                                                                                 Free school meal taken or claimed
                                                                                                 Free School Transport Eligibility Review
                                                                                                 Date
                                                                                                 Type of care                                 In care type
                                                                                                 English as additional language               Assessment component details
                                                                                                 Family structure                             Family
                                                                                                 Sibling on Child Protection Register
                                                                                                 Number of previous schools
                                                                                                 Pregnant pupil indicator
                                                                                                 Uniform allowance indicator
                                                                                                 Source of pupil religious affiliation code

                                                                                                 Date of Entry




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                     Page 3 of 58                                                                                   Date last updated: 3/4/2011
Data items and codesets by module in the new CBDS spreadsheets


Module           Date items                                Codesets                   Module         Date items                                Codesets
3 Pupil Status   Pupil Enrolment status                    Pupil Enrolment Status     5 Exclusions   Exclusion Category                        Pupil Exclusion Reason
                 Other School LA number                    LEA list                                  Exclusion Reason
                 Other School DfES Establishment           Establishment list                        Exclusion Start Date
                 Number
                 Pupil Date of entry                                                                 Exclusion Start (am/pm)
                 Pupil Date of Leaving                                                               Exclusion End Date
                 Pupil Part-time Indicator                                                           Exclusion Actual Number of Sessions

                 Pupil - Number of sessions                                                          Exclusion Appeal Indicator
                 Pupil Boarder Indicator                   Pupil Boarder                             Exclusion Appeal Date
                 Pupil's Actual National Curriculum Year   Pupil NC Year Group                       Exclusion Appeal Result
                 Group
                 Pupil Class Type Indicator                Class Type                                Exclusion Reinstatement Date
                 Pupil Registration Group                                                            Date of exclusion notification by
                                                                                                     Headteacher
                 Pupil Email Address                                                                 Date of Governors' Meeting re exclusion

                 Leaving destination                       Leaving Destination                       Date of exclusion hearing/expiration of
                                                                                                     notice of appeal
                 Name of leaving destination                                                         Permanent exclusion pending appeal        Pupil Exclusion Status

4 SEN            Member of SEN Unit, special class or
                 resourced provision
                 Member of SEN Unit or special class
                 Member of Resourced provision
                 Pupil SEN Provision (formerly stage)      Pupil SEN provision
                 Pupil date placed upon stage              SENType
                 Pupil date of next SEN review             General subjects
                 Pupil SEN Type ranking
                 Pupil SEN type code
                 National Curriculum Modification or
                 Dissapplication
                 National Curriculum Subject
                 Pupil Medical Flag
                 Pupil Medical Condition/ Notes
                 Paramedical support




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                            Page 4 of 58                                                                        Date last updated: 3/4/2011
Data items and codesets by module in the new CBDS spreadsheets


Module           Date items                       Codesets                        Module            Date items                       Codesets
6 Home           Pupil Address Type               AddressType                     7 Home Location Enumeration district
Information      Sub-dwelling                     PhoneType                       Context         LA Electoral Ward Code
                 SAON Start Number                                                                 LA Electoral Ward Name
                 SAON Start Number Suffix                                                          Parliamentary Constituency Code
                 SAON End Number                                                                   Parliamentary Constituency Name
                 SAON End Number Suffix                                                            Parish Council
                 SAON Description                                                                  Church of England Diocese         Church dioceses
                 Dwelling                                                                          Church of England Parish
                 PAON Start Number                                                                 Roman Catholic Diocese            Church dioceses
                 PAON Start Number Suffix                                                          Roman Catholic Parish
                 PAON End Number                                                                   Learning & Skills Council Code    LSC Area list
                 PAON End Number Suffix                                                            Catchment area
                 PAON Description
                 Street
                 Locality
                 Town
                 Administrative Area
                 Post town
                 Postcode
                 UPRN
                 Unique Street Reference Number
                 Property Easting
                 Property Northing
                 Address Line 1
                 Address Line 2
                 Address Line 3
                 Address Line 4
                 Address Line 5
                 International Address Line 1
                 International Address Line 2
                 International Address Line 3
                 International Address Line 4
                 International Address Line 5     Nation states and countries
                 International Post Code          Nation states and countries
                 ISO 3166-1 Alpha-3 Code          Nation states and countries
                 ISO 3166-1 Alpha-2 Code          Nation states and countries
                 ISO 3166-1 Numeric-3 Code        Nation states and countries
                 ISO 3166-1 Short Country Name    PhoneType
                 ISO 3166-1 Long Country Name
                 Telephone Type
                 Telephone Number
                 Start date at address
                 End date at address




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                        Page 5 of 58                                                           Date last updated: 3/4/2011
Data items and codesets by module in the new CBDS spreadsheets

Module           Date items                                Codesets               Module        Date items                                 Codesets
8 Contact        Contact Priority                                                 8 Contact     Address Line 3
Information      Contact Title                                                    Information   Address Line 4
                 Contact Last Name                                                              Address Line 5
                 Contact First Name                                                             International Address Line 1
                 Contact Middle Name                                                            International Address Line 2
                 Contact Gender                                                                 International Address Line 3
                 Contact Relationship to Pupil               Relationship                       International Address Line 4
                 Contact Responsibility to Pupil                                                International Address Line 5
                 Contact Member of Armed Forces                                                 Zip Code
                 Indicator
                 Contact Translator or Interpreter Indicator                                    International Post Code

                 Contact Language Code                     Language code list                   ISO 3166-1 Alpha-3 Code                    Nation states and countries
                 Contact Email Address                                                          ISO 3166-1 Alpha-2 Code                    Nation states and countries
                 Contact Address Type                                                           ISO 3166-1 Numeric-3 Code                  Nation states and countries
                 Sub-dwelling                                                                   Country Name                               Nation states and countries
                 SAON Start Number                                                              ISO 3166-1 Short Country Name              Nation states and countries
                 SAON Start Number Suffix                                                       ISO 3166-1 Long Country Name               Nation states and countries
                 SAON End Number                                                                Contact Telephone Type                     PhoneType
                 SAON End Number Suffix                                                         Contact Telephone Number
                 SAON Description                                                               Day location
                 Dwelling                                                                       Preference for written communication
                                                                                                indicator
                 PAON Start Number                                                              Contact priority source                    Contact Priority Source
                 PAON Start Number Suffix                                                       Child is resident with contact indicator

                 PAON End Number                                                                Address can be disclosed indicator
                 PAON End Number Suffix                                                         Contact address should be transferred
                                                                                                with pupil indicator
                 PAON Description
                 Street
                 Locality
                 Town
                 Administrative Area
                 Post Town
                 Postcode
                 UPRN
                 Unique Street Reference Number
                 Property Easting
                 Property Northing
                 Address Line 1
                 Address Line 2




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                        Page 6 of 58                                                                             Date last updated: 3/4/2011
Data items and codesets by module in the new CBDS spreadsheets

Module           Date items                            Codesets                   Module          Date items                              Codesets
9 Attendance     Attendance Year                                                  11 Post 16      Post Advanced Level Indicator
                 Attendance period start date                                     Courses         Number of GCE A Level subjects being
                                                                                                  studied
                 Attendance period end date                                                       Number of GCE A and AS Level
                                                                                                  subjects being studied
                 Possible Sessions                                                                Number of GCE AS Level subjects being
                                                                                                  studied
                 Sessions Attended                                                                Number of GCSE Subjects being studied

                 Sessions missed due to Authorised                                                GNVQ level                              GNVQ Level
                 Absence
                 Sessions missed due to Unauthorised                                              GNVQ Precursor Level                    GNVQ Precursor Level
                 Absence
                 Attendance codes                      Pupil Attendance Codes                     NVQ Level                               NVQ Level
                 Number of sessions missed                                                        Other Post-16 Courses Indicator         Other Post 16 Courses
                 Alternative tuition indicator                                                    Qualification Accreditation Number      Qualification Accreditation Number
                 Alternative tuition start date                                                   Learning Aim Start Date
                 Alternative tuition end date                                                     Learning Aim Planned End Date
                 Alternative tuition category          TuitionCategory                            Learning Aim Actual End Date
                 Number of hours alternative tuition   TuitionHours                               Learning Aim Completion Status          Learning Aim Completion Status
                 attended per week
10 Previous      Previous School LA number             LEA list                                   DfES Number for Destination School      Establishment list
School History   Previous School DfES Establishment    Establishment list                         LA Number for Destination School        LEA list
                 Number
                 Previous School Name                                                             Destination Information                 Destinations
                 Previous School Date of Entry                                                    LSC funded
                 Previous School Date of Leaving                                                  LA funded
                 Pupil Reason for Leaving              LeavingReason              12 Assessment   Assessment Identifier                   Assessment IDs
                 Last School                                                                      Assessment Year
                                                                                                  Assessment Locale
                                                                                                  Assessment Date
                                                                                                  Assessment / Examination Season         Season
                                                                                                  Assessment Result Indicator             Result
                                                                                                  Assessment Subject                      Assessment subjects
                                                                                                  Examination Subject                     Assessment subjects
                                                                                                  Assessment Type                         Assessment types
                                                                                                  Assessment Component                    Assessment component details
                                                                                                  Component Result Type                   Assessment component result type
                                                                                                  Component Result                        Assessment component details
                                                                                                  Awarding Body/ Examination Board        Awarding bodies and examination
                                                                                                                                          boards
                                                                                                  Examination Syllabus Number             Key Stage 4 and 5 syllabuses




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                        Page 7 of 58                                                                          Date last updated: 3/4/2011
1 Pupil Identifiers
Identifier Identifier   Data Element     Description                     Business   Format.Values                   Format.    Format.     Format.XML_Tag   Format.Validation (CBDS not                Date.       Date.        Relation.
(New          (Old      Name                                             Format                                     Default    Multiples                    Census validation)                         Periodicity Created      Identifier
CBDS          CBDS                                                                                                             (S, M)                                                                  (C,S,A,O,X)
Ref No)       Ref No)
Pupil identifiers
100001     P1           Unique Pupil     A Unique Pupil Number (UPN) A(13)          A999999999999 or                           S           <UPN>            To calculate the check letter:             C             2000-10-10 100002
                        Number (UPN)     is allocated to each pupil in              A99999999999A (for                                                      1. Multiply the individual digits by their
                                         maintained schools in England              temporary UPN)                                                          weights as follows:
                                         and Wales. It is an identifier             Any alphabetical character                                              digit 2 by weight 2; digit 3 by weight 3;
                                         for use in the educational                 other than I, O, or S.                                                  digit 4 by weight 4; digit 5 by weight 5;
                                         context during a child's school            Characters 2-4 must be a                                                digit 6 by weight 6; digit 7 by weight 7;
                                         career only and subject to Data            valid post April 1998 LA code                                           digit 8 by weight 8; digit 9 by weight 9;
                                         Protection restrictions.                   or a recognised Welsh                                                   digit 10 by weight 10; digit 11 by
                                                                                    "pseudo LA" code (see LA                                                weight 11; digit 12 by weight 12; digit
                                                                                    list codeset)                                                           13 by weight 13 (any alphabetical
                                                                                                                                                            character at digit 13 is accorded the
                                                                                                                                                            same numerical value as listed in
                                                                                                                                                            paragraph 3 below, ie A=0, B=1, C=2
                                                                                                                                                            etc).
                                                                                                                                                            2. Sum the individual results, divide
                                                                                                                                                            the total by 23, and take the
                                                                                                                                                            remainder.
                                                                                                                                                            3. Calculate the check letter from the
                                                                                                                                                            result as follows:
                                                                                                                                                            0 = A; 1 = B; 2 = C; 3 = D; 4 = E;
                                                                                                                                                             5 = F; 6 = G;
                                                                                                                                                            7 = H; 8 = J; 9 = K; 10 = L; 11 = M;
                                                                                                                                                            12 = N; 13 = P;
                                                                                                                                                            14 = Q; 15 = R; 16 = T; 17 = U; 18
                                                                                                                                                            = V; 19 = W; 20 = X;
                                                                                                                                                            21 = Y; 22 = Z.


100002     P2           Pupil's Former   Where a pupil has held another A(13)       A999999999999 or                           S           <FormerUPN>      Where present                              S             2000-10-10 100001
                        UPN              UPN whilst at a school (eg                 A99999999999A (for                                                      (a) should contain the correct check
                                         temporary UPN was allocated                temporary UPN)                                                          letter (for calculating the check letter
                                         when the pupil was first                                                                                           see <UPN> (100001))
                                         admitted to the school, but                                                                                        (b) characters 2-13 of <FormerUPN>
                                         subsequently replaced by the                                                                                       = characters 2-13 of <UPN>
                                         permanent UPN being
                                         retrieved from a previous
                                         school)


100003     P3           Pupil Surname    Full legal surname (derived     A(35)      Any character string                       S           <Surname>                                                   C             2000-10-10 100009,
                                         from family, clan or marital                                                                                                                                                           100011,
                                         association) of the child (as                                                                                                                                                          100162
                                         written)
100004     P4           Pupil Forename   Full given first name of the    A(35)      Any character string                       S           <Forename>                                                  C             2000-10-10 100010,
                                         child (not common                                                                                                                                                                      100163
                                         contractions).




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                   Page 8 of 58                                                                               Date last updated: 3/4/2011
Identifier Identifier   Data Element      Description                        Business     Format.Values                  Format.      Format.     Format.XML_Tag            Format.Validation (CBDS not              Date.       Date.          Relation.
(New          (Old      Name                                                 Format                                      Default      Multiples                             Census validation)                       Periodicity Created        Identifier
CBDS          CBDS                                                                                                                    (S, M)                                                                         (C,S,A,O,X)
Ref No)       Ref No)
Pupil identifiers
100005     P5           Pupil Name        This indicator will be used        A(1)         Y or blank                     Blank        S           <SurnameFirst>            Y if the recorded surname (for written   O             2000-11-22 100012
                        Order Indicator   primarily to identify the naming                                                                                                  communication purposes) should be
                                          conventions used by some,                                                                                                         used for familiar spoken
                                          predominantly non-European,                                                                                                       communication (equivalent to the first
                                          ethnic or language groups.                                                                                                        name in traditional European
                                                                                                                                                                            languages).
100006     P6           Pupil Middle      In full, not shortened or familiar A(35)        Any character string                        S           <MiddleNames>             Components should be separated by        C             2000-10-10 100164
                        Names             versions. If pupil has no middle                                                                                                  a single space.
                                          name(s) then this field must be
                                          left blank

100007     P7           Pupil Date of     Date of birth of pupil             CCYY-MM-DD   Any valid date                              S           <DOB>                     Implied age at previous 31 August        C             2000-10-10
                        Birth                                                                                                                                               would normally be in the range:
                                                                                                                                                                            Primary schools 2-12; Middle
                                                                                                                                                                            schools 7-14;
                                                                                                                                                                            Secondary schools 10-19; Special
                                                                                                                                                                            schools 2–25.
100008     P8           Pupil Gender      Gender of pupil                  A(1)           M or F for Male and Female                  S           <Gender>                                                           C             2000-10-10 100165
100009     P9           Pupil former      A pupil's former surname                        Any character string                        S           <FormerSurname>                                                    S             2004-12-01 100003,
                        Surname           where it is known. (This should                                                                                                                                                                     100011,
                                          only be completed if a former                                                                                                                                                                       100162
                                          surname is already known to
                                          the school. Schools need not
                                          and should not take any special
                                          steps to establish the existence
                                          of former surnames of which
                                          they are not already aware. If
                                          the pupil has more than one
                                          former surname, record the
                                          most recently used.)



100010     P10          Pupil Preferred   The forename preferred by the      A(35)        Any character string                        S           <PreferredForename>       Common contractions, if used, may        C             2004-12-01 100004,
                        Forename          pupil (as written) most                                                                                                           be recorded.                                                      100163
                                          commonly used in the school.

100011     P11          Pupil Preferred   The surname preferred by the       A(35)        Any character string                        S           <PreferredSurname>                                                 C             2004-12-01 100003,
                        Surname           pupil (as written) most                                                                                                                                                                             100009,
                                          commonly used in the school.                                                                                                                                                                        100162

100012     P12          Pupil Preferred   This indicator will be used        A(1)         Y or blank                     Blank        S           <PreferredSurnameFirst>   Y if the recorded surname (for written   O             2000-11-22 100005
                        Name Order        primarily to identify the naming                                                                                                  communication purposes) should be
                        Indicator         conventions used by some,                                                                                                         used for familiar spoken
                                          predominantly non-European,                                                                                                       communication (equivalent to the first
                                          ethnic or language groups.                                                                                                        name in traditional European
                                                                                                                                                                            languages).
100013     P123         Attendance        LA number for school which         A(3)         LEA list available at                       S           LEA                                                                S             2006-01-31 100032,
                        School LA         pupil attends                                   http://www.teachernet.gov.                                                                                                                          100043,
                        Number                                                            uk/management/ims/data                                                                                                                              100061,
                                                                                          management/cbds/CBDSs                                                                                                                               100239,
                                                                                                                                                                                                                                              100261
                                                                                          pecs/




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                          Page 9 of 58                                                                                      Date last updated: 3/4/2011
Identifier Identifier   Data Element       Description                       Business     Format.Values                      Format.     Format.     Format.XML_Tag         Format.Validation (CBDS not           Date.       Date.           Relation.
(New          (Old      Name                                                 Format                                          Default     Multiples                          Census validation)                    Periodicity Created         Identifier
CBDS          CBDS                                                                                                                       (S, M)                                                                   (C,S,A,O,X)
Ref No)       Ref No)
Pupil identifiers
100014     P124         Attendance         School DfES Establishment         A(4)         Establishment list - This                      S           Estab                  0001-0900 Secure Units &               S             2006-01-31 100062,
                        School DfES        Number for school which pupil                  file is too large to be                                                           Miscellaneous; 0940-0949 Playing for                            100240,
                        Establishment      attends                                        offered as a download;                                                            Success Centres; 1000-1099 LA                                   100260
                        Number                                                                                                                                              Nursery Schools; 1100-1149 Pupil
                                                                                          please request a copy by
                                                                                                                                                                            Referral Unit; 1800-1999
                                                                                          email from
                                                                                                                                                                            Miscellaneous; 2000-3999 Maintained
                                                                                          ChangeControl.CBDS@df                                                             Primary (inc Middle deemed Primary);
                                                                                          es.gsi.gov.uk.                                                                    4000-4899 Maintained Secondary (inc
                                                                                                                                                                            Middle Deemed Secondary); 4900-
                                                                                                                                                                            4999 Sixth Form Centres; 5200-5299
                                                                                                                                                                            Maintained Primary (Ex GM - inc
                                                                                                                                                                            Middle deemed Primary); 5400-5499
                                                                                                                                                                            Maintained Secondary (Ex GM - inc
                                                                                                                                                                            Middle deemed Secondary); 5900-
                                                                                                                                                                            5949 Mixed Maintained Primary and
                                                                                                                                                                            Secondary; 5950-5999 Foundation
                                                                                                                                                                            Special (Ex GM); 6000-6599
                                                                                                                                                                            Independent Schools (inc Special and
                                                                                                                                                                            Approved for SEN); 6900-6904 City
                                                                                                                                                                            Technology Colleges; 6905-6924
                                                                                                                                                                            Academies; 7000-7751 Special
                                                                                                                                                                            Schools; 7500-7511 Non-maintained
                                                                                                                                                                            and Community Special Schools;
                                                                                                                                                                            7748-7754 Community Special
                                                                                                                                                                            Schools; 7900-7901 Special Colleges;
                                                                                                                                                                            8000-8799 Further Education (inc
                                                                                                                                                                            Sixth Form Colleges, incl. 8713 for
                                                                                                                                                                            Nottingham Trent University); 9455
                                                                                                                                                                            Lea House Hospital; 9500-9910
                                                                                                                                                                            Miscellaneous (inc Secure Units, incl.
                                                                                                                                                                            9565 for Blaby Community Home)




100015                  Unique Internal    Pupil identifier unique to a   A(20)                                                          S           LocalPupilIdentifier   No validation                         O              2006-01-31
                        Pupil Identifier   school
100016                  ULN                Unique Learner Number          9999999999      A ten digit number with zero                   S           UniqueLearnerNumber                                          O              2006-01-31
                                           (Format, values and validation                 not allowed as the first
                                           should be as defined in CDD                    character.
                                           (in May 2005 version these are
                                           still tba))

100017                  UPN allocation     Date UPN allocated                CCYY-MM-DD   Any valid date                                 S           UPNAllocationDate                                            O              2006-01-31
                        date
100018                  Sibling flag       Indicates that a pupil has        A(20)        Unique Internal Pupil Identifier               M           SiblingIdentifier                                            O              2006-01-31
                                           brother or sister in the school                of sibling(s)




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                            Page 10 of 58                                                                                 Date last updated: 3/4/2011
Identifier Identifier   Data Element      Description                      Business   Format.Values                       Format.    Format.     Format.XML_Tag                 Format.Validation (CBDS not   Date.       Date.          Relation.
(New          (Old      Name                                               Format                                         Default    Multiples                                  Census validation)            Periodicity Created        Identifier
CBDS          CBDS                                                                                                                   (S, M)                                                                   (C,S,A,O,X)
Ref No)       Ref No)
Pupil identifiers
100019                  Photograph        Pupil photograph in an image     A(254)     filename.ext where filename                    S           PupilImage                                                   O             2006-01-31
                                          file                                        can contain any character
                                                                                      except / or \ and ext can be
                                                                                      any usual image file format eg
                                                                                      gif, jpg, png or tif

100020                  On roll on census Indicates that a record was      A(5)       1,0 or true, false                             S           SchoolCensusPupilRecord                                      O             2006-01-31
                        day               submitted for the pupil in the
                                          School Census return
100021                  Birth certificate Indicates that the birth         A(1)       0 not verified (birth certificate             0 S          BirthCertificateVerification                                 O             2006-01-31
                        seen indicator    certificate had been viewed in              not seen), 2 verified (birth
                                          order to establish the correct              certificate viewed)
                                          legal name




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                        Page 11 of 58                                                                                Date last updated: 3/4/2011
2 Pupil Characteristics
Identifier Identifier   Data Element       Description                       Business   Format.Values                Format.    Format.     Format.XML_Tag    Format.Validation (CBDS not           Date.       Date.          Relation.
(New       (Old         Name                                                 Format                                  Default    Multiples                     Census validation)                    Periodicity Created        Identifier
CBDS       CBDS                                                                                                                 (S, M)                                                              (C,S,A,O,X)
Ref No)    Ref No)
Pupil Characteristics
   100022 P13           Pupil Ethnic       Pupil's ethnic code               A(4)       Ethnic code list available NOBT         S           Ethnicity                                               C             2000-10-10
                        Code                                                            at
                                                                                        http://www.teachernet.gov.
                                                                                        uk/management/ims/data
                                                                                        management/cbds/CBDSs
                                                                                        pecs/
   100023 P14           Source of Pupil    Source of pupil's recorded        A(1)       Ethnicity Source                        S           EthnicitySource   <EthnicitySource> must be present     S             2000-10-10 100025,
                        Ethnic Code        ethnic code                                                                                                        where <Ethnicity> is present                                   100058,
                                                                                                                                                              If <Ethnicity> = REFU then                                     100221
                                                                                                                                                              <EthnicitySource> must be C, P or O



   100024 P15           Pupil Traveller/   Code to identify type of          A(2)       Traveller/Gypsy Code                    S           Traveller                                               O             2000-10-10
                        Gypsy Code         Traveller/Gypsy

   100025 P16           Source of Pupil Source of pupil's recorded           A(1)       Traveller Source                        S           TravellerSource                                         O             2006-01-31 100023,
                        Traveller         traveller/gypsy code                                                                                                                                                               100058,
                        Indicator                                                                                                                                                                                            100221
   100026 P17           Pupil Nationality The country of legal nationality   A(3)       Nation states and                       S           Nationality                                             O             2004-05-31 100026,
                                          (ie which country issued the                  countries (consistent with                                                                                                           100139,
                                          pupil's passport)                             GDSC requirement to use                                                                                                              100140,
                                                                                                                                                                                                                             100141,
                                                                                        BSEN 3166 (ISO 3166-1))
                                                                                                                                                                                                                             100142,
                                                                                        available at
                                                                                                                                                                                                                             100143,
                                                                                        http://www.teachernet.gov.                                                                                                           100211,
                                                                                        uk/management/ims/data                                                                                                               100212,
                                                                                        management/cbds/CBDSs                                                                                                                100213,
                                                                                        pecs/                                                                                                                                100214,
                                                                                                                                                                                                                             100215,
                                                                                                                                                                                                                             100216




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                    Page 12 of 58                                                                           Date last updated: 3/4/2011
Identifier Identifier   Data Element       Description                       Business   Format.Values                Format.     Format.     Format.XML_Tag       Format.Validation (CBDS not        Date.       Date.          Relation.
(New       (Old         Name                                                 Format                                  Default     Multiples                        Census validation)                 Periodicity Created        Identifier
CBDS       CBDS                                                                                                                  (S, M)                                                              (C,S,A,O,X)
Ref No)    Ref No)
Pupil Characteristics
   100027 P18           Pupil Refugee/     Indicates a pupil's                A(5)      1,0 or true, false                       S           Refugee              Must be N if <Nationality> = GBR   O             2000-10-10
                        Asylum Seeker      refugee/asylum seeker status
                        Indicator          (Article 1 of the 1951 Refugee
                                           Convention defines a refugee
                                           as a person who is outside
                                           his/her country of nationality or
                                           habitual residence; has a well-
                                           founded fear of persecution
                                           because of his/her race,
                                           religion, nationality,
                                           membership in a particular
                                           social group or political opinion;
                                           and is unable or unwilling to
                                           avail himself/herself of the
                                           protection of that country, or to
                                           return there, for fear of
                                           persecution.
                                           An asylum seeker is a person
                                           whose request or application
                                           for asylum has not been
                                           finally decided on by a
                                           prospective country of refuge.
                                           Source: United Nations High
                                           Commissioner for Refugees
                                           (UNHCR).)




   100028 P20           Pupil Country of The country of birth                A(3)       Nation states and                        S           CountryofOrigin                                         O             2004-05-31 100026,
                        Birth                                                           countries (consistent with                                                                                                            100028,
                                                                                        GDSC requirement to use                                                                                                               100139,
                                                                                                                                                                                                                              100140,
                                                                                        BSEN 3166 (ISO 3166-1))
                                                                                                                                                                                                                              100141,
                                                                                        available at
                                                                                                                                                                                                                              100142,
                                                                                        http://www.teachernet.gov.                                                                                                            100143,
                                                                                        uk/management/ims/data                                                                                                                100211,
                                                                                        management/cbds/CBDSs                                                                                                                 100212,
                                                                                        pecs/                                                                                                                                 100213,
                                                                                                                                                                                                                              100214,
                                                                                                                                                                                                                              100215,
                                                                                                                                                                                                                              100216
   100029 P21           Pupil Religious    Religious faith of the pupil      A(2)       Religion                                 S           Religion                                                O             2000-10-10
                        Affiliation Code

   100030 P22           Pupil Religious    Indicates if the pupil has been   A(1)       W (Withdrawn from RE) or A               S           ReligiousEducation                                      O             2000-10-10
                        Education          withdrawn from RE                            (Attends RE)
                        Indicator




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                     Page 13 of 58                                                                           Date last updated: 3/4/2011
Identifier Identifier   Data Element       Description                          Business     Format.Values                    Format.       Format.     Format.XML_Tag      Format.Validation (CBDS not   Date.       Date.          Relation.
(New       (Old         Name                                                    Format                                        Default       Multiples                       Census validation)            Periodicity Created        Identifier
CBDS       CBDS                                                                                                                             (S, M)                                                        (C,S,A,O,X)
Ref No)    Ref No)
Pupil Characteristics
   100031 P23           Pupil Collective   Indicates if the pupil has been      A(1)         W (Withdrawn from collective                   S           CollectiveWorship                                 O             2000-10-10
                        Worship            withdrawn from collective                         worship) or A (Attends
                        Indicator          worship                                           collective worship)

   100032 P24           Pupil Home LA      Pupil's home LA                      A(3)         LEA list available at                          S           HomeLEA                                           S             2006-01-31 100013,
                                           (Home LA is equivalent to the                     http://www.teachernet.gov.                                                                                                            100043,
                                           “housing authority” as defined                    uk/management/ims/data                                                                                                                100061,
                                           in Section 11.2 of the DfES                                                                                                                                                             100239,
                                                                                             management/cbds/CBDSs
                                           Guidance on the Education of                                                                                                                                                            100261
                                                                                             pecs/
                                           Young People in Public Care)

   100033 P25           Pupil Free         Indicates if the pupil is eligible A(5)           1,0 or true, false                             S           FSMeligible                                       C             2004-12-01
                        School Meal        for free school milk
                        Eligibility        (Pupils should be recorded as
                                           eligible only if a claim for free
                                           school meals has been made
                                           by them or on their behalf by
                                           parents and either (a) the
                                           relevant authority has
                                           confirmed their eligibility and a
                                           free school meal is currently
                                           being provided or (b) the
                                           school or the LA have seen the
                                           necessary documentation (for
                                           example, an Income Support
                                           order book) that supports their
                                           eligibility, and the
                                           administration of the free meal
                                           is to follow as a matter of
                                           process. Conversely, if pupils
                                           are in receipt of a free meal but
                                           there is confirmation that they
                                           are no longer eligible and
                                           entitlement will be revoked,
                                           false should be applied.)




   100034 P26           Pupil Free         Review date for pupil's free         CCYY-MM-DD   Any valid date after current                   S           FSMreviewDate                                     C             2000-10-10
                        School Meal        school meal eligibility                           date
                        Review Date
   100035 P27           Pupil Free         Indicates if the pupil is eligible   A(5)         1,0 or true, false                             S           FreeTransport                                     C             2004-12-01
                        School             for free school transport
                        Transport
                        Eligibility
   100036 P27a          Connexions         Indicates if parents consent to      A(3)         Connexions Agreement             UNS           S           Connexions                                        S             2004-05-31
                        Agreement          pupil data being shared with
                                           Connexions
                                           (Middle, Secondary and
                                           Special Schools only)




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                                Page 14 of 58                                                                     Date last updated: 3/4/2011
Identifier Identifier   Data Element        Description                      Business   Format.Values                Format.      Format.     Format.XML_Tag          Format.Validation (CBDS not           Date.       Date.          Relation.
(New       (Old         Name                                                 Format                                  Default      Multiples                           Census validation)                    Periodicity Created        Identifier
CBDS       CBDS                                                                                                                   (S, M)                                                                    (C,S,A,O,X)
Ref No)    Ref No)
Pupil Characteristics
   100037 P180          Gifted &            Indicates if the pupil is in the  A(5)      1,0 or true, false           false or 0   S           GandTindicator                                                C             2004-12-10
                        Talented            Gifted & Talented cohort for
                        indicator           the school
   100038 P28           In Care Indicator   Indicates if the child is 'looked A(5)      1,0 or true, false                        S           InCare                                                        C             2004-12-01
                                            after' on the census day.
                                            (The term „looked after‟ was
                                            introduced by the Children Act
                                            1989, and refers to children
                                            who are subject to care orders
                                            and those who are
                                            accommodated. Source: DfES
                                            Guidance on the Education of
                                            Young People in Public Care)



   100039 P29           In Care - Caring Code of the 'originating'        A(3)          LEA list available at                     S           CareAuthority           If <InCare> = true or                 S             2000-10-10 100013,
                        Authority Code authority, where the child was                   http://www.teachernet.gov.                                                    <InCareAtCurrentSchool> = true then                            100032,
                                         originally placed in public care               uk/management/ims/data                                                        <CareAuthority> must be a valid LA                             100061,
                                         and which looks after the child                                                                                              number                                                         100239,
                                                                                        management/cbds/CBDSs
                                         for the purposes of the                                                                                                                                                                     100261
                                                                                        pecs/
                                         Children Act 1989
                                         (Equivalent to the “originating
                                         authority” as defined in Section
                                         11.2 of the DfES Guidance on
                                         the Education of Young People
                                         in Public Care)



   100040 P30           In Care while at Indicates if the pupil has ever  A(5)          1,0 or true, false                        S           InCareAtCurrentSchool   If <InCare> = true then               S             2004-12-01
                        current school   been in care while at the school                                                                                             <InCareAtCurentSchool> must also
                        indicator                                                                                                                                     be true




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                    Page 15 of 58                                                                                   Date last updated: 3/4/2011
Identifier Identifier   Data Element     Description                       Business   Format.Values          Format.       Format.     Format.XML_Tag          Format.Validation (CBDS not   Date.       Date.          Relation.
(New       (Old         Name                                               Format                            Default       Multiples                           Census validation)            Periodicity Created        Identifier
CBDS       CBDS                                                                                                            (S, M)                                                            (C,S,A,O,X)
Ref No)    Ref No)
Pupil Characteristics
   100041 P31           Personal         Indicates whether the pupil in     A(5)      1,0 or true, false                   S           PersonalEducationPlan                                 S             2004-12-01
                        Education Plan   care has a personal education
                        Indicator        plan
                                         (“Every child and young person
                                         in public care needs a Personal
                                         Education Plan which ensures
                                         access to services and
                                         support; contributes to stability,
                                         minimises disruption and
                                         broken schooling; signals
                                         particular and special needs;
                                         establishes clear goals and
                                         acts as a record of progress
                                         and achievement.”
                                         “When a child enters public
                                         care the Social Worker will
                                         inform the school and the
                                         LA….The social worker is
                                         responsible for initiating a PEP
                                         in partnership with the child or
                                         young person, designated
                                         teacher, parent and/or relevant
                                         family member, carer and any
                                         other person that may be
                                         relevant….The PEP should be
                                         agreed as soon as possible
                                         and at least within 20 school
                                         days of entering care or of
                                         joining a new school.”)




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                               Page 16 of 58                                                                         Date last updated: 3/4/2011
Identifier Identifier   Data Element      Description                       Business   Format.Values                Format.    Format.     Format.XML_Tag       Format.Validation (CBDS not    Date.       Date.          Relation.
(New       (Old         Name                                                Format                                  Default    Multiples                        Census validation)             Periodicity Created        Identifier
CBDS       CBDS                                                                                                                (S, M)                                                          (C,S,A,O,X)
Ref No)    Ref No)
Pupil Characteristics
   100042 P32           Child Protection Indicates if the pupil is on the    A(5)      1,0 or true, false                      S           ProtectionRegister                                  C             2004-12-01
                        Register         Child Protection Register
                        Indicator        (“Child protection register: in
                                         each area covered by a social
                                         services department, a central
                                         register must be maintained
                                         which lists all the children in the
                                         area who are considered to be
                                         suffering from, or are likely to
                                         suffer, significant harm and for
                                         which there is a child protection
                                         plan. This is not a register of
                                         children who have been
                                         abused but of children for
                                         whom there are currently
                                         unresolved child protection
                                         issues.”
                                         Source: DfEE Special
                                         Educational Needs Glossary)




   100043 P33           Pupil Child       The LA code where a pupil is      A(3)       LEA list available at                   S           RegisterLEA          Must not be blank if           C             2006-01-31 100013,
                        Protection        on the LA's Child Protection                 http://www.teachernet.gov.                                               <ProtectionRegister> is TRUE                            100032,
                        Register LA       Register                                     uk/management/ims/data                                                                                                           100061,
                        Code              (See <ProtectionRegister>                    management/cbds/CBDSs                                                                                                            100239,
                                          above)                                                                                                                                                                        100261
                                                                                       pecs/
   100044 P50           First Language    The language to which the child A(3)         First Language                          S           FirstLanguage                                       C             2004-05-31
                                          was exposed during early
                                          development and continues to
                                          use in the home or in the
                                          community. If a child acquires
                                          English subsequent to early
                                          development, then English is
                                          not their first language.

   100045 P52           Language Type Types of pupil language usage: A(1)              LanguageType                            S           LanguageQualifier                                   C             2005-04-30
                                      'First language‟, „Multiple First
                                      Language‟, 'Home Language‟,
                                      'Tuition Language' and „Second
                                      Language‟



   100046 P53           Language Code Codes for language(s) used by A(4)               Language code list                      S           Language                                            C             2005-04-30
                                      pupils
   100047 P53a          Language Code Codes for language(s) used by A(4)               Language code list                      S           Language                                            C             2006-01-31
                                      pupils (incorporating First                      available at
                                      Language (P50) code set)                         http://www.teachernet.gov.
                                                                                       uk/management/ims/data
                                                                                       management/cbds/CBDSs
                                                                                       pecs/




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                   Page 17 of 58                                                                       Date last updated: 3/4/2011
Identifier Identifier   Data Element       Description                      Business     Format.Values                   Format.     Format.     Format.XML_Tag            Format.Validation (CBDS not         Date.       Date.          Relation.
(New       (Old         Name                                                Format                                       Default     Multiples                             Census validation)                  Periodicity Created        Identifier
CBDS       CBDS                                                                                                                      (S, M)                                                                    (C,S,A,O,X)
Ref No)    Ref No)
Pupil Characteristics
   100048 P194          Usual mode of      The usual mode of travel          A(3)        Usual mode of Travel                        S           ModeOfTravel                                                  C             2006-01-31
                        travel             normally used by the child for
                                           the greater part (in distance) of
                                           the journey to and from school.

   100049               Free school        Indicates if pupil has claimed   A(5)         1,0 or true, false                          S           FSMClaim                                                      O             2006-01-31
                        meal taken or      for a free school meal on
                        claimed            Census day
   100050               Free School        Review date for pupil's free     CCYY-MM-DD                                               S           FreeTransportreviewDate                                       O             2006-01-31
                        Transport          school transport eligibility
                        Eligibility
                        Review Date
   100051               Type of care       Type of care child is in eg      A(2)         In care type                                S           InCareType                                                    O             2006-01-31
                                           fostering, children's home
   100052               English as         Assessment of a pupil's          A(1)         Assessment component                        S           EALSteps                                                      O             2006-01-31 100274,
                        additional         progress in English as an                     details 2006 available at                                                                                                                      100275,
                        language           Additional Langage based on                   http://www.teachernet.gov.                                                                                                                     100276
                                           QCA Steps: S1 (Step 1), S2
                                                                                         uk/management/ims/data
                                           (Step 2), 1T (Level 1
                                                                                         management/cbds/CBDSs
                                           Threshold), 1S (Level 1
                                           Secure).                                      pecs/
   100053               Family structure Indicates type of family           A(1)         Family                                      S           Family                                                        O             2006-01-31
                                         structure pupil is living in
   100054               Sibling on Child Indicates if the pupil has a       A(5)         1,0 or true, false                          S           SilbingChildProtection                                        O             2006-01-31
                        Protection       sibling on the Child Protection
                        Register         Register

   100055               Number of          Number of previous schools       99                                                       S           PreviousSchools                                               O             2006-01-31
                        previous           derived from school history
                        schools            module
   100056               Pregnant pupil                                      A(5)         1,0 or true, false                          S           Pregnancy                                                     O             2006-01-31
                        indicator
   100057               Uniform            Indicates if pupil is paid a     A(5)         1,0 or true, false                          S           UniformAllowance                                              O             2006-01-31
                        allowance          uniform allowance
                        indicator
   100058               Source of pupil                                     A(1)         Religion Source                             S           ReligionSource                                                O             2006-01-31 100023,
                        religious                                                                                                                                                                                                       100025,
                        affiliation code                                                                                                                                                                                                100221
   100059 P171          Date of Entry      Date of arrival in UK            CCYY-MM-DD   Any valid date after 2002-09-               S           DateEntry                 Must be blank if                    O             2006-01-31
          Wales only                                                                     01 (this value will increment                                                     <NonEnglishWelshSystems> is false
                                                                                         each year)                                                                        and/or <Refugee> is false.
                                                                                                                                                                           Must have a value if
                                                                                                                                                                           <NonEnglishWelshSystems> is true
                                                                                                                                                                           and/or <Refugee> is true.




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                         Page 18 of 58                                                                                 Date last updated: 3/4/2011
Pupil Level: Pupil Characteristics Module Codesets

Ethnicity Source/Traveller Source/Religion Source                      First Language                                                 Usual mode of Travel
C             Provided by the child (ie pupil)                         ENG          English                                           WLK          Walk
P             Provided by the parent                                   ENB          Not known but believed to be English              CYC          Cycle
S             Ascribed by the current school                           OTH          Other than English                                CAR          Car/Van
T             Ascribed by a previous school                            OTB          Not known but believed to be other than English   CRS          Car Share (with a child/children from a different
                                                                                                                                                   household)
O             Other                                                    REF            Refused                                         PSB          Public service bus
                                                                       NOT            Information not obtained                        DSB          Dedicated school bus
                                                                                                                                      BNK          Bus (type not known)
Traveller/Gypsy Code                                                                                                                  TXI          Taxi
GH           Gypsy/Roma (Housed)                                       LanguageType                                                   TRN          Train
GT           Gypsy/Roma (Travelling)                                   F          First Language                                      LUL          London Underground
OT           Occupational Traveller                                    M          Multiple First Language                             MTL          Metro/Tram/Light Rail
TR           Traveller (Other)                                         H          Home                                                OTH          Other
NT           Not a Traveller                                           T          Tuition
                                                                       S          Second Language
                                                                                                                                      Family
Religion                                                                                                                              S            Single parent
BU            Buddhist                                                 In care type                                                   A            2 adults
CH            Christian                                                FT             Fostered                                        F            Foster parents
HI            Hindu                                                    CH             Children's Home                                 C            In residential care
JE            Jewish                                                   WP             With parents                                    U            Unknown
MU            Muslim                                                   PA             Placed for adoption
NO            No religion                                              OT             Other
OT            Other religion
SI            Sikh


Connexions Agreement
Yes         Permission has been given by the parent or guardian

No            Parent or guardian has refused permission
UNS           School has not yet sent out Fair Processing Notices
(Unsought)    (Data cannot be shared with Connexions)

SNR           School has sent out Fair Processing Notices, but has
(Sought, No   received no reply from parent or guardian (Data can be
Reply         shared with Connexions)




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                           Page 19 of 58                                                            Date last updated: 3/4/2011
3 Pupil Status
Identifier Identifier   Data Element    Description                       Business     Format.Values                Format.     Format.     Format.XML_Tag   Format.Validation (CBDS not            Date.       Date.          Relation.
(New         (Old       Name                                              Format                                    Default     Multiples                    Census validation)                     Periodicity Created        Identifier
CBDS         CBDS                                                                                                               (S, M)                                                              (C,S,A,O,X)
Ref No)      Ref No)
Pupil Status
   100060 P34           Pupil Enrolment Enrolment status of a pupil       A(1)         Pupil Enrolment Status       C           S           EnrolStatus                                             S             2000-10-10
                        status          using one of the registration
                                        codes supplied in the codeset

   100061 P35           Other School    The LA code of the other          A(3)         LEA list available at                    S           LEA              Must be blank if <EnrolStatus> = C     S             2006-01-31 100013,
                        LA number       school(s) for dually registered                http://www.teachernet.gov.                                            Must not be blank if <ENrolStatus> =                            100032,
                                        pupils                                         uk/management/ims/data                                                M or S                                                          100043,
                                                                                       management/cbds/CBDSs                                                                                                                 100239,
                                                                                                                                                                                                                             100261
                                                                                       pecs/
   100062 P36           Other School    The DfES establishment code A(4)               Establishment list - This                S           Estab            Must be blank if <EnrolStatus> = C     S             2006-01-31 100014,
                        DfES            of the other school(s) for dually              file is too large to be                                               Must not be blank if <ENrolStatus> =                            100240,
                        Establishment   registered pupils                              offered as a download;                                                M or S                                                          100260
                        Number                                                                                                                               0001-0900 Secure Units &
                                                                                       please request a copy by
                                                                                                                                                             Miscellaneous; 0940-0949 Playing for
                                                                                       email from
                                                                                                                                                             Success Centres; 1000-1099 LA
                                                                                       ChangeControl.CBDS@df                                                 Nursery Schools; 1100-1149 Pupil
                                                                                       es.gsi.gov.uk.                                                        Referral Unit; 1800-1999
                                                                                                                                                             Miscellaneous; 2000-3999 Maintained
                                                                                                                                                             Primary (inc Middle deemed Primary);
                                                                                                                                                             4000-4899 Maintained Secondary (inc
                                                                                                                                                             Middle Deemed Secondary); 4900-
                                                                                                                                                             4999 Sixth Form Centres; 5200-5299
                                                                                                                                                             Maintained Primary (Ex GM - inc
                                                                                                                                                             Middle deemed Primary); 5400-5499
                                                                                                                                                             Maintained Secondary (Ex GM - inc
                                                                                                                                                             Middle deemed Secondary); 5900-
                                                                                                                                                             5949 Mixed Maintained Primary and
                                                                                                                                                             Secondary; 5950-5999 Foundation
                                                                                                                                                             Special (Ex GM); 6000-6599
                                                                                                                                                             Independent Schools (inc Special and
                                                                                                                                                             Approved for SEN); 6900-6904 City
                                                                                                                                                             Technology Colleges; 6905-6924
                                                                                                                                                             Academies; 7000-7751 Special
                                                                                                                                                             Schools; 7500-7511 Non-maintained
                                                                                                                                                             and Community Special Schools;
                                                                                                                                                             7748-7754 Community Special
                                                                                                                                                             Schools; 7900-7901 Special Colleges;
                                                                                                                                                             8000-8799 Further Education (inc
                                                                                                                                                             Sixth Form Colleges, incl. 8713 for
                                                                                                                                                             Nottingham Trent University); 9455
                                                                                                                                                             Lea House Hospital; 9500-9910
                                                                                                                                                             Miscellaneous (inc Secure Units, incl.
                                                                                                                                                             9565 for Blaby Community Home)


   100063 P37           Pupil Date of   Date of entry to current school   CCYY-MM-DD   Any valid date                           S           EntryDate                                               C             2000-10-10
                        entry




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                    Page 20 of 58                                                                           Date last updated: 3/4/2011
Identifier Identifier   Data Element      Description                       Business      Format.Values                 Format.       Format.     Format.XML_Tag      Format.Validation (CBDS not             Date.       Date.           Relation.
(New         (Old       Name                                                Format                                      Default       Multiples                       Census validation)                      Periodicity Created         Identifier
CBDS         CBDS                                                                                                                     (S, M)                                                                  (C,S,A,O,X)
Ref No)      Ref No)
Pupil Status
   100064 P38           Pupil Date of     Date pupil left current school    CCYY-MM-DD    Any valid date                              S           LeavingDate                                                 S              2000-10-10
                        Leaving           (For a permanently excluded
                                          pupil, Pupil Date of Leaving will
                                          be the day the pupil‟s name is
                                          removed from the school roll
                                          (until 31/08/2005) and the day
                                          the pupil‟s name is removed
                                          from the school roll (with effect
                                          from 01/09/2005).)



   100065 P42           Pupil Part-time   Indicates whether a pupil is    A(5)            1,0 or true, false            false         S           PartTime                                                    S              2004-12-01
                        Indicator         part-time or not.
                                          (For dual-registered pupils,
                                          time in other schools should be
                                          taken into consideration; eg 2
                                          days in one school and 3 days
                                          in another school should not be
                                          classified by either school as
                                          part-time.)


   100066 P43           Pupil - Number    Number of pupil sessions (half               99 A number between 1 and 10                   S           Sessions            If <PartTime> = N and <EnrolStatus>     S              2000-08-11
                        of sessions       days) per week                                                                                                              = C then must be 10.
                                                                                                                                                                      If <PartTime> = Y or <EnrolStatus> =
                                                                                                                                                                      M or S then must be in the range 1-9.



   100067 P44           Pupil Boarder     Indicates whether a pupil is a     A(1)         Pupil Boarder                 N             S           Boarder             If <PartTime> = true then <Boarder>      S             2000-10-10
                        Indicator         boarder or not                                                                                                              must be N or missing
   100068 P45           Pupil's Actual    The year group in which the        A(2)         Pupil NC Year Group           Default to    S           NCyearActual        If not "X", must be in range (age minus C              2000-10-10
                        National          pupil is taught for the majority                                              N1 if age =                                   6) to (age minus 2) if age greater than
                        Curriculum        of their time, regardless of their                                            2 or below.                                   6.
                        Year Group        chronological age                                                             Default to                                    Must be R, 1, 2, 3 or 4 if age = 6.
                                                                                                                        N2 if age =                                   Must be N1, N2, R, 1, 2 or 3 if age = 5.
                                                                                                                        3.                                            Must be N1, N2, R, 1 or 2 if age = 4.
                                                                                                                        Default to                                    Must be N1, N2, R or 1 if age = 3.
                                                                                                                        R if age = 4.                                 Must be N1, N2 or R if age = 2.
                                                                                                                        Default to                                    (All ages are as at previous 31
                                                                                                                        (age minus                                    August).
                                                                                                                        4) if age
                                                                                                                        greater
                                                                                                                        than 4.




   100069 P46           Pupil Class       Indicates if the pupil is in a    A(1)          Class Type                    O             S           ClassType           Should be O or X if age at previous 31 S               2005-04-30
                        Type Indicator    nursery or special class/unit                                                                                               August>=6
                                                                                                                                                                      Must be N or O if <SENprovision> = N

   100070 P48           Pupil             Name of pupil's registration      A(30)         Any character string                        S           RegistrationGroup                                           O              2000-10-10
                        Registration      group
                        Group




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                          Page 21 of 58                                                                                Date last updated: 3/4/2011
Identifier Identifier   Data Element   Description                    Business   Format.Values                   Format.    Format.     Format.XML_Tag    Format.Validation (CBDS not   Date.       Date.          Relation.
(New         (Old       Name                                          Format                                     Default    Multiples                     Census validation)            Periodicity Created        Identifier
CBDS         CBDS                                                                                                           (S, M)                                                      (C,S,A,O,X)
Ref No)      Ref No)
Pupil Status
   100071 P49           Pupil Email    Pupil's email address          A(254)     string1@string2                            S           Email                                           O             2000-10-10 100172
                        Address                                                  string1 and string2 may
                                                                                 include any characters except
                                                                                 @
   100072               Leaving        Pupil's destination on leaving  A(2)      Leaving Destination                        S           Destination                                     O             2006-01-31
                        destination    the school
   100073               Name of        Name of institution/employer of A(100)    Any character string                       S           DestinationName                                 O             2006-01-31
                        leaving        pupil's destination
                        destination




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                Page 22 of 58                                                                   Date last updated: 3/4/2011
Pupil Level: Pupil Status Module Codesets
Pupil Enrolment Status
C          Current (single registration at this school)
G          Guest (pupil not registered at this school but attending some
           lessons or sessions)
M          Current Main (dual registration)
S          Current Subsidiary (dual registration)
P          Previous


Pupil Boarder
B          Boarder, nights per week not specified
6          Boarder, six nights or less a week
7          Boarder, seven nights a week
N          Not a boarder


Pupil NC Year Group
N1         Nursery first year
N2         Nursery second year
R          Reception
1-14       Years 1 to 14
X          National Curriculum not followed – available only for
            Special Schools where pupils are not following a
            particular NC Year


ClassType
N           Nursery Class (not a Special Class/Unit)
O           Other Class (not a Special Class/Unit)
S           Nursery Special Class/Unit
X           Other Special Class/Unit


Leaving Destination
PS        Primary school
SS        Secondary school
SC        6th Form College
FE        Further Education/Training
HE        University
EM        Employment/Training
NK        Other/Not Known




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                   Page 23 of 58   Date last updated: 3/4/2011
4 Special Educational Needs
Identifier Identifier Data Element      Description                        Business     Format.Values                     Format.      Format.     Format.XML_Tag              Format.Validation (CBDS not            Date.       Date.          Relation.
(New       (Old        Name                                                Format                                         Default      Multiples                               Census validation)                     Periodicity Created        Identifier
CBDS       CBDS                                                                                                                        (S, M)                                                                         (C,S,A,O,X)
Ref No)    Ref No)
Special Educational Needs
   100074 P181         Member of SEN    Indicates if a pupil with SEN in   A(5)         1,0 or true, false                false or 0   S           SpecialProvisionIndicator   Not required if <SENprovision> = N or C              2004-12-10
                       Unit, special    a mainstream school is a                                                                                                               A
                       class or         member of an SEN Unit,                                                                                                                 Must be true if <ClassType> = S or X
                       resourced        special class or resourced                                                                                                             Must be false if <ClassType> = N or O
                       provision        provision

   100075 P195       Member of SEN      Indicates if a pupil with SEN in   A(5)         1,0 or true, false                false or 0   S           SENUnitIndicator                                                   C             2006-01-31
                     Unit (sometimes    a mainstream school is a
                     called special     member of an SEN Unit
                     class) indicator   (sometimes called special
                                        class)
   100076 P196       Member of          Indicates if a pupil with SEN in   A(5)         1,0 or true, false                false or 0   S           ResourcedProvisionIndicat                                          C             2006-01-31
                     resourced          a mainstream school is a                                                                                   or
                     provision          member of a resourced
                     indicator          provision
   100077 P54        Pupil SEN          Provision types under the SEN      A(1)         Pupil SEN Provision               N            S           SENprovision                                                       C             2004-05-31
                     Provision          Code of Practice
                     (formerly stage)
   100078 P55        Pupil date placed Date placed on current SEN          CCYY-MM-DD   Any valid date after current                   S           StartDate                   Must be present if <SENprovision> is   S             2000-10-10
                     upon stage        stage                                            date                                                                                   not N

   100079 P56        Pupil date of next Date of pupil's next SEN review CCYY-MM-DD      Any valid date after                           S           NextReviewDate              Must be present if <StartDate> is  S                 2000-10-10
                     SEN review                                                         <StartDate>                                                                            present
   100080 P57        Pupil SEN Type                                     99              Integer from 1 in order of                     M           SENtypeRank                 Cannot be 2 if there is no         S                 2005-04-30
                     ranking                                                            significance of special                                                                <SENtypeRank> = 1; Cannot be 3 if
                                                                                        educational need                                                                       no <SENNtypeRank>=1 and
                                                                                                                                                                               <SENtypeRank> = 2 etc.
                                                                                                                                                                               Must be at least one <SENtypeRank>
                                                                                                                                                                               if <SENprovision> is not N
                                                                                                                                                                               <SENtype> must be present when
                                                                                                                                                                               <SENtypeRank> is present
                                                                                                                                                                               <SENtypeRank> must be present
                                                                                                                                                                               when <SENtype> is present


   100081 P58        Pupil SEN type     Nature of pupil's special          A(4)         Pupil SEN Type                                 M           SENtype                     Must be 1 or 2 <SENtype>if             S             2005-04-30
                     code               educational need.                                                                                                                      <SENprovision> not N
   100082 P61        National                                              A(1)         M (National Curriculum                         S           Modification                                                       S             2000-08-11
                     Curriculum                                                         modified) or N (National
                     Modification or                                                    Curriculum disapplied)
                     Dissapplication
   100083 P62        National           National Curriculum subject for A(3)            General subjects v3.0 at                       M           Subject                                                            S             2004-05-31
                     Curriculum         which modification or                           http://www.teachernet.gov.
                     Subject            disapplication applies                          uk/management/ims/data
                                                                                        management/cbds/CBDSs
                                                                                        pecs/
   100084 P64a       Pupil Medical      Indicates whether there is         A(5)         1,0 or true, false                             S           MedicalFlag                                                        C             2004-05-31
                     Flag               medical information on a pupil.




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                           Page 24 of 58                                                                                      Date last updated: 3/4/2011
Special Educational Needs
   100085 P63          Pupil Medical                                    A(60)                                             M   Medical              No validation   O             2006-01-31
           (Wales      Condition/ Notes
           only)
   100086              Paramedical        Type of therapy pupil needs   A(1)    P (Physiotherapy), S (Speech              M   ParamedicalSupport                   O             2006-01-31
                       support                                                  therapy), O (Occupational
                                                                                therapy)




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                             Page 25 of 58                                                Date last updated: 3/4/2011
Pupil Level: Pupil SEN Module Codesets
Pupil SEN Provision
N          No Special Educational Need
A          School Action or Early Years Action
P          School Action Plus or Early Years Action Plus
S          Statement
Q          School ActionPlus and Statutory Assessment (for historical
           and/or local purposes only - not valid for PLASC/School Census)




Pupil SEN Type
SPLD       Specific Learning Difficulty
MLD        Moderate Learning Difficulty
SLD        Severe Learning Difficulty
PMLD       Profound & Multiple Learning Difficulty
BESD       Behaviour, Emotional & Social Difficulties
SLCN       Speech, Language and Communication Needs
HI         Hearing Impairment
VI         Visual Impairment
MSI        Multi-Sensory Impairment
PD         Physical Disability
ASD        Autistic Spectrum Disorder
OTH        Other Difficulty/Disability




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                 Page 26 of 58   Date last updated: 3/4/2011
5 Exclusions
Identifier   Identifier   Data Element      Description                        Business     Format.Values                  Format.   Format.     Format.XML_Tag   Format.Validation (CBDS not           Date.       Date.          Relation.
(New         (Old         Name                                                 Format                                      Default   Multiples                    Census validation)                    Periodicity Created        Identifier
CBDS         CBDS                                                                                                                    (S, M)                                                             (C,S,A,O,X)
Ref No)      Ref No)
Exclusions
   100087 P66             Exclusion         For each exclusion, type of        A(4)         FIXD (Fixed), PERM                       M           Category                                               C             2006-01-31
                          Category          exclusion                                       (Permanent), LNCH
                                                                                            (Lunchtime)
   100088 P67             Exclusion         For each exclusion, reason for     A(2)         Pupil Exclusion Reason                   M           Reason                                                 C             2003-07-18
                          Reason            exclusion
   100089 P68             Exclusion Start   For each exclusion, exclusion      CCYY-MM-DD   Valid date before or on                  M           StartDate        Definition to cease 31/08/2005        C             2005-04-30
                          Date              start date (the day the pupil‟s                 current date                                                          Must be blank if <AppealResult> = R
                                            name has been removed from                                                                                            Must be same as <LeavingDate> for
                                            the school roll).                                                                                                     permanent exclusion (but only after
                                                                                                                                                                  appeal)

   100090 P68a            Exclusion Start   For each exclusion, Exclusion      CCYY-MM-DD   Valid date before or on                  M           StartDate                                              C             2004-12-01
                          Date              Start Date (irrespective of any                 current date
                                            review or appeal). Normally,
                                            this will not be the same as
                                            Pupil Date of Leaving and it
                                            should be noted that the pupil
                                            will remain on the school's roll
                                            for a period after Exclusion
                                            Start Date.


   100091 P69             Exclusion Start   For each exclusion, Exclusion      A(2)         AM or PM                                 M           Session                                                O             2000-10-10
                          (am/pm)           Start session
   100092 P70             Exclusion End     For each exclusion,                CCYY-MM-DD   Valid date after Exclusion               M           EndDate          Must be blank if <AppealResult>       S             2000-10-10
                          Date              Exclusion End Date                              Start Date                                                            = R and/or <Category> = PERM

   100093 P70a            Exclusion         For each exclusion, number of 99                                                         M           Sessions         If <Category> = FIXD or LNCH          C             2005-04-30
                          Actual Number     sessions for which the                                                                                                <Sessions> must be present
                          of Sessions       exclusion is in effect. For                                                                                           <Sessions> should be less than or
                                            lunchtime exclusions, each                                                                                            equal to 90
                                            lunchtime for which the                                                                                               <Sessions> should not be provided
                                            exclusion applies is one                                                                                              where <Category> = PERM
                                            session. For fixed term and
                                            permanent exclusions, each
                                            half school day is one session.
                                            For exclusions which are
                                            followed by reinstatement the
                                            actual, not the planned number
                                            of sessions should be
                                            recorded. (Exclusion sessions
                                            are used only to calculate the
                                            total allowable in a term or
                                            academic year and are not the
                                            same as an attendance
                                            session.)




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                             Page 27 of 58                                                                      Date last updated: 3/4/2011
Identifier   Identifier   Data Element       Description                     Business     Format.Values                      Format.   Format.     Format.XML_Tag             Format.Validation (CBDS not            Date.       Date.          Relation.
(New         (Old         Name                                               Format                                          Default   Multiples                              Census validation)                     Periodicity Created        Identifier
CBDS         CBDS                                                                                                                      (S, M)                                                                        (C,S,A,O,X)
Ref No)      Ref No)
Exclusions
   100094 P71             Exclusion        Indicates an appeal against       A(5)         1,0 or true, false                           M           Appeal                                                            C             2004-12-01
                          Appeal Indicator permanent exclusion

   100095 P72             Exclusion          The date for appeal against     CCYY-MM-DD                                                M           AppealDate                 Must be blank if <Appeal> = false      C             2000-10-10
                          Appeal Date        permanent exclusion                                                                                                              Must not be blank if <Appeal> = true

   100096 P73             Exclusion          The result of appeal against    A(1)         R (Reinstatement), E                         M           AppealResult               Must not be blank if <Appeal> = true   C             2000-10-10
                          Appeal Result      permanent exclusion                          (Exclusion stands), O
                                                                                          (Reinstatement would be
                                                                                          appropriate but not in best
                                                                                          interests of child given other
                                                                                          circumstances)
   100097 P73a            Exclusion          If the result of appeal is      CCYY-MM-DD   Valid date before or on                      M           ReinstatementDate                                                 C             2003-08-31
                          Reinstatement      Reinstatement, the date of                   current date
                          Date               Reinstatement
   100098                 Date of            Date of exclusion          CCYY-MM-DD        Valid date before or on                      M           HeadteacherNotification                                           C             2006-01-31
                          exclusion          notification to parents,                     current date                                             Date
                          notification by    school LA and pupil's home
                          Headteacher
                                             LA (if different)
   100099                 Date of                                            CCYY-MM-DD   Valid date before or on                      M           GovernorMeetingDate                                               C             2006-01-31
                          Governors'                                                      current date
                          Meeting re
                          exclusion
   100100                 Date of                                            CCYY-MM-DD   Valid date before or on                      M           HearingNoticeOfAppealDat                                          C             2006-01-31
                          exclusion                                                       current date                                             e
                          hearing/
                          expiration of
                          notice of appeal

   100101                 Permanent          Status of permanent exclusion   A(3)         Pupil Exclusion Status                       M           ExclusionStatus                                                   C             2006-01-31
                          exclusion
                          pending appeal




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                               Page 28 of 58                                                                                 Date last updated: 3/4/2011
Pupil Level: Exclusions Module Codesets

Pupil Exclusion Reason
PP         Physical assault against a pupil
PA         Physical assault against an adult
VP         Verbal abuse/threatening behaviour against a pupil
VA         Verbal abuse/threatening behaviour against an adult
BU         Bullying
RA         Racist abuse
SM         Sexual misconduct
DA         Drug and alcohol related
DM         Damage
TH         Theft
DB         Persistent disruptive behaviour
OT         Other



Pupil Exclusion Status
UAP        Upheld by independent appeal panel
OGR        Overturned by the governors
OAR        Overturned by an independent appeal panel
AWA        Awaiting appeal




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                         Page 29 of 58   Date last updated: 3/4/2011
6 Home Information
Identifier Identifier   Data Element    Description                      Business       Format.Values                     Format.   Format.     Format.XML_Tag   Format.Validation (CBDS not   Date.       Date.          Relation.
(New       (Old         Name                                             Format                                           Default   Multiples                    Census validation)            Periodicity Created        Identifier
CBDS       CBDS                                                                                                                     (S, M)                                                     (C,S,A,O,X)
Ref No)    Ref No)
Home Information
   100102 P74           Pupil Address   Indicates whether address        A1             C - Current - address where                 M           AddressType                                    S             2006-01-31
                        Type            given is pupil's current,                       pupil is normally resident; P -
                                        previous, in care or alternate                  Previous - default type for any
                                        address or address for                          current address superseded
                                        transport or mail                               by a later current address
                                                                                        where a history of addresses
                                                                                        is held; T - Transport -
                                                                                        address from which/to which
                                                                                        a pupil is transported by a
                                                                                        transport contractor which
                                                                                        may be different from the
                                                                                        current address



   100103 P75           Sub-dwelling    Flat, apartment name or         BS7666 v1.4                                                 M           SAON                                           S             2003-08-31 100174
                                        number or other sub-division of Secondary
                                        a dwelling                      Addressable
                                                                        Object Name
                                                                        A(100)
   100104               SAON Start      Start (single) dwelling number BS7666 v2.0                                                  S           Number                                         S             2006-01-31 100175
                        Number                                          SAON Start
                                                                        Number
                                                                        9999
   100105               SAON Start      Start (single) dwelling number BS7666 v2.0                                                  S           Suffix                                         S             2006-01-31 100176
                        Number Suffix   suffix                          SAON Start
                                                                        Number Suffix
                                                                        A(1)
   100106               SAON End        End dwelling number             BS7666 v2.0                                                 S           Number                                         S             2006-01-31 100177
                        Number                                          SAON End
                                                                        Number
                                                                        9999
   100107               SAON End        End dwelling number suffix      BS7666 v2.0                                                 S           Suffix                                         S             2006-01-31 100178
                        Number Suffix                                   SAON End
                                                                        Number Suffix
                                                                        A(1)
   100108               SAON            Dwelling name                   BS7666 v2.0                                                 S           Description                                    S             2006-01-31 100179
                        Description                                     SAON
                                                                        Description
                                                                        A(90)
   100109 P76           Dwelling        Dwelling name and/or number BS7666 v1.4                                                     M           PAON                                           S             2000-10-10 100180
                                                                        Primary
                                                                        Addressable
                                                                        Object Name
                                                                        A(100)
   100110               PAON Start      Start (single) dwelling number BS7666 v2.0                                                  S           Number                                         S             2006-01-31 100181
                        Number                                          PAON Start
                                                                        Number
                                                                        9999




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                       Page 30 of 58                                                                  Date last updated: 3/4/2011
Identifier Identifier   Data Element     Description                       Business          Format.Values      Format.      Format.     Format.XML_Tag       Format.Validation (CBDS not          Date.       Date.        Relation.
(New       (Old         Name                                               Format                               Default      Multiples                        Census validation)                   Periodicity Created      Identifier
CBDS       CBDS                                                                                                              (S, M)                                                                (C,S,A,O,X)
Ref No)    Ref No)
Home Information
   100111               PAON Start       Start (single) dwelling number      BS7666v2.0                                      S           Suffix                                                    S             2006-01-31 100182
                        Number Suffix    suffix                              PAON Start
                                                                             Number Suffix
                                                                             A(1)
   100112               PAON End         End dwelling number                 BS7666v2.0                                      S           Number                                                    S             2006-01-31 100183
                        Number                                               PAON End
                                                                             Number
                                                                             99
   100113               PAON End         End dwelling number suffix          BS7666 v2.0                                     S           Suffix                                                    S             2006-01-31 100184
                        Number Suffix                                        PAON End
                                                                             Number Suffix
                                                                             A(1)
   100114               PAON             Dwelling name                       BS7666 v2.0                                     S           Description                                               S             2006-01-31 100185
                        Description                                          PAON
                                                                             Description
                                                                             A(90)
   100115 P77           Street           Street name or street               BS7666 v1.4                                     M           Street               May be missing for small communities S             2005-04-30 100186
                                         description that has been           Street                                                                           with no recognised street name
                                         allocated to a street by the        Descriptor
                                         street naming authority             A(100)
   100116 P78           Locality         The locality name refers to a       BS7666 v1.4                                     M           Locality             At least one of <Locality>, <Town>   S             2005-04-30 100187
                                         neighbourhood, suburb, district, Locality                                                                            and <AdministrativeArea> must be
                                         village, estate, settlement, or     A(35)                                                                            present
                                         parish that may form part of a
                                         town, or stand in its own right
                                         within the context of an
                                         administrative area. Where an
                                         industrial estate contains
                                         streets it is defined as a locality
                                         in its in own right.



   100117 P79           Town             The town name refers to a city    BS7666 v1.4                                       M           Town                 At least one of <Locality>, <Town>   S             2005-04-30 100188
                                         or town that is not an            Town                                                                               and <AdministrativeArea> must be
                                         administrative area, a suburb     A(30)                                                                              present
                                         of an administrative area that
                                         does not form part of another
                                         town or a London district

   100118 P80           Administrative   The administrative area is a      BS7666 v1.4                                       M           AdministrativeArea   At least one of <Locality>, <Town>   S             2005-04-30 100189
                        Area             geographic area that may be       Administrative                                                                     and <AdministrativeArea> must be
                                         the highest level local           Area                                                                               present
                                         administrative area, which may    A(30)
                                         be a county or a unitary
                                         authority, an island or island
                                         group or London.
   100119 P80a          Post town        Post Office usually assigns       BS7666 v1.4                                       M           PostTown                                                  S             2005-04-30 100190
                                         these based on Sorting Office     Post Town
                                                                           A(30)




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                Page 31 of 58                                                                             Date last updated: 3/4/2011
Identifier Identifier   Data Element    Description                    Business        Format.Values                      Format.   Format.     Format.XML_Tag             Format.Validation (CBDS not               Date.       Date.         Relation.
(New       (Old         Name                                           Format                                             Default   Multiples                              Census validation)                        Periodicity Created       Identifier
CBDS       CBDS                                                                                                                     (S, M)                                                                           (C,S,A,O,X)
Ref No)    Ref No)
Home Information
   100120 P81           Postcode        The code allocated by the Post BS7666 v1.4     Valid Postcode formats are:                  M           Postcode                   Double spaces should be converted         S              2004-12-01 100191
                                        Office to identify a group of  Postcode        A9 9AA                                                                              to a single space; convert any 'O' at
                                        postal delivery points         A(8)            A99 9AA                                                                             start of second postcode block to '0'
                                                                                       AA9 9AA                                                                             (zero).
                                                                                       AA99 9AA
                                                                                       A9A 9AA
                                                                                       AA9A 9AA
                                                                                       Plus BFPO 999

   100121 P81a          Postcode        The code allocated by the Post BS7666 v1.4     Valid Postcode formats are:                  M           PostCode                   Double spaces should be converted          S             2006-01-31 100192
                                        Office to identify a group of  Postcode        A9 9AA                                                                              to a single space; convert any 'O' at
                                        postal delivery points         A(8)            A99 9AA                                                                             start of second postcode block to '0'
                                                                                       AA9 9AA                                                                             (zero); Q, V and X are not used in the
                                                                                       AA99 9AA                                                                            first position; I, J and Z are not used in
                                                                                       A9A 9AA                                                                             the second position; only A, B, C, D,
                                                                                       AA9A 9AA                                                                            E, F, G, H, J, K, S, T, U and W appear
                                                                                       Plus BFPO 999                                                                       in the third position; only A, B, E, H, M,
                                                                                                                                                                           N, P, R, V, W, X and Y appear in the
                                                                                                                                                                           fourth position; the second half of the
                                                                                                                                                                           Postcode is always consistent
                                                                                                                                                                           numeric, alpha, alpha format and the
                                                                                                                                                                           letters C, I, K, M, O and V are never
                                                                                                                                                                           used.


   100122 P82           UPRN            A unique identifier for each   BS7666 v1.4     Positive integer minimum                     M           UPRN                                                                 O              2000-10-10 100193
                                        land and property unit.        Unique          length of 1 digit and maximum
                                                                       Property        length of 12 digits
                                                                       Reference
                                                                       Number
                                                                       999999999999

   100123 P82a          UPRN            A unique identifier for each   BS7666 v1.4     Positive integer minimum                     M           UniquePropertyReferenceN                                             O              2006-01-31 100194
                                        land and property unit.        Unique          length of 1 digit and maximum                            umber
                                                                       Property        length of 12 digits
                                                                       Reference
                                                                       Number
                                                                       999999999999

   100124 P83           Unique Street   A unique identifier for each   BS7666 v1.4     Positive integer in the range 1-             M           USRN                                                                 O              2000-10-10 100195
                        Reference       street                         Unique Street   999999999999
                        Number                                         Reference
                                                                       Number
                                                                       999999999999

   100125 P83a          Unique Street   A unique identifier for each   BS7666 v1.4     Positive integer in the range 1-             M           Unique Street Reference                                              O              2006-01-31 100196
                        Reference       street                         Unique Street   99999999                                                 Number
                        Number                                         Reference
                                                                       Number
                                                                       99999999




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                       Page 32 of 58                                                                                         Date last updated: 3/4/2011
Identifier Identifier   Data Element       Description                    Business         Format.Values                       Format.      Format.     Format.XML_Tag    Format.Validation (CBDS not   Date.       Date.        Relation.
(New       (Old         Name                                              Format                                               Default      Multiples                     Census validation)            Periodicity Created      Identifier
CBDS       CBDS                                                                                                                             (S, M)                                                      (C,S,A,O,X)
Ref No)    Ref No)
Home Information
   100126 P84           Property Easting  Easting coordinate for mapping 9999999                                                            M           Easting                                         O             2000-10-10 100197
                                          an address
   100127 P85           Property Northing Northing coordinate for        9999999                                                            M           Northing                                        O             2000-10-10 100198
                                          mapping an address
   100128 P182          Address Line 1    First Line of Address          Line Address      No validation. Included                          M           AddressLine1                                    S             2006-01-31 100199
                                                                         Format            temporarily to facilitate data
                                                                         A(35)             transfer pending BS7666
                                                                                           compliance.
   100129 P183          Address Line 2     Second Line of Address         Line Address     No validation. Included                          M           AddressLine2                                    S             2006-01-31 100200
                                                                          Format           temporarily to facilitate data
                                                                          A(35)            transfer pending BS7666
                                                                                           compliance.
   100130 P184          Address Line 3     Third Line of Address          Line Address     No validation. Included                          M           AddressLine3                                    S             2006-01-31 100201
                                                                          Format           temporarily to facilitate data
                                                                          A(35)            transfer pending BS7666
                                                                                           compliance.
   100131 P185          Address Line 4     Fourth Line of Address         Line Address     No validation. Included                          M           AddressLine4                                    S             2006-01-31 100202
                                                                          Format           temporarily to facilitate data
                                                                          A(35)            transfer pending BS7666
                                                                                           compliance.
   100132 P186          Address Line 5     Fifth Line of Address          Line Address     No validation. Included                          M           AddressLine5                                    S             2006-01-31 100203
                                                                          Format           temporarily to facilitate data
                                                                          A(35)            transfer pending BS7666
                                                                                           compliance.
   100133               International      First Line of International    BS7666                                                                        IntAddressLine1                                 S             2006-01-31 100204
                        Address Line 1     Address                        International
                                                                          Address Format
                                                                          A(35)

   100134               International      Second Line of International   BS7666                                                                        IntAddressLine2                                 S             2006-01-31 100205
                        Address Line 2     Address                        International
                                                                          Address Format
                                                                          A(35)

   100135               International      Third Line of International    BS7666                                                                        IntAddressLine3                                 S             2006-01-31 100206
                        Address Line 3     Address                        International
                                                                          Address Format
                                                                          A(35)

   100136               International      Fourth Line of International   BS7666                                                                        IntAddressLine4                                 S             2006-01-31 100207
                        Address Line 4     Address                        International
                                                                          Address Format
                                                                          A(35)

   100137               International      Fifth Line of International    BS7666                                                                        IntAddressLine5                                 S             2006-01-31 100208
                        Address Line 5     Address                        International
                                                                          Address Format
                                                                          A(35)




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                               Page 33 of 58                                                                   Date last updated: 3/4/2011
Identifier Identifier   Data Element       Description                       Business         Format.Values                Format.    Format.     Format.XML_Tag          Format.Validation (CBDS not   Date.       Date.        Relation.
(New       (Old         Name                                                 Format                                        Default    Multiples                           Census validation)            Periodicity Created      Identifier
CBDS       CBDS                                                                                                                       (S, M)                                                            (C,S,A,O,X)
Ref No)    Ref No)
Home Information
   100138               International Post Post Code of International        BS7666                                                               InternationalPostCode                                 S             2006-01-31 100210
                        Code               Address                           International
                                                                             Address Format
                                                                             A(35)

   100139               ISO 3166-1         3 digit alphabetic country code   A(3)             Nation states and                                   CountryCodeAlpha3                                     S             2006-01-31 100211
                        Alpha-3 Code                                                          countries (consistent with
                                                                                              GDSC requirement to use
                                                                                              BSEN 3166 (ISO 3166-1))
                                                                                              available at
                                                                                              http://www.teachernet.gov.
                                                                                              uk/management/ims/data
                                                                                              management/cbds/CBDSs
                                                                                              pecs/
   100140               ISO 3166-1         2 digit alphabetic country code   A(2)             Nation states and                                   CountryCodeAlpha2                                     S             2006-01-31 100212
                        Alpha-2 Code                                                          countries (consistent with
                                                                                              GDSC requirement to use
                                                                                              BSEN 3166 (ISO 3166-1))
                                                                                              available at
                                                                                              http://www.teachernet.gov.
                                                                                              uk/management/ims/data
                                                                                              management/cbds/CBDSs
                                                                                              pecs/
   100141               ISO 3166-1         3 digit numeric country code      999              Nation states and                                   CountryCodeNumeric3                                   S             2006-01-31 100213
                        Numeric-3 Code     999                                                countries (consistent with
                                                                                              GDSC requirement to use
                                                                                              BSEN 3166 (ISO 3166-1))
                                                                                              available at
                                                                                              http://www.teachernet.gov.
                                                                                              uk/management/ims/data
                                                                                              management/cbds/CBDSs
                                                                                              pecs/
   100142               ISO 3166-1         Short country name                A(35)            Nation states and                                   CountryCodeNameShort                                  S             2006-01-31 100215
                        Short Country                                                         countries (consistent with
                        Name                                                                  GDSC requirement to use
                                                                                              BSEN 3166 (ISO 3166-1))
                                                                                              available at
                                                                                              http://www.teachernet.gov.
                                                                                              uk/management/ims/data
                                                                                              management/cbds/CBDSs
                                                                                              pecs/




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                         Page 34 of 58                                                                         Date last updated: 3/4/2011
Identifier Identifier   Data Element     Description                  Business     Format.Values                      Format.     Format.     Format.XML_Tag     Format.Validation (CBDS not   Date.       Date.          Relation.
(New       (Old         Name                                          Format                                          Default     Multiples                      Census validation)            Periodicity Created        Identifier
CBDS       CBDS                                                                                                                   (S, M)                                                       (C,S,A,O,X)
Ref No)    Ref No)
Home Information
   100143               ISO 3166-1 Long Long country name             A(55)        Nation states and                                          CountryNameLong                                  S             2006-01-31 100216
                        Country Name                                               countries (consistent with
                                                                                   GDSC requirement to use
                                                                                   BSEN 3166 (ISO 3166-1))
                                                                                   available at
                                                                                   http://www.teachernet.gov.
                                                                                   uk/management/ims/data
                                                                                   management/cbds/CBDSs
                                                                                   pecs/
   100144 P96           Telephone Type   Type of phone for which       A(1)        PhoneType                                      M           PhoneType                                        O             2004-12-01 100217
                                         number is provided
   100145 P97           Telephone        Pupil's home telephone number A(35)       Valid characters are 0-9 and                   M           PhoneNo                                          O             2004-12-10 100218
                        Number                                                     a leading '+' (for international
                                                                                   numbers)
   100146               Start date at                                 CCYY-MM-DD   Any valid date                                 M           AddressStartDate                                 O             2006-01-31
                        address
   100147               End date at                                   CCYY-MM-DD   Any valid date                                 M           AddressEndDate                                   O             2006-01-31
                        address




     e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                     Page 35 of 58                                                                    Date last updated: 3/4/2011
Pupil Level: Home Info Module Codesets

PhoneType
F         Fax
H         Home
A         Alternate Home
M         Mobile
W         Work




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls   Page 36 of 58   Date last updated: 3/4/2011
7 Home Location Context
Identifier Identifier Data Element    Description                  Business   Format.Values                  Format.    Format.     Format.XML_Tag     Format.Validation (CBDS not              Date.       Date.          Relation.
(New       (Old       Name                                         Format                                    Default    Multiples                      Census validation)                       Periodicity Created        Identifier
CBDS       CBDS                                                                                                         (S, M)                                                                  (C,S,A,O,X)
Ref No)    Ref No)
Home Location Context
   100148 P86        Enumeration      National Population Census   99AAAA99                                             S           CensusDistrict                                              O             2000-10-10
                     district         Enumeration District

   100149 P87        LA Electoral     ONS Ward Code                99AAAA     http://www.statistics.gov.uk              S           WardCode           Must be equal to first 6 characters of   O             2006-01-31
                     Ward Code                                                /geography/geographic_ar                                                 <CensusDistrict>
                                                                              ea_listings/
   100150 P88        LA Electoral     ONS Ward Name                A(40)      http://www.statistics.gov.uk              S           Ward                                                        O             2006-02-01
                     Ward Name                                                /geography/geographic_ar
                                                                              ea_listings/
   100151 P89        Parliamentary    ONS Parliamentary            999        http://www.statistics.gov.uk              S           ConstituencyCode   001-529 England                          O             2000-10-10
                     Constituency     Constituency Code                       /geography/geographic_ar                                                 530-569 Wales
                     Code                                                     ea_listings/                                                             601-672 Scotland
                                                                                                                                                       701-718 Northern Ireland
   100152 P90        Parliamentary    ONS Parliamentary            A(40)      http://www.statistics.gov.uk              S           Constituency                                                O             2000-10-10
                     Constituency     Constituency Name                       /geography/geographic_ar
                     Name                                                     ea_listings/
   100153 P91        Parish Council   ONS Parish Council Name      A(40)      http://www.statistics.gov.uk              S           Parish                                                      O             2000-10-10
                                                                              /geography/geographic_ar
                                                                              ea_listings/
   100154 P92        Church of        Church Dioceses - CofE       A(3)       Church dioceses available                 S           CofEdiocese                                                 O             2000-10-10
                     England                                                  at
                     Diocese                                                  http://www.teachernet.gov.
                                                                              uk/management/ims/data
                                                                              management/cbds/CBDSs
                                                                              pecs/
   100155 P93        Church of        Church Parish - CofE         A(50)                                                S           CofEparish         No validation                            O             2000-10-10
                     England Parish

   100156 P94        Roman Catholic Church Dioceses - RC           A(3)       Church dioceses available                 S           RCdiocese                                                   O             2000-10-10
                     Diocese                                                  at
                                                                              http://www.teachernet.gov.
                                                                              uk/management/ims/data
                                                                              management/cbds/CBDSs
                                                                              pecs/
   100157 P95        Roman Catholic Church Parish - RC             A(50)                                                S           RCparish           No validation                            O             2000-10-10
                     Parish

   100158 P95a       Learning &       LSC Area code                A(3)       LSC Area list available at                S           LSCcode                                                     A             2004-05-31
                     Skills Council                                           http://www.teachernet.gov.
                     Code                                                     uk/management/ims/data
                                                                              management/cbds/CBDSs
                                                                              pecs/
   100159            Catchment area Text describing school         A(3000)                                              S           CatchmentArea      No validation                            O             2006-01-31
                                      catchment area




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                            Page 37 of 58                                                                               Date last updated: 3/4/2011
8 Contact Information
Identifier Identifier   Data Element        Description                        Business   Format.Values                   Format.     Format.     Format.XML_Tag   Format.Validation (CBDS not              Date.       Date.          Relation.
(New        (Old        Name                                                   Format                                     Default     Multiples                    Census validation)                       Periodicity Created        Identifier
CBDS        CBDS                                                                                                                      (S, M)                                                                (C,S,A,O,X)
Ref No)     Ref No)
Contact Information
   100160 P98           Contact Priority    Priority order in which to call    99         1-10                                        M           Order                                                     C             2005-04-30
                                            contact names provided                        2 or more contacts may
                                                                                          have equal priority order
   100161 P99           Contact Title       Title of contact                   A(35)      If any of: Mr, Mrs, Ms, Miss,               M           Title                                                     C             2006-01-31
                                                                                          Rev, Fr, Dr, Prof, Hon, Sir,
                                                                                          Lord, Lady, must be as
                                                                                          shown, otherwise free text.

   100162 P100          Contact Last        Surname of contact                 A(35)      Any character string                        M           Surname                                                   C             2000-10-10 100003,
                        Name                                                                                                                                                                                                         100009,
                                                                                                                                                                                                                                     100011
   100163 P101          Contact First       First name of contact              A(35)      Any character string                        M           Forename                                                  C             2000-10-10 100004,
                        Name                                                                                                                                                                                                         100010
   100164 P102          Contact Middle      Middle name of contact             A(35)      Any character string                        M           MiddleNames      Components should be separated by        O             2000-10-10 100006
                        Name                                                                                                                                       a single space
   100165 P103          Contact Gender      Gender of contact                  A(1)       M or F for Male and Female                  M           Gender                                                    C             2000-10-10 100008

   100166 P104          Contact             Relationship of pupil to contact   A(3)       Relationship                                M           Relationship     There must be a pupil Contact record     C             2006-01-31
                        Relationship to     (Carer is defined in the DfES                                                                                          for the Social Worker if <InCare> =
                        Pupil               SEN glossary)                                                                                                          true

   100167 P104a         Contact             Does the contact have              A(5)       1,0 or true, false                          M           Responsibility                                            C             2000-10-10
                        Responsibility to   responsibility for pupil?
                        Pupil               (Parent' and 'parental
                                            responsibility' are defined in the
                                            Guidance on Schools,
                                            “Parents” and “Parental
                                            Responsibility”)
   100168 P105          Contact Member Is the contact a member of the          A(5)       1,0 or true, false                          M           ArmedForces      Must not be blank if <Relationship> =    O             2000-10-10
                        of Armed Forces armed forces?                                                                                                              P?? (ie parent)
                        Indicator                                                                                                                                  Must be blank if <Relationship> is not
                                                                                                                                                                   = P?? (ie non-parent)
   100169 P106          Contact             Does the contact need a            A(5)       1,0 or true, false                          M           Translator       Must not be blank if <Relationship> =    O             2000-10-10
                        Translator or       translator or interpreter?                                                                                             P?? or CAR
                        Interpreter
                        Indicator
   100170 P107          Contact             Contact's language                 A(4)       Language code list                          M           Language         Must not be blank if <Translator>        O             2000-10-10
                        Language Code                                                                                                                              =Y

   100171 P107a         Contact             Contact's language                 A(4)       Language code list available                M           Language         Must not be blank if <Translator>        O             2006-01-31 100047,
                        Language Code       (incorporating First                          at                                                                       =Y                                                                100171
                                            Language (P50) code set)                      http://www.teachernet.gov.uk
                                                                                          /management/ims/datamana
                                                                                          gement/cbds/CBDSspecs/




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                          Page 38 of 58                                                                             Date last updated: 3/4/2011
Identifier Identifier   Data Element      Description                        Business        Format.Values                Format.       Format.     Format.XML_Tag   Format.Validation (CBDS not   Date.       Date.          Relation.
(New        (Old        Name                                                 Format                                       Default       Multiples                    Census validation)            Periodicity Created        Identifier
CBDS        CBDS                                                                                                                        (S, M)                                                     (C,S,A,O,X)
Ref No)     Ref No)
Contact Information
   100172 P108          Contact Email     Contact's email address            A(254)          string1@string2                            M           Email                                          O             2000-10-10
                        Address                                                              string1 and string2 may
                                                                                             include any characters
                                                                                             except @
   100173               Contact Address   Indicates whether address          A1              C - current address, M -                   M           AddressType                                    S             2006-01-31
                        Type              given is contact's current                         mailing address
                                          address or address for mail
                                          only
   100174 P109          Sub-dwelling      Contact's address: Flat,           BS7666 v1.4                                                M           SAON                                           S             2000-10-10 100103
                                          apartment name or number or        Secondary
                                          other sub-division of a dwelling   Addressable
                                                                             Object Name
                                                                             A(100)
   100175               SAON Start        Start (single) dwelling number     BS7666 v2.0                                                S           Number                                         S             2006-01-31 100104
                        Number                                               SAON Start
                                                                             Number
                                                                             9999
   100176               SAON Start        Start (single) dwelling number     BS7666 v2.0                                                S           Suffix                                         S             2006-01-31 100105
                        Number Suffix     suffix                             SAON Start
                                                                             Number suffix
                                                                             A(1)
   100177               SAON End          End dwelling number                BS7666 v2.0                                                S           Number                                         S             2006-01-31 100106
                        Number                                               SAON End
                                                                             Number
                                                                             9999
   100178               SAON End          End dwelling number suffix         BS7666 v2.0                                                S           Suffix                                         S             2006-01-31 100107
                        Number Suffix                                        SAON End
                                                                             Number Suffix
                                                                             A(1)
   100179               SAON              Dwelling name                      BS7666 v2.0                                                S           Description                                    S             2006-01-31 100108
                        Description                                          SAON
                                                                             Description
                                                                             A(90)
   100180 P110          Dwelling          Contact's address: Dwelling        BS7666 v1.4                                                M           PAON                                           S             2000-10-10 100109
                                          name and/or number                 Primary
                                                                             Addressable
                                                                             Object Name
                                                                             A(100)
   100181               PAON Start        Start (single) dwelling number     BS7666 v2.0                                                S           Number                                         S             2006-01-31 100110
                        Number                                               PAON Start
                                                                             Number
                                                                             9999
   100182               PAON Start        Start (single) dwelling number     BS7666v2.0                                                 S           Suffix                                         S             2006-01-31 100111
                        Number Suffix     suffix                             PAON Start
                                                                             Number Suffix
                                                                             A(1)
   100183               PAON End          End dwelling number                BS7666v2.0                                                 S           Number                                         S             2006-01-31 100112
                        Number                                               PAON End
                                                                             Number
                                                                             9999




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                            Page 39 of 58                                                                  Date last updated: 3/4/2011
Identifier Identifier   Data Element     Description                       Business         Format.Values     Format.       Format.     Format.XML_Tag       Format.Validation (CBDS not             Date.       Date.        Relation.
(New        (Old        Name                                               Format                             Default       Multiples                        Census validation)                      Periodicity Created      Identifier
CBDS        CBDS                                                                                                            (S, M)                                                                   (C,S,A,O,X)
Ref No)     Ref No)
Contact Information
   100184               PAON End         End dwelling number suffix        BS7666 v2.0                                      S           Suffix                                                       S             2006-01-31 100113
                        Number Suffix                                      PAON End
                                                                           Number Suffix
                                                                           A(1)
   100185               PAON             Dwelling name                     BS7666 v2.0                                      S           Description                                                  S             2006-01-31 100114
                        Description                                        PAON
                                                                           Description
                                                                           A(90)
   100186 P111          Street           Contact's address: Street         BS7666 v1.4                                      M           Street                                                       S             2000-10-10 100115
                                         name or street description that   Street
                                         has been allocated to a street    Descriptor
                                         by the street naming authority    A(100)

   100187 P112          Locality         Contact's address: The        BS7666 v1.4                                          M           Locality                                                     S             2006-01-31 100116
                                         locality name refers to a     Locality
                                         neighbourhood, suburb,        A(35)
                                         district, village, estate,
                                         settlement, or parish that
                                         may form part of a town, or
                                         stand in its own right within
                                         the context of an
                                         administrative area. Where
                                         an industrial estate contains
                                         streets it is defined as a
                                         locality in its in own right.

   100188 P113          Town             Contact's address: The town       BS7666 v1.4                                      M           Town                                                         S             2006-01-31 100117
                                         name refers to a city or town     Town
                                         that is not an administrative     A(30)
                                         area, a suburb of an
                                         administrative area that does
                                         not form part of another town
                                         or a London district

   100189 P114          Administrative   Contact's address: The            BS7666 v1.4                                      M           AdministrativeArea                                           S             2006-01-31 100118
                        Area             administrative area is a          Administrative
                                         geographic area that may be       Area
                                         the highest level local           A(30)
                                         administrative area, which may
                                         be a county or a unitary
                                         authority, an island or island
                                         group or London.
   100190 P114a         Post Town        Contact's address: Post Office BS7666 v1.4                                         M           PostTown                                                     S             2000-10-10 100119
                                         usually assigns these based on Post Town
                                         Sorting Office                 A(30)

   100191 P115          Postcode         Contact's address: The code       BS7666 v1.4                                      M           Postcode             Double spaces should be converted       S             2000-10-10 100120
                                         allocated by the Post Office to   Postcode                                                                          to a single space; convert any 'O' at
                                         identify a group of postal        A(8)                                                                              start of second postcode block to '0'
                                         delivery points                                                                                                     (zero).




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                Page 40 of 58                                                                                Date last updated: 3/4/2011
Identifier Identifier   Data Element        Description                       Business        Format.Values                     Format.       Format.     Format.XML_Tag             Format.Validation (CBDS not               Date.       Date.         Relation.
(New        (Old        Name                                                  Format                                            Default       Multiples                              Census validation)                        Periodicity Created       Identifier
CBDS        CBDS                                                                                                                              (S, M)                                                                           (C,S,A,O,X)
Ref No)     Ref No)
Contact Information
   100192 P115a         Postcode            Contact's address: The code       BS7666 v1.4                                                     M           PostCode                   Double spaces should be converted          S             2006-01-31 100121
                                            allocated by the Post Office to   Postcode                                                                                               to a single space; convert any 'O' at
                                            identify a group of postal        A(8)                                                                                                   start of second postcode block to '0'
                                            delivery points                                                                                                                          (zero); Q, V and X are not used in the
                                                                                                                                                                                     first position; I, J and Z are not used in
                                                                                                                                                                                     the second position; only A, B, C, D,
                                                                                                                                                                                     E, F, G, H, J, K, S, T, U and W appear
                                                                                                                                                                                     in the third position; only A, B, E, H, M,
                                                                                                                                                                                     N, P, R, V, W, X and Y appear in the
                                                                                                                                                                                     fourth position; the second half of the
                                                                                                                                                                                     Postcode is always consistent
                                                                                                                                                                                     numeric, alpha, alpha format and the
                                                                                                                                                                                     letters C, I, K, M, O and V are never
                                                                                                                                                                                     used.


   100193 P116          Unique Property                                       BS7666 v1.4     Positive integer minimum                        M           UPRN                                                                 O              2000-10-10 100122
                        Reference                                             UPRN            length of 1 digit and
                        number                                                999999999       maximum length of 9 digits

   100194 P116a         UPRN                A unique identifier for each      BS7666 v1.4     Positive integer minimum                        M           UniquePropertyReferenceN                                             O              2006-01-31 100123
                                            land and property unit.           Unique          length of 1 digit and                                       umber
                                                                              Property        maximum length of 12 digits
                                                                              Reference
                                                                              Number
                                                                              999999999999

   100195 P117          Unique Street                                         99999999        Positive integer in the range                   M           USRN                                                                 O              2000-10-10 100124
                        Reference                                                             1- 999999999999
                        Number
   100196 P117a         Unique Street       A unique identifier for each      BS7666 v1.4     Positive integer in the range                   M           Unique Street Reference                                              O              2006-01-31 100125
                        Reference           street                            Unique Street   1- 99999999                                                 Number
                        Number                                                Reference
                                                                              Number
                                                                              99999999
   100197 P118          Property Easting                                      9999999                                                         M           Easting                                                              O              2000-10-10 100126

   100198 P119          Property Northing                                     9999999                                                         M           Northing                                                             O              2000-10-10 100127

   100199 P187          Address Line 1      First Line of Contact's Address Line Address      No validation. Included                         M           AddressLine1                                                         S              2006-01-31 100128
                                                                            Format            temporarily to facilitate dta
                                                                            A(35)             transfer pending BS7666
                                                                                              compliance.
   100200 P188          Address Line 2      Second Line of Contact's          Line Address    No validation. Included                         M           AddressLine2                                                         S              2006-01-31 100129
                                            Address                           Format          temporarily to facilitate dta
                                                                              A(35)           transfer pending BS7666
                                                                                              compliance.
   100201 P189          Address Line 3      Third Line of Contact's Address Line Address      No validation. Included                         M           AddressLine3                                                         S              2006-01-31 100130
                                                                            Format            temporarily to facilitate dta
                                                                            A(35)             transfer pending BS7666
                                                                                              compliance.




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                                  Page 41 of 58                                                                                         Date last updated: 3/4/2011
Identifier Identifier   Data Element       Description                       Business         Format.Values                     Format.       Format.     Format.XML_Tag          Format.Validation (CBDS not   Date.       Date.        Relation.
(New        (Old        Name                                                 Format                                             Default       Multiples                           Census validation)            Periodicity Created      Identifier
CBDS        CBDS                                                                                                                              (S, M)                                                            (C,S,A,O,X)
Ref No)     Ref No)
Contact Information
   100202 P190          Address Line 4     Fourth Line of Contact's          Line Address     No validation. Included                         M           AddressLine4                                          S             2006-01-31 100131
                                           Address                           Format           temporarily to facilitate dta
                                                                             A(35)            transfer pending BS7666
                                                                                              compliance.
   100203 P191          Address Line 5     Fifth Line of Contact's Address Line Address       No validation. Included                         M           AddressLine5                                          S             2006-01-31 100132
                                                                           Format             temporarily to facilitate dta
                                                                           A(35)              transfer pending BS7666
                                                                                              compliance.
   100204               International      First Line of International       BS7666                                                                       IntAddressLine1                                       S             2006-01-31 100133
                        Address Line 1     Address                           International
                                                                             Address Format
                                                                             A(35)

   100205               International      Second Line of International      BS7666                                                                       IntAddressLine2                                       S             2006-01-31 100134
                        Address Line 2     Address                           International
                                                                             Address Format
                                                                             A(35)

   100206               International      Third Line of International       BS7666                                                                       IntAddressLine3                                       S             2006-01-31 100135
                        Address Line 3     Address                           International
                                                                             Address Format
                                                                             A(35)

   100207               International      Fourth Line of International      BS7666                                                                       IntAddressLine4                                       S             2006-01-31 100136
                        Address Line 4     Address                           International
                                                                             Address Format
                                                                             A(35)

   100208               International      Fifth Line of International       BS7666                                                                       IntAddressLine5                                       S             2006-01-31 100137
                        Address Line 5     Address                           International
                                                                             Address Format
                                                                             A(35)

   100209 P192          Zip Code           International Post Code           A(20)                                                            M           Zip                                                   S             2005-04-30
   100210 P192a         International Post Post Code of International        BS7666                                                                       InternationalPostCode                                 S             2006-01-31 100138
                        Code               Address                           International
                                                                             Address Format
                                                                             A(35)

   100211               ISO 3166-1         3 digit alphabetic country code   A(3)             Nation states and countries                                 CountryCodeAlpha3                                     S             2006-01-31 100139
                        Alpha-3 Code                                                          (consistent with GDSC
                                                                                              requirement to use BSEN
                                                                                              3166 (ISO 3166-1))
                                                                                              available at
                                                                                              http://www.teachernet.gov.uk
                                                                                              /management/ims/datamana
                                                                                              gement/cbds/CBDSspecs/




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                                  Page 42 of 58                                                                         Date last updated: 3/4/2011
Identifier Identifier   Data Element     Description                       Business   Format.Values                  Format.    Format.     Format.XML_Tag         Format.Validation (CBDS not           Date.       Date.          Relation.
(New        (Old        Name                                               Format                                    Default    Multiples                          Census validation)                    Periodicity Created        Identifier
CBDS        CBDS                                                                                                                (S, M)                                                                   (C,S,A,O,X)
Ref No)     Ref No)
Contact Information
   100212               ISO 3166-1       2 digit alphabetic country code   A(2)       Nation states and countries                           CountryCodeAlpha2                                            S             2006-01-31 100140
                        Alpha-2 Code                                                  (consistent with GDSC
                                                                                      requirement to use BSEN
                                                                                      3166 (ISO 3166-1))
                                                                                      available at
                                                                                      http://www.teachernet.gov.uk
                                                                                      /management/ims/datamana
                                                                                      gement/cbds/CBDSspecs/

   100213               ISO 3166-1       3 digit numeric country code      999        Nation states and countries                           CountryCodeNumeric3                                          S             2006-01-31 100141
                        Numeric-3 Code   999                                          (consistent with GDSC
                                                                                      requirement to use BSEN
                                                                                      3166 (ISO 3166-1))
                                                                                      available at
                                                                                      http://www.teachernet.gov.uk
                                                                                      /docbank/index.cfm?id=8893

   100214 P193          Country Name     Country Name                      A(30)      Nation states and                                     Country                                                      S             2005-04-30
                                                                                      countries (consistent with
                                                                                      GDSC requirement to
                                                                                      use BSEN 3166 (ISO
                                                                                      3166-1)) available at
                                                                                      http://www.teachernet.gov
                                                                                      .uk/management/ims/data
                                                                                      management/cbds/CBDS
                                                                                      specs/
   100215               ISO 3166-1       Short country name                A(35)      Nation states and countries                           CountryCodeNameShort                                         S             2006-01-31 100142
                        Short Country                                                 (consistent with GDSC
                        Name                                                          requirement to use BSEN
                                                                                      3166 (ISO 3166-1))
                                                                                      available at
                                                                                      http://www.teachernet.gov.uk
                                                                                      /management/ims/datamana
                                                                                      gement/cbds/CBDSspecs/

   100216               ISO 3166-1 Long Long country name                  A(55)      Nation states and countries                           CountryNameLong                                              S             2006-01-31 100143
                        Country Name                                                  (consistent with GDSC
                                                                                      requirement to use BSEN
                                                                                      3166 (ISO 3166-1))
                                                                                      available at
                                                                                      http://www.teachernet.gov.uk
                                                                                      /management/ims/datamana
                                                                                      gement/cbds/CBDSspecs/

   100217 P120          Contact          Type of phone for which           A(1)       PhoneType (see Home Info                  M           PhoneType              Cannot be blank if <Relationship> =   S             2000-10-10 100144
                        Telephone Type   number is provided                           Codesets)                                                                    SWR
   100218 P121          Contact          Contact's home telephone          A(35)      Valid characters are 0-9 and              M           PhoneNo                Cannot be blank if <Relationship> =   S             2004-12-01 100145
                        Telephone        number                                       a leading '+' (for                                                           SWR
                        Number                                                        international numbers)
   100219               Day location     Day location of contact eg        A(1)       H = Home, W = Work                        S           DayLocation                                                  O             2006-01-31
                                         home or work




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                    Page 43 of 58                                                                                Date last updated: 3/4/2011
Identifier Identifier   Data Element        Description                      Business   Format.Values               Format.       Format.     Format.XML_Tag             Format.Validation (CBDS not   Date.       Date.          Relation.
(New        (Old        Name                                                 Format                                 Default       Multiples                              Census validation)            Periodicity Created        Identifier
CBDS        CBDS                                                                                                                  (S, M)                                                               (C,S,A,O,X)
Ref No)     Ref No)
Contact Information
   100220               Preference for      Indicates whether contact        A(1)       E=email, M=Mail                           S           WrittenCommunicationPref                                 O             2006-01-31
                        written             prefers written communication                                                                     erence
                        communication       to be by email or mail
                        indicator
   100221               Contact priority    Records who gave the priority    A(1)       Contact Priority Source                   S           ContactPrioritySource                                    O             2006-01-31 100023,
                        source              for contacts eg parents                                                                                                                                                             100025,
                                                                                                                                                                                                                                100058
   100222               Child is resident                                    A(5)       1,0 or true, false                        M           ContactResident                                          O             2006-01-31
                        with contact
                        indicator

   100223               Address can be      Some parents do not wish the     A(5)       1,0 or true, false                        S           AddressDisclosure                                        O             2006-01-31
                        disclosed           address to be disclosed to a
                        indicator           former partner
   100224               Contact address     Set to N if there is a concern   A(5)       1,0 or true, false                        S           ContactAddressTransfer                                   O             2006-01-31
                        should be           about the contact address
                        transferred with
                        pupil indicator




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                      Page 44 of 58                                                                            Date last updated: 3/4/2011
Pupil Level: Contact Information Module Codesets

Relationship
CAR        Carer
CHM        Childminder
DOC        Doctor
FAM        Other family member
OTH        Other Contact
PAM        Mother
PAF        Father
STP        Step Parent
FOS        Foster Parent
REL        Other Relative
SWR        Social Worker
RLG        Religious/Spiritual Contact



Contact Priority Source
C          Provided by the child (ie pupil)
P          Provided by the parent
S          Ascribed by the current school
T          Ascribed by a previous school
O          Other




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls      Page 45 of 58   Date last updated: 3/4/2011
9 Attendance
Identifier   Identifier   Data Element       Description                       Business     Format.Values               Format.      Format.     Format.XML_Tag         Format.Validation (CBDS not           Date.       Date.          Relation.
(New         (Old         Name                                                 Format                                   Default      Multiples                          Census validation)                    Periodicity Created        Identifier
CBDS         CBDS                                                                                                                    (S, M)                                                                   (C,S,A,O,X)
Ref No)      Ref No)
Attendance
   100225 P122            Attendance Year Year at the start of the             CCYY                                                  S           Year                                                         S             2000-10-10
                                            academic year
   100226 P124a           Attendance        Term start date                    CCYY-MM-DD   Any valid date                           M           AttendanceStartDate                                          A             2004-05-31
                          period start date

   100227 P124b           Attendance         Term end date                     CCYY-MM-DD   Any valid date                           M           AttendanceEndDate                                            A             2004-05-31
                          period end date
   100228 P125            Possible           Number possible sessions       999             0-400                                    M           SessionsPossible       For termly attendance,                S             2005-04-30
                          Sessions           during reporting period. There                                                                                             <SessionsPossible> should be less
                                             are 2 sessions for each school                                                                                             than 151
                                             day (morning and afternoon).                                                                                               The total of <SessionsAuthorised>
                                                                                                                                                                        plus <SessionsUnauthorised> must
                                                                                                                                                                        be less than or equal to
                                                                                                                                                                        <SessionsPossible>

   100229 P126            Sessions           Number of sessions                999          0-400                                    M           SessionsAttended                                             S             2004-12-01
                          Attended           attended
   100230 P126a           Sessions missed    Authorised absence is absence 999              0-400                                    M           SessionsAuthorised     <SessionsAuthorised> must be less     S             2005-04-30
                          due to             which has been authorised by                                                                                               than or equal to <SessionsPossible>
                          Authorised         a teacher or other authorised
                          Absence            representative of the school.

   100231 P127            Sessions missed    Unauthorised absence is          999           0-400                                    M           SessionsUnauthorised   <SessionsUnauthorised> must be        S             2005-04-30
                          due to             absence without leave from a                                                                                               less than or equal to
                          Unauthorised       teacher or other authorised                                                                                                <SessionsPossible>
                          Absence            representative of the school.
                                             This includes all unexplained or
                                             unjustified absences

   100232 P197            Attendance         Pupil level morning and       A(1)             Pupil Attendance Codes                   M           AttendanceReason                                             O             2006-01-31
                          codes              afternoon registration marks.
                                             New attendance codes
                                             effective from September 2006
                                             (England)
   100233 P198            Number of          Number of sessions missed for 999                                                       M           AbsenceSessions                                              C             2006-01-31
                          sessions missed    specified reason

   100234                 Alternative tuition Indicates whether pupil          A(5)         1,0 or true, false                       M                                                                        C             2006-01-31
                          indicator           receives alternative tuition
   100235                 Alternative tuition Reason for alternative tuition   A(2)         TuitionCategory                          M           TuitionCategory        Must not be blank if 100188 is true   O             2006-01-31
                          category
   100236                 Alternative tuition                                  CCYY-MM-DD                                            M                                  Must not be blank if 100188 is true   O             2006-01-31
                          start date
   100237                 Alternative tuition                                  CCYY-MM-DD                                            M                                                                        O             2006-01-31
                          end date




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                         Page 46 of 58                                                                                Date last updated: 3/4/2011
Identifier   Identifier   Data Element      Description                   Business   Format.Values      Format.      Format.     Format.XML_Tag   Format.Validation (CBDS not           Date.       Date.           Relation.
(New         (Old         Name                                            Format                        Default      Multiples                    Census validation)                    Periodicity Created         Identifier
CBDS         CBDS                                                                                                    (S, M)                                                             (C,S,A,O,X)
Ref No)      Ref No)
Attendance
   100238                 Number of hours Number of hours alternative     99         TuitionHours                    M           Hours            Number of whole hours. 0-29 minutes O                2006-01-31
                          alternative tuition tuition attended per week                                                                           to be rounded down and 30-59
                          attended per                                                                                                            minutes to be rounded up. Range = 1-
                          week                                                                                                                    99. Must not be blank if 100188 is true.




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                         Page 47 of 58                                                                           Date last updated: 3/4/2011
Pupil Level: Attendance Module Codesets
Pupil Attendance Codes                                                                     TuitionCategory
CODE DESCRIPTION                                                                           IL             Alternative Tuition by LA because of Illness
/    Present (AM)                                                                                         Alternative Tuition by LA because of Permanent
                                                                                           PE             Exclusion
\     Present (PM)                                                                         OR             Alternative Tuition by LA for Other Reason
L     Late (before registers closed) marked as present                                     HP             Alternative Tuition at Home by Parents/Carers
I     Authorised absence due to Illness (NOT medical or dental etc.
      appointments)
M                                                                                          TuitionHours
      Authorised absence due to medical/ dental appointments
R     Authorised absence due to religious observance                                       A              5 hours or less
S     Authorised absence due to study leave                                                B              6-12 hours
T
      Authorised absence due to traveller absence                                          C              13-19 hours
H     Authorised absence due to agreed family holiday                                      D              20 hours or more
F                        due to agreed extended family holiday
      Authorised absence as pupil is excluded, with no alternative provision
E     made
      Authorised absence as pupil is absent due to other authorised
C     circumstances
B     Approved education activity as pupil being educated off site (not dual
      registration)
D     Approved education activity as pupil is dual registered (i.e. attending
      another establishment)
J     Approved education activity as pupil is attending interview
P     Approved education activity as pupil is attending an approved
      sporting activity
V     Approved education activity as pupil is away on an educational visit
      or trip
W     Approved education activity as pupil is attending work experience
G     Unauthorised absence as pupil is on a family holiday, not agreed, or
      is taking days in excess of an agreed family holiday
U
      Unauthorised absence as pupil arrived after regsiters closed
O     Unauthorised absence as pupil missed sessions for an unauthorised
      absence not covered by any other code/description a reason that
      Unauthorised absence as pupil missed sessions for
N     has not yet been provided
X     Non-compulsory school age absence - not counted in possible
      attendances
Y     Enforced closure - not counted in possible attendances
Z     Pupil not yet on roll - not counted in possible attendances
#     School closed to pupils - not counted in possible attendances




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                        Page 48 of 58                                                        Date last updated: 3/4/2011
10 Previous School History
Identifier Identifier Data Element    Description                       Business     Format.Values                Format.    Format.     Format.XML_Tag   Format.Validation (CBDS not           Date.       Date.           Relation.
(New       (Old         Name                                            Format                                    Default    Multiples                    Census validation)                    Periodicity Created         Identifier
CBDS       CBDS                                                                                                              (S, M)                                                             (C,S,A,O,X)
Ref No)    Ref No)
Previous School History
   100239 P128       Previous         LA number for school which        A(3)         LEA list available at                   M           LEA                                                    S              2006-01-31 100013,
                     School LA        pupil attended prior to current                http://www.teachernet.gov.                                                                                                           100032,
                     number           school                                         uk/management/ims/data                                                                                                               100043,
                                                                                     management/cbds/CBDSs                                                                                                                100061,
                                                                                                                                                                                                                          100261
                                                                                     pecs/
   100240 P129       Previous         DfES Establishment number       A(4)           Establishment list - This               M           Estab            0001-0900 Secure Units &               S             2006-01-31 100014,
                     School DfES      for school which pupil attended                file is too large to be                                              Miscellaneous; 0940-0949 Playing for                            100062,
                     Establishment    prior to current school                        offered as a download;                                               Success Centres; 1000-1099 LA                                   100260
                     Number                                                                                                                               Nursery Schools; 1100-1149 Pupil
                                                                                     please request a copy by
                                                                                                                                                          Referral Unit; 1800-1999
                                                                                     email from
                                                                                                                                                          Miscellaneous; 2000-3999 Maintained
                                                                                     ChangeControl.CBDS@df                                                Primary (inc Middle deemed Primary);
                                                                                     es.gsi.gov.uk.                                                       4000-4899 Maintained Secondary (inc
                                                                                                                                                          Middle Deemed Secondary); 4900-
                                                                                                                                                          4999 Sixth Form Centres; 5200-5299
                                                                                                                                                          Maintained Primary (Ex GM - inc
                                                                                                                                                          Middle deemed Primary); 5400-5499
                                                                                                                                                          Maintained Secondary (Ex GM - inc
                                                                                                                                                          Middle deemed Secondary); 5900-
                                                                                                                                                          5949 Mixed Maintained Primary and
                                                                                                                                                          Secondary; 5950-5999 Foundation
                                                                                                                                                          Special (Ex GM); 6000-6599
                                                                                                                                                          Independent Schools (inc Special and
                                                                                                                                                          Approved for SEN); 6900-6904 City
                                                                                                                                                          Technology Colleges; 6905-6924
                                                                                                                                                          Academies; 7000-7751 Special
                                                                                                                                                          Schools; 7500-7511 Non-maintained
                                                                                                                                                          and Community Special Schools;
                                                                                                                                                          7748-7754 Community Special
                                                                                                                                                          Schools; 7900-7901 Special Colleges;
                                                                                                                                                          8000-8799 Further Education (inc
                                                                                                                                                          Sixth Form Colleges, incl. 8713 for
                                                                                                                                                          Nottingham Trent University); 9455
                                                                                                                                                          Lea House Hospital; 9500-9910
                                                                                                                                                          Miscellaneous (inc Secure Units, incl.
                                                                                                                                                          9565 for Blaby Community Home)




   100241 P131       Previous         Name of school which pupil       A(100)        Any character string                    M           SchoolName       Must not be blank if <Estab> = XXXX   S              2005-04-30
                     School Name      attended prior to current school

   100242 P133       Previous         Date which pupil started at       CCYY-MM-DD   Any valid date                          M           EntryDate                                              S              2005-04-30
                     School Date of   school prior to current school
                     Entry
   100243 P134       Previous         Data which pupil left school CCYY-MM-DD        Any valid date                          M           LeavingDate                                            S              2005-04-30
                     School Date of   prior to current school
                     Leaving




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                 Page 49 of 58                                                                           Date last updated: 3/4/2011
Identifier Identifier Data Element   Description                    Business   Format.Values          Format.       Format.     Format.XML_Tag   Format.Validation (CBDS not   Date.       Date.          Relation.
(New       (Old         Name                                        Format                            Default       Multiples                    Census validation)            Periodicity Created        Identifier
CBDS       CBDS                                                                                                     (S, M)                                                     (C,S,A,O,X)
Ref No)    Ref No)
Previous School History
   100244 P134a      Pupil Reason    Reason why pupil left school   A(2)       LeavingReason                        M           LeavingReason                                  S             2006-01-31
                     for Leaving     prior to current school

   100245 P134b      Last School     Indicates whether this school   A(5)      1,0 or true, false                   S           LastSchool                                     S             2003-08-31
                                     was the last one before current
                                     school




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                        Page 50 of 58                                                                  Date last updated: 3/4/2011
Pupil Level: Previous School History Module Codesets
LeavingReason
DD              Deceased
EO              Education other than at school/college
EM              Emigration
FE              Further Education (Leaver)
FM              First to Middle Phase Transfer
HE              Higher Education (Leaver)
NI              Nursery to Infant
IJ              Infant to Junior/Primary Phase Transfer
JS              Junior/Primary to Secondary Phase Transfer
MS              Middle to Secondary Phase Transfer
OS              Other School Sixth Form (Leaver)
OT              Other/Unknown
PE              Permanent Exclusion
ST              School Transfer (Mid-Year)
TR              Training (Leaver)
UN              Unemployment (Leaver)
WK              Employment (Leaver)




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                     Page 51 of 58   Date last updated: 3/4/2011
11 Post 16 Courses
Identifier Identifier   Data Element      Description                        Business   Format.Values            Format.       Format.     Format.XML_Tag   Format.Validation (CBDS not      Date.       Date.           Relation.
(New       (Old         Name                                                 Format                              Default       Multiples                    Census validation)               Periodicity Created         Identifier
CBDS       CBDS                                                                                                                (S, M)                                                        (C,S,A,O,X)
Ref No)    Ref No)
Post 16 Courses
   100246 P135          Post Advanced     Indicates whether a pupil is   A(5)           1,0 or true, false                     S           AdvancedCourse   <AdvancedCourse> must be false if S             2005-04-30
                        Level Indicator   taking a post advanced level                                                                                      <Alevels> is greater than 0 or
                                          course or not. A post advanced                                                                                    <GNVQs> = 3 or <PreGNVQs> = 3 or
                                          level course is any course                                                                                        <NVQs> = 3 or <Other> = B
                                          taken by a pupil who has
                                          completed GCE A Levels, an
                                          advanced GNVA or GNVQ
                                          precursor or a NVQ Level 3
                                          and is no longer studying at
                                          that level.
   100247 P136          Number of GCE     This includes AS (Advanced         9          0-9                                    S           Alevels                                           S              2005-04-30
                        A Level           Subsidiary), A2 and linear A
                        subjects being    Levels, but excludes General
                        studied           Studies and Vocational
                                          Certificates of Education
                                          (VCEs), sometimes known as
                                          Vocational A Levels.

   100248 P136a         Number of GCE     This includes AS (Advanced         99         0-19                                   S           Alevels                                           S              2005-04-30
                        A and AS Level    Subsidiary), A2 and linear A
                        subjects being    Levels, but excludes General
                        studied           Studies and Vocational
                                          Certificates of Education
                                          (VCEs), sometimes known as
                                          Vocational A Levels.

   100249 P137          Number of GCE     Total number of AS level           9          0-9                                    S           Aslevels                                          S              2005-04-30
                        AS Level          subects being studied by pupil
                        subjects being
                        studied
   100250 P138          Number of         The total number of GCSEs          99         0-19                                   S           GCSEs                                             S              2005-04-30
                        GCSE Subjects     being taken by pupil
                        being studied

   100251 P139          GNVQ level        Indicates whether a pupil is not   9          GNVQ Level                             S           GNVQs                                             S              2005-04-30
                                          taking a GNVQ or VCE, or is
                                          taking a foundation,
                                          intermediate or advanced
                                          GNVQ or VCE
   100252 P140          GNVQ            Indicates whether a pupil is not     9          GNVQ Precursor Level                   S           PreGNVQs                                          S              2005-04-30
                        Precursor Level taking a GNVQ precursor, or is
                                        taking a level 2 GNVQ
                                        precursor or a level 3 GNVQ
                                        precursor
   100253 P141          NVQ Level       Indicates whether a pupil is not     9          NVQ Level                              S           NVQs                                              S              2005-04-30
                                        taking a NVQ or is taking a
                                        NVQ level 1, 2 or 3




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                   Page 52 of 58                                                                      Date last updated: 3/4/2011
Identifier Identifier   Data Element    Description                       Business    Format.Values                 Format.     Format.     Format.XML_Tag             Format.Validation (CBDS not            Date.       Date.          Relation.
(New       (Old         Name                                              Format                                    Default     Multiples                              Census validation)                     Periodicity Created        Identifier
CBDS       CBDS                                                                                                                 (S, M)                                                                        (C,S,A,O,X)
Ref No)    Ref No)
Post 16 Courses
   100254 P142          Other Post-16   Indicates whether a pupil is     A(1)         Other Post16 Courses                      S           Other                                                             S             2005-04-30
                        Courses         taking the International
                        Indicator       Baccalaureate, another course
                                        (all categories not counted
                                        elsewhere, including General
                                        Studies) or not taking any other
                                        post year 12 courses

   100255 P199          Qualification   Unique number identifying         A(8)        Qualification Accreditation               M           QAN                        1st and 8th characters can be 0-9 or   S             2006-01-31
                        Accreditation   learning aim / course of study                Number - This file is too                                                        A-Z (upper case)
                        Number                                                        large to be offered as a                                                         Characters 2-7 must be numeric
                                                                                      download; please request
                                                                                      a copy by email from
                                                                                      ChangeControl.CBDS@df
                                                                                      es.gsi.gov.uk.
   100256 P300          Learning Aim    The date on which learning for CCYY-MM-DD                                               M           LearningStartDate                                                 S             2006-01-31
                        Start Date      the learning aim began
   100257 P301          Learning Aim    The date by which the school     CCYY-MM-DD                                             M           LearningPlannedEndDate                                            S             2006-01-31
                        Planned End     and learner plan to complete
                        Date            the learning related to this
                                        learning aim
   100258 P302          Learning Aim    The date that the learner        CCYY-MM-DD                                             M           LearningActualEndDate                                             S             2006-01-31
                        Actual End Date completed the learning
                                        activities necessary to achieve
                                        the learning aim or the date the
                                        learner withdrew from the
                                        learning activities

   100259 P303          Learning Aim    An indication of the degree of     A(1)       Learning Aim Completion                   M           LearningCompletionStatus                                          S             2006-01-31
                        Completion      completion of the learning                    Status
                        Status          activities leading to the learning
                                        aim




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                    Page 53 of 58                                                                                     Date last updated: 3/4/2011
Identifier Identifier   Data Element      Description                    Business   Format.Values                       Format.     Format.     Format.XML_Tag       Format.Validation (CBDS not           Date.       Date.           Relation.
(New       (Old         Name                                             Format                                         Default     Multiples                        Census validation)                    Periodicity Created         Identifier
CBDS       CBDS                                                                                                                     (S, M)                                                                 (C,S,A,O,X)
Ref No)    Ref No)
Post 16 Courses
   100260               DfES Number       DfES number for destination    A(4)       Establishment list - This file is               S           Estab                0001-0900 Secure Units &               O             2006-01-31 100014,
                        for Destination   school or college                         too large to be offered as a                                                     Miscellaneous; 0940-0949 Playing for                            100062,
                        School                                                      download; please request a                                                       Success Centres; 1000-1099 LA                                   100240
                                                                                    copy by email from                                                               Nursery Schools; 1100-1149 Pupil
                                                                                    ChangeControl.CBDS@dfes.                                                         Referral Unit; 1800-1999
                                                                                    gsi.gov.uk.                                                                      Miscellaneous; 2000-3999 Maintained
                                                                                                                                                                     Primary (inc Middle deemed Primary);
                                                                                                                                                                     4000-4899 Maintained Secondary (inc
                                                                                                                                                                     Middle Deemed Secondary); 4900-
                                                                                                                                                                     4999 Sixth Form Centres; 5200-5299
                                                                                                                                                                     Maintained Primary (Ex GM - inc
                                                                                                                                                                     Middle deemed Primary); 5400-5499
                                                                                                                                                                     Maintained Secondary (Ex GM - inc
                                                                                                                                                                     Middle deemed Secondary); 5900-
                                                                                                                                                                     5949 Mixed Maintained Primary and
                                                                                                                                                                     Secondary; 5950-5999 Foundation
                                                                                                                                                                     Special (Ex GM); 6000-6599
                                                                                                                                                                     Independent Schools (inc Special and
                                                                                                                                                                     Approved for SEN); 6900-6904 City
                                                                                                                                                                     Technology Colleges; 6905-6924
                                                                                                                                                                     Academies; 7000-7751 Special
                                                                                                                                                                     Schools; 7500-7511 Non-maintained
                                                                                                                                                                     and Community Special Schools;
                                                                                                                                                                     7748-7754 Community Special
                                                                                                                                                                     Schools; 7900-7901 Special Colleges;
                                                                                                                                                                     8000-8799 Further Education (inc
                                                                                                                                                                     Sixth Form Colleges, incl. 8713 for
                                                                                                                                                                     Nottingham Trent University); 9455
                                                                                                                                                                     Lea House Hospital; 9500-9910
                                                                                                                                                                     Miscellaneous (inc Secure Units, incl.
                                                                                                                                                                     9565 for Blaby Community Home)




   100261               LA Number for     LA number for destination                 LEA list available at                           S           LEA                                                        O              2006-01-31
                                                                                                                                                                                                                                       100013,
                        Destination       school or college                         http://www.teachernet.gov.                                                                                                                         100032,
                        School                                                      uk/management/ims/data                                                                                                                             100043,
                                                                                    management/cbds/CBDSs                                                                                                                              100061,
                                                                                    pecs/                                                                                                                                              100239
   100262               Destination       To manage performance of       A(2)       Destinations                                    S           LeavingDestination                                         O              2006-01-31
                        Information       school, eg how many students
                                          went on to University




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                        Page 54 of 58                                                                               Date last updated: 3/4/2011
Pupil Level: Post 16 Courses Module Codesets
GNVQ Level                                                                                              Learning Aim Completion Status
0          Not taking a GNVQ or VCE                                                                     0            The learner is re-sitting the examination or coursework only. The learner is not
                                                                                                                     attending the full course of study for this learning aim. (The student may be
                                                                                                                     attending some revision classes.)
1             Taking a foundation GNVQ                                                                  1            The learner is continuing or intending to continue the learning activities leading to
                                                                                                                     the learning aim
2             Taking an intermediate GNVQ                                                               2            The learner has completed the learning activities leading to the learning aim

3             Taking an advanced GNVQ or VCE (3, 6 or 12 units)                                         3              The learner has withdrawn from the learning activities leading to the learning aim

                                                                                                        4              The learner has transferred to a new learning aim. That is, the learner has
                                                                                                                       withdrawn from this learning aim and as a direct result has at the same time
                                                                                                                       started studying for another learning aim within the same provider



GNVQ Precursor Level
0          Not taking a GNVQ precursor                                                                  Destinations
2          Taking a level 2 GNVQ precursor (ie a BTEC First or City & Guilds Diploma of                 MS           Maintained school
           Vocational Education at intermediate level
3          Taking a level 3 GNVQ precursor (ie a BTEC National or City & Guilds Diploma of              IS             Independent school
           Vocational Education at national level
                                                                                                        SC             Sixth Form College
                                                                                                        FE             General FE, tertiary and specialist colleges
NVQ Level                                                                                               HE             Higher education institutions
0             not taking a NVQ                                                                          WL             Work based Learning
1             taking a NVQ level 1                                                                      EM             Employment
2             taking a NVQ level 2                                                                      OT             Other
3             taking a NVQ level 3



Other Post 16 Courses
B            Taking the International Baccalaureate
O            Taking another course (not Advanced Supplementary or International
             Baccalaureate) this is a catch of all other categories not counted elsewhere,
             including General Studies
N             Not taking any other post year 12 courses
A             Taking an Advanced Supplementary (old) course (for historical purposed
              only, not an acceptable PLASC entry from January 2005)




e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                     Page 55 of 58                                                                   Date last updated: 3/4/2011
12 Assessment
Identifier Identifier   Data Element     Description                       Business     Format.Values                Format.    Format.     Format.XML_Tag   Format.Validation (CBDS not            Date.       Date.          Relation.
(New       (Old         Name                                               Format                                    Default    Multiples                    Census validation)                     Periodicity Created        Identifier
CBDS       CBDS                                                                                                                 (S, M)                                                              (C,S,A,O,X)
Ref No)    Ref No)
Assessment
   100265 P143          Assessment       Identifier for assessment being   A(3)         Assessment IDs available                S           Stage                                                   S             2005-04-30
                        Identifier       taken by pupil                                 at
                                                                                        http://www.teachernet.gov.
                                                                                        uk/management/ims/data
                                                                                        management/cbds/CBDSs
                                                                                        pecs/
   100266 P144          Assessment       Calendar year of assessment       CCYY                                                 S           Year                                                    S             2001-05-04
                        Year
   100267 P144a         Assessment       Indicates whether the             A(3)         ENG = England                           S           Locale                                                  S             2003-08-31
                        Locale           assessment locale is England,                  WAL = Wales/Cymru
                                         Wales or Unknown                               UNK = Unknown
   100268 P145          Assessment       Date of assessment                CCYY-MM-DD                                           S           Date                                                    S             2001-05-04
                        Date
   100269 P146          Assessment /     Exam season                       A(1)         Season                                  S           Season                                                  S             2001-05-04
                        Examination
                        Season
   100270 P147          Assessment       Indicates whether the result is   A(1)         Result                                  S           ResultStatus                                            S             2001-05-04
                        Result Indicator estimated, an interim result,
                                         provisional, actual result or a
                                         target
   100271 P148          Assessment       Subject assessed                  A(3)         Assessment subjects                     S           Subject          Must be absent or blank if             S             2004-05-31
                        Subject                                                         available at                                                         <ExamSubject> not blank
                                                                                        http://www.teachernet.gov.
                                                                                        uk/management/ims/data
                                                                                        management/cbds/CBDSs
                                                                                        pecs/
   100272 P148a         Examination      Subject of exam                   A(6)         Assessment subjects                     S           ExamSubject      Must be absent or blank if <Subject>   S             2004-05-31
                        Subject                                                         available at                                                         not blank
                                                                                        http://www.teachernet.gov.
                                                                                        uk/management/ims/data
                                                                                        management/cbds/CBDSs
                                                                                        pecs/
   100273 P149          Assessment       Method of assessment              A(3)         Assessment types                        S           Method                                                  S             2006-01-31
                        Type             (Task/test, teacher                            available at
                                         assessment, disapplied, test                   http://www.teachernet.gov.
                                         not taken)                                     uk/management/ims/data
                                                                                        management/cbds/CBDSs
                                                                                        pecs/
   100274 P150          Assessment       Subject component within each A(3)             Assessment component                    S           Component                                               S             2006-01-20
                        Component        type of assessment                             details 2006 available at
                                         (Assessments prior to 2004 will                http://www.teachernet.gov.
                                         be in A_COMP_2003)                             uk/management/ims/data
                                                                                        management/cbds/CBDSs
                                                                                        pecs/




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                                    Page 56 of 58                                                                           Date last updated: 3/4/2011
Identifier Identifier   Data Element   Description                    Business   Format.Values                Format.    Format.     Format.XML_Tag        Format.Validation (CBDS not   Date.       Date.          Relation.
(New       (Old         Name                                          Format                                  Default    Multiples                         Census validation)            Periodicity Created        Identifier
CBDS       CBDS                                                                                                          (S, M)                                                          (C,S,A,O,X)
Ref No)    Ref No)
Assessment
   100275 P151          Component      Component result type          A(2)       Assessment component                    M           ResultQualifier                                     S             2006-01-20
                        Result Type                                              result types available at
                                                                                 http://www.teachernet.gov.
                                                                                 uk/management/ims/data
                                                                                 management/cbds/CBDSs
                                                                                 pecs/
   100276 P152          Component      Result of components within     A(3)      Assessment component                    M           Result                                              S             2006-01-20
                        Result         each type of assessment                   details 2006 available at
                                       (Assessments prior to 2004 will           http://www.teachernet.gov.
                                       be in A_COMP_2003)                        uk/management/ims/data
                                                                                 management/cbds/CBDSs
                                                                                 pecs/
   100277 P153          Awarding Body/ Name of awarding body/exam     A(3)       Awarding bodies &                       M           ExamBoard                                           S             2001-05-04
                        Examination    board                                     examination boards
                        Board                                                    available at
                                                                                 http://www.teachernet.gov.
                                                                                 uk/management/ims/data
                                                                                 management/cbds/CBDSs
                                                                                 pecs/
   100278 P154          Examination    Exam board syllabus ID         A(6)       Key Stage 4 & 5                         M           ExamBoardSyllabusID                                 S             2001-05-04
                        Syllabus                                                 syllabuses available at
                        Number                                                   http://www.teachernet.gov.
                                                                                 uk/management/ims/data
                                                                                 management/cbds/CBDSs
                                                                                 pecs/




    e802cf28-1f4b-41d8-b153-c4a651d9e319.xls                                                             Page 57 of 58                                                                       Date last updated: 3/4/2011
Pupil Level: Assessment Module Codesets
Season
S        Summer
W        Winter
M        Modular/Continuous Assessment
1-9      Jan-September
a-c      October-November



Result
E        Estimate
I        Interim
P        Provisional (subject to regrading/appeal)
R        Result
T        Target

								
To top