Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Birmingham

VIEWS: 4 PAGES: 59

  • pg 1
									                                                                                                                                                         Telephone: 08702 670001
                                                                                                                                               Email : servicedesk@thedataservice.org.uk
                                                                                                                                                    Website : www.thedataservice.org.uk
Part 1 - Report Information

Report : Skills for Life ESOL provision report

Customer : LSC - Skills for Life policy team NO

Date : 8th June 2009

Saved Location : G:\Organisational Data\DCA\A&MI\MIReports\ESOL\

Service Desk Reference Number :



Part 2 - Quality Statement

Data Sources :                                                                                                                                                                               1     PUBLIC – information that has been declared public knowledge by someone with the authority to do so, or is already within the public domain and can freely be given to anyone without any possible damage to the LSC or its partners. Please note: you do not n
                                                                                                                                                                                                 Public
                                                                                                                                                                                             2     UNCLASSIFIED – information relates to the majority of information produced or used by the LSC for the purpose of executing its internal business processes. Unclassified information shall normally be open access to all LSC employees, however the ability t
                                                                                                                                                                                                 Unclassified
Filename                           Freeze Date            Next Freeze Date                Coverage %                                                                                         3     PROTECT – sensitive information that should only be accessible to those with explicit permission to access it. Information shall only be classified as PROTECT where there are specific and legitimate business reasons for doing so. Note : information cla
                                                                                                                                                                                                 Protect
ILR0607_F05_AIMS                   Final                  n/a                                 100%
dbo.ILR0708_F05_AIMS               Final                  n/a                                 100%
dbo.ILR0708_C03_AIMS               Final                  n/a                                 100%
dbo.ILR0607_C03_AIMS               Final                  n/a                                 100%
dbo.ILR0607_U05_AIMS               Final                  n/a                                 100%
dbo.ILR0708_U05_AIMS               Final                  n/a                                 100%
dbo.ILR0607_S_AIMS                 Final                  n/a                                 100%
dbo.ILR0708_S_AIMS                 Final                  n/a                                 100%
dbo.ILR0607_W_AIMS                 Final                  n/a                                 100%
dbo.ILR0708_W_AIMS                 Final                  n/a                                 100%
dbo.ILR0607_T_AIMS                 Final                  n/a                                 100%
dbo.ILR0708_T_AIMS                 Final                  n/a                                 100%
LAD_0607                           n/a                    n/a                             n/a
LAD_0708                           n/a                    n/a                             n/a




Known Errors :

None


Quality Assurance :

Peer review. In addition to the standard checks when finalising management information.


Security Classification :          Unclassified                                       2

UNCLASSIFIED – information relates to the majority of information produced or used by the LSC for the purpose of executing its internal business processes. Unclassified information shall
normally be open access to all LSC employees, however the ability t




Personal and Sensitive Data - Additional Comments :

Not to be shared externally as when the data is drilled down to a low level there is the potential to see values below 5.


Detailed Information :

None


Notes :

Before using the Pivot it will need to be refreshed. This can be done via the pivot tablecommand bar or by "right clicking" the pivot table.
Learner_Region       (All)




Learner_LEA          Birmingham

Sum of Enrolments    Aim_Type
Academic_Year        ESOL units    non-approved ESOL Pre-entry Skills For Life ESOL
2006/07                                          2780     381                    7704
2007/08                       4552               1834     645                    6160




Learner_Region       (All)




Learner_LEA          Birmingham

Sum of Achievements Aim_Type
Academic_Year       ESOL units    non-approved ESOL Pre-entry Skills For Life ESOL
2006/07                                         2059     268                    4208
2007/08                      3362               1339     567                    4435
Learner_Region      (All)




Learner_LEA         Birmingham

Sum of Enrolments
Academic_Year       Funding_Stream             Ethnicity
2006/07             Adult Safeguarded Learning Asian or Asian British - Any other Asian background
                                               Asian or Asian British - Bangladeshi
                                               Asian or Asian British - Indian
                                               Asian or Asian British - Pakistani
                                               Black or Black British - African
                                               Black or Black British - Caribbean
                                               Mixed - White and Asian
                                               White - British
                    European Social Fund       Any other
                                               Asian or Asian British - Bangladeshi
                                               Asian or Asian British - Indian
                                               Asian or Asian British - Pakistani
                                               Black or Black British - African
                    Further Education          Any other
                                               Asian or Asian British - Any other Asian background
                                               Asian or Asian British - Bangladeshi
                                               Asian or Asian British - Indian
                                               Asian or Asian British - Pakistani
                                               Black or Black British - African
                                               Black or Black British - Any other black background
                                               Black or Black British - Caribbean
                                               Chinese
                                               Mixed - Any other mixed background
                                               Mixed - White and Asian
                                               Mixed - White and Black African
                                               Mixed - White and Black Caribbean
                                               Not known/not provided
                                               White - Any other white background
                                               White - British
                                               White - Irish
                    University For Industry    Any other
                                               Asian or Asian British - Any other Asian background
                                               Asian or Asian British - Bangladeshi
                                               Asian or Asian British - Indian
                                               Asian or Asian British - Pakistani
                                               Black or Black British - African
                                               Black or Black British - Any other black background
                                               Mixed - Any other mixed background
                                               Mixed - White and Asian
                                               Mixed - White and Black African
                                     Not known/not provided
                                     White - Any other white background
          Workbased Learning         Any other
                                     Asian or Asian British - Any other Asian background
                                     Asian or Asian British - Bangladeshi
                                     Asian or Asian British - Indian
                                     Asian or Asian British - Pakistani
                                     Black or Black British - African
                                     Black or Black British - Any other black background
                                     Chinese
                                     Mixed - White and Black African
                                     Not known/not provided
                                     White - Any other white background
                                     White - British
2007/08   Adult Safeguarded Learning Asian or Asian British - Any other Asian background
                                     Asian or Asian British - Bangladeshi
                                     Asian or Asian British - Indian
                                     Asian or Asian British - Pakistani
                                     Not known/not provided
                                     White - British
          European Social Fund       Any other
                                     Asian or Asian British - Any other Asian background
                                     Asian or Asian British - Indian
                                     Asian or Asian British - Pakistani
                                     Black or Black British - African
                                     Black or Black British - Any other black background
                                     Black or Black British - Caribbean
                                     Mixed - White and Black African
                                     Not known/not provided
          Further Education          Any other
                                     Asian or Asian British - Any other Asian background
                                     Asian or Asian British - Bangladeshi
                                     Asian or Asian British - Indian
                                     Asian or Asian British - Pakistani
                                     Black or Black British - African
                                     Black or Black British - Any other black background
                                     Black or Black British - Caribbean
                                     Chinese
                                     Mixed - Any other mixed background
                                     Mixed - White and Asian
                                     Mixed - White and Black African
                                     Mixed - White and Black Caribbean
                                     Not known/not provided
                                     White - Any other white background
                                     White - British
          Workbased Learning         Any other
                                     Asian or Asian British - Any other Asian background
                                     Asian or Asian British - Bangladeshi
                                     Asian or Asian British - Indian
                                     Asian or Asian British - Pakistani
                                     Black or Black British - African
                                     Black or Black British - Any other black background
Chinese
Mixed - White and Asian
Mixed - White and Black African
Not known/not provided
White - Any other white background
Aim_Type
ESOL units   non-approved ESOL Pre-entry Skills For Life ESOL
                              5
             *
             *
                             13 *
             *
                              5
             *
             *
                                                                6
                                                                5
             *                              *
                             15                                 6
                                            *
                            308        42                 770
                            145        56                 747
                            252        23                 512
                            235        28                 381
                            973       123                1705
                            312        85                1649
                             21   *                        97
                              8   *                        14
                             47   *                       106
                              6                            27
                              7                            51
                             10   *                        74
             *                              *
                             53         9                 124
                            250         6                1245
                             18                            43
             *                              *
                             11
                             10
             *
             *
                             12
                             18
             *
             *
             *
             *
              6
             15
                               20
                               11
                               15
                          *
                               40
                               25
                          *
                          *
                          *
                          *
                                9
                          *
         *
         *
         *
             34           *
         *
         *                *
                                8
                          *
                                6
                          *
                          *
                          *
                          *
                          *
                          *
     215     220     46        496
     568     119     86        678
     285     167     31        476
     187     117     34        287
     972     644    218       1290
    1333     209    147       1379
      49      23     12         88
       5*                        6
     102     27      8         110
      18      5*                17
      35     14 *               42
      50      9                 47
*        *                *
     132      67    33        107
     569     158    25        846
      31       7*              28
                               24
                               29
                               16
                               12
                               59
                               56
                                7
*
*
*
     5
    13
Learner_Region      (All)




Learner_LEA         Birmingham

Sum of Enrolments                                                                      Aim_Type
Academic_Year       Gender       Ethnicity                                             ESOL units
2006/07             Female       Any other
                                 Asian or Asian British - Any other Asian background
                                 Asian or Asian British - Bangladeshi
                                 Asian or Asian British - Indian
                                 Asian or Asian British - Pakistani
                                 Black or Black British - African
                                 Black or Black British - Any other black background
                                 Black or Black British - Caribbean
                                 Chinese
                                 Mixed - Any other mixed background
                                 Mixed - White and Asian
                                 Mixed - White and Black African
                                 Mixed - White and Black Caribbean
                                 Not known/not provided
                                 White - Any other white background
                                 White - British
                                 White - Irish
                    Male         Any other
                                 Asian or Asian British - Any other Asian background
                                 Asian or Asian British - Bangladeshi
                                 Asian or Asian British - Indian
                                 Asian or Asian British - Pakistani
                                 Black or Black British - African
                                 Black or Black British - Any other black background
                                 Black or Black British - Caribbean
                                 Chinese
                                 Mixed - Any other mixed background
                                 Mixed - White and Asian
                                 Mixed - White and Black African
                                 Mixed - White and Black Caribbean
                                 Not known/not provided
                                 White - Any other white background
                                 White - British
                                 White - Irish
2007/08             Female       Any other                                                     107
                                 Asian or Asian British - Any other Asian background           243
                                 Asian or Asian British - Bangladeshi                          193
                                 Asian or Asian British - Indian                               162
                                 Asian or Asian British - Pakistani                            771
                                 Black or Black British - African                              856
       Black or Black British - Any other black background       28
       Black or Black British - Caribbean                    *
       Chinese                                                   82
       Mixed - Any other mixed background                         9
       Mixed - White and Asian                                    6
       Mixed - White and Black African                           35
       Mixed - White and Black Caribbean
       Not known/not provided                                     70
       White - Any other white background                        320
       White - British                                            19
Male   Any other                                                 108
       Asian or Asian British - Any other Asian background       325
       Asian or Asian British - Bangladeshi                       92
       Asian or Asian British - Indian                            25
       Asian or Asian British - Pakistani                        201
       Black or Black British - African                          477
       Black or Black British - Any other black background        21
       Black or Black British - Caribbean                    *
       Chinese                                                   20
       Mixed - Any other mixed background                         9
       Mixed - White and Asian                                   29
       Mixed - White and Black African                           15
       Mixed - White and Black Caribbean                     *
       Not known/not provided                                     62
       White - Any other white background                        249
       White - British                                            12
non-approved ESOL    Pre-entry Skills For Life ESOL
               188          21                    363
                73          28                    291
               194          17                    325
               214          23                    312
               832          89                   1410
               226          46                    960
                15                                 57
                 8   *                             11
                36   *                             76
                 5                                 19
                 5                                 20
                11   *                             48
*                              *
                27   *                             54
               122   *                            675
                10                                 24
                               *
              131           21                    433
               87           28                    467
               63            6                    207
               27            5                     77
              181           38                    341
              106           39                    716
                7    *                             42
                5    *         *
               11                                  31
*                                                   8
                5                                  31
*                                                  27
                               *
               32            6                     71
              143            5                    579
                9                                  20
*
              135          26                    279
               52          48                    319
              119          15                    316
              102          29                    229
              559         148                   1046
              127          93                    935
    16     10       56
*               *
    23     5        63
*                    6
     6*             14
     9              28
*               *
     33    17        59
     94    10       528
      5*             13
     85    20       249
     68    38       389
     50    16       176
     16     5        76
    119    70       308
     82    54       504
      7*             40
*               *
*     *             51
*     *             11
     8*             29
                    24
                *
    36     16        54
    64     15       331
*                    17
Learner_Region      (All)




Learner_LEA         Birmingham

Sum of Enrolments                           Aim_Type
Academic_Year       Gender   Aim_Level      ESOL units non-approved ESOL Pre-entry
2006/07             Female   Entry Level                             1814     231
                             Level 1                                   90
                             Level 2                                   24
                             Mixed Level                               16
                             Not Applicable                            23
                    Male     Entry Level                              707     150
                             Level 1                                   46
                             Level 2                                   11
                             Not Applicable                            49
2007/08             Female   Entry Level           2650              1288     403
                             Level 1                186
                             Level 2                  66
                    Male     Entry Level           1501               546     242
                             Level 1                115
                             Level 2                  34
Skills For Life ESOL
                  4102
                   406
                   142


                2624
                 330
                 100

                3413
                 340
                 143
                1913
                 251
                 100
Learner_Region      (All)




Learner_LEA         Birmingham

Sum of Enrolments
Academic_Year       Aim_Level
2006/07             Entry Level




                    Level 1



                    Level 2



                    Mixed Level
                    Not Applicable

2007/08             Entry Level
Level 1


Level 2
A09_TITL
Basic ESOL Course, Entry Level
Basic ESOL Course, Pre-entry Level
Certificate in ESOL Skills for Life (Entry 1)
Certificate in ESOL Skills for Life (Entry 2)
Certificate in ESOL Skills for Life (Entry 3)
Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 1)
Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 2)
Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 3)
Entry Level Certificate in ESOL Skills for Life (Entry 1)
Entry Level Certificate in ESOL Skills for Life (Entry 2)
Entry Level Certificate in ESOL Skills for Life (Entry 3)
Entry Level Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 1)
Entry Level Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 2)
Entry Level Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 3)
Going Up
Welcome to English
Basic ESOL Course, Level 1
Certificate in English (ESOL)
Certificate in ESOL Skills for Life
Certificate in ESOL Skills for Life (Speaking and Listening)
Basic ESOL Course, Level 2
Certificate in English Language Skills (IELTS Bands 6/7) (ESOL)
Certificate in ESOL Skills for Life
Certificate in ESOL Skills for Life (Speaking and Listening)
Adult Basic Education Modules (ESOL)
ELLIS - Introduction
ELLIS - Middle Mastery
Basic ESOL Course, Entry Level
Basic ESOL Course, Pre-entry Level
Certificate in ESOL Skills for Life (Entry 1)
Certificate in ESOL Skills for Life (Entry 2)
Certificate in ESOL Skills for Life (Entry 3)
Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 1)
Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 2)
Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 3)
Entry Level Certificate in ESOL Skills for Life (Entry 1)
Entry Level Certificate in ESOL Skills for Life (Entry 2)
Entry Level Certificate in ESOL Skills for Life (Entry 3)
Entry Level Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 1)
Entry Level Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 2)
Entry Level Certificate in ESOL Skills for Life (Speaking and Listening) (Entry 3)
Open College Network Basic ESOL Course, Entry Level
Unitisation (approved external qualification) Entry Level, Preparation for Life and Work (SSA 14), PW F - ESOL
Certificate in ESOL Skills for Life
Certificate in ESOL Skills for Life (Speaking and Listening)
Unitisation (approved external qualification) Level 1, Preparation for Life and Work (SSA 14), PW F - ESOL
Certificate in ESOL Skills for Life
Certificate in ESOL Skills for Life (Speaking and Listening)
Unitisation (approved external qualification) Level 2, Preparation for Life and Work (SSA 14), PW F - ESOL
Aim_Type
ESOL units   non-approved ESOL Pre-entry Skills For Life ESOL
                           2508
                                    381
                                                            856
                                                            826
                                                            511
                                                           1700
                                                            987
                                                            697
                                                             61
                                                            263
                                                             48
                                                            310
                                                            236
                                                            231
                             12
             *
                            134
             *
                                                            253
                                                            483
                             28
                              7
                                                             73
                                                            169
                             16
                             51
                             21
                           1833
                                    645
                                                            494
                                                            510
                                                            357
                                                           1200
                                                            742
                                                            561
                                                            512
                                                            338
                                                            344
                                                             78
                                                            109
           81
       *
4151
           270
           321
301
           116
           127
100
Learner_Region   (All)




Learner_LEA      Birmingham

Sum of Enrolments                                                     Aim_Type
Academic_Year     Gender   DOMICILE_DESC                              ESOL units    non-approved ESOL
2006/07           Female   Afghanistan
                           Congo                                                    *
                           England                                                               1915
                           Iran                                                     *
                           Lithuania
                           Netherlands
                           Not known                                                *
                           Poland                                                                   6
                           Romania
                           Sarawak
                           Sikkim
                           Slovakia                                                 *
                           Socialist People's Libyan Arab Jamahiriy
                           (blank)                                                                 42
                 Male      England                                                                801
                           Hungary
                           Iraq
                           Latvia
                           Norway
                           Poland                                                   *
                           Republic, Czech                                          *
                           Slovakia                                                 *
                           Vatican City
                           (blank)                                                                  6
2007/08          Female    Afghanistan                                              *
                           England                                           2891                1233
                           Hungary
                           Iran                                       *
                           Latvia                                     *
                           Lithuania                                                *
                           Pakistan                                   *                             6
                           Poland                                                  6*
                           Sikkim                                                   *
                           State of Eritrea
                           Sweden                                     *
                           (blank)                                                                 41
                 Male      Afghanistan                                *             *
                           England                                           1643                 543
                           Netherlands                                              *
                           Pakistan                                   *
Poland    *
(blank)   *   *
Pre-entry Skills For Life ESOL
          *
          *
     227                    4598
          *
          *
          *
          *
                              16
          *
          *
          *

           *
*                            22
     150                   3034
           *
           *
           *
           *
                             10
           *

           *
           *

     403                   3874
           *




           *

           *

                             18

     242                   2247
*
    13
Learner_Region   (All)




Learner_LEA      Birmingham

Sum of Enrolments                     Aim_Type
Academic_Year     Gender   Age_Band   ESOL units    non-approved ESOL    Pre-entry
2006/07           Female   16 - 18                                  42           7
                           19 - 24                                 292          34
                           25 - 34                                 716          89
                           35 - 44                                 546          49
                           45 - 54                                 215          40
                           55 - 64                                 103           9
                           65+                                      53   *
                 Male      16 - 18                                  52          11
                           19 - 24                                 126          28
                           25 - 34                                 309          56
                           35 - 44                                 185          33
                           45 - 54                                  98          16
                           55 - 64                                  28   *
                           65+                                      15   *
2007/08          Female    16 - 18            146                   35          20
                           19 - 24            464                  189          41
                           25 - 34           1123                  504        125
                           35 - 44            799                  355        110
                           45 - 54            273                  125          60
                           55 - 64             78                   56          23
                           65+                 19                   24          24
                 Male      16 - 18            172                   64          29
                           19 - 24            261                   73          39
                           25 - 34            681                  212          81
                           35 - 44            354                  128          61
                           45 - 54            140                   47          22
                           55 - 64             28                   16           8
                           65+                 14                    6   *
Skills For Life ESOL
                   213
                   893
                  1851
                  1136
                   425
                   109
                    23
                   275
                   499
                  1257
                   695
                   269
                    43
                    16
                   198
                   676
                  1535
                  1015
                   347
                   110
                    15
                   278
                   321
                   867
                   530
                   210
                    42
                    16
The SQL is similar for each stream.

USE LSC_MI_db_pub

DELETE FROM Corporate_Cube_CM_Dev.dbo.ESOL_DATA_Jun09

WHERE Funding_Stream = 'Adult Safeguarded Learning'


INSERT INTO Corporate_Cube_CM_Dev.dbo.ESOL_DATA_Jun09

(
     Funding_Stream
    ,Collection
    ,Academic_Year
    ,Aim_Type
    ,L01
    ,Provider_Name
    ,Provider_LEA
    ,Provider_Region
    ,Age_Band
    ,Ethnicity
    ,DOMICILE_DESC
    ,Gender
    ,L_Difficulties
    ,Disability
    ,L_Difficulty
    ,Learner_Support_Reason_A
    ,Learner_Support_Reason_B
    ,Learner_Support_Reason_C
    ,Learner_Support_Reason_D
    ,PRIOR_ATTAINMENT_LEVEL_DESC
    ,A09_TITL
    ,Aim_Level
    ,Reason_For_Fee_Remission
    ,Enrolments
    ,Completions
    ,Achievements

)

SELECT

-- Dimensions ---------------------------------------------------------------------------------------------------

    Funding_Stream = 'Adult Safeguarded Learning'

    ,Collection = 'C03'

    ,Academic_Year = '2006/07'

    ,Aim_Type = CASE
             WHEN LAD.A_SFLTYP IN('03', '04', '07', '10', '17')
               THEN
                 CASE
                   WHEN Aims.A09 IN('10037433', '10037445', '10037408', '1003741X', '10037421', '10049022', '10049034', '100
                           '10049010', '10045843', '10045855', '10045818', '1004582X', '10045831', '10064187', '10064199', '10
                           '10050620', '10050632', '10057420', '10057432', '10057390', '10057407', '10057419', '10057183', '10
                           '10036179', '10036180', '10036192', '10059878', '1005988X', '10059891', '10057201', '10057213', '10
                           '10048819', '10048820', '10057225', '10057237', '10048832', '10048844', '10048856', '10042696', '10
                           '10042660', '10042672', '10042684', '10045168', '1004517X', '10045132', '10045144', '10045156', '10
                           '10049393', '10039429', '10039302', '10039326', '10051326', '10051338', '10051296', '10051302', '10
                           '280368', '280414', '280415', '280416', '280369')
                    THEN 'Skills For Life ESOL'
                  WHEN Aims.A09 IN('50021813', '50021825', '50022982', '50022647', '50021382', '50021850', '50022519', '500
                           '5002114X', '50021795', '50021801', '50021151', '50021163', '50021771', '50021783', '10059878', '10
                           '10059891')
                    THEN 'ESOL For Work'
                  WHEN Aims.A09 IN ('CBSP0001','CBSP0002','CBSP0003')
                    THEN 'Pre-entry Unit'
                  WHEN Aims.A09 like 'ZUNA%' or Aims.A09 like 'ZUNE%' or Aims.A09 like 'CUNA%' or Aims.A09 like 'CUNE%
                    THEN 'Other Unit'
                ELSE 'ESOL Unknown'
                END
       END

,Aims.L01

,Provider_Name = UPN.P_PROVIDER_NAME

,Provider_LEA = PC.LEA_NAME

,Provider_Region = Aims.L_PREG

--,Aims.L_AGE

,Age_Band = CASE
        WHEN Aims.L_AGE BETWEEN 1 AND 18 THEN '16 - 18'
        WHEN Aims.L_AGE BETWEEN 19 AND 24 THEN '19 - 24'
        WHEN Aims.L_AGE BETWEEN 25 AND 34 THEN '25 - 34'
        WHEN Aims.L_AGE BETWEEN 35 AND 44 THEN '35 - 44'
        WHEN Aims.L_AGE BETWEEN 45 AND 54 THEN '45 - 54'
        WHEN Aims.L_AGE BETWEEN 55 AND 64 THEN '55 - 64'
      ELSE '65+'
      END

,Ethnicity = L12.ETHNICITY_DESC

,L24.DOMICILE_DESC

,Gender = CASE
        WHEN Aims.L13='M' THEN 'Male'
        WHEN Aims.L13='F' THEN 'Female'
     ELSE 'Unknown'
     END

,L_Difficulties = L14.DIFFICULTY_DISABILITY_DESC

,Disability = L15.DISABILITY_DESC

,L_Difficulty = L16.DIFFICULTY_DESC
--,Aims.L17

,Learner_Support_Reason_A = CASE
                  WHEN LRN.L34A = -9 THEN 'Unknown'
                  WHEN LRN.L34A = 1 THEN 'General access support (fees, books, accommodation and meals, other exclud
                  WHEN LRN.L34A = 2 THEN 'Childcare support'
                  WHEN LRN.L34A = 3 THEN 'Residential bursary'
                  WHEN LRN.L34A = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
                  WHEN LRN.L34A = 11 THEN 'Access support refused'
                  WHEN LRN.L34A = 12 THEN 'Childcare support refused'
                  WHEN LRN.L34A = 13 THEN 'Residential bursary refused'
                  WHEN LRN.L34A = 24 THEN 'Adult learning grant (ALG) pilot'
                  WHEN LRN.L34A = 25 THEN 'Educational maintenance allowance (EMA)'
                  WHEN LRN.L34A = 32 THEN 'Career development loan'
                  WHEN LRN.L34A = 41 THEN 'Time off for study'
                  WHEN LRN.L34A = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
                  WHEN LRN.L34A = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to l
                  WHEN LRN.L34A = 51 THEN 'Learner living off campus (privately managed accommodation on provider rec
                  WHEN LRN.L34A = 52 THEN 'Learner living off campus (privately managed accommodation not on provider
                  WHEN LRN.L34A BETWEEN 53 AND 96 THEN 'Unassigned'
                  WHEN LRN.L34A = 99 THEN 'No learner support or no more of the above'
                ELSE 'Unknown'
                END

,Learner_Support_Reason_B = CASE
                  WHEN LRN.L34B = -9 THEN 'Unknown'
                  WHEN LRN.L34B = 1 THEN 'General access support (fees, books, accommodation and meals, other exclud
                  WHEN LRN.L34B = 2 THEN 'Childcare support'
                  WHEN LRN.L34B = 3 THEN 'Residential bursary'
                  WHEN LRN.L34B = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
                  WHEN LRN.L34B = 11 THEN 'Access support refused'
                  WHEN LRN.L34B = 12 THEN 'Childcare support refused'
                  WHEN LRN.L34B = 13 THEN 'Residential bursary refused'
                  WHEN LRN.L34B = 24 THEN 'Adult learning grant (ALG) pilot'
                  WHEN LRN.L34B = 25 THEN 'Educational maintenance allowance (EMA)'
                  WHEN LRN.L34B = 32 THEN 'Career development loan'
                  WHEN LRN.L34B = 41 THEN 'Time off for study'
                  WHEN LRN.L34B = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
                  WHEN LRN.L34B = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to l
                  WHEN LRN.L34B = 51 THEN 'Learner living off campus (privately managed accommodation on provider rec
                  WHEN LRN.L34B = 52 THEN 'Learner living off campus (privately managed accommodation not on provider
                  WHEN LRN.L34B BETWEEN 53 AND 96 THEN 'Unassigned'
                  WHEN LRN.L34B = 99 THEN 'No learner support or no more of the above'
                ELSE 'Unknown'
                END

,Learner_Support_Reason_C = CASE
                  WHEN LRN.L34C = -9 THEN 'Unknown'
                  WHEN LRN.L34C = 1 THEN 'General access support (fees, books, accommodation and meals, other exclud
                  WHEN LRN.L34C = 2 THEN 'Childcare support'
                  WHEN LRN.L34C = 3 THEN 'Residential bursary'
                  WHEN LRN.L34C = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
                  WHEN LRN.L34C = 11 THEN 'Access support refused'
                  WHEN LRN.L34C = 12 THEN 'Childcare support refused'
                  WHEN LRN.L34C = 13 THEN 'Residential bursary refused'
                  WHEN LRN.L34C = 24 THEN 'Adult learning grant (ALG) pilot'
                           WHEN LRN.L34C = 25 THEN 'Educational maintenance allowance (EMA)'
                           WHEN LRN.L34C = 32 THEN 'Career development loan'
                           WHEN LRN.L34C = 41 THEN 'Time off for study'
                           WHEN LRN.L34C = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
                           WHEN LRN.L34C = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to l
                           WHEN LRN.L34C = 51 THEN 'Learner living off campus (privately managed accommodation on provider rec
                           WHEN LRN.L34C = 52 THEN 'Learner living off campus (privately managed accommodation not on provider
                           WHEN LRN.L34C BETWEEN 53 AND 96 THEN 'Unassigned'
                           WHEN LRN.L34C = 99 THEN 'No learner support or no more of the above'
                         ELSE 'Unknown'
                         END

   ,Learner_Support_Reason_D = CASE
                     WHEN LRN.L34D = -9 THEN 'Unknown'
                     WHEN LRN.L34D = 1 THEN 'General access support (fees, books, accommodation and meals, other exclud
                     WHEN LRN.L34D = 2 THEN 'Childcare support'
                     WHEN LRN.L34D = 3 THEN 'Residential bursary'
                     WHEN LRN.L34D = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
                     WHEN LRN.L34D = 11 THEN 'Access support refused'
                     WHEN LRN.L34D = 12 THEN 'Childcare support refused'
                     WHEN LRN.L34D = 13 THEN 'Residential bursary refused'
                     WHEN LRN.L34D = 24 THEN 'Adult learning grant (ALG) pilot'
                     WHEN LRN.L34D = 25 THEN 'Educational maintenance allowance (EMA)'
                     WHEN LRN.L34D = 32 THEN 'Career development loan'
                     WHEN LRN.L34D = 41 THEN 'Time off for study'
                     WHEN LRN.L34D = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
                     WHEN LRN.L34D = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to l
                     WHEN LRN.L34D = 51 THEN 'Learner living off campus (privately managed accommodation on provider rec
                     WHEN LRN.L34D = 52 THEN 'Learner living off campus (privately managed accommodation not on provider
                     WHEN LRN.L34D BETWEEN 53 AND 96 THEN 'Unassigned'
                     WHEN LRN.L34D = 99 THEN 'No learner support or no more of the above'
                   ELSE 'Unknown'
                   END

   ,L35.PRIOR_ATTAINMENT_LEVEL_DESC

   ,LAD.A09_TITL

   ,Aim_Level = CASE
            WHEN LAD.A_NOTION = '1' THEN 'Level 1'
            WHEN LAD.A_NOTION = '2' THEN 'Level 2'
            WHEN LAD.A_NOTION = '3' THEN 'Level 3'
            WHEN LAD.A_NOTION = '4' THEN 'Level 4'
            WHEN LAD.A_NOTION = '5' THEN 'Level 5'
            WHEN LAD.A_NOTION = 'E' THEN 'Entry Level'
            WHEN LAD.A_NOTION = 'H' THEN 'Higher Level'
            WHEN LAD.A_NOTION = 'M' THEN 'Mixed Level'
            WHEN LAD.A_NOTION = 'U' THEN 'Unknown'
            WHEN LAD.A_NOTION = 'X' THEN 'Not Applicable'
          ELSE 'ERROR'
          END

   ,Reason_For_Fee_Remission = A14.A14_N

-- Measures -----------------------------------------------------------------------------------------------------
 ,Enrolments = Count(*)

 ,Completions = SUM(
            CASE
            WHEN Aims.A34 = 2
               THEN 1
          ELSE 0
          END
          )

 ,Achievements = SUM(
            CASE
            WHEN Aims.A35 = 1
              THEN 1
          ELSE 0
          END
          )

FROM

          dbo.ILR0607_C03_AIMS
          AS AIMS

 LEFT OUTER JOIN dbo.ILR0607_C03_LEARNER
        AS LRN
        ON Aims.L01 = LRN.L01 AND Aims.L03 = LRN.L03

 LEFT OUTER JOIN dbo.LAD_0607
        AS LAD
        ON Aims.A09 = LAD.A09

 LEFT OUTER JOIN dbo.ILR0607_UPIN_TO_LLSC
        AS UPN
        ON Aims.L01 = UPN.L01

 LEFT OUTER JOIN LSC_MI_db_pub.dbo.Postcode_Extract_May08_P16DU
        AS PC
        ON UPN.P_POSTCODE = PC.POSTCODE

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L12_ETHNICITY
        AS L12
        ON Aims.L12 = L12.L12

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L14_DIFFICULTY_DISA
        AS L14
        ON Aims.L14 = L14.L14

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L15_DISABILITY
        AS L15
        ON Aims.L15 = L15.L15

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L16_DIFFICULTY
        AS L16
        ON Aims.L16 = L16.L16

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L35_PRIORATTAINLEVE
           AS L35
           ON Aims.L35 = L35.L35

 LEFT OUTER JOIN dbo.A14_LOOKUP
        AS A14
        ON Aims.A14 = A14.A14

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L24_DOMICILES
        AS L24
        ON LRN.L24 = L24.L24

WHERE

   LAD.A_SFLTYP IN ('03', '04', '07', '10', '17')
 AND Aims.L_FUND IN (1, 2)

GROUP BY

  CASE
    WHEN LAD.A_SFLTYP IN('03', '04', '07', '10', '17')
     THEN
       CASE
         WHEN Aims.A09 IN('10037433', '10037445', '10037408', '1003741X', '10037421', '10049022', '10049034', '10048996',
                  '10049010', '10045843', '10045855', '10045818', '1004582X', '10045831', '10064187', '10064199', '10050619
                  '10050620', '10050632', '10057420', '10057432', '10057390', '10057407', '10057419', '10057183', '10057195
                  '10036179', '10036180', '10036192', '10059878', '1005988X', '10059891', '10057201', '10057213', '10048807
                  '10048819', '10048820', '10057225', '10057237', '10048832', '10048844', '10048856', '10042696', '10042702
                  '10042660', '10042672', '10042684', '10045168', '1004517X', '10045132', '10045144', '10045156', '10049381
                  '10049393', '10039429', '10039302', '10039326', '10051326', '10051338', '10051296', '10051302', '10051314
                  '280368', '280414', '280415', '280416', '280369')
           THEN 'Skills For Life ESOL'
         WHEN Aims.A09 IN('50021813', '50021825', '50022982', '50022647', '50021382', '50021850', '50022519', '50022507',
                  '5002114X', '50021795', '50021801', '50021151', '50021163', '50021771', '50021783', '10059878', '1005988X
                  '10059891')
           THEN 'ESOL For Work'
         WHEN Aims.A09 IN ('CBSP0001','CBSP0002','CBSP0003')
           THEN 'Pre-entry Unit'
         WHEN Aims.A09 like 'ZUNA%' or Aims.A09 like 'ZUNE%' or Aims.A09 like 'CUNA%' or Aims.A09 like 'CUNE%'
           THEN 'Other Unit'
             ELSE 'ESOL Unknown'
             END
       END

 ,Aims.L01

 ,UPN.P_PROVIDER_NAME

 ,PC.LEA_NAME

 ,Aims.L_PREG

 --,Aims.L_AGE

 ,CASE
    WHEN Aims.L_AGE BETWEEN 1 AND 18 THEN '16 - 18'
    WHEN Aims.L_AGE BETWEEN 19 AND 24 THEN '19 - 24'
  WHEN Aims.L_AGE BETWEEN 25 AND 34 THEN '25 - 34'
  WHEN Aims.L_AGE BETWEEN 35 AND 44 THEN '35 - 44'
  WHEN Aims.L_AGE BETWEEN 45 AND 54 THEN '45 - 54'
  WHEN Aims.L_AGE BETWEEN 55 AND 64 THEN '55 - 64'
ELSE '65+'
END

,L12.ETHNICITY_DESC

,L24.DOMICILE_DESC

,CASE
   WHEN Aims.L13='M' THEN 'Male'
   WHEN Aims.L13='F' THEN 'Female'
 ELSE 'Unknown'
 END

,L14.DIFFICULTY_DISABILITY_DESC

,L15.DISABILITY_DESC

,L16.DIFFICULTY_DESC

--,Aims.L17

,CASE
   WHEN LRN.L34A = -9 THEN 'Unknown'
   WHEN LRN.L34A = 1 THEN 'General access support (fees, books, accommodation and meals, other excluding transport)'
   WHEN LRN.L34A = 2 THEN 'Childcare support'
   WHEN LRN.L34A = 3 THEN 'Residential bursary'
   WHEN LRN.L34A = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
   WHEN LRN.L34A = 11 THEN 'Access support refused'
   WHEN LRN.L34A = 12 THEN 'Childcare support refused'
   WHEN LRN.L34A = 13 THEN 'Residential bursary refused'
   WHEN LRN.L34A = 24 THEN 'Adult learning grant (ALG) pilot'
   WHEN LRN.L34A = 25 THEN 'Educational maintenance allowance (EMA)'
   WHEN LRN.L34A = 32 THEN 'Career development loan'
   WHEN LRN.L34A = 41 THEN 'Time off for study'
   WHEN LRN.L34A = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
   WHEN LRN.L34A = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to learner)'
   WHEN LRN.L34A = 51 THEN 'Learner living off campus (privately managed accommodation on provider recommended list)'
   WHEN LRN.L34A = 52 THEN 'Learner living off campus (privately managed accommodation not on provider recommended li
   WHEN LRN.L34A BETWEEN 53 AND 96 THEN 'Unassigned'
   WHEN LRN.L34A = 99 THEN 'No learner support or no more of the above'
 ELSE 'Unknown'
 END

,CASE
   WHEN LRN.L34B = -9 THEN 'Unknown'
   WHEN LRN.L34B = 1 THEN 'General access support (fees, books, accommodation and meals, other excluding transport)'
   WHEN LRN.L34B = 2 THEN 'Childcare support'
   WHEN LRN.L34B = 3 THEN 'Residential bursary'
   WHEN LRN.L34B = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
   WHEN LRN.L34B = 11 THEN 'Access support refused'
   WHEN LRN.L34B = 12 THEN 'Childcare support refused'
   WHEN LRN.L34B = 13 THEN 'Residential bursary refused'
  WHEN LRN.L34B = 24 THEN 'Adult learning grant (ALG) pilot'
  WHEN LRN.L34B = 25 THEN 'Educational maintenance allowance (EMA)'
  WHEN LRN.L34B = 32 THEN 'Career development loan'
  WHEN LRN.L34B = 41 THEN 'Time off for study'
  WHEN LRN.L34B = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
  WHEN LRN.L34B = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to learner)'
  WHEN LRN.L34B = 51 THEN 'Learner living off campus (privately managed accommodation on provider recommended list)'
  WHEN LRN.L34B = 52 THEN 'Learner living off campus (privately managed accommodation not on provider recommended li
  WHEN LRN.L34B BETWEEN 53 AND 96 THEN 'Unassigned'
  WHEN LRN.L34B = 99 THEN 'No learner support or no more of the above'
ELSE 'Unknown'
END

,CASE
   WHEN LRN.L34C = -9 THEN 'Unknown'
   WHEN LRN.L34C = 1 THEN 'General access support (fees, books, accommodation and meals, other excluding transport)'
   WHEN LRN.L34C = 2 THEN 'Childcare support'
   WHEN LRN.L34C = 3 THEN 'Residential bursary'
   WHEN LRN.L34C = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
   WHEN LRN.L34C = 11 THEN 'Access support refused'
   WHEN LRN.L34C = 12 THEN 'Childcare support refused'
   WHEN LRN.L34C = 13 THEN 'Residential bursary refused'
   WHEN LRN.L34C = 24 THEN 'Adult learning grant (ALG) pilot'
   WHEN LRN.L34C = 25 THEN 'Educational maintenance allowance (EMA)'
   WHEN LRN.L34C = 32 THEN 'Career development loan'
   WHEN LRN.L34C = 41 THEN 'Time off for study'
   WHEN LRN.L34C = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
   WHEN LRN.L34C = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to learner)'
   WHEN LRN.L34C = 51 THEN 'Learner living off campus (privately managed accommodation on provider recommended list)'
   WHEN LRN.L34C = 52 THEN 'Learner living off campus (privately managed accommodation not on provider recommended li
   WHEN LRN.L34C BETWEEN 53 AND 96 THEN 'Unassigned'
   WHEN LRN.L34C = 99 THEN 'No learner support or no more of the above'
 ELSE 'Unknown'
 END

,CASE
   WHEN LRN.L34D = -9 THEN 'Unknown'
   WHEN LRN.L34D = 1 THEN 'General access support (fees, books, accommodation and meals, other excluding transport)'
   WHEN LRN.L34D = 2 THEN 'Childcare support'
   WHEN LRN.L34D = 3 THEN 'Residential bursary'
   WHEN LRN.L34D = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
   WHEN LRN.L34D = 11 THEN 'Access support refused'
   WHEN LRN.L34D = 12 THEN 'Childcare support refused'
   WHEN LRN.L34D = 13 THEN 'Residential bursary refused'
   WHEN LRN.L34D = 24 THEN 'Adult learning grant (ALG) pilot'
   WHEN LRN.L34D = 25 THEN 'Educational maintenance allowance (EMA)'
   WHEN LRN.L34D = 32 THEN 'Career development loan'
   WHEN LRN.L34D = 41 THEN 'Time off for study'
   WHEN LRN.L34D = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
   WHEN LRN.L34D = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to learner)'
   WHEN LRN.L34D = 51 THEN 'Learner living off campus (privately managed accommodation on provider recommended list)'
   WHEN LRN.L34D = 52 THEN 'Learner living off campus (privately managed accommodation not on provider recommended li
   WHEN LRN.L34D BETWEEN 53 AND 96 THEN 'Unassigned'
   WHEN LRN.L34D = 99 THEN 'No learner support or no more of the above'
 ELSE 'Unknown'
 END
   ,L35.PRIOR_ATTAINMENT_LEVEL_DESC

   ,LAD.A09_TITL

   ,CASE
      WHEN LAD.A_NOTION = '1' THEN 'Level 1'
      WHEN LAD.A_NOTION = '2' THEN 'Level 2'
      WHEN LAD.A_NOTION = '3' THEN 'Level 3'
      WHEN LAD.A_NOTION = '4' THEN 'Level 4'
      WHEN LAD.A_NOTION = '5' THEN 'Level 5'
      WHEN LAD.A_NOTION = 'E' THEN 'Entry Level'
      WHEN LAD.A_NOTION = 'H' THEN 'Higher Level'
      WHEN LAD.A_NOTION = 'M' THEN 'Mixed Level'
      WHEN LAD.A_NOTION = 'U' THEN 'Unknown'
      WHEN LAD.A_NOTION = 'X' THEN 'Not Applicable'
    ELSE 'ERROR'
    END

   ,A14.A14_N


-- * + * + * + * + * + * + * + * + * + * + * + * + * + * + * + * + * +
-- * + * + * + * + * + * + * + * + * + * + * + * + * + * + * + * + * +


UNION ALL


-- * + * + * + * + * + * + * + * + * + * + * + * + * + * + * + * + * +
-- * + * + * + * + * + * + * + * + * + * + * + * + * + * + * + * + * +


SELECT

-- Dimensions ---------------------------------------------------------------------------------------------------

    Funding_Stream = 'Adult Safeguarded Learning'

   ,Collection = 'C03'

   ,Academic_Year = '2007/08'

   ,Aim_Type = CASE
            WHEN LAD.A_SFLTYP IN('03', '04', '07', '10', '17')
              THEN
                CASE
                  WHEN Aims.A09 IN('10037433', '10037445', '10037408', '1003741X', '10037421', '10049022', '10049034', '100
                           '10049010', '10045843', '10045855', '10045818', '1004582X', '10045831', '10064187', '10064199', '10
                           '10050620', '10050632', '10057420', '10057432', '10057390', '10057407', '10057419', '10057183', '10
                           '10036179', '10036180', '10036192', '10059878', '1005988X', '10059891', '10057201', '10057213', '10
                           '10048819', '10048820', '10057225', '10057237', '10048832', '10048844', '10048856', '10042696', '10
                           '10042660', '10042672', '10042684', '10045168', '1004517X', '10045132', '10045144', '10045156', '10
                           '10049393', '10039429', '10039302', '10039326', '10051326', '10051338', '10051296', '10051302', '10
                           '280368', '280414', '280415', '280416', '280369')
                    THEN 'Skills For Life ESOL'
                  WHEN Aims.A09 IN('50021813', '50021825', '50022982', '50022647', '50021382', '50021850', '50022519', '500
                           '5002114X', '50021795', '50021801', '50021151', '50021163', '50021771', '50021783', '10059878', '10
                           '10059891')
                    THEN 'ESOL For Work'
                  WHEN Aims.A09 IN ('CBSP0001','CBSP0002','CBSP0003')
                    THEN 'Pre-entry Unit'
                  WHEN Aims.A09 like 'ZUNA%' or Aims.A09 like 'ZUNE%' or Aims.A09 like 'CUNA%' or Aims.A09 like 'CUNE%
                    THEN 'Other Unit'
                ELSE 'ESOL Unknown'
                END
       END

,Aims.L01

,Provider_Name = UPN.P_PROVIDER_NAME

,Provider_LEA = PC.LEA_NAME

,Provider_Region = Aims.L_PREG

--,Aims.L_AGE

,Age_Band = CASE
        WHEN Aims.L_AGE BETWEEN 1 AND 18 THEN '16 - 18'
        WHEN Aims.L_AGE BETWEEN 19 AND 24 THEN '19 - 24'
        WHEN Aims.L_AGE BETWEEN 25 AND 34 THEN '25 - 34'
        WHEN Aims.L_AGE BETWEEN 35 AND 44 THEN '35 - 44'
        WHEN Aims.L_AGE BETWEEN 45 AND 54 THEN '45 - 54'
        WHEN Aims.L_AGE BETWEEN 55 AND 64 THEN '55 - 64'
      ELSE '65+'
      END

,Ethnicity = L12.ETHNICITY_DESC

,L24.DOMICILE_DESC

,Gender = CASE
        WHEN Aims.L13='M' THEN 'Male'
        WHEN Aims.L13='F' THEN 'Female'
     ELSE 'Unknown'
     END

,L_Difficulties = L14.DIFFICULTY_DISABILITY_DESC

,Disability = L15.DISABILITY_DESC

,L_Difficulty = L16.DIFFICULTY_DESC

--,Aims.L17

,Learner_Support_Reason_A = CASE
                  WHEN LRN.L34A = -9 THEN 'Unknown'
                  WHEN LRN.L34A = 1 THEN 'General access support (fees, books, accommodation and meals, other exclud
                  WHEN LRN.L34A = 2 THEN 'Childcare support'
                  WHEN LRN.L34A = 3 THEN 'Residential bursary'
                  WHEN LRN.L34A = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
                  WHEN LRN.L34A = 11 THEN 'Access support refused'
                  WHEN LRN.L34A = 12 THEN 'Childcare support refused'
                  WHEN LRN.L34A = 13 THEN 'Residential bursary refused'
                  WHEN LRN.L34A = 24 THEN 'Adult learning grant (ALG) pilot'
                  WHEN LRN.L34A = 25 THEN 'Educational maintenance allowance (EMA)'
                  WHEN LRN.L34A = 32 THEN 'Career development loan'
                  WHEN LRN.L34A = 41 THEN 'Time off for study'
                  WHEN LRN.L34A = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
                  WHEN LRN.L34A = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to l
                  WHEN LRN.L34A = 51 THEN 'Learner living off campus (privately managed accommodation on provider rec
                  WHEN LRN.L34A = 52 THEN 'Learner living off campus (privately managed accommodation not on provider
                  WHEN LRN.L34A BETWEEN 53 AND 96 THEN 'Unassigned'
                  WHEN LRN.L34A = 99 THEN 'No learner support or no more of the above'
                ELSE 'Unknown'
                END

,Learner_Support_Reason_B = CASE
                  WHEN LRN.L34B = -9 THEN 'Unknown'
                  WHEN LRN.L34B = 1 THEN 'General access support (fees, books, accommodation and meals, other exclud
                  WHEN LRN.L34B = 2 THEN 'Childcare support'
                  WHEN LRN.L34B = 3 THEN 'Residential bursary'
                  WHEN LRN.L34B = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
                  WHEN LRN.L34B = 11 THEN 'Access support refused'
                  WHEN LRN.L34B = 12 THEN 'Childcare support refused'
                  WHEN LRN.L34B = 13 THEN 'Residential bursary refused'
                  WHEN LRN.L34B = 24 THEN 'Adult learning grant (ALG) pilot'
                  WHEN LRN.L34B = 25 THEN 'Educational maintenance allowance (EMA)'
                  WHEN LRN.L34B = 32 THEN 'Career development loan'
                  WHEN LRN.L34B = 41 THEN 'Time off for study'
                  WHEN LRN.L34B = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
                  WHEN LRN.L34B = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to l
                  WHEN LRN.L34B = 51 THEN 'Learner living off campus (privately managed accommodation on provider rec
                  WHEN LRN.L34B = 52 THEN 'Learner living off campus (privately managed accommodation not on provider
                  WHEN LRN.L34B BETWEEN 53 AND 96 THEN 'Unassigned'
                  WHEN LRN.L34B = 99 THEN 'No learner support or no more of the above'
                ELSE 'Unknown'
                END

,Learner_Support_Reason_C = CASE
                  WHEN LRN.L34C = -9 THEN 'Unknown'
                  WHEN LRN.L34C = 1 THEN 'General access support (fees, books, accommodation and meals, other exclud
                  WHEN LRN.L34C = 2 THEN 'Childcare support'
                  WHEN LRN.L34C = 3 THEN 'Residential bursary'
                  WHEN LRN.L34C = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
                  WHEN LRN.L34C = 11 THEN 'Access support refused'
                  WHEN LRN.L34C = 12 THEN 'Childcare support refused'
                  WHEN LRN.L34C = 13 THEN 'Residential bursary refused'
                  WHEN LRN.L34C = 24 THEN 'Adult learning grant (ALG) pilot'
                  WHEN LRN.L34C = 25 THEN 'Educational maintenance allowance (EMA)'
                  WHEN LRN.L34C = 32 THEN 'Career development loan'
                  WHEN LRN.L34C = 41 THEN 'Time off for study'
                  WHEN LRN.L34C = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
                  WHEN LRN.L34C = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to l
                  WHEN LRN.L34C = 51 THEN 'Learner living off campus (privately managed accommodation on provider rec
                  WHEN LRN.L34C = 52 THEN 'Learner living off campus (privately managed accommodation not on provider
                  WHEN LRN.L34C BETWEEN 53 AND 96 THEN 'Unassigned'
                           WHEN LRN.L34C = 99 THEN 'No learner support or no more of the above'
                         ELSE 'Unknown'
                         END

   ,Learner_Support_Reason_D = CASE
                     WHEN LRN.L34D = -9 THEN 'Unknown'
                     WHEN LRN.L34D = 1 THEN 'General access support (fees, books, accommodation and meals, other exclud
                     WHEN LRN.L34D = 2 THEN 'Childcare support'
                     WHEN LRN.L34D = 3 THEN 'Residential bursary'
                     WHEN LRN.L34D = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
                     WHEN LRN.L34D = 11 THEN 'Access support refused'
                     WHEN LRN.L34D = 12 THEN 'Childcare support refused'
                     WHEN LRN.L34D = 13 THEN 'Residential bursary refused'
                     WHEN LRN.L34D = 24 THEN 'Adult learning grant (ALG) pilot'
                     WHEN LRN.L34D = 25 THEN 'Educational maintenance allowance (EMA)'
                     WHEN LRN.L34D = 32 THEN 'Career development loan'
                     WHEN LRN.L34D = 41 THEN 'Time off for study'
                     WHEN LRN.L34D = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
                     WHEN LRN.L34D = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to l
                     WHEN LRN.L34D = 51 THEN 'Learner living off campus (privately managed accommodation on provider rec
                     WHEN LRN.L34D = 52 THEN 'Learner living off campus (privately managed accommodation not on provider
                     WHEN LRN.L34D BETWEEN 53 AND 96 THEN 'Unassigned'
                     WHEN LRN.L34D = 99 THEN 'No learner support or no more of the above'
                   ELSE 'Unknown'
                   END

   ,L35.PRIOR_ATTAINMENT_LEVEL_DESC

   ,LAD.A09_TITL

   ,Aim_Level = CASE
            WHEN LAD.A_NOTION = '1' THEN 'Level 1'
            WHEN LAD.A_NOTION = '2' THEN 'Level 2'
            WHEN LAD.A_NOTION = '3' THEN 'Level 3'
            WHEN LAD.A_NOTION = '4' THEN 'Level 4'
            WHEN LAD.A_NOTION = '5' THEN 'Level 5'
            WHEN LAD.A_NOTION = 'E' THEN 'Entry Level'
            WHEN LAD.A_NOTION = 'H' THEN 'Higher Level'
            WHEN LAD.A_NOTION = 'M' THEN 'Mixed Level'
            WHEN LAD.A_NOTION = 'U' THEN 'Unknown'
            WHEN LAD.A_NOTION = 'X' THEN 'Not Applicable'
          ELSE 'ERROR'
          END

   ,Reason_For_Fee_Remission = A14.A14_N

-- Measures -----------------------------------------------------------------------------------------------------

   ,Enrolments = Count(*)

   ,Completions = SUM(
              CASE
              WHEN Aims.A34 = 2
                 THEN 1
            ELSE 0
            END
         )

 ,Achievements = SUM(
            CASE
            WHEN Aims.A35 = 1
              THEN 1
          ELSE 0
          END
          )

FROM

         dbo.ILR0708_C03_AIMS
         AS AIMS

 LEFT OUTER JOIN dbo.ILR0708_C03_LEARNER
        AS LRN
        ON Aims.L01 = LRN.L01 AND Aims.L03 = LRN.L03

 LEFT OUTER JOIN dbo.LAD_0708
        AS LAD
        ON Aims.A09 = LAD.A09

 LEFT OUTER JOIN dbo.ILR0708_UPIN_TO_LLSC
        AS UPN
        ON Aims.L01 = UPN.L01

 LEFT OUTER JOIN LSC_MI_db_pub.dbo.Postcode_Extract_May08_P16DU
        AS PC
        ON UPN.P_POSTCODE = PC.POSTCODE

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L12_ETHNICITY
        AS L12
        ON Aims.L12 = L12.L12

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L14_DIFFICULTY_DISA
        AS L14
        ON Aims.L14 = L14.L14

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L15_DISABILITY
        AS L15
        ON Aims.L15 = L15.L15

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L16_DIFFICULTY
        AS L16
        ON Aims.L16 = L16.L16

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L35_PRIORATTAINLEVE
        AS L35
        ON Aims.L35 = L35.L35

 LEFT OUTER JOIN dbo.A14_LOOKUP
        AS A14
        ON Aims.A14 = A14.A14

 LEFT OUTER JOIN dbo.LOOKUP_ILR_L24_DOMICILES
           AS L24
           ON LRN.L24 = L24.L24

WHERE

   LAD.A_SFLTYP IN ('03', '04', '07', '10', '17')
 AND Aims.L_FUND IN (1, 2)

GROUP BY

  CASE
    WHEN LAD.A_SFLTYP IN('03', '04', '07', '10', '17')
      THEN
        CASE
          WHEN Aims.A09 IN('10037433', '10037445', '10037408', '1003741X', '10037421', '10049022', '10049034', '10048996',
                   '10049010', '10045843', '10045855', '10045818', '1004582X', '10045831', '10064187', '10064199', '10050619
                   '10050620', '10050632', '10057420', '10057432', '10057390', '10057407', '10057419', '10057183', '10057195
                   '10036179', '10036180', '10036192', '10059878', '1005988X', '10059891', '10057201', '10057213', '10048807
                   '10048819', '10048820', '10057225', '10057237', '10048832', '10048844', '10048856', '10042696', '10042702
                   '10042660', '10042672', '10042684', '10045168', '1004517X', '10045132', '10045144', '10045156', '10049381
                   '10049393', '10039429', '10039302', '10039326', '10051326', '10051338', '10051296', '10051302', '10051314
                   '280368', '280414', '280415', '280416', '280369')
            THEN 'Skills For Life ESOL'
          WHEN Aims.A09 IN('50021813', '50021825', '50022982', '50022647', '50021382', '50021850', '50022519', '50022507',
                   '5002114X', '50021795', '50021801', '50021151', '50021163', '50021771', '50021783', '10059878', '1005988X
                   '10059891')
            THEN 'ESOL For Work'
          WHEN Aims.A09 IN ('CBSP0001','CBSP0002','CBSP0003')
            THEN 'Pre-entry Unit'
          WHEN Aims.A09 like 'ZUNA%' or Aims.A09 like 'ZUNE%' or Aims.A09 like 'CUNA%' or Aims.A09 like 'CUNE%'
            THEN 'Other Unit'
        ELSE 'ESOL Unknown'
        END
  END

 ,Aims.L01

 ,UPN.P_PROVIDER_NAME

 ,PC.LEA_NAME

 ,Aims.L_PREG

 --,Aims.L_AGE

 ,CASE
    WHEN Aims.L_AGE BETWEEN 1 AND 18 THEN '16 - 18'
    WHEN Aims.L_AGE BETWEEN 19 AND 24 THEN '19 - 24'
    WHEN Aims.L_AGE BETWEEN 25 AND 34 THEN '25 - 34'
    WHEN Aims.L_AGE BETWEEN 35 AND 44 THEN '35 - 44'
    WHEN Aims.L_AGE BETWEEN 45 AND 54 THEN '45 - 54'
    WHEN Aims.L_AGE BETWEEN 55 AND 64 THEN '55 - 64'
  ELSE '65+'
  END

 ,L12.ETHNICITY_DESC
,L24.DOMICILE_DESC

,CASE
   WHEN Aims.L13='M' THEN 'Male'
   WHEN Aims.L13='F' THEN 'Female'
 ELSE 'Unknown'
 END

,L14.DIFFICULTY_DISABILITY_DESC

,L15.DISABILITY_DESC

,L16.DIFFICULTY_DESC

--,Aims.L17

,CASE
   WHEN LRN.L34A = -9 THEN 'Unknown'
   WHEN LRN.L34A = 1 THEN 'General access support (fees, books, accommodation and meals, other excluding transport)'
   WHEN LRN.L34A = 2 THEN 'Childcare support'
   WHEN LRN.L34A = 3 THEN 'Residential bursary'
   WHEN LRN.L34A = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
   WHEN LRN.L34A = 11 THEN 'Access support refused'
   WHEN LRN.L34A = 12 THEN 'Childcare support refused'
   WHEN LRN.L34A = 13 THEN 'Residential bursary refused'
   WHEN LRN.L34A = 24 THEN 'Adult learning grant (ALG) pilot'
   WHEN LRN.L34A = 25 THEN 'Educational maintenance allowance (EMA)'
   WHEN LRN.L34A = 32 THEN 'Career development loan'
   WHEN LRN.L34A = 41 THEN 'Time off for study'
   WHEN LRN.L34A = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
   WHEN LRN.L34A = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to learner)'
   WHEN LRN.L34A = 51 THEN 'Learner living off campus (privately managed accommodation on provider recommended list)'
   WHEN LRN.L34A = 52 THEN 'Learner living off campus (privately managed accommodation not on provider recommended li
   WHEN LRN.L34A BETWEEN 53 AND 96 THEN 'Unassigned'
   WHEN LRN.L34A = 99 THEN 'No learner support or no more of the above'
 ELSE 'Unknown'
 END

,CASE
   WHEN LRN.L34B = -9 THEN 'Unknown'
   WHEN LRN.L34B = 1 THEN 'General access support (fees, books, accommodation and meals, other excluding transport)'
   WHEN LRN.L34B = 2 THEN 'Childcare support'
   WHEN LRN.L34B = 3 THEN 'Residential bursary'
   WHEN LRN.L34B = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
   WHEN LRN.L34B = 11 THEN 'Access support refused'
   WHEN LRN.L34B = 12 THEN 'Childcare support refused'
   WHEN LRN.L34B = 13 THEN 'Residential bursary refused'
   WHEN LRN.L34B = 24 THEN 'Adult learning grant (ALG) pilot'
   WHEN LRN.L34B = 25 THEN 'Educational maintenance allowance (EMA)'
   WHEN LRN.L34B = 32 THEN 'Career development loan'
   WHEN LRN.L34B = 41 THEN 'Time off for study'
   WHEN LRN.L34B = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
   WHEN LRN.L34B = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to learner)'
   WHEN LRN.L34B = 51 THEN 'Learner living off campus (privately managed accommodation on provider recommended list)'
   WHEN LRN.L34B = 52 THEN 'Learner living off campus (privately managed accommodation not on provider recommended li
  WHEN LRN.L34B BETWEEN 53 AND 96 THEN 'Unassigned'
  WHEN LRN.L34B = 99 THEN 'No learner support or no more of the above'
ELSE 'Unknown'
END

,CASE
   WHEN LRN.L34C = -9 THEN 'Unknown'
   WHEN LRN.L34C = 1 THEN 'General access support (fees, books, accommodation and meals, other excluding transport)'
   WHEN LRN.L34C = 2 THEN 'Childcare support'
   WHEN LRN.L34C = 3 THEN 'Residential bursary'
   WHEN LRN.L34C = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
   WHEN LRN.L34C = 11 THEN 'Access support refused'
   WHEN LRN.L34C = 12 THEN 'Childcare support refused'
   WHEN LRN.L34C = 13 THEN 'Residential bursary refused'
   WHEN LRN.L34C = 24 THEN 'Adult learning grant (ALG) pilot'
   WHEN LRN.L34C = 25 THEN 'Educational maintenance allowance (EMA)'
   WHEN LRN.L34C = 32 THEN 'Career development loan'
   WHEN LRN.L34C = 41 THEN 'Time off for study'
   WHEN LRN.L34C = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
   WHEN LRN.L34C = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to learner)'
   WHEN LRN.L34C = 51 THEN 'Learner living off campus (privately managed accommodation on provider recommended list)'
   WHEN LRN.L34C = 52 THEN 'Learner living off campus (privately managed accommodation not on provider recommended li
   WHEN LRN.L34C BETWEEN 53 AND 96 THEN 'Unassigned'
   WHEN LRN.L34C = 99 THEN 'No learner support or no more of the above'
 ELSE 'Unknown'
 END

,CASE
   WHEN LRN.L34D = -9 THEN 'Unknown'
   WHEN LRN.L34D = 1 THEN 'General access support (fees, books, accommodation and meals, other excluding transport)'
   WHEN LRN.L34D = 2 THEN 'Childcare support'
   WHEN LRN.L34D = 3 THEN 'Residential bursary'
   WHEN LRN.L34D = 4 THEN 'Access support (transport only) funded from provider or LEA partnership LSF'
   WHEN LRN.L34D = 11 THEN 'Access support refused'
   WHEN LRN.L34D = 12 THEN 'Childcare support refused'
   WHEN LRN.L34D = 13 THEN 'Residential bursary refused'
   WHEN LRN.L34D = 24 THEN 'Adult learning grant (ALG) pilot'
   WHEN LRN.L34D = 25 THEN 'Educational maintenance allowance (EMA)'
   WHEN LRN.L34D = 32 THEN 'Career development loan'
   WHEN LRN.L34D = 41 THEN 'Time off for study'
   WHEN LRN.L34D = 49 THEN 'Learner living on campus (accommodation owned or managed by provider)'
   WHEN LRN.L34D = 50 THEN 'Learner living off campus (accommodation leased by provider and sub-let to learner)'
   WHEN LRN.L34D = 51 THEN 'Learner living off campus (privately managed accommodation on provider recommended list)'
   WHEN LRN.L34D = 52 THEN 'Learner living off campus (privately managed accommodation not on provider recommended li
   WHEN LRN.L34D BETWEEN 53 AND 96 THEN 'Unassigned'
   WHEN LRN.L34D = 99 THEN 'No learner support or no more of the above'
 ELSE 'Unknown'
 END

,L35.PRIOR_ATTAINMENT_LEVEL_DESC

,LAD.A09_TITL

,CASE
   WHEN LAD.A_NOTION = '1' THEN 'Level 1'
   WHEN LAD.A_NOTION = '2' THEN 'Level 2'
  WHEN LAD.A_NOTION = '3' THEN 'Level 3'
  WHEN LAD.A_NOTION = '4' THEN 'Level 4'
  WHEN LAD.A_NOTION = '5' THEN 'Level 5'
  WHEN LAD.A_NOTION = 'E' THEN 'Entry Level'
  WHEN LAD.A_NOTION = 'H' THEN 'Higher Level'
  WHEN LAD.A_NOTION = 'M' THEN 'Mixed Level'
  WHEN LAD.A_NOTION = 'U' THEN 'Unknown'
  WHEN LAD.A_NOTION = 'X' THEN 'Not Applicable'
ELSE 'ERROR'
END

,A14.A14_N
03741X', '10037421', '10049022', '10049034', '10048996', '10049009',
1004582X', '10045831', '10064187', '10064199', '10050619',
10057390', '10057407', '10057419', '10057183', '10057195',
1005988X', '10059891', '10057201', '10057213', '10048807',
10048832', '10048844', '10048856', '10042696', '10042702',
1004517X', '10045132', '10045144', '10045156', '10049381',
10051326', '10051338', '10051296', '10051302', '10051314',


022647', '50021382', '50021850', '50022519', '50022507', '50022623',
50021163', '50021771', '50021783', '10059878', '1005988X',




 Aims.A09 like 'CUNA%' or Aims.A09 like 'CUNE%'
s, books, accommodation and meals, other excluding transport)'


ly) funded from provider or LEA partnership LSF'




accommodation owned or managed by provider)'
accommodation leased by provider and sub-let to learner)'
privately managed accommodation on provider recommended list)'
privately managed accommodation not on provider recommended list)'




s, books, accommodation and meals, other excluding transport)'


ly) funded from provider or LEA partnership LSF'




accommodation owned or managed by provider)'
accommodation leased by provider and sub-let to learner)'
privately managed accommodation on provider recommended list)'
privately managed accommodation not on provider recommended list)'




s, books, accommodation and meals, other excluding transport)'


 ly) funded from provider or LEA partnership LSF'
accommodation owned or managed by provider)'
accommodation leased by provider and sub-let to learner)'
privately managed accommodation on provider recommended list)'
privately managed accommodation not on provider recommended list)'




s, books, accommodation and meals, other excluding transport)'


ly) funded from provider or LEA partnership LSF'




accommodation owned or managed by provider)'
accommodation leased by provider and sub-let to learner)'
privately managed accommodation on provider recommended list)'
privately managed accommodation not on provider recommended list)'
X', '10037421', '10049022', '10049034', '10048996', '10049009',
2X', '10045831', '10064187', '10064199', '10050619',
90', '10057407', '10057419', '10057183', '10057195',
8X', '10059891', '10057201', '10057213', '10048807',
32', '10048844', '10048856', '10042696', '10042702',
7X', '10045132', '10045144', '10045156', '10049381',
26', '10051338', '10051296', '10051302', '10051314',


', '50021382', '50021850', '50022519', '50022507', '50022623',
63', '50021771', '50021783', '10059878', '1005988X',




A09 like 'CUNA%' or Aims.A09 like 'CUNE%'
modation and meals, other excluding transport)'


 rovider or LEA partnership LSF'




 wned or managed by provider)'
eased by provider and sub-let to learner)'
d accommodation on provider recommended list)'
d accommodation not on provider recommended list)'




modation and meals, other excluding transport)'


 rovider or LEA partnership LSF'
 wned or managed by provider)'
eased by provider and sub-let to learner)'
d accommodation on provider recommended list)'
d accommodation not on provider recommended list)'




modation and meals, other excluding transport)'


provider or LEA partnership LSF'




 wned or managed by provider)'
eased by provider and sub-let to learner)'
d accommodation on provider recommended list)'
d accommodation not on provider recommended list)'




modation and meals, other excluding transport)'


provider or LEA partnership LSF'




 wned or managed by provider)'
eased by provider and sub-let to learner)'
d accommodation on provider recommended list)'
d accommodation not on provider recommended list)'
 03741X', '10037421', '10049022', '10049034', '10048996', '10049009',
1004582X', '10045831', '10064187', '10064199', '10050619',
10057390', '10057407', '10057419', '10057183', '10057195',
1005988X', '10059891', '10057201', '10057213', '10048807',
10048832', '10048844', '10048856', '10042696', '10042702',
1004517X', '10045132', '10045144', '10045156', '10049381',
10051326', '10051338', '10051296', '10051302', '10051314',
022647', '50021382', '50021850', '50022519', '50022507', '50022623',
50021163', '50021771', '50021783', '10059878', '1005988X',




 Aims.A09 like 'CUNA%' or Aims.A09 like 'CUNE%'




s, books, accommodation and meals, other excluding transport)'


ly) funded from provider or LEA partnership LSF'
accommodation owned or managed by provider)'
accommodation leased by provider and sub-let to learner)'
privately managed accommodation on provider recommended list)'
privately managed accommodation not on provider recommended list)'




s, books, accommodation and meals, other excluding transport)'


ly) funded from provider or LEA partnership LSF'




accommodation owned or managed by provider)'
accommodation leased by provider and sub-let to learner)'
privately managed accommodation on provider recommended list)'
privately managed accommodation not on provider recommended list)'




s, books, accommodation and meals, other excluding transport)'


 ly) funded from provider or LEA partnership LSF'




accommodation owned or managed by provider)'
accommodation leased by provider and sub-let to learner)'
privately managed accommodation on provider recommended list)'
privately managed accommodation not on provider recommended list)'
s, books, accommodation and meals, other excluding transport)'


ly) funded from provider or LEA partnership LSF'




accommodation owned or managed by provider)'
accommodation leased by provider and sub-let to learner)'
privately managed accommodation on provider recommended list)'
privately managed accommodation not on provider recommended list)'
X', '10037421', '10049022', '10049034', '10048996', '10049009',
2X', '10045831', '10064187', '10064199', '10050619',
90', '10057407', '10057419', '10057183', '10057195',
8X', '10059891', '10057201', '10057213', '10048807',
32', '10048844', '10048856', '10042696', '10042702',
7X', '10045132', '10045144', '10045156', '10049381',
26', '10051338', '10051296', '10051302', '10051314',


', '50021382', '50021850', '50022519', '50022507', '50022623',
63', '50021771', '50021783', '10059878', '1005988X',




A09 like 'CUNA%' or Aims.A09 like 'CUNE%'
modation and meals, other excluding transport)'


 rovider or LEA partnership LSF'




 wned or managed by provider)'
eased by provider and sub-let to learner)'
d accommodation on provider recommended list)'
d accommodation not on provider recommended list)'




modation and meals, other excluding transport)'


 rovider or LEA partnership LSF'




 wned or managed by provider)'
eased by provider and sub-let to learner)'
d accommodation on provider recommended list)'
d accommodation not on provider recommended list)'
modation and meals, other excluding transport)'


provider or LEA partnership LSF'




 wned or managed by provider)'
eased by provider and sub-let to learner)'
d accommodation on provider recommended list)'
d accommodation not on provider recommended list)'




modation and meals, other excluding transport)'


provider or LEA partnership LSF'




 wned or managed by provider)'
eased by provider and sub-let to learner)'
d accommodation on provider recommended list)'
d accommodation not on provider recommended list)'

								
To top