Docstoc

Blank Printable Resume

Document Sample
Blank Printable Resume Powered By Docstoc
					                                                                          74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



          FILENAME VALIDATION


                                                                                                                                  FE

                                                                                                                                  an
From                                                                                                                              d           ESF   External                  Reject
02/03     Ref          Description             Length Rule ID        Format         Rule Description                              Ufi WBL ACL SR    Check?     E/W LIS? Core? File?
          N01          Filename                       N01_1          FLLLLLLDDAAAYY                                               Y    Y   Y Y                  E    Y    Y     Y
                                                                     YYBBBSS.CCC
                                                         N01_2                      Must not have been received before            Y    Y   Y   Y       Y        E   N         Y         Y
                                                         N01_3                      Should be expected return                     Y    Y   Y   Y       Y        E   N         Y         Y
Change                                                   N01_4                      Transmission number must be greater than      Y    Y   Y   Y       Y        E   N         Y         Y
                                                                                    previous transmission
Change                                                   N01_5                      Transmission number should be 1 greater       Y    Y   Y   Y       Y       W    N         Y         N
                                                                                    than last transmission number received
Change N02             File Type                     1 N02_1         alphanumeric   Must be 'A' or 'B'                                 Y       Y                E   Y         y         Y
New                                                    N02_2                        must be A                                     Y        Y                    E   Y         Y         Y
Delete N03             Provider Number               6 N03_1         numeric        Must be numeric and non-zero                  Y    Y   Y   Y                E   Y         Y         Y
Change 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. 0304)           Y    Y   Y   Y                E   Y         Y         Y
Change N06             Transmission Number           3 N06_1         numeric           Must be 3 character numeric                Y    Y   Y   Y                E   Y         Y         Y
Change N07             Serial Number                 2 N07_1         numeric           Must be 2 digit numeric (starts at 01)     Y    Y   Y   Y                E   Y         Y         Y
Change                                                 N07_2                           Must not be 00                             Y    Y   Y   Y                E   Y         Y         Y
Change N08             Collection Period               N08_1         alphanumeric      Must be 3 characters in the range W01 to   Y    Y   Y   Y                E   Y         Y         Y
                                                                                       W13 or the range F01 to F05 or the range
                                                                                       C01 to C03 and S01 toS12 and U01 to U03

          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



LSC 11/15/2010                                                                            File Level                                                                    Page 1 of 30 / 2003/04
                                                                          74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                       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
New       T12      reserved for use by              50 T12_1         alphanumeric      May be any printable characters except for [*]
                   providers                                                           and [?] and [%] and [_]
New       T13      Reserved for LIS                      T13_1       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?

Change F01             Provider Number               6 F01_N03_1                       Must be same as in filename unless F01 =         Y   Y   Y   Y                E   Y         Y         Y
                                                                                       '999999'
Change F01a            Contract/Allocation           2 F01a_N03a_1   numeric           Must be same as in filename                      Y   Y   Y   Y                E   Y         Y         Y
                       Type
Change F02             FILLER                       12 F02_1         alphanumeric      Must be all 'Z's                                 Y   Y   Y   Y                E   Y         Y         Y
Change F03             Data Set Identifier           2 F03_1         numeric           Must be 99                                       Y   Y   Y   Y                E   Y         Y         Y
Change F04             LSC Number of                 3 F04_N04_1                       Must be same as in filename                      Y   Y   Y   Y                E   Y         Y         Y
                       funding LSC
Change    F05          Year of Submission            4   F05_N05_1   numeric           Must be same as in filename                      Y   Y   Y   Y                E   Y         Y         Y
Change    F06          Collection Period             3   F06_N08_1   alphanumeric      Must be same as in filename (extension)          Y   Y   Y   Y                E   Y         Y         Y
Change    F07          Transmission Number           3   F07_N06_1   numeric           Must be same as in filename                      Y   Y   Y   Y                E   Y         Y         Y
Change    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
Change    F09          Record Count                  7   F09_1       numeric           Must be numeric                                  Y   Y   Y   Y                E   Y         Y         Y
Change                                                   F09_2                         Must equal count of all records in file          Y   Y   Y   Y                E   Y         Y         Y
                                                                                       (including header and footer)
          F10          Reserved for LIS                              alphanumeric




LSC 11/15/2010                                                                            File Level                                                                         Page 2 of 30 / 2003/04
                                                         74ee86bf-9829-4e48-b5eb-d52470ba1873.xls


From                                                                                                                  ESF                Reject FE
02/03  Rule ID   Description                                                                             FE WBL ACL    SR E/W LIS? Core? File? Fund?
Change R03       An Aim record must have an associated Learner record (same Provider Number and           Y  Y   Y      Y  E    Y    Y           Y
                 Allocation Number and Learner Reference number)
change R04       An ESF record must have an associated Aim record (same Provider Number and              Y   Y         Y   E    Y    Y
                 Allocation Number and Learner Reference number and Learning Aim data set
                 sequence number)
change R05       An HE record must have an associated Aim record (same Provider Number and               Y                 E    Y    Y
                 Allocation Number and Learner Reference number and Learning Aim data set
                 sequence number)
Change R06       No two Learner records should have the same Contract/Allocation Provider Number         Y   Y   Y     Y   E    Y    Y                   Y
                 and Allocation Number and Learner Reference number combination
Change R07       No two Aim records should have the same Contract/Allocation Provider Number and         Y   Y   Y     Y   E    Y    Y                   Y
                 Allocation Number and Learner Reference number and Learning aim data set
                 sequence combination
change R08       No two ESF records should have the same Provider Number and Allocation Number           Y   Y         Y   E    Y    Y
                 and Learner Reference number and Learning aim data set sequence and ESF dataset
                 sequence combination
Change R09       No two HE records should have the same Provider Number and Allocation Number            Y                 E    Y    Y
                 and Learner Reference number and Learning aim data set sequence and HE dataset
                 sequence combination
Change 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
                 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
Change R20       A learner must only have one LSC WBL-funded main aim at any one time                        Y             E    Y    Y
New    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.
New       R22    If A10 = 41 or 42 for an aim, then there must be at least one more aim record for the       Y             E    Y    Y
                 same learner (based on L01 and L03) with A10=40 and A15=(02 or 03)
New       R23    If A31 is not null on all aims for a learner then L39, Destination cannot be 95             Y             E    Y    Y




LSC 11/15/2010                                                      Cross Record Validation                                              Page 3 of 30 / 2003/04
                                                                              74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



From                                                                                  FE            ESF                          Reject  FE
02/03    Rule ID    Description                                                       ufi   WBL ACL SR          E/W LIS? Core?    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

2002/03 rules deleted in 2003/04




LSC 11/15/2010                                                                              Import Validation                                   Page 4 of 30 / 2003/04
                                                                     74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                        Learner Level Derived Data
                                                                                     FE
                                                                                     and
           Ref          Field Name                        Length Field type           UfI WBL ACL ESF SR Derivation Rule                                              LIS? Core? 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    Y             Calculated by subtracting Date of Birth (L11) from            Y       Y
                                                                                                         Learning Start Date (A27) and truncate to derive
                                                                                                         age. Age bands are '1' 16-18 and '2' 19-24. Also
                                                                                                         eligible as 16 year olds are 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. The age band is
                                                                                                         set to 16-18 if one of the Eligibility for Enhanced
                                                                                                         Funding fields has '15' in it.

2002/03 rules deleted in 2003/04
                       FE Indicator                            1 alphabetic          N/A N/A                  Set to 'Y' if any dependent aim has A08 = '1' else       Y       Y
           LD01                                                                                               'N'
                       WBL Indicator                           1 alphabetic          N/A N/A                  Set to 'Y' if any dependent aim has A08 = '2' else       Y       Y
           LD02                                                                                               'N'
                       Earliest Start Date                     8 date (DDMMYYYY)       y    Y                 Earliest start date (A27) for any aim for the learner    Y       Y
           LD03
                                                                                                              Calculated by subtracting Date of Birth (L11) from
           AD02         Age at Start                           3 numeric              Y     Y                 Learning Start Date (A27)                                Y       Y




           LSC 11/15/2010                                                     Derived Data for Validation                                                              Page 5 of 30 / 2003/04
                                                                                 74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                            FE/U           ESF
From                                                                                                                             Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03     Rule ID             Field Name
                    Field Number                             FE WBL ACL ESF SR    Rule Description                               (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
Change    L01_2     L01       Provider number                 Y  Y   Y Y          Must exist on table                                                    E   Y    Y    Y    Y       Y    Y    Y         B/O
New       L02_1     L02       Contract/Allocation Type        Y  Y   Y            Must exist on table                                                    E   Y                      Y    Y              B/O
New       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
New       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.
New       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.
New    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
Change L11_2        L11       Date of birth                  Y   Y   Y     Y      Warning message if 00000000                                           W    Y    Y    Y    Y      Y    Y                      B/O
       L11_3        L11       Date of birth                  Y   Y   Y     Y      Date must be before 01/08/2003 and                                    E    Y    Y    Y    Y      Y    Y             Y        B/O
                                                                                  after 01/01/1850 if entered
Change L11_5        L11       Date of birth                  Y   Y   Y     Y      Date should be after 01/08/1903                                       W    Y    Y    Y    Y      Y    Y                      B/O
       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
New       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
New       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
Change L17_2        L17       Home postcode                  Y   Y   Y     Y      First part should must 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

Change 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




LSC 11/15/2010                                                                               Field Level Validation                                                                              Page 6 of 28 / 2003/04
                                                                               74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                        FE/U           ESF
From                                                                                                                         Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03     Rule ID             Field Name
                    Field Number                           FE WBL ACL ESF SR    Rule Description                             (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
          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.

New       L18_3     L18        Address line 1              Y   Y         Y      Must be spaces                                                      E              Y           Y    Y                      B/O
          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.

New       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.

New       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.

New    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
Change 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
Change 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
Change 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
New    L22_5        L22        Current Postcode            Y   Y                Must be spaces                                                      E              Y    Y      Y    Y                      B/O
Change 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
New       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
New       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     Y      Must exist on table and not be 000                                  E         Y    Y    Y      Y    Y    Y                 B/O




LSC 11/15/2010                                                                            Field Level Validation                                                                             Page 7 of 28 / 2003/04
                                                                                       74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                               FE/U           ESF
From                                                                                                                                Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03  Rule ID               Field Name
                   Field Number                                    FE WBL ACL ESF SR    Rule Description                            (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
Change L25_3       L25       LSC number of funding LSC              Y  Y   Y     Y      Must be 000 for FE                                                  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              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
New    L26_10      L26       National insurance number             Y   Y                Must be spaces                                                     E    Y         Y    Y      Y    Y                      B/O
Change L26_4       L26       National insurance number             Y   Y                NI Number should must not be in use on                             W         Y                     Y    Y                 B/O
                                                                                        another 'in learning' event if non-blank

          L27_1    L27       Restricted use indicator              Y   Y         Y      Must exist on table                                                E    Y    Y         Y      Y    Y                      B/O
New       L27_2    L27       Restricted use indicator              Y   Y         Y      Must be 0                                                          E              Y           Y    Y                      B/O
          L28a_3   L28a      Eligibility for enhanced funding      Y   Y                For FE, must be 12, 13, 99                                         E    Y                     Y    Y             Y        B/O
                             (1)
New       L28a_4   L28a      Eligibility for enhanced funding      Y   Y                Must be 00                                                         E              Y    Y      Y    Y                      B/O
                             (1)
New       L28a_5   L28a      Eligibility for enhanced funding      Y   Y                Must be 00, 14, 15, 99                                             E         Y                Y    Y                      B/O
                             (1)
          L28b_3   L28b      Eligibility for enhanced funding      Y   Y                For FE, must be 12, 13, 99                                         E    Y                     Y    Y             Y        B/O
                             (2)
New       L28b_4   L28b      Eligibility for enhanced funding      Y   Y                Must be 00                                                         E              Y    Y      Y    Y                      B/O
                             (2)
New       L28b_5   L28b      Eligibility for enhanced funding      Y   Y                Must be 00, 14, 15, 99                                             E         Y                Y    Y                      B/O
                             (2)
          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 uplift   Y                    Must exist on table                                                E    Y                     Y    Y             Y        B/O

          L32_2    L32       Eligibility for disadvantage uplift   Y                    Must be 00                                                         E         Y    Y    Y      Y    Y             Y        B/O

          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
Change L33_3       L33       Disadvantage uplift factor            Y                    Must have decimal point in position 2                              E    Y    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
New    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
New    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
New    L34c_4      L34c      Learner support reason (3)            Y   Y                Must be 00                                                         E              Y    Y      Y    Y                      B/O
new    L34d_2      L34d      Learner support reason (4)            Y   Y                Must be 41 or 99                                                   E         Y                Y    Y                      B/O
new    L34d_3      L34d      Learner support reason (4)            Y   Y                Must exist on table                                                E    Y                     Y    Y                      B/O
New    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
New    L35_2       L35       Prior attainment level                Y   Y         Y      Must be 00                                                         E              Y           Y    Y                      B/O




LSC 11/15/2010                                                                                    Field Level Validation                                                                            Page 8 of 28 / 2003/04
                                                                                     74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                          FE/U           ESF
From                                                                                                                           Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03     Rule ID             Field Name
                    Field Number                                 FE WBL ACL ESF SR    Rule Description                         (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
          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              Y                Must exist on table (if present)                                E         Y                Y    Y                    B/O
                              day of learning
          L38_2     L38       Employment status on last              Y                Must be zeros                                                   E    Y         Y     Y     Y    Y                    B/O
                              day 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

New    L39_4        L39        Destination                       Y   Y         Y      Must be zeros                                                   E              Y           Y    Y                    B/O
Change L40a_2       L40a       National learner monitoring (1)   Y   Y   Y            Must be 11-1920, 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

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

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

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

New       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                    B/O
New       L41a_2    L41a       Local learner monitoring (1)      Y   Y                Must be zeros                                                   E              Y    Y      Y    Y                    B/O
          L41b_1    L41b       Local learner monitoring (2)      Y   Y                Must be => 0 if entered                                         E    Y    Y                Y    Y                    B/O
New       L41b_2    L41b       Local learner monitoring (2)      Y   Y                Must be zeros                                                   E              Y    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 [_]
New       L44_1     L44        NCS delivery LSC number               Y                Must not be 002                                                 E         Y                Y    Y                    B/O
New       L44_2     L44        NCS delivery LSC number               Y                Must be 000                                                     E    Y         Y    Y      Y    Y                    B/O
New       L44_3     L44        NCS delivery LSC number               Y                Must exist on table (if entered)                                E         Y                Y    Y                    B/O




LSC 11/15/2010                                                                                    Field Level Validation                                                                     Page 9 of 28 / 2003/04
                                                                                       74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                               FE/U           ESF
From                                                                                                                                Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03     Rule ID             Field Name
                    Field Number                                   FE WBL ACL ESF SR    Rule Description                            (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
                    LEARNING AIMS DATA SET LAYOUT

                                 Field Name                                                                                                                    FE/U           ESF
                                                                                                                                    Metadata Description        FI  WBL ACL SR                       FE   Batch/
       Rule ID      2002/3 Ref                                     FE WBL ACL           Rule Description                            (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
Change 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
Change A02_1        A02          Allocation number                  Y  Y                Must be the same as L02                                             E   Y         Y    Y       Y    Y         Y    B/O
New    A02_2        A02          Allocation number                  Y  Y                Must be 11 or 12 or 13 or 14 (if entered)                           E        Y                 Y    Y         Y    B/O
New    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
New    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
New    A08_2        A08          Data Set Format                   Y   Y   Y     Y      Must be 1                                                          E    Y                     Y    Y                    B/O
New    A08_3        A08          Data Set Format                   Y   Y   Y     Y      Must be 2                                                          E         Y                Y    Y                    B/O
New    A08_4        A08          Data Set Format                   Y   Y   Y     Y      Must be 3                                                          E              Y           Y    Y                    B/O
Change 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)
New       A10_3     A10          LSC Funding stream                Y   Y   Y     Y      Must be 20, 70, 80 or 99                                           E    Y                     Y    Y           Y        B/O
New       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
New       A10_5     A10          LSC Funding stream                Y   Y   Y     Y      Must be 10, 80, 99                                                 E              Y           Y    Y                    B/O
New       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
New       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




LSC 11/15/2010                                                                                      Field Level Validation                                                                       Page 10 of 28 / 2003/04
                                                                                                74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                                            FE/U           ESF
From                                                                                                                                           Metadata Description          FI  WBL ACL SR                           FE   Batch/
02/03     Rule ID             Field Name
                    Field Number                                FE WBL ACL ESF SR                Rule Description                              (error condition)        E/W Rule Rule Rule rule       LIS? Core? Ext Fund? Online
          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    Should exist on table or be ZZ99 ZZZ or                                W     Y       Y           Y               Y   Y              B/O
                                                                                                 all spaces
Change A23_2        A23        Delivery location postcode           Y       Y               Y    First part should must exist on table or be                            W     Y       Y           Y       Y           Y                B
                                                                                                 'ZZ99' or the whole postcode must be
                                                                                                 spaces
Change A23_3        A23        Delivery location postcode           Y       Y               Y    The second part of the postcode must be                                  E   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

Change A23_4        A23        Delivery location postcode           Y       Y               Y    The first part of the postcode must                                      E   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    Mandatory                                                                E   Y                           Y       Y                  B/O
New       A23_6     A23        Delivery location postcode           Y       Y               Y    Must be spaces                                                           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
New       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
New       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
Delete    A27_3     A27        Learning start date              Y       Y       Y       Y        Must be on or before today's date                                    E           Y           Y               Y                   O
New       A27_6     A27        Learning Start Date              Y       Y       Y       Y        Start date must not be more than 10           IF A27 > 1 August 2013 E           Y           Y       Y       Y                   B/O
                                                                                                 years in the future
New       A27_4     A27        Learning start date                  Y       Y       Y       Y    Start date must not be more than ten          IF A27 < 1 August 1993     E   Y       Y   Y       Y       Y       Y                  B/O
                                                                                                 years ago
New       A27_5     A27        Learning start date                  Y       Y       Y       Y    Start date must not be after current          IF A27 > 31 July 2004      E   Y       Y   Y       Y       Y       Y                  B/O
                                                                                                 learning year
          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
New       A31_3     A31        Learning actual end date             Y       Y       Y       Y    Should be after 1 August 2002                                          W     Y                           Y       Y                   B
New       A31_4     A31        Learning actual end date             Y       Y       Y       Y    Should be before 31 July of 2004                                       W     Y       Y           Y       Y       Y                   B
New       A31_5     A31        Learning actual end date             Y       Y       Y       Y    Must be before 31 July 2006                                            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        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                  B/O
                                                                                                 value is greater than [2000]
          A32_3     A32        Guided learning hours                Y               Y            Must be 00000                                                            E           Y           Y       Y       Y                  B/O
          A34_3     A34        Completion status                    Y       Y       Y       Y    Must exist on table                                                      E   Y       Y   Y       Y       Y       Y                  B/O




LSC 11/15/2010                                                                                              Field Level Validation                                                                                    Page 11 of 28 / 2003/04
                                                                                   74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                            FE/U           ESF
From                                                                                                                             Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03  Rule ID               Field Name
                   Field Number                                FE WBL ACL ESF SR    Rule Description                             (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
Change A35_1       A35       Learning outcome                   Y  Y   Y      Y     Must exist on table (if present)                                     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
Change A37_1       A37       Number of units completed          Y  Y                Must be => 0                                                         E   Y    Y                 Y    Y         Y    B/O
New    A37_2       A37       Number of units completed          Y  Y                Must be zeros                                                        E             Y    Y       Y    Y              B/O
Change A38_1       A38       Number of units to achieve full    Y  Y                Must be => 0                                                         E   Y    Y                 Y    Y         Y    B/O
                             qualification
New       A38_2    A38       Number of units to achieve full   Y   Y                Must be zeros                                                       E              Y    Y      Y    Y                    B/O
                             qualification
Change 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       NVQ achievement date                  Y                Must be a valid date or 00000000                                    E         Y                Y    Y                    B/O
          A40_2    A40       NVQ achievement date                  Y                Date must be less than or equal to                                  E         Y                     Y                     O
                                                                                    today’s date.
New       A40_3    A40        NVQ 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
          A44_1    A44        Placement employer name              Y                May be any printable characters except                              E         Y                Y    Y                    B/O
                                                                                    for [*] and [?] and [%] and [_]
New       A44_2    A44        Placement employer name              Y                Must be spaces                                                      E    Y         Y    Y      Y    Y                    B/O
          A45_1    A45        Placement employer location          Y                Should exist on table or be all spaces                              W         Y                     Y    Y               B/O
                              postcode
Change A45_2       A45        Placement employer location          Y                First part should must exist on table or                            W         Y                Y         Y                 B
                              postcode                                              the whole postcode must be spaces
Change A45_3       A45        Placement employer location          Y                The second part of the postcode must be                             E         Y                Y    Y                    B/O
                              postcode                                              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
Change A45_4       A45        Placement employer location          Y                The first part of the postcode must                                 E         Y                Y    Y                    B/O
                              postcode                                              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
New       A45_5    A45        Placement employer location          Y                Must be spaces                                                      E    Y         Y    Y      Y    Y                    B/O
                              postcode
change A46a_1      A46a       National learning aim            Y   Y   Y            Must be                                                             E    Y                     Y    Y           Y        B/O
                              monitoring (1)                                        01,13,14,15,16,17,18,19,20,21,25,27-50
                                                                                    or 99
Change A46a_2      A46a       National learning aim            Y   Y   Y            Must be 14, 15, 16, 17,21, 26, 27-50 or                             E         Y                Y    Y                    B/O
                              monitoring (1)                                        99
New       A46a_3   A46a       National learning aim            Y   Y   Y            Must be 14,15,16,23,24,27-50 or 99                                  E              Y           Y    Y                    B/O
                              monitoring (1)
change A46b_1      A46b       National learning aim            Y   Y   Y            Must be                                                             E    Y                     Y    Y           Y        B/O
                              monitoring (2)                                        01,13,14,15,16,17,18,19,20,21,25,27-50
                                                                                    or 99
Change A46b_2      A46b       National learning aim            Y   Y   Y            Must be 14, 15, 16, 17, 21, 26, 27-50 or                            E         Y                Y    Y                    B/O
                              monitoring (2)                                        99
New       A46b_3   A46b       National learning aim            Y   Y   Y            Must be 14,15,16,23,24,27-50 or 99                                  E              Y           Y    Y                    B/O
                              monitoring (2)




LSC 11/15/2010                                                                                  Field Level Validation                                                                        Page 12 of 28 / 2003/04
                                                                                    74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                         FE/U           ESF
From                                                                                                                          Metadata Description        FI  WBL ACL SR                           FE   Batch/
02/03     Rule ID             Field Name
                    Field Number                               FE WBL ACL ESF SR     Rule Description                         (error condition)      E/W Rule Rule Rule rule       LIS? Core? Ext Fund? Online
          A47a_1    A47a      Local learning aim monitoring     Y  Y                 Must be => 0 if entered                                          E   Y    Y                     Y    Y              B/O
                              (1)
New       A47a_2    A47a      Local learning aim monitoring    Y    Y                Must be zeros                                                   E                Y      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                    B/O
                              (2)
New       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      Y    Y   Y       Y    May be any printable characters except                          E      Y    Y    Y      Y      Y    Y                    B/O
                              aim data 1 (1)                                         for [*] and [?] and [%] and [_]
          A48b_1    A48b      Provider specified learning      Y    Y   Y       Y    May be any printable characters except                          E      Y    Y    Y      Y      Y    Y                    B/O
                              aim data 1 (2)                                         for [*] and [?] and [%] and [_]
New       A49_1     A49       Special Projects and Pilots      Y    Y                May be any printable characters except                          E      Y    Y                  Y    Y                    B/O
                                                                                     for [*] and [?] and [%] and [_]
New       A49_2     A49        Special Projects and Pilots     Y    Y                Must be spaces                                                  E                Y      Y      Y    Y                    B/O
New       A50_1     A50        Reason Learning Ended                Y                Must exist on table if entered                                  E           Y                  Y    Y                    B/O
New       A50_2     A50                                             Y                Must be zeros                                                   E      Y         Y      Y      Y    Y                    B/O
New       A51_1     A51        On programme payments                Y                Must be greater or equal to zero                                E           Y                  Y    Y                    B/O
New       A51_2     A51        On programme payments                Y                Should be less than 48                                          W           Y                  Y    Y                    B/O
New       A51_3     A51        On programme payments                Y                Must be zeros                                                   E      Y         Y      Y      Y    Y                    B/O
New       A52_1     A52        Distance learning funding       Y                     Must be zeros                                                   E           Y    Y      Y      Y    Y                    B/O
New       A52_2     A52        Distance learning funding       Y                     Must be greater or equal to zero                                E      Y                       Y    Y                    B/O
New       A53_1     A53        Additional Learning Needs            Y                Must exist on table (if entered)                                E           Y                  Y    Y                    B/O
New       A53_2     A53        Additional Learning Needs            Y                Must be 00                                                      E      Y         Y      Y      Y    Y                    B/O
New       A46a_3    A46        National learning aim           Y    Y   Y            Must be 00                                                      E                       Y      Y    Y                    B/O
                               monitoring (1)
New       A46b_3    A46        National learning aim           Y    Y   Y            Must be 00                                                      E                       Y      Y    Y                    B/O
                               monitoring (2)

                    ESF CO-FINANCING DATA SET LAYOUT
          Rule ID   2002/3 Ref Field Name            FE            WBL ACL ESF SR    Rule Description                         Metadata Description   E/W   FE WBL           ESF                 FE   Batch/Online
                                                                                                                                                                                   LIS? Core? Ext Fund?
                                                                                                                                                           Rule Rule ACL    SR
                                                                                                                                                                     rule   rule
          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
New       E02_2                                                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_2     E08        Date started ESF co-financing   Y    Y       Y        Must be <= today's date                                         E      Y    Y           Y           Y                      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




LSC 11/15/2010                                                                                 Field Level Validation                                                                          Page 13 of 28 / 2003/04
                                                                                  74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                   FE/U           ESF
From                                                                                                                    Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03  Rule ID               Field Name
                   Field Number                               FE WBL ACL ESF SR    Rule Description                     (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
       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
Change 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                    B/O
                             stereotyping (1)
New       E16a_2   E16a      Addressing gender                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
                             stereotyping (1)
          E16b_1   E16b      Addressing gender                Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
                             stereotyping (2)
New       E16b_2   E16b      Addressing gender                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
                             stereotyping (2)
          E16c_1   E16c      Addressing gender                Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
                             stereotyping (3)
New       E16c_2   E16c      Addressing gender                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
                             stereotyping (3)
          E16d_1   E16d      Addressing gender                Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
                             stereotyping (4)
New       E16d_2   E16d      Addressing gender                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
                             stereotyping (4)
          E16e_1   E16e      Addressing gender                Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
                             stereotyping (5)
New       E16e_2   E16e      Addressing gender                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
                             stereotyping (5)
          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
          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
          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
          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
          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
          E18a_1   E18a      Delivery Mode (1)                Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
New       E18a_2   E18a      Delivery Mode (1)                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
          E18b_1   E18b      Delivery Mode (2)                Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
New       E18b_2   E18b      Delivery Mode (2)                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
          E18c_1   E18c      Delivery Mode (3)                Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
New       E18c_2   E18c      Delivery Mode (3)                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
          E18d_1   E18d      Delivery Mode (4)                Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
New       E18d_2   E18d      Delivery Mode (4)                Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
          E19a_1   E19a      Support measures to be           Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
                             accessed by learner (1)
New       E19a_2   E19a      Support measures to be           Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
                             accessed by learner (1)
          E19b_1   E19b      Support measures to be           Y   Y                Must exist on table (if entered)                            E    Y    Y                Y    Y                    B/O
                             accessed by learner (2)
New       E19b_2   E19b      Support measures to be           Y   Y                Must be a space                                             E                   Y      Y    Y                    B/O
                             accessed by learner (2)




LSC 11/15/2010                                                                                Field Level Validation                                                                 Page 14 of 28 / 2003/04
                                                                                      74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                           FE/U           ESF
From                                                                                                                            Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03     Rule ID             Field Name
                    Field Number                                  FE WBL ACL ESF SR    Rule Description                         (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
          E19c_1    E19c      Support measures to be               Y  Y                Must exist on table (if entered)                                 E   Y    Y                 Y    Y              B/O
                              accessed by learner (3)
New       E19c_2    E19c      Support measures to be              Y   Y                Must be a space                                                 E                   Y      Y    Y                    B/O
                              accessed by learner (3)
          E19d_1    E19d      Support measures to be              Y   Y                Must exist on table (if entered)                                E    Y    Y                Y    Y                    B/O
                              accessed by learner (4)
New       E19d_2    E19d      Support measures to be              Y   Y                Must be a space                                                 E                   Y      Y    Y                    B/O
                              accessed by learner (4)
          E19e_1    E19e      Support measures to be              Y   Y                Must exist on table (if entered)                                E    Y    Y                Y    Y                    B/O
                              accessed by learner (5)
New       E19e_2    E19e      Support measures to be              Y   Y                Must be a space                                                 E                   Y      Y    Y                    B/O
                              accessed by learner (5)
Change E20a_1       E20a      Learner background (1)              Y   Y      Y         Must exist on table (if entered)                                E    Y    Y         Y      Y    Y                    B/O
New    E20b_1       E20b      Learner background (2)              Y   Y      Y         Must exist on table (if entered)                                E    Y    Y         Y      Y    Y                    B/O
New    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                    B/O
                              with disability
New       E21_2     E21       Support measures for learners       Y   Y                Must be zeros                                                   E                   Y      Y    Y                    B/O
                              with disability

                    HIGHER EDUCATION DATA SET LAYOUT

                                                                                                                                                           FE WBL                                FE   Batch/
          Rule ID   2002/3 Ref   Field Name                       FE WBL               Rule Description                         Metadata Description   E/W Rule Rule             LIS? Core? Ext Fund? Online
          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




LSC 11/15/2010                                                                                    Field Level Validation                                                                     Page 15 of 28 / 2003/04
                                                                                  74ee86bf-9829-4e48-b5eb-d52470ba1873.xls



                                                                                                                                                         FE/U           ESF
From                                                                                                                          Metadata Description        FI  WBL ACL SR                       FE   Batch/
02/03     Rule ID             Field Name
                    Field Number                              FE WBL ACL ESF SR    Rule Description                           (error condition)      E/W Rule Rule Rule rule   LIS? Core? Ext Fund? Online
          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 2004                                 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
          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
New       H36_1     H36       Socio-economic indicator        Y                    Must exist on table                                               E    Y                     Y    Y                    B/O




LSC 11/15/2010                                                                                Field Level Validation                                                                       Page 16 of 28 / 2003/04
                                                                                                                     74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                                               ESF
From                                                                                                                                                          FE/UFI WBL ACL SR                      FE
02/03       Rule                             Rule Description                                                     Metadata                                E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
new         A02_A09_A10_A15_A16_AD01_L01_L25 For WBL funded aims there must be a matching contract line           IF A10 = 40 AND A15 NOT = 99 AND         W          Y                    Y    Y         B/O Need to excluded non-contracted provision for WBL
            _LAD_WBL_1                       on a valid contract between the provider and the LLSC.               no matching contract line in WBL for                                                        funded aims - DJ
                                                                                                                  the (FUNDING_CATEGORY from
                                                                                                                  LAD, LEARNER_PROGRAMME from
                                                                                                                  WBL, AGE_BAND) combination.

New         A02_A10_1                            Contract allocation type must be entered for WBL aims          IF A10 = (40 or 41 or 42) and A02 =        E            Y               Y     Y                 B/O
                                                                                                                null
New         A02_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
                                                 Provider Number, LSC and contract type                         no funding relationship between this
                                                                                                                provider and LLSC
New         A02_L01_L25_WBL_1                    There must be a funding relationship for this Provider Number, if there is no funding relationship        E            y                            Y          B/O
                                                 LSC and contract type                                          between this provider and LLSC
            A05_L05_1                            The data set sequence must be less than or equal to the        IF A05 > L05                               E     Y      Y     Y    Y    Y     Y                  B
                                                 number of datasets
            A06_A10_1                            If LSC Funding Stream is LSC ESF Co-financed, there must       IF A10 = 70 AND A06 = 00                   E     Y      Y          Y    Y     Y                 B/O Consistency of data with control fields
                                                 be an ESF data set
            A06_A10_2                            ESF data must not be submitted if there is no LSC funding for IF A06 = 1 AND A10 = 99                     E     Y      Y     Y         Y     Y                 B/O
                                                 the 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
            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   IF A11a = 001 OR 002 AND A07 = 00        E     Y                      Y     Y                 B/O Consistency of data with control fields
                                                 for HEFCE funding, there must be an HE data set
            A07_A11b_1                           If the aim is either supported by HEFCE funding or is eligible   IF A11b = 001 OR 002 AND A07 = 00        E     Y                      Y     Y                 B/O Consistency of data with control fields
                                                 for HEFCE funding, there must be an HE data set
New         A09_A10_1                            If the learning aim is XESF0001 the LSC funding stream must      IF A09 = 'XESF0001' AND A10 NOT =        E            Y          Y    Y     Y                 B/O
                                                 be <70> LSC ESF co-financed                                      70
New         A09_A10_A15_3                        A WBL funded E2E programme must use the E2E learning             if a15=09 and a10=40 and a09             E            Y               Y     Y                 B/O
                                                 aim code                                                         not=Xe2e0001
New         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 AMA, FMA and NVQ main aims. Except for framework          in LAD not ="Y" AND A10 = 40 AND
                                                 completion class codes                                           A15 = (02 OR 03 OR 04 OR 05 OR
                                                                                                                  06 OR 07) AND A24 = 0000

Change      A09_A10_A15_LAD_1                    Programme type must be consistent with LAD level for NVQ         IF A10 = 40 AND ((A15 = 04 AND           E            Y               Y     Y      Y          B/O
                                                 level 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) OR (A15 =
                                                                                                                  07 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))
New         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 MAs. Except for framework     "Y" and (a10=40) and if (A15 = 07
                                                 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))




LSC 11/15/2010                                                                                                                   Cross field validation                                                                                                       Page 17 of 29 / 2003/04
                                                                                                                  74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                                             ESF
From                                                                                                                                                        FE/UFI WBL ACL SR                      FE
02/03       Rule                             Rule Description                                                  Metadata                                 E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
New         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) AND                 E          Y               Y    Y    Y         B/O
                                             funded provision for first-time entrants                          A16=05 AND A27 => 1 August 2003
                                                                                                               AND A27 <= 31 July 2004 AND
                                                                                                               WBL_STATUS_CODE IN
                                                                                                               WBL_ANNUAL_VALUES table in
                                                                                                               LAD = '2' (not valid for new starters)
New         A09_A10_A16_A27_LAD_3            Must be valid learning aim for this year for a new start for      IF A10=(42 or 70 or 80 or 99) AND         E    Y      Y    Y    Y    Y     Y     Y    Y    B/O
                                             provision which is not FE-, ACL- or WBL-funded, for first-time (A16=05 OR A16=00) AND A27 => 1
                                             entrants on aims for which Programme Entry Route is not           August 2003 AND A27 <= 31 July
                                             collected                                                         2004 AND
                                                                                                               NON_LSC_FUNDED_STATUS IN
                                                                                                               ALL_ANNUAL_VALUES table in LAD
                                                                                                               = '2' (not valid for new starters)
New         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    Y    B/O
                                             funded provision                                                  2003 AND A27 <= 31 July 2004 AND
                                                                                                               FE_STATUS_CODE IN
                                                                                                               FE_ANNUAL_VALUES table in LAD
                                                                                                               = '2' (not valid for new starters)
New         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     Y   B/O
                                             funded provision                                                  2003 AND A27 <= 31 July 2004 AND
                                                                                                               ACL_STATUS_CODE IN
                                                                                                               ACL_ANNUAL_VALUES table in LAD
                                                                                                               = '2' (not valid for new starters)
New         A09_A10_LAD_4                    Must exist on FE Annual Values table for year 2003/04 with        IF A10 =20 AND FE_STATUS_CODE             E    Y                     Y     Y     Y    Y    B/O
                                             valid status (1 or 2) for FE-funded aims                          IN FE_ ANNUAL_VALUES IN LAD
                                                                                                               (for record with Academic_Year=
                                                                                                               0304) NOT=('1' OR '2')

New         A09_A10_LAD_5                    Must exist on ACL Annual Values table for year 2003/04 with      IF A10 =10 AND                             E                Y    Y    Y     Y     Y         B/O
                                             valid status (1 or 2) for ACL-funded aims                        ACL_STATUS_CODE IN
                                                                                                              ACL_ANNUAL_VALUES IN LAD (for
                                                                                                              record with Academic_Year= 0304)
                                                                                                              NOT=('1' OR '2')
New         A09_A10_LAD_6                    Must exist on WBL Annual Values table for year 2003/04 with      IF (A10 =40 OR A10=41) AND                 E           Y              Y     Y     Y         B/O
                                             valid status (1 or 2) for WBL-funded aims                        WBL_STATUS_CODE IN
                                                                                                              WBL_ANNUAL_VALUES IN LAD (for
                                                                                                              record with Academic_Year= 0304)
                                                                                                              NOT=('1' OR '2')
New         A09_A10_LAD_7                    Must exist on All Annual Values table for year 2003/04 with      IF A10=(30 or 42 or 70 or 80 or 99)        E    Y      Y    Y    Y    Y     Y     Y    Y    B/O
                                             valid status (1 or 2) for aims which are not FE-, WBL- or ACL-   AND NON_LSC_FUNDED_STATUS
                                             funded                                                           IN ALL_ANNUAL_VALUES IN LAD
                                                                                                              (for record with Academic_Year=
                                                                                                              0304) NOT=('1' OR '2')

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

New         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.
New         A09_A15_A16_A27_A51_AD01_LAD_1   The number of on-programme payments must not be greater          IF A27 >= 1/08/2003 AND A15 NOT =          E           Y              Y     Y     Y         B/O
                                             than the Standard Length of Stay for the programme for all       04 AND A51 >
                                             programme type except NVQ level 1 for starts on or after         AVERAGE_MONTHS_STAY read
                                             1/08/2003                                                        from FUNDING_LEVEL using a key
                                                                                                              built from LEARNER_PROGRAMME
                                                                                                              (derived from A15 and A16, AD01,
                                                                                                              FUNDING CATEGORY (read from
                                                                                                              LAD))




LSC 11/15/2010                                                                                                                 Cross field validation                                                                                  Page 18 of 29 / 2003/04
                                                                                                                    74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                                                ESF
From                                                                                                                                                           FE/UFI WBL ACL SR                      FE
02/03       Rule                             Rule Description                                                   Metadata                                   E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
New         A09_A15_A16_A27_A51_AD01_LAD_2   The number of on-programme payments should not be greater          IF A27 < 1/08/2003 AND A15 NOT =            W          Y               Y    Y    Y         B/O
                                             than the Standard Length of Stay for the programme for all         04 AND A51 >
                                             programme types except NVQ level 1 for starts before               AVERAGE_MONTHS_STAY read
                                             1/08/2003                                                          from FUNDING_LEVEL using a key
                                                                                                                built from LEARNER_PROGRAMME
                                                                                                                (derived from A15 and A16, AD01,
                                                                                                                FUNDING CATEGORY (read from
                                                                                                                LAD))

New         A09_A15_LAD_1                    If a framework completion class code is used then the              if FLAG11 in LEARNING_AIM on LAD            E           Y              y     y     y         B/O
                                             programme type must be AMA or FMA                                  ="Y" AND A15 not = 02 or 03
New         A09_A16_A27_LAD_1                If LAD record has an Approval_End_Date, then learners              IF APPROVAL_END_DATE NOT=                  W     Y      Y    Y    Y    Y     Y     Y         B/O This is a warning because apparently providers can
                                             should not start after that date.                                  Null AND A16 = (05 or 00) AND A27>                                                               exceptionally be given permission to start aims after the
                                                                                                                APPROVAL_END_DATE                                                                                approval end date.
            A09_A17_A32_H21_LAD_1            If the Aim is HE level and the Delivery Mode is (Continuous        IF ENGLAND_FE_HE_STAT_CODE                 W     Y                     Y     Y     Y         B/O
                                             Delivery - Daytime or Sandwich) AND Guided Learning Hours          = 'H' on LEARNING_AIM table in LAD
                                             >449 the Term-Time Accommodation field must be completed           AND A17 = (1 OR 4) AND A32 > 449
                                                                                                                AND H21 = 0

            A09_A18_LAD_1                    For NVQ delivery methods, the aim must should be an NVQ in IF A18 = 11 OR 12 OR 13 AND                         E    Y                     Y     Y     Y         B/O
                                             LAD                                                        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 ENGLAND_FE_HE_STAT_CODE                         W     Y                     Y     Y     Y         B/O
                                             Employer Provision AND Guided Learning Hours >449 the      = 'H' on LEARNING_AIM table in LAD
                                             Term-Time Accommodation field must be completed            AND A19 = 3 AND A32 > 449 AND
                                                                                                        H21 = 0

New         A09_A26_LAD_1                    If sector framework code is entered, it should match the           IF A26 NOT= 000 and there is no            W            Y              Y     Y     Y         B/O
                                             framework for that learning aim in the LAD                         matching record in
                                                                                                                SECTOR_FRAMEWORK_AIMS with
                                                                                                                ( LEARNING_AIM_REF=A09 and
                                                                                                                SECTOR_FRAMEWORK_CODE=A2
                                                                                                                6)

            A09_A31_H31_LAD_1                If the Aim is HE level and the Actual End Date is completed        IF ENGLAND_FE_HE_STAT_CODE                 W     Y                     Y     Y     Y         B/O
                                             then the Reason for Leaving must be completed                      = '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_DIA_TEST NOT =              E    Y                     Y     Y     Y         B/O
                                             learning outcome grade cannot be one of the grades reserved        'Y' in LEARNING_AIM table AND A36
                                             for such aims                                                      = LN OR L2 OR L1 OR E3 OR E2 OR
                                                                                                                E1
New         A09_A40_A43_L26_LAD1             If the Sector Framework Achievement Date is entered, the           IF FLAG11 on LEARNING_AIM table             E           Y                    Y     Y         B/O Needs to look across years
                                             Achievement Date must be set either on this record or a            in LAD not = "Y" AND A43 >
                                             previous record for the learner for this learning aim and the      00000000 AND A40 = 00000000 on
                                             same learning aim. Except for framework completion                 this record and on all other aim
                                             class codes                                                        records for this learner record with the
                                                                                                                same non-blank NI Number and the
                                                                                                                same learning aim
New         A09_A40_LAD1                     Achievement date must be null for sector framework class           IF FLAG11 on LEARNING_AIM table             E           Y              Y     Y     Y         B/O
                                             codes                                                              in LAD = "Y" AND A40 NOT =
                                                                                                                00000000
            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

Change      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    IF A10 = 20 AND A11a => 511521                 E    Y                     Y     Y          Y    B/O
                                             ESF but is not LSC ESF co-financed, the implied rate of LSC     AND A11a <= 536546 AND A12a =
                                             FE funding for ESF which is not LSC ESF co-financed must        000
                                             not be zero




LSC 11/15/2010                                                                                                                   Cross field validation                                                                                                    Page 19 of 29 / 2003/04
                                                                                                        74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                                 ESF
From                                                                                                                                            FE/UFI WBL ACL SR                      FE
02/03       Rule                 Rule Description                                                    Metadata                               E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
Change      A10_A11b_A12b_1      If the learner is LSC FE funded and the source of funding is        IF A10 = 20 AND A11b => 521 AND         E     Y                    Y    Y          Y   B/O
                                 ESF but is not LSC ESF co-financed, the implied rate of LSC         A11b <= 546 AND A12b = 000
                                 FE 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
New         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 AMA after FMA' the Programme Type must be              NOT = 02                                                                                     validation
                                 'AMA'
New         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                 NOT = 06                                                                                     validation
                                 'NVQ3'
New         A10_A15_A26_1        For WBL funded main aims, Sector code must be entered if            IF A10=40 aND (A15 = 02 OR 03)          E           Y              Y     Y               B/O Reflects downgrade for Maximise PMR change
                                 the programme type = FMA or AMA                                     AND A26 = 000
New         A10_A15_A27_AD01_1   for WBL funded NVQ1 main aims starting after 31 July 2003           if A10=40 AND A15=4 and                 E           Y              Y     Y               B/O
                                 the learner must not be 16-18 years old at start                    A27>31072003 and AD01=1
Change      A10_A15_A31_A40_2    Learning actual end date mandatory if NVQ achievement date          IF A10 = 40 AND A40 NOT = NULL          E           Y              Y     Y               B/O
                                 is entered for NVQ Learning programme types for WBL funded          AND A31 = NULL AND A15 = 04 OR
                                 aims                                                                05 OR 06 OR 07
New         A10_A15_A31_A43_1    Learning actual end date mandatory if framework achievement         IF A10=40 AND A43 NOT= null AND         E           Y              Y     Y               B/O
                                 date is entered for FMA/AMA WBL funded aims                         A31 = null AND A15 = 02 OR 03

New         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)

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

New         A10_A15_A35_A40_2    If the Achievement Date is entered then the Learning Outcome IF A40 NOT = 00000000 AND A35                  E           Y              Y     Y               B/O
                                 must be 'achieved' for all learning aims except FMA and AMA NOT = 1 AND NOT (A15=(02 or 03)
                                 main aims                                                      and A10=40)
New         A10_A15_A35_A40_3    If the Learning Outcome is 'achieved' then the Achievement     if A35 = 1 AND A40 = 00000000 AND            E           Y              Y     Y               B/O
                                 Date must be entered for all learning aims except FMA and      NOT (A15=(02 or 03) and A10=40)
                                 AMA main aims
            A10_A15_A35_A43_1    For WBL funded FMA and AMA main aims, if the Learning          IF A10=40 AND A15 = 02 OR 03 AND             E           Y              Y     Y               B/O Raised in Release 1 acceptance testing
                                 Outcome is achieved, the Framework Achievement Date must A35 = 1 AND A43 = 00000000
                                 be entered
New         A10_A15_A37_1        Number of units must not be entered for WBL funded E2E         IF A10 = 40 AND A15 = 09 AND A37             E           Y              Y     Y               B/O
                                 main aims.                                                     NOT = 00
New         A10_A15_A38_1        Number of units to achieve full qualification must not be      IF A10 = 40 AND A15 = 09 AND A38             E           Y              Y     Y               B/O
                                 entered for WBL funded E2E main aims.                          NOT = 00
New         A10_A15_A51_1        The on programme payments should be greater than zero for      IF A51 = 00 AND A10 = 40 AND A15            W            Y              Y     Y               B/O
                                 aims that are WBL funded main aims except for E2E.             NOT = 09
New         A10_A15_A53_1        Additional learning needs data must be entered for aims that   IF A53 = NULL AND A10 = 40 AND               E           Y              Y     Y               B/O
                                 are WBL funded main aims unless they are entry to              a15 Not = 09
                                 employment.
New         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.
New         A10_A16_2            Programme entry route must not be entered for an LSC           IF A10 NOT = 40 and A16 NOT = null           E           Y              Y     Y               B/O
                                 funding stream other than WBL main aim.
New         A10_A24_1            Occupation relating to learning aim must not be entered for    IF A10 = 10 AND A24 NOT = 0000               E                Y         Y     Y               B/O
                                 ACL funded aims.
New         A10_A26_1            Sector code must not be entered except on WBL funded main IF A10 NOT =40 AND A26 NOT =                      E           Y              Y     Y               B/O Reflects downgrade for Maximise PMR change
                                 aims                                                           NULL
New         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
            A10_A27_L11_1        Must be under 25 years old at start for WBL funded aims        IF A27 - L11 => 25 years AND A10 =           E           Y              Y     Y               B/O
                                                                                                40




LSC 11/15/2010                                                                                                     Cross field validation                                                                                                   Page 20 of 29 / 2003/04
                                                                                                       74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                                ESF
From                                                                                                                                           FE/UFI WBL ACL SR                      FE
02/03       Rule                   Rule Description                                                 Metadata                               E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
Change      A10_A27_L11_4          Must be over school leaving age at start for WBL funded aims     IF A10 = 40 AND A27 - L11 <16 years W              Y               Y    Y              B/O
                                                                                                    AND NOT(A27 - L11 = 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)

New         A10_A27_T08_1          Start date must be on or before file creation date for WBL       If A10 = 40 and A27 > T08               E       Y              Y     Y                  B
                                   funded main aims
New         A10_A31_A40_1          For WBL funded main aims, if an achievement date is entered      IF A10 = 40 AND A40 > A31 AND           E       Y              Y     Y                 B/O
                                   it must be on or before the learning actual end date             A40 NOT = 00000000
New         A10_A31_A50_1          If there is no learning actual end date then Reason Learning     IF A10 = 40 AND A31 = 0 and A50         E       y              y      y                B/O
                                   Ended must be continuing for WBL main aims                       NOT = 96
Change      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 should be FE funded
New         A10_A51_1              On programme payments data must not be entered for aims          IF A51 NOT = 00 AND A10 NOT = 40        E       Y              Y     Y                 B/O
                                   that are not WBL funded main aims.
New         A10_A53_1              Additional learning needs data must not be entered for aims      IF A53 NOT = NULL AND A10 NOT =         E       Y              Y     Y                 B/O
                                   that are not WBL funded main aims.                               40
New         A10_E22                If the funding stream is 70 then the project dossier number      If A10 = 70 AND E22 = spaces            E   Y   Y         Y    Y     Y                 B/O
                                   must be entered
New         A10_E23                If the funding stream is 70 then the local project number must   If A10 = 70 AND E23 = spaces            E   Y   Y         Y    Y     Y                 B/O
                                   be entered
Change      A10_L11_1              FE funded learners should not be 14 or younger on 31st           IF A10 = 20 AND L11 > 310819878         W   Y                  Y     Y                 B/O
                                   August of the current teaching year
Change      A10_L11_3              Non-FE funded learners should not be 100 or older on 1st       IF A10 NOT = 20 AND L11 <                 W   Y             Y    Y     Y                 B/O
                                   January of the current teaching year                           010119034
            A10_L24_1              Learner is not eligible for LSC FE or WBL funding if the       IF A10 = 20 OR 40 AND L24 NOT (on         W   Y   Y              Y     Y                 B/O
                                   learner's country of domicile is not in the European Union     table of European Union Country
                                                                                                  Codes)
            A11a _A11b_A17_H17_1   For learners who are HEFCE funded or eligible for HEFCE        IF H17 NOT = 000.0 AND ((A11a =           E   Y                  Y     Y                 B/O
                                   funding and where the delivery mode is Absent for Year, the    001 OR 002) OR (A11b = 001 OR
                                   Learner FTE 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

            A11a_A11b_H17_1        The FTE must be entered if the aim is HEFCE funded or            IF H17 = 000.0 AND ((A11a = 001 OR      W   Y                  Y     Y                 B/O
                                   eligible for HEFCE funding                                       002) OR (A11b = 001 OR 002))
Change      A11a_A12a_1            If the source of funding is not 'ESF but not LSC ESF co-         IF A12a NOT = 000 AND A11a < 511        E   Y                  Y     Y                 B/O
                                   financed', the implied rate of LSC FE funding for ESF which is   OR > 546
                                   not LSC ESF co-financed must be zero
            A11a_A17_A32_H21_1     For learners who are HEFCE funded or eligible for HEFCE          IF A11a = (001 OR 002) AND A17 =        W   Y                  Y     Y                 B/O
                                   funding and where the delivery mode is continuous delivery       (1 OR 4) AND A32 > 00449 AND H21
                                   daytime or sandwich and where the guided learning hours are      =0
                                   more than 449, the term time accommodation field must be
                                   completed
            A11a_A19_A32_H21_1     For learners who are HEFCE funded or eligible for HEFCE          IF A11a = (001 OR 002) AND A19 =        W   Y                  Y     Y                 B/O
                                   funding and where the employer role is learner is attending      3) AND A32 > 00449 AND H21 = 0
                                   dedicated 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          IF A11a = (001 OR 002) AND A31          W   Y                  Y     Y                 B/O
                                   funding and where the learning actual end date is completed,     NOT = 00000000 AND H31 = 00
                                   the reason for leaving should be completed
            A11a_H27_N08_1         For the last 2 FE returns of the year, for learners who are      IF N08 = ('F04' OR 'F05') AND A11a =    W   Y                  Y     Y                  B    Replaces A11a_H27_T06_1
                                   HEFCE funded or eligible for HEFCE funding the A/AS level        (001 OR 002) AND H27 = 00
                                   score should be non-zero




LSC 11/15/2010                                                                                                     Cross field validation                                                                                  Page 21 of 29 / 2003/04
                                                                                                              74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                                        ESF
From                                                                                                                                                   FE/UFI WBL ACL SR                      FE
02/03       Rule                 Rule Description                                                          Metadata                                E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
Change      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
                                 should not be 16 or younger on 31st July of the current                   >31071987
                                 teaching year
Change      A11b_A12b_1          If the source of funding is not 'ESF but not LSC ESF co-                  IF A12b NOT = 000 AND A11b < 511         E    Y                     Y     Y               B/O
                                 financed', the implied rate of LSC FE funding for ESF which is            OR > 546
                                 not LSC ESF co-financed must be zero
            A11b_A17_A32_H21_1   For learners who are HEFCE funded or eligible for HEFCE                   IF A11b = (001 OR 002) AND A17 =        W     Y                     Y     Y               B/O
                                 funding and where the delivery mode is continuous delivery                (1 OR 4) AND A32 > 00449 AND H21
                                 daytime or sandwich and where the guided learning hours are               =0
                                 more than 449, the term time accommodation field should
                                 must be completed
            A11b_A19_A32_H21_1   For learners who are HEFCE funded or eligible for HEFCE                   IF A11b = (001 OR 002) AND A19 =        W     Y                     Y     Y               B/O
                                 funding and where the employer role is learner is attending               3) AND A32 > 00449 AND H21 = 0
                                 dedicated employer provision and where the guided learning
                                 hours are more than 449, the term time accommodation field
                                 should must be completed
            A11b_A31_H31_1       For learners who are HEFCE funded or eligible for HEFCE                   IF A11b = (001 OR 002) AND A31          W     Y                     Y     Y               B/O
                                 funding and where the learning actual end date is completed,              NOT = 00000000 AND H31 = 00
                                 the reason for leaving should be completed
            A11b_H27_N08_1       For the last 2 FE returns of the year, for learners who are               IF N08 = ('F04' OR 'F05') AND A11b =    W     Y                     Y     Y                B    Replaces A11b_H27_T06_1
                                 HEFCE funded or eligible for HEFCE funding the A/AS level                 (001 OR 002) AND H27 = 00
                                 score should 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
                                 should not be 16 or younger on 31st July of the current                   >31071986
                                 teaching year
            A13_A14_1            Reason for partial or full non-payment of tuition fees must not           IF A14 = 99 AND A13 = 00000              E    Y           Y         Y     Y               B/O
                                 be ‘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      IF A14 = 19 AND A13 NOT = 00000          E    Y           Y         Y     Y               B/O
                                 is zero, Tuition fee received for year must be 0.
            A14_H20_1            Reason for partial or full non-payment of tuition fees must not           IF A14 = 99 AND H20 = 98                 E    Y                     Y     Y               B/O
                                 be 'fees paid in full' if the major source of tuition fees is 'no fees'

change      A14_L11_1            Reason for partial or full non-payment of tuition fees must not           IF L11 < 01081938 AND A14 = 15           E    Y                     Y     Y               B/O Learners of pensionable age cannot claim job seeker's
                                 be Job seeker’s allowance if the learner is 65 or over at the 1st                                                                                                       allowance
                                 of August of the training year.
change      A14_L11_2            Reason for partial or full non-payment of tuition fees must not           IF L11 < 01081980 AND A14 = 01           E    Y                     Y     Y               B/O Providers cannot charge fees to 16-18 year olds and this
                                 be ‘fees waived - 16-18 year old learner; provision funded by                                                                                                           is the absolute limit of age of learners with 16-18 eligibility
                                 the LSC’, if the learner is 23 or over at the 1st August of the
                                 training year.
Change      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 Reflects downgrade for Maximise PMR change
                                 FMA and AMA                                                               NOT = 000
Change      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 RFC 1295
                                 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 AMA and FMA                                               NOT = (02 OR 03)
New         A15_A50_1            To progress from E2E you must be in E2E                                   F A50 = 20 OR 21 OR 22 AND A15           E           y              Y     Y               B/O
                                                                                                           NOT = 09
New         A15_A51_1            If programme type is not AMA, FMA or NVQ learning, OPPs                   IF A15 NOT = (02 OR 03 OR 04 OR          E           Y              Y     Y               B/O
                                 must be zero                                                              05 OR 06 OR 07) AND A51 NOT = 0

New         A15_A53_1            If programme type is not AMA, FMA or NVQ learning,                        IF A15 NOT = (02 OR 03 OR 04 OR          E           Y              Y     Y               B/O
                                 Additional learning needs data must not be entered.                       05 OR 06 OR 07) AND A53 NOT = 0

New         A15_L28a_2           If programe type is E2E the first part of eligibility for enhanced        IF A15 = 09 AND L28a NOT = 00           W            Y              Y     Y               B/O
                                 funding should be null
New         A15_L28b_2           If programe type is E2E the second part of eligibility for                IF A15 = 09 AND L28b NOT = 00           W            Y              Y     Y               B/O
                                 enhanced funding should be null
New         A16_A26_A27_LAD_1    If sector framework code is entered, and if that framework has            IF A26 NOT=000 AND                       E           Y              Y     Y     Y         B/O Many sector codes are no longer valid for new framework
                                 a non-null 'EFFECTIVE_TO' date, then learner must not start               EFFECTIVE_TO (from                                                                            programmes
                                 after that date if the Programme Entry Route is 'First-Time               SECTOR_FRAMEWORKS table)
                                 Entrant' and start date is after 31/07/2003                               NOT=Null AND A16=05 AND
                                                                                                           A27>EFFECTIVE_TO (from
                                                                                                           SECTOR_FRAMEWORKS table) and
                                                                                                           A27>31/07/2003
New         A16_A27              the programme entry type must be not be direct for learning               IF A16 = 01 and A27 > 01/08/2003         E           Y              Y     Y               B/O
                                 aims starting after 1 August 2003




LSC 11/15/2010                                                                                                            Cross field validation                                                                                                      Page 22 of 29 / 2003/04
                                                                                                  74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                            ESF
From                                                                                                                                       FE/UFI WBL ACL SR                      FE
02/03       Rule            Rule Description                                                   Metadata                                E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
            A17_A32_1       If the Delivery Mode is 'Absent for the year', the Guided          IF A17 = 6 AND A32 NOT = 0               E     Y                    Y    Y          Y   B/O
                            Learning Hours must be zero
New         A17_A32_2       The guided learning hours should not be zero unless the            IF A17 NOT = 6 AND A32 = 0              W     Y                     Y     Y               B/O
                            Delivery Mode is 'absent for the year'.
New         A18_A52_1       The main delivery method must be distance learning or e-           IF A52 > 00000 AND A18 NOT = 03          E    Y                     Y     Y          Y    B/O
                            learning or NVQ delivered at the workplace if the distance         OR 05 OR 12 OR 13
                            learning funding 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
New         A26_A43_1       The sector framework achievement date must not be                  IF A43 NOT = 00000000 AND A26 =          E           Y              Y     Y               B/O
                            completed when the sector framework of learning is not             000
                            completed.
            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        IF A28 - A27 => 20years                  E    Y      Y    Y    Y    Y     Y          Y    B/O Make rule apply on-line as well
                            date
            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                B
                            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,      IF A32 > 60 AND the integer part        W     Y           Y         Y     Y                B
                            and 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          IF A32/(A28-A27+1) > 9 AND              W     Y           Y         Y     Y                B
                            number 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   IF A31 NOT = 00000000 AND A31 <          E    Y      Y    Y    Y    Y     Y          Y    B/O
                            date                                                               A27
Change      A27_A40_1       NVQ achievement date must be greater than or equal to the          IF A40 NOT NULL AND A40 NOT >            E           Y              Y     Y               B/O
                            start 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      IF E08 < A27                             E    Y      Y         Y    Y     Y               B/O
                            on 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
Change      A27_L11_2       Must Should be more than 12 years old at start for non WBL         IF A27 - L11 < 12 years AND A10          E           Y         Y    Y     Y               B/O
                            funded programmes                                                  NOT = 40
            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 Must be more than 4 years old at start                      IF A27 - L11 < 4 years                  W     Y                     Y     Y               B/O
Delete      A27_T08_1       Start date must be on or before file creation date                 IF A27 > T08                            E            Y    Y    Y    Y     Y                B
Change      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.
Change      A31_A34_2       Completion status must be ‘the learner is continuing or            IF A34 NOT = 1 AND A31 = 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 not completed.

New         A31_A43_1       The sector framework achievement date must not be after the        IF A43 NOT NULL AND A43 > A31            E           Y              Y     Y               B/O
                            learning actual end date




LSC 11/15/2010                                                                                                Cross field validation                                                                                           Page 23 of 29 / 2003/04
                                                                                                 74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                           ESF
From                                                                                                                                      FE/UFI WBL ACL SR                      FE
02/03       Rule          Rule Description                                                    Metadata                                E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
New         A31_A50_2     If there is a learning actual end date then the learner must not    IF A50 = 96 and A31 NOT=0                E          y               y    y              B/O
                          be 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_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           IF A35 NOT = 9 AND A34 = 1               E    Y           Y         Y     Y               B/O
                          intending to 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               IF A39 = 1 OR 2 AND A34 = 1              E    Y                     Y     Y          Y    B/O
                          'achievement funding claimed' or 'partial achievement funding
                          claimed' the Completion status must should 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 '        E    Y                     Y     Y               B/O
                          grade is 'FL', 'U ', N ', 'X ' or 'Y '                              OR 'N ' OR 'X ' OR 'Y '
            A35_A36_2     Learning Outcome Grade must be set to 'FL','U ', 'N ', 'X ', 'Y '   IF A35 = 3 AND A36 NOT = ('FL' OR        E    Y                     Y     Y               B/O
                          or ' ' 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             IF A35 = 4 OR 5 OR 9 AND A36 NOT          E    Y                     Y     Y               B/O
                          outcome is ‘exam taken but result not known’, ‘learning            = spaces
                          activities are 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             IF A35 = 2 AND A37 = 0                   E    Y                     Y     Y          Y    B/O
                          completed
            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'
Change      A35_A43_1     If the Sector Framework Achievement Date is entered then the        IF A43 NOT = 00000000 AND A35           W            Y              Y     Y               B/O
                          Learning Outcome must be 'achieved'                                 NOT = 1
Change      A40_T08_1     NVQ Achievement date must be on or before the file creation         IF A40 > T08                             E           Y              Y     Y                B
                          date
            A46a_A46b_1   National Learning Aim Monitoring values must be different           IF A46a NOT = 99 AND A46a = A46b         E    Y      Y    Y         Y     Y               B/O
                          unless they are both 99
            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
            E08_T08_1     ESF Start date must be on or before file creation date              E08 > T08                                E    Y      Y         Y    Y     Y                B
            E12_E13_2     If Employment Status on day before start is unemployed              IF E12 = 04 AND E13 NOT = 03             E    Y      Y         Y    Y     Y               B/O
                          learner's employment status must be unemployed
New         E12_E13_4     If Employment Status on day before start is employed,               IF E12= 01 AND E13 = 03                  E    Y      Y         Y    Y     Y               B/O
                          learner's employment status cannot be unemployed
Change      E12_E14_2     Length of Unemployment must be Not Unemployed or Not                IF E12 NOT = 04 AND (E14 NOT =           E    Y      Y         Y    Y     Y               B/O
                          Known/not provided if Employment Status at start is not             99 Or E14 Not =98)
                          Unemployed
New         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.
Change      E16abcde_1    Addressing Gender Stereotyping entries must should all be          IF E16a = (E16b OR E16c OR E16d           E    Y      Y              Y     Y               B/O
                          different if entered                                               OR E16e) OR E16b = (E16c OR
                                                                                             E16d OR E16e) OR E16c = (E16d or
                                                                                             E16e) OR E16d = E16e
Change      E17abcde_1    Main Co-financing Activity entries must should all be different if IF E17a = (E17b OR E17c OR E17d           E    Y      Y         Y    Y     Y               B/O
                          entered                                                            OR E17e) OR E17b = (E17c OR
                                                                                             E17d OR E17e) OR E17c = (E17d or
                                                                                             E17e) OR E17d = E17e
New         E18abcd_1     Delivery Mode entries must all be different if entered             IF E18a = (E18b OR E18c OR E18d)          E    Y      Y              Y     Y               B/O
                                                                                             OR E18b = (E18c OR E18d) OR E18c
                                                                                             = 18d




LSC 11/15/2010                                                                                               Cross field validation                                                                                  Page 24 of 29 / 2003/04
                                                                                                           74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                                      ESF
From                                                                                                                                                 FE/UFI WBL ACL SR                      FE
02/03       Rule                 Rule Description                                                       Metadata                                 E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
New         E19abcde_1           Support measures to be accessed by the learner entries must            IF E19a = (E19b OR E19c OR E19d           E     Y    Y               Y    Y              B/O
                                 all be different if entered                                            OR E19e) OR E19b = (E19c OR
                                                                                                        E19d OR E19e) OR E19c = (E19d or
                                                                                                        E19e) OR E19d = E19e
New         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
            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                 IF H20 = 02 OR 04 AND L24 = 299          W     Y                     Y     Y               B/O
                                 Country of Domicile
            H20_L24_2            Major Source of Tuition Fees should be consistent with                 IF H20 = 02 OR 03 AND L24 = 099          W     Y                     Y     Y               B/O
                                 Country of Domicile
            H20_L24_3            Major Source of Tuition Fees should be consistent with          IF H20 = 03 OR 04 AND L24 = 399                 W     Y                     Y     Y               B/O
                                 Country of Domicile                                             OR 599
            L01_L02_L03_L11_1    When changing a record for a learner, the learner should must   IF L01 AND L02 AND L03 exist                    W            Y         Y          Y     Y          B
                                 have the same date of birth as the record already in the system onLEARNER_EVENTS and L11 NOT
                                                                                                 = DATE_OF_BIRTH in
                                                                                                 LEARNER_EVENTS
New         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
New         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           IF N03 NOT = L01 AND L01 AND                     E           Y         Y          Y     Y          B    Prevent the inclusion of incorrect UPINs in multi-provider
                                 structure in PIMS as the provider number in the file name       N03 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.

New         L11_L28a_1           If the age at 1 August 2003 is over 23 then Eligibility for            IF 1st of August 2003 - L11 > 23          E    Y                     Y     Y               BO
                                 enhanced funding must not be ‘16-18 funding entitlement and            years AND L28a = (12 OR 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'

New         L11_L28b_1           If the age at the 1 august 2003 is over 23 then Eligibility for        IF 1st of August 2003 - L11 > 23          E    Y                     Y     Y               BO
                                 enhanced funding must not be ‘16-18 funding entitlement and            years AND L28b = (12 OR 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'

            L14_L15_1            Disability or Health Problem must be set to ‘Not                       IF L14 = 9 AND L15 NOT = 99               E    Y      Y              Y     Y               B/O
                                 known/information 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            E    Y      Y              Y     Y               B/O
                                                                                                        099 OR 299 OR 599) AND L17 =
                                                                                                        SPACES
            L17_L32_1            Eligibity for Disadvantage Uplift must not be ‘from deprived           IF L32 = 01 and L17(1,4) = 'ZZ99'         E    Y                     Y     Y               B/O
                                 area (ward based uplift) – postcode on Council’s file’, if the first
                                 4 characters of the postcode are [ZZ99].
New         L25_L44_1            delivery locations must be present for NCS contracts                 if L25=002 and L44=null                     E           Y              Y     Y               B/O
New         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




LSC 11/15/2010                                                                                                          Cross field validation                                                                                                    Page 25 of 29 / 2003/04
                                                                                           74ee86bf-9829-4e48-b5eb-d52470ba1873.xls




                                                                                                                                                     ESF
From                                                                                                                                FE/UFI WBL ACL SR                      FE
02/03       Rule          Rule Description                                                Metadata                              E/W Rule   Rule Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
            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)
            L28a_L28b_1   Entries for Eligibility for enhanced funding must be different  IF L28a = L28b AND L28a NOT = 99       E    Y                     Y     Y               B/O
                          unless they are both 99
New         L28a_L28b_2   Entries for Eligibility for enhanced funding must be different  IF L28a = L28b AND L28a NOT = 99       E           Y              Y     Y               B/O
                          unless 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    NOT = 99
                          factor 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                                                                   IF
                          Learner Support Reasons must all be different unless they are 99 L34a NOT = 99 AND L34a = L34b         E    Y      Y              Y     Y               B/O

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

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

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

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

New         L34c_L34d_1                                                                   IF
                          Learner Support Reasons must all be different unless they are 99 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   IF L38 = 00 AND L39 NOT = 95              E           Y              Y     Y               B/O
                          code anything other than 'continuing existing programme of
                          learning'




LSC 11/15/2010                                                                                         Cross field validation                                                                                  Page 26 of 29 / 2003/04
Explanation of colours used

Changes that apply in LIS 11.01 and OLDC system release 1 and onwards
Changes that apply in LIS 11.02 and OLDC system release 2 and onwards

				
DOCUMENT INFO
Description: Blank Printable Resume document sample