Learner Import Specification in PICSWeb

User redirected to the New Learner window

File added to the Import List with a status of Pending

FIRSTNAME

string

Roberta

String

100

PREFFIRSTNAME

string

Ro

Preferred First Name

String

30

SURNAME

string

Smith

String

100

PREV_SURNAME

string

Jones

String

30

SEX

string

1: Male
2: Female
M: Male
F: Female

String

1

ETHNICORIGIN

numeric

33

ILR Ethnicity
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/Ethnicity

String

2

TITLE

numeric

4

1: Mr

2: Mrs

3: Miss

4: Ms

5: Dr

6: Rev

7: Hon

8: Mx

9: Other

String

1

BIRTHDATE

date

13/03/2003

DateTime

NINUMBER

string

JB010101A

String

9

PHOTOFILEID

File GUID

Must be an existing PICS File GUID

String

32

MIAP_ULN

numeric

100000009

LRS Unique Learner Number (ULN)

String

10

MIAP_FPN_SEEN

numeric

LRS Ability to Share / Privacy Notice seen

0 - No seen
1 - Seen

String

1

MIAP_PREFNAME

string

LRS Preferred Name

String

35

MIAP_VERIFTYPE

numeric

LRS Identity Verification Type
0 - None Provided
1 - Relationship with school
2 - Passport
3 - Driving licence
4 - ID Card
5 - National Insurance card
6 - Certificate of Entitlement to Funding
7 - Bank credit/debit card
999 - Other (please specify in MIAP_VERIFTEXT)

String

3

MIAP_VERIFTEXT

string

LRS Identity Verification Type Other details

String

255

PROV_ID

string

Provider Assigned Internal Identifier

String

20

LSC_ULIN

string

COB1234455

ILR Learner Reference Number

String

12

TAG_IDS

string

a1a1a1a1a1a1a1a1a1a1a1a1a1a1a1a1*b2b2b2b2b2b2b2b2b2b2b2b2b2b2b2b2*

INTERNAL USE ONLY
pcTagList RecGUID values * separated.

A list of guids separated by an *. Each guid must be 32 chars long

String

∞

TAG_NAMES

string

April 2022*Engineers*

A list of tags to create separated by an *.

String

∞

ADDR1

string

Flat A

First line of Home Address

String

50

ADDR2

string

123 Acacia Avenue

Second line of Home Address

String

50

ADDR3

string

Suburb

Third line of Home Address

String

50

ADDR4

string

Townville

Fourth line of Home Address

String

50

POSTCODE

string

TO1 1WN

Home Postcode

String

8

L17POSTCODE

string

TO1 1WN

Home Postcode prior to enrolment

String

8

PHONE

numeric

01603492620

Home Phone number

String

18

MOBILEPHONE

numeric

07799000001

Mobile Phone number

String

18

EMAIL

string

bob@here.com

String

100

NOKNAME

string

A Smith

Next of Kin Name

String

30

NOKREL

string

Parent

Next of Kin Relationship

String

30

NOKPHONE

string

01603492620

First Next of Kin Phone Number

String

15

NOKPHONE2

string

07799000002

Second Next of Kin Phone Number

String

15

NOKEMAIL

string

asmith@home.com

Next of Kin Email Address

String

100

CONT_METH

string

PETS

Allowed Contact Methods between Provider & Learner
Any combination of the following codes:
E: Email
P: Post

T: Telephone
S: SMS

String

5

PREF_CONTACT_METH

string

E

Preferred Contact Method between Provider & Learner
One of the codes in Allowed Contact Methods

String

1

SITE

string

PICS Internal Site code

String

10

CLIENT_ID

string

Learner Internal Client structure Identifier. Used when importing new Episodes for an existing Learner

String

5

ULIN_ID

string

Learner Internal Learner Reference Number structure Identifier. Used when importing new Episodes for an existing Learner Reference

String

5

PICS_APIDENT

string

Source Applicant Identifier for linking between an existing Applicant and a Learner

String

5

RISKLEVEL

string

Learner Risk Level

1: High

2: Medium

3: Low

String

1

QUALPLAN

string