Blank Muslim Marriage Certificates - Download as Excel by mgx23910

VIEWS: 152 PAGES: 90

More Info
									Information relating to this spreadsheet

Title                   CBDS Specification - Pupil (Modular Format)
Version                 V4.4
Filename                Pupil CBDS V4.4
Creator                 Julia High, DSG DDU
Audience                DSG DDU, DSG TDU, TeacherNet
Description             This workbook contains the Pupil Level CBDS broken down into modules (e.g. Pupil
                        Characteristics) and with appropriate code sets
Related.reference
Subject.category        Information Management
Date Last Updated       2007-07-31

Notes:
Rows highlighted in yellow indicate that the data definition has been superseded by a revised or new one; some
of these rows are active as some applications may still use this definition.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                             Page 1 of 91                                Date last updated: 1/13/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 (Permanent UPN) or A99999999999A (Temporary UPN). 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 occurrence, M = Multiple current occurrence.
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 which 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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                      Page 2 of 91                                                                       Date last updated: 1/13/2011
Data items and codesets by module in the new CBDS spreadsheets

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

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

                                                                                                                         First Language                               First Language
Module           Date items                                Codesets                                                      Language Type                                Language Type
3 Pupil Status   Pupil/child Enrolment status              Pupil Enrolment Status                                        Language Type                                Language Type v2.0
                 Other School LA number                    LEA list                                                      Language Code                                Language code list v1.0
                 Other School DfES Establishment Number    Establishment list                                            Language Code                                Language code list v2.0

                 Pupil Date of entry                                                                                     Usual mode of travel                         Usual mode of travel
                 Pupil Date of Leaving                                                                                   Free school meal taken or claimed
                 Pupil Part-time Indicator                                                                               Free School Transport Eligibility Review
                                                                                                                         Date
                 Pupil - Number of sessions                                                                              Type of care                                 In care type
                 Pupil Boarder Indicator                   Pupil Boarder                                                 English as additional language               Assessment component details
                 Pupil's Actual National Curriculum Year   NC Year Group                                                 Family structure                             Family
                 Group
                 Pupil Class Type Indicator                Class Type                                                    Sibling on Child Protection Register
                 Pupil Class Type Indicator                Class Type v2.0                                               Number of previous schools
                 Pupil Registration Group                                                                                Pregnant pupil indicator
                 Pupil Email Address                                                                                     Uniform allowance indicator
                 Leaving destination                                                                                     Source of pupil religious affiliation code   Religion Source




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                Page 3 of 90                                                                             Date last updated: 1/13/2011
Data items and codesets by module in the new CBDS spreadsheets

                 Name of leaving destination                                                                Date of Entry
                 Pupil/Child Educated Elsewhere                                                             Service Child Indicator                   Service Child Indicator
                                                                                                            Source for Service Child Indicator        Service Child Source
                                                                                                            IDACI


Module           Date items                             Codesets                             Module         Date items                                Codesets
4 SEN            Member of SEN Unit, special class or                                        5 Exclusions   Exclusion Category                        Pupil Exclusion Reason
                 resourced provision
                 Member of SEN Unit or special class                                                        Exclusion Reason
                 Member of Resourced provision                                                              Exclusion Start Date
                 SEN Provision                          Pupil SEN provision                                 Exclusion Start Date
                 Pupil date placed upon stage           Pupil SEN Type                                      Exclusion Start (am/pm)
                 Pupil date of next SEN review                                                              Exclusion End Date
                 Pupil SEN Type ranking                                                                     Exclusion Actual Number of Sessions
                 Pupil SEN type code                                                                        Exclusion Appeal Indicator
                 National Curriculum Modification or                                                        Exclusion Appeal Date
                 Disapplication
                 National Curriculum Subject                                                                Exclusion Appeal Result
                 Pupil Medical Flag                                                                         Exclusion Reinstatement Date
                 Pupil Medical Condition/ Notes                                                             Date of exclusion notification by
                                                                                                            Headteacher
                 Paramedical support                                                                        Date of Governors' Meeting re exclusion

                                                                                                            Date of exclusion hearing/expiration of
                                                                                                            notice of appeal


Module           Date items                             Codesets                             Module         Date items                                Codesets
6 Home           Pupil Address Type                     AddressType                          6 Home         Property Easting
Information      SAON                                                                        Information    Property Northing
                 SAON Start Number                                                           (Continued)    OSAPR
                 SAON Start Number Suffix                                                                   Address Line 1
                 SAON End Number                                                                            Address Line 2
                 SAON End Number Suffix                                                                     Address Line 3
                 SAON Description                                                                           Address Line 4
                 PAON                                                                                       Address Line 5
                 PAON Start Number                                                                          International Address Line 1
                 PAON Start Number Suffix                                                                   International Address Line 2
                 PAON End Number                                                                            International Address Line 3
                 PAON End Number Suffix                                                                     International Address Line 4
                 PAON Description                                                                           International Address Line 5
                 Street                                                                                     International Post Code
                 Locality                                                                                   ISO 3166-1 Alpha-3 Code                   Nation states and countries
                 Town                                                                                       ISO 3166-1 Alpha-2 Code                   Nation states and countries
                 Administrative Area                                                                        ISO 3166-1 Numeric-3 Code                 Nation states and countries
                 Post town                                                                                  ISO 3166-1 Short Country Name             Nation states and countries
                 Postcode                                                                                   ISO 3166-1 Long Country Name              Nation states and countries
                 Postcode                                                                                   Telephone Type                            PhoneType




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                      Page 4 of 90                                                                    Date last updated: 1/13/2011
Data items and codesets by module in the new CBDS spreadsheets

                  UPRN                                                                                                 Telephone Type                         Telephone Type
                  Unique Property Reference Number                                                                     Telephone Number
                  Unique Street Reference Number (Old)                                                                 Start date at address
                  Unique Street Reference Number                                                                       End date at address


Module            Date items                                    Codesets
7 Home Location Enumeration district
Context         LA Electoral Ward Code
                  LA Electoral Ward Name
                  Parliamentary Constituency Code
                  Parliamentary Constituency Name
                  Parish Council
                  Church of England Diocese                     Church dioceses
                  Church of England Parish
                  Roman Catholic Diocese                        Church dioceses
                  Roman Catholic Parish
                  Learning & Skills Council Code                LSC Area list
                  Catchment area


Module            Date items                                    Codesets                                 Module        Date items                             Codesets
8 Contact         Contact Priority                                                                       8 Contact     Unique Property Reference Number
Information       Contact Title                                                                          Information   UPRN
                  Contact Last Name                                                                      (Continued)   Unique Street Reference Number (Old)

                  Contact First Name                                                                                   Unique Street Reference Number
                  Contact Middle Name                                                                                  Property Easting
                  Contact Gender                                                                                       Property Northing
                  Contact Relationship to Pupil                 Relationship                                           OSAPR
                  Contact Relationship to pupil/child           Relationship v2.0                                      Address Line 1
                  Contact Relationship to pupil/child           SIFRelationship                                        Address Line 2
                  (extended list as used in SIF Data Model)

                  Contact Responsibility to Pupil                                                                      Address Line 3
                  Contact Member of Armed Forces Indicator                                                             Address Line 4

                  Contact Translator or Interpreter Indicator                                                          Address Line 5

                  Contact Language Code                         Language code list                                     International Address Line 1
                  Contact Language Code                         Language code list v2.0                                International Address Line 2
                  Contact Email Address                                                                                International Address Line 3
                  Contact Address Type                          Address Type                                           International Address Line 4
                  SAON                                                                                                 International Address Line 5
                  SAON Start Number                                                                                    Zip Code
                  SAON Start Number Suffix                                                                             International Post Code
                  SAON End Number                                                                                      ISO 3166-1 Alpha-3 Code                Nation states and countries
                  SAON End Number Suffix                                                                               ISO 3166-1 Alpha-2 Code                Nation states and countries
                  SAON Description                                                                                     ISO 3166-1 Numeric-3 Code              Nation states and countries




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                  Page 5 of 90                                                               Date last updated: 1/13/2011
Data items and codesets by module in the new CBDS spreadsheets

                 PAON                                                                                                    Country Name                                 Nation states and countries
                 PAON Start Number                                                                                       ISO 3166-1 Short Country Name                Nation states and countries
                 PAON Start Number Suffix                                                                                ISO 3166-1 Long Country Name                 Nation states and countries
                 PAON End Number                                                                                         Contact Telephone Type
                 PAON End Number Suffix                                                                                  Contact Telephone Type                       Telephone Type
                 PAON Description                                                                                        Contact Telephone Number
                 Street                                                                                                  Day location
                 Locality                                                                                                Preference for written communication
                                                                                                                         indicator
                 Town                                                                                                    Contact priority source                      Contact Priority Source
                 Administrative Area                                                                                     Child is resident with contact indicator
                 Post Town                                                                                               Address can be disclosed indicator
                 Postcode                                                                                                Contact address should be transferred with
                                                                                                                         pupil indicator
                 Postcode


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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                     Page 6 of 90                                                                     Date last updated: 1/13/2011
10 Previous
School History

Data items and codesets by module in the new CBDS spreadsheets

                 Pupil Reason for Leaving                                                                       Module          Date items                        Codesets
                 Reason for leaving                          LeavingReason v2.0                                 13 Admissions   Admissions entry year and month
                 Last School                                                                                                    Admissions entry year group       Entry year group
                                                                                                                                Status                            Status type
Module           Date items                                  Codesets                                                           Text (file header)
12 Assessment    Assessment Identifier                       Assessment IDs                                                     Application reference
                 Assessment Year                                                                                                Statemented
                 Assessment Locale                                                                                              Verified (address)
                 Assessment Locale                                                                                              Preference Rank
                 Assessment Date                                                                                                Preference reason                 Reason codes
                 Assessment / Examination Season             Season                                                             Preference reason text
                 Assessment Result Indicator                 Result                                                             Aptitude code                     Aptitude Code
                 Assessment Subject                          Assessment subjects                                                Aptitude text
                 Examination Subject                         Assessment subjects                                                Faith                             Faith
                 Assessment Type                             Assessment types                                                   Faith text
                 Assessment Component                        Assessment component details                                       Distance from school
                 Component Result Type                       Assessment component result type                                   LA pre banding information        Pre Banding categories
                 Component Result                            Assessment component details                                       LA 'other' text
                 Awarding Body/ Examination Board            Awarding bodies and examination boards                             Local reference

                 Examination Syllabus Number                 Key Stage 4 and 5 syllabuses                                       Medical or social information
                 Points Scores                                                                                                  Offer status                      Offer status
                 Assessment Year                                                                                                Criterion
                 Average Points Score                                                                                           Priority
                 Subject Points                                                                                                 Admission policy criterion
                 Assessment Subject                          Assessment subjects                                                Notification method               Notification method
                 CVA Calculation Prior Points Score                                                                             Ranking of offers


Module           Date items                                  Codesets
14 QAN Web       Qualifications                              QAN_Current_V1.1.xml
Services         Qualification                               QAN_Expired_V1.1.xml
                 Qualification Identifier
                 Qualification Accreditation Number
                 Awarding Body Code
                 Qualification Type Code
                 Discount Code Map Code
                 Discount Code
                 Qualification Full Title
                 Qualification Short Title
                 Accreditation Start Date
                 Accreditation End Date
                 Certification End Date
                 Approval Start Date
                 Approval End Date
                 Sector Subject Framework Tier 2 Code
                 Sector Subject Framework Tier 1 Code
                 National Qualification Framework Level(s)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                         Page 7 of 90                                                             Date last updated: 1/13/2011
Data items and codesets by module in the new CBDS spreadsheets

                 Effective From Date
                 Effective To Date
                 Last Updated Date
                 Awarding Bodies                              QAN_AB_V1.0.xml
                 Awarding Body
                 Awarding Body Identifier
                 Awarding Body Code
                 Awarding Body Name
                 Awarding Body Acronym
                 Effective From Date
                 Effective To Date
                 Last Updated Date
                 Qualification Types                          QAN_QualType_V1.0.xml
                 Qualification Type
                 Qualification Type Identifier
                 Qualification Type Code
                 Qualification Type Description
                 National Qualification Framework Level(s)
                 Discount Family
                 Qualification Code
                 Effective From Date
                 Effective To Date
                 Last Updated Date
                 Discount Code Mappings                       QAN_Map_V1.0.xml
                 Discount Code Mapping
                 Discount Code Map Identifier
                 Discount Code Map Code
                 Discount Code Map Description
                 Effective From Date
                 Effective To Date
                 Last Updated Date
                 Discount Codes                               QAN_DiscCode_V1.1.xml
                 Discount Code
                 Discount Code Identifier
                 Discount Code
                 Discount Code Description
                 Sector Subject Framework Tier 2 Code
                 Sector Subject Framework Tier 1 Code
                 Discount Code Map Code
                 Effective From Date
                 Effective To Date
                 Last Updated Date
                 SSF Tier 2 Data                              QAN_SSFT2_V1.1.xml
                 SSF Tier 2
                 Sector Subject Framework Tier 2 Identifier
                 Sector Subject Framework Tier 2 Code
                 Description




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                              Page 8 of 90   Date last updated: 1/13/2011
                                                              QAN_SSFT2_V1.1.xml


Data items and codesets by module in the new CBDS spreadsheets

                 Sector Subject Framework Tier 1 Code
                 Description
                 Effective From Date
                 Effective To Date
                 Last Updated Date
                 SSF Tier 1 Data                              QAN_SSFT1_V1.1.xml
                 SSF Tier 1
                 Sector Subject Framework Tier 1 Identifier
                 Sector Subject Framework Tier 1 Code
                 Description
                 Effective From Date
                 Effective To Date
                 Last Updated Date
                 Qualification Type Points Data               QAN_QualTypePoints_V1.2.xml
                 Qualification Type Identifier
                 Qualification Grade Points
                 Qualification Grade
                 UCAS Points Score
                 QCA Points Score
                 Qualification Message Header
                 File Content
                 Version
                 Date and Time




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                    Page 9 of 90   Date last updated: 1/13/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).




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                         Page 10 of 91                                                                                      Date last updated: 1/13/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).




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                              Page 11 of 91                                                                                             Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                       Page 12 of 91                                                                                        Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                  Page 13 of 91                                                                                    Date last updated: 1/13/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.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                        Page 14 of 91                                           Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                          Page 15 of 91                                                                                      Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                          Page 16 of 91                                                                                           Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                Page 17 of 91                                                                       Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                 Page 18 of 91                                                                                         Date last updated: 1/13/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.”)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                           Page 19 of 91                                                                              Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                       Page 20 of 91                                                                                            Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                    Page 21 of 91                                                                                                Date last updated: 1/13/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.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                        Page 22 of 91                                                                Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                             Page 23 of 91                                                                  Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                     Page 24 of 91   Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                              Page 25 of 91                                                                                 Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                             Page 26 of 91                                                                                       Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                             Page 27 of 91                                                                          Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                   Page 28 of 91   Date last updated: 1/13/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 Rank order of the 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               Indicates whether the National A(1)           M (National Curriculum                   S          Modification                                                 S       2000-08-11            1
           Curriculum             Curriculum has been modified                  modified) or N (National
           Modification or        or disapplied due to the nature               Curriculum disapplied)
           Dissapplication        of the special need

    100083 National               National Curriculum subject     A(3)          National Curriculum                      M          Subject                                                      S       2004-05-31            1
           Curriculum             for which modification or                     Subject - See Assessment
           Subject                disapplication applies                        Module

    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.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                 Page 29 of 91                                                                                                Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                       Page 30 of 91                                                                           Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                  Page 31 of 91   Date last updated: 1/13/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.)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                           Page 32 of 91                                                                            Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                             Page 33 of 91                                                                                            Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                         Page 34 of 91   Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                           Page 35 of 91                                                                            Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                              Page 36 of 91                                                                                Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                  Page 37 of 91                                                                                         Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                Page 38 of 91                                                                                       Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                      Page 39 of 91                                                                 Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                Page 40 of 91                                                                       Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                         Page 41 of 91                                                                  Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                       Page 43 of 91                                                                                   Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                            Page 44 of 91                                                                                             Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                              Page 45 of 91                                                                        Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                          Page 46 of 91                                                                           Date last updated: 1/13/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.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                Page 47 of 91                                                                                                Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                               Page 48 of 91                                                                              Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                       Page 49 of 91                                                                             Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                              Page 50 of 91                                                                                     Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                        Page 51 of 91                                                   Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                        Page 52 of 91   Date last updated: 1/13/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       A subset of the codeset is used   O       2006-01-31                 2006-09-01
           codes               afternoon registration marks.                                                                                      for School Census
                               New attendance codes
                               effective from September
                               2006 (England)
                                                                                                                                                                                                              1
    100338 Attendance          Pupil level morning and       A(999)          Pupil Attendance Codes             M          AttendanceMarks        Attendance codes for a pupil     O        2007-02-05                 2007-02-05
           marks for all       afternoon registration marks.                                                                                      covering a number of sessions
           sessions            This data item is a                                                                                                eg covering a whole term may be
                               concatenation of all session                                                                                       shown together as a string for
                               attendance codes for each                                                                                          transfer between schools/LAs via
                               pupil. New attendance codes                                                                                        CTF. NOTE : \ in XML is a
                               effective from September                                                                                           special character but should not
                               2006 (England)                                                                                                     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          AlternativeTuition                                       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 100234 is    O       2006-01-31
           category                                                                                                                               true                                                        1




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                        Page 53 of 91                                                                                        Date last updated: 1/13/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
    100236 Alternative tuition   Date on which the Alternative CCYY-MM-DD                                        M          AlternativeTuitionStart   Must not be blank if 100234 is   O       2006-01-31
           start date            Tuition started                                                                                                      true                                                       1
    100237 Alternative tuition   Date on which the Alternative CCYY-MM-DD                                        M          AlternativeTuitionEnd                                      O       2006-01-31
           end date              Tuition ended                                                                                                                                                                   1
    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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                         Page 54 of 91                                                                                            Date last updated: 1/13/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     Late (before registers closed) marked as present
      Authorised absence due to Illness (NOT medical 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 age absence - not counted in possible
      Non-compulsory school
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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                        Page 55 of 91                                                       Date last updated: 1/13/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          LeavingReason                                   S       2006-12-31            1
            Leaving           school prior to current school




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                                Page 56 of 91                                                                                  Date last updated: 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                Page 57 of 91                                                                Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                    Page 58 of 91   Date last updated: 1/13/2011
  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”.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                            Page 59 of 91                                                                                        Date last updated 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                   Page 60 of 91                                                                                      Date last updated 1/13/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.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                      Page 61 of 91                                                                       Date last updated 1/13/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.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                     Page 62 of 91                                                             Date last updated 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                  63 of 91                                              Date last updated 1/13/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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls   64 of 91   Date last updated 1/13/2011
  11 Post 16
 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                                                                                                 Post16Courses
    100246 Post Advanced      Indicates whether a pupil is A(5)      1,0 or true, false               S          AdvancedCourse   <AdvancedCourse> must be           S      2005-04-30            2                      2006-12-31
           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                      2006-12-31
           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            2                      2006-12-31
           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                      2006-12-31
           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            2                      2006-12-31
           Subjects being being taken by pupil
           studied
    100251 GNVQ level     Indicates whether a pupil is      9        GNVQ Level                       S          GNVQs                                              S       2005-04-30            2                      2006-12-31
                          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            2                      2006-12-31
           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            2                      2006-12-31
                          not taking a NVQ or is taking a
                          NVQ level 1, 2 or 3




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                              Page 65 of 91                                                                                      Date last updated: 1/13/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                                                                                                              Post16Courses
    100254 Other Post-16     Indicates whether a pupil is   A(1)           Other Post16 Courses                    S          Other                                                      S       2005-04-30            2                      2006-12-31
           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
 Post-16 Learning Aims                                                                                                        LearningAims
 Post-16 Learning Aim                                                                                                         LearningAim
    100255 Qualification      Unique number identifying      A(8)          QAN data available for                  M          QAN                        1st and 8th characters can be 0- S      2006-01-31            1 2007-10-04
            Accreditation     learning aim / course of study               download at                                                                   9 or A-Z (upper case)                                           School Census
            Number                                                         http://data.dfes.gov.uk/qws                                                   Characters 2-7 must be numeric                                  October 07
                                                                           web/Main.aspx
    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)          Discount Code data                 0000 M          DiscCode                   QAN_DiscCode_Table.XSD          S       2006-12-31            1 2007-10-04
                              together identify the subject                available for download at                                                                                                                     School Census
                              studied where the QAN on its                 http://data.dfes.gov.uk/qws                                                                                                                   October 07
                              own does not                                 web/Main.aspx
 Pupil Leaving Destination                                                                                                    DestSchool
    100261 LA Number for      LA number for destination                    LEA list available at                   S          LEA                                                        O       2006-01-31            1
             Destination      school or college                            http://www.teachernet.gov.
             School                                                        uk/management/ims/datam
                                                                           anagement/cbds/CBDSspe
                                                                           cs/




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                           Page 66 of 91                                                                                              Date last updated: 1/13/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                                                                                                           Post16Courses
    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,
    100262 Destination      To manage performance of     A(2)                                                   S          LeavingDestination     incl. 9565 for Blaby Community 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




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                        Page 67 of 91                                                                                          Date last updated: 1/13/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)




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                        Page 68 of 91                                                                 Date last updated: 1/13/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/management/ims/datam
                                                                          anagement/cbds/CBDSspe
                                                                          cs/
    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)                                                  S          Subject                               S       2004-05-31            1
           Subject            below)                                      Assessment subjects
                                                                          available at
                                                                          http://www.teachernet.gov.uk/
                                                                          management/ims/datamanag
                                                                          ement/cbds/CBDSspecs/
    100272 Examination     Subject of exam (KS4 and          A(6)         Under review (see QAN                     S          ExamSubject                           S       2004-05-31            1
           Subject         above)                                         Web Services Module)
    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/management/ims/datam
                                                                          anagement/cbds/CBDSspe
                                                                          cs/
    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/management/ims/datam
                                                                          anagement/cbds/CBDSspe
                                                                          cs/




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                            Page 69 of 91                                                                         Date last updated: 1/13/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
    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/management/ims/datam
                                                                    anagement/cbds/CBDSspe
                                                                    cs/
    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/management/ims/datam
                                                                    anagement/cbds/CBDSspe
    100277 Awarding Body/ Name of awarding body/exam A(3)           cs/
                                                                    Under review (see QAN                  M          ExamBoard                                S       2001-05-04            1
           Examination     board                                    Web Services Module)
           Board
    100278 Examination     Exam board syllabus ID    A(6)           Under review (see QAN                  M          ExamBoardSyllabusID                      S       2001-05-04            1
           Syllabus Number                                          Web Services Module)

           Points Scores                                                                                              PointsScores
    100266 Assessment Year Calendar year of assessment CCYY                                                S          Year                                     S       2001-05-04            1

    100339 Average Points    Average Points Score          99.99                                           S          APS                                      S       2007-06-20            1
           Score             (English, Mathematics and
                             Science)
           Subject Points                                                                                             SubjectPoints
    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
    100340 CVA Calculation   Point scores based on the      99.99                                          S          CvaPriorPoints                           S       2007-06-20            1
           Prior Points      decimalised National
           Score             Curriculum levels for use in
                             the Contextual Value-Added
                             (CVA) calculation. This should
                             only be populated for KS2 and
                             KS3.




7b8db11f-e1ca-43ef-b01c-e24df3e13649.xls                                                                   Page 70 of 91                                                                            Date last updated: 1/13/2011
Pupil Level: Assessment Module Codesets
Season
S        Summer
W        Winter
M        Modular/Continuous Assessment
1-9      Jan-September
a-c      October-December



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

Identifier Title               Description                         Format     Codeset
(New
CBDS Ref
No)
           Qualifications      Qualifications Dataset

          Qualification        Individual Qualification
   100341 Qualification        Unique identifier for a             99999999
          Identifier           qualification

   100255 Qualification        Number allocated by QCA        A(8)            Qualification Accreditation
          Accreditation        identifying a qualification /                  Number (QAN).
          Number               learning aim / course of study                 Files containing current and
                                                                              expired QAN data are
                                                                              available for download from
                                                                              the QAN Web Services web
                                                                              site - see codesets page for
                                                                              URL details).

   100342 Awarding Body        Identifier for an awarding body A(3)           See codesets page for URL
          Code




   100343 Qualification Type Identifier for a qualification        A(3)       See codesets page for URL
          Code               type




   100344 Discount Code        Indicates whether the               A(4)       See codesets page for URL
          Map Code             Discount Code is either a
                               LEAP or LDCS code


   100337 Discount Code        Identifier indicating the       A(4)           See codesets page for URL
                               qualification subject. Discount
                               code and QAN together
                               identify the subject studied
                               where the QAN on its own
                               does not



   100345 Qualification Full   Official full title of the          A(165)
          Title                qualification. (Will include
                               reference to the awarding
                               body, NQF level and the
                               subject.)
   100346 Qualification        Short title of the qualification.   A(55)
          Short Title          (Will not include reference to
                               the awarding body or NQF
                               level.)
100347 Accreditation       Date from which QCA           CCYY-MM-DD
       Start Date          accreditation starts




100348 Accreditation End Date upon which QCA             CCYY-MM-DD
       Date              accreditation ends




100349 Certification End   Last date upon which          CCYY-MM-DD
       Date                awarding bodies may issue
                           certificates.


100350 Approval Start      Date from which Section 96    CCYY-MM-DD
       Date                approval starts




100351 Approval End        Date upon which Section 96    CCYY-MM-DD
       Date                approval ends




100352 Sector Subject   QCA issued code number           A(4)            See codesets page for URL
       Framework Tier 2
       Code


100353 Sector Subject   QCA issued code number           A(2)            See codesets page for URL
       Framework Tier 1
       Code


100354 National            Single or multiple            A(8)            Instances (single or multiple)
       Qualification       (concatenated) NQF level(s)                   may be:
       Framework                                                         E, E1, E2, E3 or 0-9
       Level(s)                                                          Multpile instances indicated by
                                                                         separating semi-colon, e.g.
                                                                         E1;E2;E3
100355 Effective From      Date from which the              CCYY-MM-DD
       Date                qualification is to be available
                           in live systems (not the date
                           from which the qualification is
                           available to study)

100356 Effective To Date Last date upon which the         CCYY-MM-DD
                         qualification is to be available
                         in live systems (not the last
                         date upon which the
                         qualification is available to
                         study)
100357 Last Updated        Date the record for the        CCYY-MM-DD
       Date                qualification was last updated

        Awarding Bodies Awarding Body Dataset

        Awarding Body      Individual Awarding Body
100358 Awarding Body        Unique identifier for an       99999999
       Identifier           awarding body

100342 Awarding Body        Unique identifier for an       A(3)        See codesets page for URL
       Code                 awarding body




100359 Awarding Body        Name of Awarding Body (or      A(130)
       Name                 Awarding Body Partnership)




100360 Awarding Body        Awarding Body (or              A(20)
       Acronym              Partnership) Acronym(s)




100355 Effective From     Date from which the awarding CCYY-MM-DD
       Date               body is to be available in live
                          systems
100356 Effective To Date Last date upon which the         CCYY-MM-DD
                          awarding body is to be
                          available in live systems
100357 Last Updated       Date the record for the         CCYY-MM-DD
       Date               awarding body was last
                          updated
       Qualification      Qualification Type Dataset
       Types
       Qualification Type Individual Qualification Type

100361 Qualification Type Unique identifier for a          99999999
       Identifier         qualification type

100343 Qualification Type Identifier for a qualification   A(3)        See codesets page for URL
       Code               type




100362 Qualification Type Qualification Type Description A(75)
       Description




100354 National             Single or multiple             A(8)        Instances (single or multiple)
       Qualification        (concatenated) NQF level(s)                may be:
       Framework                                                       E, E1, E2, E3 or 0-9
       Level(s)                                                        Multpile instances indicated by
                                                                       separating semi-colon, e.g.
                                                                       E1;E2;E3
100363 Discount Family      DfES Qualification Type        A(3)
                            classification




100364 Qualification        DfES internal code number      A(3)
       Code
100355 Effective From    Date from which the             CCYY-MM-DD
       Date              qualification type is to be
                         available in live systems
100356 Effective To Date Last date upon which the        CCYY-MM-DD
                         qualification type is to be
                         available in live systems
100357 Last Updated      Date the record for the         CCYY-MM-DD
       Date              qualification type was last
                         updated
       Discount Code     Mapping Dataset
       Mappings
       Discount Code     Individual Mapping
       Mapping
100365 Discount Code     Unique identifier for a map     99999999
       Map Identifier    code

100344 Discount Code      Discount Code Map Code         A(4)         See codesets page for URL
       Map Code




100366 Discount Code      Map Description                A(40)
       Map Description

100355 Effective From    Date from which the map code CCYY-MM-DD
       Date              is to be available in live
                         systems
100356 Effective To Date Last date upon which the map CCYY-MM-DD
                         code is to be available in live
                         systems
100357 Last Updated      Date the record for the map     CCYY-MM-DD
       Date              code was last updated

        Discount Codes    Discount Code Dataset

       Discount Code      Individual Discount Code
100367 Discount Code      Unique identifier for a        99999999
       Identifier         Discount Code

100337 Discount Code      Identifier indicating the       A(4)        See codesets page for URL
                          qualification subject. Discount
                          Code and QAN together
                          identify the subject studied
                          where the QAN on its own
                          does not



100368 Discount Code      Discount Code Description      A(60)
       Description




100352 Sector Subject   QCA issued code number           A(4)
       Framework Tier 2
       Code
100353 Sector Subject   QCA issued code number               A(2)
       Framework Tier 1
       Code


100344 Discount Code        Indicates whether the            A(4)
       Map Code             Discount Code is either a
                            LEAP or LDCS code


100355 Effective From      Date from which the Discount      CCYY-MM-DD
       Date                Code is to be available in live
                           systems
100356   Effective To Date Last date upon which the          CCYY-MM-DD
                           Discount Code is to be
                           available in live systems
100357   Last Updated      Date the record for the           CCYY-MM-DD
         Date              Discount Code was last
                           updated
         SSF Tier 2 Data Sector Subject Framework
                           Tier 2 Dataset
         SSF Tier 2        Individual SSF Tier 2
100369   Sector Subject    Unique identifier for a Sector    99999999
         Framework Tier 2 Subject Framework Tier 2
         Identifier        category
100352   Sector Subject    QCA issued code number            A(4)         See codesets page for URL
         Framework Tier 2
         Code


100370 Sector Subject   SSF Tier 2 Category                  A(55)
       Framework Tier 2 Description
       Description


100353 Sector Subject   QCA issued code number               A(2)
       Framework Tier 1
       Code


100371 Sector Subject   SSF Tier 1 Category                  A(50)
       Framework Tier 1 Description
       Description


100355 Effective From    Date from which the SSFT2       CCYY-MM-DD
       Date              Code is to be available in live
                         systems
100356 Effective To Date Last date upon which the        CCYY-MM-DD
                         SSFT2 Code is to be available
                         in live systems
100357 Last Updated      Date the record for the SSFT2 CCYY-MM-DD
       Date              Code was last updated

         SSF Tier 1 Data    Sector Subject Framework
                            Tier 1 Dataset
         SSF Tier 1         Individual SSF Tier 1
100372 Sector Subject      Unique identifier for a Sector   99999999
       Framework Tier 1    Subject Framework Tier 1
       Identifier          category
100353 Sector Subject      QCA issued code number           A(2)          See codesets page for URL
       Framework Tier 1
       Code


100371 Sector Subject   SSF Tier 1 Category                 A(50)
       Framework Tier 1 Description
       Description


100355 Effective From    Date from which the SSFT1       CCYY-MM-DD
       Date              Code is to be available in live
                         systems
100356 Effective To Date Last date upon which the        CCYY-MM-DD
                         SSFT1 Code is to be available
                         in live systems
100357 Last Updated      Date the record for the SSFT1 CCYY-MM-DD
       Date              Code was last updated

        Qualification Type Qualification Type Points
        Points Data        Dataset

100361 Qualification Type Unique identifier for a           99999999      See codesets page for URL
       Identifier         qualification type

       Qualification       Qualification Type Grade
       Grade Points        Points
100373 Qualification       Qualification Grade              A(3)
       Grade

100374 UCAS Points    UCAS Points Score based on 999                      0-800
       Score          the Qualification Type and the
                      Grade achieved
100375 QCA Points     QCA Points Score based on 9999.99                   0-1500
       Score          the Qualification Type and the
                      Grade achieved
       Qualification  Qualification Message Header
       Message Header (applicable to all data files)

100376 File Content        Description of File              A(255)
                           Contents

100377 Version             Version Number of the            99.99
                           relevant XML Schema file
                           (.XSD)
100378 Date and Time       Date and Time of the File        CCYY-MM-
                                                            DDT HH:MM:S
                                                            S
Default   Allow      XML Tag              Validation Rules                 Item Date            Data
Value     Multiple                                                         Level Created        Item
          Entries?                                                                              Status
          (S, M)
                     Qualifications       Refer to XML Schema file - for
                                          URL see codesets page.
                     Qualification
          M          QAN_ID                                                S       2007-06-06            1


          M          QAN                                                   S       2006-01-31            1




          M          AB                                                    S       2007-06-06            1




          M          QualType                                              S       2007-06-06            1




          M          Map                                                   S       2007-06-06            1




     0000 M          DiscCode                                              S       2006-12-31            1




          M          QualificationTitle                                    S       2007-06-06            1




          M          QualShortTitle                                        S       2007-06-06            1
M   AccStartDate                                        S   2007-06-06   1




M   AccEndDate                                          S   2007-06-06   1




M   CertEndDate                                         S   2007-06-06   1




M   AppStartDate                                        S   2007-06-06   1




M   AppEndDate                                          S   2007-06-06   1




M   SSFT2                                               S   2007-06-06   1




M   SSFT1                                               S   2007-06-06   1




M   NQF                                                 S   2007-06-06   1




M   EffectiveFrom                                       S   2007-06-06   1




M   EffectiveTo                                         S   2007-06-06   1




M   LastUpdated                                         S   2007-06-06   1


    AwardingBodyData   Refer to XML Schema file - for
                       URL see codesets page.
    AwardingBody
M   AB_ID                                                       S   2007-06-06   1


M   AB                                                          S   2007-06-06   1




M   AwardingBodyName                                            S   2007-06-06   1




M   AB_Acronym                                                  S   2007-06-06   1




M   EffectiveFrom                                               S   2007-06-06   1


M   EffectiveTo                                                 S   2007-06-06   1


M   LastUpdated                                                 S   2007-06-06   1


    QualificationTypeData      Refer to XML Schema file - for
                               URL see codesets page.
    QualificationType

M   QualType_ID                                                 S   2007-06-06   1


M   QualType                                                    S   2007-06-06   1




M   QualificationDescription                                    S   2007-06-06   1




M   NQF                                                         S   2007-06-06   1




M   DiscountFamily                                              S   2007-06-06   1




M   QualCode                                                    S   2007-06-06   1
    M    EffectiveFrom                                          S   2007-06-06   1


    M    EffectiveTo                                            S   2007-06-06   1


    M    LastUpdated                                            S   2007-06-06   1


         MappingData           Refer to XML Schema file - for
                               URL see codesets page.
         MapData

    M    Map_ID                                                 S   2007-06-06   1


    M    Map                                                    S   2007-06-06   1




    M    MapDescription                                         S   2007-06-06   1


    M    EffectiveFrom                                          S   2007-06-06   1


    M    EffectiveTo                                            S   2007-06-06   1


    M    LastUpdated                                            S   2007-06-06   1


         DiscountCodeData      Refer to XML Schema file - for
                               URL see codesets page.
         DiscountCode
    M    DiscCode_ID                                            S   2007-06-06   1


0000 M   DiscCode                                               S   2006-12-31   1




    M    DiscCodeDescription                                    S   2007-06-06   1




    M    SSFT2                                                  S   2007-06-06   1
M   SSFT1                                                     S   2007-06-06   1




M   Map                                                       S   2007-06-06   1




M   EffectiveFrom                                             S   2007-06-06   1


M   EffectiveTo                                               S   2007-06-06   1


M   LastUpdated                                               S   2007-06-06   1


    SectorSubjectTier2Data   Refer to XML Schema file - for
                             URL see codesets page.
    SectorSubjectTier2
M   SSFT2_ID                                                  S   2007-06-06   1


M   SSFT2                                                     S   2007-06-06   1




M   SSFT2Description                                          S   2007-06-06   1




M   SSFT1                                                     S   2007-06-06   1




M   SSFT1Description                                          S   2007-06-06   1




    EffectiveFrom                                             S   2007-06-06   1


    EffectiveTo                                               S   2007-06-06   1


    LastUpdated                                               S   2007-06-06   1


    SectorSubjectTier1Data   Refer to XML Schema file - for
                             URL see codesets page.
    SectorSubjectTier1
M   SSFT1_ID                                                    S   2007-06-06   1


M   SSFT1                                                       S   2007-06-06   1




M   SSFT1Description                                            S   2007-06-06   1




M   EffectiveFrom                                               S   2007-06-06   1


M   EffectiveTo                                                 S   2007-06-06   1


M   LastUpdated                                                 S   2007-06-06   1


    QualificationTypePoints   Refer to XML Schema file - for
                              URL see codesets page.

M   QualType_ID                                                 S   2007-06-06   1


    GradePoints

M   QualGrade                                                   S   2007-06-06   1


M   UCAS_Pts                                                    S   2007-06-06   1


M   QCA_Pts                                                     S   2007-06-06   1


    Header                    Refer to XML Schema files - for
                              URL see codesets page.

M   FileContent                                                 S   2007-06-06   1


M   Version                                                     S   2007-06-06   1



M   DateTime                                                    S   2007-06-06   1
Implementation   Cut-off Date
Date




2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-10-04
School Census
October 07

2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-10-04
School Census
October 07
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services

2007-04-01
QAN Web
Services




2007-04-01
QAN Web
Services




2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services




2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services

2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services




2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services




2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-10-04
School Census
October 07
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services




2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2006-11-01
PLAMS 06/07
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services




2007-04-01
QAN Web
Services


2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services




2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
2007-04-01
QAN Web
Services
Pupil Level: QAN Web Services Module Codesets
All datasets are available from the QAN Web Services (QWS) site:
http://data.dfes.gov.uk/qwsweb/Default.aspx
QWS URL for downloading Qualification data and XML schema files:
http://data.dfes.gov.uk/qwsweb/Main.aspx
The URLs for individual XML schema files are listed below:
Qualifications
http://data.dfes.gov.uk/qwsweb/XSDs/QAN_Main_V1.1.xsd
Awarding Bodies
http://data.dfes.gov.uk/qwsweb/XSDs/QAN_AB_V1.0.xsd
Qualification Types
http://data.dfes.gov.uk/qwsweb/XSDs/QAN_QualType_V1.0.xsd
Discount Code Mapping
http://data.dfes.gov.uk/qwsweb/XSDs/QAN_Map_V1.0.xsd
Discount Codes
http://data.dfes.gov.uk/qwsweb/XSDs/QAN_DiscCode_V1.1.xsd
Sector Subject Framework Tier 2
http://data.dfes.gov.uk/qwsweb/XSDs/QAN_SSFT2_V1.1.xsd
Sector Subject Framework Tier 1
http://data.dfes.gov.uk/qwsweb/XSDs/QAN_SSFT1_V1.1.xsd
Qualification Type Points
http://data.dfes.gov.uk/qwsweb/XSDs/QAN_QualTypePoints_V1.2.xsd

								
To top