Docstoc

Printable Blank Birth and Death Certificates

Document Sample
Printable Blank Birth and Death Certificates Powered By Docstoc
					                                                                          6243854d-c878-4edd-973b-773ced327163.xls



          FILENAME VALIDATION


                                                                                                                                      FE
                                                                                                                                      an
From                                                                                                                                   d          ESF   External                  Reject
2003/04 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
                                                         N01_4                      Transmission number must be greater than          Y   Y   Y   Y        Y        E     N       Y         Y
                                                                                    previous transmission
                                                         N01_5                      Transmission number should be 1 greater than      Y   Y   Y   Y        Y       W      N       Y        N
                                                                                    last transmission number received
          N02          File Type                     1 N02_1         alphanumeric   Must be 'A' or 'B'                                    Y       Y                 E     Y       y         Y
                                                       N02_2                        must be A                                         Y       Y                     E     Y       Y         Y
          N03          Provider Number               6 N03_2         numeric        Value must exist on database                      Y   Y   Y   Y        Y        E     Y       Y         Y
          N03a         Contract/Allocation           2 N03a_1        numeric        Must be numeric                                   Y   Y   Y   Y                 E     Y       Y         Y
                       Type
                                                       N03a_2                          Must be 00                                         Y   Y   Y                 E     Y       Y         Y
                                                       N03a_3                          Must exist on table                            Y                    Y        E     Y       Y         Y
          N04          LSC Number of                 3 N04_1         numeric           Must be numeric                                Y   Y   Y   Y                 E     Y       Y         Y
                       funding LSC
                                                       N04_2                           Value must exist on database or be '999'           Y       Y        Y        E     Y       Y         Y
                                                       N04_3                           Value must be 000                              Y       Y                     E     Y       Y         Y
Change N05             Year of Submission            4 N05_1         numeric           Must be current year (e.g. 0405)               Y   Y   Y   Y                 E     Y       Y         Y
       N06             Transmission Number           3 N06_1         numeric           Must be 3 character numeric                    Y   Y   Y   Y                 E     Y       Y         Y
       N07             Serial Number                 2 N07_1         numeric           Must be 2 digit numeric (starts at 01)         Y   Y   Y   Y                 E     Y       Y         Y
                                                       N07_2                           Must not be 00                                 Y   Y   Y   Y                 E     Y       Y         Y
Change N08             Collection Period               N08_1         alphanumeric      Must be 3 characters in the range W01 to W13   Y   Y   Y   Y                 E     Y       Y         Y
                                                                                       or the range F01 to F05 or the range C01 to
                                                                                       C03 or the range S01 to S12 or the range U01
                                                                                       to U05 or the range X01 to X99

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



LSC 7/8/2011                                                                              File Level                                                               Page 1 of 26 / 2003/04 DRAFT 1b
                                                                          6243854d-c878-4edd-973b-773ced327163.xls



          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       T12a         Software Supplier            40 T12_1         alphanumeric      May be any printable characters except for [*]       Y   Y   Y   Y                E     Y       Y         Y
                       name                                                            and [?] and [%] and [_]




New       T12b         Product name                 30 T12_1         alphanumeric      May be any printable characters except for [*]       Y   Y   Y   Y                E     Y       Y         Y
                                                                                       and [?] and [%] and [_]




New       T12c         Version Number               20 T12_1         alphanumeric      May be any printable characters except for [*]       Y   Y   Y   Y                E     Y       Y         Y
                                                                                       and [?] and [%] and [_]




          T13      Reserved for LIS                                  alphanumeric
          FOOTER RECORD VALIDATION

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

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




LSC 7/8/2011                                                                              File Level                                                                    Page 2 of 26 / 2003/04 DRAFT 1b
                                                                                                                    6243854d-c878-4edd-973b-773ced327163.xls




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

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

          R11       The number of Aims records should match the count of aims in the learner record and     Y   Y     Y     Y    E     Y      Y            Y   change description
                    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 and     Y   Y     Y     Y    E     Y      Y
                    must be 00 or 01
          R20       A learner must only have one LSC WBL-funded main aim at any one time                        Y                E     Y      Y                           Changed back to orignal rule
          R21       At any one time, a learner should have one open aim per non-generic aim reference for       Y                E     Y      Y
                    a given funding stream.
          R23       If A31 is not null on all aims for a learner then L39, Destination cannot be 95             Y                E     Y      Y
New       R24       A learner must not have more than one aim where A10=40 and A31 = null                       Y                                              To
                                                                                                                                                               prevent
                                                                                                                                                               learners
                                                                                                                                                               having
                                                                                                                                                               more than
                                                                                                                                                               one aim
                                                                                                                                                               open at
                                                                                                                                                               any one
                                                                                                                                 E     Y      Y                time      Changed in v 0.2

2003/04 rules that are deleted for 2004/05
Delete    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                Will not apply under the new rules where the main aim will not necessarily be the first aim the learner starts
                    same learner (based on L01 and L03) with A10=40 and A15=(02 or 03)




LSC 7/8/2011                                                                                                                 Cross Record Validation                                                                                                         Page 3 of 27 / 2003/04 DRAFT 1b
                                                                             6243854d-c878-4edd-973b-773ced327163.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




LSC 7/8/2011                                                                              Import Validation                                  Page 4 of 27 / 2003/04 DRAFT 1b
                                                            6243854d-c878-4edd-973b-773ced327163.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             Calculated by subtracting Date of Birth (L11) from       Y     Y
                                                                                               Learning Start Date (A27) Programme start date
                                                                                               (AD02) and truncate to derive age. Age bands are
                                                                                               '1' 16-18 and '2' 19-24 and '3' 25+. Age band 1 will
                                                                                               also include 15 year olds whose birthday lies
                                                                                               between the last Friday in June and the 1st of
                                                                                               September and whose learning start date is in the
                                                                                               same date range and learners where one of the
                                                                                               Eligibility for Enhanced Funding fields has '15' in it.



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




LSC 7/8/2011                                                         Derived Data for Validation                                               Page 5 of 27 / 2003/04 DRAFT 1b
                                                                                                              6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                           FE/U           ESF
From                                                                                                                            Metadata Description        FI  WBL ACL SR                       FE   Batch/
03/04     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   Reason for change
          L01_2     L01       Provider number                 Y  Y   Y Y         Must exist on table                                                    E   Y    Y    Y    Y       Y    Y    Y         B/O
          L02_1     L02       Contract/Allocation Type        Y                  Must exist on table                                                    E   Y                      Y    Y              B/O
          L02_2     L02       Contract/Allocation Type        Y  Y   Y           Must be 00                                                             E        Y    Y    Y       Y    Y              B/O
          L03_1     L03       Learner reference number        Y  Y   Y Y         Mandatory                                                              E   Y    Y    Y    Y       Y    Y              B/O
          L03_2     L03       Learner reference number        Y  Y   Y Y         Only acceptable characters are [A to Z], [a                            E   Y    Y    Y    Y       Y    Y              B/O
                                                                                 to z], [0 to 9] and [ ].
                    L04       Data set identifier code       Y   Y   Y     Y
          L05_1     L05       Learning aims data sets        Y   Y   Y     Y     Must be > 00                                                           E   Y         Y           Y    Y               B/O
          L06_1     L06       ESF co-financing data sets     Y   Y   Y     Y     Must be 00                                                             E   Y    Y    Y    Y      Y    Y                B
          L07_1     L07       HE data sets                   Y   Y   Y     Y     Must be 00                                                             E   Y    Y    Y    Y      Y    Y                B
          L08_1     L08       Deletion flag                      Y         Y     Must be 'Y' or 'N'                                                     E        Y         Y      Y    Y                B
          L08_2     L08       Deletion flag                      Y         Y     Must be space                                                          E   Y         Y           Y    Y                B
          L09_1     L09       Learner surname/family name    Y   Y         Y     Mandatory                                                              E   Y    Y         Y      Y    Y               B/O

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

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




LSC 7/8/2011                                                                                                                Field Level Validation                                                                              Page 6 of 26 / 2003/04 DRAFT 1b
                                                                                                                   6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                 FE/U           ESF
From                                                                                                                                  Metadata Description        FI  WBL ACL SR                       FE   Batch/
03/04     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   Reason for change
          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], [a                             E   Y    Y         Y       Y    Y              B/O
                                                                                      to z], [0 to 9], commas, hyphens,
                                                                                      apostrophes, slashes, full stops,
                                                                                      ampersands, exclamation marks, open
                                                                                      and close brackets, plus signs, colons,
                                                                                      semi-colons, @ and spaces.
          L20_2     L20        Address line 3                     Y   Y         Y     Must be spaces                                                          E             Y           Y    Y               B/O
          L21_1     L21        Address line 4                     Y   Y         Y     Only acceptable characters are [A to Z], [a                             E   Y    Y         Y      Y    Y               B/O
                                                                                      to z], [0 to 9], commas, hyphens,
                                                                                      apostrophes, slashes, full stops,
                                                                                      ampersands, exclamation marks, open
                                                                                      and close brackets, plus signs, colons,
                                                                                      semi-colons, @ and spaces.
          L21_2     L21        Address line 4                     Y   Y         Y     Must be spaces                                                         E              Y           Y    Y               B/O
          L22_1     L22        Current Postcode                   Y   Y               Should exist on table or be all spaces                                 W    Y    Y                     Y    Y          B/O
          L22_2     L22        Current Postcode                   Y   Y               First part should must exist on table or the                           W    Y    Y                Y         Y           B
                                                                                      whole postcode must be spaces
          L22_3     L22        Current Postcode                   Y   Y               The second part of the postcode must be                                 E   Y    Y                Y    Y               B/O
                                                                                      in the correct format (nXX) where n = 0-9
                                                                                      and XX are capital letters excluding C, I,
                                                                                      K, M, O and V or the whole postcode must
                                                                                      be spaces
          L22_4     L22        Current Postcode                   Y   Y               The first part of the postcode must                                     E   Y    Y                Y    Y               B/O
                                                                                      conform to the format 1 or 2 capital letters
                                                                                      followed by (1 or 2 numbers or 1 number
                                                                                      and a capital letter) or the whole postcode
                                                                                      must be spaces
          L22_5     L22        Current Postcode                   Y   Y               Must be spaces                                                          E             Y    Y      Y    Y               B/O
          L23_1     L23        Telephone number                   Y   Y         Y     Must be left justified (space filled) numeric                           E   Y    Y         Y      Y    Y               B/O
                                                                                      or all spaces or '+' followed by numbers.
                                                                                      Spaces are allowed between numbers.

       L23_2        L23        Telephone number                   Y   Y         Y     Must be spaces                                                          E             Y           Y    Y               B/O
       L24_1        L24        Country of domicile                Y   Y               Must exist on table                                                     E   Y    Y                Y    Y               B/O
       L24_2        L24        Country of domicile                Y   Y               Must be 000                                                             E             Y    Y      Y    Y               B/O
       L25_2        L25        LSC number of funding LSC              Y   Y     Y     Must exist on table and not be 000                                      E        Y    Y    Y      Y    Y    Y          B/O
       L25_3        L25        LSC number of funding LSC              Y   Y     Y     Must be 000                                                             E   Y                     Y    Y               B/O
Change L26_1        L26        National insurance number              Y               The (first character must not be D, F, I, Q,                            E   Y    Y                Y    Y               B/O     Make FE national insurance     Changed in version 0.2
                                                                                      U or V and the second character must not                                                                                       number available for FE.
                                                                                      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
Change L26_10       L26        National insurance number          Y   Y               Must be spaces                                                          E   Y         Y    Y      Y    Y               B/O     Make FE national insurance     Changed in version 0.2
                                                                                                                                                                                                                     number available for FE.
          L27_1     L27        Restricted use indicator           Y   Y         Y     Must exist on table                                                     E   Y    Y         Y      Y    Y               B/O
          L27_2     L27        Restricted use indicator           Y   Y         Y     Must be 0                                                               E             Y           Y    Y               B/O
          L28a_4    L28a       Eligibility for enhanced funding   Y   Y               Must be 00                                                              E             Y    Y      Y    Y               B/O
                               (1)
New       L28a_6    L28a       Eligibility for enhanced funding   Y   Y               Must exist on table                                                     E   Y                     Y    Y               B/O     Change to allow learners who changed in version 0.2
                               (1)                                                                                                                                                                                   are both WBL and FE funded
                                                                                                                                                                                                                     to use values which are
                                                                                                                                                                                                                     applicable to both in this field.
                                                                                                                                                                                                                     Replaces L28a_3
New       L28a_7    L28a       Eligibility for enhanced funding   Y   Y               Must exist on table (if entered)                                        E        Y                Y    Y               B/O     Change to allow learners who changed in version 0.2
                               (1)                                                                                                                                                                                   are both WBL and FE funded
                                                                                                                                                                                                                     to use values which are
                                                                                                                                                                                                                     applicable to both in this field.
                                                                                                                                                                                                                     Replaces L28a_5
          L28b_4    L28b       Eligibility for enhanced funding   Y   Y               Must be 00                                                              E             Y    Y      Y    Y               B/O
                               (2)
New       L28b_6    L28b       Eligibility for enhanced funding   Y   Y               Must exist on table                                                     E   Y                     Y    Y               B/O     Change to allow learners who changed in version 0.2
                               (1)                                                                                                                                                                                   are both WBL and FE funded
                                                                                                                                                                                                                     to use values which are
                                                                                                                                                                                                                     applicable to both in this field.
                                                                                                                                                                                                                     Replaces L28b_3




LSC 7/8/2011                                                                                                                    Field Level Validation                                                                                Page 7 of 26 / 2003/04 DRAFT 1b
                                                                                                                   6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                             FE/U           ESF
From                                                                                                                              Metadata Description        FI  WBL ACL SR                       FE   Batch/
03/04     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   Reason for change
New       L28b_7    L28b      Eligibility for enhanced funding     Y  Y               Must exist on table (if entered)                                    E        Y                 Y    Y              B/O     Change to allow learners who changed in version 0.2
                              (1)                                                                                                                                                                                are both WBL and FE funded
                                                                                                                                                                                                                 to use values which are
                                                                                                                                                                                                                 applicable to both in this field.
                                                                                                                                                                                                                 Replaces L28b_5
          L29_1     L29         Additional support                Y                   Must exist on table                                                E    Y                     Y    Y               B/O
          L29_2     L29         Additional support                Y                   Must be 00                                                         E         Y    Y    Y      Y    Y               B/O
          L31_2     L31         Additional support cost           Y                   Warning message will be generated if                               W    Y                     Y    Y               B/O
                                                                                      value is greater than 19000
          L31_3     L31         Additional support cost           Y                   Must be => 000000 and <= 999999                                     E   Y                     Y    Y          Y    B/O
          L31_4     L31         Additional support cost           Y                   Must be 000000                                                      E        Y    Y    Y      Y    Y               B/O
          L32_1     L32         Eligibility for disadvantage      Y                   Must exist on table                                                 E   Y                     Y    Y          Y    B/O
                                uplift
          L32_2     L32         Eligibility for disadvantage      Y                   Must be 00                                                          E        Y    Y    Y      Y    Y          Y    B/O
                                uplift
          L33_1     L33         Disadvantage uplift factor        Y                   Must be either 0.0000 or a number in the                            E   Y                     Y    Y          Y    B/O
                                                                                      range 1.0000 to 1.2500 inclusive.
          L33_2     L33         Disadvantage uplift factor        Y                   Must be 0.0000                                                      E        Y    Y    Y      Y    Y               B/O
          L33_3     L33         Disadvantage uplift factor        Y                   Must have decimal point in position 2                               E   Y                     Y    Y               B/O
          L34a_2    L34a        Learner support reason (1)        Y   Y               Must be 41 or 99                                                    E        Y                Y    Y               B/O
          L34a_3    L34a        Learner support reason (1)        Y   Y               Must exist on table                                                 E   Y                     Y    Y               B/O
          L34a_4    L34a        Learner support reason (1)        Y   Y               Must be 00                                                          E             Y    Y      Y    Y               B/O
          L34b_2    L34b        Learner support reason (2)        Y   Y               Must be 41 or 99                                                    E        Y                Y    Y               B/O
          L34b_3    L34b        Learner support reason (2)        Y   Y               Must exist on table                                                 E   Y                     Y    Y               B/O
          L34b_4    L34b        Learner support reason (2)        Y   Y               Must be 00                                                          E             Y    Y      Y    Y               B/O
          L34c_2    L34c        Learner support reason (3)        Y   Y               Must be 41 or 99                                                    E        Y                Y    Y               B/O
          L34c_3    L34c        Learner support reason (3)        Y   Y               Must exist on table                                                 E   Y                     Y    Y               B/O
          L34c_4    L34c        Learner support reason (3)        Y   Y               Must be 00                                                          E             Y    Y      Y    Y               B/O
          L34d_2    L34d        Learner support reason (4)        Y   Y               Must be 41 or 99                                                    E        Y                Y    Y               B/O
          L34d_3    L34d        Learner support reason (4)        Y   Y               Must exist on table                                                 E   Y                     Y    Y               B/O
          L34d_4    L34d        Learner support reason (4)        Y   Y               Must be 00                                                          E             Y    Y      Y    Y               B/O
          L35_1     L35         Prior attainment level            Y   Y         Y     Must exist on table                                                 E   Y    Y         Y      Y    Y               B/O
          L35_2     L35         Prior attainment level            Y   Y         Y     Must be 00                                                          E             Y           Y    Y               B/O
          L36_1     L36         Learner status on last working        Y               Must exist on table                                                 E        Y                Y    Y               B/O
                                day before learning
          L36_2     L36         Learner status on last working        Y               Must be 0                                                           E   Y         Y     Y     Y    Y               B/O
                                day before learning
          L37_1     L37         Employment status on first day        Y               Must exist on table                                                 E        Y                Y    Y               B/O
                                of learning
          L37_2     L37         Employment status on first day        Y               Must be zeros                                                       E   Y         Y     Y     Y    Y               B/O
                                of learning
          L38_1     L38         Employment status on last day         Y               Must exist on table (if present)                                    E        Y                Y    Y               B/O
                                of learning
          L38_2     L38         Employment status on last day         Y               Must be zeros                                                       E   Y         Y     Y     Y    Y               B/O
                                of learning
          L39_1     L39         Destination                       Y   Y         Y     Must exist on table (if present)                                    E   Y                     Y    Y               B/O
          L39_2     L39         Destination                       Y   Y         Y     Must exist on table                                                 E        Y          Y     Y    Y               B/O

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

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

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

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

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

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

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




LSC 7/8/2011                                                                                                                   Field Level Validation                                                                             Page 8 of 26 / 2003/04 DRAFT 1b
                                                                                                                  6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                FE/U           ESF
From                                                                                                                                 Metadata Description        FI  WBL ACL SR                       FE   Batch/
03/04     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   Reason for change
          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 [_]
       L44_1        L44       NCS delivery LSC number                Y               Must not be 002                                                         E        Y                Y    Y               B/O
       L44_2        L44       NCS delivery LSC number                Y               Must be 000                                                             E   Y         Y    Y      Y    Y               B/O
       L44_3        L44       NCS delivery LSC number                Y               Must exist on table (if entered)                                        E        Y                Y    Y               B/O
       A01_1        A01       Provider number                    Y   Y   Y     Y     Must be the same as L01                                                 E   Y    Y    Y    Y      Y    Y          Y    B/O
       A02_1        A02       Allocation number                  Y   Y               Must be the same as L02                                                 E   Y         Y    Y      Y    Y          Y    B/O
change A02_2        A02       Allocation number                  Y   Y               Must be 12 (if entered)                                                 E        Y                Y    Y          Y    B/O     Changed to reflect the fact       changed in version 0.2
                                                                                                                                                                                                                    that 12 is the only allocation
                                                                                                                                                                                                                    number used for WBL
          A02_3     A02        Allocation number                 Y   Y               Must be 00                                                              E             Y    Y      Y    Y               B/O
                    A03        Learner reference number          Y   Y   Y     Y
                    A04        Data set identifier code          Y   Y   Y     Y
          A05_1     A05        Learning aim data set             Y   Y   Y     Y     Must be numeric and between 01 and 98                                   E   Y    Y    Y    Y      Y    Y          Y     B
                               sequence
          A06_1     A06        ESF data sets                     Y   Y   Y     Y     Must be 00                                                              E             Y           Y    Y               B/O
          A07_2     A07        HE Data Sets                      Y   Y   Y     Y     Must be 00                                                              E        Y    Y    Y      Y    Y               B/O
          A08_2     A08        Data Set Format                   Y   Y   Y     Y     Must be 1                                                               E   Y                     Y    Y               B/O
          A08_3     A08        Data Set Format                   Y   Y   Y     Y     Must be 2                                                               E        Y                Y    Y               B/O
          A08_4     A08        Data Set Format                   Y   Y   Y     Y     Must be 3                                                               E             Y           Y    Y               B/O
          A08_5     A08        Data Set Format                   Y   Y   Y     Y     Must be 4                                                               E                  Y      Y    Y               B/O
          A09_1     A09        Learning aim reference code       Y   Y   Y     Y     Must exist on Learning Aims Database                                    E   Y    Y    Y    Y      Y    Y    Y     Y    B/O
                                                                                     (LEARNING_AIM Table)
          A10_3     A10        LSC Funding stream                Y   Y   Y     Y     Must be 20, 70, 80 or 99                                                E   Y                     Y    Y          Y    B/O
          A10_4     A10        LSC Funding stream                Y   Y   Y     Y     Must be 40, 41, 42, 70, 80 or 99                                        E        Y                Y    Y               B/O
          A10_5     A10        LSC Funding stream                Y   Y   Y     Y     Must be 10, 80, 99                                                      E             Y           Y    Y               B/O
          A10_6     A10        LSC Funding stream                Y   Y   Y     Y     Must be 10, 70, 80                                                      E                  Y      Y    Y               B/O
          A11a_1    A11a       Source of funding (1)             Y       Y           Must exist on table                                                     E   Y         Y           Y    Y          Y    B/O
          A11a_2    A11a       Source of funding (1)             Y       Y           Must be 000                                                             E        Y         Y      Y    Y               B/O
          A11b_1    A11b       Source of funding (2)             Y       Y           Must exist on table                                                     E   Y         Y           Y    Y          Y    B/O
          A11b_2    A11b       Source of funding (2)             Y       Y           Must be 000                                                             E        Y         Y      Y    Y               B/O
          A12a_1    A12a       Implied rate of LSC funding for   Y                   Must be between 0 & 100                                                 E   Y                     Y    Y          Y    B/O
                               historic ESF (1)
          A12a_2    A12a       Implied rate of LSC funding for   Y                   Must be 0                                                               E        Y    Y    Y      Y    Y               B/O
                               historic ESF (1)
          A12b_1    A12b       Implied rate of LSC funding for   Y                   Must be between 0 & 100                                                 E   Y                     Y    Y          Y    B/O
                               historic ESF (2)
          A12b_2    A12b       Implied rate of LSC funding for   Y                   Must be 0                                                               E        Y    Y    Y      Y    Y               B/O
                               historic ESF (2)
          A13_1     A13        Tuition fee received for year     Y       Y           Must be between 00000 & 99999                                           E   Y         Y           Y    Y          Y    B/O
          A13_2     A13        Tuition fee received for year     Y       Y           Must be 00000                                                           E        Y         Y      Y    Y               B/O
          A14_1     A14        Reason for partial or full non-   Y       Y           Must exist on table                                                     E   Y         Y           Y    Y          Y    B/O
                               payment of tuition fees
          A14_2     A14        Reason for partial or full non-   Y       Y           Must be 00                                                              E        Y         Y      Y    Y               B/O
                               payment of tuition fees
          A15_1     A15        Programme type                        Y               Must exist on table                                                     E        Y                Y    Y               B/O
          A15_2     A15        Programme type                        Y               Must be 00                                                              E   Y         Y    Y      Y    Y               B/O
          A16_2     A16        Programme entry route                 Y               Must be 00                                                              E   Y         Y    Y      Y    Y               B/O
          A16_3     A16        Programme entry route                 Y               Must exist on table if entered                                          E        Y                Y    Y               B/O
          A17_1     A17        Delivery mode                     Y                   Must exist on table                                                     E   Y                     Y    Y          Y    B/O
          A17_2     A17        Delivery mode                     Y                   Must be 0                                                               E        Y    Y    Y      Y    Y               B/O
          A18_1     A18        Main delivery method              Y                   Must exist on table                                                     E   Y                     Y    Y          Y    B/O
          A18_2     A18        Main delivery method              Y                   Must be 00                                                              E        Y    Y    Y      Y    Y               B/O
          A19_1     A19        Employer role                     Y                   Must exist on table                                                     E   Y                     Y    Y          Y    B/O
          A19_2     A19        Employer role                     Y                   Must be 0                                                               E        Y    Y    Y      Y    Y               B/O
          A20_1     A20        Resit                             Y                   Must exist on table                                                     E   Y                     Y    Y          Y    B/O
          A20_2     A20        Resit                             Y                   Must be 0                                                               E        Y    Y    Y      Y    Y               B/O
          A21_1     A21        Franchised out partnership        Y                   Must exist on table                                                     E   Y                     Y    Y          Y    B/O
                               arrangements
          A21_2     A21        Franchised out partnership        Y                   Must be 00                                                              E        Y    Y    Y      Y    Y               B/O
                               arrangements
          A22_1     A22        Franchising delivery provider     Y                   Must be spaces                                                          E        Y    Y    Y      Y    Y               B/O
                               number
change A23_1        A23        Delivery location postcode        Y   Y   Y     Y     Should exist on table or be ZZ99 ZZZ or                                W    Y    Y    Y    Y           Y    Y          B/O     field now available for ACL
                                                                                     all spaces
change A23_2        A23        Delivery location postcode        Y   Y   Y     Y     First part should exist on table or be 'ZZ99'                          W    Y    Y    Y    Y      Y         Y           B      field now available for ACL
                                                                                     or the whole postcode must be spaces




LSC 7/8/2011                                                                                                                   Field Level Validation                                                                                   Page 9 of 26 / 2003/04 DRAFT 1b
                                                                                                                            6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                         FE/U           ESF
From                                                                                                                                          Metadata Description        FI  WBL ACL SR                          FE   Batch/
03/04  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   Reason for change
change A23_3      A23       Delivery location postcode          Y  Y   Y      Y                The second part of the postcode must be                                E   Y    Y    Y    Y          Y    Y              B/O     field now available for ACL
                                                                                               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       Y   The first part of the postcode must                                    E   Y       Y   Y       Y       Y       Y         B/O     field now available for ACL
                                                                                               conform to the format 1 or 2 capital letters
                                                                                               followed by (1 or 2 numbers or 1 number
                                                                                               and a capital letter) or the whole postcode
                                                                                               must be spaces
          A23_5   A23        Delivery location postcode            Y       Y       Y       Y   Mandatory                                                              E   Y                           Y       Y         B/O
          A24_1   A24        Occupation relating to learner        Y       Y               Y   Must exist on table if entered                                         E   Y       Y           Y       Y       Y         B/O
                             aim
          A24_2   A24        Occupation relating to learner        Y       Y               Y   Must be zeros                                                          E               Y               Y       Y         B/O
                             aim
          A26_1   A26        Sector framework of learning          Y       Y                   Must exist on table (if entered)                                   E               Y                   Y       Y         B/O
          A26_2   A26        Sector framework of learning          Y       Y                   Must be zeros                                                      E       Y           Y       Y       Y       Y         B/O
          A27_1   A27        Learning start date                   Y       Y       Y       Y   Mandatory                                                          E       Y       Y   Y       Y       Y       Y    Y    B/O
          A27_2   A27        Learning start date                   Y       Y       Y       Y   Must be a valid date                                               E       Y       Y   Y       Y       Y       Y    Y    B/O
          A27_4   A27        Learning start date                   Y       Y       Y       Y   Start date must not be more than ten      IF A27 < 1 August 1994   E       Y       Y   Y       Y       Y       Y         B/O
                                                                                               years ago
          A27_5   A27        Learning start date                   Y       Y       Y       Y   Start date must not be after current      IF A27 > 31 July 2005    E       Y           Y       Y       Y       Y         B/O
                                                                                               learning year
          A27_6   A27        Learning Start Date               Y       Y       Y       Y       Start date must not be more than 10 years IF A27 > 1 August 2014 E             Y           Y       Y       Y            B/O
                                                                                               in the future
          A28_1   A28        Learning planned end date             Y       Y       Y       Y   Mandatory                                                          E       Y       Y   Y       Y       Y       Y    Y    B/O
          A28_2   A28        Learning planned end date             Y       Y       Y       Y   Must be a valid date                                               E       Y       Y   Y       Y       Y       Y    Y    B/O
          A31_1   A31        Learning actual end date              Y       Y       Y       Y   Must be a valid date or 00000000                                   E       Y       Y   Y       Y       Y       Y    Y    B/O
          A31_2   A31        Learning actual end date              Y       Y       Y       Y   Must be on or before today's date if                               E               Y           Y               Y          O
                                                                                               entered
change    A31_3   A31        Learning actual end date              Y       Y       Y       Y   Should be after 1 August 2003                                     W        Y                           Y       Y          B      to reflect change in year       changed in version 0.2
change    A31_4   A31        Learning actual end date              Y       Y       Y       Y   Should be before 1 August 2005                                    W        Y       Y           Y       Y       Y          B      to reflect change in year       changed in version 0.2
change    A31_5   A31        Learning actual end date              Y       Y       Y       Y   Must be before 31 July 2007                                        E       Y                           Y       Y    Y     B      to reflect change in year       changed in version 0.2
Change    A32_1   A32        Guided learning hours                 Y               Y           Must be numeric characters in the range                            E       Y       Y   Y               Y       Y    Y    B/O     to allow GLH for WBL basic
                                                                                               [00000 to 10000].                                                                                                                skills pilots
change A32_2      A32        Guided learning hours                 Y               Y           Warning message will be output if the                             W        Y       Y   Y               Y       Y         B/O     to allow GLH for WBL basic
                                                                                               value is greater than [2000] The Guided                                                                                          skills pilots
                                                                                               learner hours should not be greater than
                                                                                               2000
change A32_3      A32        Guided learning hours                 Y               Y           Must be 00000                                                      E               Y           Y       Y       Y         B/O     to allow GLH for WBL basic
                                                                                                                                                                                                                                skills pilots
          A34_2   A34        Completion status                     Y       Y       Y       Y   Must be 1, 2, 3, or 4                                                  E   Y           Y               Y       Y    Y    B/O
          A34_3   A34        Completion status                     Y       Y       Y       Y   Must exist on table                                                    E           Y           Y       Y       Y         B/O
          A35_1   A35        Learning outcome                      Y       Y       Y       Y   Must exist on table                                                    E   Y       Y   Y       Y       Y       Y    Y    B/O
          A36_1   A36        Learning outcome grade                Y                           Must exist on table (if present)                                       E   Y                           Y       Y         B/O
          A36_2   A36        Learning outcome grade                Y                           Must be spaces                                                         E           Y   Y       Y       Y       Y         B/O
          A37_1   A37        Number of units completed             Y       Y                   Must be => 0                                                           E   Y       Y                   Y       Y    Y    B/O
          A37_2   A37        Number of units completed             Y       Y                   Must be zeros                                                          E               Y       Y       Y       Y         B/O
          A38_1   A38        Number of units to achieve full       Y       Y                   Must be => 0                                                           E   Y       Y                   Y       Y    Y    B/O
                             qualification
          A38_2   A38        Number of units to achieve full       Y       Y                   Must be zeros                                                          E               Y       Y       Y       Y         B/O
                             qualification
          A39_1   A39        Eligibility for achievement           Y                           Must exist on table (if present)                                       E   Y                           Y       Y    Y    B/O
                             funding
          A39_2   A39        Eligibility for achievement           Y                           Must be 0                                                              E           Y   Y       Y       Y       Y         B/O
                             funding
          A40_1   A40        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 today’s                             E           Y                           Y          O
                                                                                               date.
          A40_3   A40        NVQ achievement date                          Y                   Must be zeros                                                          E   Y           Y       Y       Y       Y         B/O
          A43_1   A43        Sector framework achievement                  Y                   Must be a valid date or 00000000                                       E           Y                   Y       Y         B/O
                             Date
          A43_2   A43        Sector framework achievement                  Y                   Must be 00000000                                                       E   Y           Y       Y       Y       Y         B/O
                             Date
          A44_1   A44        Placement employer name                       Y                   May be any printable characters except                                 E           Y                   Y       Y         B/O
                                                                                               for [*] and [?] and [%] and [_]
          A44_2   A44        Placement employer name                       Y                   Must be spaces                                                         E   Y           Y       Y       Y       Y         B/O




LSC 7/8/2011                                                                                                                            Field Level Validation                                                                                   Page 10 of 26 / 2003/04 DRAFT 1b
                                                                                                               6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                             FE/U           ESF
From                                                                                                                              Metadata Description        FI  WBL ACL SR                       FE   Batch/
03/04     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   Reason for change
          A45_1     A45       Placement employer location          Y               Should exist on table or be all spaces                                 W        Y                      Y    Y         B/O
                              postcode
          A45_2     A45       Placement employer location          Y               First part should must exist on table or the                          W         Y                Y         Y           B
                              postcode                                             whole postcode must be spaces
          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
          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
          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     To allow family learning to be
                               monitoring (1)                                      01,13,14,15,16,17,18,19,20,21,23,24,25,3                                                                                      available for FE and to
                                                                                   1-50 or 99                                                                                                                    remove values 27 - 29 which
                                                                                                                                                                                                                 do not apply for FE
          A46a_2    A46a       National learning aim           Y   Y   Y           Must be 14, 15, 16, 17,21, 26, 27-50 or 99                             E        Y                Y    Y               B/O                                      Changed
                               monitoring (1)                                                                                                                                                                                                     in version
                                                                                                                                                                                                                                                  0.2 this
                                                                                                                                                                                                                                                  rule
                                                                                                                                                                                                                                                  reverts to
                                                                                                                                                                                                                                                  how it
                                                                                                                                                                                                                                                  worked in
                                                                                                                                                                                                                                                  2003/04.
                                                                                                                                                                                                                                                  Separate
                                                                                                                                                                                                                                                  rule is
                                                                                                                                                                                                                                                  required
                                                                                                                                                                                                                                                  for ESF
                                                                                                                                                                                                                                                  SR
Change A46a_4       A46a       National learning aim           Y   Y   Y           Must be 14,15,16,23,24,31-50 or 99                                     E             Y           Y    Y               B/O     Rule was incorrectly named in
                               monitoring (1)                                                                                                                                                                    2003/04 val rules
                                                                                                                                                                                                                 spreadsheet. Changed to
                                                                                                                                                                                                                 make consistent with
                                                                                                                                                                                                                 validation errors report in LIS
                                                                                                                                                                                                                 and OLDC
New       A46a_5    A46a       National learning aim           Y   Y   Y           Must be 14,15,16, 17, 21, 23, 24, 30-50 or                             E                  Y      Y    Y               B/O     Added to make A46 available changed in version 0.2 - should be A46
                               monitoring (1)                                      99                                                                                                                            for ESF SR
Change A46b_1       A46b       National learning aim           Y   Y   Y           Must be                                                                E   Y                     Y    Y          Y    B/O     To allow family learning to be
                               monitoring (2)                                      01,13,14,15,16,17,18,19,20,21,23,24,25,3                                                                                      available for FE and to
                                                                                   1-50 or 99                                                                                                                    remove values 27 - 29 which
                                                                                                                                                                                                                 do not apply for FE
          A46b_2    A46b       National learning aim           Y   Y   Y           Must be 14, 15, 16, 17, 21, 26, 27-50 or 99                            E        Y                Y    Y               B/O                                     Changed
                               monitoring (2)                                                                                                                                                                                                    in version
                                                                                                                                                                                                                                                 0.2 this
                                                                                                                                                                                                                                                 rule
                                                                                                                                                                                                                                                 reverts to
                                                                                                                                                                                                                                                 how it
                                                                                                                                                                                                                                                 worked in
                                                                                                                                                                                                                                                 2003/04.
                                                                                                                                                                                                                                                 Separate
                                                                                                                                                                                                                                                 rule is
                                                                                                                                                                                                                                                 required
                                                                                                                                                                                                                                                 for ESF
                                                                                                                                                                                                                                                 SR
change A46b_4       A46b       National learning aim           Y   Y   Y           Must be 14,15,16,23,24,31-50 or 99                                     E             Y           Y    Y               B/O     Rule was incorrectly named in Changed in version 0.2
                               monitoring (2)                                                                                                                                                                    2003/04 val rules
                                                                                                                                                                                                                 spreadsheet. Changed to
                                                                                                                                                                                                                 make consistent with
                                                                                                                                                                                                                 validation errors report in LIS
                                                                                                                                                                                                                 and OLDC
New       A46b_5    A46b       National learning aim           Y   Y   Y           Must be 14,15,16, 17, 21, 23, 24, 31-50 or                             E                  Y      Y    Y               B/O     Added to make A46 available changed in version 0.2 - should be A46
                               monitoring (2)                                      99                                                                                                                            for ESF SR
          A47a_1    A47a       Local learning aim monitoring   Y   Y               Must be => 0 if entered                                                E   Y    Y         Y      Y    Y               B/O
                               (1)




LSC 7/8/2011                                                                                                                Field Level Validation                                                                                 Page 11 of 26 / 2003/04 DRAFT 1b
                                                                                                                  6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                            FE/U           ESF
From                                                                                                                             Metadata Description        FI  WBL ACL SR                       FE   Batch/
03/04     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   Reason for change
          A47a_2    A47a      Local learning aim monitoring       Y  Y               Must be zeros                                                       E             Y            Y    Y              B/O
                              (1)
change A47b_1       A47b      Local learning aim monitoring      Y   Y               Must be => 0 if entered                                             E   Y    Y         Y      Y    Y               B/O     To allow the local monitoring
                              (2)                                                                                                                                                                               field to be available for the
                                                                                                                                                                                                                ESF SR
change A47b_2       A47b       Local learning aim monitoring     Y   Y               Must be zeros                                                       E             Y    Y      Y    Y               B/O     To allow the local monitoring
                               (2)                                                                                                                                                                              field to be available for the
                                                                                                                                                                                                                ESF SR
          A48a_1    A48a       Provider specified learning aim   Y   Y   Y       Y   May be any printable characters except                              E   Y    Y    Y    Y      Y    Y               B/O
                               data 1 (1)                                            for [*] and [?] and [%] and [_]
          A48b_1    A48b       Provider specified learning aim   Y   Y   Y       Y   May be any printable characters except                              E   Y    Y    Y    Y      Y    Y               B/O
                               data 1 (2)                                            for [*] and [?] and [%] and [_]
          A49_1     A49        Special Projects and Pilots       Y   Y               May be any printable characters except                              E   Y    Y         Y      Y    Y               B/O     To allow special projects and
                                                                                     for [*] and [?] and [%] and [_]                                                                                            pilots field to be available for
                                                                                                                                                                                                                ESF short record

change A49_2        A49        Special Projects and Pilots       Y   Y               Must be spaces                                                      E             Y    Y      Y    Y               B/O     To allow special projects and
                                                                                                                                                                                                                pilots field to be available for
                                                                                                                                                                                                                ESF short record

       A50_1        A50        Reason Learning Ended                 Y               Must exist on table if entered                                      E        Y                Y    Y               B/O
       A50_2        A50        Reason Learning Ended                 Y               Must be zeros                                                       E   Y         Y    Y      Y    Y               B/O
Change A51_3        A51        On programme payments                 Y               Must be zeros                                                       E   Y    Y    Y    Y      Y    Y               B/O     OPPs no longer apply. This
                                                                                                                                                                                                                rule enforces zero entries
          A52_1     A52        Distance learning funding         Y                   Must be zeros                                                       E        Y    Y    Y      Y    Y               B/O
          A52_2     A52        Distance learning funding         Y                   Must be greater or equal to zero                                    E   Y                     Y    Y               B/O
          A53_1     A53        Additional Learning Needs             Y               Must exist on table (if entered)                                    E        Y                Y    Y               B/O
          A53_2     A53        Additional Learning Needs             Y               Must be 00                                                          E   Y         Y    Y      Y    Y               B/O
          E01_1     E01        Contract/allocation provider      Y   Y       Y       Must be the same as A01                                             E   Y    Y         Y      Y    Y               B/O
                               number
          E02_1     E02        Allocation number                 Y   Y               Must be the same as A02                                             E   Y    Y                Y    Y               B/O
          E02_2     E02        Allocation number                 Y   Y               Must be zeros                                                       E                  Y      Y    Y               B/O
                    E03        Learner reference number          Y   Y       Y
                    E04        Data set identifier code          Y   Y       Y
                    E05        Learning Aim Data Set             Y   Y       Y
                               Sequence
          E06_1     E06        ESF co-financing data set         Y   Y       Y       Must be 01                                                          E   Y    Y                Y    Y               B/O
                               sequence
          E07_1     E07        HE Data Sets                      Y           Y       Must be 00                                                          E   Y    Y         Y      Y    Y               B/O
          E08_1     E08        Date started ESF co-financing     Y   Y       Y       Must be a valid date                                                E   Y    Y         Y      Y    Y               B/O

          E08_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
          E10_1     E10        Date ended ESF co-financing       Y   Y       Y       Must be a valid date (if entered)                                   E   Y    Y         Y      Y    Y               B/O
          E10_2     E10        Date ended ESF co-financing       Y   Y       Y       Must not be before 01/09/2001                                       E   Y    Y         Y      Y    Y               B/O
          E11_1     E11        Industrial sector of learners     Y   Y       Y       Must exist on table                                                 E   Y    Y         Y      Y    Y               B/O
                               employer
          E12_1     E12        Learners employment status on     Y   Y       Y       Must exist on table                                                 E   Y    Y         Y      Y    Y               B/O
                               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
change E16a_1       E16a       Addressing gender                 Y   Y               Must exist on table (if entered)                                    E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                               stereotyping (1)
change E16b_1       E16b       Addressing gender                 Y   Y               Must exist on table (if entered)                                    E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                               stereotyping (2)
change E16c_1       E16c       Addressing gender                 Y   Y               Must exist on table (if entered)                                    E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                               stereotyping (3)




LSC 7/8/2011                                                                                                                  Field Level Validation                                                                               Page 12 of 26 / 2003/04 DRAFT 1b
                                                                                                                6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                 FE/U           ESF
From                                                                                                                           Metadata Description               FI  WBL ACL SR                       FE   Batch/
03/04  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   Reason for change
change E16d_1      E16d      Addressing gender                  Y  Y               Must exist on table (if entered)                                           E   Y    Y         Y       Y    Y              B/O     Field available for ESF SR
                             stereotyping (4)
change E16e_1      E16e      Addressing gender                 Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                             stereotyping (5)
          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
change    E18a_1   E18a      Delivery Mode (1)                 Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
change    E18b_1   E18b      Delivery Mode (2)                 Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
change    E18c_1   E18c      Delivery Mode (3)                 Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
change    E18d_1   E18d      Delivery Mode (4)                 Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
change    E19a_1   E19a      Support measures to be            Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                             accessed by learner (1)
change E19b_1      E19b      Support measures to be            Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                             accessed by learner (2)
change E19c_1      E19c      Support measures to be            Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                             accessed by learner (3)
change E19d_1      E19d      Support measures to be            Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                             accessed by learner (4)
change E19e_1      E19e      Support measures to be            Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                             accessed by learner (5)
       E20a_1      E20a      Learner background (1)            Y   Y      Y        Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O
       E20b_1      E20b      Learner background (2)            Y   Y      Y        Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O
       E20c_1      E20c      Learner background (3)            Y   Y      Y        Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O
change E21_1       E21       Support measures for learners     Y   Y               Must exist on table (if entered)                                           E   Y    Y         Y      Y    Y               B/O     Field available for ESF SR
                             with disability
New       E22_2    E22       Project Dossier Number            Y   Y      Y        Must be correct format (if entered)         if E22 not = Spaces            E   Y    Y         Y      Y    Y               B/O     To enforce correct format for    Changed in version 0.2
                                                                                                                               AND ( ([digits 1 to 2 of                                                              project dossier number
                                                                                                                               E22] not = (00, 01, 02,
                                                                                                                               03, 04,05,06 OR 07))
                                                                                                                               OR ([digits 3 to 6 of
                                                                                                                               E22] not numeric) OR
                                                                                                                               ([digits 7 to 8 of E22]
                                                                                                                               NOT IN
                                                                                                                               ['EA','LN','NE','NW','SE','
                                                                                                                               SW','WM','EM','YH'])
                                                                                                                               OR ([digit 9 of E22] >
                                                                                                                               3)) AND (E22 not =
                                                                                                                               (999999WM3 OR
                                                                                                                               031010ME1 OR
                                                                                                                               031009ME1 OR
                                                                                                                               021291ME1 OR
                                                                                                                               021292ME1 OR
                                                                                                                               021321ME1 OR
                                                                                                                               021322ME1 OR
                                                                                                                               021323ME1))

New       E23_2    E23        Local Project number             Y   Y      Y        Must be numeric and >=0                                                    E   Y    Y         Y      Y    Y               B/O     To enforce correct format for
                                                                                                                                                                                                                     local project number             Changed in version 0.2
          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




LSC 7/8/2011                                                                                                                Field Level Validation                                                                                     Page 13 of 26 / 2003/04 DRAFT 1b
                                                                                                                   6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                               FE/U           ESF
From                                                                                                                                Metadata Description        FI  WBL ACL SR                       FE   Batch/
03/04     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   Reason for change
          H14_1     H14       Mode applicable to Funding           Y                  Must exist on table                                                   E   Y                      Y    Y              B/O
                              Council early statistics,
                              HEIFES
          H15_1     H15       Level applicable to Funding         Y                   Must exist on table                                                   E   Y                     Y    Y               B/O
                              Council HEIFES
          H16_1     H16       Completion of year of               Y                   Must exist on table                                                   E   Y                     Y    Y               B/O
                              programme of study
          H17_1     H17       Learner FTE                         Y                   Must be numeric => 000.0 and <= 300.0                                 E   Y                     Y    Y               B/O

          H17_2     H17        Learner FTE                        Y                   Must have decimal point in position 4                                 E   Y                     Y    Y               B/O
          H18_1     H18        Year of programme of study         Y                   Must be => 00 and <= 99                                               E   Y                     Y    Y               B/O
          H19_1     H19        Fee band                           Y                   Must exist on table                                                   E   Y                     Y    Y               B/O
          H20_1     H20        Major source of tuition fees       Y                   Must exist on table                                                   E   Y                     Y    Y               B/O
          H21_1     H21        Term time accommodation            Y                   Must exist on table (if entered)                                      E   Y                     Y    Y               B/O
          H22_1     H22        UCAS applicant number              Y                   Must be numeric                                                       E   Y                     Y    Y               B/O
          H23_1     H23        SOC occupation code                Y                   Must exist on table or be 0000, 0007,                                 E   Y                     Y    Y               B/O
                                                                                      0008, 0009
          H24_1     H24        Last institution                   Y                   Only acceptable characters are [A to Z], [a                           E   Y                     Y    Y               B/O
                                                                                      to z], [0 to 9] and spaces
          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 Superclass    Y                   Numeric value =>000.0 and <=100.0                                     E   Y                     Y    Y               B/O
                               1 subject
          H33_2     H33        Proportion taught in Superclass    Y                   Must have decimal point in position 4                                 E   Y                     Y    Y               B/O
                               1 subject
          H34_1     H34        Proportion taught in Superclass    Y                   Numeric value =>000.0 and <=100.0                                     E   Y                     Y    Y               B/O
                               2 subject
          H34_2     H34        Proportion taught in Superclass    Y                   Must have decimal point in position 4                                 E   Y                     Y    Y               B/O
                               2 subject
          H35_1     H35        Proportion taught in Superclass    Y                   Numeric value =>000.0 and <=100.0                                     E   Y                     Y    Y               B/O
                               3 subject
          H35_2     H35        Proportion taught in Superclass    Y                   Must have decimal point in position 4                                 E   Y                     Y    Y               B/O
                               3 subject
          H36_1     H36        Socio-economic indicator           Y                   Must exist on table                                                   E   Y                     Y    Y               B/O

2003/04 rules that are deleted for 2004/05
Delete    L26_4     L26        National insurance number          Y    Y              NI Number should must not be in use on                               W         Y                     Y    Y          B/O     Removed to improve                Changed in version 0.2
                                                                                      another 'in learning' event if non-blank                                                                                     perfomance on web-based
                                                                                                                                                                                                                   systems
Delete    L28a_3    L28a       Eligibility for enhanced funding (1)Y   Y              For FE, must be 12, 13, 99                                            E   Y                     Y    Y          Y    B/O     Change to allow learners who Changed in version 0.2
                                                                                                                                                                                                                   are both WBL and FE funded
                                                                                                                                                                                                                   to use both values in this field.
                                                                                                                                                                                                                   Replaced by rules L28a_6

Delete    L28a_5    L28a       Eligibility for enhanced funding   Y    Y              Must be 00, 14, 15, 99                                                E        Y                Y    Y               B/O     Change to allow learners who Changed in version 0.2
                               (1)                                                                                                                                                                                 are both WBL and FE funded
                                                                                                                                                                                                                   to use both values in this field.
                                                                                                                                                                                                                   Replaced by rules L28a_6

Delete    L28b_3    L28b       Eligibility for enhanced funding   Y    Y              For FE, must be 12, 13, 99                                            E   Y                     Y    Y          Y    B/O     Change to allow learners who changed in version 0.2
                               (2)                                                                                                                                                                                 are both WBL and FE funded
                                                                                                                                                                                                                   to use both values in this field.
                                                                                                                                                                                                                   Replaced by rule L28b_6




LSC 7/8/2011                                                                                                                  Field Level Validation                                                                                 Page 14 of 26 / 2003/04 DRAFT 1b
                                                                                                                6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                        FE/U           ESF
From                                                                                                                         Metadata Description        FI  WBL ACL SR                       FE   Batch/
03/04     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   Reason for change
Delete    L28b_5    L28b      Eligibility for enhanced funding    Y  Y               Must be 00, 14, 15, 99                                          E        Y                 Y    Y              B/O     Change to allow learners who changed in version 0.2
                              (2)                                                                                                                                                                           are both WBL and FE funded
                                                                                                                                                                                                            to use both values in this field.
                                                                                                                                                                                                            Replaced by rule L28b_7

DELETE A23_6        A23         Delivery location postcode       Y   Y         Y     Must be spaces                                                  E             Y           Y    Y               B/O     field now available for ACL
delete A46a_3       A46         National learning aim            Y   Y   Y           Must be 00                                                      E                  Y      Y    Y               B/O     Field available for ESF SR
                                monitoring (1)
delete    A46b_3    A46         National learning aim            Y   Y   Y           Must be 00                                                      E                  Y      Y    Y               B/O     Field available for ESF SR
                                monitoring (2)
delete    A51_1     A51         On programme payments                Y               Must be greater or equal to zero                                E        Y                Y    Y               B/O     OPPs no longer required
delete    A51_2     A51         On programme payments                Y               Should be less than 48                                          W        Y                Y    Y               B/O     OPPs no longer required
delete    E16a_2    E16a        Addressing gender                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                stereotyping (1)
delete    E16b_2    E16b        Addressing gender                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                stereotyping (2)
delete    E16c_2    E16c        Addressing gender                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                stereotyping (3)
delete    E16d_2    E16d        Addressing gender                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                stereotyping (4)
delete    E16e_2    E16e        Addressing gender                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                stereotyping (5)
delete    E18a_2    E18a        Delivery Mode (1)                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
delete    E18b_2    E18b        Delivery Mode (2)                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
delete    E18c_2    E18c        Delivery Mode (3)                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
delete    E18d_2    E18d        Delivery Mode (4)                Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
delete    E19a_2    E19a        Support measures to be           Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                accessed by learner (1)
delete    E19b_2    E19b        Support measures to be           Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                accessed by learner (2)
delete    E19c_2    E19c        Support measures to be           Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                accessed by learner (3)
delete    E19d_2    E19d        Support measures to be           Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                accessed by learner (4)
delete    E19e_2    E19e        Support measures to be           Y   Y               Must be a space                                                 E                  Y      Y    Y               B/O     Field available for ESF SR
                                accessed by learner (5)
delete    E21_2     E21         Support measures for learners    Y   Y               Must be zeros                                                   E                  Y      Y    Y               B/O     Field available for ESF SR
                                with disability




LSC 7/8/2011                                                                                                              Field Level Validation                                                                             Page 15 of 26 / 2003/04 DRAFT 1b
                                                                                                               6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                               ESF
From                                                                                                                                                      FE/UFI   WBL    ACL SR                     FE
03/04          Rule                    Rule Description                                                     Metadata                                E/W    Rule    Rule   Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
               A05_L05_1               The data set sequence must be less than or equal to the number       IF A05 > L05                             E      Y       Y      Y    Y     Y    Y               B
                                       of datasets
               A06_A10_1               If LSC Funding Stream is LSC ESF Co-financed, there must be          IF A10 = 70 AND A06 = 00                E       Y       Y           Y    Y     Y               B/O Consistency of data with control fields
                                       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 for   IF A11a = 001 OR 002 AND A07 = 00        E      Y                        Y     Y                B/O Consistency of data with control fields
                                       HEFCE funding, there must be an HE data set
               A07_A11b_1              If the aim is either supported by HEFCE funding or is eligible for   IF A11b = 001 OR 002 AND A07 = 00        E      Y                        Y     Y                B/O Consistency of data with control fields
                                       HEFCE funding, there must be an HE data set
               A09_A10_1               If the learning aim is XESF0001 the LSC funding stream must be       IF A09 = 'XESF0001' AND A10 NOT =        E              Y           Y    Y     Y                B/O
                                       <70> LSC ESF co-financed                                             70
               A09_A10_A15_3           A WBL funded E2E programme must use the E2E learning aim             if a15=09 and a10=40 and a09             E              Y                Y     Y                B/O
                                       code                                                                 not=XE2E0001
               A09_A10_A15_A24_LAD_1   Occupation relating to learning aim must be entered for WBL          IF FLAG11 on LEARNING_AIM table          E              Y                Y     Y     Y          B/O
                                       funded 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

               A09_A10_A15_LAD_1       Programme type must be consistent with LAD level for NVQ level IF A10 = 40 AND ((A15 = 04 AND                 E              Y                Y     Y     Y          B/O
                                       1 to 3 Learning for funded aims                                   NOTIONAL_NVQ_LVL_CODE in
                                                                                                         LEARNING_AIM NOT = 1) OR (A15 =
                                                                                                         05 AND
                                                                                                         NOTIONAL_NVQ_LVL_CODE in
                                                                                                         LEARNING_AIM NOT = 2) OR (A15 =
                                                                                                         06 AND
                                                                                                         NOTIONAL_NVQ_LVL_CODE in
                                                                                                         LEARNING_AIM NOT = 3)
               A09_A10_A15_LAD_2       Programme type should be consistent with LAD level for NVQ         if FLAG11 in LEARNING_AIM Not =           W               Y                Y     Y     Y          B/O
                                       level 4 and for funded aims within 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))
Change         A09_A10_A16_A27_LAD_2   Must be valid learning aim for this year for a new start for WBL- IF (A10=40 OR A10=41 OR A10=42)             E              Y                Y     Y     Y          B/O
                                       funded provision for first-time entrants                          AND (A16=09 OR A16=10) AND A27
                                                                                                         => 1 August 2004 AND A27 <= 31
                                                                                                         July 2005 AND WBL_STATUS_CODE
                                                                                                         IN WBL_ANNUAL_VALUES table in
                                                                                                         LAD = '2' (not valid for new starters)

change         A09_A10_A16_A27_LAD_3   Must be valid learning aim for this year for a new start for         IF A10=(70 or 80 or 99) AND (A16=09      E      Y       Y      Y    Y    Y     Y     Y          B/O
                                       provision which is not FE-, ACL- or WBL-funded, for first-time       OR A16=10 OR A16=00) AND A27 =>
                                       entrants on aims for which Programme Entry Route is not              1 August 2004 AND A27 <= 31 July
                                       collected                                                            2005 AND
                                                                                                            NON_LSC_FUNDED_STATUS IN
                                                                                                            ALL_ANNUAL_VALUES table in LAD
                                                                                                            = '2' (not valid for new starters)
New            A09_A10_A26_LAD_1       If sector framework code is entered, it should match the              if FLAG11 in LEARNING_AIM Not =        W               Y                Y     Y     Y          B/O
                                       framework for that learning aim in the LAD for funded NVQs,          "Y" and (A10 = 40 or A10 = 41) AND
                                       employer approved schemes and technical certificates                 A26 NOT= 000 and there is no
                                                                                                            matching record in
                                                                                                            SECTOR_FRAMEWORK_AIMS with (
                                                                                                            LEARNING_AIM_REF=A09 and
                                                                                                            SECTOR_FRAMEWORK_CODE=A2
                                                                                                            6)




LSC 7/8/2011                                                                                                               Cross field validation                                                                                                    Page 16 of 26 / 2003/04 DRAFT 1b
                                                                                                             6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                              ESF
From                                                                                                                                                     FE/UFI   WBL    ACL SR                     FE
03/04          Rule                Rule Description                                                  Metadata                           E/W               Rule    Rule   Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
Change         A09_A10_A27_LAD_6   Must be valid learning aim for this year for a new start for FE   IF A10=20 AND A27 => 1 August       E                 Y                         Y    Y    Y         B/O
                                   funded provision                                                  2004 AND A27 <= 31 July 2005 AND
                                                                                                     FE_STATUS_CODE IN
                                                                                                     FE_ANNUAL_VALUES table in LAD =
                                                                                                     '2' (not valid for new starters)
Change         A09_A10_A27_LAD_7   Must be valid learning aim for this year for a new start for ACL- IF A10=10 AND A27 => 1 August       E                 Y       Y      Y    Y    Y     Y     Y         B/O
                                   funded provision                                                  2004 AND A27 <= 31 July 2005 AND
                                                                                                     ACL_STATUS_CODE IN
                                                                                                     ACL_ANNUAL_VALUES table in LAD
                                                                                                     = '2' (not valid for new starters)
Change         A09_A10_LAD_4       Must exist on FE Annual Values table for year 2004/05 with valid IF A10 =20 AND FE_STATUS_CODE        E                 Y                        Y     Y     Y     Y    B/O
                                   status (1 or 2) for FE-funded aims                                IN FE_ ANNUAL_VALUES IN LAD
                                                                                                     (for record with Academic_Year=
                                                                                                     0405) NOT=('1' OR '2')

               A09_A10_LAD_5       Must exist on ACL Annual Values table for year 2004/05 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= 0405)
                                                                                                         NOT=('1' OR '2')
Change         A09_A10_LAD_6       Must exist on WBL Annual Values table for year 2004/05 with           IF (A10 =40 OR A10=41 OR A10=42)            E             Y                Y     Y     Y          B/O
                                   valid status (1 or 2) for WBL-funded aims                             AND WBL_STATUS_CODE IN
                                                                                                         WBL_ANNUAL_VALUES IN LAD (for
                                                                                                         record with Academic_Year= 0405)
                                                                                                         NOT=('1' OR '2')

Change         A09_A10_LAD_7       Must exist on All Annual Values table for year 2004/05 with valid IF A10=(30 or 42 or 70 or 80 or 99)             E     Y       Y      Y    Y    Y     Y     Y     Y    B/O
                                   status (1 or 2) for aims which are not FE-, WBL- or ACL-funded AND NON_LSC_FUNDED_STATUS
                                                                                                           IN ALL_ANNUAL_VALUES IN LAD
                                                                                                           (for record with Academic_Year=
                                                                                                           0405) NOT=('1' OR '2')
New            A09_A10_LAD_8        If funding for a technical certificate is being claimed the learning If A10 = 41 AND                             E             Y                Y     Y     Y     Y    B/O
                                   aim must be a technical certificate                                     TECHNICAL_CERTIFICATE in
                                                                                                           WBL_ANNUAL_VALUES table in LAD
                                                                                                           for learning aim reference in field A09
                                                                                                           not = 1
New            A09_A10_LAD_9        If funding for a key skill is being claimed the learning aim must If A10 = 42 AND KEY_SKILLS_ALL in              E             Y                Y     Y     Y     Y    B/O
                                   be a key skill                                                          ALL_ANNUAL_VALUES for learning
                                                                                                           aim reference in field A09 not = (1 or
                                                                                                           3)
               A09_A11a_L14_1      For learners who are HEFCE funded or eligible for HEFCE                 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 to NOT = 1
                                   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 to NOT = 1
                                   no recognised qualification aim, the learner must consider
                                   himself or herself to have a learning difficulty or health problem

               A09_A15_3           When an E2E learning aim code of xe2e0001 is used, the                if a09=xe2e0001 and a15 not= 09             E             Y                Y     Y                B/O
                                   programme type must be E2E.
               A09_A15_LAD_1       If a framework completion class code is used then the                 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
change         A09_A16_A27_LAD_1   If LAD record has an Approval_End_Date, then learners should          IF APPROVAL_END_DATE NOT=                   W     Y       Y      Y    Y    Y     Y     Y          B/O This is a warning because apparently providers can
                                   not start after that date.                                            Null AND A16 = (09 or 10 or 00) AND                                                                   exceptionally be given permission to start aims after the
                                                                                                         A27> APPROVAL_END_DATE                                                                                approval end date.

New            A09_A16_A27_LAD_2   If LAD record has an Aim_Discontinued_Date, then learners             IF AIM_DISCONTINUED_DATE                    W     Y       Y      Y    Y    Y     Y     Y          B/O This rule is based on the date from which an aim is
                                   should not start after that date.                                     NOT= Null AND A16 = (09 or or 010                                                                     discontinued (basd on info from awarding body, usually for
                                                                                                         or 00) AND A27>                                                                                       non-DfES-approved provision). The idea is to give a
                                                                                                         AIM_DISCONTINUED_DATE                                                                                 warning to providers that they should not be using the
                                                                                                                                                                                                               code after this date.




LSC 7/8/2011                                                                                                              Cross field validation                                                                                                    Page 17 of 26 / 2003/04 DRAFT 1b
                                                                                                              6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                              ESF
From                                                                                                                                                     FE/UFI   WBL    ACL SR                     FE
03/04          Rule                    Rule Description                                                    Metadata                                E/W    Rule    Rule   Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
               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 be an NVQ in LAD             IF A18 = 11 OR 12 OR 13 AND              E      Y                        Y     Y     Y          B/O
                                                                                                           LEARNING_AIM_TYPE_CODE field
                                                                                                           in LEARNING_AIM table in LAD is not
                                                                                                           '0036' (NVQ)
               A09_A19_A32_H21_LAD_1   If the Aim is HE level and the Employer Role = Dedicated            IF ENGLAND_FE_HE_STAT_CODE               W      Y                        Y     Y     Y          B/O
                                       Employer Provision AND Guided Learning Hours >449 the Term-         = 'H' on LEARNING_AIM table in LAD
                                       Time Accommodation field must be completed                          AND A19 = 3 AND A32 > 449 AND
                                                                                                           H21 = 0
               A09_A31_H31_LAD_1       If the Aim is HE level and the Actual End Date is completed then    IF ENGLAND_FE_HE_STAT_CODE               W      Y                        Y     Y     Y          B/O
                                       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 for     'Y' in LEARNING_AIM table AND A36
                                       such aims                                                           = LN OR L2 OR L1 OR E3 OR E2 OR
                                                                                                           E1
New            A09_A40_A43_LAD_1       If the Sector Framework Achievement Date is entered, the            IF FLAG11 on LEARNING_AIM table          E              Y                Y     Y     Y          B/O
                                       Achievement Date must be entered except for framework               in LAD not = "Y" AND A43 >
                                       completion class codes                                              00000000 AND A40 = 00000000
               A09_A40_LAD1            Achievement date must be null for sector framework class codes      IF FLAG11 on LEARNING_AIM table          E              Y                Y     Y     Y          B/O
                                                                                                           in LAD = "Y" AND A40 NOT =
                                                                                                           00000000
New            A09_A46a_A46b_LAD_1     If the aim is delivered under the WBL basic skills project or the   IF (A46a = 27 or A46b = 27 or            E              Y                Y     Y     Y     Y    B/O
                                       National Employers Basic Skills project the learning aim must be    A46a=30 or A46b=30) AND
                                       a basic skill eligible for funding under these projects             BASIC_SKILLS_TYPE in
                                                                                                           ALL_ANNUAL_VALUES table in LAD
                                                                                                           for learning aim reference in field A09
                                                                                                           not = (1 or 2 or 3)
               A09_H17_LAD_1           If the Aim is HE level, learner FTE should be completed             IF H17 = 000.0 AND                       W      Y                        Y     Y     Y          B/O
                                                                                                           ENGLAND_FE_HE_STAT_CODE =
                                                                                                           'H' on LEARNING_AIM table in LAD
               A09_N08_LAD_1           Learning aim must not be temporary code for last return of year     IF N08 = 'F05' OR 'C03' AND              E      Y              Y         Y     Y     Y           B    Replaces A09_T06_LAD_1
                                                                                                           TEMPORARY_AIM_CODE in
                                                                                                           LEARNING_AIM table in LAD = 'Y'
change         A10_A11a_A12a_1         If the learner is LSC FE funded and the source of funding is ESF    IF A10 = 20 AND A11a => 531 AND          E      Y                        Y     Y           Y    B/O
                                       but is not LSC ESF co-financed, the implied rate of LSC FE          A11a <= 556 AND A12a = 000
                                       funding for ESF which is not LSC ESF co-financed must not be
                                       zero
change         A10_A11b_A12b_1         If the learner is LSC FE funded and the source of funding is ESF    IF A10 = 20 AND A11b => 531 AND          E      Y                        Y     Y           Y    B/O
                                       but is not LSC ESF co-financed, the implied rate of LSC FE          A11b <= 556 AND A12b = 000
                                       funding for ESF which is not LSC ESF co-financed must not be
                                       zero
               A10_A12a_1              If the implied rate of LSC FE funding for ESF which is not LSC      IF A12a NOT = 000 AND A10 NOT =          E      Y                        Y     Y                B/O
                                       ESF co-financed is non-zero, the aim must be LSC FE funded          20

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

               A10_A14_1               If the reason for partial or non-payment of tuition fees is 'fees   IF A14 = 01 AND A10 NOT = 20             E      Y                        Y     Y                B/O
                                       waived - 16-18 year old learner; provision funded by the LSC',
                                       the LSC funding stream must be FE
               A10_A15_A16_1           For WBL funded main aims, If the Programme Entry Route is           IF A10=40 AND A16 = 03 AND A15           E              Y                Y     Y                B/O Introduction of new entry routes necessitates additional
                                       'Resume from AMA after FMA' the Programme Type must be              NOT = 02                                                                                            validation
                                       'AMA'
               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'
               A10_A15_A26_1           For WBL funded main aims, Sector code must be entered if the        IF A10=40 aND (A15 = 02 OR 03)           E              Y                Y     Y                B/O Reflects downgrade for Maximise PMR change
                                       programme type = FMA or AMA                                         AND A26 = 000


New            A10_A15_A27_1           An main aim funded as part of a WBL programme must not have IF A10 = 40 AND A15 = 99 AND A27                 E              Y                Y     Y                B/O
                                       a programme type of 'none of the above' for stats after 31 July > 31/07/2004
                                       2004




LSC 7/8/2011                                                                                                               Cross field validation                                                                                                   Page 18 of 26 / 2003/04 DRAFT 1b
                                                                                                            6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                          ESF
From                                                                                                                                                 FE/UFI   WBL    ACL SR                     FE
03/04          Rule                 Rule Description                                                     Metadata                           E/W       Rule    Rule   Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
New            A10_A15_A27_2        A technical certificate or key skill funded as part of a framework   IF (A10 = 41 or A10 =42) AND (A15   E                 Y                 Y    Y              B/O
                                    must have a programme type of FMA or AMA for starts after 31         not = 02 or A15 not =03) AND A27 >
                                    July 2004                                                            31/07/2004
               A10_A15_A27_AD01_1   for WBL funded NVQ1 main aims starting after 31 July 2003 the        if A10=40 AND A15=4 and             E                 Y                Y     Y                B/O
                                    learner must not be 16-18 years old at start                         A27>31072003 and AD01=1
               A10_A15_A35_A37_1    For partial achievement there should be an entry in units            IF (A15 not = 09 AND A35 = 2 AND    W                 Y                Y     Y                B/O
                                    completed for all aims except for E2E main aims                      A37 = 0) OR (a15 = 09 AND A10 NOT
                                                                                                         = 40 AND A35 = 2 AND A37 = 0)

               A10_A15_A35_A38_1    For partial achievement there should be an entry in the number 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 aims A38 = 0) OR (a15 = 09 AND A10 NOT
                                                                                                       = 40 AND A35 = 2 AND A38 = 0)

               A10_A15_A37_1        Number of units must not be entered for WBL funded E2E main      IF A10 = 40 AND A15 = 09 AND A37            E             Y                Y     Y                B/O
                                    aims.                                                            NOT = 00
               A10_A15_A38_1        Number of units to achieve full qualification must not be enteredIF A10 = 40 AND A15 = 09 AND A38            E             Y                Y     Y                B/O
                                    for WBL funded E2E main aims.                                    NOT = 00
New            A10_A15_A43_1        Sector Framework Achievement Date must only be entered for       IF A10 NOT = 40 AND A43 NOT =               E             Y                Y     Y                B/O
                                    the main aim for programme types AMA and FMA                     00000000 AND A15 NOT = (02 OR
                                                                                                     03)
Change         A10_A15_A53_1        Additional learning needs data must be entered for aims that are IF A53 = NULL AND (A10 = 40 or A10          E             Y                Y     Y                B/O
                                    WBL funded aims unless they are entry to employment.             = 41 or A10 = 42) AND a15 Not = 09

               A10_A16_1            Programme entry route must be entered for WBL funded main         IF A10 = 40 and A16 = null                 E             Y                Y     Y                B/O
                                    aims.
New            A10_A16_A27_1        Programme entry route must be entered for subsiduary aims         If A10 = 41 or A10 = 42 AND A16 = 00       E             Y                Y     Y                B/O
                                    funded as part of a framework for start after 31 July 2004.       AND A27 > 31/07/2004
               A10_A24_1            Occupation relating to learning aim must not be entered for ACL IF A10 = 10 AND A24 NOT = 0000               E                    Y         Y     Y                B/O
                                    funded aims.
               A10_A27_1                                                                              aims
                                    Start date must be on or before today's date for WBL funded main If A10 = 40 AND A27 > Todays date           E             Y                Y     Y                 O
change         A10_A27_L11_4        Should be over school leaving age at start for WBL funded aims IF A10 = (40 or 41 or 42) AND A27 -           W             Y                Y     Y                B/O
                                                                                                      L11 <16 years 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)
               A10_A27_T08_1        Start date must be on or before file creation date for WBL funded If A10 = 40 and A27 > T08                  E             Y                Y     Y                B
                                    main aims
Change         A10_A31_A50_1        If there is no learning actual end date then Reason Learning      IF (A10 = 40 or 41 or 42) AND A31 = 0      E             Y                y     y                B/O
                                    Ended must be continuing for WBL funded aims                      and A50 NOT = 96
               A10_A39_1            Where the Eligibility for achievement funding is 'achievement     IF A39 = 1 OR 2 AND A10 NOT = 20           E     Y                        Y     Y                B/O
                                    funding claimed' or 'partial achievement funding claimed' the aim
                                    must should be FE funded
New            A10_A50_1            Reason learning ended must be completed for all WBL funded        IF (A10 = 40 or A10 = 41 or A10 =42)       E             Y                Y     Y                B/O
                                    aims                                                              AND A50 = 0
new            A10_AD01_A16_1       Must be under 25 year old at the start of programme for WBL       IF A10= (40 or 41 or 42) and AD01 =        E             Y                Y     Y                B/O
                                    funded aims, unless the programme entry route is transfer from '3' AND A16 NOT = (7 or 8)
                                    another provider or LSC area or restart for funding purposes.


New            A10_E08_E11_E12_1    For ESF funded aims starting after 31/07/2004, if employment         IF A10 = 70 AND E08 > 31/07/2004        E     Y       Y           Y    Y     Y                B/O
                                    status before starting is 'employed' or 'self employed', the         AND E12 = (01 or 03) AND E11 = (98
                                    industrial sector of learner's employer must not be 'no employer'    or 99)
                                    or 'not known'.
New            A10_E08_E11_E12_2    For ESF match aims starting after 31/07/2004, if employment          IF A10 not = 70 AND E08 >               E     Y       Y           Y    Y     Y                B/O
                                    status before starting is 'employed' or 'self employed', the         31/07/2004 AND E12 = (01 or 03)
                                    industrial sector of learner's employer must not be 'no employer'    AND E11 = 99

New            A10_E08_E12_1        For ESF funded aims which start after 31/07/2004 the                 IF A10 = 70 AND E12 = 98 AND E08        E     Y       Y           Y    Y     Y                B/O
                                    employment status on day before starting ESF project must not        > 31/7/2004
                                    be not known not provided
New            A10_E08_E12_E13_1    For ESF funded aims starting after 31/07/2004, if employment         IF A10 = 70 AND E08 > 31/07/2004        E     Y       Y           Y    Y     Y                B/O
                                    status before starting is 'employed' or 'self employed', the         AND E12 = (01 or 03) AND E13 NOT
                                    learner's employment status must be ;in secure employment' or        = (01 or 02)
                                    'threatened with redundancy'.
New            A10_E08_E12_E13_2    For ESF match aims starting after 31/07/2004, if employment          IF A10 not = 70 AND E08 >               E     Y       Y           Y    Y     Y                B/O
                                    status before starting is 'self employed', the learner's             31/07/2004 AND E12 = 03 AND E13 =
                                    employment status must not be 'unemployed'                           03




LSC 7/8/2011                                                                                                            Cross field validation                                                                                      Page 19 of 26 / 2003/04 DRAFT 1b
                                                                                                              6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                               ESF
From                                                                                                                                                      FE/UFI   WBL    ACL SR                     FE
03/04          Rule                   Rule Description                                                    Metadata                                  E/W    Rule    Rule   Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
New            A10_E08_E12_E14_1      For ESF funded aims starting after 31/07/2004, if employment        IF A10 =70 AND E08 > 31/07/2004            E      Y       Y           Y     Y    Y              B/O
                                      status before starting is 'unemployed', then the Length of          AND E12 = 04 AND E14 = (98 or 99)
                                      unemployment before starting ESF project must not be 'not
                                      known / not provided' or 'not unemployed'.
New            A10_E08_E12_E14_2      For ESF matched aims starting after 31/07/2004, if employment       IF A10 not = 70 AND E08 >                  E      Y       Y           Y    Y     Y                B/O
                                      status before starting is 'unemployed', then the Length of          31/07/2004 AND E12 = 04 AND E14 =
                                      unemployment before starting ESF project must not be 'not           99
                                      unemployed'.
New            A10_E08_E12_E15_1      For ESF funded aims starting after 31/07/2004, if employment        IF A10 = 70 AND E08 > 31/07/2004           E      Y       Y           Y    Y     Y                B/O
                                      status before starting is 'employed', then the Type and size of     AND E12 = 01 AND E15 NOT = (01 or
                                      learner's employer must be 'public sector organisation',            02 or 03)
                                      'small/medium enterprise' or 'large organisation'.

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

New            A10_E08_E17            For LSC ESF co-financed aims starting after 31/07/2004, the         IF E08 > 31/07/2004 AND A10=70             E      Y       Y           Y    Y     Y                B/O
                                      main co-financing activity must not be left as spaces.              AND E17abcde=' '
               A10_E22_1              If the funding stream is 70 then the project dossier number must    If A10 = 70 AND E22 = spaces               E      Y       Y           Y    Y     Y                B/O
                                      be entered
Change         A10_E23_1              If the funding stream is 70 then the local project number must be   If A10 = 70 AND E23 = spaces 000           E      Y       Y           Y    Y     Y                B/O
                                      entered

New            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 and LSC                                             no funding relationship between this
                                                                                                          provider and LLSC
Change         A10_L11_1              FE funded learners should not be 14 or younger on 31st August       IF A10 = 20 AND L11 > 31081989            W       Y                        Y     Y                B/O
                                      of the current teaching year
Change         A10_L24_1              Learner is not eligible for LSC FE or WBL funding if the learner's IF A10 = 20 OR 40 or 41 or 42 AND          W       Y       Y                Y     Y                B/O Need to add the following country of domicile codes to the
                                      country of domicile is not in the European Union. The learner's L24 NOT (on table of European Union                                                                       table of European Country codes. 199 Channel Islands,
                                      country of domicile is not in the UK and Islands or European       Country Codes)                                                                                         639 Czech Republic, 638 Cyprus, 831 Estonia, 670
                                      union and WBL or FE funding is being claimed.                                                                                                                             Hungary, 772 Latvia, 833 Lithuania, 700 Malta, 727
                                                                                                                                                                                                                Poland, 850 Slovakia, 835 Slovenia, 999 Isle of Man.

               A11a _A11b_A17_H17_1   For learners who are HEFCE funded or eligible for HEFCE             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 =               E      Y                        Y     Y                B/O
                                                                                                          A11b
               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 eligible      IF H17 = 000.0 AND ((A11a = 001 OR        W       Y                        Y     Y                B/O
                                      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 < 531           E      Y                        Y     Y                B/O
                                      financed', the implied rate of LSC FE funding for ESF which is      OR > 556
                                      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, the    NOT = 00000000 AND H31 = 00
                                      reason for leaving should be completed
               A11a_H27_N08_1         For the last 2 FE returns of the year, for learners who are HEFCE   IF N08 = ('F04' OR 'F05') AND A11a =      W       Y                        Y     Y                 B    Replaces A11a_H27_T06_1
                                      funded or eligible for HEFCE funding the A/AS level score           (001 OR 002) AND H27 = 00
                                      should be non-zero




LSC 7/8/2011                                                                                                               Cross field validation                                                                                                   Page 20 of 26 / 2003/04 DRAFT 1b
                                                                                                                 6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                                 ESF
From                                                                                                                                                        FE/UFI   WBL    ACL SR                     FE
03/04          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 teaching          >31071988
                                    year
change         A11b_A12b_1          If the source of funding is not 'ESF but not LSC ESF co-                  IF A12b NOT = 000 AND A11b < 536         E      Y                        Y     Y                B/O
                                    financed', the implied rate of LSC FE funding for ESF which is            OR > 556
                                    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 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, the          NOT = 00000000 AND H31 = 00
                                    reason for leaving should be completed
               A11b_H27_N08_1       For the last 2 FE returns of the year, for learners who are HEFCE         IF N08 = ('F04' OR 'F05') AND A11b =    W       Y                        Y     Y                 B    Replaces A11b_H27_T06_1
                                    funded or eligible for HEFCE funding the A/AS level score                 (001 OR 002) AND H27 = 00
                                    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 teaching          >31071987
                                    year
               A13_A14_1            Reason for partial or full non-payment of tuition fees must not be        IF A14 = 99 AND A13 = 00000              E      Y              Y         Y     Y                B/O
                                    ‘Fees paid in full’ if Tuition fee received for year is 0.
               A13_A14_2            If the reason for partial or full non-payment of tuition fees is fee is   IF A14 = 19 AND A13 NOT = 00000          E      Y              Y         Y     Y                B/O
                                    zero, Tuition fee received for year must be 0.
               A14_H20_1            Reason for partial or full non-payment of tuition fees must not be        IF A14 = 99 AND H20 = 98                 E      Y                        Y     Y                B/O
                                    'fees paid in full' if the major source of tuition fees is 'no fees'

Change         A14_L11_1            Reason for partial or full non-payment of tuition fees must not be        IF L11 < 01081939 AND A14 = 15           E      Y                        Y     Y                B/O Learners of pensionable age cannot claim job seeker's
                                    Job seeker’s allowance if the learner is 65 or over at the 1st of                                                                                                             allowance
                                    August of the training year.
Change         A14_L11_2            Reason for partial or full non-payment of tuition fees must not be        IF L11 < 01081981 AND A14 = 01           E      Y                        Y     Y                B/O Providers cannot charge fees to 16-18 year olds and this
                                    ‘fees waived - 16-18 year old learner; provision funded by the                                                                                                                is the absolute limit of age of learners with 16-18 eligibility
                                    LSC’, if the learner is 23 or over at the 1st August of the training
                                    year.
               A15_A26_2            Sector code must not be entered if the programme type not =               IF A15 NOT =(02 OR 03) AND A26           E              Y                Y     Y                B/O Reflects downgrade for Maximise PMR change
                                    FMA and AMA                                                               NOT = 000
new            A15_A26_A27_1        Sector code must be entered for subsiduary aims if the                    IF (A15 = 02 OR 03) AND A26 = 000        E              Y                Y     Y                B/O
                                    programme type is FMA or AMA for starts after 31 July 2004                AND A27 > 31/07/2004
               A15_A27_A53_1        Learners without additional needs who started after on or after           IF A53 = 97 AND A15 = 04 AND A27         E              Y                Y     Y                B/O 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)
               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
               A15_A53_1            If programme type is not AMA, FMA or NVQ learning, Additional             IF A15 NOT = (02 OR 03 OR 04 OR          E              Y                Y     Y                B/O
                                    learning needs data must not be entered.                                  05 OR 06 OR 07) AND A53 NOT = 0

New            A16_AD02             the programme entry type must be not be direct for programmes             IF A16 = 01 and AD02 > 01/08/2003        E              Y                Y     Y                B/O
                                    starting after 1 August 2003

               A17_A32_1            If the Delivery Mode is 'Absent for the year', the Guided Learning        IF A17 = 6 AND A32 NOT = 0               E      Y                        Y     Y           Y    B/O
                                    Hours must be zero
New            A17_A18_A32_1        The guided learning hours should not be zero unless the Delivery          IF (A17 NOT = 6) AND (A18 not =03       W       Y                        Y     Y                B/O
                                    Mode is 'absent for the year' or the main delivery method is              AND A18 not = 05) AND A32 = 0
                                    'distance learning' or 'E-Learning'.
               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'




LSC 7/8/2011                                                                                                                 Cross field validation                                                                                                      Page 21 of 26 / 2003/04 DRAFT 1b
                                                                                                          6243854d-c878-4edd-973b-773ced327163.xls




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

               A27_A28_A32_1   If the GLH is greater than 60, then the value divided by the          IF A32 > 60 AND A32/(A28-A27+1)            E      Y       Y      Y         Y     Y                B/O
                               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     Y                B/O
                               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     Y                B/O
                               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 date IF A31 NOT = 00000000 AND A31 <            E      Y       Y      Y    Y    Y     Y           Y    B/O
                                                                                                     A27
               A27_A40_1       NVQ achievement date must be greater than or equal to the start IF A40 NOT NULL AND A40 NOT >                    E              Y                Y     Y                B/O
                               date if entered                                                       A27
               A27_A43_1       Sector Framework achievement date must be greater than or             IF A43 NOT NULL AND A43 NOT >              E              Y                Y     Y                B/O
                               equal to the start date if entered                                    A27
               A27_E08_1       The ESF start date must not be before the learning start date on IF E08 < A27                                    E      Y       Y           Y    Y     Y                B/O
                               the aim to which the ESF record is attached
               A27_L11_1       Start date must be after date of birth                                IF L11 > A27                               E      Y       Y      Y    Y    Y     Y                B/O
Change         A27_L11_2       Must be more than 12 years old at start for non WBL funded            IF A27 - L11 < 12 years AND A10            E              Y           Y    Y     Y                B/O
                               learning aims                                                         NOT = (40 or 41 or 42)
               A27_L11_3       Should be less than 100 years old at start                            IF A27 - L11 > 100 years                  W       Y       Y      Y    Y    Y     Y                B/O
               A27_L11_6       Should Must be more than 4 years old at start                         IF A27 - L11 < 4 years                    W       Y                        Y     Y                B/O
               A31_A34_1       Completion status must not be ‘the learner is continuing or           IF A34 = 1 AND A31 NOT = NULL             E       Y       Y      Y    Y    Y     Y           Y    B/O
                               intending to continue the learning activities leading to the
                               learning aim’ if the Learning actual end date is completed.
               A31_A34_2       Completion status must be ‘the learner is continuing or intending IF A34 NOT = 1 AND A31 = NULL                  E      Y       Y      Y    Y    Y     Y           Y    B/O
                               to continue the learning activities leading to the learning aim’ if
                               the Learning actual end date is not completed.

New            A31_A40_1       If the achievement date is entered the actual end date must be          IF A40 NOT = NULL AND A31 =              E              Y                Y     Y                B/O
                               entered                                                                 NULL


               A31_A50_2       If there is a learning actual end date then the learner must not be IF A50 = 96 and A31 NOT=0                    E              Y                y     y                B/O
                               continuing
               A31_E10_1       If present, the Actual End Date on the aim should not be before IF A31 NOT = NULL AND E10 NOT =                 W       Y       Y           Y    Y     Y                B/O
                               the ESF end date                                                     NULL AND E10 > A31
New            A31_E10_2       If the learning actual end date is entered, then the date ended      IF A31 NOT = NULL AND E10 =                 E      Y       Y           Y    Y     Y                B/O
                               ESF co-financing must be entered.                                    NULL
New            A31_L39_1                                                                            IF A31 continuing
                               If the learning actual end date is not entered, then the destination must be= null AND L39 not = 95              E              Y           Y    Y     Y                B/O

               A31_T08_1       Must be on or before file creation date if entered                    IF A31 NOT = 00000000 AND A31 >            E              Y           Y    Y     Y                 B
                                                                                                     T08
               A34_A35_1       If the Learning outcome is ‘study continuing’, the Completion         IF A34 NOT = 1 AND A35 = 9                 E      Y              Y         Y     Y                B/O
                               Status must be set to ‘the learner is continuing or intending to
                               continue the learning activities leading to the learning aim’,
               A34_A35_2       If the Completion Status is ‘the learner is continuing or intending IF A35 NOT = 9 AND A34 = 1                   E      Y              Y         Y     Y                B/O
                               to continue the learning activities leading to the learning aim’, the
                               Learning outcome must be set to is ‘study continuing’.




LSC 7/8/2011                                                                                                          Cross field validation                                                                                                 Page 22 of 26 / 2003/04 DRAFT 1b
                                                                                                                 6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                                 ESF
From                                                                                                                                                        FE/UFI   WBL    ACL SR                     FE
03/04          Rule                 Rule Description                                                          Metadata                                E/W    Rule    Rule   Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
               A34_A39_1            Where the Eligibility for achiement funding is set to 'achievement        IF A39 = 1 OR 2 AND A34 = 1              E      Y                         Y    Y          Y   B/O
                                    funding claimed' or 'partial achievement funding claimed' the
                                    Completion status must 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 ' OR     E      Y                        Y     Y                B/O
                                    grade is 'FL', 'U ', N ', 'X ' or 'Y '                                    'N ' OR 'X ' OR 'Y '
               A35_A36_2            Learning Outcome Grade must be set to 'FL','U ', 'N ', 'X ', 'Y ' or '    IF A35 = 3 AND A36 NOT = ('FL' OR        E      Y                        Y     Y                B/O
                                    ' if Learning outcome is set to ‘no achievement’                          'U ' OR 'N ' OR 'X ' OR 'Y ' OR ' ')

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

               A35_A37_1            For partial achievement there must be an entry in units                   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'
New            A35_A40_1            If the Achievement Date is entered then the Learning Outcome              IF A40 NOT = 00000000 AND A35            E              Y                Y     Y                B/O
                                    must be 'achieved'                                                        NOT = 1


New            A35_A40_LAD_1        If the Learning Outcome is 'achieved' then the Achievement Date           IF FLAG11 on LEARNING_AIM table          E              Y                Y     Y                B/O
                                    must be entered for all learning aims except for sector framework         in LAD not = "Y" AND A35 = 1 AND
                                    class codes                                                               A40 = 00000000
New            A35_A43_LAD_1        If the learning outcome is 'achieved' then the Sector framework           IF FLAG11 on LEARNING_AIM table          E              Y                Y     Y                B/O
                                    acheivement date must be entered for sector framework class               in LAD = "Y" AND A35 = 1 AND A43 =
                                    codes                                                                     00000000
New            A35_A43_LAD_2        If the Sector framework Achievement Date is entered then the              IF FLAG11 on LEARNING_AIM table          E              Y                Y     Y                B/O
                                    Learning Outcome must be 'achieved' for sector framework class            in LAD = "Y" AND A43 NOT =
                                    codes                                                                     00000000 AND A35 NOT = 1
               A40_T08_1            Achievement date must be on or before the file creation date              IF A40 > T08                             E              Y                Y     Y                 B
               A46a_A46b_1          National Learning Aim Monitoring values must be different                 IF A46a NOT = 99 AND A46a = A46b         E      Y       Y      Y         Y     Y                B/O
                                    unless they are both 99
New            A46a_A46b_A32_1      If the learning aims is delivered under a WBL basic skills pilot          IF (A46a = 27 or A46b = 27) AND A32      E              Y                Y     Y                B/O
                                    the the guided learning hours must not be 00000                           = 00000
New            A46a_A46B_A32_2      If the learning aim is not delivered under a WBL basic skills pilot       IF A46a NOT = 27 and A46b NOT =          E              Y                Y     Y                B/O
                                    then the guided learning hours must be zero                               27 AND A32 <> 00000
new            AD02_A16_A26_LAD_1   If sector framework code is entered, and if that framework has a          IF A26 NOT=000 AND                       E              Y                Y     Y     Y          B/O Many sector codes are no longer valid for new framework
                                    non-null 'EFFECTIVE_TO' date, then learner must not start the             EFFECTIVE_TO (from                                                                                  programmes
                                    programme after that date if the Programme Entry Route is 'First-         SECTOR_FRAMEWORKS table)
                                    Time Entrant' and programme start date is after 31/07/2004                NOT=Null AND (A16=09 or A16=10)
                                                                                                              AND AD02>EFFECTIVE_TO (from
                                                                                                              SECTOR_FRAMEWORKS table) and
                                                                                                              AD02>31/07/2004
               E08_E09_1            Planned end date must be on or after start date                           IF E09 < E08                             E      Y       Y           Y    Y     Y                B/O
               E08_E10_1            Actual end date must be on or after start date                            IF E10 < E08                             E      Y       Y           Y    Y     Y                B/O
               E08_T08_1            ESF Start date must be on or before file creation date                    E08 > T08                                E      Y       Y           Y    Y     Y                 B
New            E11_E12_1            If employment status before starting is 'full time education',            IF E12 = (02 or 04 or 05) AND E11        E      Y       Y           Y    Y     Y                B/O
                                    'unemployed' or 'still at school',then the industrial sector of           NOT = 99
                                    learner's employer must be 'no employer'.
               E12_E13_2            If Employment Status on day before start is unemployed                    IF E12 = 04 AND E13 NOT = 03             E      Y       Y           Y    Y     Y                B/O
                                    learner's employment status must be unemployed
               E12_E13_4            If Employment Status on day before start is employed, learner's           IF E12= 01 AND E13 = 03                  E      Y       Y           Y    Y     Y                B/O
                                    employment status cannot be unemployed
New            E12_E13_5            If employment status before starting is 'full time education' or 'still   IF E12 = (02 or 05) AND E13 NOT =        E      Y       Y           Y    Y     Y                B/O
                                    at school', then the learner's employment status must be 'not             98
                                    known / not provided'.
               E12_E14_2            Length of Unemployment must be Not Unemployed or Not                      IF E12 NOT = 04 AND (E14 NOT = 99        E      Y       Y           Y    Y     Y                B/O
                                    Known/not provided if Employment Status at start is not                   Or E14 Not =98)
                                    Unemployed
               E12_E14_3            Length of Unemployment must not be Not Unemployed if                      IF E12 = 04 AND E14 = 99                 E      Y       Y           Y    Y     Y                B/O
                                    Employment Status at start is Unemployed.




LSC 7/8/2011                                                                                                                 Cross field validation                                                                                                  Page 23 of 26 / 2003/04 DRAFT 1b
                                                                                                    6243854d-c878-4edd-973b-773ced327163.xls




                                                                                                                                                                     ESF
From                                                                                                                                            FE/UFI   WBL    ACL SR                     FE
03/04          Rule         Rule Description                                                     Metadata                                 E/W    Rule    Rule   Rule Rule LIS? Core? Ext? Fund? B/O Business Reason for Rule
New            E12_E14_4    If employment status before starting is 'employed','full time        IF E12 = (01 or 02 or 03 or 05) AND       E      Y       Y           Y     Y    Y              B/O
                            education','self employed' or 'still at school, then the Length of   E14 NOT = 99
                            unemployment before starting ESF project must be 'not
                            unemployed'.
New            E12_E15_1    If employment status before starting is 'self employed', then the    IF E12 = 03 AND E15 NOT = 02              E      Y       Y           Y    Y     Y                B/O
                            Type and size of learner's employer must be 'small/medium
                            enterprise'.
New            E12_E15_2    If employment status before starting is 'full time education',       IF E12 = (02 or 04 or 05) AND E15         E      Y       Y           Y    Y     Y                B/O
                            unemployed' or 'still at school', then the Type and size of          NOT = 99
                            learner's employer must be 'not employed'.
change         E16abcde_1   Addressing Gender Stereotyping entries must all be different if     IF E16a = (E16b OR E16c OR E16d            E      Y       Y           Y    Y     Y                B/O
                            entered                                                             OR E16e) OR E16b = (E16c OR E16d
                                                                                                OR E16e) OR E16c = (E16d or E16e)
                                                                                                OR E16d = E16e
               E17abcde_1   Main Co-financing Activity entries must all be different if entered IF E17a = (E17b OR E17c OR E17d            E      Y       Y           Y    Y     Y                B/O
                                                                                                OR E17e) OR E17b = (E17c OR E17d
                                                                                                OR E17e) OR E17c = (E17d or E17e)
                                                                                                OR E17d = E17e
Change         E18abcd_1    Delivery Mode entries must all be different if entered              IF E18a = (E18b OR E18c OR E18d)           E      Y       Y           Y    Y     Y                B/O
                                                                                                OR E18b = (E18c OR E18d) OR E18c
                                                                                                = 18d
change         E19abcde_1   Support measures to be accessed by the learner entries must all IF E19a = (E19b OR E19c OR E19d                E      Y       Y           Y    Y     Y                B/O
                            be different if entered                                             OR E19e) OR E19b = (E19c OR E19d
                                                                                                OR E19e) OR E19c = (E19d or E19e)
                                                                                                OR E19d = E19e
               E20abc_1     Learner background must all be different if entered                 IF E20a = (E20b OR E20c) OR E20b           E      Y       Y           Y    Y     Y                B/O
                                                                                                = E20c
               H11_H12_1    A new entrant to HE should not already hold an HE level             IF H12 = 1 AND H11 = (01 OR 02 OR         W       Y                        Y     Y                B/O
                            qualification                                                       03 OR 04 OR 05 OR 10 OR 11 OR 15
                                                                                                OR 16 OR 21 OR 22 OR 23 OR 24
                                                                                                OR 25 OR 27 OR 28)
               H20_L24_1    Major Source of Tuition Fees should be consistent with Country IF H20 = 02 OR 04 AND L24 = 299                W       Y                        Y     Y                B/O
                            of Domicile
               H20_L24_2    Major Source of Tuition Fees should be consistent with Country IF H20 = 02 OR 03 AND L24 = 099                W       Y                        Y     Y                B/O
                            of Domicile




LSC 7/8/2011                                                                                                     Cross field validation                                                                                        Page 24 of 26 / 2003/04 DRAFT 1b

				
DOCUMENT INFO
Description: Printable Blank Birth and Death Certificates document sample