HCS/TIS - Field Validation

Field Sequence

TIS FE Field name 

HCS FE Field Name

TIS Reference table

HCS

Reference table

TIS - Mandatory

(Y/N)

TIS Current FE Validation & Rules

Reporting- NDW/Tableau

(Y/N)

TIS BE Table:Field name

HCS BE Table:Field name

NDW BE Table:Field name

Comments

1

Full Name

Should go with TIS field

N/A

N/A

Y

• Editable via Forename, Surname field changes

tblRegistration.RGFNAME

tblRegistration.RGSNAME

2

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. 

NA

N/A

Y

• System generated field - Automated upon creation of record

• Read only

N at the moment 

Person: ID

tblRegistration.RGSCID

Vwperson:Persontisid

02/04

TIS to align with Oriel;

PERSONAL DETAILS: Personal

3

Title

TIS List:

Mx
Mr
Ms
Mrs
Dr
Miss
Professor

Title

See: TIS UI Fields - Dropdowns

Dr

Master

Miss

Mr

Mrs

Ms

Mx

Prof

N

• drop down

Contactdetails:Title

tblRegistration.RGTITLE

Vwperson:Title

02/04

TIS to align with Oriel;

4

Forename

Forenames

N/A

N/A

Y

• Free text

• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   )

• Multiple names allowable

• Upper and lower case allowed

• MANDATORY

Contactdetails:Forenames

tblRegistration.RGFNAME

Vwperson:Forenames

5

Legal forenames

Not Required

N/A

N/A

N

• Free text

• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))

• Multiple names allowable

• Upper and lower case allowed

Contactdetails:Legalforenames

Vwperson:Legalforenames

6

Initials

Not required

N/A

N/A

Y

• Free text

• No special characters (excl spaces (   )) 

• Multiple initials allowable

• Upper case only

Contactdetails:Initials

Vwperson:Initials

7

Surname

Surname

N/A

N/A

Y

• Free text

• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))

• Multiple names allowable

• Upper and lower case allowed

• MANDATORY

Contactdetails:Surname

tblRegistration.RGSNAME

Vwperson:Surname

8

Legal surname

Not Required

N/A

N/A

N

• Free text

• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))

• Multiple names allowable

• Upper and lower case allowed

Contactdetails:Legalsurname

Vwperson:Legalsurname

9

Known as

Not required

N/A

N/A

N

• Free text

• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))

• Multiple names allowable

• Upper and lower case allowed

Contactdetails:Knownas

Vwperson:Knownas

10

Maiden name

Not required

N/A

N/A

N

• Free text

• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))

• Multiple names allowable

• Upper and lower case allowed

Contactdetails:Maidenname

Vwperson:Maidenname

PERSONAL DETAILS: Contact

11

Telephone number

Should go with TIS field

HCS got Personal Phone or Work Phone

(Go with TIS Field )

N/A

N/A

N

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

Contactdetails:Telephonenumber

tblRegistration.RGPSPHN

tblRegistration.RGWKPHN

Vwperson:Telephonenumber

12

Mobile number

Mobile number

HCS got Personal Phone or Work Phone

(Go with TIS Field )

N/A

N/A

N

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

Contactdetails:Mobilenumber

Vwperson:Mobilenumber

13

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

N/A

Professional

Personal

Academic

Above for preferred email drop down

N

• must be in email format

Contactdetails:Email

tblRegistration.RGWKEML

tblRegistration.RGPSEML

tblRegistration.ACEML

Vwperson:Emailaddress

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)

13

Address line 1

Address 1

N/A

N/A

N

• Free text

• no min/max length

Contactdetails:Address1

tblRegistration.RGADD1

Vwperson:Addressline1

14

Address line 2

Address 2

N/A

N/A

N

• Free text

• no min/max length

Contactdetails:Address2

tblRegistration.RGADD2

Vwperson:Addressline2

15

Address line 3

Address 3

N/A

N/A

N

• Free text

• no min/max length

Contactdetails:Address3

tblRegistration.RGADD3

Vwperson:Addressline3

16

Address line 4

Not required

N/A

N/A

N

• Free text

• no min/max length

Contactdetails:Address4

Vwperson:Addressline4

17

Postcode

Postcode

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

N/A

N/A

N

• Free text

• no min/max length

Contactdetails:Postcode

tblRegistration.RGPCODE

Vwperson:Addresspostcode

PERSONAL DETAILS: GMC/GDC Details

TIS to add a field

HCPC Registration number

It is only for HSST programme 

tblRegistration.RGHCPC

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

TIS to add a field

HCPC Status

Is there any start and end date?

TIS to add a field

HCPC start date

Is there any start and end date?

TIS to add a field

HCPC end date

Is there any start and end date?

18

GMC 

Not Required

N/A

N/A

Y

• 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 (   )

Gmcdetails:Gmcnumber

Vwperson:Gmcnumber

19

GMC status

Not Required

See: TIS UI Fields - Dropdowns

N/A

N

• Drop down

Gmcdetails:Gmcstatus

Vwperson:Gmcstatus

20

GMC start date

Not Required

N/A

N/A

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Gmcdetails:Gmcstartdate

Vwperson:Gmcstartdate

21

GMC end date

Not Required

N/A

N/A

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Gmcdetails:Gmcenddate

Vwperson:Gmcexpirydate

22

GDC

Should go with TIS field

N/A

N/A

Y

• 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 (   )

Gdcdetails:Gdcnumber

Vwperson:Gdcnumber

23

GDC status

Should go with TIS field

See: TIS UI Fields - Dropdowns

N/A

N

• Free text

Gdcdetails:Gdcstatus

Vwperson:Gdcstatus

24

GDC start date

Should go with TIS field

N/A

N/A

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Gdcdetails:Gdcstartdate

Vwperson:Gdcstartdate

25

GDC end date

Should go with TIS field

N/A

N/A

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Gdcdetails:Gdcenddate

Vwperson:Gdcexpirydate

26

PH

Public health number

Not Required

N/A

N/A

• 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    ( / )

Person:Publichealthnumber

Vwperson:Publichealthnumber

27

Not display in TIS FE

College

Not Required

In TIS ref.table

N/A

N

• N/A

SENSITIVE DATA: Right to work - TIS/HCS (pulls from Oriel) To use Oriel Reference table for these fields

28

EEA Resident

TIS List:

YES

NO

UNKNOWN

Should go with TIS field

See: TIS UI Fields - Dropdowns

Need to see how it's display in HCS front end

N

• Drop down - TISDEV-4186

Righttowork:Eearesident

Vwperson:Eearesident

02/04

To use Oriel Reference table for these fields

29

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

Should go with TIS field

See: TIS UI Fields - Dropdowns

Need to see how it's display in HCS front end

N

• Drop down

Righttowork:Permittowork

Vwperson:Permittowork

02/04

To use Oriel Reference table for these fields

30

Settled

TIS List:

YES

NO

Should go with TIS field

See: TIS UI Fields - Dropdowns

Need to see how it's display in HCS front end

N

• Drop down

Righttowork:Settled

Vwperson:Settled

02/04

To use Oriel Reference table for these fields

31

Visa issued

Should go with TIS field

N/A

Need to see how it's display in HCS front end

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Righttowork:Visaissued

Vwperson:Visaissued

32

Visa valid to

Should go with TIS field

N/A

Need to see how it's display in HCS front end

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Righttowork:Visavalidto

Vwperson:Visavalidto

33

Visa details

Should go with TIS field

N/A

Need to see how it's display in HCS front end

N

• Free text

Righttowork:Visadetails

Vwperson:Visadetails

34

Not display in TIS FE

NI number

Not Required

N/A

Need to see how it's display in HCS front end

N

• Free text

Personaldetails:Nationalinsurancenumber

?

SENSITIVE DATA: Diversity - TIS pull from Oriel (to workout for non-English trainees)

35

Date of birth

Date of Birth

N/A

N/A

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Personaldetails:Dateofbirth

tblRegistration.RGDOB

Vwperson:Dateofbirth

36

Age

Not required

N/A

N/A

N

• Derived from date of birth

Not captured in BE?

37

Gender

TIS List:

Male
Female
I prefer not to specify
UNDISCLOSED

Gender

See: TIS UI Fields - Dropdowns

Male

Female

Other

Not Stated

Non-Binary

N

• Drop down

Personaldetails:Gender

tblRegistration.RGGEN

Vwperson:Gender

02/04

To use Oriel Reference table for these fields

38

Nationality

Countries

See: TIS UI Fields - Dropdowns

See list of Countries in the HCS reference table spreadsheet

N

• Drop down

 Personaldetails:Nationality

tblRegistration.RGNAT

Vwperson:Nationality

39

Dual nationality

Not Required

See: TIS UI Fields - Dropdowns

N/A

N

• Drop down

Personaldetails:Dualnationality

Vwperson:Nationalitydual

40

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

See: TIS UI Fields - Dropdowns

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

N

• Drop down

Personaldetails:Ethnicorigin

tblRegistration.RGETH

Vwperson:Ethnicorigin

02/04

Aligning to Oriel Ref. Table

41

Marital status

Not Required

See: TIS UI Fields - Dropdowns

N/A

N

• Drop down

Personaldetails:Maritalstatus

Vwperson:Maritalstatus

42

Sexual orientation

Not Required

See: TIS UI Fields - Dropdowns

N/A

N

• Drop down

Personaldetails:Sexualorientation

Vwperson:Sexualorientation

43

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

See: TIS UI Fields - Dropdowns

Atheism

Baha'i
Buddhism
Candomblé
Hinduism
Islam
Jainism
Jehovah's Witness
Judaism
Mormonism
Paganism
Rastafari
Santeria
Shinto
Sikhism
Spiritualism
Taoism
Unitarianism
Zoroastrianism
Catholicism
Church of England
Presbyterian/Church of Scotland
Methodism
Lutheranism
Baptist
Church of Wales
Church of Ireland
Pentecostalism
Russian Orthodox
Greek Orthodox
Quaker
Wicca
Druidism
Agnosticism
Unstated
Unspecified/Non-demoniational Christianity
Other
Marthomite
Orthodoxy
Ethiopian Orthodox
No Religion
Adventist
Evangelical
Charismatic

N

• Drop down

Personaldetails:Religiousbelief

tblRegistration.RGREL

Vwperson:Religiousbelief

02/04

To use Oriel Reference table for these fields

44

Disability

TIS List:

YES

NO

Disability 

See: TIS UI Fields - Dropdowns

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

N

• Drop down

Personaldetails:Disability

tblRegistration.RGDISAB

Vwperson:Disability

02/04

To use Oriel Reference table for these fields

45

Disability details

comes from Oriel and free text

Should go with TIS field

Captured only when trainee is registering 

N/A

N/A

N

• Free text

Personaldetails:Disabilitydetails

tblRegistration.RGDISDET

Vwperson:Disabilitydetails

SENSITIVE DATA: Manage Record Function: 

46

Roles

Should go with TIS field

See: TIS UI Fields - Dropdowns

Contact Type:

Training Coordinator
Head of Department
Other

This to also include 'Training Officer'

N

• Drop down

Role

tblTraineeContacts.CNTYPE

47

Comments

Comments

N/A

N/A

N

• Free text

Comments

48

Training Status

This can be captured on TIS placement.

Current/Inactive

Status

See: TIS UI Fields - Dropdowns

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

Y

• 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)

Status

tblRegistration.RGSTAT

02/04:

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

49

TIS: why HCS needs this?

AFC Band

Alex response: HCS Post-training Data

AFC Grade can be added to placement?

Band 1
Band 2
Band 3
Band 4
Band 5
Band 6
Band 7
Band 8a
Band 8b
Band 8c
Band 8d
Band 9

TIS to create?

tblRegistration.RGFJBAND

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 

TIS: why HCS needs this?

First Job Type

Alex response: HCS Post- training Data

Healthcare: NHS
Healthcare: Non-NHS
Not Employed
HSST
Other/Non-Healthcare

TIS to create?

tblRegistration.RGFJTP

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 

50

TIS: why HCS needs this?

Why do you need Salary if you've got AFC bands?

Salary

Alex response: HCS Post- training Data

< £20,000
£20,000 - £24,999
£25,000 - £29,999
£30,000 - £34,999
£35,000 - £40,000
> £40,000

TIS to create?

tblRegistration.RGFJSAL

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 

51

TIS: why HCS needs this?

TIS already record WTE (Whole Time Equivalent) in placement.

What do you need to report here?

Contract Type

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 to create?

tblRegistration.RGFRCNT

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 

52

Not display in TIS FE

Inactive from date

Not required

N/A

N/A

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Inactivefromdate

53

Not display in TIS FE

Inactive notes

Not required

N/A

N/A

N

• Free text

Inactivenotes

QUALIFICATIONS: Qualification -  TIS pull from Oriel (to workout for non-English trainees)

54

Qualification

Should this be Qualification Subjects for HCS? 

See: TIS UI Fields - Dropdowns

To speak to Alex on this

N

Free text

Qualification

tblPrevQual.QUSUBJ

Free text on TIS and there is reference table for HCS

55

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

See: TIS UI Fields - Dropdowns

BEng

BA
BA (Hons)
BEng (Hons)
BSc
BSc (Hons)
BSc CH
MPhys
MPhys (Hons)
MEng
MBioMed
MChem
MSc
MSci
PhD / DPhil
MPhil
MRes
PGCE
PGDip
Diploma
Other
International Equivalent
Unknown
MChem (Hons)
BMedSc
PGCert
BNurs
MBiolSci
BHCS
Foundation

N

• Drop down

Qualificationtype

tblPrevQual.QUNAME

Align with Oriel

56

This comes from Oriel for TIS

Qualification Mark

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

TIS to create?

tbPrevQual.QUMARK

Align with Oriel

57

Qualification for TIS which is free text?

Qualification Subject

Quite a large list of subjects

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

TIS to create?

tblPrevQual.QUSUBJ

Align with Oriel

06/04

How is this diff than line 54?

58

Certification Type 

Attainment

Equivalence

02/04

No longer required

 59

Date attained

Qualification Year

N/A

N/A

N

• Free text - or calendar picker

• date format DD/MM/YYYY

Qualificationattaineddate

60

Not display in TIS FE

Month attained

Not Required

N/A

N/A

N

• Free text - or taken from Date attained field

• date format DD/MM/YYYY

Not in BE

61

Not display in TIS FE

Year attained

Not Required

N/A

N/A

N

• Free text - or taken from Date attained field

• date format DD/MM/YYYY

Not in BE

62

Medical school

University

See: TIS UI Fields - Dropdowns

See long list of universities in HCS reference table

N

• Drop down

Medicalschool

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

63

Country of qualification

Not Required

See: TIS UI Fields - Dropdowns

See long list of countries in HCS reference table

N

• Drop down

Countryofqualification

64

TIS: why HCS needs this?

Qualification Verified By School?

Alex Response: TBC

Yes

No

02/04:

No longer required

PROGRAMME MEMBERSHIP : Programme

65

Programme name

Should go with TIS field

See: TIS UI Fields - Dropdowns

List of Programme types

Y

• Drop down (smartsearch)

• MANDATORY

Programmename

Might be required if specialism will be listed under a programme

02/04:

Programmes are:

STP
HSST
PTP
ASP

Apprenticeships????

66

Can add their Specialism to our programme 

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

See long list of specialism in HCS reference table

TIS to create?

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

02/04

add to curriculum specialty table

67

add to the list of drop down in membership type in row 74/ or be created as a filed?

TIS List:

Programmemembershiptype:

SUBSTANTIVE
LAT
FTSTA
MILITARY
VISITOR

Program Type 

STP

HSST

PTP

ASP

Apprenticeships????

TIS to create?

• 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.

Professional Leads

TIS to create?

68

Can go under academic curricula

ASP Type 

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)

TIS to create?

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

69

Need to know how to display this

Might be added to programme type

Entry Type 

Direct Entry

In-Service

TIS to create?

02/04

TIS: add to programme type. TIS to look at

• about funding 

70

Programme number.

TIS example: EOE922

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

See: TIS UI Fields - Dropdowns

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

Y

• Auto populated when Programme Name is selected

Programmenumber.

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.

71

Owner

This is programme owner  on TIS 

Should go with TIS field

See: TIS UI Fields - Dropdowns

Should be pre-populated with HCS????

Y

• Auto populated when Programme Name is selected

Owner

For TIS - the HEE local offices owns the programmes

02/04

Pre-populated with NSHCS

72

Programme start date

 Should go with TIS field

N/A

N/A

Y

• Free text - or calendar picker

• date format DD/MM/YYYY

• MANDATORY

Programmestartdate

HCS  need to have both curriculum and programme

73

Programme end date

 Should go with TIS field

N/A

N/A

Y

• 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

Programmeenddate

HCS  need to have both curriculum and programme

74

Programme membership type

Same as row 67?

TIS List:

• FTSTA

• LAT

• Military

• Substantive

• Visitor

Should go with TIS field

See: TIS UI Fields - Dropdowns

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'

Y

• Drop down

• MANDATORY

Programmemembershiptype

Is this required for HCS? 

02/04 

Required for HCS

75

Rotation name

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 

N

• Drop down

Rotation

76

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.

See: TIS UI Fields - Dropdowns

Alex Response: It is joined up with 49-51

When trainee finishes programme

Healthcare: NHS

Healthcare: Non-NHS

Not Employed

HSST

Other/Non-Healthcare

N

• Drop down

Leavingdestination

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.

77

Should be part of TIS placement/Assessment 

Status

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

TIS to create?

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

?

78

Training number

Not required

N/A

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

Trainingnumber

PROGRAMME MEMBERSHIP -  Curriculum -  (HCS  are stored on a separate website called Curriculum library - HCS want to keep this)

79

Curriculum

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

See: TIS UI Fields - Dropdowns

Y

• Drop down

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

• MANDATORY 

?

Name????

80

Why do HCS need this?

HSST Cohort

Alex Response: To determine timing of completion and assessments

• Cohort 1

• Cohort 2

• Cohort 3

• Cohort 4

• Cohort 5

• Cohort 6

TIS to create?

81

Curriculum start date

Required for HCS

N/A

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

Y

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

Curriculumstartdate

82

Curriculum end date

Required for HCS

N/A

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

Y

• 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

Curriculumenddate

83

Not display in TIS FE

Curriculum sub-type

Not Required: 

Curriculum sub-type

See: TIS UI Fields - Dropdowns

Alex Response: This is useful for some of our specialities where they branch off - can provide a list at later date

N

N/A

84

Not display in TIS FE

Curriculum specialty

Not Required:

Can specialism comes here?

See: TIS UI Fields - Dropdowns

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

N

N/A

PLACEMENTS: Post 

85

National post number

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

N/A (Refer to Post list)

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

Y

• Drop down or smart search

• limit to Posts within the same Programme as Trainee

Nationalpostnumber

86

Why do HCS need this?

Because placement history will be available in TIS

Previous Post

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

If other - Another field create?

TIS to create?

87

Specialty

Not Required

See: TIS UI Fields - Dropdowns

Alex Response: Not needed

Check list of specialism from HCS reference table

Y

• Drop down

?

Name???

88

Other specialties

Not required

See: TIS UI Fields - Dropdowns

Alex Response: Not needed

N/A

N

• Drop down

?

Sub specialty

Not Required

?

89

Site

Hospital/Trainee Sites

This should be the Hospital Field in HCS?

.

See: TIS UI Fields - Dropdowns

See list in  HCS Ref. for Hospital

exact site trainee work at

Need a list to use from the reference table (HEI, Trusts, university or Hospital?)

Y

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

• editable

?

Sitename

Hospital/Trainee Sites?

90

Other sites

?

?

91

TIS to explain how the post funding works and how HCS will set this up.

TIS post funding 

Trusts 

Is the employer

Need a list to use from the reference table (HEI, Trusts, university or Hospital?)

TIS need to cover non-nhs/ODS list employer. Hcs to provide TIS the list of this

TIS to capture employer and the exact site trainee work at. They are separate fields

?

Trustname???

92

Why do HCS need this? TIS Already got UK universities

TIS - All TIS academic training goes through HEI 

HEI 

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

TIS to create?

93

Local post number

Not required

N/A

N/A

N

• Read only

Localpostnumber

94

Grade

Not Required??

We can add the band grade here 

See: TIS UI Fields - Dropdowns

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

Y

• Drop down (taken from 'other grades' in the post record)

• Autogenerated from Post record

• Editable from full grade list

?

95

Owner

LETB 

Alex response: Need a freetext addition in case 'Split Funding, 'Private funding' or 'Employer-funded' are selected

Pre-populated with NSHCS

LETB:

HEE East Midlands
HEE East of England
HEE Yorkshire and the Humber
HEE Wessex
HEE Thames Valley
HEE North West London
HEE South London
HEE North-Central and East London
HEE Kent, Surrey and Sussex
HEE North East
HEE North West
HEE West Midlands
HEE South West
NHS Wales
NHS Scotland
NHS Northern Ireland
London (Unspecified)
NHS Non-HEE (England Only)
Private Funding
Employer-Funded
Split Funding
Genomics Education
HEE Trent Valley & South West

N

• read only

• derived from Post

Owner

Training description

?

Trainingdescription

PLACEMENT: Placement, Supervisor and Approval

96

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

See: TIS UI Fields - Dropdowns

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

Y

• Drop down

Placementtype

97

Date from

Should go with TIS field

N/A

N/A

Y

• Free text - or calendar picker

• date format DD/MM/YYYY

Datefrom

98

Date to

Should go with TIS field

N/A

N/A

Y

• Free text - or calendar picker

• date format DD/MM/YYYY

Dateto

99

Comment

Not required

N/A

Alex Response: Not Required

N/A

• Free text

?

100

Whole time equivalent

To be captured especially for HSST

N/A

N/A

Y

• Numerical

• equal to, or less than 1

Placementwholetimeequivalent

101

Status

TIS list:

CURRENT

PAST

FUTURE

Should go with TIS field

TIS UI Fields - Dropdowns

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.

N

• autodetermined based on dates

• read only

Status

102

Educational Supervisor

Covered under Placement supervisor in TIS

N/A

N/A

N

• drop down

?

103

Clinical Supervisor

Covered under Placement supervisor in TIS

N/A

N/A

N

• drop down

?

Approval

TIS List:

APPROVED

DRAFT

Is this required?

?

Placement approval

ASSESSMENT : Event, Pre-assessment details and Post -Assessment details

Trainee First Name

Should go with TIS field

Assessment Event

Firstname

Trainee Surname

Should go with TIS field

Assessment Event

Lastname

Type

TIS List:

ACADEMIC
ARCP
FRCP
FRCP_STAGE_2
IRCP
RITA

Should go with TIS field

Assessment Event

Type

Review Date

Should go with TIS field

Assessment Event

Reviewdate

Programme Number

Should go with TIS field

Assessment Event

Programmenumber

Programme name

Should go with TIS field

Assessment Event

Programmename

Curriculum name

Should go with TIS field

Pre-Assessment Detail

Curriculumname

Curriculum specialty

Should go with TIS field

Pre-Assessment Detail

Curriculumspecialty

Curriculum sub-type

Should go with TIS field

Pre-Assessment Detail

Curriculumsubtype

WTE months OOPR/T during period

(out of programme research or training)

Should go with TIS field

Pre-Assessment Detail

Monthswtedurinperiod

PYA

(penultimate year assessment)

TIS list:

YES

NO

Should go with TIS field

Pre-Assessment Detail

Pya

Days out of training

Should go with TIS field

Pre-Assessment Detail

Daysoutoftraining

Curriculum start date

Should go with TIS field

Pre-Assessment Detail

Curriculumstartdate

Curriculum end date

Should go with TIS field

Pre-Assessment Detail

Curriculumenddate

Membership type

Should go with TIS field

Pre-Assessment Detail

Pre-populated as Substansive

Membershiptype

Period covered from

Should go with TIS field

Pre-Assessment Detail

Periodcoveredfrom

Period covered to

Should go with TIS field

Pre-Assessment Detail

Periodcoveredto

Months OOPR/OOPT counted towards training

Should go with TIS field

Pre-Assessment Detail

Monthscountedtotraining

Grade at time

Should go with TIS field

Pre-Assessment Detail

Gradename

Not sure if Gradename is the BE for TIS

Outcome

TIS List:

Not ASSESSED

1
2
3
4
5
6
6R
7
8
9

Review Outcome

N/A

Post- Assessment- Outcome

See different outcomes in Reference table for STP and HSST

N

Read only - derived from assessment

Outcome

Why do you need this?

MSc Outcome 

Post- Assessment- Outcome

Pass

Merit

Distinction

Fail

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

?

Why do you need this?

OSFA Result  - Must have

Post- Assessment- Outcome

?

Why do you need this?

OSFA Type - Must have

Post- Assessment- Outcome

Full

Mock

Resit

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

?

Why do you need this?

OSFA Result  - Must have

Post- Assessment- Outcome

Pass

Fail

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

Read only - derived from assessment

?

Under Appeal

TIS List:

YES

NO

Should go with TIS field

Post- Assessment- Outcome

Read only - derived from assessment

Underappeal

Reason

Should go with TIS field

Post- Assessment- Reason

Reason

Other

Should go with TIS field

Post- Assessment- Reason

Other

External trainer

TIS List:

YES

NO

Should go with TIS field

N/A

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

N

Read only - derived from assessment

Externaltrainer

Next review date

Should go with TIS field

Post-assessment - Details

Nextreviewdate

Completion of training date (prior to review)

Should go with TIS field

Post-assessment - Details

Trainingcompletiondate

Grade at next rotation

Should go with TIS field

Post-assessment - Details

Nextrotationgradename

Comments

Should go with TIS field

Post-assessment - Details

Comments

Academic curriculum assessed

Should go with TIS field

Post-assessment - Academic Progression

Academiccurriculumassessed

Academic outcome

TIS list:

Continue on academic component

Do not Continue on academic component

Successfully  completed academic component

Should go with TIS field

Post-assessment - Academic Progression

Academicoutcome

Detailed reason

Should go with TIS field

Post-assessment - Supplementary Details

Setailedreasons

Competences which need to be developed by next ARCP

Should go with TIS field

Post-assessment - Supplementary Details

Competencestobedeveloped

Recommended additional training time (if required)

Should go with TIS field

Post-assessment - Supplementary Details

Recommendedaddtnltrainingtime

Mitigating circumstances

Should go with TIS field

Post-assessment - Supplementary Details

Mitigatingcircumstances

Other recommended actions

Should go with TIS field

Post-assessment - Supplementary Details

Otherrecommendedactions

Additional comments from the panel

Should go with TIS field

Post-assessment - Supplementary Details

Addcommentsfrompanel

Documents

Add documents

Should go with TIS field

Filter by tag

Should go with TIS field

Search documents

Should go with TIS field

Link to Trainee e-portfolio's document on TIS- HCS to provide codes.