Blank Marriage Certificate Uk

Document Sample
Blank Marriage Certificate Uk Powered By Docstoc
					Information relating to this spreadsheet

Title                  CBDS Specification - Pupil (Modular Format)
Version                V4.3
Filename               Pupil CBDS V4.3
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      19-Jan-07

Notes:




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                          Page 1 of 70                          Date last updated: 1/7/2011
                            Key to Columns in the new CBDS Spreadsheets
Column                      Column                         Description and contents
Identifier                  Identifier (New CBDS Ref No)   Starting from 10000, replacing P1, P402a, S1, S2 etc
Title.Main                  Title                          The name of the data item
Description                 Description                    The description of the data item not required if description of data item is clear from Data Element Name
Format                      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.Codeset              Codeset                        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                  Default value
Format.Multiples            Allow Multiple Entries? (S, M) S = Single current occurance, M = Multiple current occurance.
Format.XMLTag               XML Tag                        XML tag
Format.Validation           Validation Rules               The validation rules to be applied for acceptance of data e.g. ZQ postcode - error
Date.PeriodicityItemlevel   Item Level (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                Date Created                   Date of version of CBDS data item first appeared in or last updated (CCYY-MM-DD)
Status                      Data Item Status               1 = Active, 2 = Inactive, 3 = Deleted
Date.ToBeImplemented        Implementation Date            Date for data item to be implemented
Date.Cut-off Date           Cut-off Date                   Date from which the data item definition should no longer be used
Relation.References         Data Item References           Other linked CBDS data items




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                     Page 2 of 70                                                                      Date last updated: 1/7/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 Country of Birth                       Nation states and countries
Identifiers       Pupil's Former UPN                                                    Characteristics   Pupil Religious Affiliation Code             Religion
                  Pupil/Child Surname                                                   (Continued)       Pupil Religious Affiliation Code             Religion v2.0
                  Pupil/Child Forename                                                                    Pupil Religious Education Indicator
                  Pupil Name Order Indicator                                                              Pupil Collective Worship Indicator
                  Pupil/Child Middle Names                                                                Pupil Home LA                                LEA list
                  Date of Birth                                                                           Pupil Free School Meal Eligibility
                  Pupil/Child Date of Birth                                                               Pupil Free School Meal Review Date
                  Pupil Gender                                                                            Pupil Free School Transport Eligibility
                  Pupil/Child Gender                     Pupil/Child Gender                               Connexions Agreement                         Connexions Agreement
                  Pupil former Surname                                                                    Gifted & Talented indicator
                  Pupil Preferred Forename                                                                In Care Indicator
                  Pupil/Child Preferred Surname                                                           In Care - Caring Authority Code              LEA list
                  Pupil Preferred Name Order Indicator                                                    In Care while at current school indicator

                  Attendance School LA Number            LEA list                                         Personal Education Plan Indicator
                  Attendance School DfES Establishment   Establishment list                               Child Protection Register Indicator
                  NumberInternal Pupil Identifier
                  Unique                                                                                  Pupil Child Protection Register LA Code      LEA list

                  ULN                                                                                     First Language                               First Language
                  UPN allocation date                                                                     Language Type                                Language Type
                  Sibling flag                                                                            Language Type                                Language Type v2.0
                  Photograph                                                                              Language Code                                Language code list v1.0
                  On roll on census day                                                                   Language Code                                Language code list v2.0
                  Birth certificate seen indicator                                                        Usual mode of travel                         Usual mode of travel
                  Birth date verification level          BirthDateVerificationLevel                       Free school meal taken or claimed
                                                                                                          Free School Transport Eligibility Review
                                                                                                          Date
Module            Date items                             Codesets                                         Type of care                                 In care type
2 Pupil           Pupil Ethnic Code                      Ethnic code list                                 English as additional language               Assessment component details
Characteristics   Ethnicity                              Ethnic code list v2.0                            Family structure                             Family
                  Source of Pupil Ethnic Code            Ethnicity Source                                 Sibling on Child Protection Register
                  Pupil Traveller/ Gypsy Code            Traveller/Gypsy Code                             Number of previous schools
                  Source of Pupil Traveller Indicator    Traveller Source                                 Pregnant pupil indicator
                  Pupil Nationality                      Nation states and countries                      Uniform allowance indicator
                  Pupil Refugee/                                                                          Source of pupil religious affiliation code   Religion Source
                  Asylum Seeker Indicator
                                                                                                          Date of Entry
                                                                                                          Service Child Indicator                      Service Child Indicator
                                                                                                          Source for Service Child Indicator           Service Child Source
                                                                                                          IDACI




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                               Page 3 of 70                                                                                   Date last updated: 1/7/2011
Data items and codesets by module in the new CBDS spreadsheets


Module           Date items                                Codesets                  Module         Date items                                Codesets
3 Pupil Status   Pupil/child 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 Date
                 Pupil Date of Leaving                                                              Exclusion Start (am/pm)
                 Pupil Part-time Indicator                                                          Exclusion End Date
                 Pupil - Number of sessions                                                         Exclusion Actual Number of Sessions

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

                 Leaving destination                                                                Date of exclusion hearing/expiration of
                                                                                                    notice of appeal
                 Name of leaving destination
                 Pupil/Child Educated Elsewhere
4 SEN            Member of SEN Unit, special class or
                 resourced provision
                 Member of SEN Unit or special class
                 Member of Resourced provision
                 SEN Provision                             Pupil SEN provision
                 Pupil date placed upon stage              Pupil SEN Type
                 Pupil date of next SEN review
                 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




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                            Page 4 of 70                                                                       Date last updated: 1/7/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                    6 Home            Telephone Type                    Telephone Type
Information      SAON                                                              Information       Telephone Number
                 SAON Start Number                                                 (Continued)       Start date at address
                 SAON Start Number Suffix                                                            End date at address
                 SAON End Number
                 SAON End Number Suffix
                 SAON Description                                                  Module            Date items                        Codesets
                 PAON                                                              7 Home Location Enumeration district
                 PAON Start Number                                                 Context         LA Electoral Ward Code
                 PAON Start Number Suffix                                                            LA Electoral Ward Name
                 PAON End Number                                                                     Parliamentary Constituency Code
                 PAON End Number Suffix                                                              Parliamentary Constituency Name
                 PAON Description                                                                    Parish Council
                 Street                                                                              Church of England Diocese         Church dioceses
                 Locality                                                                            Church of England Parish
                 Town                                                                                Roman Catholic Diocese            Church dioceses
                 Administrative Area                                                                 Roman Catholic Parish
                 Post town                                                                           Learning & Skills Council Code    LSC Area list
                 Postcode                                                                            Catchment area
                 Postcode
                 UPRN
                 Unique Property Reference Number
                 Unique Street Reference Number
                 Unique Street Reference Number
                 Property Easting
                 Property Northing
                 OSAPR
                 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
                 International Post Code
                 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      Nation states and countries
                 ISO 3166-1 Long Country Name       Nation states and countries
                 Telephone Type                     PhoneType




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                          Page 5 of 70                                                           Date last updated: 1/7/2011
Data items and codesets by module in the new CBDS spreadsheets

Module           Date items                                    Codesets
8 Contact        Contact Priority                                                         Module        Date items                                 Codesets
Information      Contact Title                                                            8 Contact     Unique Street Reference Number
                 Contact Last Name                                                        Information   Property Easting
                 Contact First Name                                                       (Continued)   Property Northing
                 Contact Middle Name                                                                    OSAPR
                 Contact Gender                                                                         Address Line 1
                 Contact Relationship to Pupil             Relationship                                 Address Line 2
                 Contact Relationship to pupil/child       Relationship v2.0                            Address Line 3
                 Contact Relationship to pupil/child       SIFRelationship                              Address Line 4
                 (extended list as used in SIF Data Model)

                 Contact Responsibility to Pupil                                                        Address Line 5
                 Contact Member of Armed Forces                                                         International Address Line 1
                 Indicator
                 Contact Translator or Interpreter Indicator                                            International Address Line 2

                 Contact Language Code                         Language code list                       International Address Line 3
                 Contact Language Code                         Language code list v2.0                  International Address Line 4
                 Contact Email Address                                                                  International Address Line 5
                 Contact Address Type                          Address Type                             Zip Code
                 SAON                                                                                   International Post Code
                 SAON Start Number                                                                      ISO 3166-1 Alpha-3 Code                    Nation states and countries
                 SAON Start Number Suffix                                                               ISO 3166-1 Alpha-2 Code                    Nation states and countries
                 SAON End Number                                                                        ISO 3166-1 Numeric-3 Code                  Nation states and countries
                 SAON End Number Suffix                                                                 Country Name                               Nation states and countries
                 SAON Description                                                                       ISO 3166-1 Short Country Name              Nation states and countries
                 PAON                                                                                   ISO 3166-1 Long Country Name               Nation states and countries
                 PAON Start Number                                                                      Contact Telephone Type
                 PAON Start Number Suffix                                                               Contact Telephone Type                     Telephone Type
                 PAON End Number                                                                        Contact Telephone Number
                 PAON End Number Suffix                                                                 Day location
                 PAON Description                                                                       Preference for written communication
                 Street                                                                                 indicatorpriority source
                                                                                                        Contact                                    Contact Priority Source
                 Locality                                                                               Child is resident with contact indicator

                 Town                                                                                   Address can be disclosed indicator
                 Administrative Area                                                                    Contact address should be transferred
                                                                                                        with pupil indicator
                 Post Town
                 Postcode
                 Postcode
                 Unique Property Reference Number
                 UPRN
                 Unique Street Reference Number




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                 Page 6 of 70                                                                            Date last updated: 1/7/2011
Data items and codesets by module in the new CBDS spreadsheets

Module           Date items                            Codesets
9 Attendance     Attendance Year
                 Attendance period start date                                        Module        Date items                              Codesets
                 Attendance period end date                                          11 Post 16    Post Advanced Level Indicator
                 Possible Sessions                                                   Courses       Number of GCE A Level subjects being
                                                                                                   studied
                 Sessions Attended                                                                 Number of GCE A and AS Level subjects
                                                                                                   being studied
                 Sessions missed due to Authorised                                                 Number of GCE AS Level subjects being
                 Absence                                                                           studied
                 Sessions missed due to Unauthorised                                               Number of GCSE Subjects being studied
                 Absence
                 Attendance codes                      Pupil Attendance Codes                      GNVQ level                              GNVQ Level
                 Number of sessions missed                                                         GNVQ Precursor Level                    GNVQ Precursor Level
                 Alternative tuition indicator                                                     NVQ Level                               NVQ Level
                 Alternative tuition category          TuitionCategory                             Other Post-16 Courses Indicator         Other Post 16 Courses
                 Alternative tuition start date                                                    Qualification Accreditation Number      Qualification Accreditation Number
                 Alternative tuition end date                                                      Learning Aim Start Date
                 Number of hours alternative tuition   TuitionHours                                Learning Aim Planned End Date
                 attended per week
                 Type of Alternative Provision         Alternative Provision Type                  Learning Aim Actual End Date
                 Funded Hours                                                                      Learning Aim Completion Status          Learning Aim Completion Status
                 Hours at Setting                                                                  Discount Code                           QAN_DiscCode.XML
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
                 Previous School Date of Entry                                                     Destination                             Leaving Destination v2.0
                 Previous School Date of Leaving
                 Pupil Reason for Leaving
                 Reason for leaving                    LeavingReason v2.0
                 Last School




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                            Page 7 of 70                                                                          Date last updated: 1/7/2011
Data items and codesets by module in the new CBDS spreadsheets

Module           Date items                         Codesets                            Module          Date items                        Codesets
12 Assessment    Assessment Identifier              Assessment IDs                      13 Admissions   Admissions entry year and month
                 Assessment Year                                                                        Admissions entry year group       Entry year group
                 Assessment Locale                                                                      Status                            Status type
                 Assessment Locale                                                                      Text (file header)
                 Assessment Date                                                                        Application reference
                 Assessment / Examination Season    Season                                              Statemented
                 Assessment Result Indicator        Result                                              Verified (address)
                 Assessment Subject                 Assessment subjects                                 Preference Rank
                 Examination Subject                Assessment subjects                                 Preference reason                 Reason codes
                 Assessment Type                    Assessment types                                    Preference reason text
                 Assessment Component               Assessment component details                        Aptitude code                     Aptitude Code
                 Component Result Type              Assessment component result type                    Aptitude text
                 Component Result                   Assessment component details                        Faith                             Faith
                 Awarding Body/ Examination Board   Awarding bodies and examination                     Faith text
                                                    boards
                 Examination Syllabus Number        Key Stage 4 and 5 syllabuses                        Distance from school
                                                                                                        LA pre banding information        Pre Banding categories
                                                                                                        LA 'other' text
                                                                                                        Local reference
                                                                                                        Medical or social information
                                                                                                        Offer status                      Offer status
                                                                                                        Criterion
                                                                                                        Priority
                                                                                                        Admission policy criterion
                                                                                                        Notification method               Notification method
                                                                                                        Ranking of offers




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                               Page 8 of 70                                                                Date last updated: 1/7/2011
  1 Pupil Identifiers
 Identifier Title              Description                    Format   Codeset                         Default   Allow       XML Tag        Validation Rules                    Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                  Value     Multiple                                                       Level Created        Item         Date
 CBDS Ref                                                                                                        Entries?                                                                            Status
 No)                                                                                                             (S, M)
 Pupil identifiers
 100001      Unique Pupil      A Unique Pupil Number (UPN) A(13)       A999999999999 or                          S           UPN            To calculate the check letter:       C      2000-10-10            1
             Number (UPN)      is allocated to each pupil in           A99999999999A (for                                                   1. Multiply the individual digits by
                               maintained schools in                   temporary UPN)                                                       their weights as follows:
                               England and Wales. It is an             Any alphabetical character                                           digit 2 by weight 2; digit 3 by
                               identifier for use in the               other than I, O, or S.                                               weight 3; digit 4 by weight 4; digit
                               educational context during a            Characters 2-4 must be a                                             5 by weight 5; digit 6 by weight 6;
                               child's school career only and          valid post April 1998 LA code                                        digit 7 by weight 7; digit 8 by
                               subject to Data Protection              or a recognised Welsh                                                weight 8; digit 9 by weight 9; digit
                               restrictions.                           "pseudo LA" code (see LA list                                        10 by weight 10; digit 11 by
                                                                       codeset)                                                             weight 11; digit 12 by weight 12;
                                                                                                                                            digit 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      Pupil's Former    Where a pupil has held         A(13)    A999999999999 or                          S           FormerUPN      Where present                     S         2000-10-10            1
             UPN               another UPN whilst at a                 A99999999999A (for                                                   (a) should contain the correct
                               school (eg temporary UPN                temporary UPN)                                                       check letter (for calculating the
                               was allocated when the pupil                                                                                 check letter see <UPN>
                               was first admitted to the                                                                                    (100001))
                               school, but subsequently                                                                                     (b) characters 2-13 of
                               replaced by the permanent                                                                                    <FormerUPN> = characters 2-13
                               UPN being retrieved from a                                                                                   of <UPN>
                               previous school)

 100003      Pupil/Child      Full legal surname (derived      A(35)   Any character string                      S           Surname                                            C       2000-10-10            1
             Surname          from family, clan or marital
                              association) of the child (as
                              written).
 100004      Pupil/Child      Full given first name of the     A(35)   Any character string                      S           Forename                                           C       2000-10-10            1
             Forename         child (not common
                              contractions)
 100005      Pupil Name Order This indicator will be used      A(1)    Y or blank                      Blank     S           SurnameFirst   Y if the recorded surname (for   O          2000-11-22            1
             Indicator        primarily to identify the naming                                                                              written communication purposes)
                              conventions used by some,                                                                                     should be used for familiar
                              predominantly non-European,                                                                                   spoken communication
                              ethnic or language groups.                                                                                    (equivalent to the first name in
                                                                                                                                            traditional European languages).




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                             Page 9 of 70                                                                                     Date last updated: 1/7/2011
 Identifier Title               Description                       Format       Codeset                      Default   Allow      XML Tag                 Validation Rules                  Item Date            Data         Implementation     Cut-off Date
 (New                                                                                                       Value     Multiple                                                             Level Created        Item         Date
 CBDS Ref                                                                                                             Entries?                                                                                  Status
 No)                                                                                                                  (S, M)
 Pupil identifiers
 100006      Pupil/Child Middle In full, not shortened or         A(35)        Any character string                   S          MiddleNames             Components should be              C       2000-10-10            1
             Names              familiar versions. If pupil has                                                                                          separated by a single space.
                                no middle name(s) then this
                                field must be left blank

 100007      Pupil Date of      Date of birth of pupil            CCYY-MM-DD Any valid date                           S          DOB                     Implied age at previous 31        C       2000-10-10            1
             Birth                                                                                                                                       August would normally be in the
                                                                                                                                                         range:
                                                                                                                                                         Primary schools 2-12; Middle
                                                                                                                                                         schools 7-14;
                                                                                                                                                         Secondary schools 10-19;
                                                                                                                                                         Special schools 2–25.
 100292      Date of Birth      Date of birth of pupil/child      CCYY-MM-DD Any valid date                           S          PersonBirthDate         Implied age at previous 31       C        2006-12-31            1        01/03/2007
                                                                                                                                                         August would normally be in the                                      EY Census Pilot
                                                                                                                                                         range:
                                                                                                                                                         Early Years 3-4; Primary schools
                                                                                                                                                         2-12; Middle schools 7-14;
                                                                                                                                                         Secondary schools 10-19;
                                                                                                                                                         Special schools 2–25.

 100008      Pupil Gender       Gender of pupil                 A(1)           M or F for Male and Female             S          Gender                                                    C       2000-10-10            1
 100287      Pupil/Child        Gender of pupil/child (as       A(1)           Pupil/Child Gender                     S          GenderCurrent                                             C       2006-12-31            1        01/03/2007
             Gender             defined in Common Data                                                                                                                                                                        EY Census Pilot
                                Elements).
 100009      Pupil former       A pupil's former surname        A(35)          Any character string                   S          FormerSurname                                             S       2004-12-01            1
             Surname            where it is known. (This
                                should only be completed if a
                                former 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      Pupil Preferred    The forename preferred by    A(35)             Any character string                   S          PreferredForename       Common contractions, if used,     C       2004-12-01            1
             Forename           the pupil (as written) most                                                                                              may be recorded.
                                commonly used in the school.

 100011      Pupil/Child        The surname preferred by the A(35)             Any character string                   S          PreferredSurname                                          C       2004-12-01            1
             Preferred          pupil (as written) most
             Surname            commonly used in the school.

 100012      Pupil Preferred    This indicator will be used      A(1)          Y or blank                   Blank     S          PreferredSurnameFirst   Y if the recorded surname (for   O        2000-11-22            1
             Name Order         primarily to identify the naming                                                                                         written communication purposes)
             Indicator          conventions used by some,                                                                                                should be used for familiar
                                predominantly non-European,                                                                                              spoken communication
                                ethnic or language groups.                                                                                               (equivalent to the first name in
                                                                                                                                                         traditional European languages).




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                              Page 10 of 70                                                                                              Date last updated: 1/7/2011
 Identifier Title               Description                       Format        Codeset                              Default   Allow      XML Tag                Validation Rules              Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                                Value     Multiple                                                        Level Created        Item         Date
 CBDS Ref                                                                                                                      Entries?                                                                             Status
 No)                                                                                                                           (S, M)
 Pupil identifiers
 100013      Attendance         LA number for school which        A(3)          LEALIST_V3                                     S          LEA                                                  S       2006-01-31            1
             School LA          pupil attends
             Number
 100014      Attendance         School DfES Establishment     A(4)              Establishment list - This file                 S          Estab                  0001-0900 Secure Units &              2006-01-31            1
             School DfES        Number for school which pupil                   is too large to be offered as                                                    Miscellaneous; 0940-0949
             Establishment      attends                                         a download; please request                                                       Playing for Success Centres;
             Number                                                             a copy by email from                                                             1000-1099 LA Nursery Schools;
                                                                                                                                                                 1100-1149 Pupil Referral Unit;
                                                                                ChangeControl.CBDS@dfe
                                                                                                                                                                 1800-1999 Miscellaneous; 2000-
                                                                                s.gsi.gov.uk                                                                     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,
 100015      Unique Internal    Pupil identifier unique to a      A(20)                                                        S          LocalPupilIdentifier   incl. 9565 for
                                                                                                                                                                 No validation Blaby Community O       2006-01-31            1
             Pupil Identifier   school
 100016      ULN                Unique Learner Number             9999999999 A ten digit number with zero                      S          UniqueLearnerNumber                                  O       2006-01-31            1
                                                                             not allowed as the first
                                                                             character.
 100017      UPN allocation     Date UPN allocated                CCYY-MM-DD Any valid date                                    S          UPNallocationDate                                    O       2006-01-31            1
             date
 100018      Sibling flag       Indicates that a pupil has        A(20)         Unique Internal Pupil Identifier               M          SiblingIdentifier                                    O       2006-01-31            1
                                brother or sister in the school                 of sibling(s)

 100019      Photograph         Pupil photograph in an image A(254)             filename.ext where filename                    S          PupilImage                                           O       2006-12-31            1
                                file                                            may contain any character
                                                                                except /, \, <, >, ?, *, :, | or "
                                                                                and ext can be any usual
                                                                                image file format eg gif, jpg,
                                                                                png or tif




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                       Page 11 of 70                                                                                         Date last updated: 1/7/2011
 Identifier Title               Description                      Format   Codeset                             Default    Allow      XML Tag                        Validation Rules   Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                         Value      Multiple                                                     Level Created        Item         Date
 CBDS Ref                                                                                                                Entries?                                                                          Status
 No)                                                                                                                     (S, M)
 Pupil identifiers
 100020      On roll on census Indicates that a record was        A(5)    1,0 or true, false                             S          SchoolCensusPupilRecord                           O       2006-01-31            1
             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            2
             seen indicator     certificate had been viewed in            not seen), 2 verified (birth
                                order to establish the correct            certificate viewed)
                                legal name
 100328      Birth date         Indicates the level of birth date A(1)    BirthDateVerificationLevel                    0 S         BirthDateVerification                             O       2006-12-31            1
             verification level verification




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                  Page 12 of 70                                                                                     Date last updated: 1/7/2011
Pupil Level: Pupil Identifiers Module Codesets
Pupil/Child Gender
0               Not known
1               Male
2               Female
9               Not specified



BirthDateVerificationLevel
0               Not Verified
1               One or more of the following Secondary certificates: Certificate of Baptism; Marriage Certificate; National
                Health Service Medical Card; Child's Certificate of Vaccination; Child's Health Record Card; A certificate of
                Service in HM Forces or other employment under the Crown or in the Mercantile Marine; A certificate of
                membership of a Trade Union Friendly Society or any cards or papers relating to membership of an Approved
                Society or Unemployment Insurance Apprenticeship indentures; Early certificate or testimonial from employer;
                Aliens registration card, certificate of naturalisation, Home Office travel document or a passport; Life insurance
                policy; Certificate of confirmation; School certificate or report; A birthday book or old family record; Family Bible
                containing a record of birth.


2                 One of the following: Full certificate; Birth certificate short form; Certificate of registry showing given names
                  and family name; GRO copy; Adoption Order issued by the High Court, County Court or Juvenile Court;
                  Certificate of adoption issued by the GRO; Foreign birth certificate issued by registration authority of the
                  foreign country.




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                        Page 13 of 70                                           Date last updated: 1/7/2011
  2 Pupil Characteristics
 Identifier Title            Description                         Format   Codeset                       Default   Allow      XML Tag           Validation Rules                 Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                   Value     Multiple                                                      Level Created        Item         Date
 CBDS Ref                                                                                                         Entries?                                                                           Status
 No)                                                                                                              (S, M)
 Pupil Characteristics
    100022 Pupil Ethnic Code Pupil's ethnic code                 A(4)     Ethnic code list              NOBT      S          Ethnicity                                          C       2000-10-10            1

    100319 Ethnicity             Pupil/child's ethnic code       A(4)     Ethnic code list V2.0         NOBT      S          Ethnicity                                          C       2006-12-31            1
                                                                          available at
                                                                          http://www.teachernet.gov.
                                                                          uk/docbank/index.cfm?id=1
                                                                          0430
    100023 Source of Pupil       Source of pupil's recorded      A(1)     Ethnicity Source                        S          EthnicitySource   <EthnicitySource> must be        S       2000-10-10            1
           Ethnic Code           ethnic code                                                                                                   present where <Ethnicity> is
                                                                                                                                               present
                                                                                                                                               If <Ethnicity> = REFU then
                                                                                                                                               <EthnicitySource> must be C, P
                                                                                                                                               or O
    100024 Pupil Traveller/      Code to identify type of        A(2)     Traveller/Gypsy Code                    S          Traveller                                          O       2000-10-10            1
           Gypsy Code            Traveller/Gypsy
    100025 Source of Pupil       Source of pupil's recorded      A(1)     Traveller Source                        S          TravellerSource                                    O       2006-01-31            1
           Traveller Indicator   traveller/gypsy code

    100026 Pupil Nationality     The country of legal nationality A(3)    Nation states and countries             S          Nationality                                        O       2004-05-31            1
                                 (ie which country issued the             (consistent with GDSC
                                 pupil's passport)                        requirement to use BSEN
                                                                          3166 (ISO 3166-1))
                                                                          available at
                                                                          http://www.teachernet.gov.
                                                                          uk/docbank/index.cfm?id=1
                                                                          0434




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                          Page 14 of 70                                                                                       Date last updated: 1/7/2011
 Identifier Title              Description                      Format   Codeset                        Default   Allow      XML Tag              Validation Rules                   Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                   Value     Multiple                                                           Level Created        Item         Date
 CBDS Ref                                                                                                         Entries?                                                                                Status
 No)                                                                                                              (S, M)
 Pupil Characteristics
    100027 Pupil Refugee/      Indicates a pupil's               A(5)    1,0 or true, false                       S          Refugee              Must be 0 or false if <Nationality> O      2006-12-31            1
            Asylum Seeker      refugee/asylum seeker status                                                                                       = GBR
            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 Pupil Country of    The country of birth             A(3)     Nation states and countries              S          CountryofOrigin                                         O       2004-05-31            1
           Birth                                                         (consistent with GDSC
                                                                         requirement to use BSEN
                                                                         3166 (ISO 3166-1))
                                                                         available at
                                                                         http://www.teachernet.gov.
                                                                         uk/docbank/index.cfm?id=1
                                                                         0434
    100029 Pupil Religious     Religious faith of the pupil     A(2)     Religion                                 S          Religion                                                O       2000-10-10            2
           Affiliation Code
    100320 Pupil Religious     Religious denomination of the A(2)        Religion V2.0                            S          Religions                                               O       2006-12-31            1
           Affiliation Code    pupil
    100030 Pupil Religious     Indicates if the pupil has been A(1)      W (Withdrawn from RE) or A               S          ReligiousEducation                                      O       2000-10-10            1
           Education           withdrawn from RE                         (Attends RE)
           Indicator
    100031 Pupil Collective    Indicates if the pupil has been A(1)      W (Withdrawn from collective             S          CollectiveWorship                                       O       2000-10-10            1
           Worship Indicator   withdrawn from collective                 worship) or A (Attends
                               worship                                   collective worship)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                          Page 15 of 70                                                                                            Date last updated: 1/7/2011
 Identifier Title              Description                       Format        Codeset                     Default      Allow      XML Tag          Validation Rules   Item Date            Data         Implementation    Cut-off Date
 (New                                                                                                      Value        Multiple                                       Level Created        Item         Date
 CBDS Ref                                                                                                               Entries?                                                            Status
 No)                                                                                                                    (S, M)
 Pupil Characteristics
    100032 Pupil Home LA       Pupil's home LA                A(3)             LEALIST_V3                               S          HomeLEA                             S       2006-01-31            1
                               (Home LA is equivalent to the
                               “housing authority” as defined
                               in Section 11.2 of the DfES
                               Guidance on the Education of
                               Young People in Public Care)

    100033 Pupil Free School Indicates if the pupil is eligible A(5)           1,0 or true, false                       S          FSMeligible                         C       2004-12-01            1
           Meal Eligibility  for free school meals
                             (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 Pupil Free School   Review date for pupil's free      CCYY-MM-DD Any valid date after current                S          FSMreviewDate                       C       2000-10-10            1
           Meal Review         school meal eligibility                      date
           Date
    100035 Pupil Free School   Indicates if the pupil is eligible A(5)         1,0 or true, false                       S          FreeTransport                       C       2004-12-01            1
           Transport           for free school transport
           Eligibility

    100036 Connexions        Indicates if parents consent to A(3)              Connexions Agreement        UNS          S          Connexions                          S       2004-05-31            1
           Agreement         pupil data being shared with
                             Connexions
                             (Middle, Secondary and
                             Special Schools only)
    100037 Gifted & Talented Indicates if the pupil is in the A(5)             1,0 or true, false          false or 0   S          GandTindicator                      C       2004-12-10            1        2006-19-01
           indicator         Gifted & Talented cohort for
                             the school




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                Page 16 of 70                                                                        Date last updated: 1/7/2011
 Identifier Title              Description                       Format   Codeset              Default   Allow      XML Tag                 Validation Rules              Item Date            Data         Implementation   Cut-off Date
 (New                                                                                          Value     Multiple                                                         Level Created        Item         Date
 CBDS Ref                                                                                                Entries?                                                                              Status
 No)                                                                                                     (S, M)
 Pupil Characteristics
    100038 In Care Indicator   Indicates if the child is 'looked A(5)     1,0 or true, false             S          InCare                                                C       2004-12-01            1
                               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 In Care - Caring    Code of the 'originating'        A(3)      LEALIST_V3                     S          CareAuthority           If <InCare> = true or          S      2000-10-10            1
           Authority Code      authority, where the child was                                                                               <InCareAtCurrentSchool> = true
                               originally placed in public care                                                                             then there must be a valid LA
                               and which looks after the child                                                                              Caring Authority Code
                               for the purposes of the
                               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 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            1
           current school      been in care while at the                                                                                    <InCareAtCurentSchool> must
           indicator           school                                                                                                       also be true




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                 Page 17 of 70                                                                                          Date last updated: 1/7/2011
 Identifier Title            Description                   Format   Codeset              Default   Allow      XML Tag                 Validation Rules   Item Date            Data         Implementation   Cut-off Date
 (New                                                                                    Value     Multiple                                              Level Created        Item         Date
 CBDS Ref                                                                                          Entries?                                                                   Status
 No)                                                                                               (S, M)
 Pupil Characteristics
    100041 Personal          Indicates whether the pupil in A(5)    1,0 or true, false             S          PersonalEducationPlan                      S       2004-12-01            1
            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.”)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                           Page 18 of 70                                                                               Date last updated: 1/7/2011
 Identifier Title              Description                     Format   Codeset                      Default   Allow      XML Tag              Validation Rules                    Item Date            Data         Implementation    Cut-off Date
 (New                                                                                                Value     Multiple                                                            Level Created        Item         Date
 CBDS Ref                                                                                                      Entries?                                                                                 Status
 No)                                                                                                           (S, M)
 Pupil Characteristics
    100042 Child Protection Indicates if the pupil is on the A(5)       1,0 or true, false                     S          ProtectionRegister                                       C       2004-12-01            1
            Register Indicator Child Protection Register
                               (“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 Pupil Child      The LA code where a pupil is A(3)           LEALIST_V3                             S          RegisterLEA          Must not be blank if the pupil is   C       2006-01-31            1
           Protection       on the LA's Child Protection                                                                                       on the Child Protection Register
           Register LA Code Register
                            (See <ProtectionRegister>
                            above)
    100044 First Language   The language to which the       A(3)        First Language                         S          FirstLanguage                                            C       2004-05-31            1                       18/01/2007
                            child was exposed during                                                                                                                                                                                         School
                            early development and                                                                                                                                                                                        Census 07
                            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 Language Type       Types of pupil language          A(1)    LanguageType                           S          LanguageQualifier                                        C       2005-04-30            1
                               usage: 'First language‟,
                               „Multiple First Language‟,
                               'Home Language‟, 'Tuition
                               Language' and „Second
                               Language‟

    100327 Language Type       Types of pupil language          A(1)    Language Type V2.0                     M          LanguageType                                             C       2006-12-31            1
                               usage
    100046 Language Code       Codes for language(s) used       A(4)    Language code list (V1)                S          Language                                                 C       2005-04-30            2                       17/01/2007
                               by pupils                                                                                                                                                                                                     School
                                                                                                                                                                                                                                         Census 07
    100047 Language Code       Codes for language(s) used       A(4)    Language code list (V2)                M          Language                                                 C       2006-12-31            1        18/01/2007
                               by pupils (incorporating First           available at                                                                                                                                   School Census
                               Language (P50) code set)                 http://www.teachernet.gov.                                                                                                                                07
                                                                        uk/docbank/index.cfm?id=9
                                                                        525




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                       Page 19 of 70                                                                                             Date last updated: 1/7/2011
 Identifier Title                Description                        Format        Codeset                      Default      Allow      XML Tag                   Validation Rules                   Item Date            Data         Implementation    Cut-off Date
 (New                                                                                                          Value        Multiple                                                                Level Created        Item         Date
 CBDS Ref                                                                                                                   Entries?                                                                                     Status
 No)                                                                                                                        (S, M)
 Pupil Characteristics
    100048 Usual mode of        The usual mode of travel            A(3)          Usual mode of Travel                      S          ModeOfTravel                                                 C       2006-01-31            1        18/01/2007
            travel              normally used by the child for                                                                                                                                                                          School Census
                                the greater part (in distance)                                                                                                                                                                                     07
                                of the journey to and from
                                school.
    100049   Free school meal Indicates if pupil has claimed        A(5)          1,0 or true, false                        S          FSMclaim                                                     O       2006-01-31            1
             taken or claimed for a free school meal on
                                Census day
    100050   Free School        Review date for pupil's free        CCYY-MM-DD                                              S          FreeTransportReviewDate                                      O       2006-12-31            1
             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            1
                                fostering, children's home
    100052   English as         Assessment of a pupil's             A(2)          Assessment component                      S          EALsteps                                                     O       2006-12-31            1
             additional         progress in English as an                         details 2006 available at
             language           Additional Langage based on                       http://www.teachernet.gov.
                                QCA Steps: S1 (Step 1), S2                        uk/management/ims/datam
                                (Step 2), 1T (Level 1
                                                                                  anagement/cbds/CBDSspe
                                Threshold), 1S (Level 1
                                Secure).
                                                                                  cs/
    100053 Family structure      Indicates type of family        A(1)             Family                                    S          Family                                                       O       2006-01-31            1
                                 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            1
           Protection            sibling on the Child Protection
           Register              Register
    100055 Number of             Number of previous schools      99                                                         S          PreviousSchools                                              O       2006-01-31            1
           previous schools      derived from school history
                                 module
    100056 Pregnant pupil                                        A(5)             1, 0 or true, false                       S          Pregnancy                                                    O       2006-01-31            1
           indicator
    100057 Uniform               Indicates if pupil is paid a       A(5)          1, 0 or true, false                       S          UniformAllowance                                             O       2006-01-31            1
           allowance             uniform allowance
           indicator
    100058 Source of pupil                                          A(1)          Religion Source                           S          ReligionSource                                               O       2006-01-31            1
           religious affiliation
           code
    100059 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            1
                                                                               01 (this value will increment                                                     <NonEnglishWelshSystems> is
                                                                               each year)                                                                        false and/or <Refugee> is false.
                                                                                                                                                                 Must have a value if
                                                                                                                                                                 <NonEnglishWelshSystems> is
                                                                                                                                                                 true and/or <Refugee> is true.



    100330 Service Children      Indicates if a child has           A(5)          Service Child Indicator      false or 0   S          ServiceChild                                                 S       2006-12-31            1        18/01/2008
           in Education          parent(s) who are Service                                                                                                                                                                              School Census
           Indicator             personnel serving in regular                                                                                                                                                                                      08
                                 military units of all forces and
                                 exercising parental care and
                                 responsibility
    100331 Source for            Source of the service child        A(5)          Service Child Source                      S          ServiceChildSource                                           S       2006-12-31            1        18/01/2008
           Service Child         indicator                                                                                                                                                                                              School Census
           Indicator                                                                                                                                                                                                                               08




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                    Page 20 of 70                                                                                                 Date last updated: 1/7/2011
 Identifier Title                Description                      Format   Codeset                    Default   Allow      XML Tag   Validation Rules   Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                 Value     Multiple                                Level Created        Item         Date
 CBDS Ref                                                                                                       Entries?                                                     Status
 No)                                                                                                            (S, M)
 Pupil Characteristics
    100336 IDACI (Income         An identifier which links pupil's 9.99    A number between 0 and 1             S          IDACI                        O       2006-12-31            1
            Deprivation          postcode with an indicator of
            Affecting Children   socio economic factors as
            Index)               used in contextual value
                                 added in the Achievement
                                 and Attainment Tables, PAT
                                 and RAISEonline.




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                        Page 21 of 70                                                                 Date last updated: 1/7/2011
Pupil Level: Pupil Characteristics Module Codesets

Ethnicity Source/Traveller Source/Religion Source                                           Usual mode of Travel
C                          Provided by the child (ie pupil)                                 WLK                      Walk
P                          Provided by the parent                                           CYC                      Cycle
S                          Ascribed by the current school                                   CAR                      Car/Van
T                          Ascribed by a previous school                                    CRS                      Car Share (with a child/children from a different
                                                                                                                     household)
O                           Other                                                           PSB                      Public service bus
                                                                                            DSB                      Dedicated school bus
                                                                                            BNK                      Bus (type not known)
Traveller/Gypsy Code                                                                        TXI                      Taxi
GH                          Gypsy/Roma (Housed)                                             TRN                      Train
GT                          Gypsy/Roma (Travelling)                                         LUL                      London Underground
OT                          Occupational Traveller                                          MTL                      Metro/Tram/Light Rail
TR                          Traveller (Other)                                               OTH                      Other
NT                          Not a Traveller

Religion V2.0                                                                               Language Type V2.0
BU                          Buddhist                                                        F                        First Language
CH                          Christian                                                       M                        Multiple First Language
HI                          Hindu                                                           H                        Home
JE                          Jewish                                                          T                        Tuition
MU                          Muslim                                                          S                        Second Language
NO                          No religion                                                     C                        Correspondence language
OT                          Other religion
SI                          Sikh                                                            In care type
RF                          Refused                                                         FT                       Fostered
                                                                                            CH                       Children's Home
                                                                                            WP                       With parents
Connexions Agreement                                                                        PA                       Placed for adoption
Yes                         Permission has been given by the parent or guardian             OT                       Other
No                          Parent or guardian has refused permission

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

                                                                                            S
First Language                                                                              A                        2 adults
ENG                         English                                                         F                        Foster parents
ENB                         Not known but believed to be English                            C                        In residential care
OTH                         Other than English                                              U                        Unknown
OTB                         Not known but believed to be other than English
REF                         Refused
NOT                         Information not obtained




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                             Page 22 of 70                                                       Date last updated: 1/7/2011
Pupil Level: Pupil Characteristics Module Codesets



Service Child Indicator
Y                         Yes
N                         No
U                         Unknown
R                         Refused


Service Child Source
C                         Provided by the child (ie pupil)
P                         Provided by the parent
S                         Ascribed by the current school
O                         Other




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                     Page 23 of 70   Date last updated: 1/7/2011
  3 Pupil Status
 Identifier Title              Description                     Format      Codeset                          Default   Allow      XML Tag       Validation Rules                Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                       Value     Multiple                                                 Level Created        Item         Date
 CBDS Ref                                                                                                             Entries?                                                                      Status
 No)                                                                                                                  (S, M)
 Pupil Status
    100060 Pupil/child         Enrolment status of a           A(1)        Pupil Enrolment Status           C         S          EnrolStatus                                   S       2000-10-10            1
              Enrolment status pupil/child using one of the
                               registration codes supplied in
                               the codeset
    100061 Other School LA The LA code of the other            A(3)        LEALIST_V3                                 S          LEA           Must be blank if <EnrolStatus> = S      2006-12-31            1
              number           school(s) for dually registered                                                                                 C
                               pupils                                                                                                          Must not be blank if
                                                                                                                                               <EnrolStatus> = M or S
    100062 Other School        The DfES establishment code A(4)            Establishment list - This file             S          Estab         Must be blank if <EnrolStatus> = S      2006-12-31            1
           DfES                of the other school(s) for                  is too large to be offered as                                       C
           Establishment       dually registered pupils                    a download; please request                                          Must not be blank if
           Number                                                          a copy by email from                                                <EnrolStatus> = M or S
                                                                                                                                               0001-0900 Secure Units &
                                                                           ChangeControl.CBDS@dfe
                                                                                                                                               Miscellaneous; 0940-0949
                                                                           s.gsi.gov.uk                                                        Playing for Success Centres;
                                                                                                                                               1000-1099 LA Nursery Schools;
                                                                                                                                               1100-1149 Pupil 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.
    100063 Pupil Date of       Date of entry to current school CCYY-MM-DD Any valid date                              S          EntryDate     8713 for Nottingham Trent        C      2000-10-10            1
           entry
    100064 Pupil Date of       Date of the last day pupil is on CCYY-MM-DD Any valid date                             S          LeavingDate                                   S       2006-12-31            1
           Leaving             roll at current school




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                              Page 24 of 70                                                                                  Date last updated: 1/7/2011
 Identifier Title               Description                      Format   Codeset                         Default   Allow      XML Tag             Validation Rules                 Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                     Value     Multiple                                                        Level Created        Item         Date
 CBDS Ref                                                                                                           Entries?                                                                             Status
 No)                                                                                                                (S, M)
 Pupil Status
    100065 Pupil Part-time      Indicates whether a pupil is  A(5)        1,0 or true, false              false     S          PartTime                                             S       2004-12-01            1
              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 Pupil - Number of Number of pupil sessions (half 99            A number between 1 and 10                 S          Sessions            If <PartTime> = 0 or false and S         2006-12-31            1
           sessions          days) per week                                                                                                        <EnrolStatus> = C then must be
                                                                                                                                                   10.
                                                                                                                                                   If <PartTime> = 1 or true or
                                                                                                                                                   <EnrolStatus> = M or S then
                                                                                                                                                   must be in the range 1-9.
    100067 Pupil Boarder        Indicates whether a pupil is a   A(1)     Pupil Boarder                   N         S          Boarder             If <PartTime> = true then      S         2000-10-10            1
           Indicator            boarder or not                                                                                                     <Boarder> must be N or missing

    100068 Pupil's Actual       The year group in which the      A(2)     NC Year Group                   Default to S         NCyearActual        If not "X", must be in range (age C      2000-10-10            1
           National             pupil is taught for the majority                                          N1 if age =                              minus 6) to (age minus 2) if age
           Curriculum Year      of their time, regardless of                                              2 or below.                              greater than 6.
           Group                their 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
                                                                                                          3.                                       age = 5.
                                                                                                          Default to                               Must be N1, N2, R, 1 or 2 if age
                                                                                                          R if age =                               = 4.
                                                                                                          4.                                       Must be N1, N2, R or 1 if age =
                                                                                                          Default to                               3.
                                                                                                          (age                                     Must be N1, N2 or R if age = 2.
                                                                                                          minus 4) if                              (All ages are as at previous 31
                                                                                                          age                                      August).
                                                                                                          greater
                                                                                                          than 4.


    100069 Pupil Class Type Indicates if the pupil is in a       A(1)     Class Type                      O         S          ClassType           Should be O or X if age at       S       2005-04-30            1                    17/01/2008
           Indicator        nursery or special class/unit                                                                                          previous 31 August>=6                                                               School
                                                                                                                                                   Must be N or O if                                                                   Census 08
                                                                                                                                                   <SENprovision> = N
    100325 Pupil Class Type     Indicates if the pupil is in a   A(1)     Class Type (V2.0)               O         S          TypeOfClass         Should be O if age at previous   S       2006-12-31            1
           Indicator            nursery class                                                                                                      31 August>=6
    100070 Pupil Registration   Name of pupil's registration     A(30)    Any character string                      S          RegistrationGroup                                    O       2000-10-10            1
           Group                group

    100071 Pupil Email          Pupil's email address            A(254)   string1@string2                           S          Email                                                O       2000-10-10            1
           Address                                                        string1 and string2 may
                                                                          include any characters except
                                                                          @
    100072 Leaving              Pupil's destination on leaving   A(2)                                               S          Destination                                          O       2006-12-31            3
           destination          the school
    100073 Name of leaving      Name of institution/employer     A(100)   Any character string                      S          DestinationName                                      O       2006-01-31            1
           destination          of pupil's destination




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                             Page 25 of 70                                                                                        Date last updated: 1/7/2011
 Identifier Title         Description                      Format   Codeset               Default   Allow      XML Tag             Validation Rules   Item Date            Data         Implementation    Cut-off Date
 (New                                                                                     Value     Multiple                                          Level Created        Item         Date
 CBDS Ref                                                                                           Entries?                                                               Status
 No)                                                                                                (S, M)
 Pupil Status
    100317 Pupil/Child    Indicates that the pupil is on   A(1)     true, false or 0, 1             S          EducatedElsewhere                      C       2006-12-31            1        01/03/2007
              Educated    the PRU's register, but is                                                                                                                                          PRU Pilot
              Elsewhere   attending all or part of their
                          time at an FE college or
                          voluntary provider




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                            Page 26 of 70                                                                           Date last updated: 1/7/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


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



ClassType v(2.0)
N          Nursery Class
O          Not a Nursery Class




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                   Page 27 of 70   Date last updated: 1/7/2011
  4 Special Educational Needs
 Identifier Title                 Description                     Format        Codeset                     Default      Allow      XML Tag                     Validation Rules                 Item Date            Data         Implementation    Cut-off Date
 (New                                                                                                       Value        Multiple                                                                Level Created        Item         Date
 CBDS Ref                                                                                                                Entries?                                                                                     Status
 No)                                                                                                                     (S, M)
 Special Educational Needs
    100074 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> = C       2004-12-10            2        19/01/2006     2006-12-31
            Unit, special class   a mainstream school is a                                                                                                      N or A                                                               School Census
            or resourced          member of an SEN Unit,                                                                                                        Must be true if <ClassType> = S                                                 06
            provision             special class or resourced                                                                                                    or X
                                  provision                                                                                                                     Must be false if <ClassType> = N
                                                                                                                                                                or O
    100075 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            1        21/01/2007
           Unit (sometimes   a mainstream school is a                                                                                                                                                                                School Census
           called special    member of an SEN Unit                                                                                                                                                                                              07
           class) indicator  (sometimes called special
                             class)
    100076 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            1        21/01/2007
           resourced         a mainstream school is a                                                                               or                                                                                               School Census
           provision         member of a resourced                                                                                                                                                                                              07
           indicator         provision
    100077 SEN Provision     Provision types under the            A(1)          Pupil SEN Provision         N            S          SENprovision                                                 C       2004-05-31            1
                             SEN Code of Practice
    100078 Pupil date placed Date placed on current SEN           CCYY-MM-DD Any valid date after current                S          StartDate                   Must be present if               S       2000-10-10            1
           upon stage        stage                                           date                                                                               <SENprovision> is not N

    100079 Pupil date of next Date of pupil's next SEN            CCYY-MM-DD Any valid date after                        S          NextReviewDate              Must be present if <StartDate> is S      2000-10-10            1
           SEN review         review                                         <StartDate>                                                                        present
    100080 Pupil SEN Type                                         99         Integer from 1 in order of                  S          SENtypeRank                 SEN Type ranking must be          S      2006-12-31            1
           ranking                                                           significance of special                                                            unique, a pupil cannot have 2 or
                                                                             educational need                                                                   more SEN types of the same
                                                                                                                                                                rank.
                                                                                                                                                                Cannot be 2 if there is no
                                                                                                                                                                <SENtypeRank> = 1.
                                                                                                                                                                Cannot be 3 if no
                                                                                                                                                                <SENtypeRank>=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 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            1
           code                   educational need.                                                                                                             <SENprovision> not N
    100082 National                                               A(1)          M (National Curriculum                   S          Modification                                                 S       2000-08-11            1
           Curriculum                                                           modified) or N (National
           Modification or                                                      Curriculum disapplied)
           Dissapplication
    100083 National               National Curriculum subject                                                            M                                                                       S       2004-05-31            1
           Curriculum             for which modification or
           Subject                disapplication applies

    100084 Pupil Medical          Indicates whether there is      A(5)          1,0 or true, false                       S          MedicalFlag                                                  C       2004-05-31            1
           Flag                   medical information on a pupil.




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                 Page 28 of 70                                                                                                 Date last updated: 1/7/2011
 Identifier Title              Description                   Format   Codeset                        Default   Allow      XML Tag              Validation Rules   Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                Value     Multiple                                           Level Created        Item         Date
 CBDS Ref                                                                                                      Entries?                                                                Status
 No)                                                                                                           (S, M)
 Special Educational Needs
    100085 Pupil Medical                                     A(60)                                             M          Medical              No validation      O       2006-01-31            1
            Condition/ Notes

    100086 Paramedical         Type of therapy pupil needs   A(1)     P (Physiotherapy), S (Speech             M          ParamedicalSupport                      O       2006-01-31            1
           support                                                    therapy), O (Occupational
                                                                      therapy)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                       Page 29 of 70                                                                            Date last updated: 1/7/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




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                  Page 30 of 70   Date last updated: 1/7/2011
  5 Exclusions
 Identifier Title             Description                   Format       Codeset                         Default   Allow      XML Tag     Validation Rules                 Item Date            Data     Implementation    Cut-off Date
 (New                                                                                                    Value     Multiple                                                Level Created        Item     Date
 CBDS Ref                                                                                                          Entries?                                                                     Status
 No)                                                                                                               (S, M)
 Exclusions
    100087 Exclusion          For each exclusion, type of   A(4)         FIXD (Fixed), PERM                        M          Category                                     C       2006-01-31        1
           Category           exclusion                                  (Permanent), LNCH
                                                                         (Lunchtime)
    100088 Exclusion          For each exclusion, reason for A(2)        Pupil Exclusion Reason                    M          Reason                                       C       2003-07-18        1
           Reason             exclusion
    100089 Exclusion Start    For each exclusion, exclusion CCYY-MM-DD Valid date before or on current             M          StartDate   Definition to cease 31/08/2005 C         2005-04-30        1                       2006-08-31
           Date               start date (the day the pupil‟s          date                                                               Must be blank if <AppealResult>
                              name has been removed from                                                                                  =R
                              the school roll).                                                                                           Must be same as <LeavingDate>
                                                                                                                                          for permanent exclusion (but
                                                                                                                                          only after appeal)



    100090 Exclusion Start    For each exclusion, Exclusion CCYY-MM-DD Valid date before or on current             M          StartDate                                    C       2006-12-31        1        2006-09-01
           Date               Start Date (irrespective of any          date
                              review or appeal) will be the
                              day after the date the pupil is
                              asked to leave the school by
                              the Head teacher . 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 Exclusion Start    For each exclusion, Exclusion A(2)       AM or PM                                    M          Session                                      O       2000-10-10        1
           (am/pm)            Start session
    100092 Exclusion End      For each exclusion,           CCYY-MM-DD Valid date after Exclusion                  M          EndDate     Must be blank if                 S       2000-10-10        1
           Date               Exclusion End Date                       Start Date                                                         <AppealResult> = R and/or
                                                                                                                                          <Category> = PERM
    100093 Exclusion Actual   For each exclusion, number of 99                                                     M          Sessions    If <Category> = FIXD or LNCH     C       2005-04-30        1
           Number of          sessions for which the                                                                                      <Sessions> must be present
           Sessions           exclusion is in effect. For                                                                                 <Sessions> should be less than
                              lunchtime exclusions, each                                                                                  or equal to 90
                              lunchtime for which the                                                                                     <Sessions> should not be
                              exclusion applies is one                                                                                    provided where <Category> =
                              session. For fixed term and                                                                                 PERM
                              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.)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                           Page 31 of 70                                                                             Date last updated: 1/7/2011
 Identifier Title              Description                  Format        Codeset                          Default   Allow      XML Tag                    Validation Rules                  Item Date            Data     Implementation   Cut-off Date
 (New                                                                                                      Value     Multiple                                                                Level Created        Item     Date
 CBDS Ref                                                                                                            Entries?                                                                                     Status
 No)                                                                                                                 (S, M)
 Exclusions
    100094 Exclusion Appeal Indicates an appeal against     A(5)          1,0 or true, false                         M          Appeal                                                       C       2004-12-01        1
           Indicator        permanent exclusion

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

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

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




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                             Page 32 of 70                                                                                             Date last updated: 1/7/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




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                         Page 33 of 70   Date last updated: 1/7/2011
  6 Home Information
 Identifier Title          Description                      Format        Codeset        Default   Allow      XML Tag       Validation Rules                  Item Date         Data     Implementation   Cut-off Date
 (New                                                                                    Value     Multiple                                                   Level Created     Item     Date
 CBDS Ref                                                                                          Entries?                                                                     Status
 No)                                                                                               (S, M)
 Home Information
    100102 Pupil Address   Indicates whether address        A(1)          Address Type             M          AddressType   A pupil may have multiple current S       2006-12-31 1
           Type            given is pupil's current,                                                                        addresses eg where they live
                           previous, in care or alternate                                                                   with one parent for part of the
                           address or address for                                                                           week and the other for the rest of
                           transport                                                                                        the week.
    100103 SAON            Flat, apartment name or        BS7666                                   S          SAON                                             S      2003-08-31 1
                           number or other sub-division   Secondary
                           of a dwelling                  Addressable
                                                          Object Name
                                                          A(100)
    100104 SAON Start      Start (single) dwelling number BS7666 SAON                              S          Number                                          S       2006-01-31 1
           Number                                         Start Number
                                                          9999

    100105 SAON Start      Start (single) dwelling number BS7666 SAON                              S          Suffix                                          S       2006-01-31 1
           Number Suffix   suffix                         Start Number
                                                          Suffix A(1)

    100106 SAON End        End dwelling number              BS7666 SAON                            S          Number                                          S       2006-01-31 1
           Number                                           End Number
                                                            9999

    100107 SAON End        End dwelling number suffix       BS7666 SAON                            S          Suffix                                          S       2006-01-31 1
           Number Suffix                                    End Number
                                                            Suffix A(1)

    100108 SAON            Dwelling name                                                           S          Description                                     S       2006-01-31 1
           Description                                    BS7666 SAON
                                                          Description
                                                          A(90)
    100109 PAON            Dwelling name and/or number BS7666                                      S          PAON                                            S       2000-10-10 1
                                                          Primary
                                                          Addressable
                                                          Object Name
                                                          A(100)
    100110 PAON Start      Start (single) dwelling number BS7666 PAON                              S          Number                                          S       2006-01-31 1
           Number                                         Start Number
                                                          Suffix A(1)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                           Page 34 of 70                                                                             Date last updated: 1/7/2011
 Identifier Title           Description                          Format           Codeset   Default   Allow      XML Tag              Validation Rules               Item Date         Data     Implementation   Cut-off Date
 (New                                                                                       Value     Multiple                                                       Level Created     Item     Date
 CBDS Ref                                                                                             Entries?                                                                         Status
 No)                                                                                                  (S, M)
 Home Information
    100111 PAON Start       Start (single) dwelling number BS7666 PAON                                S          Suffix                                              S       2006-01-31 1
           Number Suffix    suffix                         End Number
                                                           9999

    100112 PAON End         End dwelling number                  BS7666 PAON                          S          Number                                              S       2006-01-31 1
           Number                                                End Number
                                                                 9999

    100113 PAON End         End dwelling number suffix           BS7666 PAON                          S          Suffix                                              S       2006-01-31 1
           Number Suffix                                         End Number
                                                                 Suffix A(1)

    100114 PAON             Dwelling name                        BS7666 PAON                          S          Description                                         S       2006-01-31 1
           Description                                           Description

    100115 Street           Street name or street                BS7666 Street                        S          Street               May be missing for small       S       2005-04-30 1
                            description that has been            Description                                                          communities with no recognised
                            allocated to a street by the         A(100)                                                               street name
                            street naming authority
    100116 Locality         The locality name refers to a        BS7666                               S          Locality             At least one of <Locality>,    S       2005-04-30 1
                            neighbourhood, suburb,               Locality                                                             <Town> and
                            district, village, estate,           A(35)                                                                <AdministrativeArea> must be
                            settlement, or parish that may                                                                            present
                            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 Town             The town name refers to a city BS7666 Town                                S          Town                 At least one of <Locality>,    S       2005-04-30 1
                            or town that is not an         A(30)                                                                      <Town> and
                            administrative area, a suburb                                                                             <AdministrativeArea> must be
                            of an administrative area that                                                                            present
                            does not form part of another
                            town or a London district

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




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                              Page 35 of 70                                                                                 Date last updated: 1/7/2011
 Identifier Title            Description                    Format          Codeset                             Default   Allow      XML Tag                   Validation Rules                   Item Date         Data     Implementation    Cut-off Date
 (New                                                                                                           Value     Multiple                                                                Level Created     Item     Date
 CBDS Ref                                                                                                                 Entries?                                                                                  Status
 No)                                                                                                                      (S, M)
 Home Information
    100120 Postcode          The code allocated by the       BS7666         Valid Postcode formats are:                   M          Postcode                  Double spaces should be            S       2004-12-01 2                           2006-01-19
                             Post Office to identify a group Postcode       A9 9AA                                                                             converted to a single space;
                             of postal delivery points       A(8)           A99 9AA                                                                            convert any 'O' at start of second
                                                                            AA9 9AA                                                                            postcode block to '0' (zero).
                                                                            AA99 9AA
                                                                            A9A 9AA
                                                                            AA9A 9AA
                                                                            Plus BFPO 999

    100121 Postcode          The code allocated by the       BS7666         Valid Postcode formats are:                   S          Postcode                  Double spaces should be             S      2006-01-31 1            19/01/2006
                             Post Office to identify a group Postcode       A9 9AA                                                                             converted to a single space;                                    School Census
                             of postal delivery points       A(8)           A99 9AA                                                                            convert any 'O' at start of second                                         06
                                                                            AA9 9AA                                                                            postcode block to '0' (zero); Q, V
                                                                            AA99 9AA                                                                           and X are not used in the first
                                                                            A9A 9AA                                                                            position; I, J and Z are not used
                                                                            AA9A 9AA                                                                           in the second position; only A, B,
                                                                            Plus BFPO 999                                                                      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.


    100122 UPRN              A unique identifier for each   BS7666          Positive integer minimum                      M          UPRN                                                         O       2000-10-10 2                           2006-01-31
                             land and property unit.        Unique          length of 1 digit and maximum
                                                            Property        length of 12 digits in the range
                                                            Reference       1-999999999999
                                                            Number
                                                            999999999999

    100123 Unique Property   A unique identifier for each   BS7666          Positive integer minimum                      S          UniquePropertyReference                                      O       2006-01-31 1            2006-01-31
           Reference         land and property unit.        Unique          length of 1 digit and maximum                            Number
           Number                                           Property        length of 12 digits digits in the
                                                            Reference       range 1-999999999999
                                                            Number
                                                            999999999999

    100124 Unique Street     A unique identifier for each   BS7666          Positive integer minimum                      M          USRN                                                         O       2000-10-10 2                           2006-01-31
           Reference         street                         Unique Street   length of 1 digit and maximum
           Number                                           Reference       length of 8 digits digits in the
                                                            Number          range 1-99999999
                                                            999999999999

    100125 Unique Street     A unique identifier for each   BS7666          Positive integer minimum                      S          Unique Street Reference                                      O       2006-01-31 1            2006-01-31
           Reference         street                         Unique Street   length of 1 digit and maximum                            Number
           Number                                           Reference       length of 8 digits digits in the
                                                            Number          range 1-99999999
                                                            99999999




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                  Page 36 of 70                                                                                          Date last updated: 1/7/2011
 Identifier Title             Description                    Format          Codeset                          Default   Allow      XML Tag           Validation Rules                  Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                         Value     Multiple                                                       Level Created        Item         Date
 CBDS Ref                                                                                                               Entries?                                                                            Status
 No)                                                                                                                    (S, M)
 Home Information
    100126 Property Easting  Easting coordinate for          999999.9                                                   S          Easting                                             O       2006-12-31 1
                             mapping an address
    100127 Property Northing Northing coordinate for         999999.9                                                   S          Northing                                            O       2006-12-31 1
                             mapping an address
    100334 OSAPR             OSAPR is the Ordnance           A(18)                                                      S          OSAPR             The first two characters of any   O       2006-12-31            1
                             Survey Address-Point                                                                                                    OSAPR are always 'AP'.
                             Reference. Each address has
                             an OSAPR, which is a unique
                             reference to that address and
                             is included in the OS file made
                             available to suppliers for
                             address validation purposes.


    100128 Address Line 1     First Line of Address          Line Address    No validation. Included                    S          AddressLine1                                        S       2006-01-31 1
                                                             Format          temporarily to facilitate data
                                                             A(35)           transfer pending BS7666
                                                                             compliance.
    100129 Address Line 2     Second Line of Address         Line Address    No validation. Included                    S          AddressLine2                                        S       2006-01-31 1
                                                             Format          temporarily to facilitate data
                                                             A(35)           transfer pending BS7666
                                                                             compliance.
    100130 Address Line 3     Third Line of Address          Line Address    No validation. Included                    S          AddressLine3                                        S       2006-01-31 1
                                                             Format          temporarily to facilitate data
                                                             A(35)           transfer pending BS7666
                                                                             compliance.
    100131 Address Line 4     Fourth Line of Address         Line Address    No validation. Included                    S          AddressLine4                                        S       2006-01-31 1
                                                             Format          temporarily to facilitate data
                                                             A(35)           transfer pending BS7666
                                                                             compliance.
    100132 Address Line 5     Fifth Line of Address          Line Address    No validation. Included                    S          AddressLine5                                        S       2006-01-31 1
                                                             Format          temporarily to facilitate data
                                                             A(35)           transfer pending BS7666
                                                                             compliance.
    100133 International      First Line of International    BS7666                                                     S          IntAddressLine1                                     S       2006-01-31 1
           Address Line 1     Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100134 International      Second Line of International   BS7666                                                     S          IntAddressLine2                                     S       2006-01-31 1
           Address Line 2     Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100135 International      Third Line of International    BS7666                                                     S          IntAddressLine3                                     S       2006-01-31 1
           Address Line 3     Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100136 International      Fourth Line of International   BS7666                                                     S          IntAddressLine4                                     S       2006-01-31 1
           Address Line 4     Address                        International
                                                             Address
                                                             Format
                                                             A(35)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                Page 37 of 70                                                                                        Date last updated: 1/7/2011
 Identifier Title           Description                   Format          Codeset   Default   Allow      XML Tag           Validation Rules   Item Date         Data     Implementation   Cut-off Date
 (New                                                                               Value     Multiple                                        Level Created     Item     Date
 CBDS Ref                                                                                     Entries?                                                          Status
 No)                                                                                          (S, M)
 Home Information
    100137 International    Fifth Line of International   BS7666                              S          IntAddressLine5                      S       2006-01-31 1
           Address Line 5   Address                       International
                                                          Address
                                                          Format
                                                          A(35)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                      Page 38 of 70                                                                  Date last updated: 1/7/2011
 Identifier Title              Description                    Format         Codeset                          Default   Allow      XML Tag                 Validation Rules   Item Date         Data     Implementation   Cut-off Date
 (New                                                                                                         Value     Multiple                                              Level Created     Item     Date
 CBDS Ref                                                                                                               Entries?                                                                Status
 No)                                                                                                                    (S, M)
 Home Information
    100138 International Post Post Code of International     BS7666                                                     S          InternationalPostCode                      S       2006-01-31 1
           Code               Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100139 ISO 3166-1 Alpha- 3 digit alphabetic country code A(3)            Nation states and countries                S          CountryCodeAlpha3                          S       2006-01-31 1
           3 Code                                                            v3.0 (consistent with GDSC
                                                                             requirement to use BSEN
                                                                             3166 (ISO 3166-1))
                                                                             available at
                                                                             http://www.teachernet.gov.
                                                                             uk/docbank/index.cfm?id=1
                                                                             0434
    100140 ISO 3166-1 Alpha- 2 digit alphabetic country code A(2)            Nation states and countries                S          CountryCodeAlpha2                          S       2006-01-31 1
           2 Code                                                            v3.0 (consistent with GDSC
                                                                             requirement to use BSEN
                                                                             3166 (ISO 3166-1))
                                                                             available at
                                                                             http://www.teachernet.gov.
                                                                             uk/docbank/index.cfm?id=1
                                                                             0434
    100141 ISO 3166-1          3 digit numeric country code   999            Nation states and countries                S          CountryCodeNumeric3                        S       2006-01-31 1
           Numeric-3 Code      999                                           v3.0 (consistent with GDSC
                                                                             requirement to use BSEN
                                                                             3166 (ISO 3166-1))
                                                                             available at
                                                                             http://www.teachernet.gov.
                                                                             uk/docbank/index.cfm?id=1
                                                                             0434
    100142 ISO 3166-1 Short Short country name                A(45)          Nation states and countries                S          CountryCodeNameShort                       S       2006-12-31 1
           Country Name                                                      v3.0 (consistent with GDSC
                                                                             requirement to use BSEN
                                                                             3166 (ISO 3166-1))
                                                                             available at
                                                                             http://www.teachernet.gov.
                                                                             uk/docbank/index.cfm?id=1
                                                                             0434
    100143 ISO 3166-1 Long Long country name                  A(55)          Nation states and countries                S          CountryNameLong                            S       2006-01-31 1
           Country Name                                                      v3.0 (consistent with GDSC
                                                                             requirement to use BSEN
                                                                             3166 (ISO 3166-1))
                                                                             available at
                                                                             http://www.teachernet.gov.
                                                                             uk/docbank/index.cfm?id=1
                                                                             0434
    100144 Telephone Type      Type of phone for which        A(1)                                                      M          PhoneType                                  O       2004-12-01 2
                               number is provided
    100323 Telephone Type      Type of phone for which        A(1)           Telephone Type                             M          TelephoneType                              O       2006-12-31 1
                               number is provided
    100145 Telephone           Pupil's home telephone         A(35)          Valid characters are 0-9 and a             M          PhoneNo                                    O       2004-12-10 1
           Number              number                                        leading '+' (for international
                                                                             numbers)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                Page 39 of 70                                                                        Date last updated: 1/7/2011
 Identifier Title          Description     Format       Codeset        Default   Allow      XML Tag            Validation Rules   Item Date         Data     Implementation   Cut-off Date
 (New                                                                  Value     Multiple                                         Level Created     Item     Date
 CBDS Ref                                                                        Entries?                                                           Status
 No)                                                                             (S, M)
 Home Information
    100146 Start date at                   CCYY-MM-DD Any valid date             M          AddressStartDate                      O       2006-01-31 1
           address
    100147 End date at                     CCYY-MM-DD Any valid date             M          AddressEndDate                        O       2006-01-31 1
           address




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                         Page 40 of 70                                                                   Date last updated: 1/7/2011
Pupil Level: Home Information Module Codesets
Telephone Type
F          Fax
H          Home
A          Alternate Home
M          Mobile
W          Work
D          Minicom (hearing impaired/disabled)



Address Type
C         Current - address where pupil is normally
          resident
P         Previous - default type for any
            current address superseded 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
M           Mailing - address for mailing
  7 Home Location Context
 Identifier Title              Description                  Format    Codeset                        Default   Allow      XML Tag            Validation Rules                 Item Date            Data     Implementation   Cut-off Date
 (New                                                                                                Value     Multiple                                                       Level Created        Item     Date
 CBDS Ref                                                                                                      Entries?                                                                            Status
 No)                                                                                                           (S, M)
 Home Location Context
    100148 Enumeration         National Population Census                                                      S          CensusDistrict                                      O       2000-10-10
           district            Enumeration District
                                                                                                                                                                                                   1
    100149 LA Electoral        ONS Ward Code                99AAAA    http://www.statistics.gov.uk             S          WardCode           Must be equal to first 6         O       2006-01-31
           Ward Code                                                  /geography/geographic_are                                              characters of <CensusDistrict>
                                                                      a_listings/                                                                                                                  1
    100150 LA Electoral        ONS Ward Name                A(40)     http://www.statistics.gov.uk             S          Ward                                                O       2006-02-01
           Ward Name                                                  /geography/geographic_are
                                                                      a_listings/                                                                                                                  1
    100151 Parliamentary       ONS Parliamentary            999       http://www.statistics.gov.uk             S          ConstituencyCode   001-529 England                  O       2006-12-31
           Constituency        Constituency Code                      /geography/geographic_are                                              530-569 Wales
           Code                                                       a_listings/electoral.asp                                               801-859 Scotland
                                                                                                                                             701-718 Northern Ireland                              1
    100152 Parliamentary       ONS Parliamentary            A(45)     http://www.statistics.gov.uk             S          Constituency                                        O       2006-12-31
           Constituency        Constituency Name                      /geography/geographic_are
           Name                                                       a_listings/electoral.asp
                                                                                                                                                                                                   1
    100153 Parish Council      ONS Parish Council Name      A(70)     http://www.statistics.gov.uk             S          Parish                                              O       2006-12-31
                                                                      /geography/geographic_are
                                                                      a_listings/administrative.as
                                                                      p#10                                                                                                                         1
    100154 Church of       Church Dioceses - CofE           A(3)      Church dioceses available                S          CofEdiocese                                         O       2000-10-10
           England Diocese                                            at
                                                                      http://www.teachernet.gov.
                                                                      uk/docbank/index.cfm?id=6
                                                                      844                                                                                                                          1
    100155 Church of           Church Parish - CofE         A(50)                                              S          CofEparish         No validation                    O       2000-10-10
           England Parish                                                                                                                                                                          1
    100156 Roman Catholic      Church Dioceses - RC         A(3)      Church dioceses available                S          RCdiocese                                           O       2000-10-10
           Diocese                                                    at
                                                                      http://www.teachernet.gov.
                                                                      uk/docbank/index.cfm?id=6
                                                                      844                                                                                                                          1
    100157 Roman Catholic      Church Parish - RC           A(50)                                              S          RCparish           No validation                    O       2000-10-10
           Parish                                                                                                                                                                                  1
    100158 Learning & Skills   LSC Area code                A(3)      LSC Area list available at               S          LSCcode                                             A       2004-05-31
           Council Code                                               http://www.teachernet.gov.
                                                                      uk/docbank/index.cfm?id=8
                                                                      892                                                                                                                          1
    100159 Catchment area      Text describing school       A(3000)                                            S          CatchmentArea      No validation                    O       2006-01-31
                               catchment area                                                                                                                                                      1




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                       Page 42 of 70                                                                                    Date last updated: 1/7/2011
  8 Contact Information
 Identifier Title              Description                       Format   Codeset                         Default   Allow      XML Tag                 Validation Rules                  Item Date            Data         Implementation    Cut-off Date
 (New                                                                                                     Value     Multiple                                                             Level Created        Item         Date
 CBDS Ref                                                                                                           Entries?                                                                                  Status
 No)                                                                                                                (S, M)
 Contact Information
    100160 Contact Priority    Priority order in which to call   99       1-10                                      M          Order                                                     C       2005-04-30            1
                               contact names provided                     2 or more contacts may
                                                                          have equal priority order
    100161 Contact Title       Title of contact                  A(35)    If any of: Mr, Mrs, Ms, Miss,             M          Title                                                     C       2006-01-31            1
                                                                          Rev, Fr, Dr, Prof, Hon, Sir,
                                                                          Lord, Lady, must be as
                                                                          shown, otherwise free text.

    100162 Contact Last        Surname of contact                A(35)    Any character string                      M          Surname                                                   C       2000-10-10            1
           Name
    100163 Contact First       First name of contact             A(35)    Any character string                      M          Forename                                                  C       2000-10-10            1
           Name
    100164 Contact Middle      Middle name of contact            A(35)    Any character string                      M          MiddleNames             Components should be              O       2000-10-10            1
           Name                                                                                                                                        separated by a single space
    100165 Contact Gender      Gender of contact                 A(1)     M or F for Male and Female                M          Gender                                                    C       2000-10-10            1

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

    100328 Contact             Relationship of pupil to contact A(3)      Relationship V2.0                         M          ContactRelationship     There must be a pupil Contact     C       2006-01-31            1
           Relationship to     (Carer is defined in the DfES                                                                                           record for the Social Worker if
           pupil/child         SEN glossary)                                                                                                           <InCare> = true

    100329 Contact             Relationship of pupil to contact A(3)      SIF Relationship                          M          RelationshipToLearner   There must be a pupil Contact     C       2006-01-31            1        2006-11-01
           Relationship to                                                                                                                             record for the Social Worker if
           pupil/child                                                                                                                                 <InCare> = true
           (extended list as
           used in SIF Data
           Model)
    100167 Contact             Does the contact have              A(5)    1,0 or true, false                        M          Responsibility                                            C       2000-10-10            1
           Responsibility to   responsibility for pupil?
           Pupil               (Parent' and 'parental
                               responsibility' are defined in the
                               Guidance on Schools,
                               “Parents” and “Parental
                               Responsibility”)
    100168 Contact Member      Is the contact a member of the    A(5)     1,0 or true, false                        M          ArmedForces             Must not be blank if             O        2000-10-10            1
           of Armed Forces     armed forces?                                                                                                           <Relationship> = P?? (ie parent)
           Indicator                                                                                                                                   Must be blank if <Relationship>
                                                                                                                                                       is not = P?? (ie non-parent)



    100169 Contact             Does the contact need a           A(5)     1,0 or true, false                        M          Translator              Must not be blank if              O       2000-10-10            1
           Translator or       translator or interpreter?                                                                                              <Relationship> = P?? or CAR
           Interpreter
           Indicator
    100170 Contact             Contact's language                A(4)     Language code list                        M          Language                Must not be blank if              O       2000-10-10            2
           Language Code                                                                                                                               <Translator> = Y




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                            Page 43 of 70                                                                                              Date last updated: 1/7/2011
 Identifier Title            Description                        Format          Codeset                     Default   Allow      XML Tag       Validation Rules       Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                       Value     Multiple                                        Level Created        Item         Date
 CBDS Ref                                                                                                             Entries?                                                             Status
 No)                                                                                                                  (S, M)
 Contact Information
    100171 Contact           Contact's language                 A(4)            Language code list (V2)               M          Language      Must not be blank if   O       2006-01-31            1
           Language Code     (incorporating First                               available at                                                   <Translator> = Y
                             Language (P50) code set)                           http://www.teachernet.gov
                                                                                .uk/docbank/index.cfm?id
                                                                                =9525
    100172 Contact Email     Contact's email address            A(254)          string1@string2                       M          Email                                O       2000-10-10            1
           Address                                                              string1 and string2 may
                                                                                include any characters
                                                                                except @
    100173 Contact Address   Indicates whether address          A1              Address Type                          M          AddressType                          S       2006-01-31            1
           Type              given is contact's current
                             address or address for mail
                             only
    100174 SAON              Contact's address: Flat,           BS7666                                                S          SAON                                 S       2000-10-10            1
                             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 SAON                                           S          Number                               S       2006-01-31            1
           Number                                               Start Number
                                                                9999

    100176 SAON Start        Start (single) dwelling number     BS7666                                                S          Suffix                               S       2006-01-31            1
           Number Suffix     suffix                             SAON Start
                                                                Number suffix
                                                                A(1)

    100177 SAON End          End dwelling number                BS7666 SAON                                           S          Number                               S       2006-01-31            1
           Number                                               End Number
                                                                9999

    100178 SAON End          End dwelling number suffix         BS7666 SAON                                           S          Suffix                               S       2006-01-31            1
           Number Suffix                                        End Number
                                                                Suffix
                                                                A(1)

    100179 SAON              Dwelling name                      BS7666                                                S          Description                          S       2006-01-31            1
           Description                                          SAON
                                                                Description
                                                                A(90)
    100180 PAON              Contact's address: Dwelling        BS7666                                                S          PAON                                 S       2000-10-10            1
                             name and/or number                 Primary
                                                                Addressable
                                                                Object Name
                                                                A(100)
    100181 PAON Start        Start (single) dwelling number     BS7666 PAON                                           S          Number                               S       2006-01-31            1
           Number                                               Start Number
                                                                9999

    100182 PAON Start        Start (single) dwelling number     BS7666v2.0                                            S          Suffix                               S       2006-01-31            1
           Number Suffix     suffix                             PAON Start
                                                                Number Suffix
                                                                A(1)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                              Page 44 of 70                                                                         Date last updated: 1/7/2011
 Identifier Title           Description                      Format           Codeset   Default   Allow      XML Tag              Validation Rules   Item Date            Data         Implementation   Cut-off Date
 (New                                                                                   Value     Multiple                                           Level Created        Item         Date
 CBDS Ref                                                                                         Entries?                                                                Status
 No)                                                                                              (S, M)
 Contact Information
    100183 PAON End         End dwelling number              BS7666v2.0                           S          Number                                  S       2006-01-31            1
           Number                                            PAON End
                                                             Number
                                                             9999
    100184 PAON End         End dwelling number suffix       BS7666 PAON                          S          Suffix                                  S       2006-01-31            1
           Number Suffix                                     End Number
                                                             Suffix
                                                             A(1)

    100185 PAON             Dwelling name                    BS7666 PAON                          S          Description                             S       2006-01-31            1
           Description                                       Description
                                                             A(90)

    100186 Street           Contact's address: Street name BS7666 Street                          S          Street                                  S       2000-10-10            1
                            or street description that has Descriptor
                            been allocated to a street by  A(100)
                            the street naming authority

    100187 Locality         Contact's address: The        BS7666                                  S          Locality                                S       2006-01-31            1
                            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 Town             Contact's address: The town      BS7666 Town                          S          Town                                    S       2006-01-31            1
                            name refers to a city or town    A(30)
                            that is not an administrative
                            area, a suburb of an
                            administrative area that does
                            not form part of another town or
                            a London district

    100189 Administrative   Contact's address: The           BS7666                               S          AdministrativeArea                      S       2006-01-31            1
           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 Post Town        Contact's address: Post Office BS7666 Post                            S          PostTown                                S       2000-10-10            1
                            usually assigns these based on Town
                            Sorting Office                 A(30)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                          Page 45 of 70                                                                            Date last updated: 1/7/2011
 Identifier Title             Description                       Format        Codeset                         Default   Allow      XML Tag                   Validation Rules                   Item Date            Data         Implementation    Cut-off Date
 (New                                                                                                         Value     Multiple                                                                Level Created        Item         Date
 CBDS Ref                                                                                                               Entries?                                                                                     Status
 No)                                                                                                                    (S, M)
 Contact Information
    100191 Postcode           Contact's address: The code       BS7666                                                  M          Postcode                  Double spaces should be            S       2000-10-10            2                       2006-01-19
                              allocated by the Post Office to   Postcode                                                                                     converted to a single space;
                              identify a group of postal        A(8)                                                                                         convert any 'O' at start of second
                              delivery points                                                                                                                postcode block to '0' (zero).



    100192 Postcode           Contact's address: The code       BS7666                                                  S          PostCode                  Double spaces should be             S      2006-01-31            1        19/01/2006
                              allocated by the Post Office to   Postcode                                                                                     converted to a single space;                                           School Census
                              identify a group of postal        A(8)                                                                                         convert any 'O' at start of second                                                06
                              delivery points                                                                                                                postcode block to '0' (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 Unique Property                                      BS7666 UPRN Positive integer minimum                    M          UPRN                                                         O       2006-12-31            2                       2006-01-31
           Reference                                            999999999   length of 1 digit and
           number                                                           maximum length of 9 digits

    100194 UPRN               A unique identifier for each land BS7666 UPRN Positive integer minimum                    S          UniquePropertyReference                                      O       2006-01-31            1        2006-01-31
                              and property unit.                999999999999 length of 1 digit and                                 Number
                                                                             maximum length of 12 digits

    100195 Unique Street                                        99999999      Positive integer in the range             M          USRN                                                         O       2000-10-10            2                       2006-01-31
           Reference                                                          1- 999999999999
           Number
    100196 Unique Street      A unique identifier for each    BS7666          Positive integer in the range             S          Unique Street Reference                                      O       2006-01-31            1        2006-01-31
           Reference          street                          Unique Street   1- 99999999                                          Number
           Number                                             Reference
                                                              Number
                                                              99999999
    100197 Property Easting Easting coordinate for mapping 999999.9                                                     S          Easting                                                      O       2006-12-31            1
                             an address
    100198 Property Northing Northing coordinate for          999999.9                                                  S          Northing                                                     O       2006-12-31            1
                             mapping an address
    100333 OSAPR             OSAPR is the Ordnance            A(18)                                                     S          OSAPR                     The first two characters of any    O       2006-12-31            1
                             Survey Address-Point                                                                                                            OSAPR are always 'AP'.
                             Reference. Each address has
                             an OSAPR, which is a unique
                             reference to that address and is
                             included in the OS file made
                             available to suppliers for
                             address validation purposes.




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                Page 46 of 70                                                                                                 Date last updated: 1/7/2011
 Identifier Title             Description                    Format          Codeset                         Default   Allow      XML Tag                 Validation Rules   Item Date            Data         Implementation    Cut-off Date
 (New                                                                                                        Value     Multiple                                              Level Created        Item         Date
 CBDS Ref                                                                                                              Entries?                                                                   Status
 No)                                                                                                                   (S, M)
 Contact Information
    100199 Address Line 1     First Line of Contact's Address Line Address   No validation. Included                   S          AddressLine1                               S       2006-01-31            1        2005-04-30
                                                              Format         temporarily to facilitate dta
                                                              A(35)          transfer pending BS7666
                                                                             compliance.
    100200 Address Line 2     Second Line of Contact's       Line Address    No validation. Included                   S          AddressLine2                               S       2006-01-31            1        2005-04-30
                              Address                        Format          temporarily to facilitate dta
                                                             A(35)           transfer pending BS7666
                                                                             compliance.
    100201 Address Line 3     Third Line of Contact's Address Line Address   No validation. Included                   S          AddressLine3                               S       2006-01-31            1        2005-04-30
                                                              Format         temporarily to facilitate dta
                                                              A(35)          transfer pending BS7666
                                                                             compliance.
    100202 Address Line 4     Fourth Line of Contact's       Line Address    No validation. Included                   S          AddressLine4                               S       2006-01-31            1        2005-04-30
                              Address                        Format          temporarily to facilitate dta
                                                             A(35)           transfer pending BS7666
                                                                             compliance.
    100203 Address Line 5     Fifth Line of Contact's Address Line Address   No validation. Included                   S          AddressLine5                               S       2006-01-31            1        2005-04-30
                                                              Format         temporarily to facilitate dta
                                                              A(35)          transfer pending BS7666
                                                                             compliance.
    100204 International      First Line of International    BS7666                                                    S          IntAddressLine1                            S       2006-01-31            1
           Address Line 1     Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100205 International      Second Line of International   BS7666                                                    S          IntAddressLine2                            S       2006-01-31            1
           Address Line 2     Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100206 International      Third Line of International    BS7666                                                    S          IntAddressLine3                            S       2006-01-31            1
           Address Line 3     Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100207 International      Fourth Line of International   BS7666                                                    S          IntAddressLine4                            S       2006-01-31            1
           Address Line 4     Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100208 International      Fifth Line of International    BS7666                                                    S          IntAddressLine5                            S       2006-01-31            1
           Address Line 5     Address                        International
                                                             Address
                                                             Format
                                                             A(35)
    100209 Zip Code           International Post Code        A(20)                                                     S          Zip                                        S       2005-04-30            1        2005-04-30
    100210 International Post Post Code of International     BS7666                                                    S          InternationalPostCode                      S       2006-01-31            1
           Code               Address                        International
                                                             Address
                                                             Format
                                                             A(35)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                               Page 47 of 70                                                                               Date last updated: 1/7/2011
 Identifier Title             Description                      Format   Codeset                      Default   Allow      XML Tag                Validation Rules   Item Date            Data         Implementation    Cut-off Date
 (New                                                                                                Value     Multiple                                             Level Created        Item         Date
 CBDS Ref                                                                                                      Entries?                                                                  Status
 No)                                                                                                           (S, M)
 Contact Information
    100211 ISO 3166-1 Alpha- 3 digit alphabetic country code   A(3)     Nation states and                      S          CountryCodeAlpha3                         S       2006-01-31            1
           3 Code                                                       countries v3.0 (consistent
                                                                        with GDSC requirement to
                                                                        use BSEN 3166 (ISO
                                                                        3166-1)) available at
                                                                        http://www.teachernet.gov
                                                                        .uk/docbank/index.cfm?id
                                                                        =10434

    100212 ISO 3166-1 Alpha- 2 digit alphabetic country code   A(2)     Nation states and                      S          CountryCodeAlpha2                         S       2006-01-31            1
           2 Code                                                       countries v3.0 (consistent
                                                                        with GDSC requirement to
                                                                        use BSEN 3166 (ISO
                                                                        3166-1)) available at
                                                                        http://www.teachernet.gov
                                                                        .uk/docbank/index.cfm?id
                                                                        =10434

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

    100214 Country Name       Country Name                     A(30)    Nation states and                      S          Country                                   S       2005-04-30            1        2005-04-30
                                                                        countries (consistent with
                                                                        GDSC requirement to use
                                                                        BSEN 3166 (ISO 3166-1))
                                                                        available at
                                                                        http://www.teachernet.gov
                                                                        .uk/management/imsdata/
                                                                        management/cbds/CBDS
                                                                        specs
    100215 ISO 3166-1 Short Short country name                 A(45)    Nation states and                      S          CountryCodeNameShort                      S       2006-12-31            1
           Country Name                                                 countries v3.0 (consistent
                                                                        with GDSC requirement to
                                                                        use BSEN 3166 (ISO
                                                                        3166-1)) available at
                                                                        http://www.teachernet.gov
                                                                        .uk/docbank/index.cfm?id
                                                                        =10434




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                       Page 48 of 70                                                                              Date last updated: 1/7/2011
 Identifier Title              Description                      Format   Codeset                            Default   Allow      XML Tag                    Validation Rules       Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                       Value     Multiple                                                     Level Created        Item         Date
 CBDS Ref                                                                                                             Entries?                                                                          Status
 No)                                                                                                                  (S, M)
 Contact Information
    100216 ISO 3166-1 Long Long country name                    A(55)    Nation states and                            S          CountryNameLong                                   S       2006-01-31            1
           Country Name                                                  countries v3.0 (consistent
                                                                         with GDSC requirement to
                                                                         use BSEN 3166 (ISO
                                                                         3166-1)) available at
                                                                         http://www.teachernet.gov
                                                                         .uk/docbank/index.cfm?id
                                                                         =10434

    100217 Contact             Type of phone for which          A(1)                                                  M          PhoneType                  Cannot be blank if     S       2000-10-10            1
           Telephone Type      number is provided                                                                                                           <Relationship> = SWR
    100324 Contact             Type of phone for which          A(1)     Telephone Type                               M          TelephoneType              Cannot be blank if     S       2006-12-31            1
           Telephone Type      number is provided                                                                                                           <Relationship> = SWR
    100218 Contact             Contact's home telephone         A(35)    Valid characters are 0-9 and                 M          PhoneNo                    Cannot be blank if     S       2004-12-01            1
           Telephone           number                                    a leading '+' (for international                                                   <Relationship> = SWR
           Number                                                        numbers)
    100219 Day location        Day location of contact eg       A(1)     H = Home, W = Work                           S          DayLocation                                       O       2006-01-31            1
                               home or work
    100220 Preference for      Indicates whether contact        A(1)     E=email, M=Mail                              S          WrittenCommunicationPref                          O       2006-01-31            1
           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            1
           source              for contacts eg parents
    100222 Child is resident                                    A(5)     1,0 or true, false                           M          ContactResident                                   O       2006-01-31            1
           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            1
           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            1
           should be           about the contact address
           transferred with
           pupil indicator




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                              Page 49 of 70                                                                                      Date last updated: 1/7/2011
Pupil Level: Contact Information Module Codesets

Relationship                                       SIFRelationship                              SIFRelationship (cont)
                                                   Extended Extended Categories                 Extended Extended Categories
CAR         Carer                                  Codes                                        Codes
CHM         Childminder                              ASWR Agency representative                   FASH     Sister, half
DOC         Doctor                                  CARE    Carer                                  FASI    Sister-in-law
FAM         Other family member                     CHMR    Childminder                           FASN     Sister, natural/adoptive
OTH         Other Contact                           DEPD    Dependent                             FASO     Son
PAM         Mother                                  DOCT    Doctor                                FASP     Stepson
PAF         Father                                  EMPY    Employer                              FASS     Sister, step
STP         Step Parent                             FAAP    Adoptive parents                      FASW Son-in-law
FOS         Foster Parent                           FAAS    Adopted son                           FNCF     Fiancée
REL         Other Relative                          FABH    Brother, half                         FNCM Fiancé
SWR         Social Worker                           FABI    Brother-in-law                        FRND Friend
RLG         Religious/Spiritual Contact             FABN    Brother, natural/adoptive             GUAR Court appointed guardian
                                                    FABS    Brother, step                         HTCR     Head Teacher
                                                    FADF    Foster daughter                       NONE     None
Relationship v2.0                                   FADI    Daughter-in-law                       OTHR     Other
Main Code Main Category                             FADR    Daughter                              PREH     Former husband

CAR         Carer                                   FAFF    Father, foster                       PREW      Former wife
CHM         Childminder                              FAFI   Father-in-law                        PROB      Probation officer
DOC         Doctor                                  FAFN    Father, natural/adoptive             PTNP      Partner of parent
FAM         Other family member                     FAFO    Father's significant other           PTNR      Partner
FOF         Foster Father                           FAFS    Father, step                         RELA      Aunt
FOM         Foster Mother                           FAGA    Great aunt                           RELC      Cousin
HTC         Head Teacher                            FAGD    Granddaughter                        RELG      Minister or priest
OTH         Other Contact                           FAGF    Grandfather                          RELU      Uncle
PAF         Father                                  FAGM    Grandmother                          SIGO      Significant other
PAM         Mother                                  FAGS    Grandson                             SWKR      Social Worker
REL         Other Relative                          FAGU    Great uncle                          TADV      Advisor
RLG         Religious/Spiritual Contact             FALP    Life partner                         WARD      Ward
STF         Step Father                             FAMF    Mother, foster                       WIFE      Wife
STM         Step Mother                             FAMH    Husband
SWR         Social Worker                           FAMI    Mother-in-law
TCH         Teacher                                 FAMN    Mother, natural/adoptive            Telephone Type
                                                    FAMO    Mother's significant other          F         Fax
                                                    FAMS    Mother, step                        H         Home
Contact Priority Source                             FANC    Niece                               A         Alternate Home
C          Provided by the child (ie pupil)         FANW    Nephew                              M         Mobile
P          Provided by the parent                   FAOT    Family member                       W         Work
S          Ascribed by the current school           FAPF    Foster parent                       D         Minicom (hearing impaired/disabled)
T          Ascribed by a previous school            FAPP    Life partner of parent
O          Other                                    FASF    Foster son




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                        Page 50 of 70                                                   Date last updated: 1/7/2011
Pupil Level: Contact Information Module Codesets



Address Type
C         Current - address where pupil is normally resident
P         Previous - default type for any current address
           superseded 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
M          Mailing - address for mailing




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                        Page 51 of 70   Date last updated: 1/7/2011
  9 Attendance
 Identifier Title              Description                      Format       Codeset                  Default   Allow      XML Tag                Validation Rules                 Item Date            Data     Implementation    Cut-off Date
 (New                                                                                                 Value     Multiple                                                           Level Created        Item     Date
 CBDS Ref                                                                                                       Entries?                                                                                Status
 No)                                                                                                            (S, M)
 Attendance
    100225 Attendance Year Year at the start of the             CCYY                                            S          Year                                                    S       2000-10-10
                             academic year                                                                                                                                                                   1
    100226 Attendance        Term start date                    CCYY-MM-DD Any valid date                       M          AttendanceStartDate                                     A       2004-05-31
           period start date
                                                                                                                                                                                                             1
    100227 Attendance          Term end date                    CCYY-MM-DD Any valid date                       M          AttendanceEndDate                                       A       2004-05-31
           period end date                                                                                                                                                                                   1
    100228 Possible            Number possible sessions      999             0-400                              M          SessionsPossible       For termly attendance,           S       2005-04-30
           Sessions            during reporting period.                                                                                           <SessionsPossible> should be
                               There are 2 sessions for each                                                                                      less than 151
                               school day (morning and                                                                                            The total of
                               afternoon).                                                                                                        <SessionsAuthorised> plus
                                                                                                                                                  <SessionsUnauthorised> must
                                                                                                                                                  be less than or equal to
                                                                                                                                                  <SessionsPossible>                                         1
    100229 Sessions            Number of sessions               999          0-400                              M          SessionsAttended                                        S       2004-12-01
           Attended            attended                                                                                                                                                                      1
    100230 Sessions missed Authorised absence is                999          0-400                              M          SessionsAuthorised     <SessionsAuthorised> must be     S       2005-04-30
           due to Authorised absence which has been                                                                                               less than or equal to
           Absence           authorised by a teacher or                                                                                           <SessionsPossible>
                             other authorised
                             representative of the school.
                                                                                                                                                                                                             1
    100231 Sessions missed     Unauthorised absence is       999             0-400                              M          SessionsUnauthorised   <SessionsUnauthorised> must      S       2005-04-30
           due to              absence without leave from a                                                                                       be less than or equal to
           Unauthorised        teacher or other authorised                                                                                        <SessionsPossible>
           Absence             representative of the school.
                               This includes all unexplained
                               or unjustified absences
                                                                                                                                                                                                             1
    100232 Attendance          Pupil level morning and          A(1)         Pupil Attendance Codes             M          AttendanceReason       Attendance codes for a pupil     O       2006-01-31                 2006-09-01
           codes               afternoon registration marks.                                                                                      covering a number of sessions
                               New attendance codes                                                                                               eg covering a whole term may be
                               effective from September                                                                                           shown together as a string for
                               2006 (England)                                                                                                     transfer between schools/LAs via
                                                                                                                                                  CTF. NOTE : \ in XML is a
                                                                                                                                                  special character but should not
                                                                                                                                                  be a problem when used in a
                                                                                                                                                  character string.
                                                                                                                                                                                                             1
    100233 Number of           Number of sessions missed        999          0-400                              M          AbsenceSessions                                         C       2006-12-31            21/01/2007
           sessions missed     for specified reason                                                                                                                                                              School Census
                                                                                                                                                                                                             1 07
    100234 Alternative tuition Indicates whether pupil          A(5)         1,0 or true, false                 M                                                                  C       2006-01-31
           indicator           receives alternative tuition                                                                                                                                                  1
    100235 Alternative tuition Reason for alternative tuition   A(2)         TuitionCategory                    M          TuitionCategory        Must not be blank if 100188 is   O       2006-01-31
           category                                                                                                                               true                                                       1
    100236 Alternative tuition                                  CCYY-MM-DD                                      M                                 Must not be blank if 100188 is   O       2006-01-31
           start date                                                                                                                             true                                                       1
    100237 Alternative tuition                                  CCYY-MM-DD                                      M                                                                  O       2006-01-31
           end date                                                                                                                                                                                          1




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                        Page 52 of 70                                                                                        Date last updated: 1/7/2011
 Identifier Title             Description                   Format   Codeset                      Default   Allow      XML Tag          Validation Rules               Item Date            Data       Implementation   Cut-off Date
 (New                                                                                             Value     Multiple                                                   Level Created        Item       Date
 CBDS Ref                                                                                                   Entries?                                                                        Status
 No)                                                                                                        (S, M)
 Attendance
    100238 Number of hours Number of hours alternative      99       TuitionHours                           M          Hours            Number of whole hours. 0-29     O      2006-01-31
           alternative tuition tuition attended per week                                                                                minutes to be rounded down and
           attended per                                                                                                                 30-59 minutes to be rounded up.
           week                                                                                                                         Range = 1-99. Must not be blank
                                                                                                                                        if 100188 is true.
                                                                                                                                                                                                 1
    100279 Type of            The type of provision, for     A(3)    Alternative Provision Type             S          APtype           NB XML tag in AP spec not      C       2006-12-31            1 01/03/2007
           Alternative        example Independent School,                                                                               CBDS compliant - to be                                         AP Pilot
           Provision          Hospital, etc.                                                                                            reviewed.
    100290 Funded Hours       The number of hours funded 99.9        0.5-12.5                               S          Funded Hours                                    C       2006-12-31            1 01/03/2007
                              by an LA for the child at the                                                                                                                                            EY Pilot
                              EY setting (to the nearest 9.5
                              hour)
    100291 Hours at Setting   The total number of LA funded 99.9     0.5-70                                 S          HoursAtSetting                                  C       2006-12-31            1 01/03/2007
                              and undunded hours thtat the                                                                                                                                             EY Pilot
                              child spends at the EY setting
                              (to the nearest 0.5 hour)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                    Page 53 of 70                                                                                  Date last updated: 1/7/2011
Pupil Level: Attendance Module Codesets
Pupil Attendance Codes                                                                          TuitionCategory
/     Present (AM)                                                                              IL             Alternative Tuition by LA because of Illness
\     Present (PM)                                                                                             Alternative Tuition by LA because of Permanent
                                                                                                PE             Exclusion
L     Authorised absence due to Illness (NOT present
      Late (before registers closed) marked asmedical or dental etc.                            OR             Alternative Tuition by LA for Other Reason
I     appointments)                                                                             HP             Alternative Tuition at Home by Parents/Carers
M
      Authorised absence due to medical/ dental appointments
R                                                                                               TuitionHours
      Authorised absence due to religious observance
S     Authorised absence due to study leave                                                     A              5 hours or less
T     Authorised absence due to traveller absence                                               B              6-12 hours
H
      Authorised absence due to agreed family holiday                                           C              13-19 hours
F     Authorised absence due to agreed extended family holiday provision
                         as pupil is excluded, with no alternative                              D              20 hours or more
E     made
      Authorised absence as pupil is absent due to other authorised
C     circumstances
      Approved education activity as pupil being educated off site (not dual
B     registration)                                                                             Alternative Provision Type
D     Approved education activity as pupil is dual registered (i.e. attending
      another establishment)                                                                    HSP            Hospital
J
                                                        interview
      Approved education activity as pupil is attending an approved sporting                    IND            Independent School
P     activity                                                                                  NMS            Non-maintained Special School
V     Approved education activity as pupil is away on an educational visit or
      trip                                                                                      NOT            Not a School
W
      Approved education activity as pupil is attending work not agreed, or
      Unauthorised absence as pupil is on a family holiday, experience
G     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
N     Unauthorised absence as pupil missed sessions for a reason that has
      not yet been provided
      Non-compulsory school age absence - not counted in possible
X     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




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                        Page 54 of 70                                                        Date last updated: 1/7/2011
  10 Previous School History
  Identifier Title            Description                      Format       Codeset                          Default   Allow      XML Tag         Validation Rules                Item Date            Data         Implementation   Cut-off Date
  (New                                                                                                       Value     Multiple                                                   Level Created        Item         Date
  CBDS Ref                                                                                                             Entries?                                                                        Status
  No)                                                                                                                  (S, M)
  Previous School History
     100239 Previous School LA number for school which      A(3)            LEALIST_V3                                 M          LEA                                             S       2006-01-31            1
            LA number       pupil attended prior to current
                            school
     100240 Previous School DfES Establishment number A(4)                  Establishment list - This file             M          Estab           0001-0900 Secure Units &         S      2006-12-31            1
            DfES            for school which pupil                          is too large to be offered as                                         Miscellaneous; 0940-0949
            Establishment   attended prior to current                       a download; please                                                    Playing for Success Centres;
            Number          school                                          request a copy by email                                               1000-1099 LA Nursery Schools;
                                                                                                                                                  1100-1149 Pupil Referral Unit;
                                                                            from
                                                                                                                                                  1800-1999 Miscellaneous; 2000-
                                                                            ChangeControl.CBDS@dfe                                                3999 Maintained Primary (inc
                                                                            s.gsi.gov.uk.                                                         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,
     100241 Previous School Name of school which pupil         A(100)       Any character string                       M          SchoolName      incl. not for Blaby <Estab> =
                                                                                                                                                  Must9565be blank if Community S         2005-04-30            1
            Name            attended prior to current                                                                                             XXXX
                            school
     100242 Previous School Date which pupil started at        CCYY-MM-DD Any valid date                               M          EntryDate                                       S       2005-04-30            1
            Date of Entry   school prior to current school

     100243 Previous School Last day pupil on roll at          CCYY-MM-DD Any valid date                               M          LeavingDate                                     S       2005-04-30            1
            Date of Leaving school prior to current
                              school
     100244 Pupil Reason      Reason why pupil left school     A(2)                                                    M          LeavingReason                                   S       2006-01-31            3
            for Leaving       prior to current school

     100318 Reason for        Reason why pupil/child left      A(2)         LeavingReason V2.0                         M          ReasonLeft                                      S       2006-12-31            1
            Leaving           school prior to current school




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                                Page 55 of 70                                                                                   Date last updated: 1/7/2011
  Identifier Title          Description                     Format   Codeset              Default   Allow       XML Tag      Validation Rules   Item Date            Data         Implementation   Cut-off Date
  (New                                                                                    Value     Multiple                                    Level Created        Item         Date
  CBDS Ref                                                                                          Entries?                                                         Status
  No)                                                                                               (S, M)
  Previous School History
     100245 Last School     Indicates whether this school   A(5)     1,0 or true, false             S           LastSchool                      S       2003-08-31            1
                            was the last one before
                            current school




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                Page 56 of 70                                                                 Date last updated: 1/7/2011
Pupil Level: Previous School History Module Codesets
LeavingReason v2.0
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)
MD             Military deployment of parent(s)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                    Page 57 of 70   Date last updated: 1/7/2011
  11 Post 16 Courses
 Identifier Title             Description                   Format   Codeset                Default   Allow      XML Tag          Validation Rules                  Item Date            Data         Implementation   Cut-off Date
 (New                                                                                       Value     Multiple                                                      Level Created        Item         Date
 CBDS Ref                                                                                             Entries?                                                                           Status
 No)                                                                                                  (S, M)
 Post 16 Courses
    100246 Post Advanced      Indicates whether a pupil is A(5)      1,0 or true, false               S          AdvancedCourse   <AdvancedCourse> must be           S      2005-04-30            1
           Level Indicator    taking a post advanced level                                                                        false if <Alevels> is greater than
                              course or not. A post                                                                               0 or <GNVQs> = 3 or
                              advanced level course is any                                                                        <PreGNVQs> = 3 or <NVQs> =
                              course taken by a pupil who                                                                         3 or <Other> = B
                              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 Number of GCE      This includes AS (Advanced 9           0-9                              S          Alevels                                            S       2005-04-30            2
           A Level subjects   Subsidiary), A2 and linear A
           being studied      Levels, but excludes General
                              Studies and Vocational
                              Certificates of Education
                              (VCEs), sometimes known as
                              Vocational A Levels.

    100248 Number of GCE      This includes AS (Advanced 99          0-19                             S          Alevels                                            S       2006-12-31            1
           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 Number of GCE Total number of AS level           9        0-9                              S          Aslevels                                           S       2005-04-30            2
           AS Level subjects subects being studied by pupil
           being studied

    100250 Number of GCSE The total number of GCSEs         99       0-19                             S          GCSEs                                              S       2005-04-30            1
           Subjects being being taken by pupil
           studied
    100251 GNVQ level     Indicates whether a pupil is      9        GNVQ Level                       S          GNVQs                                              S       2005-04-30            1
                          not taking a GNVQ or VCE, or
                          is taking a foundation,
                          intermediate or advanced
                          GNVQ or VCE
    100252 GNVQ Precursor Indicates whether a pupil is      9        GNVQ Precursor Level             S          PreGNVQs                                           S       2005-04-30            1
           Level          not taking a GNVQ precursor,
                          or is taking a level 2 GNVQ
                          precursor or a level 3 GNVQ
                          precursor
    100253 NVQ Level      Indicates whether a pupil is      9        NVQ Level                        S          NVQs                                               S       2005-04-30            1
                          not taking a NVQ or is taking a
                          NVQ level 1, 2 or 3




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                              Page 58 of 70                                                                                       Date last updated: 1/7/2011
 Identifier Title             Description                   Format         Codeset                       Default   Allow      XML Tag                    Validation Rules                Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                    Value     Multiple                                                              Level Created        Item         Date
 CBDS Ref                                                                                                          Entries?                                                                                   Status
 No)                                                                                                               (S, M)
 Post 16 Courses
    100254 Other Post-16     Indicates whether a pupil is   A(1)           Other Post16 Courses                    S          Other                                                      S       2005-04-30            1
           Courses Indicator taking the International
                             Baccalaureate, another
                             course (all categories not
                             counted elsewhere, including
                             General Studies) or not taking
                             any other post year 12
                             courses
    100255 Qualification      Unique number identifying      A(8)          Qualification Accreditation             M          QAN                        1st and 8th characters can be 0- S      2006-01-31            1 2007-10-04
           Accreditation      learning aim / course of study               Number - This file is too                                                     9 or A-Z (upper case)                                           School Census
           Number                                                          large to be offered as a                                                      Characters 2-7 must be numeric                                  October 07
                                                                           download; please request
                                                                           a copy by email from
                                                                           IMS.MAILBOX@dfes.gsi.g
                                                                           ov.uk.
    100256 Learning Aim       The date on which learning for CCYY-MM-DD                                            M          LearningStartDate                                          S       2006-01-31            1 2007-10-04
           Start Date         the learning aim began                                                                                                                                                                     School Census
                                                                                                                                                                                                                         October 07
    100257 Learning Aim       The date by which the school CCYY-MM-DD                                              M          LearningPlannedEndDate                                     S       2006-01-31            1 2007-10-04
           Planned End        and learner plan to complete                                                                                                                                                               School Census
           Date               the learning related to this                                                                                                                                                               October 07
                              learning aim
    100258 Learning Aim       The date that the learner       CCYY-MM-DD                                           M          LearningActualEndDate                                      S       2006-01-31            1 2007-10-04
           Actual End Date    completed the learning                                                                                                                                                                     School Census
                              activities necessary to achieve                                                                                                                                                            October 07
                              the learning aim or the date
                              the learner withdrew from the
                              learning activities

    100259 Learning Aim       An indication of the degree of A(1)          Learning Aim Completion                 M          LearningCompletionStatus                                   S       2006-01-31            1 2007-10-04
           Completion         completion of the learning                   Status                                                                                                                                        School Census
           Status             activities leading to the                                                                                                                                                                  October 07
                              learning aim
    100337 Discount Code      Discount code and QAN          A(4)          QAN_DiscCode.XML                   0000 M          DiscCode                   QAN_DiscCode_Table.XSD          S       2006-12-31            1 2007-10-04
                              together identify the subject                                                                                                                                                              School Census
                              studied where the QAN on its                                                                                                                                                               October 07
                              own does not




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                           Page 59 of 70                                                                                               Date last updated: 1/7/2011
 Identifier Title           Description                  Format   Codeset                             Default   Allow      XML Tag                Validation Rules                Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                 Value     Multiple                                                          Level Created        Item         Date
 CBDS Ref                                                                                                       Entries?                                                                               Status
 No)                                                                                                            (S, M)
 Post 16 Courses
    100260 DfES Number for DfES number for destination   A(4)     Establishment list - This file is             S          Estab                  0001-0900 Secure Units &         O      2006-01-31            1
           Destination     school or college                      too large to be offered as a                                                    Miscellaneous; 0940-0949
           School                                                 download; please request a                                                      Playing for Success Centres;
                                                                  copy by email from                                                              1000-1099 LA Nursery Schools;
                                                                  ChangeControl.CBDS@dfes.                                                        1100-1149 Pupil Referral Unit;
                                                                  gsi.gov.uk.                                                                     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,
    100261 LA Number for    LA number for destination             LEA list available at                         S          LEA                    incl. 9565 for Blaby Community O        2006-01-31            1
           Destination      school or college                     http://www.teachernet.gov.
           School                                                 uk/management/ims/datam
                                                                  anagement/cbds/CBDSspe
                                                                  cs/
    100262 Destination      To manage performance of     A(2)                                                   S          LeavingDestination                                     O       2006-12-31            2
           Information      school, eg how many students
                            went on to University

    100326 Destination      Destination on leaving       A(2)     Destinations v2.0                             S          DestinationOnLeaving                                   O       2006-12-31            1
                            information to manage
                            performance of school




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                        Page 60 of 70                                                                                           Date last updated: 1/7/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
                                                                                                        X              Data input error
GNVQ Precursor Level
0          Not taking a GNVQ precursor
2          Taking a level 2 GNVQ precursor (ie a BTEC First or City & Guilds Diploma of                 Leaving Destination V2.0
           Vocational Education at intermediate level
3          Taking a level 3 GNVQ precursor (ie a BTEC National or City & Guilds Diploma of              MP             Maintained primary school
           Vocational Education at national level
                                                                                                        IP             Independent primary school
                                                                                                        MS             Maintained secondary school
NVQ Level                                                                                               IS             Independent secondary school
0             not taking a NVQ                                                                          SC             6th Form College
1             taking a NVQ level 1                                                                      FE             General FE, tertiary and specialist colleges
2             taking a NVQ level 2                                                                      HE             Higher education institutions
3             taking a NVQ level 3                                                                      WL             Work based Learning
                                                                                                        EM             Employment
                                                                                                        NK             Other/Not Known
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)




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                     Page 61 of 70                                                                   Date last updated: 1/7/2011
  12 Assessment
 Identifier Title             Description                    Format       Codeset                      Default   Allow      XML Tag            Validation Rules   Item Date            Data         Implementation   Cut-off Date
 (New                                                                                                  Value     Multiple                                         Level Created        Item         Date/Project
 CBDS Ref                                                                                                        Entries?                                                              Status
 No)                                                                                                             (S, M)
 Assessment
    100265 Assessment         Identifier for assessment      A(3)         Assessment IDs available               S          Stage                                 S       2005-04-30            1
           Identifier         being taken by pupil                        at
                                                                          http://www.teachernet.gov.
                                                                          uk/docbank/index.cfm?id=6
                                                                          837
    100266 Assessment Year Calendar year of assessment CCYY                                                      S          Year                                  S       2001-05-04            1

    100267 Assessment         Indicates whether the         A(3)          ENG = England                          S          Locale                                S       2003-08-31            2
           Locale             assessment locale is England,               WAL = Wales/Cymru
                              Wales or Unknown                            UNK = Unknown

    100321 Assessment      Indicates whether the        A(3)       ENG = England                                 S          AssessmentLocale                      S       2006-12-31            1
           Locale          assessment locale is England            WAL = Wales/Cymru
                           or Wales
    100268 Assessment Date Date of assessment           CCYY-MM-DD                                               S          Date                                  S       2001-05-04            1 01/10/2007 CTF

    100332 Assessment Date Date of assessment                CCYY-MM-DD                                          S          ResultDate                            S       2001-05-04            1

    100269 Assessment /       Exam season                    A(1)         Season                                 S          Season                                S       2001-05-04            1
           Examination
           Season
    100270 Assessment         Indicates whether the result is A(1)        Result                                 S          ResultStatus                          S       2001-05-04            1
           Result Indicator   estimated, an interim result,
                              provisional, actual result or a
                              target
    100271 Assessment         Subject assessed (KS3 and       A(3)        Assessment subjects                    S          Subject                               S       2004-05-31            1
           Subject            below)                                      available at
                                                                          http://www.teachernet.gov.
                                                                          uk/docbank/index.cfm?id=6
                                                                          841
    100272 Examination        Subject of exam (KS4 and       A(6)         Assessment subjects                    S          ExamSubject                           S       2004-05-31            1
           Subject            above)                                      available at
                                                                          http://www.teachernet.gov.
                                                                          uk/docbank/index.cfm?id=6
                                                                          841
    100273 Assessment Type Method of assessment              A(3)         Assessment types                       S          Method                                S       2006-01-31            1
                           (Task/test, teacher                            available at
                           assessment, disapplied, test                   http://www.teachernet.gov.
                           not taken)                                     uk/docbank/index.cfm?id=9
                                                                          612
    100274 Assessment         Subject component within       A(3)         Assessment component                   S          Component                             S       2006-01-20            1
           Component          each type of assessment                     details 2007 available at
                              (Assessments prior to 2004                  http://www.teachernet.gov.
                              will be in A_COMP_2003)                     uk/docbank/index.cfm?id=1
                                                                          0625
    100275 Component          Component result type          A(2)         Assessment component                   M          ResultQualifier                       S       2006-01-20            1
           Result Type                                                    result types available at
                                                                          http://www.teachernet.gov.
                                                                          uk/docbank/index.cfm?id=8
                                                                          886




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                         Page 62 of 70                                                                          Date last updated: 1/7/2011
 Identifier Title           Description                   Format   Codeset                      Default   Allow      XML Tag               Validation Rules   Item Date            Data         Implementation   Cut-off Date
 (New                                                                                           Value     Multiple                                            Level Created        Item         Date/Project
 CBDS Ref                                                                                                 Entries?                                                                 Status
 No)                                                                                                      (S, M)
 Assessment
    100276 Component        Result of components within   A(9)     Assessment component                   M          Result                                   S       2006-12-31            1
           Result           each type of assessment                details 2007 available at
                            (Assessments prior to 2004             http://www.teachernet.gov.
                            will be in A_COMP_2003)                uk/docbank/index.cfm?id=1
                                                                   0625
    100277 Awarding Body/   Name of awarding body/exam A(3)        Awarding bodies &                      M          ExamBoard                                S       2001-05-04            1
           Examination      board                                  examination boards
           Board                                                   available at
                                                                   http://www.teachernet.gov.
                                                                   uk/management/ims/datam
                                                                   anagement/cbds/CBDSspe
                                                                   cs/
    100278 Examination     Exam board syllabus ID         A(6)     Key Stage 4 & 5 syllabuses             M          ExamBoardSyllabusID                      S       2001-05-04            1
           Syllabus Number                                         available at
                                                                   http://www.teachernet.gov.
                                                                   uk/docbank/index.cfm?id=6
                                                                   957




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                  Page 63 of 70                                                                             Date last updated: 1/7/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
  13 Admissions
 Identifier Title             Description                      Format    Codeset                          Default   Allow      XML Tag                Validation Rules                  Item Date            Data     Implementation   Cut-off Date
 (New                                                                                                     Value     Multiple                                                            Level Created        Item     Date
 CBDS Ref                                                                                                           Entries?                                                                                 Status
 No)                                                                                                                (S, M)
 Admissions
    100293 Admissions entry Entry year and month for           A(7)      CCYY-MM                                    S          EntryYearAndMonth                                        C       2006-12-31
           year and month pupil's admission to school

    100294 Admissions entry Year group for pupil               A(2)      Entry year group                           S          EntryYearGroup                                           C       2006-12-31
           year group         admission.
    100295 Status             Status type of ADT file.         A(10)     Status type                                S          Status                                                   C       2006-12-31
                              Indicator applies to all
                              applications in the file.
    100296 Text (file header) Any required text message        A(3000)                                              S          Text                                                     O       2006-12-31

    100297 Application        Unique reference number          A(20)     LEA-YYYY-MM-N-999999, LA                   M          ApplicationReference                                     C       2006-12-31
           reference          allocated for each application             is home LA (secondary
                              (i.e. for each pupil not each              applications) or maintaining
                              preference) at the point that              LA for primary applications, N
                              the application data is                    is E(Online) K (Keyboard) B
                              "captured".                                (Batch)
                                                                         Last component six digits,
                                                                         leading zeros.

    100298 Statemented         Parents' indication that     A(5)         1, 0 or true, false              false     S          Statemented                                              C       2006-12-31
                               pupil has/hasn't got a
                               statement of SEN. As part
                               of processing an
                               application, the maintaining
                               LA would check whether
                               the pupil does have an SEN
                               statement.

    100299 Verified (address) Optional tag to indicate that   A(5)       1, 0 or true, false                        S          Verified                                                 O       2006-12-31
                              the address has been verified
                              i.e. the pupil livres at the
                              address. This allows a “home”
                              LA to indicate to an “other” LA
                              or an OAA school whether or
                              not the “home” LA has verified
                              the pupil address. It does not
                              refer to the address having
                              been validated against any
                              type of address database.


    100300 Preference Rank Rank of preference expressed A(1)                                                        S          PreferenceRank         Inclusion of this tag is mandatory O      2006-12-31
                           by applicant as on application                                                                                             when exchanged with another
                           form                                                                                                                       LA. It is mandatory when sent to
                                                                                                                                                      an OAA school where the
                                                                                                                                                      admission policy
                                                                                                                                                      (oversubscription criteria) of the
                                                                                                                                                      school includes “first preference
                                                                                                                                                      first”.




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                            Page 65 of 70                                                                                         Date last updated 1/7/2011
 Identifier Title            Description                      Format    Codeset                  Default   Allow      XML Tag              Validation Rules                  Item Date            Data     Implementation   Cut-off Date
 (New                                                                                            Value     Multiple                                                          Level Created        Item     Date
 CBDS Ref                                                                                                  Entries?                                                                               Status
 No)                                                                                                       (S, M)
 Admissions
    100301 Preference        Reasons which may be             A(4)      Reason codes                       M          ReasonCode           Inclusion of this tag is mandatory O      2006-12-31
           reason            expressed for preference for                                                                                  if <ReasonCodes> is included in
                             admission to a school                                                                                         an ADT file.

    100302 Preference        Text describing applicants       A(3000)                                      S          ReasonText                                             O       2006-12-31
           reason text       reasons for expressing this
                             preference whether or not
                             <ReasonCode> is used.

    100303 Aptitude code     A code to explain what           A(2)      Aptitude Code                      M          AptitudeCode         Inclusion of this tag is mandatory C      2006-12-31
                             specialism a parent believes                                                                                  if <Aptitudes> is included in an
                             the pupil has an aptitude for,                                                                                ADT file.
                             which may be particularly
                             relevant where a school has
                             more than one specialism

    100304 Aptitude text     Additional relevant to aptitude A(3000)                                       S          AptitudeText                                           O       2006-12-31
                             eg for aptitude PE, text may
                             be "County Youth Team"

    100305 Faith             The religious faith of the pupil A(2)      Faith                              S          Faith                Inclusion of this tag is mandatory C      2006-12-31
                             which may be required where                                                                                   if <FaithDetails> is included in an
                             a faith schools requires this as                                                                              ADT file.
                             part off its admissions policy.



    100306 Faith text        Text provided by the applicant A(3000)                                        S          VerificationText                                       O       2006-12-31
                             supporting a 'faith claim' eg
                             name of church attended

    100307 Distance from     Unit of distance from home   100000000                                        S          DistanceFromSchool                                     X       2006-12-31
           school            address to school. LA to OAA
                             school only. Unit of
                             measurement and
                             measurement description to
                             be agreed separately between
                             LA and OAA schools. (no
                             leading zeros)

    100308 LA pre banding    Available for use where the      A(2)      Pre Banding categories             S          LEApreband           NB XML tag used in Admissions X           2006-12-31
           information       LA, following testing, places                                                                                 example file is not CBDS
                             each pupil into a band where                                                                                  compliant
                             the banding information is
                             used in school admission
                             policies. LA to OAA schools
                             only.
    100309 LA 'other' text   Other text specific to the LA    A(3000)                                      S          LEAtext                                                O       2006-12-31
    100310 Local reference   Text providing a local           A(50)                                        S          LocalReference                                         O       2006-12-31
                             preference identifer for the
                             use of local systems




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                   Page 66 of 70                                                                                       Date last updated 1/7/2011
 Identifier Title              Description                      Format        Codeset               Default   Allow      XML Tag              Validation Rules   Item Date            Data     Implementation   Cut-off Date
 (New                                                                                               Value     Multiple                                           Level Created        Item     Date
 CBDS Ref                                                                                                     Entries?                                                                Status
 No)                                                                                                          (S, M)
 Admissions
    100311 Medical or social   An indicator which tells a    A(5)             1,0 or true, false              S          SocMed                                  X       2006-12-31
           information         maintaining LA whether or not
                               supporting social/medical
                               information supplied by a
                               parent is being sent
                               separately from the “home” LA
                               (LA receiving the Common
                               Application Form) to the LA
                               maintaining a preference
                               school.

    100312 Offer status        An indicator used in            A(1)           Offer status                    S          OfferStatus                             C       2006-12-31
                               exchanges between LAs to
                               indicate that an offer can be
                               made for a preference school,
                               that an an offer cannot be
                               made, that an offer previously
                               made (in error) is withdrawn or
                               that a an offer previously
                               made can be discarded
                               because an higher ranked
                               preference can now be
                               offered.


    100313 Criterion           If an OAA school has pre-       A(25)                                          S          Criterion                               C       2006-12-31
                               grouped applicants before
                               applying the oversubscription
                               criteria set out in the school
                               admissions policy, the OAA
                               school will provide information
                               on the criteria used for pre
                               grouping. This information is
                               used to describe the Criterion
                               in the ALT file under which an
                               offer has been made. The
                               information will have been
                               transferred to the LA as the
                               Admission policy criterion in
                               the ASL file from the OAA
                               school.



    100314 Priority            The rank of each Admissions               99                                   S          Priority                                X       2006-12-31
                               Policy Criterion within the
                               Priority Groups in an ASL file
                               from an OAA school to its LA

    100315 Admission policy    See explanation of Criterion     A(25)                                         S          AdmPolCriterion                         C       2006-12-31
           criterion
    100316 Notification        Method by which an (online)     A(1)           Notification method             S          NotificationMethod                      C       2006-12-31
           method              applicant wishes to be notified
                               of the result of their
                               application.




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                                      Page 67 of 70                                                                        Date last updated 1/7/2011
 Identifier Title              Description                      Format   Codeset   Default   Allow      XML Tag    Validation Rules   Item Date            Data     Implementation   Cut-off Date
 (New                                                                              Value     Multiple                                 Level Created        Item     Date
 CBDS Ref                                                                                    Entries?                                                      Status
 No)                                                                                         (S, M)
 Admissions
    100335 Ranking of offers                                    A(25)                        M          RankedBy                      C       2006-12-31
                               Method by which an OAA
                               school ranks individual pupils
                               within the Ranked Group
                               section of the file the OAA
                               school sends back to it's LA.




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                     Page 68 of 70                                                              Date last updated 1/7/2011
Pupil Level: Admissions Module Codesets

Entry Year Group                                                                                     Aptitude Code
N1, N2          Nursery                                                                               PE          Physical Education or Sport
R               Reception                                                                             PA          Performing Arts
1-14            Years 1 to 14                                                                         VA          Visual Arts
                                                                                                      ML          Modern Foreign Languages
                                                                                                      DT          Design Technology or IT
Status type                                                                                           OT          Other
Prime           These files contain completely new data and should be
                considered the means that all data previously supplied (apart from
                A 'Change' value complete application for the student.
Change          the Application Reference) are to be deleted and only the data in the
                These files to be used for pupils in Admission Authority school that an
                change file advise the LA or Own the file.
Withdrawal      application should be noted as withdrawn for a pupil who moves away
                from the LA during the admissions process.                                           Offer status
Suspended       This is a precautionary status, as it is not known when it might be
                used. These records should go to suspense, as it is not possible to
                know what to do with them if the condition cannot be determined.                     O          Offer
Late            The records in this file type are considered as late by the Home LA‟s
                criteria.                                                                            N          No offer
                                                                                                                Discard (higher preference
                                                                                                     D          offered)
Reason codes
  DIST            Distance
  SIBL            Sibling                                                                            Notification method
  MEDL            Medical                                                                            O          Online
  RLGN            Religion                                                                           E          Email
  CTCH            Catchment Area                                                                     T          SMS/Text message
  FEED            Feeder School                                                                      L          Letter
  TRAV            Travelling Time
  SSEX            Single Sex School
  COED            Coeducational School
  APTD            Aptitude
  SOCL            Social Reasons
  OTHR            Other




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls                                                  69 of 70                                              Date last updated 1/7/2011
Pupil Level: Admissions Module Codesets


Faith
BA            Baptist
BU            Buddhist
CE            Church of England
CH            Christian
CO            Congregational
EC            Christian (Ecumenical)
FR            Free Church
GR            Greek Orthodox
HI            Hindu
JE            Jewish
JW            Jehovah's Witness
ME            Methodist
MU            Muslim
QU            Quaker
RC            Roman Catholic
RU            Russian Orthodox
SA            Salvation Army
SD            Seventh Day Adventist
SI            Sikh
UR            United Reform Church


Pre Banding categories
1A            Band 1A (Highest)
1B            Band 1B
2A            Band 2A
2B            Band 2B
3             Band 3 (Lowest)
U             Band Unknown




07d2f330-35a7-4ce3-9688-5c122ccc7e68.xls   70 of 70   Date last updated 1/7/2011

				
DOCUMENT INFO
Description: Blank Marriage Certificate Uk document sample