Versions Compared

Key

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

This page outlines the work that has been carried out by the TIS Team with the Immigration and Recruitment teams to align the Permit to Work (Immigration statuses) values with Oriel. Following discussions, the exercises on TIS would be to first align the immigration statuses within TIS Reference and to then proceed with a migration of the existing people records with the hard-coded statuses to use the referenced values. From then onwards, only the Reference values with a status of CURRENT should be made available in:

...

No.

Currently on TIS Reference - PermitToWork

Actions for Devs

Matching ENUM for migration

Comments

1

British National Overseas

Make Inactive

N/A

2

Dependent - other immigration category

Make Inactive

N/A

3

Dependent - partner holds Tier 2 visa which you are a dependent on

Make Inactive

N/A

4

Dependent with endorsement - You are the partner/civil partner/spouse of a UK/EEA national and have an endorsement regarding 'no employment as a doctor or dentist in training'

Make Inactive

N/A

5

Dependent without endorsement - You are the partner/civil partner/spouse of a UK/EEA national and do not have an endorsement regarding 'employment as a doctor or dentist in training'

Make Inactive

N/A

6

Discretionary Leave to Remain

Make Inactive

N/A

7

Highly Skilled Migrant Programme (with start and end dates of endorsement stamp in passport)

Make Inactive

N/A

8

I am a fiancé of a UK national

Make Inactive

N/A

9

Indefinite Leave to Remain

Keep CURRENT
Migrate existing People records with 'Indefinite leave' to this Reference value.

INDEFINATE_LEAVE
INDEFINITE_LEAVE
INDEFINITE_LEAVE_TO_REMAIN

10

My immigration status is not listed as an option

Make Inactive

N/A

11

No current immigration status in the UK

Make Inactive

N/A

12

Other immigration categories i.e. overseas government employees, innovators etc.

Make Inactive

N/A

13

Refugee in the UK

Keep CURRENT
Migrate existing People records with:

  • 'Refugee Doctor'

  • 'Refugee in the UK'

to this Reference value.

REFUGEE_DOCTOR
REFUGEE_IN_THE_UK

14

Short-term study visa (not over 11 months)

Make Inactive

N/A

15

Tier 1

Keep CURRENT
Migrate existing People records with 'Tier 1' to this Reference value.

TIER_1

16

Tier 1 - points based system - no endoresment regarding 'employment as a doctor or dentist in training'

Make Inactive

N/A

17

Tier 1 - points based system - with endorsement 'no employment as a doctor or dentist in training'

Make Inactive

N/A

18

Tier 2

Keep CURRENT
Migrate existing People records with:

  • 'Tier 2'

  • 'Tier 2 PBS'

to this Reference value of 'Tier 2'.

TIER_2
TIER_2_POINTS_BASED_SYSTEM

19

Tier 2 - points based system

Make Inactive

N/A

20

Tier 3

Make Inactive

N/A

21

Tier 4 (Adult Student) graduate of UK medical school completed foundation

Make Inactive

N/A

22

Tier 4 (General)

Keep CURRENT, rename to 'Tier 4'
Migrate existing People records with:

  • Tier 4

  • Tier 4 (General)

  • Tier 4 General student

  • Student visa

to this Reference value of 'Tier 4'.

TIER_4
TIER_4_GENERALS_STUDENT
STUDENT_VISA
Not existing data found for ”Tier 4 (General)”.

23

Tier 4 (General) student

Make Inactive

N/A

24

Tier 4 - currently a student at a UK university/medical school

Make Inactive

N/A

25

Tier 4 - graduate of UK medical/dental school currently in Foundation Programme

Make Inactive

N/A

26

Tier 4 - studying for a Masters/PhD

Make Inactive

N/A

27

Tier 5

Keep CURRENT
Migrate existing people records with 'Tier 5' to this Reference value. 

TIER_5

Gemma: Tier 5 – MTI – please keep this category along with the Tier 5 as there are different types of Tier 5 categories and as I understand we would to distinguish between a Tier 5 MTI and other Tier 5s

28

Tier 5 - Medical Training Initiative

Keep CURRENT
Migrate existing people records with 'Tier 5 - Medical Training Initiative' to this Reference value. 

No existing data found.

29

Turkish Businessperson

Make Inactive
Migrate existing people records with 'Turkish Businessperson' to this Reference value. 

No existing data found.

Gemma: Turkish Business person – please do not add (this ok to remain on Oriel application form, but applicants would need to switch to a Tier 2/Skilled Worker before commencing training. This will be reviewed in Oriel next year in line with new immigration routes)

30

Turkish Worker

Make Inactive
Migrate existing people records with 'Turkish Worker' to this Reference value. 

No existing data found.

Gemma: Turkish worker - please do not add (this ok to remain on Oriel application form, but applicants would need to switch to a Tier 2/Skilled Worker before commencing training. This will be reviewed in Oriel next year in line with new immigration routes)

31

UK ancestry

Keep CURRENT, Migrate existing People records with 'Ancestry visa' to this Reference value.

ANCESTRY_VISA

32

Visitor visa / PLAB visa / Business Visitor visa

Make Inactive

N/A

33

Visitor visa/ PLAB visa/ Business Visitor visa

Make Inactive

N/A

34

You are the partner/civil partner/spouse of a UK/EEA national

Make Inactive

N/A

35

 

New - Add a new CURRENT value for 'UK/Irish National'
Migrate all people records with:

  • 'UK National'

  • 'No value provided' (Front End)

to this new Reference value.

UK_NATIONAL
Does “No value provided (Front End)” mean all NULL values?

Does not currently exist on TIS Reference

36

 

New - Add a new CURRENT value for 'Dependant/Spouse visa'
Migrate existing People records with:

  • 'Dependant of HSMP'

  • 'Dependant of work permit'

  • 'Spouse of HSMP holder'

to the new value of  'Dependant/Spouse visa' in Reference

DEPENDENT_OF_HMSP Valid typo Typo or different value?
DEPENDENT_OF_HSMP
DEPENDENT_OF_WORK_PERMIT
SPOUSE_OF_HSMP_HOLDER

Does not currently exist on TIS Reference

37

 

New - Add a new CURRENT value for  'EU EEA National (started prior to June 2021)' including the part in bracket.
Migrate existing People records with 'EC EEA National' to this new Reference value.

EC_EEA_NATIONAL

Does not currently exist on TIS Reference

38

 

New - Add a new CURRENT value for  'Spouse of EEA National (started prior to June 2021)' including the part in bracket.
Migrate existing People records with 'Spouse of EEA National' to this new Reference value.

SPOUSE_OF_EEA_NATIONAL

Does not currently exist on TIS Reference

39

 

New - Add a new CURRENT value for 'EU settlement scheme'

N/A

Does not currently exist on TIS Reference

40

 

New - Add a new CURRENT value for 'EU pre-settled status'

N/A

Does not currently exist on TIS Reference

41

 

New - Add a new CURRENT value for 'Student visa'

N/A

Does not currently exist on TIS Reference

42

 

New - Add a new CURRENT value for 'Skilled worker'

N/A

Does not currently exist on TIS Reference

43

 

Add a new CURRENT value for 'Post graduate visa'
Migrate all People records with 'Post graduate visa' to this new Reference value. 

POSTGRADUATE_VISA

Does not currently exist on TIS Reference

44

 

Add 'Limited LTR' value to Reference as INACTIVE.
Migrate all People records with 'Limited LTR' to this Reference value. 

LIMITED_LTR

Does not currently exist on TIS Reference

45

 

Add 'Other' value to Reference as INACTIVE.
Migrate all People records with 'Other' to this Reference value. 

OTHER

Does not currently exist on TIS Reference

46

 

Add 'Evidence of entitlement' value to Reference as INACTIVE.
Migrate all People records with 'Evidence of entitlement' to this Reference value. 

EVIDENCE_OF_ENTITLEMENT

Does not currently exist on TIS Reference

47

 

Add 'HSMP' value to Reference as INACTIVE.
Migrate all People records with 'HSMP' to this Reference value. 

HSMP

Does not currently exist on TIS Reference

48

 

Add 'Permit-free' value to Reference as INACTIVE.
Migrate all People records with 'Permit-free' to this Reference value. 

PERMIT_FREE

Does not currently exist on TIS Reference

49

 

Add 'Resident permit' value to Reference as INACTIVE.
Migrate all People records with 'Resident permit' to this Reference value. 

RESIDENT_PERMIT

Does not currently exist on TIS Reference

50

 

Add 'TWES MTI' value to Reference as INACTIVE (Tbc...).
Migrate all People records with 'TWES MTI' to this Reference value. 

TWES_MTI

Does not currently exist on TIS Reference

51

 

Add 'Unspecified' value to Reference as INACTIVE.
Migrate all People records with 'Unspecified' to this Reference value. 

UNSPECIFIED

Does not currently exist on TIS Reference.

TBC - Gemma/Tom De Salis/Alana Martinez/James/Ashley whether to make INACTIVE

52

 

Add 'Yes' value to Reference as INACTIVE.
Migrate all People records with 'Yes' to this Reference value. 

YES

Does not currently exist on TIS Reference

...