«

• 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

Provider earnings and payments where learner refund payments are due

Tags: @Refunds

• 673-AC01 DAS learner, levy available, provider retrospectively notifies a withdrawal and previously-paid monthly instalments need to be refunded.

  Tags: @Refunds

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

    commitment Id	version Id	ULN	start date	end date	status	agreed price	effective from	effective to
    1	1	learner a	01/08/2017	01/08/2018	active	11250	01/08/2017

  • And the following earnings and payments have been made to the provider A for learner a:

    Type	08/17	09/17	10/17	11/17	12/17	01/18
    Provider Earned Total	750	750	750	750	750	0
    Provider Earned from SFA	750	750	750	750	750	0
    Provider Earned from Employer	0	0	0	0	0	0
    Provider Paid by SFA	0	750	750	750	750	750
    Payment due from Employer	0	0	0	0	0	0
    Levy account debited	0	750	750	750	750	750
    SFA Levy employer budget	750	750	750	750	750	0
    SFA Levy co-funding budget	0	0	0	0	0	0

  • When an ILR file is submitted for the first time on 10/01/18 with the following data:

    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
    learner a	04/08/2017	20/08/2018	12/11/2017	withdrawn	9000	04/08/2017	2250	04/08/2017

  • Then the provider earnings and payments break down as follows:

    Type	08/17	09/17	10/17	11/17	12/17	01/18	02/18
    Provider Earned Total	750	750	750	0	0	0	0
    Provider Earned from SFA	750	750	750	0	0	0	0
    Provider Earned from Employer	0	0	0	0	0	0	0
    Provider Paid by SFA	0	750	750	750	750	750	0
    Refund taken by SFA	0	0	0	0	0	0	-1500
    Payment due from Employer	0	0	0	0	0	0	0
    Levy account debited	0	750	750	750	750	750	0
    Levy account credited	0	0	0	0	0	0	1500
    SFA Levy employer budget	750	750	750	0	0	0	0
    SFA Levy co-funding budget	0	0	0	0	0	0	0

• 673-AC02 Non-DAS learner, levy available, provider retrospectively notifies a withdrawal and previously-paid monthly instalments need to be refunded.

  Tags: @Refunds

  • Given the apprenticeship funding band maximum is 17000
  • And the following earnings and payments have been made to the provider A for learner a:

    Type	08/17	09/17	10/17	11/17	12/17	01/18
    Provider Earned Total	750	750	750	750	750	0
    Provider Earned from SFA	675	675	675	675	675	0
    Provider Earned from Employer	75	75	75	75	75	0
    Provider Paid by SFA	0	675	675	675	675	675
    Payment due from Employer	0	75	75	75	75	75
    Levy account debited	0	0	0	0	0	0
    SFA Levy employer budget	0	0	0	0	0	0
    SFA Levy co-funding budget	0	0	0	0	0	0
    SFA non-Levy co-funding budget	675	675	675	675	675	0

  • When an ILR file is submitted for the first time on 10/01/18 with the following data:

    ULN	learner type	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
    learner a	programme only non-DAS	04/08/2017	20/08/2018	12/11/2017	withdrawn	9000	04/08/2017	2250	04/08/2017

  • Then the provider earnings and payments break down as follows:

    Type	08/17	09/17	10/17	11/17	12/17	01/18	02/18
    Provider Earned Total	750	750	750	0	0	0	0
    Provider Earned from SFA	675	675	675	0	0	0	0
    Provider Earned from Employer	75	75	75	0	0	0	0
    Provider Paid by SFA	0	675	675	675	675	675	0
    Refund taken by SFA	0	0	0	0	0	0	-1350
    Payment due from Employer	0	75	75	75	75	75	0
    Levy account debited	0	0	0	0	0	0	0
    Levy account credited	0	0	0	0	0	0	0
    SFA Levy employer budget	0	0	0	0	0	0	0
    SFA Levy co-funding budget	0	0	0	0	0	0	0
    SFA non-Levy co-funding budget	675	675	675	0	0	0	0

• 673-AC03 DAS learner, insufficient levy available to cover full payments, provider retrospectively notifies a withdrawal and previously-paid monthly instalments need to be refunded. Given The learner is programme only DAS

  Tags: @Refunds

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

    commitment Id	version Id	ULN	start date	end date	status	agreed price	effective from	effective to
    1	1	learner a	01/08/2017	01/08/2018	active	11250	01/08/2017

  • And the following earnings and payments have been made to the provider A for learner a:

    Type	08/17	09/17	10/17	11/17	12/17	01/18
    Provider Earned Total	750	750	750	750	750	0
    Provider Earned from SFA	725	725	725	725	725	0
    Provider Earned from Employer	25	25	25	25	25	0
    Provider Paid by SFA	0	725	725	725	725	725
    Payment due from Employer	0	25	25	25	25	25
    Levy account debited	0	500	500	500	500	500
    SFA Levy employer budget	500	500	500	500	500	0
    SFA Levy co-funding budget	225	225	225	225	225	0

  • When an ILR file is submitted for the first time on 10/01/18 with the following data:

    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
    learner a	04/08/2017	20/08/2018	12/11/2017	withdrawn	9000	04/08/2017	2250	04/08/2017

  • Then the provider earnings and payments break down as follows:

    Type	08/17	09/17	10/17	11/17	12/17	01/18	02/18
    Provider Earned Total	750	750	750	0	0	0	0
    Provider Earned from SFA	725	725	725	0	0	0	0
    Provider Earned from Employer	25	25	25	0	0	0	0
    Provider Paid by SFA	0	725	725	725	725	725	0
    Refund taken by SFA	0	0	0	0	0	0	-1450
    Payment due from Employer	0	25	25	25	25	25	0
    Levy account debited	0	500	500	500	500	500	0
    Levy account credited	0	0	0	0	0	0	1000
    SFA Levy employer budget	500	500	500	0	0	0	0
    SFA Levy co-funding budget	225	225	225	0	0	0	0

• 683-AC01- DAS learner, levy available, 2 providers - provider A and provider B, Provider B retrospectively notifies a withdrawal and previously-paid monthly instalments need to be refunded,

  Tags: @Refunds

  and this refund must be credited to Provider A where refunded Levy amount will be in excess of the available Levy for that period.

  • Given The learner is programme only DAS
  • And the apprenticeship funding band maximum is 17000
  • And the employer's levy balance is:

    01/18	02/18	03/18	04/18	05/18	06/18	07/18
    0	1125	1125	1125	1125	1125	1125

  • And the following commitments exist:

    commitment Id	Provider	version Id	ULN	start date	end date	status	standard code	agreed price	effective from	effective to
    1	Provider A	1	Learner A	01/08/2017	01/08/2018	active	25	5625	01/08/2017
    2	Provider B	1	Learner B	01/08/2017	01/08/2018	active	25	11250	01/08/2017

  • And the following earnings and payments have been made to the Provider A for Learner A:

    Type	08/17	09/17	10/17	11/17	12/17	01/18
    Provider Earned Total	375	375	375	375	375	0
    Provider Paid by SFA	375	375	375	375	375	0
    Provider Earned from Employer	0	0	0	0	0	0
    Provider Paid by SFA	0	375	375	375	375	375
    Payment due from Employer	0	0	0	0	0	0
    Levy account debited	0	375	375	375	375	0
    SFA Levy employer budget	375	375	375	375	375	0
    SFA Levy co-funding budget	0	0	0	0	0	0

  • And the following earnings and payments have been made to the Provider B for Learner B:

    Type	08/17	09/17	10/17	11/17	12/17	01/18
    Provider Earned Total	750	750	750	750	750	0
    Provider Earned from SFA	750	750	750	750	750	0
    Provider Earned from Employer	0	0	0	0	0	0
    Provider Paid by SFA	0	750	750	750	750	750
    Payment due from Employer	0	0	0	0	0	0
    Levy account debited	0	750	750	750	750	750
    SFA Levy employer budget	750	750	750	750	750	0
    SFA Levy co-funding budget	0	0	0	0	0	0

  • When an ILR file is submitted for the first time on 10/01/18 with the following data:

    ULN	Provider	start date	planned end date	actual end date	completion status	standard code	Total training price	Total training price effective date	Total assessment price	Total assessment price effective date
    Learner A	Provider A	04/08/2017	20/08/2018		Continuing	25	4500	04/08/2017	1125	04/08/2017
    Learner B	Provider B	04/08/2017	20/08/2018	12/11/2017	withdrawn	25	9000	04/08/2017	2250	04/08/2017

  • Then the earnings and payments break down for provider A is as follows:

    Type	08/17	09/17	10/17	11/17	12/17	01/18	02/18
    Provider Earned Total	375	375	375	375	375	375	375
    Provider Earned from SFA	375	375	375	375	375	375	375
    Provider Earned from Employer	0	0	0	0	0	0	0
    Provider Paid by SFA	0	375	375	375	375	375	375
    Refund taken by SFA	0	0	0	0	0	0	0
    Payment due from Employer	0	0	0	0	0	0	0
    Levy account debited	0	375	375	375	375	375	375
    Levy account credited	0	0	0	0	0	0	0
    SFA Levy employer budget	375	375	375	375	375	375	375
    SFA Levy co-funding budget	0	0	0	0	0	0	0

  • Then the earnings and payments break down for provider B is as follows:

    Type	08/17	09/17	10/17	11/17	12/17	01/18	02/18
    Provider Earned Total	750	750	750	0	0	0	0
    Provider Earned from SFA	750	750	750	0	0	0	0
    Provider Earned from Employer	0	0	0	0	0	0	0
    Provider Paid by SFA	0	750	750	750	750	750	0
    Refund taken by SFA	0	0	0	0	0	0	-1500
    Payment due from Employer	0	0	0	0	0	0	0
    Levy account debited	0	750	750	750	750	750	0
    Levy account credited	0	0	0	0	0	0	1500
    SFA Levy employer budget	750	750	750	0	0	0	0
    SFA Levy co-funding budget	0	0	0	0	0	0	0

  • And the net effect on employer's levy balance after each period end is:

    01/18	02/18	03/18	04/18	05/18	06/18	07/18
    -1125	750	750	750	750	750	750

Generated on: 30 April 2017 10:14:04

Produced by Pickles, version 2.8.2.0