CCIS Developers Tom Wedge, CareerVision Ltd(mailto:tom.wedge@careervision.co.uk) Brenda Alexander, SCYPG CareerVision Ltd (mailto:hq@careerision.co.uk) 2007-02-01 2007-02-01 Schema for transfer of CCIS Management Information data to NCCIS for 2007 - 2008 text/xml http://www.w3.org/2001/XMLSchema XML schema, W3C Recommendation 2001 NCCIS2007 e-Government Unit, Stockley House,130 Wilton Road, London SW1V 1LQ Education, careers and employment NCCIS2007 Y - Yes N - No F = Female M = Male U = Unknown W = Withheld WBRI = WHITE BRITISH WIRI = WHITE IRISH WOTH = ANY OTHER WHITE BACKGROUND MWBC = WHITE AND BLACK CARIBBEAN MWBA = WHITE AND BLACK AFRICAN MWAS = WHITE AND ASIAN MOTH = ANY OTHER MIXED BACKGROUND AIND = INDIAN APKN = PAKISTANI ABAN = BANGLADESHI AOTH = ANY OTHER ASIAN BACKGROUND BCRB = CARIBBEAN BAFR = AFRICAN BOTH = ANY OTHER BLACK BACKGROUND CHNE = CHINESE OOTH = ANY OTHER ETHNIC GROUP REFU = REFUSED NOBT = INFORMATION NOT OBTAINED 1 = Intensive Support 2 = Supported 3 = Minimum Intervention SpLD - Specific Learning Difficulty MLD - Moderate Learning Difficulty SLD - Severe Learning Difficulty PMLD - Profound and Multiple Learning Difficulty BESD - Behaviour, Emotional and Social Difficulty SLCN - Speech, Language and Communication Needs ASD - Autistic Spectrum Disorder VI - Visual Impairment HI - Hearing Impairment MSI - Multi-Sensory Impairment PD - Physical Disability OTH - Other 1 One to one personal contact 2 Telephone 3 email/letter/text message/fax Form the National Qualification Framework N = No Qualifications 0 = Entry Level 1 = Level 1 2 = Level 2 3 = Level 3 4 = Level 4 5 = Level 5 6 = Level 6 7 = Level 7 8 = Level 8 000=Abroad 001=Wales 002=Scotland 003=Other UK Provence 004=Unknown Area 201=CITY OF LONDON 202=CAMDEN 203=GREENWICH 204=HACKNEY 205=HAMMERSMITH - FULHAM 206=ISLINGTON 207=KENSINGTON - CHELSEA 208=LAMBETH 209=LEWISHAM 210=SOUTHWARK 211=TOWER HAMLETS 212=WANDSWORTH 213=WESTMINSTER 301=BARKING - DAGENHAM 302=BARNET 303=BEXLEY 304=BRENT 305=BROMLEY 306=CROYDON 307=EALING 308=ENFIELD 309=HARINGEY 310=HARROW 311=HAVERING 312=HILLINGDON 313=HOUNSLOW 314=KINGSTON-UPON-THAMES 315=MERTON 316=NEWHAM 317=REDBRIDGE 318=RICHMOND-UPON-THAMES 319=SUTTON 320=WALTHAM FOREST 330=BIRMINGHAM 331=COVENTRY 332=DUDLEY 333=SANDWELL 334=SOLIHULL 335=WALSALL 336=WOLVERHAMPTON 340=KNOWSLEY 341=LIVERPOOL 342=ST HELENS 343=SEFTON 344=WIRRAL 350=BOLTON 351=BURY 352=MANCHESTER 353=OLDHAM 354=ROCHDALE 355=SALFORD 356=STOCKPORT 357=TAMESIDE 358=TRAFFORD 359=WIGAN 370=BARNSLEY 371=DONCASTER 372=ROTHERHAM 373=SHEFFIELD 380=BRADFORD 381=CALDERDALE 382=KIRKLEES 383=LEEDS 384=WAKEFIELD 390=GATESHEAD 391=NEWCASTLE UPON TYNE 392=NORTH TYNESIDE 393=SOUTH TYNESIDE 394=SUNDERLAND 420=ISLES OF SCILLY 800=BATH - NORTH EAST SOMERSET 801=BRISTOL 802=NORTH SOMERSET 803=SOUTH GLOUCESTERSHIRE 805=HARTLEPOOL 806=MIDDLESBROUGH 807=REDCAR - CLEVELAND 808=STOCKTON-ON-TEES 810=KINGSTON-UPON-HULL 811=EAST RIDING OF YORKSHIRE 812=NORTH EAST LINCOLNSHIRE 813=NORTH LINCOLNSHIRE 815=NORTH YORKSHIRE 816=YORK 820=BEDFORDSHIRE 821=LUTON 825=BUCKINGHAMSHIRE 826=MILTON KEYNES 830=DERBYSHIRE 831=DERBY 835=DORSET 836=POOLE 837=BOURNEMOUTH 840=DURHAM 841=DARLINGTON 845=EAST SUSSEX 846=BRIGHTON - HOVE 850=HAMPSHIRE 851=PORTSMOUTH 852=SOUTHAMPTON 855=LEICESTERSHIRE 856=LEICESTER 857=RUTLAND 860=STAFFORDSHIRE 861=STOKE 865=WILTSHIRE 866=SWINDON 867=BRACKNELL FOREST 868=WINDSOR - MAIDENHEAD 869=WEST BERKSHIRE 870=READING 871=SLOUGH 872=WOKINGHAM 873=CAMBRIDGESHIRE 874=PETERBOROUGH 875=CHESHIRE 876=HALTON 877=WARRINGTON 878=DEVON 879=PLYMOUTH 880=TORBAY 881=ESSEX 882=SOUTHEND 883=THURROCK 884=HEREFORDSHIRE 885=WORCESTERSHIRE 886=KENT 887=MEDWAY 888=LANCASHIRE 889=BLACKBURN WITH DARWEN 890=BLACKPOOL 891=NOTTINGHAMSHIRE 892=NOTTINGHAM 893=SHROPSHIRE 894=THE WREKIN 908=CORNWALL 909=CUMBRIA 916=GLOUCESTERSHIRE 919=HERTFORDSHIRE 921=ISLE OF WIGHT 925=LINCOLNSHIRE 926=NORFOLK 928=NORTHAMPTONSHIRE 929=NORTHUMBERLAND 931=OXFORDSHIRE 933=SOMERSET 935=SUFFOLK 936=SURREY 937=WARWICKSHIRE 938=WEST SUSSEX 110 - Looked after / In care 120 - Caring for own child 130 - Refugee / Asylum seeker 140 - Carer not own child 150 - Client disclosed substance misuse 160 - Care Leaver 170 - Supervised by YoT 180 - Pregnancy 190 - Teenage Parent For those of compulsory education age 110 - Registered at a school or other educational establishment in the area 120 - Educated at home 130 - In a Custodial Sentence 140 - Not registered at a school or other educational establishment in the Service area 150 - Current Situation not known In full time education, post Year 11. 210 - School Sixth Form 220 - Sixth Form College 230 - Further Education 240 - Higher Education 250 - Part time Education/Educated At Home Post 16 260 - Gap Year students 270 – Other post 16 education Employment 310 - Employment funded through GST (e.g. Apprenticeship) 320 - Employment with training to NVQ 2 or above 330 - Employment without training to NVQ 2 340 - Employment with locally recognised training 350 - Temporary employment 360 - Part Time Employment Government supported training/LSC Funded training 410 - LSC funded E2E training 420 - Other LSC funded training 430 - Other GST (eg New Deal) NEET Group 510 - personal development opportunities where in receipt of an allowance or wage 520 - other PDOs 610 - Those not yet ready for work or learning 611 - Those awaiting an E2E place 612 - Those requiring sub level 2 training provision - place not available 613 - Those requiring level 2 training provision - place not available 614 - Those requiring level 3+ training provision - place not available 616 - Start Date agreed (education/employment or training 618 - Participating in Activity Agreement Pilot (AA pilots only) 619 - Seeking employment, education or training only 620 - Not available to labour market Young carers 630 - Not available to labour market Teenage parents 640 - Not available to labour market Illness 650 - Not available to labour market Pregnancy 660 - Not available to labour market on religious grounds 670 - Not available to labour market those who are currently unlikely to be economically active 680 - Not available to labour market Other reason Other Young People not counted as EET or NEET 710 - Custody 720 - Refugees/Asylum seekers who have not yet been granted citizenship Current situation not known 810 - Current situation not known 820 - Cannot Be Contacted 830 - Refused to disclose activity 110 - Compulsory education 120 - School Sixth Form 130 - Sixth Form College 140 - Further Education 150 - Higher Education 160 - Part time education 170 - Gap Year 180 – Other post 16 education 210 - Employment funded through GST (eg Apprenticeships) 220 - Employment with training to NVQ 2 230 - Employment without training to NVQ2 240 - Temporary employment 250 - Part time employment 310 - Government supported training - Apprenticeship/other WBL 320 - Government supported training -E2E 330 - Government supported training -Other GST (eg New Deal) 410 - Personal development opportunities 510 - NEET in other area 610 - Other (inc custodial sentence) 110 - School Sixth Form 120 - Sixth Form College 130 - Further Education 140 - Higher Education 150 - Part time Education 160 - Gap Year 170 – Other post 16 education 210 - Employment 220 - Government Supported Training 310 - Personal Development Opportunities 410 - NEET in other area 510 - Custodial Sentence 610 - Unknown Activity 710 - Other Reason 01 = Managerial/Professonal 02 = Clerical/Secriterial 03 = Skilled Construction 04 = Skilled Engineering 05 = Electrical Engineering 06 = Metal Forming Trades 07 = Vehicle Trades 08 = Textile/Garment Trades 09 = Other Skilled Trades 10 = Protective Service Occupations 11 = Catering Occupations 12 = Health Care Occupations 13 = Childcare and Related Occupations 14 = Hairdressing and related Occupations 15 = Other Professional Service Occupations 16 = Sales Occupations 17 = Plant/Machine Occupations 18 = Agricultural/Forestry/Fishing Occupations 19 = Labouring/Unskilled Industrial 20 = Mail Workers 21 = Unskilled Service Sector 22 = Other Elementary Occupations 23 = Unknown Occupations 8 - School Year 8 9 - School Year 9 10 - School Year 10 11 - School Year 11 12 - School Year 12 13 - School Year 13 14 - School Year 14 15 - School Year 15 16 - School Year 16 17 - School Year 17 18 - School Year 18 19 - School Year 19 20 - School Year 20 Required Values 110 - Substance Misuse Agencies - Tier 1 111 - Substance Misuse Agencies - Tier 2 112 - Substance Misuse Agencies - Tier 3 113 - Substance Misuse Agencies - Tier 4 P=Primary S=Secondary X=Included in return, not in cohort. 110 - Staying in same school 120 - Other school 130 - College 140 - Higher Education 210 - Gap Year 220 - Training 310 - Labour Market - definite place 320 - Labour Market no definite place 410 - Undecided 510 - Other 610 - Not yet obtained 1 = Pre Year 9 2 = Year 9 3 = Year 10 4 = Year 11 5 = Education 6 = WBL or Other GST 7 = Employment 8 = NEET 110 - Section 140 Assessment Completed. 120 - Activity Agreement Review 210 - Action Plan Completed 220 - Referral to Agency. 2006 = 2006 Leaver 2007 = 2007 Leaver 2008 = 2008 Leaver 2009 = 2009 Leaver 2010 = 2010 Leaver 110 = In Learning 120 = Offer Accepted (yet to start) 130 = Offer Refused 140 = No Offer made –unable to contact 150 = No Offer made – other reason One character alpha string Seven digit numeric string