Naming Conventions 2008/2009



INTRODUCTION

1. In the approach to governance around MI, naming conventions have been introduced to promote consistency throughout management information produced within the LSC.

RULES AND CONVENTIONS

2. Common rules in variable naming conventions include;

  • Variable names should be under thirty characters in length.
  • Underscores should be used rather than whitespace.

3. A full list of variable names and labels can be found by clicking the link below. They are listed in alphabetical order under the following headings:

  • Name: The variable name that appears in the standard files in both SPSS and SQL formats. For ILR variables, this is also the name that appears in the ILR manual.
  • SRP Name: This is the name that will be displayed when the Standard Files appear in SRP (Strategic Reporting Platform) and also in any cubes that are produced.
  • Variable Label: A descriptive field attached to the variable in SPSS.

Complete Index of Variable Names and Labels 2008/2009 - Excel Spreadsheet 281k Complete Index of Variable Names and Labels 2008/2009 (281k)

COMMON PREFIXES

4. Certain variables are categorised by a common prefix as detailed in the table below.

Field
Prefix
Meaning
Adm_Field originates from the Admin file
Freg_Register of Franchise and Other Partners
Frin_Franchised In File (FORM ILRFRANIN)
EESF ILR field
E_ESF DV
HHE ILR field
H_HE DV
LLearner Level ILR field
L_Learner Level DV
P_Programme Level DV
Prv_UPIN to LLSC file, sourced from PIMs
Pst_Field originates from the Postcode file
Rec_Reconcilliation File (FORM ILRRECEXP)
TrnField originates from the Transmission file
LAD_Field originates from the LAD file

Last date modified: 26th January 2009