| pidp | Cross-wave person identifier (numeric) |
| ks4_mmsch2 | Maintained mainstream school(excluding CTCs and Academies) |
| ks4_ebac2sci_e | Pupil entered for Ebacc science |
| ks4_ebachum_e | Pupil entered for Ebacc Humanities |
| ks4_ebaclan_e | Pupil entered for Ebacc Languages |
| ks4_ebacc_e | Entered all subject pillars of the Ebacc |
| ks4_ebacengag | Achieved EBacc English component at A*-G |
| ks4_pass2sciaag | Entered Biology, Physics, Chemistry GCSEs and achieved A*-G Biology plus Physics |
| ks4_pass2scibag | Entered Biology, Physics, Chemistry GCSEs and achieved A*-G Physics and Chemistr |
| ks4_passothsciag | Achieved double science or Core and Additional science at grades A*-G |
| ks4_ebac2sciag | Achieved EBacc 2 sciences component at grade A*-G |
| ks4_ebacmatag | Achieved EBacc maths component at grades A*-G |
| ks4_msch | Maintained school(including CTCs and Academies) |
| ks4_ebachumag | Achieved EBacc Humanities component at grades A*-G |
| ks4_ebaclanag | Achieved EBacc language component at grades A*-G |
| ks4_ebaccag | Achieved English Baccalaureate |
| ks4_b8scrplusbonus | Points score plus bonus- final score to be used in 'Best 8' VA |
| ks4_ebptseng | Point score in English EBacc pillar |
| ks4_ebptsmat | Point score in maths EBacc pillar |
| ks4_ebptssci | Point score in science EBacc pillar |
| ks4_ebptshum | Point score achieved in humanities Ebac pillar |
| ks4_ebptslan | Point score achieved in language Ebac pillar |
| ks4_apelit | Grade in Full GCSE English Literature |
| ks4_msch2 | Maintained school(excluding CTCs and Academies) |
| ks4_apelec | Grade in Full GCSE Design and Technology: Electronic Products |
| ks4_apfood | Grade in Full GCSE: Design and Technology: Food Technology |
| ks4_apgra | Grade in Full GCSE: Design and Technology: Graphic Products |
| ks4_apres | Grade in Full GCSE: Design and Technology: Resistant Materials Technology |
| ks4_apsys | Grade in Full GCSE: Design and Technology: Systems & Control |
| ks4_apdtt | Grade in Full GCSE: Design and Technology: Textiles Technology |
| ks4_apart | Grade in Full GCSE: Art and Design |
| ks4_aphis | Grade in Full GCSE: History |
| ks4_apgeo | Grade in Full GCSE: Geography |
| ks4_apfre | Grade in Full GCSE: French |
| ks4_earlyt_e | Whether GCSE and equivalents were taken early by a current 15 year old pupil |
| ks4_apger | Grade in Full GCSE: German |
| ks4_apbus | Grade achieved in Full GCSE (including Double Awards where appropriate) Business |
| ks4_aprs | Grade achieved in Full GCSE (including Double Awards where appropriate) Religiou |
| ks4_appe | Grade achieved in Full GCSE (including Double Awards where appropriate) Physical |
| ks4_apphy | Grade in Full GCSE: Physics |
| ks4_apche | Grade in Full GCSE: Chemistry |
| ks4_apbio | Grade in Full GCSE: Biological Science |
| ks4_apbioe | Grade in Full GCSE: Biology (except Human Biology) |
| ks4_apdra | Grade in Full GCSE: Drama |
| ks4_apit | Grade in Full GCSE: Information Technology |
| ks4_gcse_astar | No.of Full GCSE at grade A* |
| ks4_apitsc | Grade in Short GCSE: Information Technology |
| ks4_apspan | Grade in Full GCSE: Spanish |
| ks4_apmus | Grade in Full GCSE: Music |
| ks4_apmat | Grade in Full GCSE: Maths |
| ks4_apeng | Grade in Full GCSE: English |
| ks4_apssci | Grade in Full GCSE Single Award Science |
| ks4_apstat | Grade in Full GCSE (including Double Awards where appropriate) Statistics |
| ks4_apdsci | Grade in Full GCSE Double Award Science |
| ks4_apvsci | Grade in Vocational GCSE Double Award Applied Science |
| ks4_apsvsci | Grade in Vocational GCSE Single Award Additional Applied Science |
| ks4_gcse_a | No.of Full GCSE at grade A |
| ks4_apcoresci | Grade in GCSE Core Science |
| ks4_apadtsci | Grade in GCSE Additional Science |
| ks4_apapdsci | Grade in GCSE Applied Science |
| ks4_mob1 | Student joined in latest two academic years |
| ks4_mob2 | Student joined in any other month than July/Aug/Sep? |
| ks4_newmobile | Student joined the school in the last two academic years |
| ks4_senf | Pupil SEN stage |
| ks4_gcse_b | No.of Full GCSE at grade B |
| ks4_gcse_c | No.of Full GCSE at grade C |
| ks4_gcse_d | No.of Full GCSE at grade D |
| ks4_gcse_e | No.of Full GCSE at grade E |
| ks4_acadyr | Academic year |
| ks4_gcse_f | No.of Full GCSE at grade F |
| ks4_gcse_g | No.of Full GCSE at grade G |
| ks4_gcse_u | No.of Full GCSE at grade U |
| ks4_gcse_aa | No.of Full GCSE at grades A*-A |
| ks4_gcse_ac | No.of Full GCSE at grades A*-C |
| ks4_gcse_ag | No.of Full GCSE at grades A*-G |
| ks4_gcse_dg | No.of Full GCSE at grades D-G |
| ks4_gcse_short_astar | No.of Short GCSE at grade A* |
| ks4_gcse_short_a | No.of Short GCSE at grade A |
| ks4_gcse_short_b | No.of Short GCSE at grade B |
| ks4_la_9code | Local authority 9-digit code |
| ks4_gcse_short_c | No.of Short GCSE at grade C |
| ks4_gcse_short_d | No.of Short GCSE at grade D |
| ks4_gcse_short_e | No.of Short GCSE at grade E |
| ks4_gcse_short_f | No.of Short GCSE at grade F |
| ks4_gcse_short_g | No.of Short GCSE at grade G |
| ks4_gcse_short_aa | No.of Short GCSE at grades A*-A |
| ks4_gcse_short_ac | No.of Short GCSE at grades A*-C |
| ks4_gcse_short_ag | No.of Short GCSE at grades A*-G |
| ks4_gcse_short_dg | No.of Short GCSE at grades D-G |
| ks4_gvoc_astar | No.of Double Award Vocational GCSE at grade A*A* |
| ks4_laestab | The LA and ESTAB fields joined |
| ks4_gvoc_a | No.of Double Award Vocational GCSE at AA |
| ks4_gvoc_b | No.of Double Award Vocational GCSE at BB |
| ks4_gvoc_c | No.of Double Award Vocational GCSE at CC |
| ks4_gvoc_d | No.of Double Award Vocational GCSE at DD |
| ks4_gvoc_e | No.of Double Award Vocational GCSE at EE |
| ks4_gvoc_f | No.of Double Award Vocational GCSE at FF |
| ks4_gvoc_g | No.of Double Award Vocational GCSE at GG |
| ks4_gvoc_aa | No.of Double Award Vocational GCSE at A*A*-AA |
| ks4_gvoc_ac | No.of Double Award Vocational GCSE at A*A*-CC |
| ks4_gvoc_ag | No.of Double Award Vocational GCSE at A*A*-GG |
| ks4_urn | Unique establishment number or early learner provider number |
| ks4_gvoc_dg | No.of Double Award Vocational GCSE at DD-GG |
| ks4_gnvqintdis | No.of Distinction Intermediate GNVQs |
| ks4_gnvqintmer | No.of Merit Intermediate GNVQs |
| ks4_gnvqintpas | No.of Pass Intermediate GNVQs |
| ks4_gnvqfoudis | No.of Distinction Foundation GNVQs |
| ks4_gnvqfoumer | No.of Merit Foundation GNVQs |
| ks4_gnvqfoupas | No.of Pass Foundation GNVQs |
| ks4_pass_aastar | Total No.of GCSE/GNVQ at grades A*-A |
| ks4_pass_ac | Total No.of GCSE/GNVQ at grades A*-C |
| ks4_pass_ac_aat | Total No.of passes at grades A*-C (equivalencies included) |
| ks4_idaci | Income Deprivation Affecting Children Index |
| ks4_pass_lev2 | Total No.of Level 2 GCSE and equivalents |
| ks4_pass_lev2em | Total No.of Level 2 GCSE and equivalents, including English and Maths |
| ks4_pass_ag | Total No.of GCSE at grades A*-G |
| ks4_pass_lev1 | Total No.of Level 1 GCSE and equivalents |
| ks4_pass_lev1em | Total No.of level 1 GCSE and equivalent, including English and Maths |
| ks4_ptstnewe | Total GCSE and equivalents new style point score |
| ks4_ptscnewe | Capped GCSE and equivalents new style point score |
| ks4_ptstnewg | Total GCSE/GNVQ new style point score |
| ks4_points_old_g | Total GCSE/GNVQ old style point score |
| ks4_pass_aastar5 | Achieved 5 or more GCSE/GNVQs at grades A*-A |
| ks4_toe_code | Type of establishment code taken from Edubase |
| ks4_fiveac | Achieved 5 or more GCSE/GNVQs at grades A*-C |
| ks4_level2 | Achieved Level 2 threshold |
| ks4_glevel2 | Achieved 5 A*-C (GCSE only, including Applied) |
| ks4_glevel2em | Achieved 5 A*-C including English and maths (GCSE only, including Applied) |
| ks4_fiveag | Achieved 5 or more GCSE/GNVQs at grades A*-G |
| ks4_level1 | Achieved Level 1 threshold |
| ks4_anylev1 | Achieved at least 1 GCSE or equivalent at grade A*-G |
| ks4_anypass | Achieved any passes at all in GCSE or equivalents |
| ks4_gcsesci | The highest point score achieved in Science |
| ks4_ks4sci | Highest point score achieved (GCSE equivalencies) in Science |
| ks4_nftype | Institution type |
| ks4_level2_em | Achieved 5 or more GCSE and equivalents at grades A*-C(Level 2), including Engli |
| ks4_level2em_gcse | Achieved 5 or more GCSEs (excluding equivalents) at grades A*-C(Level 2), includ |
| ks4_level2_fem | Achieved 5 or more GCSE and equivalents at grades A*-C(Level 2), including GCSE |
| ks4_level1_em | Achieved 5 or more GCSE and equivalents at grades A*-G (Level 1), including GCSE |
| ks4_level1_fem | Achieved 5 or more GCSE and equivalents at grades A*-G (Level 1), including GCSE |
| ks4_level2mfl | Achieved A*-C in one full Modern Foreign Language GCSE or equivalent |
| ks4_level1mfl | Achieved A*-G in one short course Modern Foreign Language GCSE or equivalent |
| ks4_anypmfl | Achieved any passes in Modern Foreign Language |
| ks4_ebaceng | Achieved EBacc English component |
| ks4_ebacmat | Achieved EBacc Maths component |
| ks4_mmsch | Maintained mainstream school(including CTCs and Academies) |
| ks4_ebachum | Achieved EBacc Humanities component |
| ks4_ebaclan | Achieved EBacc language component |
| ks4_ebacc | Achieved English Baccalaureate |
| ks4_l2basics | Achieved Ebacc E&M |
| ks4_l2basics_1 | Achieved Ebacc E&M and EBacc 2 sciences |
| ks4_l2basics_2 | Achieved current E&M and current 2 sciences |
| ks4_l2basics_3 | Achieved current E&M and current 2 GCSE only sciences |
| ks4_l2basics_4 | Achieved current E&M and EBacc 2 sciences |
| ks4_ebaceng_e | Pupil entered for Ebacc English |
| ks4_ebacmat_e | Pupil entered for Ebacc Maths |