160 Uk Legal Parents Consent Letter - Excel

Document Sample
160 Uk Legal Parents Consent Letter - Excel Powered By Docstoc
					                                                                               COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                         Prime/
                                                           Max     Data      Input                      Derived                 Date to be   Date to be
    Ref. No.        Data Item               XML TAG        Len.    Level     Type Crit.  Survey/Use       Data          Links     Intro.     removed      Data Ver.               Format/Table/Defaults/Data Item Validation
      P1     Unique Pupil Number      UPN                     13           1      1 *   ASC, CTF +    Prime                                               20001010 Format: Annnnnnnnnnnn or AnnnnnnnnnnnA (for temporary UPN).
             (UPN)                                                                      Many                                                                        Any alphabetical character cannot be I, O, or S. To calculate the
                                                                                                                                                                    check letter:
                                                                                                                                                                    1. Multiply the individual digits by their weights as follows:
                                                                                                                                                                    digit 2 by weight 2; digit 3 by weight 3; digit 4 by weight 4; digit 5 by
                                                                                                                                                                    weight 5; digit 6 by weight 6; digit 7 by weight 7; digit 8 by weight 8;
                                                                                                                                                                    digit 9 by weight 9; digit 10 by weight 10; digit 11 by weight 11; digit 12
                                                                                                                                                                    by weight 12; digit 13 by weight 13.
                                                                                                                                                                    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.
                                                                                                                                                                    For calculating the check letter (see above) any alphabetical character
                                                                                                                                                                    at digit 13 is accorded the same numerical value as listed in
                                                                                                                                                                    paragraph 3 above, i.e. A=0, B=1, C=2 etc.
      P2    Pupil‟s former UPN        FormerUPN              13            1      2     ASC, CTF      Prime                                               20001010 Format: Annnnnnnnnnnn or AnnnnnnnnnnnA (for temporary UPN).
                                                                                                                                                                   For calculating the check letter (see above) any alphabetical character
                                                                                                                                                                   at digit 13 is accorded the same numerical value as listed in
                                                                                                                                                                   paragraph 3 above, i.e. A=0, B=1, C=2 etc.

      P3    Pupil Surname             Surname                30            1      1 *   ASC, CTF +    Prime                                               20001010 Any character string. The legal surname (derived from family, clan or
                                                                                        Many                                                                       marital association) of the child (as written).
      P4    Pupil Forename            Forename               15            1      1 *   ASC, CTF +    Prime                                               20001010 Any character string. The full given first name of the child (not
                                                                                        Many                                                                       common contractions).
      P5    Pupil Name Order          SurnameFirst            1            1      4     Local         Prime                                               20001122 Enter “Y” if the recorded surname (for written communication
            Indicator                                                                                                                                              purposes) should be used for familiar spoken communication
                                                                                                                                                                   (equivalent to the first name in traditional European languages). This
                                                                                                                                                                   indicator will be used primarily to identify the naming conventions used
                                                                                                                                                                   by some, predominantly non-European, ethnic or language groups.

      P6    Pupil Middle Names        MiddleNames            25            1      1     ASC, CTF +    Prime                                               20001010 Any character string. Components should be separated by a single
                                                                                        Many                                                                       space.
      P7    Pupil Date of Birth       DOB                    10            1      1 *   ASC, CTF +    Prime                                               20001010 Format YYYY-MM-DD valid date. Implied age at previous 31 August
                                                                                        Many                                                                       would normally be in the range:
                                                                                                                                                                   Primary schools 2-12; Middle schools 7-14;
                                                                                                                                                                   Secondary schools 10-19; Special schools 2–25.
      P8    Pupil Gender             Gender                   1            1      1 *   ASC, CTF      Prime                                               20001010 Table values: F = Female; M = Male.
      P9    Pupil former Surname     FormerSurname           30            1      2     ASC, CTF      Prime                                               20001010 Any character string.
      P10   Pupil Preferred Forename PreferredForename       15            1      1     CTF           Prime                                               20001010 Any character string. Common contractions, if used, may be recorded.

      P11   Pupil Preferred Surname   PreferredSurname       30            1      1     CTF           Prime                                               20001010 Any character string. The surname (as written) commonly used in the
                                                                                                                                                                   school.
      P12   Pupil Preferred Name      PreferSurnameFirst      1            1      4     Local         Prime                                               20001122 As for <SurnameFirst> above.
            Order Indicator
      P13   Pupil Ethnic Code         Ethnicity               4            1      1     ASC, CTF +    Prime                                               20001010 Table values (new): ETHLIST.XLS
                                                                                        Many                                                                       May be blank if age at previous 31 August less than 5, otherwise
                                                                                                                                                                   default to NOBT.

      P14   Source of Pupil Ethnic    EthnicitySource         1            1      2     ASC, CTF      Prime                     Spr 2002                  20001010 Table values:
            Code                                                                                                                                                   C = Child
                                                                                                                                                                   P = Parent
                                                                                                                                                                   S = Current School
                                                                                                                                                                   T = Previous School
                                                                                                                                                                   O = Other.




Version: Pupil CBDS V2.0                                                                                 Page 1 of 14                                                                                                          Printed: 12/1/2010
                                                                                     COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                                Prime/
                                                              Max        Data      Input                       Derived                 Date to be   Date to be
    Ref. No.      Data Item                      XML TAG      Len.       Level     Type Crit.   Survey/Use       Data          Links     Intro.     removed      Data Ver.             Format/Table/Defaults/Data Item Validation
     P15 Pupil Traveller/ Gypsy           Traveller                  2           1      4     Local          Prime                     Spr 2002                  20001010 Table values:
             Code                                                                                                                                                          GH = Gypsy/Roma (Housed)
                                                                                                                                                                           GT = Gypsy/Roma (Travelling)
                                                                                                                                                                           OT = Occupational Traveller
                                                                                                                                                                           TR = Traveller (Other)
                                                                                                                                                                           NT = Not a Traveller.
      P16   Source of Pupil Traveller     TravellerSource            1           1      4     Local          Prime                                               20001010 Table values:
            Indicator                                                                                                                                                      C = Child
                                                                                                                                                                           P = Parent
                                                                                                                                                                           S = School
                                                                                                                                                                           O = Other.
                                          <Nationalities>
      P17   Pupil Nationality             Nationality                3           1      4     Local          Prime                                               20040531 Table values = NATIONS.XLS
                                                                                                                                                                          New version in line with Government Data Standards Catalogue
                                                                                                                                                                          requirement to use BSEN 3166 (ISO 3166-1)
                                          </Nationalities>
      P18   Pupil Refugee / Asylum        Refugee                    1           1      4     Local          Prime                                               20001010 Refugee/Asylum Seeker?
            Seeker Indicator                                                                                                                                              Table values: Y = Yes; N = No.
                                                                                                                                                                          Must be N if <Nationality> = GBR.
                                                                                                                                                                          See Additional Explanatory Notes (1)
      P20   Pupil Country of Birth        CountryofOrigin            3           1      4     Local          Prime                                               20040531 Table values = NATIONS.XLS
                                                                                                                                                                          New version in line with Government Data Standards Catalogue
                                                                                                                                                                          requirement to use BSEN 3166 (ISO 3166-1)
      P21   Pupil Religious Affiliation   Religion                   2           1      4     Local          Prime                                               20001010 Table values:
            Code                                                                                                                                                          BU = Buddhist
                                                                                                                                                                          CH = Christian
                                                                                                                                                                          HI = Hindu
                                                                                                                                                                          JE = Jewish
                                                                                                                                                                          MU = Muslim
                                                                                                                                                                          NO = No Religion
                                                                                                                                                                          OT = Other Religion
                                                                                                                                                                          SI = Sikh.
      P22   Pupil Religious Education ReligiousEducation             1           1      4     Local          Prime                                               20001010 Table values:
            Indicator                                                                                                                                                     W = Withdrawn from Religious Education
                                                                                                                                                                          A = Attends Religious Education.
      P23   Pupil Collective Worship      CollectiveWorship          1           1      4     Local          Prime                                               20001010 Table values:
            Indicator                                                                                                                                                     W = Withdrawn from Collective Worship
                                                                                                                                                                          A = Attends Collective Worship.
      P24   Pupil Home LEA                HomeLEA                    3           2      2     F8A            Prime                                               20001010 Table values = LEALIST.XLS. Available at
                                                                                                                                                                          http://www.teachernet.gov.uk/docbank/index.cfm?id=953
                                                                                                                                                                          See also Additional Explanatory Notes (2)




Version: Pupil CBDS V2.0                                                                                        Page 2 of 14                                                                                                  Printed: 12/1/2010
                                                                                      COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                                Prime/
                                                               Max        Data      Input                      Derived                 Date to be   Date to be
    Ref. No.           Data Item               XML TAG         Len.       Level     Type Crit.  Survey/Use       Data          Links     Intro.     removed      Data Ver.             Format/Table/Defaults/Data Item Validation
     P25 Pupil Free School Meal         FSMeligible                   1           1      1 *   ASC, CTF      Prime                                               20001010 true/false or 1/0.
             Eligibility
     P26 Pupil Free School Meal         FSMreviewDate             10              2      1     CTF           Prime                                               20001010 Format YYYY-MM-DD. Valid date after current date.
             Review Date
     P27 Pupil Free School              FreeTransport                 1           1      1     Local         Prime                                               20001010 true/false or 1/0.
             Transport Eligibility
     P27a Connexions Agreement          Connexions                    3           1      2     ASC           Prime                                               20040531 (Middle, Secondary and Special Schools only.)
                                                                                                                                                                          Do parents consent to data being shared with the Connexions
                                                                                                                                                                          Service?
                                                                                                                                                                          Table Values: Yes, No, UNS=Unsought (Default), SNR=Sought No
                                                                                                                                                                          Reply.
                                        <LookedAfter>
      P28   In Care Indicator           InCare                        1           1      1     ASC, CTF      Prime                          2003                 20001010 true/false or 1/0. See http://www.dfes.gov.uk/incare/ and Additional
                                                                                                                                                                          Explanatory Notes (3a).
      P29   In Care - Caring Authority CareAuthority                  3           1      2     ASC, CTF      Prime                          2003                 20001010 Must not be blank if <InCare> is true or 1.
            Code                                                                                                                                                          Table values = LEALIST.XLS. Available at
                                                                                                                                                                          http://www.teachernet.gov.uk/docbank/index.cfm?id=953
                                                                                                                                                                          See also Additional Explanatory Notes (3b).
      P30   In Care while at current    InCareAtCurrentSchoo          1           1      2     ASC           Prime                          2003                 20001010 true,false or 1/0. Has the child ever been in care while at this school?
            school Indicator            l
      P31   Personal Education Plan     PersonalEducationPla          1           2      2     Local         Prime                                               20001010 true,false or 1/0. Has the child a Personal Education Plan (PEP)? See
            Indicator                   n                                                                                                                                 Additional Explanatory Notes (3c).
      P32   Pupil Child Protection      ProtectionRegister            1           1      1     Local         Prime                                               20001010 true/false or 1/0. See Additional Explanatory Notes (4).
            Register Indicator
                                        <LEA>
      P33   Pupil Child Protection      RegisterLEA                   3           1      1     Local         Prime                                               20001010 Must not be blank if <ProtectionRegister> = true.
            Register LEA code                                                                                                                                             Table values = LEALIST.XLS. Available at
                                                                                                                                                                          http://www.teachernet.gov.uk/docbank/index.cfm?id=953
                                                                                                                                                                          See also Additional Explanatory Notes (4).
                                        </LEA>
                                        </LookedAfter>
      P34   Pupil Enrolment Status      EnrolStatus                   1           1      2     ASC           Prime                                               20001010 Table values:
                                                                                                                                                                          C = Current (Single registration)
                                                                                                                                                                          M = Current main (Dual registration)
                                                                                                                                                                          S = Current subsidiary (Dual registration)
                                                                                                                                                                          P = Previous
                                                                                                                                                                          G = Guest pupil.
                                                                                                                                                                          Default=C
                                        <OtherSchool>
      P35   Other School LEA            LEA                           3           1      2     Local         Prime                                               20001010 Table values = LEALIST.XLS. Available at
            Number                                                                                                                                                        http://www.teachernet.gov.uk/docbank/index.cfm?id=953
                                                                                                                                                                          Must be blank if <EnrolStatus> = C.
                                                                                                                                                                          Must not be blank if <EnrolStatus> = M or S.
      P36   Other School DfES           Estab                         4           1      2     Local         Prime                                               20001010 Table values = ESTABLST.CSV
            Establishment Number                                                                                                                                          Must be blank if <EnrtolStatus> = C.
                                                                                                                                                                          Must not be blank if <EnrolStatus> = M or S.
                                        </OtherSchool>
      P37   Pupil Date of Entry         EntryDate                 10              1      1 *   ASC, CTF      Prime                                               20001010 Format YYYY-MM-DD. Valid date before or equal to current date.
                                                                                                                                                                          Mandatory if previous pupil. See Additional Explanatory Notes (5).

      P38   Pupil Date of Leaving       LeavingDate               10              1      2     ASC, CTF      Prime                                               20001010 Format YYYY-MM-DD. Valid date before or equal to current date.
                                                                                                                                                                          Mandatory if previous pupil. See Additional Explanatory Notes (5).

      P42   Pupil Part-Time Indicator   PartTime                      1           1      2     ASC           Prime                                               20000811 true/false or 1/0. For dual-registered pupils, time in other schools
                                                                                                                                                                          should be taken into consideration; e.g. 2½ days in one school and
                                                                                                                                                                          2½ days in another school should not be classified by either school as
                                                                                                                                                                          part-time.
      P43   Pupil – Number of           Sessions                      2           1      2     Local         Prime                                               20000811 Number of sessions (AM/PM) per week.
            Sessions                                                                                                                                                      If <PartTime> = N and <EnrolStatus> = C then must be 10.
                                                                                                                                                                          If <PartTime> = Y or <EnrolStatus> = M or S then must be 1-9.




Version: Pupil CBDS V2.0                                                                                        Page 3 of 14                                                                                                        Printed: 12/1/2010
                                                                                  COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                            Prime/
                                                           Max        Data      Input                      Derived                 Date to be   Date to be
    Ref. No.     Data Item                    XML TAG      Len.       Level     Type Crit.  Survey/Use       Data          Links     Intro.     removed      Data Ver.             Format/Table/Defaults/Data Item Validation
     P44 Pupil Boarder Indicator       Boarder                    1           1      2     ASC           Prime                                               20001010 Table values:
                                                                                                                                                                       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
                                                                                                                                                                       For PLASC purposes, acceptable value are:
                                                                                                                                                                       B, N (Primary, Middle and Secondary Schools)
                                                                                                                                                                       6, 7, N (Special schools).
      P45   Pupil‟s actual National    NCyearActual               2           1      1     ASC, CTF      Prime                                               20001010 Acceptable values: N1 (=Nursery first year), N2 (= nursery second
            Curriculum Year Group                                                                                                                                     year), R (= reception), 1-14, X (National Curriculum not followed).
                                                                                                                                                                      Default to N1 if age = 2 or below.
                                                                                                                                                                      Default to N2 if age = 3.
                                                                                                                                                                      Default to R if age = 4.
                                                                                                                                                                      Default to (age minus 4) if age greater than 4.
                                                                                                                                                                      If not "X", must be in range (age minus 6) to (age minus 2) if age
                                                                                                                                                                      greater than 6.
                                                                                                                                                                      Must be R, 1, 2, 3 or 4 if age = 6.
                                                                                                                                                                      Must be N1, N2, R, 1, 2 or 3 if age = 5.
                                                                                                                                                                      Must be N1, N2, R, 1 or 2 if age = 4.
                                                                                                                                                                      Must be N1, N2, R or 1 if age = 3.
                                                                                                                                                                      Must be N1, N2 or R if age = 2.
                                                                                                                                                                      (All ages are as at previous 31 August).
                                                                                                                                                                      If exceptions entered, remainder to be back filled by default.


      P46   Pupil Class Type Indicator ClassType                  1           1      2     ASC           Prime                                               20000811 Table values:
                                                                                                                                                                      N = Nursery Class (not a Special Class/Unit)
                                                                                                                                                                      O = Other Class (not a Special Class/Unit)
                                                                                                                                                                      S = Nursery Special Class/Unit
                                                                                                                                                                      X = Other Special Class/Unit
                                                                                                                                                                      Should be O or X if age at previous 31 August > = 6.
                                                                                                                                                                      Default = O

      P48   Pupil Registration Group   RegistrationGroup      30              1      4     Local         Prime                                               20001010 Any character string.

      P49   Pupil email address        Email                254               1      4     Local         Prime                                               20001010 Format: string1@string2.
                                                                                                                                                                      string1 and string2 may include any characters except @.
      P50   First Language             FirstLanguage              3           1      1     ASC/CTF       Prime                                               20040531 Table values (for PLASC 2005):
                                                                                                                                                                      ENG=English
                                                                                                                                                                      ENB=Believed to be English
                                                                                                                                                                      OTH=Other
                                                                                                                                                                      OTB=Believed to be Other
                                                                                                                                                                      REF=Refused
                                                                                                                                                                      NOT=Information not obtained
                                                                                                                                                                      Table values (for PLASC 2006, and thereafter) as for <Language>
                                                                                                                                                                      (see below)
                                       <Languages>
      P52   Language Type              LanguageQualifier          1           1      1     ASC/CTF       Prime                                               20030718 Table values:
                                                                                                                                                                      F = First Language *
                                                                                                                                                                      M = Multiple First Language *
                                                                                                                                                                      H = Home
                                                                                                                                                                      T = Tuition
                                                                                                                                                                      S = Second Language
                                                                                                                                                                      * see Additional Explanatory Notes (7)
      P53   Language Code              Language                   4           1      1     ASC/CTF       Prime                                               20030718 Table values = LANGUAGE.XLS
                                                                                                                                                                      New Version to be made available by the end of 2004.
                                                                                                                                                                      Old-to-New code mapping table to be made available.
                                       </Languages>
                                       <SEN>
                                       <SENhistory>




Version: Pupil CBDS V2.0                                                                                    Page 4 of 14                                                                                                      Printed: 12/1/2010
                                                                                 COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                           Prime/
                                                          Max        Data      Input                      Derived                 Date to be   Date to be
    Ref. No.         Data Item              XML TAG       Len.       Level     Type Crit.  Survey/Use       Data          Links     Intro.     removed      Data Ver.             Format/Table/Defaults/Data Item Validation
     P54 Pupil SEN Provision         SENprovision                1           1      1     ASC, CTF      Prime                                               20040531 Table values:
             (formerly Stage)                                                                                                                                         N = No Special Educational Need
                                                                                                                                                                      A = School Action
                                                                                                                                                                      P = School Action Plus
                                                                                                                                                                      Q = School action plus and statutory assessment (for historical
                                                                                                                                                                      records only - not an acceptable entry from January 2005)
                                                                                                                                                                      S = Statemented
                                                                                                                                                                      Default = N
      P55   Pupil date placed upon   StartDate               10              1      2     CTF           Prime                                               20001010 Format YYYY-MM-DD. Valid date before or equal to current date.
            stage                                                                                                                                                    Cannot be blank if <SENstatus> not 0 or N
      P56   Pupil date of next SEN   NextReviewDate          10              1      2     Local         Prime                                               20001010 Format YYYY-MM-DD. Valid date after <StartDate>. Cannot be blank
            Review                                                                                                                                                   if <StartDate> not blank.
                                     </SENhistory>
                                     <SENtypes>
      P57   Pupil SEN Type Ranking   SENtypeRank                 2           1      2     Local         Prime                     01092003                  20001010 Integer from 1; in order of significance of special educational need.
                                                                                                                                                                     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> not 0 or N.

      P58   Pupil SEN Type Code      SENtype                     4           1      2     Local         Prime                     01092003                  20030718 Nature of pupil‟s special educational need. Table values:
                                                                                                                                                                     SPLD = Specific Learning Difficulty
                                                                                                                                                                     MLD = Moderate Learning Difficulty
                                                                                                                                                                     SLD = Severe Learning Difficulty
                                                                                                                                                                     PMLD = Profound & Multiple Learning Difficulty
                                                                                                                                                                     BESD = Emotional & Behavioural Difficulty
                                                                                                                                                                     SLCN = Speech, Language or Communication Difficulty
                                                                                                                                                                     HI = Hearing Impairment
                                                                                                                                                                     VI = Visual Impairment
                                                                                                                                                                     MSI = Multi-Sensory Impairment
                                                                                                                                                                     PD = Physical Disability
                                                                                                                                                                     ASD = Autistic Spectrum Disorder
                                                                                                                                                                     OTH = Other Difficulty/Disability
                                                                                                                                                                     Must be at least one <SENtype> if <SENprovision> not N.


                                     </SENtypes>
                                     <NCmodifications>
                                     <Subject>
      P61   National Curriculum      Modification                1           1      2     Local         Prime                                               20000811 Table values:
            Modification or                                                                                                                                          M = National Curriculum Modified
            Disapplication                                                                                                                                           D = National Curriculum Disapplied.
      P62   National Curriculum      Subject                     3           1      2     QCA           Prime                                               20040531 Table values = GEN_SUBJ.XLS
            Subject
                                     </Subject>
                                     </NCmodifications>
                                     </SEN>
                                     <Medical>
     P64a   Pupil Medical Flag       MedicalFlag                 5           1      1     CTF           Derived                                             20040531 true or false (or 1, 0). Indicates that there is medical information

                                     </Medical>
                                     <Exclusions>
                                     <Exclusion>
      P66   Exclusion Type           Category                    4           1      1     ASC, EXC      Prime                                               20001010 Table values:
                                                                                                                                                                     FIXD = Fixed-Term
                                                                                                                                                                     PERM = Permanent
                                                                                                                                                                     LNCH = Lunchtime.




Version: Pupil CBDS V2.0                                                                                   Page 5 of 14                                                                                                         Printed: 12/1/2010
                                                                                  COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                            Prime/
                                                           Max        Data      Input                      Derived                 Date to be   Date to be
    Ref. No.     Data Item                     XML TAG     Len.       Level     Type Crit.  Survey/Use       Data          Links     Intro.     removed      Data Ver.             Format/Table/Defaults/Data Item Validation
     P67 Exclusion Reason             Reason                      2           1      1     EXC           Prime                                               20030718 Table Values:
                                                                                                                                                                       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
      P68   Exclusion Start Date      StartDate               10              1      1     EXC           Prime                                               20001010 Format YYYY-MM-DD. Valid date less than or equal to current date.
                                                                                                                                                                      Must be blank if <AppealResult> = “S”. See Additional Explanatory
                                                                                                                                                                      Notes (5). Must be same as leaving date for permanent exclusion but
                                                                                                                                                                      only after appeal.
      P69   Exclusion Start (am/pm)   Session                     2           1      4     Local         Prime                                               20001010 AM, PM.

      P70   Exclusion End Date        EndDate                 10              1      2     Local         Prime                                               20001010 Format YYYY-MM-DD. Must be blank if <AppealResult> = “S” and/or
                                                                                                                                                                      <Category> = “PERM”. Otherwise must be a valid date greater than
                                                                                                                                                                      <StartDate>.
     P70a   Exclusion Actual Number Sessions                      2           1      1     EXC           Prime                                               20030718 Actual Number of Sessions for which the exclusion is in effect. For
            of Sessions                                                                                                                                               lunchtime exclusions, each lunchtime for which the exclusion applies
                                                                                                                                                                      counts as one session. For fixed term and reinstated permanent
                                                                                                                                                                      exclusions, each full school day counts as two sessions; a half school
                                                                                                                                                                      day counts as one session. For exclusions which are followed by
                                                                                                                                                                      reinstatement the actual, not the planned number of sessions should
                                                                                                                                                                      be recorded.

                                                                                                                                                                        Note: A session as defined here is not the same as an attendance
                                                                                                                                                                        session. Exclusion sessions are used only to calculate the total
                                                                                                                                                                        allowable in a term or academic year.
      P71   Exclusion Appeal          Appeal                      1           2      1     Local         Prime                                               20001010 true/false or 1/0.
            Indicator
      P72   Exclusion Appeal Date     AppealDate              10              2      1     Local         Prime                                               20001010 Format YYYY-MM-DD. Must be blank if <Appeal> = “N”. Must not be
                                                                                                                                                                      blank if <Appeal> = “Y”.
      P73   Exclusion Appeal Result   AppealResult                1           2      1     Local         Prime                                               20001010 Must not be blank if <Appeal> = “Y”. Table values: R =
                                                                                                                                                                      Reinstatement; E = Exclusion stands, O = Reinstatement would be
                                                                                                                                                                      appropriate but not in best interests of child given other circumstances

     P73a   Exclusion Reinstatement   ReinstatementDate       10              2      1     Local         Prime                                               20030831 Format YYYY-MM-DD
            Date
                                      </Exclusion>
                                      </Exclusions>
                                      <Address>                                                                                                                         For mandatory definitions of address elements see:
                                                                                                                                                                        http://www.govtalk.gov.uk/gdsc/html/noframes/default.htm
      P74   Pupil Address Type        AddressType                 1           1      2     Local         Prime                                               20001010 Table values: C = Current; P = Previous; I = In care; A = Alternate; T =
                                                                                                                                                                      Transport; M = Mail.
      P75   Sub- dwelling             SAON                  100               1      2     Local         Prime                                               20001010 BS7666 Secondary Addressable Object Name. Flat, apartment name
                                                                                                                                                                      or number or other sub- division of a dwelling.
      P76   Dwelling                  PAON                  100               1      2     CTF           Prime                                               20001010 BS7666 Primary Addressable Object Name. Dwelling name and/or
                                                                                                                                                                      number.
      P77   Street                    Street                100               1      2     CTF           Prime                                               20040531 BS7666 Street Descriptor. May be missing for small communities with
                                                                                                                                                                      no recognised street name.
      P78   Locality                  Locality                35              1      2     CTF           Prime                                               20040531 BS7666 Locality Name. At least one of Locality, Town and
                                                                                                                                                                      AdministrativeArea must be present.
      P79   Town                      Town                    30              1      2     CTF           Prime                                               20040531 BS7666 Town Name. At least one of Locality, Town and
                                                                                                                                                                      AdministrativeArea must be present.
      P80   Administrative Area       AdministrativeArea      30              1      2     CTF           Prime                                               20040531 BS7666 Administrative Area. At least one of Locality, Town and
                                                                                                                                                                      AdministrativeArea must be present.




Version: Pupil CBDS V2.0                                                                                    Page 6 of 14                                                                                                       Printed: 12/1/2010
                                                                                COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                          Prime/
                                                           Max      Data      Input                      Derived                 Date to be   Date to be
    Ref. No.     Data Item                    XML TAG      Len.     Level     Type Crit.  Survey/Use       Data          Links     Intro.     removed      Data Ver.              Format/Table/Defaults/Data Item Validation
     P80a Post Town                    PostTown               30            1      2     CTF           Prime                                               20040531 Definition awaited from the Office of the e-Envoy
     P81 Postcode                      Postcode                 8           1      2     CTF, ASC      Prime                                               20040531 BS7666 Postcode. Validated against Local and/or National Land &
                                                                                                                                                                     Property Gazetteer. Valid Postcode formats are:
                                                                                                                                                                     An nAA
                                                                                                                                                                     Ann nAA
                                                                                                                                                                     AAn nAA
                                                                                                                                                                     AAnn nAA
                                                                                                                                                                     AnA nAA
                                                                                                                                                                     AAnA nAA
                                                                                                                                                                     where „A‟ is an alphabetical character and „n‟ is a numeric character.
                                                                                                                                                                     Double spaces should be converted to a single space.
                                                                                                                                                                     Convert any 'O' at start of second postcode block to '0' (zero).


      P82   Unique Property         UPRN                      12            2      4     Local         Prime                                               20001010 BS7666 compliance requirement. Format = nnnnnnnnn. Data can be
            Reference Number                                                                                                                                        missing in school systems but field must be present.
      P83   Unique Street Reference USRN                       8            2      4     Local         Prime                                               20001010 BS7666 compliance requirement. Format = nnnnnnnn. Data can be
            Number                                                                                                                                                  missing in school systems but field must be present.
      P84   Property Easting        Easting                    7            2      4     Local         Prime                                               20001010 BS7666 compliance requirement. Format = nnnnnnn. Data can be
                                                                                                                                                                    missing in school systems but field must be present.
      P85   Property Northing          Northing                7            2      4     Local         Prime                                               20001010 BS7666 compliance requirement. Format = nnnnnnn. Data can be
                                                                                                                                                                    missing in school systems but field must be present.
                                       <LocationContext>
      P86   Enumeration District       CensusDistrict          8            2      4     Local         Prime                                               20001010 National Population Census Enumeration District.
                                                                                                                                                                    Format = nnAAAAnn.
                                                                                                                                                                    ONS Lookup Table/Link to <Postcode> under investigation.
      P87   LEA Electoral Ward Code WardCode                   6            2      4     Local         Prime                                               20001010 ONS Ward Code
                                                                                                                                                                    Format = nnAAAA. (Characters 1-6 of <CensusDistrict>)
                                                                                                                                                                    ONS Lookup Table/Link to <Postcode> under investigation.
      P88   LEA Electoral Ward         Ward                   40            2      4     Local         Prime                                               20001010 ONS Lookup Table/Link to <WardCode> under investigation.
            Name
      P89   Parliamentary              ConstituencyCode        3            2      4     Local         Prime                                               20001010 ONS Parliamentary Constituency Code
            Constituency Code                                                                                                                                       001-529 England
                                                                                                                                                                    530-569 Wales
                                                                                                                                                                    601-672 Scotland
                                                                                                                                                                    701-718 Northern Ireland
                                                                                                                                                                    ONS Lookup Table/Link to <Postcode> under investigation.
      P90   Parliamentary              Constituency           40            2      4     Local         Prime                                               20001010 ONS Lookup Table/Link to <ConstituencyCode> under investigation.
            Constituency Name
      P91   Parish Council             Parish                 40            2      4     Local         Prime                                               20001010 ONS Lookup Table/Link to <Postcode> under investigation.
      P92   Church of England          CofEdiocese             3            2      4     Local         Prime                                               20001010 See table DIOCESES.XLS
            Diocese
      P93   Church of England Parish   CofEparish             50            2      4     Local         Prime                                               20001010 No validation.

      P94   Roman Catholic Diocese     RCdiocese               3            2      4     Local         Prime                                               20001010 See table DIOCESES.XLS

     P95    Roman Catholic Parish     RCparish                50            2      4     Local         Prime                                               20001010 No validation.
     P95a   Learning & Skills Council LSCcode                  3            2      3                                                                                Table values = LSCLIST.XLS
            Code
                                      </LocationContext>
                                       </Address>
                                       <Phone>
      P96   Pupil Telephone Type       PhoneType               1            1      4     Local         Prime                                               20001010 Table values:
                                                                                                                                                                    F = Fax.
                                                                                                                                                                    H = Home
                                                                                                                                                                    M = Mobile
                                                                                                                                                                    W = Work
      P97   Pupil Telephone Number PhoneNo                    20            1      4     Local         Prime                                               20040531 Up to 20 characters, using only the characters 0-9, (space), -, \

                                       </Phone>
                                       <Contacts>
                                       <Contact>




Version: Pupil CBDS V2.0                                                                                  Page 7 of 14                                                                                                        Printed: 12/1/2010
                                                                                  COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                            Prime/
                                                           Max        Data      Input                      Derived                 Date to be   Date to be
    Ref. No.    Data Item                     XML TAG      Len.       Level     Type Crit.  Survey/Use       Data          Links     Intro.     removed      Data Ver.            Format/Table/Defaults/Data Item Validation
     P98 Contact Priority             Order                    2              1      1     CTF           Prime                                               20001010 1 – 10.
     P99 Contact Title                Title                   30              1      1     CTF           Prime                                               20001010 Mr, Mrs, Ms, Miss, Rev, Fr, Dr, Prof, Hon, Sir, Lord, Lady. [If any of
                                                                                                                                                                       preceding must be as shown, otherwise free text]
     P100   Contact Last Name         Surname                 30              1      1     CTF           Prime                                               20001010 P3
     P101   Contact First Name        Forename                15              1      1     CTF           Prime                                               20001010 P4
     P102   Contact Middle Name       MiddleNames             20              1      4     CTF           Prime                                               20001010 P6
     P103   Contact Gender            Gender                   1              1      1     CTF           Prime                                               20001010 P8
     P104   Contact Relationship to   Relationship             3              1      1     CTF           Prime                                               20001010 Table values:
            Pupil                                                                                                                                                      CAR = Carer
                                                                                                                                                                       DOC = Doctor
                                                                                                                                                                       FAM = Other Family Member
                                                                                                                                                                       OTH = Other Contact
                                                                                                                                                                       PAM = Mother
                                                                                                                                                                       PAF = Father
                                                                                                                                                                       STP=Step Parent
                                                                                                                                                                       FAM=Other Family Member
                                                                                                                                                                       REL = Other Relative
                                                                                                                                                                       SWR = Social Worker
                                                                                                                                                                       RLG=Religious/Spiritual Contact
                                                                                                                                                                       There must be a Pupil Contact record for the Social Worker if
                                                                                                                                                                       <InCare> = true. See Additional Explanatory Notes (6).
    P104A Contact Responsibility to   Responsibility              5           1      1     CTF           Prime                                                          Does the contact have parental Responsibility? True, false or 1/0
          Pupil
    P105 Contact Member of            ArmedForces                 1           1      4     Local         Prime                                               20001010 true, false or 1/0
          Armed Forces Indicator                                                                                                                                      Must not be blank if <Relationship> = P?? (i.e. parent).
                                                                                                                                                                      Must be blank if <Relationship> not = P?? (i.e. non-parent).
                                                                                                                                                                      Transfer status to be determined.
     P106   Contact Translator or     Translator                  1           1      4     Local         Prime                                               20001010 Does the Parent/Carer require a translator or interpreter? Y,N. Must
            Interpreter Indicator                                                                                                                                     not be blank if <Relationship> = P?? or CAR.
     P107   Contact Language Code     Language                    3           1      4     Local         Prime                                               20001010 Table values = LANGUAGE.XLS.
                                                                                                                                                                      Must not be blank if <Translator> = Y
     P108   Contact email address     Email                 254               1      4     Local         Prime                                               20001010 Defined above.
                                      <Address>
     P109   Sub- dwelling             SAON                   60               1      2     Local         Prime                                               20001010 See Pupil Address section for definitions
     P110   Dwelling                  PAON                   60               1      2     CTF           Prime                                               20001010 See Pupil Address section for definitions
     P111   Street                    Street                100               1      2     CTF           Prime                                                        See Pupil Address section for definitions
     P112   Locality                  Locality              100               1      2     CTF           Prime                                               20001010 See Pupil Address section for definitions
     P113   Town                      Town                  100                                                                                              20001010 See Pupil Address section for definitions
     P114   Administrative Area       AdministrativeArea     35               1      2     CTF           Prime                                               20001010 See Pupil Address section for definitions

    P114a Post Town                   PostTown                30              1      2     CTF           Prime                                               20001010 See Pupil Address section for definitions
    P115 Postcode                     Postcode                 8              1      2     CTF, ASC      Prime                                               20001010 See Pupil Address section for definitions
    P116 Unique Property              UPRN                     9              2      4     Local         Prime                                               20001010 See Pupil Address section for definitions
          Reference Number
    P117 Unique Street Reference USRN                             8           2      4     Local         Prime                                               20001010 See Pupil Address section for definitions
          Number
    P118 Property Easting        Easting                          7           2      4     Local         Prime                                               20001010 See Pupil Address section for definitions
    P119 Property Northing       Northing                         7           2      4     Local         Prime                                               20001010 See Pupil Address section for definitions
                                 </Address>
                                 <Phones>
                                 <Phone>
    P120 Contact Telephone Type PhoneType                         2           1      2     CTF           Prime                                               20001010 Defined above. Cannot be blank if <Relationship> = SWR.

     P121   Contact Telephone         PhoneNo                 20              1      2     CTF           Prime                                               20040531 Defined above. Cannot be blank if <Relationship> = SWR.
            Number
                                      </Phone>
                                      </Phones>
                                      </Contact>
                                      </Contacts>
                                      <Attendance>




Version: Pupil CBDS V2.0                                                                                    Page 8 of 14                                                                                                         Printed: 12/1/2010
                                                                                      COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                                      Prime/
                                                               Max        Data        Input                           Derived                 Date to be    Date to be
    Ref. No.          Data Item                XML TAG         Len.       Level       Type    Crit.    Survey/Use      Data           Links     Intro.      removed      Data Ver.              Format/Table/Defaults/Data Item Validation
                                        <YearData>
     P122      Attendance Year          Year                          4           1       2           CTF           Prime                                                20001010 Format YYYY. Year at the start of the academic year.
     P123      Attendance School LEA    LEA                           3           1       2           CTF           Prime                                                20001010 Table values = LEALIST.XLS. Available at
               Number                                                                                                                                                             http://www.teachernet.gov.uk/docbank/index.cfm?id=953
     P124      Attendance School DfES   Estab                         4           1       2           CTF           Prime                                                20001010 Table values = ESTABLST.CSV plus XXXX = Unknown/Other*             *
               Establishment Number                                                                                                                                               Overseas school or school not in lookup table.

    P124a Attendance Period Start       AttendanceStartData       10              1       3           Local         Prime                                                20040531 Format YYYY-MM-DD
          Date
    P124b Attendance Period End         AttendanceEndDate         10              1       3           Local         Prime                                                20040531 Format YYYY-MM-DD
          Date
    P125 Possible Sessions              SessionsPossible              3           1       2           CTF           Prime                                                20001010 Possible sessions during academic year. 0 – 400 (half-days)
    P126 Sessions Attended              SessionsAttended              3           1       2           CTF           Prime                                                20001010 Sessions attended normally 0 – 400 (half-days) but may be higher
                                                                                                                                                                                  where required.
    P126a Sessions missed due to        SessionsAuthorised            3           1       2           CTF           Prime                                                20040531 Sessions missed due to authorised absence normally 0 - 400 (half-
               Authorised Absence                                                                                                                                                 days) but may be higher where required.
     P127      Sessions missed due to   SessionsUnauthorised          3           1       2           CTF           Prime                                                20001010 Sessions missed due to unauthorised absence normally 0 - 400 (half-
               Unauthorised Absence                                                                                                                                               days) but may be higher where required.

                                        </YearData>
                                        </Attendance>
                                        <SchoolHistory>
     P128 Previous School LEA           LEA                           3           1       2           CTF           Prime                                                20001010 Table values = LEALIST.XLS. Available at
          Number                                                                                                                                                                  http://www.teachernet.gov.uk/docbank/index.cfm?id=953
    P129 Previous School DfES           Estab                         4           1       2           CTF           Prime                                                20001010 Table values = ESTABLST.CSV plus XXXX = Unknown/Other*        *
          Establishment Number                                                                                                                                                    Overseas school or school not in lookup table.
    P131 Previous School Name           SchoolName              100               1       2           CTF           Prime                                                20001010 Must not be blank if <Estab> = XXXX
    P133 Previous School Date of        EntryDate                10               1       2           CTF           Prime                                                20001010 Format = CCYY-MM-DD. Valid date less than or equal to current
          Entry                                                                                                                                                                   date.
    P134 Previous School Date of        LeavingDate               10              1       2           CTF           Prime                                                20001010 Format = CCYY-MM-DD. Valid date less than or equal to current
          Leaving                                                                                                                                                                 date.
    P134a Pupil Reason for Leaving      LeavingReason                 2           1       2           CTF           Prime                                                20001010 Must not be blank if <LeavingDate> not blank.
                                                                                                                                                                                  Table values:
                                                                                                                                                                                  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)
                                                                                                                                                                                  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).

    P134b Last School                   LastSchool                    5           1       2           CTF           Prime                                                20030831 true/false or 1/0, Whether this school was the last one before current
                                                                                                                                                                                  school.
                                        </SchoolHistory>
                                        <Post16Courses>
     P135      Post Advanced Level      AdvancedCourse                1           1       2           ASC           Prime                                  2002?         20001010 true/false or 1/0.
               Indicator
     P136      Number of GCE A Level    Alevels                       1           1       2           ASC           Prime                                  2002?         20001010 Integer.
               Subjects being studied

     P137      Number of GCE AS Level ASlevels                        1           1       2           ASC           Prime                                  2002?         20001010 Integer.
               Subjects being studied




Version: Pupil CBDS V2.0                                                                                               Page 9 of 14                                                                                                       Printed: 12/1/2010
                                                                                COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                          Prime/
                                                         Max        Data      Input                      Derived              Date to be    Date to be
    Ref. No.        Data Item                  XML TAG   Len.       Level     Type Crit.  Survey/Use       Data       Links     Intro.       removed     Data Ver.              Format/Table/Defaults/Data Item Validation
     P138 Number of GCSE              GCSEs                     2           1      2     ASC           Prime                               2002?         20001010 Integer.
             Subjects being studied
     P139 GNVQ Level                  GNVQs                     1           1      2     ASC           Prime                               2002?         20001010 Table values:
                                                                                                                                                                  0 = Not taking a GNVQ
                                                                                                                                                                  1 = Foundation GNVQ
                                                                                                                                                                  2 = Intermediate GNVQ
                                                                                                                                                                  3 = Advanced GNVQ.
     P140    GNVQ Precursor Level     PreGNVQs                  1           1      2     ASC           Prime                               2002?         20001010 Table values:
                                                                                                                                                                  0 = not taking a GNVQ precursor
                                                                                                                                                                  2 = BTEC First, or City & Guilds Diploma of Vocational Education at
                                                                                                                                                                  intermediate level
                                                                                                                                                                  3 = BTEC National, or City & Guilds Diploma of Vocational Education
                                                                                                                                                                  at national level.
     P141    NVQ Level                NVQlevel                  1           1      2     ASC           Prime                               2002?         20001010 Table values:
                                                                                                                                                                  0 = not taking an NVQ
                                                                                                                                                                  1 = NVQ level 1
                                                                                                                                                                  2 = NVQ level 2
                                                                                                                                                                  3 = NVQ level 3.
     P142    Other Post-16 Courses    Other                     1           1      2     ASC           Prime                               2002?         20001010 Table Values:
             Indicator                                                                                                                                            A = Taking an Advanced Supplementary (old) course
                                                                                                                                                                  B = Taking the International Baccalaureate
                                                                                                                                                                  O = Taking another course (not AS or Bacc.)
                                                                                                                                                                  N = Not taking another course.
                                      </Post16Courses>
                                      <Assessments>
                                      <Assessment>
     P143    Assessment Identifier    Stage                     3           1      2     CTF           Prime                               2002?         20010504 Table Values = ASSESSID.XLS

     P144    Assessment Year          Year                      4           1      2     CTF           Prime                                             20010504 Format = YYYY (Calendar year of assessment).

    P144a Assessment Locale           Locale                    3           1      2     CTF           Prime                                             20030831 Table Values: ENG, WAL, UNK

     P145    Assessment Date          Date                      8           1      2     CTF           Prime                                             20010504 Format = YYYY-MM-DD.

     P146    Assessment/ Examination Season                     1           1      2     CTF           Prime                                             20010504 Table Values: S = Summer; W = Winter; M = Modular/Continuous
             Season                                                                                                                                               Assessment PLUS format for month: 1-9,a,b,c.

     P147    Assessment Result        ResultStatus              1           1      2     CTF           Prime                                             20010504 Table Values:
             Indicator                                                                                                                                            E = Estimate
                                                                                                                                                                  I = Interim
                                                                                                                                                                  P = Provisional Result (subject to regrading/appeal)
                                                                                                                                                                  R = Result
                                                                                                                                                                  T = Target.
     P148    Assessment Subject       Subject                   3           1      2     CTF           Prime                                              20040531 Table Values = A_SUBJ.XLS
                                                                                                                                                                   Must be absent or blank if <ExamSubject> not blank
    P148a Examination Subject         ExamSubject               6           1      2     CTF           Prime                                              20040531 Table Values = A_SUBJ.XLS
                                                                                                                                                                   Must be absent or blank if <Subject> not blank
     P149    Assessment Type          Method                    3           1      2     CTF           Prime                                             20010504 Table Values = A_TYPE.XLS

     P150    Assessment Component     Component                 3           1      2     CTF           Prime                                             20010504 Table values = A_COMP_yyyy .XLS where yyyy equates to the
                                                                                                                                                                  Assessment Year. Details for assessments prior to 2003 will be held in
                                                                                                                                                                  A_COMP_2003.XLS.
     P151    Component Result Type    ResultQualifier           2           1      2     CTF           Prime                                             20010504 Table Values = A_CRTYPE.XLS

     P152    Component Result         Result                    3           1      2     CTF           Prime                                             20010504 Acceptable values for specific Assessment Components may be
                                                                                                                                                                  found in A_COMP_yyyy .XLS where yyyy equates to the Assessment
                                                                                                                                                                  Year. Details for assessments prior to 2004 will be held in
                                                                                                                                                                  A_COMP_2003.XLS.
     P153    Awarding Body/           ExamBoard                 3           1      2     CTF           Prime                                             20010504 See table EXBOARDS.XLS
             Examination Board




Version: Pupil CBDS V2.0                                                                                  Page 10 of 14                                                                                                  Printed: 12/1/2010
                                                                           COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                        Prime/
                                                       Max        Data      Input                      Derived              Date to be   Date to be
    Ref. No.       Data Item            XML TAG        Len.       Level     Type Crit.  Survey/Use       Data       Links     Intro.     removed       Data Ver.          Format/Table/Defaults/Data Item Validation
     P154 Examination Syllabus   ExamBoardSyllabusID          6           1      2     CTF           Prime                                            20010504 See table KS4&5.XLS
             Number
                                 </Assessment>
                                 </Assessments>




Version: Pupil CBDS V2.0                                                                                Page 11 of 14                                                                                            Printed: 12/1/2010
                                                                                           COMMON BASIC DATA SET SPECIFICATION - PUPIL




                                                                                                                             Prime/
                                                                          Max      Data     Input                            Derived                     Date to be    Date to be
    Ref. No.           Data Item                    XML TAG               Len.     Level    Type     Crit.    Survey/Use      Data           Links         Intro.      removed       Data Ver.              Format/Table/Defaults/Data Item Validation

               Key to Data Categorisation

               Prime/Derived Data:
               Prime Data = Data which can not be disaggregated any further.
               Derived Data = Data which is derived from one or more sources.

               Links:
               Indicates the source of derived data. Data items have unique reference number. The initial character denotes the data set in which the item resides.

               Data Level:
               1 = Data expected to be collected and held by school
               2 = Data sourced by LEA and held by school

               Input Type/Crit.[ical Information]:
               0 = Data required for export only.
               1 = Core data item – any data that applies must be present and updated continuously.
               1*= (As „1‟ above). Data critical and essential for the initial creation of a pupil record.
               2 = Standard item – any data that applies must be present and up-to-date when required for a specific survey, but need not be updated continuously.
               3 = Additional item – schools may be required to provide data item from time to time, but for limited and specific purposes that general MI systems are not necessarily expected to support (e.g. Asset Management Plans).
               4 = Optional item – data may be missing and data item need not necessarily exist within database. For local use.

               Date Introduced:
               Date on which Information not currently collected is required to be collected at the school.

               Date to be Removed:
               Date on which Information currently collected is no longer needed to be collected at the school.

               Data Version:
               Date Introduced or substantially amended.

               Text Colour Coding:
               BLUE = Additions or Amendments.
               RED = Deletions (will be absent from subsequent versions).
               GREEN = Annotations/outstanding queries or points to be clarified.




Version: Pupil CBDS V2.0                                                                                                      Page 12 of 14                                                                                                        Printed: 12/1/2010
                                                             Pupil CBDS : Additional Explanatory Notes




Ref Note
1    Refugee / Asylum Seeker Status (XML Tag: Refugee)

     Source: United Nations High Commissioner for Refugees (UNHCR)
     (http://www.unhcr.ch/un&ref/who/whois.htm)

     Who is a Refugee?
     According to the 1951 Convention Relating to the Status of Refugees, a refugee is a person who "owing to a well-founded fear of being
     persecuted for reasons of race, religion, nationality, membership in a particular social group, or political opinion, is outside the country of his
     nationality, and is unable to or, owing to such fear, is unwilling to avail himself of the protection of that country."

     What is Asylum?
     Asylum is "protection granted by a State on its territory against the exercise of jurisdiction by the State of origin, based on the principle of non-
     refoulement and characterised by the enjoyment of internationally recognised refugee rights, and generally accorded without limit of time."

     What is Non-refoulement?
     Non-refoulement is the "principle of international law which requires that no State shall return a refugee in any manner to a country where his
     or her life or freedom may be endangered. The principle also encompasses non-rejection at the frontier."
2    Home Local Education Authority (HomeLEA)

     Source: DfEE Guidance on the Education of Young People in Public Care
     (http://www.dfee.gov.uk/incare/section11.htm)

     Equivalent to the “housing authority” as defined in Section 11.2 of the guidance.

     The authority “where the child ordinarily lives.”

3    (a) In Care Indicator (InCare)

     Source: DfEE Guidance on the Education of Young People in Public Care
     (http://www.dfes.gov.uk/incare/section03.shtml)

     “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.”

     (b) In Care Local Authority (CareAuthority)

     Source: DfEE Guidance on the Education of Young People in Public Care
     (http://www.dfes.gov.uk/incare/section11.shtml)

     Equivalent to the “originating authority” as defined in Section 11.2 of the guidance.

     The authority “where the child was originally placed in public care and which looks after the child for the purposes of the Children Act 1989.”


     (c) Personal Education Plan Indicator (PersonalEducationPlan)

     Source: DfEE Guidance on the Education of Young People in Public Care
     (http://www.dfes.gov.uk/incare/section05.shtml)

     “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 LEA….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.”

4    Child Protection Register (ProtectionRegister)

     Source: DfEE Special Educational Needs Glossary
     (http://www.dfes.gov.uk/sen/documents/GLOSSARY_of_SEN_Terms.htm)

     “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.”




Version: Pupil CBDS V2.0                                                      Notes: 13/14                                                                 Printed: 12/1/2010
                                                           Pupil CBDS : Additional Explanatory Notes




5    Pupil Exclusion Start Date (StartDate) and Pupil Leaving Date (LeavingDate)

     Source: DfEE Circular 10/99 Annex A
     (http://www.dfes.gov.uk/publications/guidanceonthelaw/10-99/register.htm)

     In the case of a permanent exclusion “the absence of a permanently excluded pupil is treated as authorised while any review or appeal is in
     progress. If a permanent exclusion is confirmed, the pupil`s name should be removed from the school roll on the school day either: after the
     appeal committee`s confirmation of permanent exclusion; or on expiry of the time allowed for appeals to be made; or, if before that, the pupil
     takes up a place elsewhere. Meanwhile absence should be recorded as authorised.”

     For a permanent exclusion the “Exclusion Start Date” and the “Leaving Date” will be the day the pupil‟s name has been removed from the
     school roll.
6    Contact Relationship (Relationship)

     Source: DfEE Special Educational Needs Glossar y
     (http://www.dfes.gov.uk/sen/documents/GLOSSARY_of_SEN_Terms.htm)

     A Carer is defined as “a person named by a local authority to care for a child for whom the social services department has parental
     responsibility, ie a child who is the subject of a care order and who has been placed in a residential or foster placement. The carer may
     qualify as a parent for the purposes of the Education Acts because he or she has care of the child (see the definition of Parent below). If so,
     he or she will have a role to play in the consideration of a child's special educational needs.”

     Source: DfEE Guidance on Schools, “Parents” and “Parental Responsibility”
     (Reference: DfEE 0092/2000)
     (http://www.dfee.gov.uk/circulars/dfeepub/jun00/050600/index.htm)

     The above guidance defines “parent” and “parental responsibility” as follows:-

     “…..
     DEFINITION OF “PARENT”

     4. Section 576 of the Education Act 1996 defines “parent” to include:
     - all natural parents, whether they are married or not; and
     - any person who, although not a natural parent, has parental responsibility for a child or young person; and
     - any person who, although not a natural parent, has care of a child or young person.

     PARENTAL RESPONSIBILITY

     5. Having parental responsibility means assuming all the rights, duties, powers, responsibilities and authority that a parent of a child has by
     law(i). People other than a child‟s natural parents can acquire parental responsibility through:

     - being granted a residence order;
     - being appointed a guardian;
     - being named in an emergency protection order (although parental responsibility in such a case is limited to taking reasonable steps to
     safeguard or promote the child's welfare); or
     - adopting a child.

     (i) Parental responsibility is defined in the Children Act 1989. If the parents of a child were not married to each other when the child was
     born, the mother automatically has parental responsibility but the father does not, even if he is named on the birth certificate. He can,
     however, subsequently acquire parental responsibility by various legal means.
     …..”

     For further details the following sources may be helpful:-

     Education Act 1996
     (http://www.hmso.gov.uk/acts/acts1996/96056-ct.htm#576)

     Children Act 1989 – Sections 2, 3 and 4)
     (http://www.legislation.hmso.gov.uk/acts/acts1989/Ukpga_19890041_en_1.htm)


7    First Language (FirstLanguage) and Language Code (Language)

     The language recorded as "First Language" should be the language to which the child was initially exposed during early development.

     If the child was exposed to more than one language then one of the languages should be recorded as "First Language" and the other
     language (or, in exceptional circumstances, other languages) should be recorded in the Language section with a Language Type of "M"
     (Multiple First Language). If, in these circumstances, one of the languages is English then this should be recorded as the "First Language"
     and the other language (or languages) recorded in the Language section.

     It is proposed that in the future the collection of language data will use the language section only, with the “First Language” data item no
     longer used.

     Currently, children for whom English is an additional language may be identified by the “First Language” not being English.




Version: Pupil CBDS V2.0                                                    Notes: 14/14                                                               Printed: 12/1/2010

				
DOCUMENT INFO
Description: 160 Uk Legal Parents Consent Letter document sample