HCS/TIS - Field Validation

• Editable via Forename, Surname field changes

tblRegistration.RGFNAME

tblRegistration.RGSNAME

PersonID

Oriel Applicant ID - To be added - Future development work for TIS

Trainee ID

This ID is issued in Oriel application.

Person Application Code: RGSCID field in HCS.

They are given when they start programme.

Not system generated. From England.

it is the applicant (trainee) oriel number. 

This is different for other part of UK. 

• System generated field - Automated upon creation of record

• Read only

02/04

TIS to align with Oriel;

Title

TIS List:

Mx
Mr
Ms
Mrs
Dr
Miss
Professor

Dr

Master

Miss

Mr

Mrs

Ms

Mx

Prof

• drop down

02/04

TIS to align with Oriel;

Forename

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   )
• Multiple names allowable
• Upper and lower case allowed
• MANDATORY

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed

• Free text
• No special characters (excl spaces (   )) 
• Multiple initials allowable
• Upper case only

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed
• MANDATORY

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed

Should go with TIS field

HCS got Personal Phone or Work Phone

(Go with TIS Field )

• additional validation - limit to only numerical values / no spaces

Mobile number

Mobile number

HCS got Personal Phone or Work Phone

(Go with TIS Field )

• additional validation - limit to only numerical values / no spaces

Email address

TIS keeps the preferred contact email

Email pref

HCS sees it as a set back for them if they don't have the 3 email addresses 

Work Email or Academic or Email or Personal Email

HCS will use the preferred email  as the email address on TIS

May need to create the 3 emails fields (professional, Personal and academic)  and also preferred email field with the following drop down:

Professional

Personal

Academic

Professional

Personal

Academic

Above for preferred email drop down

• must be in email format

02/04:

HCS to look into email address and decide. Might have to go with single email.

06/04:

Preferred email is derived from a query. (AL)

Address line 1

• Free text
• no min/max length

Address line 2

• Free text
• no min/max length

Address line 3

• Free text
• no min/max length

Address line 4

• Free text
• no min/max length

Postcode

Postcode

HCS receive this information from Trainee when they are starting using the Request for Information form. 

• Free text
• no min/max length

TIS to add a field

HCPC Registration number

02/04:

• TIS to add the fields

• HCS - also have GDC number - TIS allows to add 2 numbers (HCPC and GDC). See rows 22- 25 for GDC fields

GMC 

• Free text
• MANDATORY (either this, PH or GDC must be entered)
• Must be at least 1 characterx if entered
• additional validation: no special characters apart from ( / ), ( ' ) and (   )

GMC status

• Drop down

• Free text - or calendar picker
• date format DD/MM/YYYY

GMC end date

• Free text - or calendar picker
• date format DD/MM/YYYY

GDC

• Free text
• MANDATORY (either this, PH or GMC must be entered)
• Must be at least 1 character if entered
• additional validation: no special characters apart from ( / ), ( ' ) and (   )

GDC status

• Free text

• Free text - or calendar picker
• date format DD/MM/YYYY

GDC end date

• Free text - or calendar picker
• date format DD/MM/YYYY

PH

Public health number

• Free text
• MANDATORY (either this, GMC or GDC must be entered)
• Must be at least 1 character if entered
• additional validation: no special characters apart from ( ' ) and    ( / )

Not display in TIS FE

College

• N/A

EEA Resident

TIS List:

YES

NO

UNKNOWN

• Drop down - TISDEV-4186

02/04

To use Oriel Reference table for these fields

Permit to work

TIS List:

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

• Tier 1 - points based system - with endorsement 'no employment as a doctor or dentist in training'
  
• Tier 2 - points based system
  Highly Skilled Migrant Programme (with start and end dates of endorsement stamp in passport)
  
• Tier 4 - graduate of UK medical/dental school currently in Foundation Programme
  
• Tier 4 - currently a student at a UK university/medical school
  
• Tier 4 - studying for a Masters/PhD
  
• Tier 5 - Medical Training Initiative
  
• UK ancestry
  
• Refugee in the UK
  
• Visitor visa/ PLAB visa/ Business Visitor visa
  
• Other immigration categories i.e. overseas government employees, innovators etc.
  
• Dependent - other immigration category
  
• Dependent - partner holds Tier 2 visa which you are a dependent on
  
• 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'
  
• 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'
  
• No current immigration status in the UK
  
• Tier 4 (Adult Student) graduate of UK medical school completed foundation
  
• Tier 4 (General) student
  British National Overseas
  Discretionary Leave to Remain
  
• I am a fiancé of a UK national
  
• Indefinite Leave to Remain
  
• My immigration status is not listed as an option
  Short-term study visa (not over 11 months)
  
• Tier 1
  
• Tier 2
  
• Tier 4 (General)
  
• Tier 5
  
• Turkish Businessperson
  
• Turkish Worker
  
• Visitor visa / PLAB visa / Business Visitor visa
  
• You are the partner/civil partner/spouse of a UK/EEA national
  Tier 3

• Drop down

02/04

To use Oriel Reference table for these fields

Settled

TIS List:

YES

NO

• Drop down

02/04

To use Oriel Reference table for these fields

31

• Free text - or calendar picker
• date format DD/MM/YYYY

32

Visa valid to

• Free text - or calendar picker
• date format DD/MM/YYYY

Visa details

• Free text

34

Not display in TIS FE

NI number

• Free text

35

Date of birth

• Free text - or calendar picker
• date format DD/MM/YYYY

• Derived from date of birth

Gender

TIS List:

Male
Female
I prefer not to specify
UNDISCLOSED

Male

Female

Other

Not Stated

Non-Binary

• Drop down

02/04

To use Oriel Reference table for these fields

• Drop down

• Drop down

Ethnic origin

TIS List:

Not stated
White - British
White - Irish
Any other white background
Mixed White and Black Caribbean
Mixed White and Black African
Mixed White and Asian
Asian or Asian British - Indian
Asian or Asian British - Pakistani
Asian or Asian British - Bangladeshi
Any other Asian background
Black or Black British - Caribbean
Black or Black British - African
Any other Black background
Chinese
Any other ethnic group
Any other mixed background

Ethnicity

White - British
White - Irish
White - Other
Mixed - White & Black Caribbean
Mixed - White & Black African
Mixed - White and Asian
Mixed - Other
Asian - Indian
Asian - Pakistani
Asian - Bangladeshi
Asian - Other
Black - Caribbean
Black - African
Black - Other
Chinese
Any Other
Not Stated

• Drop down

02/04

Aligning to Oriel Ref. Table

• Drop down

• Drop down

Religious belief

TIS List:

Atheism
Buddhism
Christianity
Hinduism
I do not wish to disclose my religious belief
Islam
Jainism
Judaism
Other
Protestant Community
Roman Catholic Community
Sikhism
Neither community

Religion

Atheism

• Drop down

02/04

To use Oriel Reference table for these fields

Disability

TIS List:

YES

NO

Disability 

Yes, limited a little
Yes, limited a lot
No
Unstated

• Drop down

02/04

To use Oriel Reference table for these fields

Disability details

comes from Oriel and free text

Should go with TIS field

Captured only when trainee is registering 

• Free text

Should go with TIS field

• Drop down

Comments

• Free text

Training Status

This can be captured on TIS placement.

Current/Inactive

Status

Some can be captured in Placement and Programme status? 

Active - FT
Active - PT
Maternity/Paternity
Sickness
Passed
Defer/Suspend
Resit
Left
Failed
Withdrawn
Deceased
Dismissed
Career Break

• Drop Down
• MANDATORY
• Default to current on create journey

NB: leave "Delete" as a status within the drop downs (as long as it is soft delete)

02/04:

TIS: Some to go into placement type, leaving reasons etc . TIS to decide where to place each.

AFC Band

Alex response: HCS Post-training Data

AFC Grade can be added to placement?

TIS  to decide under what heading this will go

HCS to confirm if it also comes from Oriel

02/04:

This is HCS outcome data. Post -Training - Destination data. Critical to HCS

TIS: To look at best way to do this e.g maybe leaving destination 

Alex response: HCS Post- training Data

TIS  to decide under what heading this will go e.g Personal details/sensitive data...

HCS to confirm if it also comes from Oriel

02/04

Critical to HCS

TIS: To look at best way to do this e.g maybe leaving destination 

Alex response: HCS Post- training Data

TIS  to decide under what heading this will go e.g Personal details/sensitive data...

HCS to confirm if it also comes from Oriel

02/04

HCS: Potentially out? HCS to confirm

If not, TIS: To look at best way to do this e.g maybe leaving destination 

Alex response: HCS Post -training Data

Permanent (Full Time)
Permanent (Part Time)
Fixed: 6 Months
Fixed: 1 Year
Fixed: 2 Years
Fixed: 3 Years
Fixed: 5 Years
Fixed: Other Term
Max Funding (Indicate)
Unknown

TIS WTE is represented with numbers e.g 0.3 - 3 months, 0.8 - 8 months, 1 - 1 year

HCS WTE ???? 

TIS  to decide under what heading this will go e.g Personal details/sensitive data/Placement/Programme membership 

HCS to confirm if it also comes from Oriel

02/04:

TIS: To look at best way to do this e.g maybe leaving destination 

Not display in TIS FE

Inactive from date

• Free text - or calendar picker
• date format DD/MM/YYYY

Inactivefromdate

Not display in TIS FE

Inactive notes

• Free text

Qualification

Should this be Qualification Subjects for HCS? 

Free text on TIS and there is reference table for HCS

Qualification type

TIS List:

Bachelors Degree
Bachelors Degree Hons
Basic Degree
Certification
College/Faculty
Diploma
Foundation Degree
Higher Degree
Masters Degree
Non Medical Degree
NVQ
PhD

Qualification type

BEng

• Drop down

Qualification Mark

1st
2:1
2:2
3rd
Complete
Unknown
Distinction

Qualification Subject

Quite a large list of subjects

See long list in HCS Reference table. About 523 subjects on the list

Align with Oriel

06/04

How is this diff than line 54?

Certification Type 

Attainment

Equivalence

02/04

No longer required

• Free text - or calendar picker
• date format DD/MM/YYYY

Not display in TIS FE

Month attained

• Free text - or taken from Date attained field
• date format DD/MM/YYYY

Not display in TIS FE

Year attained

Not Required

• Free text - or taken from Date attained field
• date format DD/MM/YYYY

University

• Drop down

To confirm from HCS what is this field called

02/04

University trainee got degree

Two different fields to be considered:

• University for first degree
• University where training is carried out

• Drop down

Qualification Verified By School?

Alex Response: TBC

Yes

No

02/04:

No longer required

Should go with TIS field

List of Programme types

• Drop down (smartsearch)
• MANDATORY

Might be required if specialism will be listed under a programme

02/04:

Programmes are:

STP
HSST
PTP
ASP

Apprenticeships????

Specialism 

TIS curriculum fields be use for HCS specialism? Let us test and see how it will look like? No, as curriculum will be required

Curriculum is also required as it will be linked to specialism both linked to a programme

02/04

add to curriculum specialty table

Program Type 

STP

HSST

PTP

ASP

Apprenticeships????

• NHS Scientist Training Programme (STP)
• NHS Higher Specialist Scientist Training (HSST)
• NHS Practitioner Training Programme (PTP)
• Apprenticeships
• Accredited Scientific Practice (ASP)
• Is this required by -  HCS as Programme membership filed is covered in Row 74?
• Should these Programme Type on HCS be covered in programme names on TIS ?

02/04:

• HCS - To have more programmes 

• TIS: To check if to add to programme Name
• Need to decide what goes into this field if required.

Alex Response: dependent on 67 being chosen as "ASP"

Upper GI Physiology (STP)

Lower GI Physiology

Upper & Lower GI Physiology

Lower GI Physiology (no rotation)

Upper GI Phyiology (UGI Only)

Do you have other types for other programmes that TIS need to capture?

02/04

• Modules associated with ASP
• Add to curriculum specialty on TIS

Direct Entry

In-Service

02/04

TIS: add to programme type. TIS to look at

• about funding 

Programme number.

TIS example: EOE922

HCS might need to come up with the unique code for their programmes 

Alex Response: What is a programme number? Same as Field 67?

Programmes are STP, ASP, PTP, PGDip, HSST

Ade: Is there any sub-programme associated to each programme?

N/A

• Auto populated when Programme Name is selected

What are the programmes and sub-programmes HCS has got so that TIS can help to come up with Programme Number for them?

02/04

• HCS is a national school - TIS might have to come up with unique id for each programme.

Owner

This is programme owner  on TIS 

• Auto populated when Programme Name is selected

For TIS - the HEE local offices owns the programmes

02/04

Pre-populated with NSHCS

 Should go with TIS field

• Free text - or calendar picker
• date format DD/MM/YYYY
• MANDATORY

 Should go with TIS field

• Auto populated when adding a trainee's curriculum (Programme end date is the programme start date plus the length of the curriculum followed plus any period of grace applicable)
• Editable
• MANDATORY

Programme membership type

Same as row 67?

TIS List:

• FTSTA
• LAT
• Military
• Substantive
• Visitor

Alex Response:  I don't think this is necessary

Ade: If not required, we might have to look at the impact on other fields from our end.

Pre- populated as 'Substantive'

• Drop down
• MANDATORY

Is this required for HCS? 

02/04 

Required for HCS

Not Required 

See: TIS UI Fields - Dropdowns &

Programmes - Rotations - Solution Design, Field Validation & Scenarios

Alex Response: We don't do rotations like medical

N/A

It is managed in the work place 

• Drop down

Leaving reason

Leaving Reason on TIS should do the job for HCS rather than destination.

Leaving Reason:

TIS List:

SUBSTANTIVE
Completed training
Removed from training programme
Inter deanery transfer
Left without CCT – employment not known

Leaving Destination or Leaving Reason?

This is after training finish programme.

Alex Response: It is joined up with 49-51

When trainee finishes programme

Healthcare: NHS

Healthcare: Non-NHS

Not Employed

HSST

Other/Non-Healthcare

• Drop down

Leave in-between programme - Falls under absence issue field in HCS system ( need a place to capture this also)?

Should leave in-between programme be added to the list  or a separate field be created?

** is leave between programme not already capture in 'Status' in row 77? **

02/04

TIS/HCS still need to look at how to manage this.

Active - FT
Active - PT
Maternity/Paternity
Sickness
Passed
Defer/Suspend
Resit
Left
Failed
Withdrawn
Deceased
Dismissed
Career Break

OLAT Status

Current

Passed

Incomplete (Extension)

Incomplete (Fail)

Leaver

Suspended

Is OLAT status required? Is part of completion requirement which needs to be reported

02/04

To continue from here next Thursday 

Training pathway

This must be related to the curriculum/Programme

TIS List:

CCT

CESR

N/A

HSST Pathway

LS1FRCPath

LS2FRCPath & PGDip

LS3FRCPath & DClinSci

PS1DClinSci

PS2DClinSci & CEng

PS3PGDip

PS4PGDip & CEng

Training number

Alex Response: Dependent on 67 being chosen as "HSST"

Ade: Don't think it is required since it might be covered in Programm number- 70

• Autogenerated
• Editable
• Readonly textbox (allowing special characters ( / ) in the autogeneration

HCS needs to keep curriculum 

Alex: There are codes in HCS of how they log their curriculum. Unique identifier. Alex to supply the code if there is need for it

• Drop down
• Taken from the Curriculum/Curricula attached to the Programme the trainee is following
• MANDATORY 

HSST Cohort

Alex Response: To determine timing of completion and assessments

• Cohort 1
• Cohort 2
• Cohort 3
• Cohort 4
• Cohort 5
• Cohort 6

Required for HCS

Alex Response: Not needed as start dates will always be programme start date. Not sure if these are needed as curriculum does not change during training

Ade: we'll look at the impact from our end

N/A

• Default to the Programme start date but allow for editing via a calendar picker or manual update

Required for HCS

Alex Response: Not sure if these are needed as curriculum does not change during training

Ade: we'll look at the impact from our end

N/A

• Auto populated after the Curriculum start date has been entered - will be Curriculum start date plus the duration of the curriculum
• Editable
• Date format DD/MM/YYYY

Not display in TIS FE

Curriculum sub-type

Not Required: 

Curriculum sub-type

Not display in TIS FE

Curriculum specialty

Not Required:

Can specialism comes here?

Alex Response: Not sure if these are needed as curriculum does not change during training

Ade: we'll look at the impact from our end

N/A

HCS need post number - they need to come up with algorithm. TIS to share their Algorithm

Alex Response: May take post number from ORIEL - not sure yet if this is necessary

TIS: NPN derived from the deanery, Site, Specialty and Grade tables e.g. NTH/RTD01/080/STR/005

N/A

• Drop down or smart search
• limit to Posts within the same Programme as Trainee

Previous Post

Healthcare: NHS
Healthcare: Non-NHS
Undergradute
PTP
STP
Other

If other - Another field create?

Alex Response: Not needed

Check list of specialism from HCS reference table

• Drop down

Alex Response: Not needed

N/A

• Drop down

Site

Hospital/Trainee Sites

This should be the Hospital Field in HCS?

.

• Drop down (taken from 'site' in the post record)
• editable

Trusts 

Aston University
King's College London
MAHSE Manchester Metropolitan University
MAHSE University of Manchester
MAHSE University of Salford
Manchester Metropolitan University
Newcastle University
Queen Marys University London
Swansea University
University of Birmingham
University of Liverpool
University of Manchester
University of Nottingham
University of Nottingham
Other

• Read only

Grade

Not Required??

We can add the band grade here 

Alex Resonse: All trainees are on the same band.
Ade: Can we pre-populate if we know the grade?

• Drop down (taken from 'other grades' in the post record)
• Autogenerated from Post record
• Editable from full grade list

LETB 

• read only
• derived from Post

Placement type

TIS list:

OOPC
OOPE
OOPR
OOPT
In Post
In Post - Acting up
In Post - Extension
Long-term sick
Parental Leave
Phased Return
Suspended
OOPP

Placement type

Alex Response: What is a placement type?

Ade: Shows the current situation of trainee; In post, In Post- Acting Up, In post - Extension, Long- term sick,OOPC, OOPE….

Check Status

• Drop down

• Free text - or calendar picker
• date format DD/MM/YYYY

• Free text - or calendar picker
• date format DD/MM/YYYY

Alex Response: Not Required

N/A

• Free text

Whole time equivalent

To be captured especially for HSST

• Numerical
• equal to, or less than 1

Status

TIS list:

CURRENT

PAST

FUTURE

Should go with TIS field

Alex Response: Same as Field 48?

Ade: This status is about Placement status; Past, Current and Future in TIS
Yes, 48 can be captured in Placement status.

• autodetermined based on dates
• read only

Covered under Placement supervisor in TIS

• drop down

Covered under Placement supervisor in TIS

• drop down

Approval

TIS List:

APPROVED

DRAFT

Placement approval

Trainee First Name

Trainee Surname

Type

TIS List:

ACADEMIC
ARCP
FRCP
FRCP_STAGE_2
IRCP
RITA

WTE months OOPR/T during period

(out of programme research or training)

PYA

(penultimate year assessment)

TIS list:

YES

NO

Pre-Assessment Detail

Pre-populated as Substansive

Outcome

TIS List:

Not ASSESSED

1
2
3
4
5
6
6R
7
8
9

Post- Assessment- Outcome

See different outcomes in Reference table for STP and HSST

Post- Assessment- Outcome

Pass

Merit

Distinction

Fail

Alex Response: We manage the training programme, of which MSc is part.

Post- Assessment- Outcome

Full

Mock

Resit

Alex Response: This is the trainees' final assessments. Absolutely must have.

Post- Assessment- Outcome

Pass

Fail

Alex Response: This is the trainees' final assessments. Absolutely must have.

Under Appeal

TIS List:

YES

NO

External trainer

TIS List:

YES

NO

Post-assessment - Details

N/A

Alex Response: What is this?

Ade: External trainer is a trainer who has not been supervising the trainee as part of their training.It is a YES or NO dropdown in TIS

Post-assessment - Details

Post-assessment - Academic Progression

Academic outcome

TIS list:

Continue on academic component

Do not Continue on academic component

Successfully  completed academic component

Post-assessment - Academic Progression