«

• 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

Apprentice changes provider scenarios

• Apprentice changes provider but remains with the same employer, and there is a gap between the two learning spells

  • Given The learner is programme only DAS
  • And levy balance > agreed price for all months
  • And the apprenticeship funding band maximum is 15000
  • And the following commitments exist:

    commitment Id	version Id	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	provider a	learner a	01/08/2017	01/08/2018	7500	active	01/08/2017	04/03/2018
    1	2	provider a	learner a	01/08/2017	01/08/2018	7500	cancelled	05/03/2018
    2	1	provider b	learner a	01/06/2018	01/11/2018	4500	active	06/06/2018

  • When the providers submit the following ILR files:

    Provider	ULN	start date	planned end date	actual end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date
    provider a	learner a	06/08/2017	08/08/2018	04/03/2018	withdrawn	6000	06/08/2017	1500	06/08/2017
    provider b	learner a	06/06/2018	20/11/2018		continuing	3000	06/06/2018	1500	06/06/2018

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	...	02/18	03/18	04/18	05/18	06/18	07/18	08/18	09/18	10/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	...	commitment 1 v1				commitment 2 v1	commitment 2 v1	commitment 2 v1	commitment 2 v1	commitment 2 v1

  • And the earnings and payments break down for provider a is as follows:

    Type	08/17	09/17	10/17	...	02/18	03/18
    Provider Earned Total	500	500	500	...	500	0
    Provider Earned from SFA	500	500	500	...	500	0
    Provider Earned from Employer	0	0	0	...	0	0
    Provider Paid by SFA	0	500	500	...	500	500
    Payment due from Employer	0	0	0	...	0	0
    Levy account debited	0	500	500	...	500	500
    SFA Levy employer budget	500	500	500	...	500	0
    SFA Levy co-funding budget	0	0	0	...	0	0
    SFA non-Levy co-funding budget	0	0	0	...	0	0

  • And the earnings and payments break down for provider b is as follows:

    Type	06/18	07/18	08/18	09/18	10/18	11/18
    Provider Earned Total	720	720	720	720	720	0
    Provider Earned from SFA	720	720	720	720	720	0
    Provider Earned from Employer	0	0	0	0	0	0
    Provider Paid by SFA	0	720	720	720	720	720
    Payment due from Employer	0	0	0	0	0	0
    Levy account debited	0	720	720	720	720	720
    SFA Levy employer budget	720	720	720	720	720	0
    SFA Levy co-funding budget	0	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0	0	0

• Apprentice changes provider but remains with the same employer

  • Given The learner is programme only DAS
  • And levy balance > agreed price for all months
  • And the apprenticeship funding band maximum is 15000
  • And the following commitments exist:

    commitment Id	version Id	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	provider a	learner a	01/08/2017	01/08/2018	7500	active	01/08/2017	04/03/2018
    1	2	provider a	learner a	01/08/2017	01/08/2018	7500	cancelled	05/03/2018
    2	1	provider b	learner a	05/03/2018	01/08/2018	4500	active	05/03/2018

  • When the providers submit the following ILR files:

    Provider	ULN	start date	planned end date	actual end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date
    provider a	learner a	06/08/2017	08/08/2018	04/03/2018	withdrawn	6000	06/08/2017	1500	06/08/2017
    provider b	learner a	05/03/2018	20/08/2018		continuing	3000	05/03/2018	1500	05/03/2018

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	...	02/18	03/18	04/18	05/18	06/18	07/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	...	commitment 1 v1	commitment 2 v1	commitment 2 v1	commitment 2 v1	commitment 2 v1	commitment 2 v1

  • And the earnings and payments break down for provider a is as follows:

    Type	08/17	09/17	10/17	...	02/18	03/18
    Provider Earned Total	500	500	500	...	500	0
    Provider Earned from SFA	500	500	500	...	500	0
    Provider Earned from Employer	0	0	0	...	0	0
    Provider Paid by SFA	0	500	500	...	500	500
    Payment due from Employer	0	0	0	...	0	0
    Levy account debited	0	500	500	...	500	500
    SFA Levy employer budget	500	500	500	...	500	0
    SFA Levy co-funding budget	0	0	0	...	0	0
    SFA non-Levy co-funding budget	0	0	0	...	0	0

  • And the earnings and payments break down for provider b is as follows:

    Type	03/18	04/18	05/18	06/18	07/18	08/18
    Provider Earned Total	720	720	720	720	720	0
    Provider Earned from SFA	720	720	720	720	720	0
    Provider Earned from Employer	0	0	0	0	0	0
    Provider Paid by SFA	0	720	720	720	720	720
    Payment due from Employer	0	0	0	0	0	0
    Levy account debited	0	720	720	720	720	720
    SFA Levy employer budget	720	720	720	720	720	0
    SFA Levy co-funding budget	0	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0	0	0

• Apprentice changes provider but remains with the same employer, ILR changes after the new commitment is in place

  • Given The learner is programme only DAS
  • And levy balance > agreed price for all months
  • And the apprenticeship funding band maximum is 15000
  • And the following commitments exist:

    commitment Id	version Id	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	provider a	learner a	01/08/2017	01/08/2018	7500	active	01/08/2017	04/03/2018
    1	2	provider a	learner a	01/08/2017	01/08/2018	7500	cancelled	05/03/2018
    2	1	provider b	learner a	05/03/2018	01/08/2018	4500	active	05/03/2018

  • When the providers submit the following ILR files:

    Provider	ULN	start date	planned end date	actual end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date
    provider a	learner a	06/08/2017	08/08/2018	04/04/2018	withdrawn	6000	06/08/2017	1500	06/08/2017
    provider b	learner a	05/04/2018	08/08/2018		continuing	3000	05/04/2018	1500	05/04/2018

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	...	02/18	03/18	04/18	05/18	06/18	07/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	...	commitment 1 v1		commitment 2 v1	commitment 2 v1	commitment 2 v1	commitment 2 v1

  • And the earnings and payments break down for provider a is as follows:

    Type	08/17	09/17	10/17	...	02/18	03/18	04/18
    Provider Earned Total	500	500	500	...	500	500	0
    Provider Earned from SFA	500	500	500	...	500	0	0
    Provider Earned from Employer	0	0	0	...	0	0	0
    Provider Paid by SFA	0	500	500	...	500	500	0
    Payment due from Employer	0	0	0	...	0	0	0
    Levy account debited	0	500	500	...	500	500	0
    SFA Levy employer budget	500	500	500	...	500	0	0
    SFA Levy co-funding budget	0	0	0	...	0	0	0
    SFA non-Levy co-funding budget	0	0	0	...	0	0	0

  • And the earnings and payments break down for provider b is as follows:

    Type	04/18	05/18	06/18	07/18	08/18
    Provider Earned Total	900	900	900	900	0
    Provider Earned from SFA	900	900	900	900	0
    Provider Earned from Employer	0	0	0	0	0
    Provider Paid by SFA	0	900	900	900	900
    Payment due from Employer	0	0	0	0	0
    Levy account debited	0	900	900	900	900
    SFA Levy employer budget	900	900	900	900	0
    SFA Levy co-funding budget	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0	0

• Apprentice changes provider but remains with the same employer, ILR changes before the new commitment is in place

  • Given The learner is programme only DAS
  • And levy balance > agreed price for all months
  • And the apprenticeship funding band maximum is 15000
  • And the following commitments exist:

    commitment Id	version Id	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	provider a	learner a	01/08/2017	01/08/2018	7500	active	01/08/2017	04/03/2018
    1	2	provider a	learner a	01/08/2017	01/08/2018	7500	cancelled	05/03/2018
    2	1	provider b	learner a	05/03/2018	01/08/2018	4500	active	05/03/2018

  • When the providers submit the following ILR files:

    Provider	ULN	start date	planned end date	actual end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date
    provider a	learner a	06/08/2017	08/08/2018	04/02/2018	withdrawn	6000	06/08/2017	1500	06/08/2017
    provider b	learner a	05/02/2018	20/08/2018		continuing	3000	05/02/2018	1500	05/02/2018

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	...	01/18	02/18	03/18	04/18	...	07/18	08/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	...	commitment 1 v1				...

  • And the earnings and payments break down for provider a is as follows:

    Type	08/17	09/17	10/17	...	01/18	02/18
    Provider Earned Total	500	500	500	...	500	0
    Provider Earned from SFA	500	500	500	...	500	0
    Provider Earned from Employer	0	0	0	...	0	0
    Provider Paid by SFA	0	500	500	...	500	500
    Payment due from Employer	0	0	0	...	0	0
    Levy account debited	0	500	500	...	500	500
    SFA Levy employer budget	500	500	500	...	500	0
    SFA Levy co-funding budget	0	0	0	...	0	0
    SFA non-Levy co-funding budget	0	0	0	...	0	0

  • And the earnings and payments break down for provider b is as follows:

    Type	02/18	03/18	04/18	...	07/18	08/18
    Provider Earned Total	600	600	600	...	600	0
    Provider Earned from SFA	0	0	0	...	0	0
    Provider Earned from Employer	0	0	0	...	0	0
    Provider Paid by SFA	0	0	0	...	0	0
    Payment due from Employer	0	0	0	...	0	0
    Levy account debited	0	0	0	...	0	0
    SFA Levy employer budget	0	0	0	...	0	0
    SFA Levy co-funding budget	0	0	0	...	0	0
    SFA non-Levy co-funding budget	0	0	0	...	0	0

• 1 learner aged 16-18, levy available, changes provider, earns incentive payment in the transfer month - and the date at which the incentive is earned is before the transfer date

  • Given levy balance > agreed price for all months
  • And the apprenticeship funding band maximum is 15000
  • And the following commitments exist:

    commitment Id	version Id	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	provider a	learner a	01/08/2017	01/08/2018	7500	active	01/08/2017	14/11/2017
    1	2	provider a	learner a	01/08/2017	01/08/2018	7500	cancelled	15/11/2017
    2	1	provider b	learner a	15/11/2017	01/08/2018	5625	active	15/11/2017

  • When the providers submit the following ILR files:

    Provider	learner type	ULN	start date	planned end date	actual end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    provider a	16-18 programme only DAS	learner a	06/08/2017	08/08/2018	14/11/2017	withdrawn	6000	06/08/2017	1500	06/08/2017
    provider b	16-18 programme only DAS	learner a	15/11/2017	08/08/2018		continuing					4000	15/11/2017	1625	15/11/2017

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	11/17	12/17	01/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	commitment 2 v1	commitment 2 v1	commitment 2 v1
    Employer 16-18 incentive				commitment 1 v1
    Provider 16-18 incentive				commitment 1 v1

  • And the earnings and payments break down for provider a is as follows:

    Type	08/17	09/17	10/17	11/17	12/17
    Provider Earned Total	500	500	500	1000	0
    Provider Earned from SFA	500	500	500	1000	0
    Provider Earned from Employer	0	0	0	0	0
    Provider Paid by SFA	0	500	500	500	1000
    Payment due from Employer	0	0	0	0	0
    Levy account debited	0	500	500	500	0
    SFA Levy employer budget	500	500	500	0	0
    SFA Levy co-funding budget	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0	0
    SFA Levy additional payments budget	0	0	0	1000	0

  • And the transaction types for the payments for provider a are:

    Payment type	09/17	10/17	11/17	12/17
    On-program	500	500	500	0
    Completion	0	0	0	0
    Balancing	0	0	0	0
    Employer 16-18 incentive	0	0	0	500
    Provider 16-18 incentive	0	0	0	500

  • And the earnings and payments break down for provider b is as follows:

    Type	11/17	12/17	01/18
    Provider Earned Total	500	500	500
    Provider Earned from SFA	500	500	500
    Provider Earned from Employer	0	0	0
    Provider Paid by SFA	0	500	500
    Payment due from Employer	0	0	0
    Levy account debited	0	500	500
    SFA Levy employer budget	500	500	500
    SFA Levy co-funding budget	0	0	0
    SFA non-Levy co-funding budget	0	0	0
    SFA Levy additional payments budget	0	0	0

  • And the transaction types for the payments for provider b are:

    Payment type	11/17	12/17	01/18
    On-program	0	500	500
    Completion	0	0	0
    Balancing	0	0	0
    Employer 16-18 incentive	0	0	0
    Provider 16-18 incentive	0	0	0

• 1 learner aged 16-18, levy available, changes provider, earns incentive payment in the commitment transfer month - and the ILR transfer happens in a later month

  • Given levy balance > agreed price for all months
  • And the apprenticeship funding band maximum is 15000
  • And the following commitments exist:

    commitment Id	version Id	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	provider a	learner a	01/08/2017	01/08/2018	7500	active	01/08/2017	14/11/2017
    1	2	provider a	learner a	01/08/2017	01/08/2018	7500	cancelled	15/11/2017
    2	1	provider b	learner a	15/11/2017	01/08/2018	5625	active	15/11/2017

  • When the providers submit the following ILR files:

    Provider	learner type	ULN	start date	planned end date	actual end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    provider a	16-18 programme only DAS	learner a	06/08/2017	08/08/2018	14/12/2017	withdrawn	6000	06/08/2017	1500	06/08/2017
    provider b	16-18 programme only DAS	learner a	15/12/2017	08/09/2018		continuing					4000	15/12/2017	1625	15/12/2017

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	11/17	12/17	01/18	02/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1		commitment 2 v1	commitment 2 v1	commitment 2 v1
    Employer 16-18 incentive				commitment 1 v1
    Provider 16-18 incentive				commitment 1 v1

  • And the earnings and payments break down for provider a is as follows:

    Type	08/17	09/17	10/17	11/17	12/17
    Provider Earned Total	500	500	500	1500	0
    Provider Earned from SFA	500	500	500	1000	0
    Provider Earned from Employer	0	0	0	0	0
    Provider Paid by SFA	0	500	500	500	1000
    Payment due from Employer	0	0	0	0	0
    Levy account debited	0	500	500	500	0
    SFA Levy employer budget	500	500	500	0	0
    SFA Levy co-funding budget	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0	0
    SFA Levy additional payments budget	0	0	0	1000	0

  • And the transaction types for the payments for provider a are:

    Payment type	09/17	10/17	11/17	12/17
    On-program	500	500	500	0
    Completion	0	0	0	0
    Balancing	0	0	0	0
    Employer 16-18 incentive	0	0	0	500
    Provider 16-18 incentive	0	0	0	500

  • And the earnings and payments break down for provider b is as follows:

    Type	11/17	12/17	01/18	02/18
    Provider Earned Total	0	500	500	500
    Provider Earned from SFA	0	500	500	500
    Provider Earned from Employer	0	0	0	0
    Provider Paid by SFA	0	0	500	500
    Payment due from Employer	0	0	0	0
    Levy account debited	0	0	500	500
    SFA Levy employer budget	0	500	500	500
    SFA Levy co-funding budget	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0
    SFA Levy additional payments budget	0	0	0	0

  • And the transaction types for the payments for provider b are:

    Payment type	11/17	12/17	01/18	02/18
    On-program	0	0	500	500
    Completion	0	0	0	0
    Balancing	0	0	0	0
    Employer 16-18 incentive	0	0	0	0
    Provider 16-18 incentive	0	0	0	0

• 1 learner aged 16-18, levy available, changes provider, earns incentive payment in the commitment transfer month - and the ILR transfer happens at an earlier point than the commitment

  • Given levy balance > agreed price for all months
  • And the apprenticeship funding band maximum is 15000
  • And the following commitments exist:

    commitment Id	version Id	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	provider a	learner a	01/08/2017	01/08/2018	7500	active	01/08/2017	14/11/2017
    1	2	provider a	learner a	01/08/2017	01/08/2018	7500	cancelled	15/11/2017
    2	1	provider b	learner a	15/11/2017	01/08/2018	5625	active	15/11/2017

  • When the providers submit the following ILR files:

    Provider	learner type	ULN	start date	planned end date	actual end date	completion status	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    provider a	16-18 programme only DAS	learner a	06/08/2017	08/08/2018	09/11/2017	withdrawn	6000	06/08/2017	1500	06/08/2017
    provider b	16-18 programme only DAS	learner a	10/11/2017	08/08/2018		continuing					4000	10/11/2017	1625	10/11/2017

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	11/17	12/17	01/18	02/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1
    Employer 16-18 incentive				commitment 1 v1
    Provider 16-18 incentive				commitment 1 v1

  • And the earnings and payments break down for provider a is as follows:

    Type	08/17	09/17	10/17	11/17	12/17
    Provider Earned Total	500	500	500	1000	0
    Provider Earned from SFA	500	500	500	1000	0
    Provider Earned from Employer	0	0	0	0	0
    Provider Paid by SFA	0	500	500	500	1000
    Payment due from Employer	0	0	0	0	0
    Levy account debited	0	500	500	500	0
    SFA Levy employer budget	500	500	500	0	0
    SFA Levy co-funding budget	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0	0
    SFA Levy additional payments budget	0	0	0	1000	0

  • And the transaction types for the payments for provider a are:

    Payment type	09/17	10/17	11/17	12/17
    On-program	500	500	500	0
    Completion	0	0	0	0
    Balancing	0	0	0	0
    Employer 16-18 incentive	0	0	0	500
    Provider 16-18 incentive	0	0	0	500

  • And the earnings and payments break down for provider b is as follows:

    Type	11/17	12/17	01/18	02/18
    Provider Earned Total	500	500	500	500
    Provider Earned from SFA	0	0	0	0
    Provider Earned from Employer	0	0	0	0
    Provider Paid by SFA	0	0	0	0
    Payment due from Employer	0	0	0	0
    Levy account debited	0	0	0	0
    SFA Levy employer budget	0	0	0	0
    SFA Levy co-funding budget	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0
    SFA Levy additional payments budget	0	0	0	0

  • And the transaction types for the payments for provider b are:

    Payment type	11/17	12/17	01/18	02/18
    On-program	0	0	0	0
    Completion	0	0	0	0
    Balancing	0	0	0	0
    Employer 16-18 incentive	0	0	0	0
    Provider 16-18 incentive	0	0	0	0

Generated on: 30 April 2017 10:14:04

Produced by Pickles, version 2.8.2.0