«

• 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 a learner changes employers

• • Given the apprenticeship funding band maximum is 17000
• Earnings and payments for a DAS learner, levy available, and there is a change to the Negotiated Cost which happens at the end of the month

  • Given The learner is programme only DAS
  • Given the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	01/08/2017
    employer 2	DAS	01/11/2017

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	31/08/2018	15000	active	01/08/2017	31/10/2017
    employer 1	1	2	learner a	01/08/2017	31/08/2018	15000	cancelled	01/11/2017
    employer 2	2	1	learner a	01/11/2017	31/08/2018	5625	active	01/11/2017

  • When an ILR file is submitted on 03/12/2017 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	01/08/2017	04/08/2018		continuing	12000	01/08/2017	3000	01/08/2017	5000	01/11/2017	625	01/11/2017

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	commitment 2 v1	commitment 2 v1

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

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

• Earnings and payments for a DAS learner, levy available, and there is a change to the Negotiated Cost which happens mid month

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	04/08/2017
    employer 2	DAS	10/11/2017

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	31/08/2018	15000	active	01/08/2017	31/10/2017
    employer 1	1	2	learner a	01/08/2017	31/08/2018	15000	cancelled	01/11/2017
    employer 2	2	1	learner a	01/11/2017	31/08/2018	5625	active	01/11/2017

  • When an ILR file is submitted on 03/12/2017 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	04/08/2017	04/08/2018		continuing	12000	04/08/2017	3000	04/08/2017	5000	10/11/2017	625	10/11/2017

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	commitment 2 v1	commitment 2 v1

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

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

• Earnings and payments for a DAS learner, levy available, and there is a change to the Negotiated Cost earlier than expected

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	04/08/2017
    employer 2	DAS	10/11/2017

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	31/08/2018	15000	active	01/08/2017	31/10/2017
    employer 1	1	2	learner a	01/08/2017	31/08/2018	15000	cancelled	01/11/2017
    employer 2	2	1	learner a	01/11/2017	31/08/2018	5625	active	01/11/2017

  • When an ILR file is submitted on 03/12/2017 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	04/08/2017	04/08/2018		continuing	12000	04/08/2017	3000	04/08/2017	5000	25/10/2017	625	25/10/2017

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1

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

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

• Earnings and payments for a DAS learner, levy available, where a learner switches from DAS to Non Das employer at the end of month

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	03/08/2017
    employer 2	Non DAS	03/11/2017

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	03/08/2017	04/08/2018	15000	active	03/08/2017	02/11/2017
    employer 1	1	2	learner a	03/08/2017	04/08/2018	15000	cancelled	03/11/2017

  • When an ILR file is submitted on 03/12/2017 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	03/08/2017	04/08/2018		continuing	12000	03/08/2017	3000	03/08/2017	4500	03/11/2017	1125	03/11/2017

  • And the Contract type in the ILR is:

    contract type	date from	date to
    DAS	03/08/2017	02/11/2017
    Non-DAS	03/11/2017	04/08/2018

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1

  • And the provider earnings and payments break down as follows:#change of employer mid month

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

• Earnings and payments for a DAS learner, levy available, commitment entered for a new employer in the middle of the month, and there is a change to the employer and negotiated cost in the middle of a month in the ILR

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	01/08/2017
    employer 2	DAS	15/11/2017

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	28/08/2018	15000	active	01/08/2017	14/11/2017
    employer 1	1	2	learner a	01/08/2017	28/08/2018	15000	cancelled	15/11/2017
    employer 2	2	1	learner a	15/11/2017	28/08/2018	5625	active	15/11/2017

  • When an ILR file is submitted on 03/12/2017 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	01/08/2017	28/08/2018		continuing	12000	01/08/2017	3000	01/08/2017	5000	15/11/2017	625	15/11/2017

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	commitment 2 v1	commitment 2 v1

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

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

• Earnings and payments for a DAS learner, levy available, commitment entered for a new employer in the middle of the month with gap, and there is a change to the employer and negotiated cost in the middle of a month in the ILR

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	01/08/2017
    employer 2	DAS	15/11/2017

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	28/08/2018	15000	active	01/08/2017	14/11/2017
    employer 1	1	2	learner a	01/08/2017	28/08/2018	15000	cancelled	15/11/2017
    employer 2	2	1	learner a	15/11/2017	28/08/2018	5625	active	15/11/2017

  • When an ILR file is submitted on 03/12/2017 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	01/08/2017	28/08/2018		continuing	12000	01/08/2017	3000	01/08/2017	5000	25/11/2017	625	25/11/2017

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1	commitment 2 v1	commitment 2 v1

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

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

• Earnings and payments for a DAS learner, levy available, commitment entered for a new employer in the middle of the month and ILR file is submitted before new price episode, and there is a change to the employer and negotiated cost in the middle of a month in the ILR

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	01/08/2017
    employer 2	DAS	15/11/2017

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	28/08/2018	15000	active	01/08/2017	14/11/2017
    employer 1	1	2	learner a	01/08/2017	28/08/2018	15000	cancelled	15/11/2017
    employer 2	2	1	learner a	15/11/2017	28/08/2018	5625	active	15/11/2017

  • When an ILR file is submitted on 03/12/2017 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	01/08/2017	28/08/2018		continuing	12000	01/08/2017	3000	01/08/2017	5000	05/11/2017	625	05/11/2017

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1

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

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

• Apprentice changes from a non-DAS to DAS employer, levy is available for the DAS employer

  • Given The learner is programme only DAS
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	Non DAS	06/08/2017
    employer 2	DAS	01/04/2018

  • And the following commitments exist on 03/04/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 2	1	1	learner a	01/04/2018	01/08/2018	3500	active	01/04/2018

  • When an ILR file is submitted 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	06/08/2017	08/08/2018		continuing	5000	06/08/2017	1000	06/08/2017	2500	01/04/2018	1000	01/04/2018

  • And the Contract type in the ILR is:

    contract type	date from	date to
    Non-DAS	06/08/2017	31/03/2018
    DAS	01/04/2018	08/08/2018

  • Then the data lock status will be as follows:

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

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

    Type	08/17	09/17	10/17	...	03/18	04/18	05/18	06/18	07/18	08/18
    Provider Earned Total	400	400	400	...	400	700	700	700	700	0
    Provider Earned from SFA	360	360	360	...	360	700	700	700	700	0
    Provider Earned from Employer 1	40	40	40	...	40	0	0	0	0	0
    Provider Earned from Employer 2	0	0	0	...	0	0	0	0	0	0
    Provider Paid by SFA	0	360	360	...	360	360	700	700	700	700
    Payment due from employer 1	0	40	40	...	40	40	0	0	0	0
    Payment due from employer 2	0	0	0	...	0	0	0	0	0	0
    Employer 2 Levy account debited	0	0	0	...	0	0	700	700	700	700
    SFA Levy employer budget	0	0	0	...	0	700	700	700	700	0
    SFA Levy co-funding budget	0	0	0	...	0	0	0	0	0	0
    SFA non-Levy co-funding budget	360	360	360	...	360	0	0	0	0	0

• Earnings and payments for a DAS learner, levy available, where a total cost changes during the programme and ILR is submitted late

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	03/08/2017
    employer 2	DAS	03/11/2017

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	31/08/2018	15000	active	01/08/2017	31/10/2017
    employer 1	1	2	learner a	01/08/2017	31/08/2018	15000	cancelled	01/11/2017
    employer 2	2	1	learner a	01/11/2017	31/08/2018	5625	active	01/11/2017

  • When an ILR file is submitted for the first time on 28/11/17 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	03/08/2017	04/08/2018		continuing	12000	03/08/2017	3000	03/08/2017	5000	03/11/2017	625	03/11/2017

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

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

• Earnings and payments for a DAS learner, levy available, and they have a break in learning at the end of a month and return at the start of a later month with a different employer

  • Given the apprenticeship funding band maximum is 17000
  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	01/08/2017
    employer 2	DAS	01/01/2018

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	31/08/2018	15000	active	01/08/2017	31/10/2017
    employer 1	1	2	learner a	01/08/2017	31/08/2018	15000	cancelled	01/11/2017
    employer 2	2	1	learner a	01/01/2018	31/10/2018	5625	active	01/01/2018

  • When an ILR file is submitted 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	01/08/2017	04/08/2018	31/10/2017	withdrawn	12000	01/08/2017	3000	01/08/2017
    learner a	01/01/2018	04/10/2018		continuing					5000	01/01/2018	625	01/01/2018

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17	01/18	02/18	03/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1			commitment 2 v1	commitment 2 v1	commitment 2 v1

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

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

• Earnings and payments for a DAS learner, levy available, and they have a break in learning in the middle of a month and return in the middle of a later month with a different employer

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	01/08/2017
    employer 2	DAS	01/01/2018

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	31/08/2018	15000	active	01/08/2017	31/10/2017
    employer 1	1	2	learner a	01/08/2017	31/08/2018	15000	cancelled	01/11/2017
    employer 2	2	1	learner a	01/01/2018	31/10/2018	5625	active	01/01/2018

  • When an ILR file is submitted 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	03/08/2017	04/08/2018	18/11/2017	withdrawn	12000	03/08/2017	3000	03/08/2017
    learner a	11/01/2018	04/10/2018		continuing					5000	11/01/2018	625	11/01/2018

  • Then the data lock status of the ILR in 03/12/2017 is:

    Payment type	08/17	09/17	10/17	11/17	12/17	01/18	02/18	03/18
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 v1			commitment 2 v1	commitment 2 v1	commitment 2 v1

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

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

• Earnings and payments for a DAS learner, levy available, and they have a break in learning in the middle of a month and return in the middle of a later month with a different employer - before the second commitment is in place

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	01/08/2017
    employer 2	DAS	01/01/2018

  • And the following commitments exist on 03/12/2017:

    Employer	commitment Id	version Id	ULN	start date	end date	agreed price	status	effective from	effective to
    employer 1	1	1	learner a	01/08/2017	31/08/2018	15000	active	01/08/2017	31/10/2017
    employer 1	1	2	learner a	01/08/2017	31/08/2018	15000	cancelled	01/11/2017
    employer 2	2	1	learner a	01/01/2018	31/10/2018	5625	active	01/01/2018

  • When an ILR file is submitted 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	Residual training price	Residual training price effective date	Residual assessment price	Residual assessment price effective date
    learner a	03/08/2017	04/08/2018	18/11/2017	withdrawn	12000	03/08/2017	3000	03/08/2017
    learner a	21/12/2017	04/09/2018		continuing					5000	21/12/2017	625	21/12/2017

  • Then the data lock status of the ILR in 03/12/2017 is:

    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

  • And the provider earnings and payments break down as follows:#Learner changes employer - incentives earned

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

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

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	06/08/2017
    employer 2	DAS	15/11/2017

  • And the following commitments exist:

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

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

    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		continuing	6000	06/08/2017	1500	06/08/2017	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	01/18
    Provider Earned Total	500	500	500	1500	500	500
    Provider Earned from SFA	500	500	500	1500	500	500
    Provider Earned from Employer 1	0	0	0	0	0	0
    Provider Earned from Employer 2	0	0	0	0	0	0
    Provider Paid by SFA	0	500	500	500	1500	500
    Payment due from employer 1	0	0	0	0	0	0
    Payment due from employer 2	0	0	0	0	0	0
    Employer 1 Levy account debited	0	500	500	500	0	0
    Employer 2 Levy account debited	0	0	0	0	500	500
    SFA Levy employer budget	500	500	500	500	500	500
    SFA Levy co-funding budget	0	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0	0	0
    SFA Levy additional payments budget	0	0	0	1000	0	0

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

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

• 1 learner aged 16-18, levy available, changes employer, earns incentive payment in the commitment transfer month - and the employer transfer is recorded on the ILR in a later month

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	06/08/2017
    employer 2	DAS	15/12/2017

  • And the following commitments exist:

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

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

    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		continuing	6000	06/08/2017	1500	06/08/2017	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
    On-program	commitment 1 v1	commitment 1 v1	commitment 1 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	01/18
    Provider Earned Total	500	500	500	1500	562.50	562.50
    Provider Earned from SFA	500	500	500	1000	562.50	562.50
    Provider Earned from Employer 1	0	0	0	0	0	0
    Provider Earned from Employer 2	0	0	0	0	0	0
    Provider Paid by SFA	0	500	500	500	1000	562.50
    Payment due from employer 1	0	0	0	0	0	0
    Payment due from employer 2	0	0	0	0	0	0
    Employer 1 Levy account debited	0	500	500	500	0	0
    Employer 2 Levy account debited	0	0	0	0	0	562.50
    SFA Levy employer budget	500	500	500	0	562.50	562.50
    SFA Levy co-funding budget	0	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	0	0	0	0
    SFA Levy additional payments budget	0	0	0	1000	0	0

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

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

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

  • Given The learner is programme only DAS
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	06/08/2017
    employer 2	DAS	09/11/2017

  • And the following commitments exist:

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

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

    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		continuing	6000	06/08/2017	1500	06/08/2017	4000	09/11/2017	1625	09/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
    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	01/18
    Provider Earned Total	500	500	500	1500	500	500
    Provider Earned from SFA	500	500	500	1000	0	0
    Provider Earned from Employer 1	0	0	0	0	0	0
    Provider Earned from Employer 2	0	0	0	0	0	0
    Provider Paid by SFA	0	500	500	500	1000	0
    Payment due from employer 1	0	0	0	0	0	0
    Payment due from employer 2	0	0	0	0	0	0
    Employer 1 Levy account debited	0	500	500	500	0	0
    Employer 2 Levy account debited	0	0	0	0	0	0
    SFA Levy employer budget	500	500	500	0	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
    SFA Levy additional payments budget	0	0	0	1000	0	0

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

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

• AC1- Provider earnings and payments where learner changes employer and there is a gap between commitments - provider receives payment during the gap as they amend the ACT code and employment status code correctly.

  Tags: @LearnerChangesEmployerGapInCommitments

  • Given The learner is programme only DAS
  • And the apprenticeship funding band maximum is 17000
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	03/08/2017
    No employer	Non-DAS	03/10/2017
    employer 2	DAS	03/11/2017

  • And the following commitments exist:

    commitment Id	version Id	Employer	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	Active	01/08/2017	02/10/2017
    1	2	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	cancelled	03/10/2017
    2	1	employer 2	provider a	learner a	01/11/2017	04/08/2018	5625	Active	01/11/2017

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

    ULN	Provider	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
    learner a	provider a	03/08/2017	04/08/2018		continuing	12000	03/08/2017	3000	03/08/2017	4500	03/11/2017	1125	03/11/2017

  • And the Contract type in the ILR is:

    contract type	date from	date to
    DAS	03/08/2017	02/10/2017
    Non-DAS	03/10/2017	02/11/2017
    DAS	03/11/2017	04/08/2018

  • And the employment status in the ILR is:

    Employer	Employment Status	Employment Status Applies
    employer 1	in paid employment	02/08/2017
    	not in paid employment	03/10/2017
    employer 2	in paid employment	03/11/2017

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1		commitment 2 v1	commitment 2 v1

  • And the provider earnings and payments break down as follows:#AC2

    Type	08/17	09/17	10/17	11/17	12/17
    Provider Earned Total	1000	1000	1000	500	500
    Provider Paid by SFA	0	1000	1000	1000	500
    employer 1 Levy account debited	0	1000	1000	0	0
    employer 2 Levy account debited	0	0	0	0	500
    SFA Levy employer budget	1000	1000	0	500	500
    SFA Levy co-funding budget	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	1000	0	0

• AC2- Provider earnings and payments where learner changes employer and there is a gap between commitments - provider receives no payment during the gap as they do not change the ACT code or employment status on the ILR

  Tags: @LearnerChangesEmployerGapInCommitments

  • Given The learner is programme only DAS
  • And the apprenticeship funding band maximum is 17000
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	03/08/2017
    No employer	Non-DAS	03/10/2017
    employer 2	DAS	03/11/2017

  • And the following commitments exist:

    commitment Id	version Id	Employer	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	Active	01/08/2017	02/10/2017
    1	2	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	cancelled	03/10/2017
    2	1	employer 2	provider a	learner a	01/11/2017	04/08/2018	5625	Active	01/11/2017

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

    ULN	Provider	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
    learner a	provider a	03/08/2017	04/08/2018		continuing	12000	03/08/2017	3000	03/08/2017	4500	03/11/2017	1125	03/11/2017

  • And the Contract type in the ILR is:

    contract type	date from	date to
    DAS	03/08/2017	04/08/2018

  • And the employment status in the ILR is:

    Employer	Employment Status	Employment Status Applies
    employer 1	in paid employment	02/08/2017

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1		commitment 2 v1	commitment 2 v1

  • And the provider earnings and payments break down as follows:#AC3

    Type	08/17	09/17	10/17	11/17	12/17
    Provider Earned Total	1000	1000	1000	500	500
    Provider Paid by SFA	0	1000	1000	0	500
    Employer 1 Levy account debited	0	1000	1000	0	0
    Employer 2 Levy account debited	0	0	0	0	500
    SFA Levy employer budget	1000	1000	0	500	500
    SFA Levy co-funding budget	0	0	0	0	0

• AC3- Provider earnings and payments where learner changes employer and there is a gap between commitments - provider does not receive payment during the gap as they amend the ACT code but do not amend the employment status code correctly.

  Tags: @LearnerChangesEmployerGapInCommitments

  • Given The learner is programme only DAS
  • And the apprenticeship funding band maximum is 17000
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	03/08/2017
    No employer	Non-DAS	03/10/2017
    employer 2	DAS	03/11/2017

  • And the following commitments exist:

    commitment Id	version Id	Employer	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	Active	01/08/2017	02/10/2017
    1	2	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	cancelled	03/10/2017
    2	1	employer 2	provider a	learner a	01/11/2017	04/08/2018	5625	Active	01/11/2017

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

    ULN	Provider	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
    learner a	provider a	03/08/2017	04/08/2018		continuing	12000	03/08/2017	3000	03/08/2017	4500	03/11/2017	1125	03/11/2017

  • And the Contract type in the ILR is:

    contract type	date from	date to
    DAS	03/08/2017	02/10/2017
    Non-DAS	03/10/2017	02/11/2017
    DAS	03/11/2017	04/08/2018

  • And the employment status in the ILR is:

    Employer	Employment Status	Employment Status Applies
    employer 1	in paid employment	02/08/2017

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1		commitment 2 v1	commitment 2 v1

  • And the provider earnings and payments break down as follows:#AC4

    Type	08/17	09/17	10/17	11/17	12/17
    Provider Earned Total	1000	1000	1000	500	500
    Provider Paid by SFA	0	1000	1000	900	500
    Employer 1 Levy account debited	0	1000	1000	0	0
    Employer 2 Levy account debited	0	0	0	0	500
    SFA Levy employer budget	1000	1000	0	500	500
    SFA Levy co-funding budget	0	0	0	0	0

• AC4-Provider earnings and payments where learner changes employer and there is a gap between commitments - provider does not receive payment during the gap as they amend the employment status code correctly but do not amend the ACT code.

  Tags: @LearnerChangesEmployerGapInCommitments

  • Given The learner is programme only DAS
  • And the apprenticeship funding band maximum is 17000
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	03/08/2017
    No employer	Non-DAS	03/10/2017
    employer 2	DAS	03/11/2017

  • And the following commitments exist:

    commitment Id	version Id	Employer	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	Active	01/08/2017	02/10/2017
    1	2	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	cancelled	03/10/2017
    2	1	employer 2	provider a	learner a	01/11/2017	04/08/2018	5625	Active	01/11/2017

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

    ULN	Provider	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
    learner a	provider a	03/08/2017	04/08/2018		continuing	12000	03/08/2017	3000	03/08/2017	4500	03/11/2017	1125	03/11/2017

  • And the Contract type in the ILR is:

    contract type	date from	date to
    DAS	03/08/2017	04/08/2018

  • And the employment status in the ILR is:

    Employer	Employment Status	Employment Status Applies
    employer 1	in paid employment	02/08/2017
    	not in paid employment	03/10/2017
    employer 2	in paid employment	03/11/2017

  • Then the data lock status will be as follows:

    Payment type	08/17	09/17	10/17	11/17	12/17
    On-program	commitment 1 v1	commitment 1 v1		commitment 2 v1	commitment 2 v1

  • And the provider earnings and payments break down as follows:#AC5

    Type	08/17	09/17	10/17	11/17	12/17
    Provider Earned Total	1000	1000	1000	500	500
    Provider Paid by SFA	0	1000	1000	0	500
    Employer 1 Levy account debited	0	1000	1000	0	0
    Employer 2 Levy account debited	0	0	0	0	500
    SFA Levy employer budget	1000	1000	0	500	500
    SFA Levy co-funding budget	0	0	0	0	0

• AC5-Provider earnings and payments where learner changes employer and there is a gap of more than 12 weeks between commitments - provider does not receive more than 12 weeks of payments during the gap.

  Tags: @LearnerChangesEmployerGapInCommitments

  • Given The learner is programme only DAS
  • And the apprenticeship funding band maximum is 17000
  • And the employer 1 has a levy balance > agreed price for all months
  • And the employer 2 has a levy balance > agreed price for all months
  • And the learner changes employers

    Employer	Type	ILR employment start date
    employer 1	DAS	03/08/2017
    No employer	Non-DAS	09/10/2017
    employer 2	DAS	03/03/2018

  • And the following commitments exist:

    commitment Id	version Id	Employer	Provider	ULN	start date	end date	agreed price	status	effective from	effective to
    1	1	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	Active	01/08/2017	08/10/2017
    1	2	employer 1	provider a	learner a	01/08/2017	04/08/2018	15000	cancelled	09/10/2017
    2	1	employer 2	provider a	learner a	01/11/2017	04/08/2018	5625	Active	01/03/2018

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

    ULN	Provider	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
    learner a	provider a	03/08/2017	04/08/2018		continuing	12000	03/08/2017	3000	03/08/2017	4500	03/03/2018	1125	03/03/2018

  • And the Contract type in the ILR is:

    contract type	date from	date to
    DAS	03/08/2017	08/10/2017
    Non-DAS	09/10/2017	02/03/2018
    DAS	03/03/2018	04/08/2018

  • And the employment status in the ILR is:

    Employer	Employment Status	Employment Status Applies
    employer 1	in paid employment	02/08/2017
    	not in paid employment	09/10/2017
    employer 2	in paid employment	02/03/2018

  • 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	03/18	04/18
    On-program	commitment 1 v1	commitment 1 v1						commitment 2 v1	commitment 2 v1

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

    Type	08/17	09/17	10/17	11/17	12/17	01/18	02/18	03/18	04/18
    Provider Earned Total	1000	1000	1000	1000	1000	0	0	0	0
    Provider Paid by SFA	0	1000	1000	1000	1000	1000	0	0	0
    Employer 1 Levy account debited	0	1000	1000	0	0	0	0	0	0
    Employer 2 Levy account debited	0	0	0	0	0	0	0	0	0
    SFA Levy employer budget	1000	1000	0	0	0	0	0	0	0
    SFA Levy co-funding budget	0	0	0	0	0	0	0	0	0
    SFA non-Levy co-funding budget	0	0	1000	1000	1000	0	0	0	0

Generated on: 30 April 2017 10:14:04

Produced by Pickles, version 2.8.2.0