Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column Name

Required?

Format

Example

Notes

TRG_TNP

numeric

1000

ILR Apprenticeship Financial Record - Total Negotiate Price for Training (TNP1) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/AppFinRecord/field/AFinType/attribute/TNP

TRG_EMP

numeric

50

Employer’s Contribution to Training if not levy funded

TRG_EMP_START

numeric

40

Lump Sum of Employer’s Contribution to Training

TRG_EMP_SPRD

alphanumeric

Encoding of spreading method of Employer’s Contribution to Training

ASM_TNP

numeric

1000

ILR Apprenticeship Financial Record - Total Negotiate Price for Assessment (TNP2) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/AppFinRecord/field/AFinType/attribute/TNP

ASM_EMP

numeric

50

Employer’s Contribution to Assessment if not levy funded

ASM_EMP_START

numeric

40

Lump Sum of Employer’s Contribution to Assessment

ASM_EMP_SPRD

alphanumeric

Encoding of spreading method of Employer’s Contribution to Assessment

ADD_EMP

numeric

5000

Additional Employer Price

ADD_EMP_START

numeric

4000

Additional Employer Lump Sum

ADD_EMP_SPRD

alphanumeric

Additional Employer Encoding of spreading method

Functional Skills Initial Assessments

Note

From the PICS release for the 2023/24 ILR Year (due mid August 2023) imports of Functional Skills Initial Assessments will require either a Level or a Result to be processed. If a date is not specified the Episode Start date will be used.

Column Name

Required?

Format

Example

Notes

LIT_FIRSTASSDATE

date

31/08/2021

English/Literacy Initial Assessment Date

LIT_FIRSTASSLEV

alphanumeric

D

English/Literacy Initial Assessment Level

X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy

LIT_FIRSTASSRES

numeric

67

English/Literacy Initial Assessment Result

NUM_FIRSTASSDATE

date

31/08/2021

Maths/Numeracy Initial Assessment Date

NUM_FIRSTASSLEV

alphanumeric

D

Maths/Numeracy Initial Assessment Level

X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy

NUM_FIRSTASSRES

numeric

67

Maths/Numeracy Initial Assessment Result

ICT_FIRSTASSDATE

date

31/08/2021

ICT Initial Assessment Date

ICT_FIRSTASSLEV

alphanumeric

D

ICT Initial Assessment Level

X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy

ICT_FIRSTASSRES

numeric

67

ICT Initial Assessment Result

ESOL_FIRSTASSDATE

date

31/08/2021

English as a Second Language Initial Assessment Date

ESOL_FIRSTASSLEV

alphanumeric

D

English as a Second Language Initial Assessment Level

X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy

ESOL_FIRSTASSRES

numeric

67

English as a Second Language Initial Assessment Result

Prior Qualifications

...