Il Birth Certificates Printable

Document Sample
Il Birth Certificates Printable Powered By Docstoc
					                                                  ILR Validation Rules 2005/06


Document History:

Version 1 - published 8 March 2005.

Version 2 - published 27 May 2005. Changes from version 1 are underlined and highlighted in the document and include:

Rule                           Change Description             Changed From                                    Changed To

                               Made applicable to WBL
                               which was in error recorded
                               as FE description for use in
R25                            errors reports added.          Flagged as FE rule                              Flagged as WBL rule

                               Made applicable to WBL
                               which was in error recorded
                               as FE and description for
R26                            use in error reports added.    Flagged as FE rule                              Flagged as WBL rule
                               Metadata changed, dates
                               updated to reflect 2005/06
A27_4                          academic year                  IF A27 < 1 August 1994                          IF A27 < 1 August 1995
                               Metadata changed, dates
                               updated to reflect 2005/06
A27_5                          academic year                  IF A27 < 31 July 2005                           IF A27 < 31 July 2006
                               Metadata changed, dates
                               updated to reflect 2005/06
A27_6                          academic year                  IF A27 < 1 August 2014                          IF A27 < 1 August 2015
E22_2                          Metadata changed due to        if E22 not = Spaces AND ( ([digits 1 to 2 of    if E22 not = Spaces AND ( ([digits 1 to
                               Government Office NW           E22] not = (00, 01, 02, 03, 04,05,06 OR         2 of E22] not = (00, 01, 02, 03,
                               issuing ESF project dossier    07)) OR ([digits 3 to 6 of E22] not numeric)    04,05,06 OR 07)) OR ([digits 3 to 6 of
                               numbers which are different    OR ([digits 7 to 8 of E22] NOT IN               E22] not numeric) OR ([digits 7 to 8 of
                               to the standard format.        ['EA','LN','NE','NW','SE','SW','WM','EM','YH'   E22] NOT IN
                                                              ]) OR ([digit 9 of E22] > 3)) AND (E22 not =    ['EA','LN','NE','NW','SE','SW','WM','EM'
                                                              (999999WM3 OR 031010ME1 OR                      ,'YH', 'ME']) OR ([digit 9 of E22] > 3))
                                                              031009ME1 OR 021291ME1 OR                       AND (E22 not = (999999WM3))
                                                              021292ME1 OR 021321ME1 OR
                                                              021322ME1 OR 021323ME1))


A09_A10_A16_A27_LAD_2                                         IF (A10=40 OR A10=41 OR A10=42) AND             IF (A10=40 OR A10=41 OR A10=42)
                                                              (A16=09 OR A16=10) AND A27 => 1                 AND (A16=09 OR A16=10) AND A27
                                                              August 2005 AND A27 <= 31 July 2005             => 1 August 2005 AND A27 <= 31 July
                                                              AND WBL_STATUS_CODE IN                          2006 AND WBL_STATUS_CODE IN
                                                              WBL_ANNUAL_VALUES table in LAD = '2'            WBL_ANNUAL_VALUES table in LAD
                                                              (not valid for new starters)                    = '2' (not valid for new starters)
                               Metadata changed, dates
                               updated to reflect 2005/06
                               academic year
A09_A10_A26_A27_LAD_1          Rule description changed to    For starts after 1 August 2005, if sector       For starts on or after 1 August 2005, if
                               reflect metadata.              framework code is entered, it must match        sector framework code is entered, it
                                                              the framework for that learning aim in the      must match the framework for that
                                                              LAD for funded NVQs, employer approved          learning aim in the LAD for funded
                                                              schemes and technical certificates              NVQs, employer approved schemes
                                                                                                              and technical certificates


A09_A16_A27_LAD_2              Metadata changed to use 10 IF AIM_DISCONTINUED_DATE NOT= Null IF AIM_DISCONTINUED_DATE NOT=
                               rather than 010            AND A16 = (09 or 010 or 00) AND A27> Null AND A16 = (09 or 10 or 00) AND
                                                          AIM_DISCONTINUED_DATE                A27> AIM_DISCONTINUED_DATE

A09_A46a_A46b_LAD_1            Metadata changed to reflect IF (A46a = 27 or A46b = 27 or A46a=30 or           IF (A46a = 27 or A46b = 27 or
                               change of field in LAD      A46b=30) AND BASIC_SKILLS_TYPE in                  A46a=30 or A46b=30) AND
                                                           ALL_ANNUAL_VALUES table in LAD for                 SKILLS_FOR_LIFE_TYPE_CODE in
                                                           learning aim reference in field A09 not =          ALL_ANNUAL_VALUES table in LAD
                                                           (1,2,3,5,6,7,8,9 or 10)                            for learning aim reference in field A09
                                                                                                              not = (1,2,3,5,6,7,8,9 or 10)




 a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                   Document History                                    Page 1 of 1 2005/06 Version 2
                                              ILR Validation Rules 2005/06


                                                         IF A12a NOT = 000 AND A11a < 531 OR >   IF A12a NOT = 000 AND A11a < 541
                             Metadata changed to include 556                                     OR > 566
A11a_A12a_1                  ESF values for 2006
                                                         IF A12b NOT = 000 AND A11b < 536 OR >   IF A12b NOT = 000 AND A11b < 541
                             Metadata changed to include 556                                     OR > 566
A11b_A12b_1                  ESF values for 2006




 a1ea75e1-f64c-44c7-8214-4c768b9df412.xls           Document History                               Page 1 of 1 2005/06 Version 2
                                                                                                        ILR Validation rules 2005/06




          FILENAME VALIDATION


                                                                                                                                             FE
                                                                                                                                             an                                  On-line
From                                                                                                                                          d          ESF   External           Data   Reject
2004/05 Ref               Description             Length Rule ID        Format         Rule Description                                      Ufi WBL ACL SR    Check? E/W LIS?   Capture File? Reason for change
        N01               Filename                       N01_1          FLLLLLLDDAAAYY                                                        Y   Y   Y Y               E   Y      Y       Y
                                                                        YYBBBSS.CCC

                                                            N01_3                         Should be expected return                          Y   Y   Y   Y       Y     E   N       Y       Y
                                                            N01_4                         Transmission number must be greater than           Y   Y   Y   Y       Y     E   N       Y       Y
                                                                                          previous transmission
                                                            N01_5                         Transmission number should be 1 greater than       Y   Y   Y   Y       Y     W   N       Y       N
                                                                                          last transmission number received
New                                                         N01_6                         A file with the same transmission type, provider   Y   Y   Y   Y       Y     E   N       Y       Y      The replaces N01_2. It excludes the
                                                                                          number, allocation type, LSC number,                                                                    serial number from the check to see
                                                                                          collection year, transmission number and file                                                           whether the file has been returned
                                                                                          extension combination must not have been                                                                before. This is to prevent providers
                                                                                          received before                                                                                         sending transmissions that have
                                                                                                                                                                                                  been split into more than one file

          N02             File Type                     1 N02_1         alphanumeric      Must be 'A' or 'B'                                     Y       Y             E   Y       y       Y
                                                          N02_2                           must be A                                          Y       Y                 E   Y       Y       Y
          N03             Provider Number               6 N03_2         numeric           Value must exist on database                       Y   Y   Y   Y       Y     E   Y       Y       Y
          N03a            Contract/Allocation           2 N03a_1        numeric           Must be numeric                                    Y   Y   Y   Y             E   Y       Y       Y
                          Type
                                                          N03a_2                          Must be 00                                             Y   Y   Y             E   Y       Y       Y
                                                          N03a_3                          Must exist on table                                Y                   Y     E   Y       Y       Y
          N04             LSC Number of                 3 N04_1         numeric           Must be numeric                                    Y   Y   Y   Y             E   Y       Y       Y
                          funding LSC
                                                          N04_2                           Value must exist on database or be '999'               Y       Y       Y     E   Y       Y       Y
                                                          N04_3                           Value must be 000                                  Y       Y                 E   Y       Y       Y
          N05             Year of Submission            4 N05_1         numeric           Must be current year (e.g. 0405)                   Y   Y   Y   Y             E   Y       Y       Y
          N06             Transmission Number           3 N06_1         numeric           Must be 3 character numeric                        Y   Y   Y   Y             E   Y       Y       Y
          N07             Serial Number                 2 N07_1         numeric           Must be 2 digit numeric (starts at 01)             Y   Y   Y   Y             E   Y       Y       Y
                                                          N07_2                           Must not be 00                                     Y   Y   Y   Y             E   Y       Y       Y
          N08             Collection Period               N08_1         alphanumeric      Must be 3 characters in the range W01 to W13       Y   Y   Y   Y             E   Y       Y       Y
                                                                                          or the range F01 to F05 or the range C01 to
                                                                                          C03 or the range S01 to S12 or the range U01
                                                                                          to U05 or the range X01 to X99

          HEADER RECORD VALIDATION
                                                                                                                                                        ESF    External                  Reject
          2002/3 Ref      Description             Length Rule ID        Format            Description                                        FE WBL ACL SR     Check? E/W LIS?   Core?   File?
          T01             Provider Number               6 T01_N03_1                       Must be same as in filename unless T01 =           Y   Y   Y Y                E   Y      Y       Y
                                                                                          '999999'
          T01a            Contract/Allocation           2 T01a_N03a_1   numeric           Must be same as in filename                        Y   Y   Y   Y             E   Y       Y       Y
                          Type
          T02             FILLER                       12 T02_1         alphanumeric      Must be spaces                                     Y   Y   Y   Y             E   Y       Y       Y
          T03             Data Set Identifier           2 T03_1         numeric           Must be zeros                                      Y   Y   Y   Y             E   Y       Y       Y
          T04             LSC Number of                 3 T04_N04_1                       Must be same as in filename                        Y   Y   Y   Y             E   Y       Y       Y
                          funding LSC
          T05             Year of Submission            4 T05_N05_1     numeric           Must be same as in filename                        Y   Y   Y   Y             E   Y       Y       Y
          T06             Collection Period             3 T06_N08_1     alphanumeric      Must be same as in filename (extension)            Y   Y   Y   Y             E   Y       Y       Y
          T07             Transmission Number           3 T07_N06_1     numeric           Must be same as in filename                        Y   Y   Y   Y             E   Y       Y       Y
          T08             File Preparation Date         8 T08_1         Date (ddmmyyyy)   Must be a valid date                               Y   Y   Y   Y             E   Y       Y       Y
                                                          T08_2                           Must be <= today's date                            Y   Y   Y   Y             E   Y       Y       Y
          T09             File Type                     1 T09_N02_1     alphanumeric      Must be same as in filename                        Y   Y   Y   Y             E   Y       Y       Y
          T10             Test/live Indicator           1 T10_1         numeric           Must be '1' or '2'                                 Y   Y   Y   Y             E   Y       Y       Y




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                          File Level                                                                       Page 3 of 27 2005/06 Version 2 26/05/2005
                                                                                                          ILR Validation rules 2005/06




          T12a            Software Supplier             40 T12_1         alphanumeric      May be any printable characters except for [*]       Y   Y   Y   Y            E   Y      Y        Y
                          name                                                             and [?] and [%] and [_]
          T12b            Product name                  30 T12_1         alphanumeric      May be any printable characters except for [*]       Y   Y   Y   Y            E   Y      Y        Y
                                                                                           and [?] and [%] and [_]
          T12c            Version Number                20 T12_1         alphanumeric      May be any printable characters except for [*]       Y   Y   Y   Y            E   Y      Y        Y
                                                                                           and [?] and [%] and [_]
          T13      Reserved for LIS                                      alphanumeric
          FOOTER RECORD VALIDATION

                                                                                                                                                           ESF   External                  Reject
          2002/3 Ref      Description              Length Rule ID        Format            Description                                          FE WBL ACL SR    Check? E/W LIS?   Core?   File?

          F01             Provider Number                6 F01_N03_1                       Must be same as in filename unless F01 =             Y   Y   Y   Y            E   Y      Y        Y
                                                                                           '999999'
          F01a            Contract/Allocation            2 F01a_N03a_1   numeric           Must be same as in filename                          Y   Y   Y   Y            E   Y      Y        Y
                          Type
          F02             FILLER                        12 F02_1         alphanumeric      Must be all 'Z's                                     Y   Y   Y   Y            E   Y      Y        Y
          F03             Data Set Identifier            2 F03_1         numeric           Must be 99                                           Y   Y   Y   Y            E   Y      Y        Y
          F04             LSC Number of                  3 F04_N04_1                       Must be same as in filename                          Y   Y   Y   Y            E   Y      Y        Y
                          funding LSC
          F05             Year of Submission             4   F05_N05_1   numeric           Must be same as in filename                          Y   Y   Y   Y            E   Y      Y        Y
          F06             Collection Period              3   F06_N08_1   alphanumeric      Must be same as in filename (extension)              Y   Y   Y   Y            E   Y      Y        Y
          F07             Transmission Number            3   F07_N06_1   numeric           Must be same as in filename                          Y   Y   Y   Y            E   Y      Y        Y
          F08             File Preparation Date          8   F08_T08_1   Date (ddmmyyyy)   Must be same as in file header                       Y   Y   Y   Y            E   Y      Y        Y
          F09             Record Count                   7   F09_1       numeric           Must be numeric                                      Y   Y   Y   Y            E   Y      Y        Y
                                                             F09_2                         Must equal count of all records in file (including   Y   Y   Y   Y            E   Y      Y        Y
                                                                                           header and footer)
Change F11                Reference date for in-         8 F11_1         Data (ddmmyyyy)   Must be a valid date or 00000000                     Y                        E   Y      Y        Y      From 2005/06 the reference date
                          year returns and F05                                                                                                                                                      field will be used for F05
                          return
                                                             F08_F11_1                     Must be <= file preparation date (if entered)        Y                        E   Y      Y        Y
Change                                                       F06_F11_1                     Must not be 00000000 if file extension is X01 -      Y                        E   Y      Y        Y      From 2005/06 the reference date
                                                                                           X99 or F05                                                                                               field will be used for F05
Change                                                       F06_F11_2                     Must be 00000000 filled if file extension is not     Y   Y   Y   Y            E   Y      Y        Y      From 2005/06 the reference date
                                                                                           X01-X99 and not F05                                                                                      field will be used for F05
          F12             Reserved for LIS                               alphanumeric

2003/04 Rules that are deleted for 2004/05
Delete                                                       N01_2                         Must not have been received before                   Y   Y   Y   Y      Y     E   N      Y        Y




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                            File Level                                                                       Page 4 of 27 2005/06 Version 2 26/05/2005
                                                                                                                        ILR Validation rules 2005/06




                                                                                                                                             On-line
From                                                                                                                             ESF          data   Reject FE
04/05     Rule ID        Description                                                                            FE WBL ACL       SR E/W LIS? capture File? Fund? Reason for change
          R03            An Aim record must have an associated Learner record (same Provider Number and          Y  Y   Y         Y  E    Y     Y            Y
                         Learner Reference number)
          R04            An ESF record must have an associated Aim record (same Provider Number and             Y   Y             Y     E     Y        Y
                         Learner Reference number and Learning Aim data set sequence number)
          R05            An HE record must have an associated Aim record (same Provider Number and              Y                       E     Y        Y
                         Learner Reference number and Learning Aim data set sequence number)
          R06            No two Learner records should have the same Contract/Allocation Provider Number        Y   Y       Y     Y     E     Y        Y      Y
                         and Learner Reference number combination
          R07            No two Aim records should have the same Contract/Allocation Provider Number and        Y   Y       Y     Y     E     Y        Y      Y
                         Learner Reference number and Learning aim data set sequence combination
          R08            No two ESF records should have the same Provider Number and Learner Reference          Y   Y             Y     E     Y        Y
                         number and Learning aim data set sequence and ESF dataset sequence combination

          R09            No two HE records should have the same Provider Number and Learner Reference           Y                       E     Y        Y
                         number and Learning aim data set sequence and HE dataset sequence combination

          R11            The number of Aims records should match the count of aims in the learner record and    Y   Y       Y     Y     E     Y        Y      Y
                         be between 00 and 98
          R12            The number of ESF records should match the count of ESF records in the aim record      Y   Y       Y     Y     E     Y        Y      Y
                         and must be 00 or 01
          R13            The number of HE records should match the count of HE records in the aim record        Y   Y       Y     Y     E     Y        Y
                         and must be 00 or 01
          R20            A learner must only have one LSC WBL-funded main aim at any one time                       Y                   E     Y        Y
          R21            At any one time, a learner should have one open aim per non-generic aim reference          Y                   E     Y        Y
                         for a given funding stream.
          R23            If A31 is not null on all aims for a learner then L39, Destination cannot be 95            Y                   E     Y        Y
          R24            A learner must not have more than one aim where A10=40 and A31 = null                      Y                   E     Y        Y          To prevent learners having more than one aim open at any one time
New       R25            IF the start date is >= 1 August 2005 And LSC funding stream, is WBL (A10 = 40, 41         Y                   W     Y        Y          To check for re-starts where 100% of funding is being claimed
                         or 42) and the aim is not a sector framework completion code (Flag11 on learning aim
                         table in LAD <>"Y") and there is another aim with the same Provider Number (A01),
                         Learner reference number (A03), Learning aim reference number (A09), LSC funding
                         stream (A10) combination and with an earlier start date then proportion of funding
                         remaining, A51a should not be 00 ¹
New       R26            IF sector framework achiement date is entered (A43 <> null) there must be no other         Y                   E     Y        Y          To prevent subsiduary aims being left open where the framework has been achieved
                         records with the same Provider number (A01), Learner reference number (A03),
                         Programme type (A15), Sector framework code (A26) combination that are still open
                         (A31 = null). 2

                         ¹ R25 - Where the learner has a previous episode of learning for this learning aim,
                        100% of funding should not be claimed. (This description will appear on the error
                        report)
                        2
                          R26 - Where a sector framework achievement date has been entered there must
                        not be other open aims for that framework. (This description will appear on the error
                        report)




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                 Cross Record Validation                                                                          Page 5 of 27 2005/06 Version 2 26/05/2005
                                                                                  ILR Validation rules 2005/06



                                                                                                                    On-line
From                                                                              FE          ESF                    Data     Reject FE
04/05    Rule ID        Description                                               ufi WBL ACL SR           E/W LIS? Capture   File? Fund?


         I01            All fields must conform to their specified data formats   Y     Y      Y   Y        E    Y     Y       Y      Y
         I02            Data set identifier must be valid                         Y     Y      Y   Y        E    Y     Y       Y      Y
         I03            File length is multiple of record length                  Y     Y      Y   Y        E    Y     Y       Y      Y
         I04            First record in file should be the Header                 Y     Y      Y   Y        E    Y     Y       Y      Y
         I06            Last record in the file should be the Footer              Y     Y      Y   Y        E    Y     Y       Y      Y
         I08            All records have correct record length                    Y     Y      Y   Y        E    Y     Y       Y      Y




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                               Import Validation                                    Page 6 of 27 / 2005/06 Version 2 26/05/2005
                                                                     ILR Validation rules 2005/06



              Learner Level Derived Data



                                                                        FE
                                                                        and                                                                                      On-line Data
Ref           Field Name                        Length Field type       UfI WBL ACL ESF SR Derivation Rule                                     LIS?               Capture           Ext
                                                                                           W for WBL. S for ESF Short record. C for ACL F
                                                                                           for FE, U for UFI. For batch returns derived from
LD04          collection type                         1 alphabetic       Y   Y Y    Y      file extension.                                       Y                      Y
AD01          Age Band at Start (WBL Funding)         2 numeric              Y             Calculated by subtracting Date of Birth (L11) from    Y                      Y
                                                                                           Programme start date (AD02) and truncate to
                                                                                           derive age. Age bands are '1' 16-18 and '2' 19-24
                                                                                           and '3' 25+. Age band 1 will also include 15 year
                                                                                           olds whose birthday lies between the last Friday in
                                                                                           June and the 1st of September and whose learning
                                                                                           start date is in the same date range and learners
                                                                                           where one of the Eligibility for Enhanced Funding
                                                                                           fields has '15' in it.



                                                                                                    Where the programme type A15 is 02 or 03 this is
                                                                                                    derived from the earliest start date field A27 of
                                                                                                    aims with the same learner reference number A03,
                                                                                                    programme type A15 and sector framework code
                                                                                                    A26. Where the programme type is not 02 or 03
AD02          Programme start date                    8 Date                   Y                    set to A27.                                          Y              Y




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                             Derived Data for Validation                                                 Page 7 of 27 / 2005/06 Version 2 26/05/2005
                                                                                                                                                                                           On-line
                                                                                                                                                                FE/U           ESF          data
From                                                                                                                                 Metadata Description        FI  WBL ACL SR            capture          FE   Batch/
04/05     Rule ID               Field Name
                      Field Number                                FE WBL ACL ESF SR   Rule Description                               (error condition)      E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
          L01_2       L01       Provider number                    Y  Y   Y Y         Must exist on table                                                    E   Y    Y    Y    Y     Y       Y       Y           B/O
          L02_1       L02       Contract/Allocation Type           Y                  Must exist on table                                                    E   Y                    Y       Y                   B/O
          L02_2       L02       Contract/Allocation Type           Y  Y   Y           Must be 00                                                             E        Y    Y    Y     Y       Y                   B/O
          L03_1       L03       Learner reference number           Y  Y   Y Y         Mandatory                                                              E   Y    Y    Y    Y     Y       Y                   B/O
          L03_2       L03       Learner reference number           Y  Y   Y Y         Only acceptable characters are [A to Z],                               E   Y    Y    Y    Y     Y       Y                   B/O
                                                                                      [a to z], [0 to 9] and [ ].
                      L04          Data set identifier code       Y   Y   Y     Y
          L05_1       L05          Learning aims data sets        Y   Y   Y     Y     Must be > 00                                                          E    Y         Y         Y        Y                    B/O
          L06_1       L06          ESF co-financing data sets     Y   Y   Y     Y     Must be 00                                                            E    Y    Y    Y    Y    Y        Y                     B
          L07_1       L07          HE data sets                   Y   Y   Y     Y     Must be 00                                                            E    Y    Y    Y    Y    Y        Y                     B
          L08_1       L08          Deletion flag                      Y         Y     Must be 'Y' or 'N'                                                    E         Y         Y    Y        Y                     B
          L08_2       L08          Deletion flag                      Y         Y     Must be space                                                         E    Y         Y         Y        Y                     B
          L09_1       L09          Learner surname/family name    Y   Y         Y     Mandatory                                                             E    Y    Y         Y    Y        Y                    B/O

          L09_2       L09          Learner surname/family name    Y   Y         Y     Only acceptable characters are                                        E    Y    Y         Y    Y        Y                    B/O
                                                                                      alphabetical characters i.e. A to Z, a to z,
                                                                                      spaces, hyphens and apostrophes.
          L09_3       L09          Learner surname/family name    Y   Y         Y     Must be spaces                                                        E              Y         Y        Y                    B/O

          L10_1       L10          Learner forenames              Y   Y         Y     Mandatory                                                             E    Y    Y         Y    Y        Y                    B/O
          L10_2       L10          Learner forenames              Y   Y         Y     Only acceptable characters are                                        E    Y    Y         Y    Y        Y                    B/O
                                                                                      alphabetical characters i.e. A to Z, a to z,
                                                                                      spaces, hyphens and apostrophes.
       L10_3          L10          Learner forenames              Y   Y         Y     Must be spaces                                                        E              Y         Y        Y                    B/O
       L11_1          L11          Date of birth                  Y   Y   Y     Y     Valid date or 00000000                                                E    Y    Y    Y    Y    Y        Y              Y     B/O
       L11_2          L11          Date of birth                  Y   Y   Y     Y     Warning message if 00000000                                           W    Y         Y    Y    Y        Y                    B/O
Change L11_3          L11          Date of birth                  Y   Y   Y     Y     Date must be before 01/08/2005 and                                    E    Y    Y    Y    Y    Y        Y              Y     B/O    Change in year to reflect the
                                                                                      after 01/01/1850 if entered                                                                                                         start of the 2005/06
                                                                                                                                                                                                                          academic year
Change L11_5          L11          Date of birth                  Y   Y   Y     Y     Date should be after 01/08/1905                                       W    Y    Y    Y    Y    Y        Y                    B/O    change year
       L11_6          L11          Date of birth                  Y   Y   Y     Y     Date of birth must be entered                                         E         Y              Y        Y                    B/O
       L12_2          L12          Ethnicity                      Y   Y   Y     Y     Must exist on table                                                   E    Y    Y    Y    Y    Y        Y                    B/O
       L13_2          L13          Sex                            Y   Y   Y     Y     Must exist on table                                                   E    Y    Y    Y    Y    Y        Y                    B/O
       L14_2          L14          Learning difficulties and/or   Y   Y   Y     Y     Must exist on table                                                   E    Y    Y    Y    Y    Y        Y                    B/O
                                   disability
          L15_2       L15          Disability                     Y   Y               Must exist on table                                                   E    Y    Y              Y        Y                    B/O
          L15_4       L15          Disability                     Y   Y               Must be 00                                                            E              Y    Y    Y        Y                    B/O
          L16_2       L16          Learning difficulty            Y   Y               Must exist on table                                                   E    Y    Y              Y        Y                    B/O
          L16_3       L16          Learning difficulty            Y   Y               Must be 00                                                            E              Y    Y    Y        Y                    B/O
          L17_1       L17          Home postcode                  Y   Y   Y     Y     Should exist on table or be ZZ99 ZZZ or                               W    Y    Y    Y    Y             Y      Y             B/O
                                                                                      all spaces
          L17_2       L17          Home postcode                  Y   Y   Y     Y     First part should exist on table or be                                W    Y    Y    Y    Y    Y               Y              B
                                                                                      'ZZ99' or the whole postcode must be
                                                                                      spaces
          L17_3       L17          Home postcode                  Y   Y   Y     Y     The second part of the postcode must be                               E    Y    Y    Y    Y    Y        Y                    B/O
                                                                                      in the correct format (nXX) where n = 0-9
                                                                                      and XX are capital letters excluding C, I,
                                                                                      K, M, O and V, or be 'ZZZ', or the whole
                                                                                      postcode must be spaces
          L17_4       L17          Home postcode                  Y   Y   Y     Y     The first part of the postcode must                                   E    Y    Y    Y    Y    Y        Y                    B/O
                                                                                      conform to the format 1 or 2 capital
                                                                                      letters followed by (1 or 2 numbers or 1
                                                                                      number and a capital letter) or the whole
                                                                                      postcode must be spaces
          L18_1       L18          Address line 1                 Y   Y         Y     Mandatory                                                             E    Y    Y         Y    Y        Y                    B/O
          L18_2       L18          Address line 1                 Y   Y         Y     Only acceptable characters are [A to Z],                              E    Y    Y         Y    Y        Y                    B/O
                                                                                      [a to z], [0 to 9], commas, hyphens,
                                                                                      apostrophes, slashes, full stops,
                                                                                      ampersands, exclamation marks, open
                                                                                      and close brackets, plus signs, colons,
                                                                                      semi-colons, @ and spaces.
          L18_3       L18          Address line 1                 Y   Y         Y     Must be spaces                                                        E              Y         Y        Y                    B/O




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                 Field Level Validation                                                                          Page 8 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                                           On-line
                                                                                                                                                                FE/U           ESF          data
From                                                                                                                                 Metadata Description        FI  WBL ACL SR            capture          FE   Batch/
04/05     Rule ID               Field Name
                      Field Number                                    FE WBL ACL ESF SR   Rule Description                           (error condition)      E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
          L19_1       L19       Address line 2                         Y  Y         Y     Only acceptable characters are [A to Z],                           E   Y    Y         Y     Y       Y                   B/O
                                                                                          [a to z], [0 to 9], commas, hyphens,
                                                                                          apostrophes, slashes, full stops,
                                                                                          ampersands, exclamation marks, open
                                                                                          and close brackets, plus signs, colons,
                                                                                          semi-colons, @ and spaces.
          L19_2       L19          Address line 2                     Y   Y         Y     Must be spaces                                                    E              Y         Y        Y                    B/O
          L20_1       L20          Address line 3                     Y   Y         Y     Only acceptable characters are [A to Z],                          E    Y    Y         Y    Y        Y                    B/O
                                                                                          [a to z], [0 to 9], commas, hyphens,
                                                                                          apostrophes, slashes, full stops,
                                                                                          ampersands, exclamation marks, open
                                                                                          and close brackets, plus signs, colons,
                                                                                          semi-colons, @ and spaces.
          L20_2       L20          Address line 3                     Y   Y         Y     Must be spaces                                                    E              Y         Y        Y                    B/O
          L21_1       L21          Address line 4                     Y   Y         Y     Only acceptable characters are [A to Z],                          E    Y    Y         Y    Y        Y                    B/O
                                                                                          [a to z], [0 to 9], commas, hyphens,
                                                                                          apostrophes, slashes, full stops,
                                                                                          ampersands, exclamation marks, open
                                                                                          and close brackets, plus signs, colons,
                                                                                          semi-colons, @ and spaces.
          L21_2       L21          Address line 4                     Y   Y         Y     Must be spaces                                                    E              Y         Y        Y                    B/O
          L22_1       L22          Current Postcode                   Y   Y               Should exist on table or be all spaces                            W    Y    Y                       Y      Y             B/O
          L22_2       L22          Current Postcode                   Y   Y               First part should must exist on table or                          W    Y    Y              Y               Y              B
                                                                                          the whole postcode must be spaces
          L22_3       L22          Current Postcode                   Y   Y               The second part of the postcode must be                           E    Y    Y              Y        Y                    B/O
                                                                                          in the correct format (nXX) where n = 0-9
                                                                                          and XX are capital letters excluding C, I,
                                                                                          K, M, O and V or the whole postcode
                                                                                          must be spaces
          L22_4       L22          Current Postcode                   Y   Y               The first part of the postcode must                               E    Y    Y              Y        Y                    B/O
                                                                                          conform to the format 1 or 2 capital
                                                                                          letters followed by (1 or 2 numbers or 1
                                                                                          number and a capital letter) or the whole
                                                                                          postcode must be spaces
          L22_5       L22          Current Postcode                   Y   Y               Must be spaces                                                    E              Y    Y    Y        Y                    B/O
          L23_1       L23          Telephone number                   Y   Y         Y     Must be left justified (space filled)                             E    Y    Y         Y    Y        Y                    B/O
                                                                                          numeric or all spaces or '+' followed by
                                                                                          numbers. Spaces are allowed between
                                                                                          numbers.
          L23_2       L23          Telephone number                   Y   Y         Y     Must be spaces                                                    E              Y         Y        Y                    B/O
          L24_1       L24          Country of domicile                Y   Y               Must exist on table                                               E    Y    Y              Y        Y                    B/O
          L24_2       L24          Country of domicile                Y   Y               Must be 000                                                       E              Y    Y    Y        Y                    B/O
          L25_2       L25          LSC number of funding LSC              Y   Y     Y     Must exist on table and not be 000                                E         Y    Y    Y    Y        Y      Y             B/O
          L25_3       L25          LSC number of funding LSC              Y   Y     Y     Must be 000                                                       E    Y                   Y        Y                    B/O
          L26_1       L26          National insurance number              Y               The (first character must not be D, F, I,                         E    Y    Y              Y        Y                    B/O
                                                                                          Q, U or V and the second character must
                                                                                          not be D, F, I, O, Q, U or V and
                                                                                          characters 3 to 8 must be numeric and
                                                                                          character 9 must be A, B, C, D or space)
                                                                                          unless the NI number is spaces
          L26_10      L26          National insurance number          Y   Y               Must be spaces                                                    E              Y    Y    Y        Y                    B/O
          L27_1       L27          Restricted use indicator           Y   Y         Y     Must exist on table                                               E    Y    Y         Y    Y        Y                    B/O
          L27_2       L27          Restricted use indicator           Y   Y         Y     Must be 0                                                         E              Y         Y        Y                    B/O
          L28a_4      L28a         Eligibility for enhanced funding   Y   Y               Must be 00                                                        E              Y    Y    Y        Y                    B/O
                                   (1)
          L28a_6      L28a         Eligibility for enhanced funding   Y   Y               Must exist on table                                               E    Y                   Y        Y                    B/O
                                   (1)
          L28a_7      L28a         Eligibility for enhanced funding   Y   Y               Must exist on table (if entered)                                  E         Y              Y        Y                    B/O
                                   (1)
          L28b_4      L28b         Eligibility for enhanced funding   Y   Y               Must be 00                                                        E              Y    Y    Y        Y                    B/O
                                   (2)
          L28b_6      L28b         Eligibility for enhanced funding   Y   Y               Must exist on table                                               E    Y                   Y        Y                    B/O
                                   (1)
          L28b_7      L28b         Eligibility for enhanced funding   Y   Y               Must exist on table (if entered)                                  E         Y              Y        Y                    B/O
                                   (1)




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                     Field Level Validation                                                                      Page 9 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                                           On-line
                                                                                                                                                                FE/U           ESF          data
From                                                                                                                                 Metadata Description        FI  WBL ACL SR            capture          FE   Batch/
04/05     Rule ID               Field Name
                      Field Number                                   FE WBL ACL ESF SR   Rule Description                            (error condition)      E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
          L29_1       L29       Additional support                    Y                  Must exist on table                                                 E   Y                    Y       Y                   B/O
          L29_2       L29       Additional support                    Y                  Must be 00                                                          E        Y    Y    Y     Y       Y                   B/O
          L31_2       L31       Additional support cost               Y                  Warning message will be generated if                                W   Y                    Y       Y                   B/O
                                                                                         value is greater than 19000
          L31_3       L31          Additional support cost           Y                   Must be => 000000 and <= 999999                                    E    Y                   Y        Y              Y     B/O
          L31_4       L31          Additional support cost           Y                   Must be 000000                                                     E         Y    Y    Y    Y        Y                    B/O
          L32_1       L32          Eligibility for disadvantage      Y                   Must exist on table                                                E    Y                   Y        Y              Y     B/O
                                   uplift
          L32_2       L32          Eligibility for disadvantage      Y                   Must be 00                                                         E         Y    Y    Y    Y        Y              Y     B/O
                                   uplift
          L33_1       L33          Disadvantage uplift factor        Y                   Must be either 0.0000 or a number in the                           E    Y                   Y        Y              Y     B/O
                                                                                         range 1.0000 to 1.2500 inclusive.
          L33_2       L33          Disadvantage uplift factor        Y                   Must be 0.0000                                                     E         Y    Y    Y    Y        Y                    B/O
          L33_3       L33          Disadvantage uplift factor        Y                   Must have decimal point in position 2                              E    Y                   Y        Y                    B/O
          L34a_2      L34a         Learner support reason (1)        Y   Y               Must be 41 or 99                                                   E         Y              Y        Y                    B/O
          L34a_3      L34a         Learner support reason (1)        Y   Y               Must exist on table                                                E    Y                   Y        Y                    B/O
          L34a_4      L34a         Learner support reason (1)        Y   Y               Must be 00                                                         E              Y    Y    Y        Y                    B/O
          L34b_2      L34b         Learner support reason (2)        Y   Y               Must be 41 or 99                                                   E         Y              Y        Y                    B/O
          L34b_3      L34b         Learner support reason (2)        Y   Y               Must exist on table                                                E    Y                   Y        Y                    B/O
          L34b_4      L34b         Learner support reason (2)        Y   Y               Must be 00                                                         E              Y    Y    Y        Y                    B/O
          L34c_2      L34c         Learner support reason (3)        Y   Y               Must be 41 or 99                                                   E         Y              Y        Y                    B/O
          L34c_3      L34c         Learner support reason (3)        Y   Y               Must exist on table                                                E    Y                   Y        Y                    B/O
          L34c_4      L34c         Learner support reason (3)        Y   Y               Must be 00                                                         E              Y    Y    Y        Y                    B/O
          L34d_2      L34d         Learner support reason (4)        Y   Y               Must be 41 or 99                                                   E         Y              Y        Y                    B/O
          L34d_3      L34d         Learner support reason (4)        Y   Y               Must exist on table                                                E    Y                   Y        Y                    B/O
          L34d_4      L34d         Learner support reason (4)        Y   Y               Must be 00                                                         E              Y    Y    Y        Y                    B/O
          L35_1       L35          Prior attainment level            Y   Y         Y     Must exist on table                                                E    Y    Y         Y    Y        Y                    B/O
          L35_2       L35          Prior attainment level            Y   Y         Y     Must be 00                                                         E              Y         Y        Y                    B/O
          L36_1       L36          Learner status on last working        Y               Must exist on table                                                E         Y              Y        Y                    B/O
                                   day before learning
          L36_2       L36          Learner status on last working        Y               Must be 0                                                          E    Y         Y    Y    Y        Y                    B/O
                                   day before learning
          L37_1       L37          Employment status on first            Y               Must exist on table                                                E         Y              Y        Y                    B/O
                                   day of learning
          L37_2       L37          Employment status on first            Y               Must be zeros                                                      E    Y         Y    Y    Y        Y                    B/O
                                   day of learning
          L38_1       L38          Employment status on last day         Y               Must exist on table (if present)                                   E         Y              Y        Y                    B/O
                                   of learning
          L38_2       L38          Employment status on last day         Y               Must be zeros                                                      E    Y         Y    Y    Y        Y                    B/O
                                   of learning
          L39_1       L39          Destination                       Y   Y         Y     Must exist on table (if present)                                   E    Y                   Y        Y                    B/O
          L39_2       L39          Destination                       Y   Y         Y     Must exist on table                                                E         Y         Y    Y        Y                    B/O

          L39_4       L39          Destination                       Y   Y         Y     Must be zeros                                                      E              Y         Y        Y                    B/O
          L40a_2      L40a         National learner monitoring (1)   Y   Y   Y           Must be 11-19, 99                                                  E         Y    Y         Y        Y                    B/O

          L40a_3      L40a         National learner monitoring (1)   Y   Y   Y           Must exist on table                                                E    Y                   Y        Y                    B/O

          L40a_4      L40a         National learner monitoring (1)   Y   Y   Y           Must be 00                                                         E                   Y    Y        Y                    B/O

          L40b_2      L40b         National learner monitoring (2)   Y   Y   Y           Must be 11-19, 99                                                  E         Y    Y         Y        Y                    B/O

          L40b_3      L40b         National learner monitoring (2)   Y   Y   Y           Must exist on table                                                E    Y                   Y        Y                    B/O

          L40b_4      L40b         National learner monitoring (1)   Y   Y   Y           Must be 00                                                         E                   Y    Y        Y                    B/O

          L41a_1      L41a         Local learner monitoring (1)      Y   Y               Must be => 0 if entered                                            E    Y    Y         Y    Y        Y                    B/O
          L41a_2      L41a         Local learner monitoring (1)      Y   Y               Must be zeros                                                      E              Y         Y        Y                    B/O
          L41b_1      L41b         Local learner monitoring (2)      Y   Y               Must be => 0 if entered                                            E    Y    Y         Y    Y        Y                    B/O
          L41b_2      L41b         Local learner monitoring (2)      Y   Y               Must be zeros                                                      E              Y         Y        Y                    B/O

          L42a_1      L42a         Provider specified learner data   Y   Y   Y     Y     May be any printable characters except                             E    Y    Y    Y    Y    Y        Y                    B/O
                                   (1)                                                   for [*] and [?] and [%] and [_]
          L42b_1      L42b         Provider specified learner data   Y   Y   Y     Y     May be any printable characters except                             E    Y    Y    Y    Y    Y        Y                    B/O
                                   (2)                                                   for [*] and [?] and [%] and [_]




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                    Field Level Validation                                                                       Page 10 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                                           On-line
                                                                                                                                                                FE/U           ESF          data
From                                                                                                                                 Metadata Description        FI  WBL ACL SR            capture          FE   Batch/
04/05     Rule ID               Field Name
                      Field Number                                   FE WBL ACL ESF SR   Rule Description                            (error condition)      E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
          L44_1       L44       NCS delivery LSC number                  Y               Must not be 002                                                     E        Y               Y       Y                   B/O
          L44_2       L44       NCS delivery LSC number                  Y               Must be 000                                                         E   Y         Y    Y     Y       Y                   B/O
          L44_3       L44       NCS delivery LSC number                  Y               Must exist on table (if entered)                                    E        Y               Y       Y                   B/O
          A01_1       A01       Provider number                       Y  Y   Y      Y    Must be the same as L01                                             E   Y    Y    Y    Y     Y       Y              Y    B/O
          A02_1       A02       Allocation number                     Y  Y               Must be the same as L02                                             E   Y         Y    Y     Y       Y              Y    B/O
          A02_2       A02       Allocation number                     Y  Y               Must be 12 (if entered)                                             E        Y               Y       Y              Y    B/O
          A02_3       A02       Allocation number                     Y  Y               Must be 00                                                          E             Y    Y     Y       Y                   B/O
                      A03       Learner reference number              Y  Y   Y      Y
                      A04       Data set identifier code              Y  Y   Y      Y
          A05_1       A05       Learning aim data set                 Y  Y   Y      Y    Must be numeric and between 01 and 98                              E    Y    Y    Y    Y    Y        Y              Y      B
                                sequence
          A06_1       A06       ESF data sets                        Y   Y   Y     Y     Must be 00                                                         E              Y         Y        Y                    B/O
          A07_2       A07       HE Data Sets                         Y   Y   Y     Y     Must be 00                                                         E         Y    Y    Y    Y        Y                    B/O
          A08_2       A08       Data Set Format                      Y   Y   Y     Y     Must be 1                                                          E    Y                   Y        Y                    B/O
          A08_3       A08       Data Set Format                      Y   Y   Y     Y     Must be 2                                                          E         Y              Y        Y                    B/O
          A08_4       A08       Data Set Format                      Y   Y   Y     Y     Must be 3                                                          E              Y         Y        Y                    B/O
          A08_5       A08       Data Set Format                      Y   Y   Y     Y     Must be 4                                                          E                   Y    Y        Y                    B/O
          A09_1       A09       Learning aim reference code          Y   Y   Y     Y     Must exist on Learning Aims Database                               E    Y    Y    Y    Y    Y        Y      Y       Y     B/O
                                                                                         (LEARNING_AIM Table)
          A10_3       A10          LSC Funding stream                Y   Y   Y     Y     Must be 20, 70, 80 or 99                                           E    Y                   Y        Y              Y     B/O
          A10_4       A10          LSC Funding stream                Y   Y   Y     Y     Must be 40, 41, 42, 70, 80 or 99                                   E         Y              Y        Y                    B/O
          A10_5       A10          LSC Funding stream                Y   Y   Y     Y     Must be 10, 80, 99                                                 E              Y         Y        Y                    B/O
          A10_6       A10          LSC Funding stream                Y   Y   Y     Y     Must be 10, 70, 80                                                 E                   Y    Y        Y                    B/O
          A11a_1      A11a         Source of funding (1)             Y       Y           Must exist on table                                                E    Y         Y         Y        Y              Y     B/O
          A11a_2      A11a         Source of funding (1)             Y       Y           Must be 000                                                        E         Y         Y    Y        Y                    B/O
          A11b_1      A11b         Source of funding (2)             Y       Y           Must exist on table                                                E    Y         Y         Y        Y              Y     B/O
          A11b_2      A11b         Source of funding (2)             Y       Y           Must be 000                                                        E         Y         Y    Y        Y                    B/O
          A12a_1      A12a         Implied rate of LSC funding for   Y                   Must be between 0 & 100                                            E    Y                   Y        Y              Y     B/O
                                   historic ESF (1)
          A12a_2      A12a         Implied rate of LSC funding for   Y                   Must be 0                                                          E         Y    Y    Y    Y        Y                    B/O
                                   historic ESF (1)
          A12b_1      A12b         Implied rate of LSC funding for   Y                   Must be between 0 & 100                                            E    Y                   Y        Y              Y     B/O
                                   historic ESF (2)
          A12b_2      A12b         Implied rate of LSC funding for   Y                   Must be 0                                                          E         Y    Y    Y    Y        Y                    B/O
                                   historic ESF (2)
          A13_1       A13          Tuition fee received for year     Y       Y           Must be between 00000 & 99999                                      E    Y         Y         Y        Y              Y     B/O
          A13_2       A13          Tuition fee received for year     Y       Y           Must be 00000                                                      E         Y         Y    Y        Y                    B/O
          A14_1       A14          Reason for partial or full non-   Y       Y           Must exist on table                                                E    Y         Y         Y        Y              Y     B/O
                                   payment of tuition fees
          A14_2       A14          Reason for partial or full non-   Y       Y           Must be 00                                                         E         Y         Y    Y        Y                    B/O
                                   payment of tuition fees
          A15_1       A15          Programme type                        Y               Must exist on table                                                E         Y              Y        Y                    B/O
          A15_2       A15          Programme type                        Y               Must be 00                                                         E    Y         Y    Y    Y        Y                    B/O
          A16_2       A16          Programme entry route                 Y               Must be 00                                                         E    Y         Y    Y    Y        Y                    B/O
          A16_3       A16          Programme entry route                 Y               Must exist on table if entered                                     E         Y              Y        Y                    B/O
          A17_1       A17          Delivery mode                     Y                   Must exist on table                                                E    Y                   Y        Y              Y     B/O
          A17_2       A17          Delivery mode                     Y                   Must be 0                                                          E         Y    Y    Y    Y        Y                    B/O
          A18_1       A18          Main delivery method              Y                   Must exist on table                                                E    Y                   Y        Y              Y     B/O
          A18_2       A18          Main delivery method              Y                   Must be 00                                                         E         Y    Y    Y    Y        Y                    B/O
          A19_1       A19          Employer role                     Y                   Must exist on table                                                E    Y                   Y        Y              Y     B/O
          A19_2       A19          Employer role                     Y                   Must be 0                                                          E         Y    Y    Y    Y        Y                    B/O
          A20_1       A20          Resit                             Y                   Must exist on table                                                E    Y                   Y        Y              Y     B/O
          A20_2       A20          Resit                             Y                   Must be 0                                                          E         Y    Y    Y    Y        Y                    B/O
          A21_1       A21          Franchised out partnership        Y                   Must exist on table                                                E    Y                   Y        Y              Y     B/O
                                   arrangements
          A21_2       A21          Franchised out partnership        Y                   Must be 00                                                         E         Y    Y    Y    Y        Y                    B/O
                                   arrangements
          A22_1       A22          Franchising delivery provider     Y                   Must be spaces                                                     E         Y    Y    Y    Y        Y                    B/O
                                   number
          A23_1       A23          Delivery location postcode        Y   Y   Y     Y     Should exist on table or be ZZ99 ZZZ or                            W    Y    Y    Y    Y             Y      Y             B/O
                                                                                         all spaces
          A23_2       A23          Delivery location postcode        Y   Y   Y     Y     First part should exist on table or be                             W    Y    Y    Y    Y    Y               Y              B
                                                                                         'ZZ99' or the whole postcode must be
                                                                                         spaces




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                    Field Level Validation                                                                       Page 11 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                                             On-line
                                                                                                                                                                  FE/U           ESF          data
From                                                                                                                                Metadata Description           FI  WBL ACL SR            capture          FE   Batch/
04/05     Rule ID               Field Name
                      Field Number                                   FE WBL ACL ESF SR   Rule Description                           (error condition)         E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
          A23_3       A23       Delivery location postcode            Y  Y   Y      Y    The second part of the postcode must be                               E   Y    Y    Y    Y     Y       Y                   B/O
                                                                                         in the correct format (nXX) where n = 0-9
                                                                                         and XX are capital letters excluding C, I,
                                                                                         K, M, O and V, or be 'ZZZ', or the whole
                                                                                         postcode must be spaces
          A23_4       A23          Delivery location postcode        Y   Y   Y     Y     The first part of the postcode must                                  E    Y    Y    Y    Y    Y        Y                    B/O
                                                                                         conform to the format 1 or 2 capital
                                                                                         letters followed by (1 or 2 numbers or 1
                                                                                         number and a capital letter) or the whole
                                                                                         postcode must be spaces
          A23_5       A23          Delivery location postcode        Y   Y   Y     Y     Mandatory                                                            E    Y                   Y        Y                    B/O
          A24_1       A24          Occupation relating to learner    Y   Y         Y     Must exist on table if entered                                       E    Y    Y         Y    Y        Y                    B/O
                                   aim
          A24_2       A24          Occupation relating to learner    Y   Y         Y     Must be zeros                                                        E              Y         Y        Y                    B/O
                                   aim
       A26_1          A26          Sector framework of learning      Y   Y               Must exist on table (if entered)                                     E         Y              Y        Y                    B/O
       A26_2          A26          Sector framework of learning      Y   Y               Must be zeros                                                        E    Y         Y    Y    Y        Y                    B/O
       A27_1          A27          Learning start date               Y   Y   Y     Y     Mandatory                                                            E    Y    Y    Y    Y    Y        Y              Y     B/O
       A27_2          A27          Learning start date               Y   Y   Y     Y     Must be a valid date                                                 E    Y    Y    Y    Y    Y        Y              Y     B/O
Change A27_4          A27          Learning start date               Y   Y   Y     Y     Start date must not be more than ten        IF A27 < 1 August 1995   E    Y    Y    Y    Y    Y        Y                    B/O     Dates need to change to
                                                                                         years ago                                                                                                                           reflect 2005/06
Change A27_5          A27          Learning start date               Y   Y   Y     Y     Start date must not be after current        IF A27 > 31 July 2006    E    Y         Y    Y    Y        Y                    B/O     Dates need to change to
                                                                                         learning year                                                                                                                       reflect 2005/06
Change A27_6          A27          Learning Start Date               Y   Y   Y     Y     Start date must not be more than 10         IF A27 > 1 August 2015   E         Y         Y    Y        Y                    B/O     Dates need to change to
                                                                                         years in the future                                                                                                                 reflect 2005/06
          A28_1       A28          Learning planned end date         Y   Y   Y     Y     Mandatory                                                            E    Y    Y    Y    Y    Y        Y              Y     B/O
          A28_2       A28          Learning planned end date         Y   Y   Y     Y     Must be a valid date                                                 E    Y    Y    Y    Y    Y        Y              Y     B/O
          A31_1       A31          Learning actual end date          Y   Y   Y     Y     Must be a valid date or 00000000                                     E    Y    Y    Y    Y    Y        Y              Y     B/O
          A31_2       A31          Learning actual end date          Y   Y   Y     Y     Must be on or before today's date if                                 E         Y         Y             Y                     O
                                                                                         entered
Change A31_3          A31          Learning actual end date          Y   Y   Y     Y     Should be after 1 August 2004                                        W    Y                   Y        Y                     B
Change A31_4          A31          Learning actual end date          Y   Y   Y     Y     Should be before 1 August 2006                                       W    Y    Y         Y    Y        Y                     B
Change A31_5          A31          Learning actual end date          Y   Y   Y     Y     Must be before 1 August 2008                                         E    Y                   Y        Y              Y      B
       A32_1          A32          Guided learning hours             Y       Y           Must be numeric characters in the range                              E    Y    Y    Y         Y        Y              Y     B/O
                                                                                         [00000 to 10000].
          A32_2       A32          Guided learning hours             Y       Y           Warning message will be output if the                                W    Y    Y    Y         Y        Y                    B/O
                                                                                         value is greater than [2000] The Guided
                                                                                         learner hours should not be greater than
                                                                                         2000
          A32_3       A32          Guided learning hours             Y       Y           Must be 00000                                                        E         Y         Y    Y        Y                    B/O
          A34_2       A34          Completion status                 Y   Y   Y     Y     Must be 1, 2, 3, or 4                                                E    Y         Y         Y        Y              Y     B/O
          A34_3       A34          Completion status                 Y   Y   Y     Y     Must exist on table                                                  E         Y         Y    Y        Y                    B/O
          A35_1       A35          Learning outcome                  Y   Y   Y     Y     Must exist on table                                                  E    Y    Y    Y    Y    Y        Y              Y     B/O
          A36_1       A36          Learning outcome grade            Y                   Must exist on table (if present)                                     E    Y                   Y        Y                    B/O
          A36_2       A36          Learning outcome grade            Y                   Must be spaces                                                       E         Y    Y    Y    Y        Y                    B/O
          A37_1       A37          Number of units completed         Y   Y               Must be => 0                                                         E    Y    Y              Y        Y              Y     B/O
          A37_2       A37          Number of units completed         Y   Y               Must be zeros                                                        E              Y    Y    Y        Y                    B/O
          A38_1       A38          Number of units to achieve full   Y   Y               Must be => 0                                                         E    Y    Y              Y        Y              Y     B/O
                                   qualification
          A38_2       A38          Number of units to achieve full   Y   Y               Must be zeros                                                        E              Y    Y    Y        Y                    B/O
                                   qualification
          A39_1       A39          Eligibility for achievement       Y                   Must exist on table (if present)                                     E    Y                   Y        Y              Y     B/O
                                   funding
          A39_2       A39          Eligibility for achievement       Y                   Must be 0                                                            E         Y    Y    Y    Y        Y                    B/O
                                   funding
          A40_1       A40          Achievement date                      Y               Must be a valid date or 00000000                                     E         Y              Y        Y                    B/O
          A40_2       A40          Achievement date                      Y               Date must be less than or equal to                                   E         Y                       Y                     O
                                                                                         today’s date.
          A40_3       A40          Achievement date                      Y               Must be zeros                                                        E    Y         Y    Y    Y        Y                    B/O
          A43_1       A43          Sector framework                      Y               Must be a valid date or 00000000                                     E         Y              Y        Y                    B/O
                                   achievement Date
          A43_2       A43          Sector framework                      Y               Must be 00000000                                                     E    Y         Y    Y    Y        Y                    B/O
                                   achievement Date




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                    Field Level Validation                                                                         Page 12 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                                             On-line
                                                                                                                                                                  FE/U           ESF          data
From                                                                                                                                  Metadata Description         FI  WBL ACL SR            capture          FE   Batch/
04/05  Rule ID                  Field Name
                      Field Number                                   FE WBL ACL ESF SR   Rule Description                             (error condition)       E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
Change A44_1          A44       Employer Identifier                      Y               May be any printable characters except                                E   Y    Y               Y       Y                   B/O Change in field name and to
                                                                                         for [*] and [?] and [%] and [_]                                                                                                  make field available for FE
                                                                                                                                                                                                                          providers
Change A44_2          A44          Employer Identifier                   Y               Must be spaces                                                       E    Y         Y    Y    Y        Y                   B/O Change in field name and to
                                                                                                                                                                                                                          make field available for FE
                                                                                                                                                                                                                          providers
Change A45_1          A45          Workplace Location Postcode           Y               Should exist on table or be all spaces                               W    Y    Y                       Y      Y            B/O Change in field name and to
                                                                                                                                                                                                                          make field available for FE
                                                                                                                                                                                                                          providers
Change A45_2          A45          Workplace location postcode           Y               First part should exist on table or the                              W    Y    Y              Y               Y             B    Change in field name and to
                                                                                         whole postcode must be spaces                                                                                                    make field available for FE
                                                                                                                                                                                                                          providers
Change A45_3          A45          Workplace Location Postcode           Y               The second part of the postcode must be                              E    Y    Y              Y        Y                   B/O Change in field name and to
                                                                                         in the correct format (nXX) where n = 0-9                                                                                        make field available for FE
                                                                                         and XX are capital letters excluding C, I,                                                                                       providers
                                                                                         K, M, O and V or the whole postcode
                                                                                         must be spaces
Change A45_4          A45          Workplace location postcode           Y               The first part of the postcode must                                  E    Y    Y              Y        Y                     B/O     Change in field name and to
                                                                                         conform to the format 1 or 2 capital                                                                                                 make field available for FE
                                                                                         letters followed by (1 or 2 numbers or 1                                                                                             providers
                                                                                         number and a capital letter) or the whole
                                                                                         postcode must be spaces
Change A45_5          A45          Workplace location postcode           Y               Must be spaces                                                       E    Y         Y    Y    Y        Y                     B/O     Change in field name and to
                                                                                                                                                                                                                              make field available for FE
Change A46a_1         A46a         National learning aim             Y   Y   Y           Must be                                                              E    Y                   Y        Y              Y      B/O     providers
                                                                                                                                                                                                                              Code changes in the field
                                   monitoring (1)                                        01,13,14,15,16,17,18,19,20,21,23,24,25,
                                                                                         31,34,35, 36-60 or 99
Change A46a_2         A46a         National learning aim             Y   Y   Y           Must be 14, 15, 16, 17,21, 26-30,32-                                 E         Y              Y        Y                     B/O     Code changes in the field
                                   monitoring (1)                                        33,35, 36 to 60 or 99
Change A46a_4         A46a         National learning aim             Y   Y   Y           Must be 14,15,16,23,24,35,36-60 or 99                                E              Y         Y        Y                     B/O     Code changes in the field
                                   monitoring (1)
Change A46a_5         A46a         National learning aim             Y   Y   Y           Must be 14,15,16, 17, 21, 23, 24, 35, 36-                            E                   Y    Y        Y                     B/O     Code changes in the field
                                   monitoring (1)                                        60 or 99
Change A46b_1         A46b         National learning aim             Y   Y   Y           Must be                                                              E    Y                   Y        Y              Y      B/O     Code changes in the field
                                   monitoring (2)                                        01,13,14,15,16,17,18,19,20,21,23,24,25,
                                                                                         31,34,35, 36-60 or 99
Change A46b_2         A46b         National learning aim             Y   Y   Y           Must be 14, 15, 16, 17,21, 26-30,32-                                 E         Y              Y        Y                     B/O     Code changes in the field
                                   monitoring (2)                                        33,35, 36 to 60 or 99
Change A46b_4         A46b         National learning aim             Y   Y   Y           Must be 14,15,16,23,24,35,36-60 or 99                                E              Y         Y        Y                     B/O     Code changes in the field
                                   monitoring (2)
Change A46b_5         A46b         National learning aim             Y   Y   Y           Must be 14,15,16, 17, 21, 23, 24, 35, 36-                            E                   Y    Y        Y                     B/O     Code changes in the field
                                   monitoring (2)                                        60 or 99
          A47a_1      A47a         Local learning aim monitoring     Y   Y               Must be => 0 if entered                                              E    Y    Y         Y    Y        Y                     B/O
                                   (1)
          A47a_2      A47a         Local learning aim monitoring     Y   Y               Must be zeros                                                        E              Y         Y        Y                     B/O
                                   (1)
          A47b_1      A47b         Local learning aim monitoring     Y   Y               Must be => 0 if entered                                              E    Y    Y         Y    Y        Y                     B/O
                                   (2)
          A47b_2      A47b         Local learning aim monitoring     Y   Y               Must be zeros                                                        E              Y    Y    Y        Y                     B/O
                                   (2)
          A48a_1      A48a         Provider specified learning aim   Y   Y   Y       Y   May be any printable characters except                               E    Y    Y    Y    Y    Y        Y                     B/O
                                   data 1 (1)                                            for [*] and [?] and [%] and [_]
          A48b_1      A48b         Provider specified learning aim   Y   Y   Y       Y   May be any printable characters except                               E    Y    Y    Y    Y    Y        Y                     B/O
                                   data 1 (2)                                            for [*] and [?] and [%] and [_]
New       A49_3       A49          Special Projects and Pilots       Y   Y       Y       Must be a valid code (if entered)            IF A49 not = spaces     E    Y    Y         Y    Y        Y                     B/O     Set of codes now available
                                                                                                                                      and A49 not = [SS001                                                                    for field A49
                                                                                                                                      to SS150] and A49 not
                                                                                                                                      = [CV001 to CV500]
                                                                                                                                      and A49 not = [SP001
                                                                                                                                      to SP300]
          A49_2       A49          Special Projects and Pilots       Y   Y               Must be spaces                                                       E              Y         Y        Y                     B/O
          A50_1       A50          Reason Learning Ended                 Y               Must exist on table if entered                                       E         Y              Y        Y                     B/O
          A50_2       A50          Reason Learning Ended                 Y               Must be zeros                                                        E    Y         Y    Y    Y        Y                     B/O




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                    Field Level Validation                                                                          Page 13 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                                            On-line
                                                                                                                                                                 FE/U           ESF          data
From                                                                                                                                  Metadata Description        FI  WBL ACL SR            capture          FE   Batch/
04/05     Rule ID               Field Name
                      Field Number                                  FE WBL ACL ESF SR   Rule Description                              (error condition)      E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
New       A51a_1      A51a      Proportion of funding                Y      Y Y         Must be zeros                                                         E   Y         Y    Y     Y       Y                   B/O New field for 2005/06 for
                                remaining                                                                                                                                                                                WBL only
New       A51a_2      A51a      Proportion of funding                   Y               Must be numeric characters in the range                              E         Y              Y        Y                   B/O New WBL field for 2005/06
                                remaining                                               [00] to [99].
          A52_1       A52       Distance learning funding           Y                   Must be zeros                                                        E         Y    Y    Y    Y        Y                    B/O
          A52_2       A52       Distance learning funding           Y                   Must be greater or equal to zero                                     E    Y                   Y        Y                    B/O
          A53_1       A53       Additional Learning Needs               Y               Must exist on table (if entered)                                     E         Y              Y        Y                    B/O
          A53_2       A53       Additional Learning Needs               Y               Must be 00                                                           E    Y         Y    Y    Y        Y                    B/O
          E01_1       E01       Contract/allocation provider        Y   Y      Y        Must be the same as A01                                              E    Y    Y         Y    Y        Y                    B/O
                                number
          E02_1       E02       Allocation number                   Y   Y               Must be the same as A02                                              E    Y    Y              Y        Y                    B/O
          E02_2       E02       Allocation number                   Y   Y               Must be zeros                                                        E                   Y    Y        Y                    B/O
                      E03       Learner reference number            Y   Y      Y
                      E04       Data set identifier code            Y   Y      Y
                      E05       Learning Aim Data Set               Y   Y      Y
                                Sequence
          E06_1       E06       ESF co-financing data set           Y   Y      Y        Must be 01                                                           E    Y    Y              Y        Y                    B/O
                                sequence
          E07_1       E07       HE Data Sets                        Y          Y        Must be 00                                                           E    Y    Y         Y    Y        Y                    B/O
          E08_1       E08       Date started ESF co-financing       Y   Y      Y        Must be a valid date                                                 E    Y    Y         Y    Y        Y                    B/O

          E08_3       E08          Date started ESF co-financing    Y   Y      Y        Must not be before 01/09/2001                                        E    Y    Y         Y    Y        Y                    B/O

          E09_1       E09          Planned end date for ESF co-     Y   Y      Y        Must be a valid date                                                 E    Y    Y         Y    Y        Y                    B/O
                                   financing
          E09_2       E09          Planned end date for ESF co-     Y   Y      Y        Must not be before 01/09/2001                                        E    Y    Y         Y    Y        Y                    B/O
                                   financing
          E10_1       E10          Date ended ESF co-financing      Y   Y      Y        Must be a valid date (if entered)                                    E    Y    Y         Y    Y        Y                    B/O
          E10_2       E10          Date ended ESF co-financing      Y   Y      Y        Must not be before 01/09/2001                                        E    Y    Y         Y    Y        Y                    B/O
          E11_1       E11          Industrial sector of learners    Y   Y      Y        Must exist on table                                                  E    Y    Y         Y    Y        Y                    B/O
                                   employer
          E12_1       E12          Learners employment status       Y   Y      Y        Must exist on table                                                  E    Y    Y         Y    Y        Y                    B/O
                                   on day before starting ESF
                                   project
          E13_1       E13          Learners employment status       Y   Y      Y        Must exist on table                                                  E    Y    Y         Y    Y        Y                    B/O
          E14_1       E14          Length of unemployment           Y   Y      Y        Must exist on table                                                  E    Y    Y         Y    Y        Y                    B/O
                                   before starting ESF project
          E15_1       E15          Type and size of learners        Y   Y      Y        Must exist on table                                                  E    Y    Y         Y    Y        Y                    B/O
                                   employer
          E16a_1      E16a         Addressing gender                Y   Y               Must exist on table (if entered)                                     E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                   stereotyping (1)
          E16b_1      E16b         Addressing gender                Y   Y               Must exist on table (if entered)                                     E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                   stereotyping (2)
          E16c_1      E16c         Addressing gender                Y   Y               Must exist on table (if entered)                                     E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                   stereotyping (3)
          E16d_1      E16d         Addressing gender                Y   Y               Must exist on table (if entered)                                     E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                   stereotyping (4)
          E16e_1      E16e         Addressing gender                Y   Y               Must exist on table (if entered)                                     E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                   stereotyping (5)
New       E17a_2      E17a         Main co-financing activity (1)   Y   Y      Y        Must be space filled                                                 E    Y    Y         Y    Y        Y                    B/O     Field no longer required
New       E17b_2      E17b         Main co-financing activity (2)   Y   Y      Y        Must be space filled                                                 E    Y    Y         Y    Y        Y                    B/O     Field no longer required
New       E17c_2      E17c         Main co-financing activity (3)   Y   Y      Y        Must be space filled                                                 E    Y    Y         Y    Y        Y                    B/O     Field no longer required
New       E17d_2      E17d         Main co-financing activity (4)   Y   Y      Y        Must be space filled                                                 E    Y    Y         Y    Y        Y                    B/O     Field no longer required
New       E17e_2      E17e         Main co-financing activity (5)   Y   Y      Y        Must be space filled                                                 E    Y    Y         Y    Y        Y                    B/O     Field no longer required
          E18a_1      E18a         Delivery Mode (1)                Y   Y               Must exist on table (if   entered)                                   E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
          E18b_1      E18b         Delivery Mode (2)                Y   Y               Must exist on table (if   entered)                                   E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
          E18c_1      E18c         Delivery Mode (3)                Y   Y               Must exist on table (if   entered)                                   E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
          E18d_1      E18d         Delivery Mode (4)                Y   Y               Must exist on table (if   entered)                                   E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
          E19a_1      E19a         Support measures to be           Y   Y               Must exist on table (if   entered)                                   E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                   accessed by learner (1)
          E19b_1      E19b         Support measures to be           Y   Y               Must exist on table (if entered)                                     E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                   accessed by learner (2)
          E19c_1      E19c         Support measures to be           Y   Y               Must exist on table (if entered)                                     E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                   accessed by learner (3)




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                     Field Level Validation                                                                       Page 14 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                                           On-line
                                                                                                                                                                FE/U           ESF          data
From                                                                                                                            Metadata Description             FI  WBL ACL SR            capture          FE   Batch/
04/05     Rule ID               Field Name
                      Field Number                            FE WBL ACL ESF SR   Rule Description                              (error condition)           E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
          E19d_1      E19d      Support measures to be         Y  Y               Must exist on table (if entered)                                           E   Y    Y         Y     Y       Y                   B/O Field available for ESF SR
                                accessed by learner (4)
          E19e_1      E19e      Support measures to be         Y  Y               Must exist on table (if entered)                                          E    Y    Y         Y    Y        Y                    B/O     Field available for ESF SR
                                accessed by learner (5)
          E20a_1      E20a      Learner background (1)         Y  Y      Y        Must exist on table (if   entered)                                        E    Y    Y         Y    Y        Y                    B/O
          E20b_1      E20b      Learner background (2)         Y  Y      Y        Must exist on table (if   entered)                                        E    Y    Y         Y    Y        Y                    B/O
          E20c_1      E20c      Learner background (3)         Y  Y      Y        Must exist on table (if   entered)                                        E    Y    Y         Y    Y        Y                    B/O
          E21_1       E21       Support measures for learners Y   Y               Must exist on table (if   entered)                                        E    Y    Y         Y    Y        Y                    B/O
                                with disability
          E22_2       E22       Project Dossier Number         Y  Y      Y        Must be correct format (if entered)           if E22 not = Spaces         E    Y    Y         Y    Y        Y                    B/O
                                                                                                                                AND ( ([digits 1 to 2 of
                                                                                                                                E22] not = (00, 01, 02,
                                                                                                                                03, 04,05,06 OR 07))
                                                                                                                                OR ([digits 3 to 6 of
                                                                                                                                E22] not numeric) OR
                                                                                                                                ([digits 7 to 8 of E22]
                                                                                                                                NOT IN
                                                                                                                                ['EA','LN','NE','NW','SE'
                                                                                                                                ,'SW','WM','EM','YH',
                                                                                                                                'ME']) OR ([digit 9 of
                                                                                                                                E22] > 3)) AND (E22
                                                                                                                                not = (999999WM3))
Change E23_2          E23          Local Project number             Y   Y   Y     Must be numeric and >=0 in the range                                      E    Y    Y         Y    Y        Y                    B/O     To enforce correct format for
                                                                                  [000] to [999]                                                                                                                           local project number
          H01_1       H01          Provider number                  Y             Must be the same as A01                                                   E    Y                   Y        Y                    B/O
          H02_1       H02          Allocation number                Y             Must be the same as A02                                                   E    Y                   Y        Y                    B/O
                      H03          Learner reference number         Y
                      H04          Data set identifier code         Y
                      H05          Learning aim data set            Y
                                   sequence
          H06_1       H06          ESF co-financing data set        Y             Must be 00                                                                E    Y                   Y        Y                    B/O
                                   sequence
          H07_1       H07          HE data set sequence             Y             Must be 01                                                                E    Y                   Y        Y                    B/O
          H08_1       H08          Learning aim reference code      Y             Must be the same as A09                                                   E    Y                   Y        Y                    B/O
          H09_1       H09          Learner instance number          Y             May be any printable characters except                                    E    Y                   Y        Y                    B/O
                                                                                  for [*] and [?] and [%] and [_]
          H10_1       H10          Learner nationality              Y             Must be spaces or 0000 to 9999                                            E    Y                   Y        Y                    B/O
          H11_1       H11          Highest qualification on entry   Y             Must exist on table                                                       E    Y                   Y        Y                    B/O
          H12_1       H12          New entrant to HE                Y             Must exist on table                                                       E    Y                   Y        Y                    B/O
          H13_1       H13          Type of programme year           Y             Must exist on table                                                       E    Y                   Y        Y                    B/O
          H14_1       H14          Mode applicable to Funding       Y             Must exist on table                                                       E    Y                   Y        Y                    B/O
                                   Council early statistics,
                                   HEIFES
          H15_1       H15          Level applicable to Funding      Y             Must exist on table                                                       E    Y                   Y        Y                    B/O
                                   Council HEIFES
          H16_1       H16          Completion of year of            Y             Must exist on table                                                       E    Y                   Y        Y                    B/O
                                   programme of study
          H17_1       H17          Learner FTE                      Y             Must be numeric => 000.0 and <= 300.0                                     E    Y                   Y        Y                    B/O

          H17_2       H17          Learner FTE                      Y             Must have decimal point in position 4                                     E    Y                   Y        Y                    B/O
          H18_1       H18          Year of programme of study       Y             Must be => 00 and <= 99                                                   E    Y                   Y        Y                    B/O
          H19_1       H19          Fee band                         Y             Must exist on table                                                       E    Y                   Y        Y                    B/O
          H20_1       H20          Major source of tuition fees     Y             Must exist on table                                                       E    Y                   Y        Y                    B/O
          H21_1       H21          Term time accommodation          Y             Must exist on table (if entered)                                          E    Y                   Y        Y                    B/O
          H22_1       H22          UCAS applicant number            Y             Must be numeric                                                           E    Y                   Y        Y                    B/O
          H23_1       H23          SOC occupation code              Y             Must exist on table or be 0000, 0007,                                     E    Y                   Y        Y                    B/O
                                                                                  0008, 0009
          H24_1       H24          Last institution                 Y             Only acceptable characters are [A to Z],                                  E    Y                   Y        Y                    B/O
                                                                                  [a to z], [0 to 9] and spaces
Change H25_1          H25          Year at last institution         Y             Must be in the range 1900 to 2006                                         E    Y                   Y        Y                    B/O
                                                                                  inclusive or 0000 or 9999
          H26_1       H26          Number of A levels               Y             Must exist on table (if entered)                                          E    Y                   Y        Y                    B/O
          H27_1       H27          A/AS level score                 Y             Numeric value =>00 and <= 30                                              E    Y                   Y        Y                    B/O
          H28_1       H28          Number of SCE Highers and        Y             Must exist on table (if entered)                                          E    Y                   Y        Y                    B/O
                                   CSYS




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                               Field Level Validation                                                                            Page 15 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                                          On-line
                                                                                                                                                               FE/U           ESF          data
From                                                                                                                                Metadata Description        FI  WBL ACL SR            capture          FE   Batch/
04/05     Rule ID               Field Name
                      Field Number                                  FE WBL ACL ESF SR   Rule Description                            (error condition)      E/W Rule Rule Rule rule LIS?   system    Ext   Fund? Online Reason for change
          H29_1       H29       Scottish higher points               Y                  Numeric value =>00 and <= 30                                        E   Y                    Y       Y                   B/O
          H30_1       H30       Number of vocational                 Y                  Must exist on table (if entered)                                    E   Y                    Y       Y                   B/O
                                qualifications
          H31_1       H31       Reason for leaving                  Y                   Must exist on table (if entered)                                   E    Y                   Y        Y                    B/O
          H32_1       H32       Proportion not taught by this       Y                   Numeric value =>000.0 and <=100.0                                  E    Y                   Y        Y                    B/O
                                institution
          H32_2       H32       Proportion not taught by this       Y                   Must have decimal point in position 4                              E    Y                   Y        Y                    B/O
                                institution
          H33_1       H33       Proportion taught in                Y                   Numeric value =>000.0 and <=100.0                                  E    Y                   Y        Y                    B/O
                                Superclass 1 subject
          H33_2       H33       Proportion taught in                Y                   Must have decimal point in position 4                              E    Y                   Y        Y                    B/O
                                Superclass 1 subject
          H34_1       H34       Proportion taught in                Y                   Numeric value =>000.0 and <=100.0                                  E    Y                   Y        Y                    B/O
                                Superclass 2 subject
          H34_2       H34       Proportion taught in                Y                   Must have decimal point in position 4                              E    Y                   Y        Y                    B/O
                                Superclass 2 subject
          H35_1       H35       Proportion taught in                Y                   Numeric value =>000.0 and <=100.0                                  E    Y                   Y        Y                    B/O
                                Superclass 3 subject
          H35_2       H35       Proportion taught in                Y                   Must have decimal point in position 4                              E    Y                   Y        Y                    B/O
                                Superclass 3 subject
          H36_1       H36       Socio-economic indicator            Y                   Must exist on table                                                E    Y                   Y        Y                    B/O

2004/05 rules that are deleted for 2005/06
Delete    A51_3       A51          On programme payments                Y               Must be zeros                                                      E    Y    Y    Y    Y    Y        Y                    B/O     OPPs no longer apply. This
                                                                                                                                                                                                                          rule enforces zero entries
Delete    E08_2       E08          Date started ESF co-financing    Y   Y      Y        Must be <= today's date                                            E    Y    Y         Y             Y                     O      To facilitate the use of
                                                                                                                                                                                                                          subsiduary aims for ESF
                                                                                                                                                                                                                          provision
Delete    E17a_1      E17a         Main co-financing activity (1)   Y   Y      Y        Must exist on table (if entered)                                   E    Y    Y         Y    Y        Y                    B/O
Delete    E17b_1      E17b         Main co-financing activity (2)   Y   Y      Y        Must exist on table (if entered)                                   E    Y    Y         Y    Y        Y                    B/O

Delete    E17c_1      E17c         Main co-financing activity (3)   Y   Y      Y        Must exist on table (if entered)                                   E    Y    Y         Y    Y        Y                    B/O
Delete    E17d_1      E17d         Main co-financing activity (4)   Y   Y      Y        Must exist on table (if entered)                                   E    Y    Y         Y    Y        Y                    B/O
Delete    E17e_1      E17e         Main co-financing activity (5)   Y   Y      Y        Must exist on table (if entered)                                   E    Y    Y         Y    Y        Y                    B/O
delete    A49_1       A49          Special Projects and Pilots      Y   Y               May be any printable characters except                             E    Y    Y         Y    Y        Y                    B/O     Set of codes now available
                                                                                        for [*] and [?] and [%] and [_]                                                                                                   for the field




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                   Field Level Validation                                                                       Page 16 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                 ILR validation rules 2005/06




                                                                                                                                                                                               On-line
                                                                                                                                                                                                data
                                                                                                                                                                                               captur
                                                                                                                                                                                     ESF         e
From                                                                                                                                                           FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                           Rule Description                                                     Metadata                                 E/W    Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule                                   Reason for change
            A05_L05_1                      The data set sequence must be less than or equal to the number       IF A05 > L05                              E      Y     Y         Y    Y    Y     Y                   B
                                           of datasets
            A06_A10_1                      If LSC Funding Stream is LSC ESF Co-financed, there must be an       IF A10 = 70 AND A06 = 00                 E       Y        Y              Y      Y   Y               B/O Consistency of data with control fields
                                           ESF data set
            A06_A10_2                      ESF data must not be submitted if there is no LSC funding for the    IF A06 = 1 AND A10 = 99                  E       Y        Y      Y              Y   Y               B/O
                                           aim
            A06_L39_1                      Destination code must be valid for LSC ESF learning                  IF A06 = 1 AND L39 = NULL                 E      Y                              Y   Y               B/O
New         A06_A11a_A11b_1                If the source of funding is ESF (non-co-financed) then there must    IF A06 = 1 AND (A11a = (541-546 OR        E      Y                              Y   Y               B/O To prevent ESF funded aims where the provider is the co-
                                           be no ESF dataset                                                    551-556 OR 561-566) OR A11b =                                                                           financing body to be used as match for LSC ESF co-
                                                                                                                (541-546 OR 551-556 OR 561-566))                                                                        financing

            A07_A09_LAD_1                  If the Aim is HE Level, there must be an HE dataset                  IF NOTIONAL_NVQ_LVL_ID decodes            E      Y                              Y   Y   Y            B
                                                                                                                to = 'H' on LEARNING_AIM table in
                                                                                                                LAD AND A07 = 0

            A07_A11a_1                     If the aim is either supported by HEFCE funding or is eligible for   IF A11a = 001 OR 002 AND A07 = 00         E      Y                              Y   Y               B/O Consistency of data with control fields
                                           HEFCE funding, there must be an HE data set
            A07_A11b_1                     If the aim is either supported by HEFCE funding or is eligible for   IF A11b = 001 OR 002 AND A07 = 00         E      Y                              Y   Y               B/O Consistency of data with control fields
                                           HEFCE funding, there must be an HE data set
            A09_A10_1                      If the learning aim is XESF0001 the LSC funding stream must be       IF A09 = 'XESF0001' AND A10 NOT =         E               Y              Y      Y   Y               B/O
                                           <70> LSC ESF co-financed                                             70
            A09_A10_A15_3                  A WBL funded E2E programme must use the E2E learning aim             if a15=09 and a10=40 and a09              E               Y                     Y   Y               B/O
                                           code                                                                 not=XE2E0001
            A09_A10_A15_A24_LAD_1          Occupation relating to learning aim must be entered for WBL          IF FLAG11 on LEARNING_AIM table           E               Y                     Y   Y   Y           B/O
                                           funded Advanced Apprenticeship, Apprenticeship and NVQ main          in LAD not ="Y" AND A10 = 40 AND
                                           aims. Except for framework completion class codes                    A15 = (02 OR 03 OR 04 OR 05 OR 06
                                                                                                                OR 07) AND A24 = 0000

            A09_A10_A15_LAD_1              Programme type must be consistent with LAD level for NVQ level       IF A10 = 40 AND ((A15 = 04 AND            E               Y                     Y   Y   Y           B/O
                                           1 to 3 Learning for funded aims                                      NOTIONAL_NVQ_LVL_CODE in
                                                                                                                LEARNING_AIM NOT = 1) OR (A15 =
                                                                                                                05 AND
                                                                                                                NOTIONAL_NVQ_LVL_CODE in
                                                                                                                LEARNING_AIM NOT = 2) OR (A15 =
                                                                                                                06 AND
                                                                                                                NOTIONAL_NVQ_LVL_CODE in
                                                                                                                LEARNING_AIM NOT = 3)
            A09_A10_A15_LAD_2              Programme type should be consistent with LAD level for NVQ            if FLAG11 in LEARNING_AIM Not =         W                Y                     Y   Y   Y           B/O
                                           level 4 and for funded aims within Apprenticeship programmes.        "Y" and (a10=40) and if (A15 = 07
                                           Except for framework completion class codes                          AND NOTIONAL_NVQ_LVL_CODE in
                                                                                                                LEARNING_AIM NOT = 4) OR (A15 =
                                                                                                                02 AND
                                                                                                                NOTIONAL_NVQ_LVL_CODE in
                                                                                                                LEARNING_AIM NOT = (3 OR 4)) OR
                                                                                                                (A15 = 03 AND
                                                                                                                NOTIONAL_NVQ_LVL_CODE in
                                                                                                                LEARNING_AIM NOT = 2))
Change      A09_A10_A16_A27_LAD_2          Must be valid learning aim for this year for a new start for WBL-    IF (A10=40 OR A10=41 OR A10=42)           E               Y                     Y   Y   Y           B/O                                                            Dates need to change to reflect 2005/06
                                           funded provision for first-time entrants                             AND (A16=09 OR A16=10) AND A27
                                                                                                                => 1 August 2005 AND A27 <= 31
                                                                                                                July 2006 AND WBL_STATUS_CODE
                                                                                                                IN WBL_ANNUAL_VALUES table in
                                                                                                                LAD = '2' (not valid for new starters)

Change      A09_A10_A16_A27_LAD_3          Must be valid learning aim for this year for a new start for provision IF A10=(70 or 80 or 99) AND (A16=09     E      Y        Y       Y      Y      Y   Y   Y           B/O                                                            Dates need to change to reflect 2005/06
                                           which is not FE-, ACL- or WBL-funded, for first-time entrants on OR A16=10 OR A16=00) AND A27 =>
                                           aims for which Programme Entry Route is not collected                  1 August 2005 AND A27 <= 31 July
                                                                                                                  2006 AND
                                                                                                                  NON_LSC_FUNDED_STATUS IN
                                                                                                                  ALL_ANNUAL_VALUES table in LAD
                                                                                                                  = '2' (not valid for new starters)
New         A09_A10_A26_A27_LAD_1          For starts on or after 1 August 2005, if sector framework code is       if A27 >= 1 August 2005 AND            E               Y                     Y   Y   Y           B/O Checks that the learning aim is valid for the framework    The process for assigning sector framework codes has improved.
                                           entered, it must match the framework for that learning aim in the      FLAG11 in LEARNING_AIM Not = "Y"                                                                                                                                 This is a new rule which checks that the learning aim is valid for the
                                           LAD for funded NVQs, employer approved schemes and technical and (A10 = 40 or A10 = 41) AND A26                                                                                                                                         framework
                                           certificates                                                           NOT= 000 and there is no matching
                                                                                                                  record in
                                                                                                                  SECTOR_FRAMEWORK_AIMS with (
                                                                                                                  LEARNING_AIM_REF=A09 and
                                                                                                                  SECTOR_FRAMEWORK_CODE=A2
                                                                                                                  6)

New         A09_A10_A20_A27_LAD_6          Must be valid learning aim for this year for a new start for FE      IF A10=20 AND A27 => 1 August             E      Y                              Y   Y   Y           B/O                                                            New rule to allow learning aim the are not valid for new starts to be
                                           funded provision                                                     2005 AND A27 <= 31 July 2006 AND                                                                                                                                   used for re-sits
                                                                                                                A20 = 9 AND FE_STATUS_CODE IN
                                                                                                                FE_ANNUAL_VALUES table in LAD =
                                                                                                                '2' (not valid for new starters)

Change      A09_A10_A27_LAD_7              Must be valid learning aim for this year for a new start for ACL-    IF A10=10 AND A27 => 1 August            E       Y        Y      Y       Y      Y   Y   Y           B/O                                                            Dates need to change to reflect 2005/0^
                                           funded provision                                                     2005 AND A27 <= 31 July 2006 AND
                                                                                                                ACL_STATUS_CODE IN
                                                                                                                ACL_ANNUAL_VALUES table in LAD
                                                                                                                = '2' (not valid for new starters)




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                             Cross field validation                                                                                                                                 Page 17 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                   ILR validation rules 2005/06




                                                                                                                                                                                                 On-line
                                                                                                                                                                                                  data
                                                                                                                                                                                                 captur
                                                                                                                                                                                       ESF         e
From                                                                                                                                                             FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                           Rule Description                                                      Metadata                        E/W              Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule                                      Reason for change
Change      A09_A10_LAD_4                  Must exist on FE Annual Values table for year 2005/06 with valid      IF A10 =20 AND FE_STATUS_CODE    E                Y                         Y     Y      Y     Y     B/O                                                               Dates need to change to reflect 2005/06
                                           status (1 or 2) for FE-funded aims                                    IN FE_ ANNUAL_VALUES IN LAD
                                                                                                                 (for record with Academic_Year=
                                                                                                                 0506) NOT=('1' OR '2')

Change      A09_A10_LAD_5                  Must exist on ACL Annual Values table for year 2005/06 with valid IF A10 =10 AND                                  E                      Y      Y      Y   Y   Y           B/O                                                               Dates need to change to reflect 2005/06
                                           status (1 or 2) for ACL-funded aims                               ACL_STATUS_CODE IN
                                                                                                             ACL_ANNUAL_VALUES IN LAD (for
                                                                                                             record with Academic_Year= 0506)
                                                                                                             NOT=('1' OR '2')
Change      A09_A10_LAD_6                  Must exist on WBL Annual Values table for year 2005/06 with valid IF (A10 =40 OR A10=41 OR A10=42)                E              Y                     Y   Y   Y           B/O                                                               Dates need to change to reflect 2005/06.
                                           status (1 or 2) for WBL-funded aims                               AND WBL_STATUS_CODE IN
                                                                                                             WBL_ANNUAL_VALUES IN LAD (for
                                                                                                             record with Academic_Year= 0506)
                                                                                                             NOT=('1' OR '2')

Change      A09_A10_LAD_7                  Must exist on All Annual Values table for year 2005/06 with valid     IF A10=(30 or 70 or 80 or 99) AND           E     Y        Y       Y      Y      Y   Y   Y    Y      B/O                                                               Dates need to change to reflect 2005/06.
                                           status (1 or 2) for aims which are not FE-, WBL- or ACL-funded        NON_LSC_FUNDED_STATUS IN
                                                                                                                 ALL_ANNUAL_VALUES IN LAD (for
                                                                                                                 record with Academic_Year= 0506)
                                                                                                                 NOT=('1' OR '2')
            A09_A10_LAD_8                   If funding for a technical certificate is being claimed the learning If A10 = 41 AND                             E              Y                     Y   Y   Y    Y      B/O
                                           aim must be a technical certificate                                   TECHNICAL_CERTIFICATE in
                                                                                                                 WBL_ANNUAL_VALUES table in LAD
                                                                                                                 for learning aim reference in field A09
                                                                                                                 not = 1
            A09_A10_LAD_9                   If funding for a key skill is being claimed the learning aim must be If A10 = 42 AND KEY_SKILLS_ALL in           E              Y                     Y   Y   Y    Y      B/O
                                           a key skill                                                           ALL_ANNUAL_VALUES for learning
                                                                                                                 aim reference in field A09 not = (1 or 3)

            A09_A11a_L14_1                 For learners who are HEFCE funded or eligible for HEFCE funding IF A09 = (88888888 OR CMISC002)                   E     Y                              Y   Y               B/O
                                           and who are undergoing studies for students with learning          AND A11a = (001 OR 002) AND L14
                                           difficulties and disabilities (such as Life Skills) leading to no  NOT = 1
                                           recognised qualification aim, the learner must consider himself or
                                           herself to have a learning difficulty or health problem

            A09_A11b_L14_1                 For learners who are HEFCE funded or eligible for HEFCE funding IF A09 = (88888888 OR CMISC002)                   E     Y                              Y   Y               B/O
                                           and who are undergoing studies for students with learning          AND A11b = (001 OR 002) AND L14
                                           difficulties and disabilities (such as Life Skills) leading to no  NOT = 1
                                           recognised qualification aim, the learner must consider himself or
                                           herself to have a learning difficulty or health problem

            A09_A15_3                      When an E2E learning aim code of xe2e0001 is used, the          if a09=xe2e0001 and a15 not= 09                   E              Y                     Y   Y               B/O
                                           programme type must be E2E.
            A09_A15_LAD_1                  If a framework completion class code is used then the programme if FLAG11 in LEARNING_AIM on LAD                  E              Y                     y   y   y           B/O
                                           type must be Advanced Apprenticeship or Apprenticeship          ="Y" AND A15 not = 02 or 03

            A09_A16_A27_LAD_1              If LAD record has an Approval_End_Date, then learners should          IF APPROVAL_END_DATE NOT=                   W     Y        Y       Y      Y      Y   Y   Y           B/O This is a warning because apparently providers can
                                           not start after that date.                                            Null AND A16 = (09 or 10 or 00) AND                                                                      exceptionally be given permission to start aims after the
                                                                                                                 A27> APPROVAL_END_DATE                                                                                   approval end date.

Change      A09_A16_A27_LAD_2              If LAD record has an Aim_Discontinued_Date, then learners             IF AIM_DISCONTINUED_DATE                    W     Y        Y       Y      Y      Y   Y   Y           B/O This rule is based on the date from which an aim is         Error in rule corrected for 2005/06, it used 010 rather than 10 in
                                           should not start after that date.                                     NOT= Null AND A16 = (09 or 10 or 00)                                                                     discontinued (basd on info from awarding body, usually for 2004/05
                                                                                                                 AND A27>                                                                                                 non-DfES-approved provision). The idea is to give a
                                                                                                                 AIM_DISCONTINUED_DATE                                                                                    warning to providers that they should not be using the code
                                                                                                                                                                                                                          after this date.
            A09_A17_A32_H21_LAD_1          If the Aim is HE level and the Delivery Mode is (Continuous           IF                                          W     Y                              Y   Y   Y           B/O
                                           Delivery - Daytime or Sandwich) AND Guided Learning Hours             ENGLAND_FE_HE_STATUS_CODE
                                           >449 the Term-Time Accommodation field must be completed              = 'H' on LEARNING_AIM table in LAD
                                                                                                                 AND A17 = (1 OR 4) AND A32 > 449
                                                                                                                 AND H21 = 0
            A09_A18_LAD_1                  For NVQ delivery methods, the aim must be an NVQ in LAD               IF A18 = 11 OR 12 OR 13 AND                 E     Y                              Y   Y   Y           B/O
                                                                                                                 LEARNING_AIM_TYPE_CODE field in
                                                                                                                 LEARNING_AIM table in LAD is not
                                                                                                                 '0036' (NVQ)
            A09_A19_A32_H21_LAD_1          If the Aim is HE level and the Employer Role = Dedicated              IF                                          W     Y                              Y   Y   Y           B/O
                                           Employer Provision AND Guided Learning Hours >449 the Term-           ENGLAND_FE_HE_STATUS_CODE
                                           Time Accommodation field must be completed                            = 'H' on LEARNING_AIM table in LAD
                                                                                                                 AND A19 = 3 AND A32 > 449 AND
                                                                                                                 H21 = 0
            A09_A31_H31_LAD_1              If the Aim is HE level and the Actual End Date is completed then      IF                                          W     Y                              Y   Y   Y           B/O
                                           the Reason for Leaving must be completed                              ENGLAND_FE_HE_STATUS_CODE
                                                                                                                 = 'H' on LEARNING_AIM table in LAD
                                                                                                                 AND A31 NOT = 00000000 AND H31
                                                                                                                 = 00
            A09_A36_LAD_1                  If learning aim is not 'basic skills diagnostic assessment', the      IF BASIC_SKILLS_DIAG_TEST NOT               E     Y                              Y   Y   Y           B/O
                                           learning outcome grade cannot be one of the grades reserved for       = 'Y' in LEARNING_AIM table AND
                                           such aims                                                             A36 = LN OR L2 OR L1 OR E3 OR E2
                                                                                                                 OR E1
            A09_A40_A43_LAD_1              If the Sector Framework Achievement Date is entered, the              IF FLAG11 on LEARNING_AIM table             E              Y                     Y   Y   Y           B/O                                                               replaces A09_A40_A43_L26_LAD1
                                           Achievement Date must be entered except for framework                 in LAD not = "Y" AND A43 > 00000000
                                           completion class codes                                                AND A40 = 00000000




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                               Cross field validation                                                                                                                                   Page 18 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                ILR validation rules 2005/06




                                                                                                                                                                                              On-line
                                                                                                                                                                                               data
                                                                                                                                                                                              captur
                                                                                                                                                                                    ESF         e
From                                                                                                                                                          FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                           Rule Description                                                   Metadata                                  E/W    Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule                                    Reason for change
            A09_A40_LAD1                   Achievement date must be null for sector framework class codes     IF FLAG11 on LEARNING_AIM table            E            Y                   Y     Y      Y           B/O
                                                                                                              in LAD = "Y" AND A40 NOT =
                                                                                                              00000000
Change      A09_A46a_A46b_LAD_1            If the aim is delivered under the WBL basic skills project or the  IF (A46a = 27 or A46b = 27 or              E               Y                     Y   Y   Y    Y      B/O                                                             To ensure that only eligible basic skills learning aims are delivered
                                           National Employers Basic Skills project the learning aim must be a A46a=30 or A46b=30) AND                                                                                                                                              under the basic skills project.
                                           basic skill eligible for funding under these projects              SKILLS_FOR_LIFE_TYPE_CODE in
                                                                                                              ALL_ANNUAL_VALUES table in LAD
                                                                                                              for learning aim reference in field A09
                                                                                                              not = (1,2,3,5,6,7,8,9 or 10)

            A09_H17_LAD_1                  If the Aim is HE level, learner FTE should be completed              IF H17 = 000.0 AND                      W       Y                              Y   Y   Y           B/O
                                                                                                                ENGLAND_FE_HE_STAT_CODE =
                                                                                                                'H' on LEARNING_AIM table in LAD
            A09_N08_LAD_1                  Learning aim must not be temporary code for last return of year      IF N08 = 'F05' OR 'C03' AND              E      Y                Y             Y   Y   Y            B    Replaces A09_T06_LAD_1
                                                                                                                TEMPORARY_AIM_CODE in
                                                                                                                LEARNING_AIM table in LAD = 'Y'
Change      A10_A11a_A12a_1                If the learner is LSC FE funded and the source of funding is ESF     IF A10 = 20 AND A11a => 541 AND          E      Y                              Y   Y        Y      B/O                                                             Changes to cope with new ESF values for 2005 and removal of
                                           but is not LSC ESF co-financed, the implied rate of LSC FE           A11a <= 566 AND A12a = 000                                                                                                                                         codes before 2003
                                           funding for ESF which is not LSC ESF co-financed must not be
                                           zero
Change      A10_A11b_A12b_1                If the learner is LSC FE funded and the source of funding is ESF     IF A10 = 20 AND A11b => 541 AND          E      Y                              Y   Y        Y      B/O                                                             Changes to cope with new ESF values for 2005 and removal of
                                           but is not LSC ESF co-financed, the implied rate of LSC FE           A11b <= 566 AND A12b = 000                                                                                                                                         codes before 2003
                                           funding for ESF which is not LSC ESF co-financed must not be
                                           zero
            A10_A12a_1                     If the implied rate of LSC FE funding for ESF which is not LSC       IF A12a NOT = 000 AND A10 NOT =          E      Y                              Y   Y               B/O
                                           ESF co-financed is non-zero, the aim must be LSC FE funded           20

            A10_A12b_1                     If the implied rate of LSC FE funding for ESF which is not LSC       IF A12b NOT = 000 AND A10 NOT =          E      Y                              Y   Y               B/O
                                           ESF co-financed is non-zero, the aim must be LSC FE funded           20

            A10_A14_1                      If the reason for partial or non-payment of tuition fees is 'fees    IF A14 = 01 AND A10 NOT = 20             E      Y                              Y   Y               B/O
                                           waived - 16-18 year old learner; provision funded by the LSC', the
                                           LSC funding stream must be FE
            A10_A15_A16_1                  For WBL funded main aims, If the Programme Entry Route is            IF A10=40 AND A16 = 03 AND A15           E               Y                     Y   Y               B/O Introduction of new entry routes necessitates additional
                                           'Resume from Advanced Apprenticeship after Apprenticeship' the       NOT = 02                                                                                               validation
                                           Programme Type must be 'Advanced Apprenticeship'
            A10_A15_A16_2                  For WBL funded main aims, If the Programme Entry Route is            IF A10=40 AND A16 = 04 AND A15           E               Y                     Y   Y               B/O Introduction of new entry routes necessitates additional
                                           'Resume NVQ3 after NVQ2' the Programme Type must be 'NVQ3'           NOT = 06                                                                                               validation

New         A15_A16_3                      If the programme type is Apprenticeship or Advanced                  IF A15 = (02 or 03) AND A16 = 10         E               Y                     Y   Y               B/O To check that the programme entry route is consitent with
                                           Apprenticeship the programme entry route must not be first time                                                                                                             the programme type
                                           entrant on other WBL programme
New         A15_A16_4                      If the programme type is not Apprenticeship or Advanced              IF A15 not = (02 or 03) AND A16 = 09     E               Y                     Y   Y               B/O To check that the programme entry route is consitent with
                                           Apprenticeship then the programme entry route must not be first                                                                                                             the programme type
                                           time entrant on Apprenticeship or Advanced Apprenticship

            A10_A15_A26_1                  For WBL funded main aims, Sector code must be entered if the         IF A10=40 aND (A15 = 02 OR 03)           E               Y                     Y   Y               B/O Reflects downgrade for Maximise PMR change
                                           programme type = Apprenticeship or Advanced Apprenticeship           AND A26 = 000


            A10_A15_A27_1                  An main aim funded as part of a WBL programme must not have          IF A10 = 40 AND A15 = 99 AND A27         E               Y                     Y   Y               B/O                                                             to bring into line with WBL actuals system
                                           a programme type of 'none of the above' for stats after 31 July      > 31/07/2004
                                           2004
            A10_A15_A27_2                  A technical certificate or key skill funded as part of a framework   IF (A10 = 41 or A10 =42) AND (A15        E               Y                     Y   Y               B/O                                                             to bring into line with WBL actuals system
                                           must have a programme type of Apprenticeship or Advanced             not = 02 or A15 not =03) AND A27 >
                                           Apprenticeship for starts after 31 July 2004                         31/07/2004
            A10_A15_A27_AD01_1             for WBL funded NVQ1 main aims starting after 31 July 2003 the        if A10=40 AND A15=4 and                  E               Y                     Y   Y               B/O
                                           learner must not be 16-18 years old at start                         A27>31072003 and AD01=1
            A10_A15_A35_A37_1              For partial achievement there should be an entry in units            IF (A15 not = 09 AND A35 = 2 AND        W                Y                     Y   Y               B/O
                                           completed for all aims except for E2E main aims                      A37 = 0) OR (a15 = 09 AND A10 NOT
                                                                                                                = 40 AND A35 = 2 AND A37 = 0)

            A10_A15_A35_A38_1              For partial achievement there should be an entry in the number of    IF (A15 not = 09 AND A35 = 2 AND        W                Y                     Y   Y               B/O
                                           units to achieve the full qualifcation except for E2E main aims      A38 = 0) OR (a15 = 09 AND A10 NOT
                                                                                                                = 40 AND A35 = 2 AND A38 = 0)

            A10_A15_A37_1                  Number of units must not be entered for WBL funded E2E main          IF A10 = 40 AND A15 = 09 AND A37         E               Y                     Y   Y               B/O
                                           aims.                                                                NOT = 00
            A10_A15_A38_1                  Number of units to achieve full qualification must not be entered    IF A10 = 40 AND A15 = 09 AND A38         E               Y                     Y   Y               B/O
                                           for WBL funded E2E main aims.                                        NOT = 00
            A10_A15_A43_1                  Sector Framework Achievement Date must only be entered for the       IF A10 NOT = 40 AND A43 NOT =            E               Y                     Y   Y               B/O                                                             Rule to prevent sector framework achievement being recorded on
                                           main aim for programme types Advanced Apprenticeship and             00000000 AND A15 NOT = (02 OR                                                                                                                                      subsiduary aims
                                           Apprenticeship                                                       03)
            A10_A15_A53_1                  Additional learning needs data must be entered for aims that are     IF A53 = NULL AND (A10 = 40 or A10       E               Y                     Y   Y               B/O                                                             To ensure that ALN/ASN is available for all aims except E2E
                                           WBL funded aims unless they are entry to employment.                 = 41 or A10 = 42) AND a15 Not = 09

            A10_A16_1                      Programme entry route must be entered for WBL funded main         IF A10 = 40 and A16 = null                  E               Y                     Y   Y               B/O
                                           aims.
            A10_A16_A27_1                  Programme entry route must be entered for subsiduary aims         If A10 = 41 or A10 = 42 AND A16 = 00        E               Y                     Y   Y               B/O
                                           funded as part of a framework for start after 31 July 2004.       AND A27 > 31/07/2004
            A10_A24_1                      Occupation relating to learning aim must not be entered for ACL   IF A10 = 10 AND A24 NOT = 0000              E                       Y             Y   Y               B/O
                                           funded aims.
            A10_A27_1                                                                                        If A10
                                           Start date must be on or before today's date for WBL funded main aims = 40 AND A27 > Todays date              E               Y                     Y   Y                O




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                            Cross field validation                                                                                                                                  Page 19 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                    ILR validation rules 2005/06




                                                                                                                                                                                                  On-line
                                                                                                                                                                                                   data
                                                                                                                                                                                                  captur
                                                                                                                                                                                        ESF         e
From                                                                                                                                                              FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                           Rule Description                                                         Metadata                                E/W    Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule                                      Reason for change
            A10_A27_L11_4                  Should be over school leaving age at start for WBL funded aims           IF A10 = (40 or 41 or 42) AND A27 -      W            Y                   Y     Y                  B/O                                                               Added funding stream 42 as key skills aims now generate WBL
                                                                                                                    L11 <16 years AND NOT(A27 - L11 =                                                                                                                                    funding
                                                                                                                    15 years AND 16th birthday > last
                                                                                                                    Friday in June in starting year AND <
                                                                                                                    1st September in starting year AND
                                                                                                                    A27 > last Friday in June AND A27 <
                                                                                                                    1st September)
            A10_A27_T08_1                  Start date must be on or before file creation date for WBL funded        If A10 = 40 and A27 > T08                E               Y                     Y   Y                B
                                           main aims
            A10_A31_A50_1                  If there is no learning actual end date then Reason Learning             IF (A10 = 40 or 41 or 42) AND A31 = 0    E               Y                     y   y               B/O                                                               Reason learning ended is now required for all subsiduary aims
                                           Ended must be continuing for WBL funded aims                             and A50 NOT = 96
            A10_A39_1                      Where the Eligibility for achievement funding is 'achievement            IF A39 = 1 OR 2 AND A10 NOT = 20         E      Y                              Y   Y               B/O
                                           funding claimed' or 'partial achievement funding claimed' the aim
                                           must be FE funded
            A10_A50_1                      Reason learning ended must be completed for all WBL funded               IF (A10 = 40 or A10 = 41 or A10 =42)     E               Y                     Y   Y               B/O                                                               Reason learning ended is now required for all subsiduary aims
                                           aims                                                                     AND A50 = 0
Change      A10_AD01_A16_1                 Must be under 25 year old at the start of programme for WBL              IF A10= (40 or 41 or 42) and AD01 =      E               Y                     Y   Y               B/O                                                               This rule allows learner to start aims aged over 25 provided they
                                           funded aims, unless the programme entry route is transfer from           '3' AND A16 NOT = (7 or 8 or 11)                                                                                                                                     were aged under 25 at the end of their programme. It allows learner
                                           another provider or LSC area or restart for funding purposes or                                                                                                                                                                               aged over 25 in continuous learning to restart the aim as a result of
                                           restart after a break in learning.                                                                                                                                                                                                            a transfer or restart.
            A10_E08_E11_E12_1              For ESF funded aims starting after 31/07/2004, if employment             IF A10 = 70 AND E08 > 31/07/2004         E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           status before starting is 'employed' or 'self employed', the             AND E12 = (01 or 03) AND E11 = (98
                                           industrial sector of learner's employer must not be 'no employer' or     or 99)
                                           'not known'.
            A10_E08_E11_E12_2              For ESF match aims starting after 31/07/2004, if employment              IF A10 not = 70 AND E08 >                E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           status before starting is 'employed' or 'self employed', the             31/07/2004 AND E12 = (01 or 03)
                                           industrial sector of learner's employer must not be 'no employer'        AND E11 = 99

            A10_E08_E12_1                  For ESF funded aims which start after 31/07/2004 the                     IF A10 = 70 AND E12 = 98 AND E08         E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           employment status on day before starting ESF project must not be         > 31/7/2004
                                           not known not provided
            A10_E08_E12_E13_1              For ESF funded aims starting after 31/07/2004, if employment             IF A10 = 70 AND E08 > 31/07/2004         E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           status before starting is 'employed' or 'self employed', the learner's   AND E12 = (01 or 03) AND E13 NOT
                                           employment status must be ;in secure employment' or 'threatened          = (01 or 02)
                                           with redundancy'.
            A10_E08_E12_E13_2              For ESF match aims starting after 31/07/2004, if employment              IF A10 not = 70 AND E08 >                E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           status before starting is 'self employed', the learner's employment      31/07/2004 AND E12 = 03 AND E13 =
                                           status must not be 'unemployed'                                          03
            A10_E08_E12_E14_1              For ESF funded aims starting after 31/07/2004, if employment             IF A10 =70 AND E08 > 31/07/2004          E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           status before starting is 'unemployed', then the Length of               AND E12 = 04 AND E14 = (98 or 99)
                                           unemployment before starting ESF project must not be 'not known
                                           / not provided' or 'not unemployed'.
            A10_E08_E12_E14_2              For ESF matched aims starting after 31/07/2004, if employment            IF A10 not = 70 AND E08 >                E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           status before starting is 'unemployed', then the Length of               31/07/2004 AND E12 = 04 AND E14 =
                                           unemployment before starting ESF project must not be 'not                99
                                           unemployed'.
            A10_E08_E12_E15_1              For ESF funded aims starting after 31/07/2004, if employment             IF A10 = 70 AND E08 > 31/07/2004         E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           status before starting is 'employed', then the Type and size of          AND E12 = 01 AND E15 NOT = (01 or
                                           learner's employer must be 'public sector organisation',                 02 or 03)
                                           'small/medium enterprise' or 'large organisation'.

            A10_E08_E12_E15_2              For ESF matched aims starting after 31/07/2004, if employment            IF A10 not=70 AND E08 > 31/07/2004       E      Y        Y              Y      Y   Y               B/O                                                               To improve quality of ESF data
                                           status before starting is 'employed', then the Type and size of          AND E12 = 01 AND E15 =99
                                           learner's employer must not be not employed.

            A10_E22_1                      If the funding stream is 70 then the project dossier number must         If A10 = 70 AND E22 = spaces             E      Y        Y              Y      Y   Y               B/O
                                           be entered
            A10_E23_1                      If the funding stream is 70 then the local project number must be        If A10 = 70 AND E23 = 000                E      Y        Y              Y      Y   Y               B/O                                                               To correct error in rule the field is numeric so should not contain
                                           entered                                                                                                                                                                                                                                       spaces. There is a new field level rule which E23_2 which enforces
                                                                                                                                                                                                                                                                                         a numeric value
            A10_L01_L25_WBL_1              For WBL aims there must be a funding relationship for this        if A10 = (40 or 41 or 42) and there is          E               Y                             Y           B/O                                                               Contract numbers are no longer used in the WBL funding system.
                                           Provider Number and LSC                                           no funding relationship between this                                                                                                                                        This rule replaces A02_A10_L01_L25_WBL_1
                                                                                                             provider and LLSC
            A10_L11_1                      FE funded learners should not be 14 or younger on 31st August of IF A10 = 20 AND L11 > 31081989                  W       Y                              Y   Y               B/O
                                           the current teaching year
            A10_L24_1                      The learner's country of domicile is not in the UK and Islands or IF A10 = 20 OR 40 or 41 or 42 AND              W       Y        Y                     Y   Y               B/O Need to add the following country of domicile codes to the The current rule description says the learner is not eligible for
                                           European union and WBL or FE funding is being claimed.            L24 NOT (on table of European Union                                                                           table of European Country codes. 199 Channel Islands,      funding which is not correct. Needs to include code 41
                                                                                                             Country Codes)                                                                                                639 Czech Republic, 638 Cyprus, 831 Estonia, 670
                                                                                                                                                                                                                           Hungary, 772 Latvia, 833 Lithuania, 700 Malta, 727 Poland,
                                                                                                                                                                                                                           850 Slovakia, 835 Slovenia, 999 Isle of Man.

            A11a _A11b_A17_H17_1           For learners who are HEFCE funded or eligible for HEFCE funding          IF H17 NOT = 000.0 AND ((A11a =          E      Y                              Y   Y               B/O
                                           and where the delivery mode is Absent for Year, the Learner FTE          001 OR 002) OR (A11b = 001 OR
                                           must be 0                                                                002)) AND A17 = 6
            A11a_A11b_1                    Source of Funding entries must be different unless value = 999           IF A11a NOT = 999 AND A11a = A11b        E      Y                              Y   Y               B/O

            A11a_A11b_2                    Cannot have a combination of HEFCE funding or eligibility for            IF A11a = (001 OR 002) AND A11b =        E      Y                              Y   Y               B/O
                                           HEFCE funding and Department of health/regional health                   (009 OR 025)
                                           authority/NHS/social care or teacher training agency funding
            A11a_A11b_3                    Cannot have a combination of HEFCE funding or eligibility for            IF A11b = (001 OR 002) AND A11a =        E      Y                              Y   Y               B/O
                                           HEFCE funding and Department of health/regional health                   (009 OR 025)
                                           authority/NHS/social care or teacher training agency funding




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                                Cross field validation                                                                                                                                   Page 20 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                  ILR validation rules 2005/06




                                                                                                                                                                                                On-line
                                                                                                                                                                                                 data
                                                                                                                                                                                                captur
                                                                                                                                                                                      ESF         e
From                                                                                                                                                            FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                           Rule Description                                                          Metadata                           E/W      Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule                                    Reason for change
            A11a_A11b_H17_1                The FTE must be entered if the aim is HEFCE funded or eligible            IF H17 = 000.0 AND ((A11a = 001 OR W         Y                         Y     Y                  B/O
                                           for HEFCE funding                                                         002) OR (A11b = 001 OR 002))
            A11a_A12a_1                    If the source of funding is not 'ESF but not LSC ESF co-financed',        IF A12a NOT = 000 AND A11a < 541    E        Y                              Y   Y               B/O                                                             Change to reflect the new ESF codes for 2005 and the removal of
                                           the implied rate of LSC FE funding for ESF which is not LSC ESF           OR > 566                                                                                                                                                        the codes for 2003.
                                           co-financed must be zero
            A11a_A17_A32_H21_1             For learners who are HEFCE funded or eligible for HEFCE funding           IF A11a = (001 OR 002) AND A17 = (1    W     Y                              Y   Y               B/O
                                           and where the delivery mode is continuous delivery daytime or             OR 4) AND A32 > 00449 AND H21 =
                                           sandwich and where the guided learning hours are more than                0
                                           449, the term time accommodation field must be completed

            A11a_A19_A32_H21_1             For learners who are HEFCE funded or eligible for HEFCE funding IF A11a = (001 OR 002) AND A19 = 3)              W     Y                              Y   Y               B/O
                                           and where the employer role is learner is attending dedicated   AND A32 > 00449 AND H21 = 0
                                           employer provision and where the guided learning hours are more
                                           than 449, the term time accommodation field must be completed

            A11a_A31_H31_1                 For learners who are HEFCE funded or eligible for HEFCE funding           IF A11a = (001 OR 002) AND A31         W     Y                              Y   Y               B/O
                                           and where the learning actual end date is completed, the reason           NOT = 00000000 AND H31 = 00
                                           for leaving should be completed
            A11a_H27_N08_1                 For the last 2 FE returns of the year, for learners who are HEFCE         IF N08 = ('F04' OR 'F05') AND A11a =   W     Y                              Y   Y                B    Replaces A11a_H27_T06_1
                                           funded or eligible for HEFCE funding the A/AS level score should          (001 OR 002) AND H27 = 00
                                           be non-zero
            A11a_L11_1                     HEFCE funded learners or learners eligible for HEFCE funding              IF A11a = 001 OR 002 AND L11           W     Y                              Y   Y               B/O                                                             Change to year
                                           should not be 16 or younger on 31st July of the current teaching          >31071988
                                           year
            A11b_A12b_1                    If the source of funding is not 'ESF but not LSC ESF co-financed',        IF A12b NOT = 000 AND A11b < 541       E     Y                              Y   Y               B/O                                                             Change to reflect the new ESF codes for 2005 and the removal of
                                           the implied rate of LSC FE funding for ESF which is not LSC ESF           OR > 566                                                                                                                                                        the codes for 2003.
                                           co-financed must be zero
            A11b_A17_A32_H21_1             For learners who are HEFCE funded or eligible for HEFCE funding           IF A11b = (001 OR 002) AND A17 =       W     Y                              Y   Y               B/O
                                           and where the delivery mode is continuous delivery daytime or             (1 OR 4) AND A32 > 00449 AND H21
                                           sandwich and where the guided learning hours are more than                =0
                                           449, the term time accommodation field should be completed

            A11b_A19_A32_H21_1             For learners who are HEFCE funded or eligible for HEFCE funding IF A11b = (001 OR 002) AND A19 =                 W     Y                              Y   Y               B/O
                                           and where the employer role is learner is attending dedicated   3) AND A32 > 00449 AND H21 = 0
                                           employer provision and where the guided learning hours are more
                                           than 449, the term time accommodation field should be completed

            A11b_A31_H31_1                 For learners who are HEFCE funded or eligible for HEFCE funding           IF A11b = (001 OR 002) AND A31         W     Y                              Y   Y               B/O
                                           and where the learning actual end date is completed, the reason           NOT = 00000000 AND H31 = 00
                                           for leaving should be completed
            A11b_H27_N08_1                 For the last 2 FE returns of the year, for learners who are HEFCE         IF N08 = ('F04' OR 'F05') AND A11b =   W     Y                              Y   Y                B    Replaces A11b_H27_T06_1
                                           funded or eligible for HEFCE funding the A/AS level score should          (001 OR 002) AND H27 = 00
                                           be non-zero
            A11b_L11_1                     HEFCE funded learners or learners eligible for HEFCE funding              IF A11b = 001 OR 002 AND L11           W     Y                              Y   Y               B/O                                                             Date updated to reflect 2004/05 year
                                           should not be 16 or younger on 31st July of the current teaching          >31071987
                                           year
            A13_A14_1                      Reason for partial or full non-payment of tuition fees must not be        IF A14 = 99 AND A13 = 00000            E     Y                Y             Y   Y               B/O
                                           ‘Fees paid in full’ if Tuition fee received for year is 0.
            A13_A14_2                      If the reason for partial or full non-payment of tuition fees is fee is   IF A14 = 19 AND A13 NOT = 00000        E     Y                Y             Y   Y               B/O
                                           zero, Tuition fee received for year must be 0.
            A14_H20_1                      Reason for partial or full non-payment of tuition fees must not be        IF A14 = 99 AND H20 = 98               E     Y                              Y   Y               B/O
                                           'fees paid in full' if the major source of tuition fees is 'no fees'

            A14_L11_1                      Reason for partial or full non-payment of tuition fees must not be        IF L11 < 01081939 AND A14 = 15         E     Y                              Y   Y               B/O Learners of pensionable age cannot claim job seeker's       Date updated to reflect 2004/05 year
                                           Job seeker’s allowance if the learner is 65 or over at the 1st of                                                                                                             allowance
                                           August of the training year.
            A14_L11_2                      Reason for partial or full non-payment of tuition fees must not be        IF L11 < 01081981 AND A14 = 01         E     Y                              Y   Y               B/O Providers cannot charge fees to 16-18 year olds and this is Date updated to reflect 2004/05 year
                                           ‘fees waived - 16-18 year old learner; provision funded by the                                                                                                                the absolute limit of age of learners with 16-18 eligibility
                                           LSC’, if the learner is 23 or over at the 1st August of the training
                                           year.
            A15_A26_2                      Sector code must not be entered if the programme type not =               IF A15 NOT =(02 OR 03) AND A26         E              Y                     Y   Y               B/O
                                           Apprenticeship and Advanced Apprenticeship                                NOT = 000
            A15_A26_A27_1                  Sector code must be entered for subsiduary aims if the                    IF (A15 = 02 OR 03) AND A26 = 000      E              Y                     Y   Y               B/O                                                             The sector code must now be entered on all aims which form part of
                                           programme type is Apprenticeship or Advanced Apprenticeship for           AND A27 > 31/07/2004                                                                                                                                            a framework from 1 August 2004
                                           starts after 31 July 2004
            A15_A27_A53_1                  Learners without additional needs who started after on or after           IF A53 = 97 AND A15 = 04 AND A27       E              Y                     Y   Y               B/O
                                           26/03/2001 are not eligible for NVQ1 learning                             =>26032001
            A15_A43_1                      Sector Framework Achievement Date must only be entered for                IF A43 NOT = 00000000 AND A15          E              Y                     Y   Y               B/O
                                           programme types Advanced Apprenticeship and Apprenticeship                NOT = (02 OR 03)

Change      A15_A50_1                      To progress from E2E you must be in E2E                                   F A50 = 20 OR 21 OR 22 23 OR 24        E              Y                     Y   Y               B/O                                                             Removal of code 22 and addition of codes 23 and 24 in this field
                                                                                                                     AND A15 NOT = 09
            A15_A53_1                      If programme type is not Advanced Apprenticeship,                         IF A15 NOT = (02 OR 03 OR 04 OR        E              Y                     Y   Y               B/O
                                           Apprenticeship or NVQ learning, Additional learning needs data            05 OR 06 OR 07) AND A53 NOT = 0
                                           must not be entered.
            A16_AD02                       the programme entry type must be not be direct for programmes             IF A16 = 01 and AD02 > 01/08/2003      E              Y                     Y   Y               B/O                                                             To allow a programme entry route of 01 to be used on subsiduary
                                           starting after 1 August 2003                                                                                                                                                                                                              aims which started after 31/07/2003
            A17_A32_1                      If the Delivery Mode is 'Absent for the year', the Guided Learning        IF A17 = 6 AND A32 NOT = 0             E     Y                              Y   Y        Y      B/O
                                           Hours must be zero
            A17_A18_A32_1                  The guided learning hours should not be zero unless the Delivery          IF (A17 NOT = 6) AND (A18 not =03      W     Y                              Y   Y               B/O                                                             To allow zero guided learning hours for distance and E-learning.
                                           Mode is 'absent for the year' or the main delivery method is              AND A18 not = 05) AND A32 = 0                                                                                                                                   Replaces rule A17_A32_2
                                           'distance learning' or 'E-Learning'.




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                              Cross field validation                                                                                                                                Page 21 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                    ILR validation rules 2005/06




                                                                                                                                                                                                  On-line
                                                                                                                                                                                                   data
                                                                                                                                                                                                  captur
                                                                                                                                                                                        ESF         e
From                                                                                                                                                              FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                           Rule Description                                                          Metadata                               E/W    Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule          Reason for change
            A18_A52_1                      The main delivery method must be distance learning or e-learning          IF A52 > 00000 AND A18 NOT = 03         E      Y                         Y     Y            Y     B/O
                                           or NVQ delivered at the workplace if the distance learning funding        OR 05 OR 12 OR 13
                                           is non zero.
            A19_L28a_1                     Employer Role should be ‘none of the above’, if Eligibility for           IF A19 NOT = 9 AND L28a = (12 OR       W       Y                              Y   Y               B/O
                                           enhanced funding, is set to ‘16-18 funding entitlement and                13)
                                           programme includes key skills’ or ‘16-18 funding entitlement and
                                           the learner's learning difficulties and/or disabilities are such that
                                           the QCA key skills qualification is inappropriate'
            A19_L28b_1                     Employer Role should be ‘none of the above’, if Eligibility for           IF A19 NOT = 9 AND L28b = (12 OR       W       Y                              Y   Y               B/O
                                           enhanced funding, is set to ‘16-18 funding entitlement and                13)
                                           programme includes key skills’ or ‘16-18 funding entitlement and
                                           the learner's learning difficulties and/or disabilities are such that
                                           the QCA key skills qualification is inappropriate'
            A21_A22_1                      The franchise and partnership delivery provider number must               IF A21 = 99 AND A22 NOT = spaces        E      Y                              Y   Y               B/O
                                           should be blank if the franchised out and partnership
                                           arrangements indicate that the provision is not franchised out or
                                           delivered by a partner
            A21_A22_2                      The franchise and partnership delivery provider number must               IF A21 NOT = 99 AND A22 = spaces        E      Y                              Y   Y               B/O
                                           should be present if the franchised out and partnership
                                           arrangements indicate that the provision is franchised out or
                                           delivered by a partner
            A27_A28_1                      Planned end date must be on or after start date                           IF A28 < A27                            E      Y        Y       Y      Y      Y   Y        Y      B/O Make rule apply on-line as well
            A27_A28_2                      Planned end date must be less than 20 years after the start date          IF A28 - A27 => 20years                 E      Y        Y       Y      Y      Y   Y        Y      B/O Make rule apply on-line as well

            A27_A28_A32_1                  If the GLH is greater than 60, then the value divided by the              IF A32 > 60 AND A32/(A28-A27+1)         E      Y        Y       Y             Y   Y               B/O                                   To allow GLH to be enter for WBL basic skills pilots
                                           number of days of study must not be greater than 24.                      NOT <=24
            A27_A28_A32_2                  Warning message will be output if the GLH is greater than 60, and         IF A32 > 60 AND the integer part       W       Y        Y       Y             Y   Y               B/O                                   To allow GLH to be enter for WBL basic skills pilots
                                           value divided by weeks of study is greater than 35.                       of(A32/(A28-A27+1)/7) NOT <=35
            A27_A28_A32_3                  Warning message will be output, if the GLH divided by the number          IF A32/(A28-A27+1) > 9 AND             W       Y        Y       Y             Y   Y               B/O                                   To allow GLH to be enter for WBL basic skills pilots
                                           of days of study is greater than 9 and less than 24.                      A32/(A28-A27+1) < 24
            A27_A28_H18_1                  The current year of Programme should not be greater than the              IF H18 NOT = 99 AND H18 > (((A28-      W       Y                              Y   Y               B/O
                                           planned duration of the aim                                               A27(in days) + 1)/365) rounded up to
                                                                                                                     next highest whole number)
            A27_A31_1                      If present, the learning actual end date to be on or after start date     IF A31 NOT = 00000000 AND A31 <         E      Y        Y       Y      Y      Y   Y        Y      B/O
                                                                                                                     A27
            A27_A40_1                      NVQ achievement date must be greater than or equal to the start           IF A40 NOT NULL AND A40 NOT >           E               Y                     Y   Y               B/O
                                           date if entered                                                           A27
            A27_A43_1                      Sector Framework achievement date must be greater than or                 IF A43 NOT NULL AND A43 NOT >           E               Y                     Y   Y               B/O
                                           equal to the start date if entered                                        A27
            A27_E08_1                      The ESF start date must not be before the learning start date on          IF E08 < A27                            E      Y        Y              Y      Y   Y               B/O
                                           the aim to which the ESF record is attached
            A27_L11_1                      Start date must be after date of birth                                    IF L11 > A27                            E      Y        Y       Y      Y      Y   Y               B/O
            A27_L11_2                      Must be more than 12 years old at start for non WBL funded                IF A27 - L11 < 12 years AND A10         E               Y              Y      Y   Y               B/O                                   Codes 41 and 42 are also WBL funded aims
                                           learning aims                                                             NOT = (40 or 41 or 42)
            A27_L11_3                      Should be less than 100 years old at start                                IF A27 - L11 > 100 years               W       Y        Y       Y      Y      Y   Y               B/O
            A27_L11_6                      Should be more than 4 years old at start                                  IF A27 - L11 < 4 years                 W       Y                              Y   Y               B/O
            A31_A34_1                      Completion status must not be ‘the learner is continuing or               IF A34 = 1 AND A31 NOT = NULL          E       Y        Y       Y      Y      Y   Y        Y      B/O
                                           intending to continue the learning activities leading to the learning
                                           aim’ if the Learning actual end date is completed.
            A31_A34_2                      Completion status must be ‘the learner is continuing or intending         IF A34 NOT = 1 AND A31 = NULL           E      Y        Y       Y      Y      Y   Y        Y      B/O
                                           to continue the learning activities leading to the learning aim’ if the
                                           Learning actual end date is not completed.

            A31_A40_1                      If the achievement date is entered the actual end date must be            IF A40 NOT = NULL AND A31 =             E               Y                     Y   Y               B/O                                   The achievement date now relates to the learing aim on all aims
                                           entered                                                                   NULL                                                                                                                                    except sector framework class code (which will not allow an
                                                                                                                                                                                                                                                             acheivement date). This rule replaces A10_A15_A31_A40_2

New         A31_A40_2                      The achievement date if entered must be on or after the actual end IF A40 Not = NULL AND A40 < A31                E               Y                     Y   Y               B/O
                                           date
            A31_A50_2                      If there is a learning actual end date then the learner must not be IF A50 = 96 and A31 NOT=0                     E               Y                     y   y               B/O
                                           continuing
            A31_E10_1                      If present, the Actual End Date on the aim should not be before       IF A31 NOT = NULL AND E10 NOT =            W       Y        Y              Y      Y   Y               B/O
                                           the ESF end date                                                      NULL AND E10 > A31
            A31_E10_2                      If the learning actual end date is entered, then the date ended ESF IF A31 NOT = NULL AND E10 = NULL              E      Y        Y              Y      Y   Y               B/O                                   To improve quality of ESF data
                                           co-financing must be entered.
            A31_L39_1                                                                                            IF be = null AND
                                           If the learning actual end date is not entered, then the destination must A31continuing L39 not = 95              E               Y              Y      Y   Y               B/O                                   To enforce a destination of continuing if the actual end date is not
                                                                                                                                                                                                                                                             completed
            A31_T08_1                      Must be on or before file creation date if entered                        IF A31 NOT = 00000000 AND A31 >         E               Y              Y      Y   Y                B
                                                                                                                     T08
            A34_A35_1                      If the Learning outcome is ‘study continuing’, the Completion             IF A34 NOT = 1 AND A35 = 9              E      Y                Y             Y   Y               B/O
                                           Status must be set to ‘the learner is continuing or intending to
                                           continue the learning activities leading to the learning aim’,
            A34_A35_2                      If the Completion Status is ‘the learner is continuing or intending to IF A35 NOT = 9 AND A34 = 1                 E      Y                Y             Y   Y               B/O
                                           continue the learning activities leading to the learning aim’, the
                                           Learning outcome must be set to is ‘study continuing’.

            A34_A39_1                      Where the Eligibility for achiement funding is set to 'achievement        IF A39 = 1 OR 2 AND A34 = 1             E      Y                              Y   Y        Y      B/O
                                           funding claimed' or 'partial achievement funding claimed' the
                                           Completion status must not be 'the learner is continuing or
                                           intending to continue the learning activities leading to the learning
                                           aim'
            A35_A36_1                      Learning outcome must not be ‘achieved’ if Learning outcome               IF A35 = 1 AND A36 = 'FL' OR 'U ' OR    E      Y                              Y   Y               B/O
                                           grade is 'FL', 'U ', N ', 'X ' or 'Y '                                    'N ' OR 'X ' OR 'Y '




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                                Cross field validation                                                                                                        Page 22 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                   ILR validation rules 2005/06




                                                                                                                                                                                                 On-line
                                                                                                                                                                                                  data
                                                                                                                                                                                                 captur
                                                                                                                                                                                       ESF         e
From                                                                                                                                                             FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                           Rule Description                                                       Metadata                                 E/W    Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule                                  Reason for change
            A35_A36_2                      Learning Outcome Grade must be set to 'FL','U ', 'N ', 'X ', 'Y ' or ' IF A35 = 3 AND A36 NOT = ('FL' OR         E      Y                          Y    Y                  B/O
                                           ' if Learning outcome is set to ‘no achievement’                       'U ' OR 'N ' OR 'X ' OR 'Y ' OR ' ')

            A35_A36_3                      Learning outcome grade must not be entered if learning outcome            IF A35 = 4 OR 5 OR 9 AND A36 NOT       E      Y                              Y   Y               B/O
                                           is ‘exam taken but result not known’, ‘learning activities are            = spaces
                                           complete but the exam has not yet been taken and there is an
                                           intention to take the exam’, or ‘study continuing’

            A35_A37_1                      For partial achievement there must be an entry in units completed IF A35 = 2 AND A37 = 0                         E      Y                              Y   Y        Y      B/O

            A35_A38_1                      If the Learning Outcome is 'partial achievement' the number of            IF A35 = 2 AND A38 = 0                 E      Y                              Y   Y               B/O
                                           units to achieve full qualification must be greater than zero
            A35_A39_1                      Where the Eligibility for achiement funding is set to 'partial            IF A39 = 2 AND A35 NOT = 2             E      Y                              Y   Y        Y      B/O
                                           achievement funding claimed' the Learning outcome must be
                                           'partial achievement'
            A35_A40_1                      If the Achievement Date is entered then the Learning Outcome              IF A40 NOT = 00000000 AND A35          E               Y                     Y   Y               B/O                                                           The achievement date now relates to the learing aim on all aims
                                           must be 'achieved'                                                        NOT = 1                                                                                                                                                        except sector framework class code (which will not allow an
                                                                                                                                                                                                                                                                                    acheivement date). This rule replaces A10_A15_A35_A40_2

            A35_A40_LAD_1                  If the Learning Outcome is 'achieved' then the Achievement Date           IF FLAG11 on LEARNING_AIM table        E               Y                     Y   Y               B/O                                                           The achievement date now relates to the learing aim on all aims
                                           must be entered for all learning aims except for sector framework         in LAD not = "Y" AND A35 = 1 AND                                                                                                                               except sector framework class code. This rule replaces
                                           class codes                                                               A40 = 00000000                                                                                                                                                 A10_A15_A35_A40_3
            A35_A43_LAD_1                  If the learning outcome is 'achieved' then the Sector framework           IF FLAG11 on LEARNING_AIM table        E               Y                     Y   Y               B/O                                                           The outcome on sector framework class codes relate to a
                                           acheivement date must be entered for sector framework class               in LAD = "Y" AND A35 = 1 AND A43 =                                                                                                                             framework not a learning aim.
                                           codes                                                                     00000000
            A35_A43_LAD_2                  If the Sector framework Achievement Date is entered then the              IF FLAG11 on LEARNING_AIM table        E               Y                     Y   Y               B/O                                                           The outcome on sector framework class codes relate to a
                                           Learning Outcome must be 'achieved' for sector framework class            in LAD = "Y" AND A43 NOT =                                                                                                                                     framework not a learning aim.
                                           codes                                                                     00000000 AND A35 NOT = 1
            A40_T08_1                      Achievement date must be on or before the file creation date              IF A40 > T08                           E               Y                     Y   Y                B
            A46a_A46b_1                    National Learning Aim Monitoring values must be different unless          IF A46a NOT = 99 AND A46a = A46b       E      Y        Y       Y             Y   Y               B/O
                                           they are both 99
            A46a_A46b_A32_1                If the learning aims is delivered under a WBL basic skills pilot the      IF (A46a = 27 or A46b = 27) AND A32    E               Y                     Y   Y               B/O                                                           To allow GLH to be enter for WBL basic skills pilots
                                           the guided learning hours must not be 00000                               = 00000
            A46a_A46B_A32_2                If the learning aim is not delivered under a WBL basic skills pilot       IF A46a NOT = 27 and A46b NOT =        E               Y                     Y   Y               B/O                                                           To prevent GLH being entered for WBL aims which are not part of a
                                           then the guided learning hours must be zero                               27 AND A32 <> 00000                                                                                                                                            WBL basic skills pilot
            AD02_A16_A26_LAD_1             If sector framework code is entered, and if that framework has a          IF A26 NOT=000 AND                     E               Y                     Y   Y   Y           B/O Many sector codes are no longer valid for new framework   The start date of the programme (see dervived variable AD02)
                                           non-null 'EFFECTIVE_TO' date, then learner must not start the             EFFECTIVE_TO (from                                                                                   programmes                                                cannot be after the effective _to date although the start date of an
                                           programme after that date if the Programme Entry Route is 'First-         SECTOR_FRAMEWORKS table)                                                                                                                                       individual aim (a27) may be. This rule is replaces
                                           Time Entrant' and programme start date is after 31/07/2004                NOT=Null AND (A16=09 or A16=10)                                                                                                                                A16_A26_A27_Lad_1
                                                                                                                     AND AD02>EFFECTIVE_TO (from
                                                                                                                     SECTOR_FRAMEWORKS table) and
                                                                                                                     AD02>31/07/2004
            E08_E09_1                      Planned end date must be on or after start date                           IF E09 < E08                           E      Y        Y              Y      Y   Y               B/O
            E08_E10_1                      Actual end date must be on or after start date                            IF E10 < E08                           E      Y        Y              Y      Y   Y               B/O
            E11_E12_1                      If employment status before starting is 'full time education',            IF E12 = (02 or 04 or 05) AND E11      E      Y        Y              Y      Y   Y               B/O                                                           To improve quality of ESF data
                                           'unemployed' or 'still at school',then the industrial sector of           NOT = 99
                                           learner's employer must be 'no employer'.
            E12_E13_2                      If Employment Status on day before start is unemployed learner's          IF E12 = 04 AND E13 NOT = 03           E      Y        Y              Y      Y   Y               B/O
                                           employment status must be unemployed
            E12_E13_4                      If Employment Status on day before start is employed, learner's           IF E12= 01 AND E13 = 03                E      Y        Y              Y      Y   Y               B/O
                                           employment status cannot be unemployed
            E12_E13_5                      If employment status before starting is 'full time education' or 'still   IF E12 = (02 or 05) AND E13 NOT =      E      Y        Y              Y      Y   Y               B/O                                                           To improve quality of ESF data
                                           at school', then the learner's employment status must be 'not             98
                                           known / not provided'.
            E12_E14_2                      Length of Unemployment must be Not Unemployed or Not                      IF E12 NOT = 04 AND (E14 NOT = 99      E      Y        Y              Y      Y   Y               B/O
                                           Known/not provided if Employment Status at start is not                   Or E14 Not =98)
                                           Unemployed
            E12_E14_3                      Length of Unemployment must not be Not Unemployed if                      IF E12 = 04 AND E14 = 99               E      Y        Y              Y      Y   Y               B/O
                                           Employment Status at start is Unemployed.
            E12_E14_4                      If employment status before starting is 'employed','full time             IF E12 = (01 or 02 or 03 or 05) AND    E      Y        Y              Y      Y   Y               B/O                                                           To improve quality of ESF data
                                           education','self employed' or 'still at school, then the Length of        E14 NOT = 99
                                           unemployment before starting ESF project must be 'not
                                           unemployed'.
            E12_E15_1                      If employment status before starting is 'self employed', then the         IF E12 = 03 AND E15 NOT = 02           E      Y        Y              Y      Y   Y               B/O                                                           To improve quality of ESF data
                                           Type and size of learner's employer must be 'small/medium
                                           enterprise'.
            E12_E15_2                      If employment status before starting is 'full time education',            IF E12 = (02 or 04 or 05) AND E15      E      Y        Y              Y      Y   Y               B/O                                                           To improve quality of ESF data
                                           unemployed' or 'still at school', then the Type and size of learner's     NOT = 99
                                           employer must be 'not employed'.
            E16abcde_1                     Addressing Gender Stereotyping entries must all be different if           IF E16a = (E16b OR E16c OR E16d        E      Y        Y              Y      Y   Y               B/O                                                           E16 now on ESF short record
                                           entered                                                                   OR E16e) OR E16b = (E16c OR E16d
                                                                                                                     OR E16e) OR E16c = (E16d or E16e)
                                                                                                                     OR E16d = E16e
            E18abcd_1                      Delivery Mode entries must all be different if entered                    IF E18a = (E18b OR E18c OR E18d)       E      Y        Y              Y      Y   Y               B/O                                                           E18 now on ESF short record
                                                                                                                     OR E18b = (E18c OR E18d) OR E18c
                                                                                                                     = 18d
            E19abcde_1                     Support measures to be accessed by the learner entries must all           IF E19a = (E19b OR E19c OR E19d        E      Y        Y              Y      Y   Y               B/O                                                           E19 now on ESF short record
                                           be different if entered                                                   OR E19e) OR E19b = (E19c OR E19d
                                                                                                                     OR E19e) OR E19c = (E19d or E19e)
                                                                                                                     OR E19d = E19e
            E20abc_1                       Learner background must all be different if entered                       IF E20a = (E20b OR E20c) OR E20b       E      Y        Y              Y      Y   Y               B/O
                                                                                                                     = E20c




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                               Cross field validation                                                                                                                               Page 23 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                                     ILR validation rules 2005/06




                                                                                                                                                                                                   On-line
                                                                                                                                                                                                    data
                                                                                                                                                                                                   captur
                                                                                                                                                                                         ESF         e
From                                                                                                                                                               FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                           Rule Description                                                  Metadata                          E/W                  Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule                                        Reason for change
            H11_H12_1                      A new entrant to HE should not already hold an HE level           IF H12 = 1 AND H11 = (01 OR 02 OR W                     Y                         Y     Y                  B/O
                                           qualification                                                     03 OR 04 OR 05 OR 10 OR 11 OR 15
                                                                                                             OR 16 OR 21 OR 22 OR 23 OR 24
                                                                                                             OR 25 OR 27 OR 28)
            H20_L24_1                      Major Source of Tuition Fees should be consistent with Country of IF H20 = 02 OR 04 AND L24 = 299    W                    Y                              Y   Y               B/O
                                           Domicile
            H20_L24_2                      Major Source of Tuition Fees should be consistent with Country of IF H20 = 02 OR 03 AND L24 = 099    W                    Y                              Y   Y               B/O
                                           Domicile
            H20_L24_3                      Major Source of Tuition Fees should be consistent with Country of IF H20 = 03 OR 04 AND L24 = 399    W                    Y                              Y   Y               B/O
                                           Domicile                                                          OR 599
            L01_L02_L03_L11_1              When changing a record for a learner, the learner should have the IF L01 AND L02 AND L03 exist       W                             Y              Y          Y   Y            B
                                           same date of birth as the record already in the system            onLEARNER_EVENTS and L11 NOT
                                                                                                             = DATE_OF_BIRTH in
                                                                                                             LEARNER_EVENTS
            L01_L03_LD04_WBL_1             Learner Reference/Provider Reference/Collection Type              IF L01 AND L03 AND LD04 exist on   E                             Y              Y          Y   Y            O
                                           combination must not already exist on the database for an 'add'   LEARNER_EVENTS
                                           transaction
            L01_N03_1                      Provider number must be the same as in the file name              IF L01 NOT = N03                   E                    Y                Y             Y   Y                B
            L01_N03_PIMS_1                 provider number must be part of the same organisation structure IF N03 NOT = L01 AND L01 AND N03 E                                 Y              Y          Y   Y            B    Prevent the inclusion of incorrect UPINs in multi-provider
                                           in PIMS as the provider number in the file name                   are not members of the same                                                                                      files (outstanding issue 3 from rules review on 15/11/2002)
                                                                                                             ORG_GROUP with
                                                                                                             ORG_GROUP_TYPE = '202'
            L05_L08_1                      Must be no learning aims data sets if the delete flag is set      IF L08 = Y AND L05 NOT = 00        E                             Y              Y      Y   Y               B/O
            L05_L08_2                      Must be at least one learning aim if there is no delete flag      IF L08 = N OR BLANK AND L05 = 00   E                             Y              Y      Y   Y               B/O Needed to ensure there's at least one aim for FE etc.

Change      L11_L28a_1                     If the age at 1 August 2005 is over 23 then Eligibility for enhanced       IF 1st of August 2005 - L11 > 23 years   E     Y                              Y   Y               BO                                                                  Changed date to 1 August 2005 to reflect start of 2005/06 academic
                                           funding must not be ‘16-18 funding entitlement and programme               AND L28a = (12 OR 13)                                                                                                                                                 year
                                           includes key skills’ or ‘16-18 funding entitlement and the learner's
                                           learning difficulties and/or disabilities are such that the QCA key
                                           skills qualification is inappropriate'
Change      L11_L28b_1                     If the age at the 1 august 2005 is over 23 then Eligibility for            IF 1st of August 2005 - L11 > 23 years   E     Y                              Y   Y               BO                                                                  Changed date to 1 August 2005 to reflect start of 2005/06 academic
                                           enhanced funding must not be ‘16-18 funding entitlement and                AND L28b = (12 OR 13)                                                                                                                                                 year
                                           programme includes key skills’ or ‘16-18 funding entitlement and
                                           the learner's learning difficulties and/or disabilities are such that
                                           the QCA key skills qualification is inappropriate'
            L14_L15_1                      Disability or Health Problem must be set to ‘Not known/information         IF L14 = 9 AND L15 NOT = 99              E     Y        Y                     Y   Y               B/O
                                           not provided’ if Learning difficulties and/or disabilities is set to ‘No
                                           information provided by the learner’.
            L14_L15_2                      Disability or Health Problem must be set to ‘No disability’ if             IF L14 = 2 AND L15 NOT = 98              E     Y        Y                     Y   Y               B/O
                                           Learning difficulties and/or disabilities is set to ‘Learner does not
                                           consider himself or herself to have a learning difficulty and/or
                                           disability or health problem’.
            L14_L16_1                      Learning Difficulty must be set to ‘Not known/information not              IF L14 = 9 AND L16 NOT = 99              E     Y        Y                     Y   Y               B/O
                                           provided’ if Learning difficulties and/or disabilities is set to ‘No
                                           information provided by the learner’.
            L14_L16_2                      Learening Difficulty must be set to ‘No learning difficulty’ if            IF L14 = 2 AND L16 NOT = 98              E     Y        Y                     Y   Y               B/O
                                           Learning difficulties and/or disabilities is set to ‘Learner does not
                                           consider himself or herself to have a learning difficulty and/or
                                           disability or health problem’.
            L17_L24_1                      Postcode is mandatory unless country code is not 'UK'                      IF L24 = (199 OR 399 OR 999 OR 099       E     Y        Y                     Y   Y               B/O
                                                                                                                      OR 299 OR 599) AND L17 = SPACES

            L17_L32_1                      Eligibity for Disadvantage Uplift must not be ‘from deprived area     IF L32 = 01 and L17(1,4) = 'ZZ99'             E     Y                              Y   Y               B/O
                                           (ward based uplift) – postcode on Council’s file’, if the first 4
                                           characters of the postcode are [ZZ99].
            L25_A46a_A46b_1                The Basic Skills Project for National Employers is only available for IF (A46a = 30 or A46b = 30) AND L25           E              Y                     Y   Y   Y    Y      B/O                                                                 Checks that if the learning aim is part of the National Employers
                                           providers who contract with the National Contracts Service            not = 002                                                                                                                                                                  basic skills project which is run by NCS that the provider contract
                                                                                                                                                                                                                                                                                            that the provider contracts with NCS
            L25_L44_1                      delivery locations must be present for NCS contracts                    if L25=002 and L44=null                     E              Y                     Y   Y               B/O
            L25_L44_2                      non NCS contracts must not fill in L44                                  if L44 NOT = NULL and l25 NOT =             E              Y                     Y   Y               B/O
                                                                                                                   002
            L25_T04_1                      The LSC ID must be the same as that on the file header unless           IF L25 NOT = T04 AND T04 NOT =              E              Y              Y      Y   Y                B
                                           the file header contains 999                                            (999 OR 000)
            L27_L39_1                      If destination code is set to 'death' then the restricted use indicator IF L39 = 61 and L27 not = 2                 E     Y        Y              Y      Y   Y                B                                                                  To ensure that learners who have died are flagged as not to be
                                           must be set to 'learner is not to be contacted'                                                                                                                                                                                                  contacted
            L28a_L28b_1                    Entries for Eligibility for enhanced funding must be different unless IF L28a = L28b AND L28a NOT = 99              E     Y                              Y   Y               B/O
                                           they are both 99
            L28a_L28b_2                    Entries for Eligibility for enhanced funding must be different unless IF L28a = L28b AND L28a NOT = 99              E              Y                     Y   Y               B/O
                                           they are both 99 or null                                                OR 00
            L29_L31_1                      Additional support costs must be zero if learner has not been           IF L29 = 97 OR 98 AND L31 NOT =             E     Y                              Y   Y               B/O
                                           assessed as requiring additional support                                000000
            L32_L33_1                      Eligibility for disadvantage uplift must be ‘not eligible for           IF L33 = 0.0000 OR 1.0000 AND L32           E     Y                              Y   Y               B/O
                                           disadvantage uplift enhanced funding' if Disadvantage uplift factor NOT = 99
                                           is 0.0000 or 1.0000
            L32_L33_2                      Disadvantage Uplift Factor must be 0.0000 if Eligibility for            IF L32 = 99 AND L33 NOT = 0.0000            E     Y                              Y   Y               B/O
                                           disadvantage uplift is ‘not eligible for disadvantage uplift enhanced
                                           funding’
            L34a_L34b_1                    Learner Support Reasons must all be different unless they are 99 IF L34a NOT = 99 AND L34a = L34b                   E     Y        Y                     Y   Y               B/O

            L34a_L34c_1                    Learner Support Reasons must all be different unless they are 99           IF L34a NOT = 99 AND L34a = L34c         E     Y        Y                     Y   Y               B/O

            L34a_L34d_1                    Learner Support Reasons must all be different unless they are 99           IF L34a NOT = 99 AND L34a = L34d         E     Y        Y                     Y   Y               B/O




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                                 Cross field validation                                                                                                                                     Page 24 of 26 2005/06 Version 2 26/05/2005
                                                                                                                                                               ILR validation rules 2005/06




                                                                                                                                                                                             On-line
                                                                                                                                                                                              data
                                                                                                                                                                                             captur
                                                                                                                                                                                   ESF         e
From                                                                                                                                                         FE/UFI WBL       ACL SR         syste         FE
04/05       Rule                             Rule Description                                                    Metadata                              E/W    Rule  Rule      Rule Rule LIS?   m     Ext? Fund?   B/O Business Reason for Rule   Reason for change
            L34b_L34c_1                      Learner Support Reasons must all be different unless they are 99    IF L34b NOT = 99 AND L34b = L34c       E      Y     Y                   Y     Y                  B/O

            L34b_L34d_1                      Learner Support Reasons must all be different unless they are 99    IF L34b NOT = 99 AND L34b = L34d       E      Y        Y                     Y   Y               B/O

            L34c_L34d_1                      Learner Support Reasons must all be different unless they are 99    IF L34c NOT = 99 AND L34c = L34d       E      Y        Y                     Y   Y               B/O

            L38_L39_1                        The Employment Status at end must not be 00 if destination code     IF L38 = 00 AND L39 NOT = (93,94 or    E               Y                     Y   Y               B/O
                                             anything other than 'continuing existing programme of learning',    95)
                                             'framework continuing' or 'framework completed'
            L38_L39_2                        The destination code must be 'continuing existing programme of      IF L39 = 95 AND L38 NOT = 00           E               Y                     Y   Y               B/O
                                             learning' if the Employment Status at end is 00
            L40a_L40b_1                      The National Learning Monitoring fields must not contain the same   IF L40a = L40b AND L40a NOT = 99       E      Y        Y       Y             Y   Y               B/O
                                             values unless they are both 99

2004/05 rules that are deleted for 2005/06
Delete      A10_E08_E17                      For LSC ESF co-financed aims starting after 31/07/2004, the         IF E08 > 31/07/2004 AND A10=70         E      Y        Y              Y      Y   Y               B/O                            Field E17 no longer required
                                             main co-financing activity must not be left as spaces.              AND E17abcde=' '
Delete      A09_A10_A26_LAD_1                If sector framework code is entered, it should match the             if FLAG11 in LEARNING_AIM Not =      W                Y                     Y   Y   Y           B/O                            This rule is replaced with A09_A10_A26_A27_LAD_1 which
                                             framework for that learning aim in the LAD for funded NVQs,         "Y" and (A10 = 40 or A10 = 41) AND                                                                                              generate an error for aim that start on or after 1 August 2005 and
                                             employer approved schemes and technical certificates                A26 NOT= 000 and there is no                                                                                                    meet this condition
                                                                                                                 matching record in
Delete      A09_A10_A27_LAD_6                Must be valid learning aim for this year for a new start for FE     IF A10=20 AND A27 => 1 August          E      Y                              Y   Y   Y           B/O                            Replaced with a new rule which allows aims the are not valid for
                                             funded provision                                                    2004 AND A27 <= 31 July 2005 AND                                                                                                new starts to be used for re-sits
                                                                                                                 FE_STATUS_CODE IN
                                                                                                                 FE_ANNUAL_VALUES table in LAD =
                                                                                                                 '2' (not valid for new starters)
Delete      E08_T08_1                        ESF Start date must be on or before file creation date              E08 > T08                              E      Y        Y              Y      Y   Y                B




a1ea75e1-f64c-44c7-8214-4c768b9df412.xls                                                                                                                           Cross field validation                                                                                                Page 25 of 26 2005/06 Version 2 26/05/2005

				
DOCUMENT INFO
Description: Il Birth Certificates Printable document sample