«

• Home
• 1 learner aged 16-18, non-DAS, employed with a small employer at start, is fully funded for on programme and completion payments
• 16 to 18 learner incentives, framework uplifts, level 2 english or maths payments
• 2 learners, paid in priority order
• Amount due is calculated based on previously earned amount
• Apprentice changes provider scenarios
• Business definitions
• Calculate the payments
• Datalock produces correct errors when ILR does not match commitment
• Employer stops payments on a commitment
• Provider adjustments (EAS) payments
• Provider earnings and payments for a learner with a negotiated price above the funding band cap
• Provider earnings and payments where a learner changes employers
• Provider earnings and payments where learner changes apprenticeship standard or there is a change to the negotiated price at the end of a month, remaining with the same employer and provider
• Provider earnings and payments where learner completes earlier than planned
• Provider earnings and payments where learner completes later than planned
• Provider earnings and payments where learner completes on time and is funded by levy
• Provider earnings and payments where learner refund payments are due
• The ILR is submitted late

Datalock produces correct errors when ILR does not match commitment

• DLOCK07 - When no matching record found in an employer digital account for for the agreed price then datalock DLOCK_07 will be produced

  • Given the following commitments exist:

    commitment Id	version Id	Provider	ULN	framework code	programme type	pathway code	agreed price	start date	end date	status	effective from
    73	125	Provider a	learner a	450	2	1	10000	01/05/2017	01/05/2018	active	01/05/2017

  • When an ILR file is submitted with the following data:

    Provider	ULN	framework code	programme type	pathway code	start date	planned end date	completion status	Total training price	Total training price effective date
    Provider a	learner a	450	2	1	01/05/2017	08/08/2018	continuing	10010	01/05/2017

  • Then the following data lock event is returned:

    Price Episode identifier	Apprenticeship Id	ULN	ILR Start Date	ILR Training Price
    2-450-1-01/05/2017	73	learner a	01/05/2017	10010

  • And the data lock event has the following errors:

    Price Episode identifier	Error code	Error Description
    2-450-1-01/05/2017	DLOCK_07	No matching record found in the employer digital account for the negotiated cost of training

  • And the data lock event has the following periods

    Price Episode identifier	Period	Payable Flag	Transaction Type
    2-450-1-01/05/2017	1617-R10	false	Learning
    2-450-1-01/05/2017	1617-R11	false	Learning
    2-450-1-01/05/2017	1617-R12	false	Learning

  • And the data lock event used the following commitments

    Price Episode identifier	Apprentice Version	Start Date	framework code	programme type	pathway code	Negotiated Price	Effective Date
    2-450-1-01/05/2017	125	01/05/2017	450	2	1	10000	01/05/2017

• DLOCK09 - When no matching record found in an employer digital account for for the start date then datalock DLOCK_09 will be produced

  • Given the following commitments exist:

    commitment Id	version Id	Provider	ULN	standard code	agreed price	start date	end date	status	effective from
    73	125	Provider a	learner a	23	10000	01/06/2017	01/05/2018	active	01/06/2017

  • When an ILR file is submitted with the following data:

    Provider	ULN	standard code	start date	planned end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date
    Provider a	learner a	23	01/05/2017	08/08/2018	continuing	9000	01/05/2017	1000	01/05/2017

  • Then the following data lock event is returned:

    Price Episode identifier	Apprenticeship Id	ULN	ILR Start Date	ILR Training Price	ILR End point assessment price
    25-23-01/05/2017	73	learner a	01/05/2017	9000	1000

  • And the data lock event has the following errors:

    Price Episode identifier	Error code	Error Description
    25-23-01/05/2017	DLOCK_09	The start date for this negotiated price is before the corresponding price start date in the employer digital account

  • And the data lock event has the following periods

    Price Episode identifier	Period	Payable Flag	Transaction Type
    25-23-01/05/2017	1617-R11	false	Learning
    25-23-01/05/2017	1617-R12	false	Learning

  • And the data lock event used the following commitments

    Price Episode identifier	Apprentice Version	Start Date	standard code	Negotiated Price	Effective Date
    25-23-01/05/2017	125	01/06/2017	23	10000	01/06/2017

• DLOCK03 - When no matching record found in an employer digital account for for the standard code then datalock DLOCK_03 will be produced

  • Given the following commitments exist:

    commitment Id	version Id	Provider	ULN	standard code	agreed price	start date	end date	status	effective from
    73	125	Provider a	learner a	21	10000	01/05/2017	01/05/2018	active	01/05/2017

  • When an ILR file is submitted with the following data:

    Provider	ULN	standard code	start date	planned end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date
    Provider a	learner a	23	01/05/2017	08/08/2018	continuing	9000	01/05/2017	1000	01/05/2017

  • Then the following data lock event is returned:

    Price Episode identifier	Apprenticeship Id	ULN	ILR Start Date	ILR Training Price	ILR End point assessment price
    25-23-01/05/2017	73	learner a	01/05/2017	9000	1000

  • And the data lock event has the following errors:

    Price Episode identifier	Error code	Error Description
    25-23-01/05/2017	DLOCK_03	No matching record found in the employer digital account for the standard code

  • And the data lock event has the following periods

    Price Episode identifier	Period	Payable Flag	Transaction Type
    25-23-01/05/2017	1617-R10	false	Learning
    25-23-01/05/2017	1617-R11	false	Learning
    25-23-01/05/2017	1617-R12	false	Learning

  • And the data lock event used the following commitments

    Price Episode identifier	Apprentice Version	Start Date	standard code	Negotiated Price	Effective Date
    25-23-01/05/2017	125	01/05/2017	21	10000	01/05/2017

• DLOCK04 - When no matching record found in an employer digital account for for the framework code then datalock DLOCK_04 will be produced

  • Given the following commitments exist:

    commitment Id	version Id	Provider	ULN	framework code	programme type	pathway code	agreed price	start date	end date	status	effective from
    73	125	Provider a	learner a	451	2	1	10000	01/05/2017	01/05/2018	active	01/05/2017

  • When an ILR file is submitted with the following data:

    Provider	ULN	framework code	programme type	pathway code	start date	planned end date	completion status	Total training price	Total training price effective date
    Provider a	learner a	450	2	1	01/05/2017	08/08/2018	continuing	10000	01/05/2017

  • Then the following data lock event is returned:

    Price Episode identifier	Apprenticeship Id	ULN	ILR Start Date	ILR Training Price
    2-450-1-01/05/2017	73	learner a	01/05/2017	10000

  • And the data lock event has the following errors:

    Price Episode identifier	Error code	Error Description
    2-450-1-01/05/2017	DLOCK_04	No matching record found in the employer digital account for the framework code

  • And the data lock event has the following periods

    Price Episode identifier	Period	Payable Flag	Transaction Type
    2-450-1-01/05/2017	1617-R10	false	Learning
    2-450-1-01/05/2017	1617-R11	false	Learning
    2-450-1-01/05/2017	1617-R12	false	Learning

  • And the data lock event used the following commitments

    Price Episode identifier	Apprentice Version	Start Date	framework code	programme type	pathway code	Negotiated Price	Effective Date
    2-450-1-01/05/2017	125	01/05/2017	451	2	1	10000	01/05/2017

• DLOCK05 - When no matching record found in an employer digital account for for the programme type then datalock DLOCK_05 will be produced

  • Given the following commitments exist:

    commitment Id	version Id	Provider	ULN	framework code	programme type	pathway code	agreed price	start date	end date	status	effective from
    73	125	Provider a	learner a	450	3	1	10000	01/05/2017	01/05/2018	active	01/05/2017

  • When an ILR file is submitted with the following data:

    Provider	ULN	framework code	programme type	pathway code	start date	planned end date	completion status	Total training price	Total training price effective date
    Provider a	learner a	450	2	1	01/05/2017	08/08/2018	continuing	10000	01/05/2017

  • Then the following data lock event is returned:

    Price Episode identifier	Apprenticeship Id	ULN	ILR Start Date	ILR Training Price
    2-450-1-01/05/2017	73	learner a	01/05/2017	10000

  • And the data lock event has the following errors:

    Price Episode identifier	Error code	Error Description
    2-450-1-01/05/2017	DLOCK_05	No matching record found in the employer digital account for the programme type

  • And the data lock event has the following periods

    Price Episode identifier	Period	Payable Flag	Transaction Type
    2-450-1-01/05/2017	1617-R10	false	Learning
    2-450-1-01/05/2017	1617-R11	false	Learning
    2-450-1-01/05/2017	1617-R12	false	Learning

  • And the data lock event used the following commitments

    Price Episode identifier	Apprentice Version	Start Date	framework code	programme type	pathway code	Negotiated Price	Effective Date
    2-450-1-01/05/2017	125	01/05/2017	450	3	1	10000	01/05/2017

• DLOCK06 - When no matching record found in an employer digital account for for the pathway code then datalock DLOCK_06 will be produced

  • Given the following commitments exist:

    commitment Id	version Id	Provider	ULN	framework code	programme type	pathway code	agreed price	start date	end date	status	effective from
    73	125	Provider a	learner a	450	2	6	10000	01/05/2017	01/05/2018	active	01/05/2017

  • When an ILR file is submitted with the following data:

    Provider	ULN	framework code	programme type	pathway code	start date	planned end date	completion status	Total training price	Total training price effective date
    Provider a	learner a	450	2	1	01/05/2017	08/08/2018	continuing	10000	01/05/2017

  • Then the following data lock event is returned:

    Price Episode identifier	Apprenticeship Id	ULN	ILR Start Date	ILR Training Price
    2-450-1-01/05/2017	73	learner a	01/05/2017	10000

  • And the data lock event has the following errors:

    Price Episode identifier	Error code	Error Description
    2-450-1-01/05/2017	DLOCK_06	No matching record found in the employer digital account for the pathway code

  • And the data lock event has the following periods

    Price Episode identifier	Period	Payable Flag	Transaction Type
    2-450-1-01/05/2017	1617-R10	false	Learning
    2-450-1-01/05/2017	1617-R11	false	Learning
    2-450-1-01/05/2017	1617-R12	false	Learning

  • And the data lock event used the following commitments

    Price Episode identifier	Apprentice Version	Start Date	framework code	programme type	pathway code	Negotiated Price	Effective Date
    2-450-1-01/05/2017	125	01/05/2017	450	2	6	10000	01/05/2017

• DLOCK04 + DLOCK05 - When no matching record found in an employer digital account for for the framework code and programme type then datalock DLOCK_04 and DLOCK05 will be produced

  • Given the following commitments exist:

    commitment Id	version Id	Provider	ULN	framework code	programme type	pathway code	agreed price	start date	end date	status	effective from
    73	125	Provider a	learner a	451	3	1	10000	01/05/2017	01/05/2018	active	01/05/2017

  • When an ILR file is submitted with the following data:

    Provider	ULN	framework code	programme type	pathway code	start date	planned end date	completion status	Total training price	Total training price effective date
    Provider a	learner a	450	2	1	01/05/2017	08/08/2018	continuing	10000	01/05/2017

  • Then the following data lock event is returned:

    Price Episode identifier	Apprenticeship Id	ULN	ILR Start Date	ILR Training Price
    2-450-1-01/05/2017	73	learner a	01/05/2017	10000

  • And the data lock event has the following errors:

    Price Episode identifier	Error code	Error Description
    2-450-1-01/05/2017	DLOCK_04	No matching record found in the employer digital account for the framework code
    2-450-1-01/05/2017	DLOCK_05	No matching record found in the employer digital account for the programme type

  • And the data lock event has the following periods

    Price Episode identifier	Period	Payable Flag	Transaction Type
    2-450-1-01/05/2017	1617-R10	false	Learning
    2-450-1-01/05/2017	1617-R11	false	Learning
    2-450-1-01/05/2017	1617-R12	false	Learning

  • And the data lock event used the following commitments

    Price Episode identifier	Apprentice Version	Start Date	framework code	programme type	pathway code	Negotiated Price	Effective Date
    2-450-1-01/05/2017	125	01/05/2017	451	3	1	10000	01/05/2017

• DLOCK04 + DLOCK05 + DLOCK06 - When no matching record found in an employer digital account for for the framework code, programme type and pathway code then datalock DLOCK_04, DLOCK05 and DLOCK06 will be produced

  • Given the following commitments exist:

    commitment Id	version Id	Provider	ULN	framework code	programme type	pathway code	agreed price	start date	end date	status	effective from
    73	125	Provider a	learner a	451	3	6	10000	01/05/2017	01/05/2018	active	01/05/2017

  • When an ILR file is submitted with the following data:

    Provider	ULN	framework code	programme type	pathway code	start date	planned end date	completion status	Total training price	Total training price effective date
    Provider a	learner a	450	2	1	01/05/2017	08/08/2018	continuing	10000	01/05/2017

  • Then the following data lock event is returned:

    Price Episode identifier	Apprenticeship Id	ULN	ILR Start Date	ILR Training Price
    2-450-1-01/05/2017	73	learner a	01/05/2017	10000

  • And the data lock event has the following errors:

    Price Episode identifier	Error code	Error Description
    2-450-1-01/05/2017	DLOCK_04	No matching record found in the employer digital account for the framework code
    2-450-1-01/05/2017	DLOCK_05	No matching record found in the employer digital account for the programme type
    2-450-1-01/05/2017	DLOCK_06	No matching record found in the employer digital account for the pathway code

  • And the data lock event has the following periods

    Price Episode identifier	Period	Payable Flag	Transaction Type
    2-450-1-01/05/2017	1617-R10	false	Learning
    2-450-1-01/05/2017	1617-R11	false	Learning
    2-450-1-01/05/2017	1617-R12	false	Learning

  • And the data lock event used the following commitments

    Price Episode identifier	Apprentice Version	Start Date	framework code	programme type	pathway code	Negotiated Price	Effective Date
    2-450-1-01/05/2017	125	01/05/2017	451	3	6	10000	01/05/2017

Generated on: 30 April 2017 10:14:04

Produced by Pickles, version 2.8.2.0