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 Name

TIS BE Field name

HCS BE Table Name

HCS BE Field Name

NDW BE Table Name

NDW BE Field name

Comments

1

Full Name

Should go with TIS field

N/A

N/A

Y

• Editable via Forename, Surname field changes

?

?

tblRegistration

RGFNAME

RGSNAME

?

?

TIS Question: Anywhere this is captured in BE?

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

N/A

N/A

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

N/A

N/A

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

N/A

N/A

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

N/A

N/A

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

N/A

N/A

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

RGWKPHN

Vwperson

Telephonenumber

Question for HCS: tblRegistration.RGWKPHN Seems to capture Landline

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

tblRegistration.RGPSPHN???

Vwperson:Mobilenumber

Question for HCS: Can tblRegistration.RGPSPHN be used for mobile?

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

Question for HCS:

tblRegistration.RGWKEML- Personal email

tblRegistration.RGPSEML - Professional email

tblRegistration.ACEML - Personal email

How do we work this out to know which to capture?

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

N/A

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

Question for HCS: Is this required?

TIS to add a field

HCPC start date

Question for HCS: Is this required?

Should it be the start date of the programme?

TIS to add a field

HCPC end date

Question for HCS: Is this required?

Should it be the end date of the programme?

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

N/A

N/A

Vwperson

Gmcnumber

19

GMC status

Not Required

See: TIS UI Fields - Dropdowns

N/A

N

• Drop down

Gmcdetails

Gmcstatus

N/A

N/A

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

N/A

N/A

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

N/A

N/A

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

Question for HCS: Where do you capture this in your database?

23

GDC status

Should go with TIS field

See: TIS UI Fields - Dropdowns

N/A

N

• Free text

Gdcdetails

Gdcstatus

Vwperson

Gdcstatus

Question for HCS: Is this required?

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

Question for HCS: Is this required?

Should it be the end date of the programme?

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

Question for HCS: Is this required?

Should it be the end date of the programme?

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

N/A

N/A

Vwperson

Publichealthnumber

27

Not display in TIS FE

College

Not Required

In TIS ref.table

N/A

N

• N/A

College

Name

N/A

N/A

?

?

TIS Question: BE field in NDW?

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

Question for HCS: Need to know where this is captured in your database. Which field?

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

Question for HCS: Need to know where this is captured in your database. Which field?

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

Question for HCS: Need to know where this is captured in your database. Which field?

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

Question for HCS: Need to know where this is captured in your database. Which field?

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

Question for HCS: Need to know where this is captured in your database. Which field?

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

Question for HCS: Need to know where this is captured in your database. Which field?

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

N/A

N/A

?

?

Question for TIS: Need to know where this is captured in NDW

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?

N/A

N/A

?

?

Question for TIS: Need to know where this is captured in TIS BE and NDW

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

N/A

N/A

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

N/A

N/A

Vwperson

Maritalstatus

42

Sexual orientation

Not Required

See: TIS UI Fields - Dropdowns

N/A

N

• Drop down

Personaldetails

Sexualorientation

N/A

N/A

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

Person

Role

tblTraineeContacts

CNTYPE

Vwperson

Role

47

Comments

Comments

N/A

N/A

N

• Free text

Person

Comments

?

?

Vwperson

Comments

Question for HCS: Need to know where this is captured in your database. Which field?

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)

Person

Status

tblRegistration

RGSTAT

Vwperson

Status

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

Person

Inactivefromdate

N/A

N/A

Vwperson

Inactivedate

53

Not display in TIS FE

Inactive notes

Not required

N/A

N/A

N

• Free text

Person

Inactivenotes

N/A

N/A

Vwperson

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

Qualification

tblPrevQual

QUSUBJ

Vwpersonqualification

Qualification

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

Qualification

Qualificationtype

tblPrevQual

QUNAME

Vwpersonqualification

Qualificationtype

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

?

?

N/A

N/A

?

?

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

Qualification

Qualificationattaineddate

?

?

Vwpersonqualification

Dateattained

HCS Question

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

N/A

N/A

Vwpersonqualification

Monthattained

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

N/A

N/A

Vwpersonqualification

Yearattained

TIS question

62

Medical school

University

See: TIS UI Fields - Dropdowns

See long list of universities in HCS reference table

N

• Drop down

Qualification

Medicalschool

Vwpersonqualification

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

Qualification

Countryofqualification

N/A

N/A

Vwpersonqualification

Country

64

TIS: why HCS needs this?

Qualification Verified By School?

Alex Response: TBC

Yes

No

N/A

N/A

N/A

N/A

N/A

N/A

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

Programme

Programmename

?

?

Vwprogramme

Programmename

Questions for HCS and TIS on Field and table

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

?

Specialty

TIS to create?

Name

?

?

?

Vwspecialty

?

Specialtyname

Questions for HCS and TIS on Field and table

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

?

Programmemembership

TIS to create?

Programmemembershiptype

?

?

?

Vwprogrammerotationmembership

?

Membershiptype

Questions for HCS and TIS on Field and table

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

?

?

?

?

Questions for HCS on Field and table

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?

?

?

?

?

Questions for HCS on Field and table

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?

?

?

?

?

Questions for HCS on Field and table

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

Programme

Programmenumber

?

?

Vwprogramme

Programmenumber

Questions for HCS on Field and table

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

Programme

Owner

?

?

Vwprogramme

Managingdeanery

Questions for HCS on Field and table

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

Programmemembership

Programmestartdate

?

?

Vwprogrammerotationmembership

Programmestartdate

Questions for HCS on Field and table

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

Programmemembership

Programmeenddate

?

?

Vwprogrammerotationmembership

Programmeenddatewithprog

Questions for HCS on Field and table

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

Programmemembership

Programmemembershiptype

?

?

Vwprogrammerotationmembership

Membershiptype

Questions for HCS on Field and table

02/04 

Required for HCS

Is this 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

Programmemembership

Rotation

N/A

N/A

Vwprogrammerotationmembership

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

Programmemembership

Leavingdestination

?

?

Vwcurriculummembership

Leavingdestination

Questions for HCS on Field and table

02/04

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

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? **

77

Should be part of TIS placement/Assessment 

Status

OLAT Status

Current

Passed

Incomplete (Extension)

Incomplete (Fail)

Leaver

Suspended

?

TIS to create?

?

?

?

?

Questions for HCS on Field and table

09/04

OLAT Status - legacy data to be decided by HCS where they go.

 TS: Can help to add the OLAT into NDW.

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

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

?

?

?

?

Vwcurriculummembership

Trainingpathway

Questions for HCS and TIS on Field and table

09/04

These are different programme pathways which are the requirement to meet in HSST.

TIS: Specialty/sub-specialty…?

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

Trainingnumber

N/A

N/A

Vwcurriculummembership

Trainingnumber

09/04

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 

Curriculum

Name

?

?

Vwcurriculum

Name

Questions for HCS on Field and table

09/04

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?

?

?

?

?

Questions for HCS and TIS on Field and table
09/04

Trainee goes into cohort that meets their completion dates. TIS uses trainee completion date.

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

Programmemembership

Curriculumstartdate

?

?

Vwcurriculummembership

Curriculumstartdate

Questions for HCS on Field and table

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

Programmemembership

Curriculumenddate

?

?

Vwcurriculummembership

Curriculumenddate

Questions for HCS on Field and table
TIS - To look into POG on how it will impact

83

Not display in TIS FE

Curriculum sub-type

 Go with TIS field

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

Curriculum

Curriculumsubtype

N/A

N/A

Vwcurriculummembership

Curriculumsubtype

09/04

HCS Curriculum sub-type

84

Not display in TIS FE

Curriculum specialty

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

?

?

?

?

?

?

Questions for HCS and TIS on Field and table

09/04

HCS specialism comes in here

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

Post

Nationalpostnumber

?

?

Vwpost

Nationalpostnumber

Questions for HCS on Field and table
09/04

HCS Posts - will be assigned npn

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?

?

?

?

?

Questions for HCS and TIS on Field and table
09/04

This explains what trainee was doing before coming on the programme.

TIS: this may go into NDW but not FE

87

Specialty

Not Required

See: TIS UI Fields - Dropdowns

Alex Response: Not needed

Check list of specialism from HCS reference table

Y

• Drop down

Specialty

Name

N/A

N/A

Vwspecialty

Specialtyname

09/04

88

Other specialties

Not required

See: TIS UI Fields - Dropdowns

Alex Response: Not needed

N/A

N

• Drop down

?

?

N/A

N/A

?

?

Questions for TIS on Field and table

Sub specialty

Not Required

?

?

N/A

N/A

Vwspecialty

Subspecialty

89

Site

Hospital/Trainee Sites

.

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

Site

Sitename/Siteknownas?

?

?

Vwsite

Sitename/Siteknownas?

Question for TIS and HCS on Field and table

Hospital/Trainee Sites?

09/04

List from ODS and private providers for HCS

Employers - Hospital

Trainee sites- training site

90

Other sites

?

?

?

?

?

Vwpostothersite

Sitename/Siteknownas?

Question for TIS and HCS on Field and table

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

Trust

Trustname/Trustknownas?

?

?

Vwtrust

Trustname/Trustknownas?

Question for TIS and HCS on Field and table

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?

?

?

Question for TIS and HCS on Field and table

09/04

Certain programme associated to certain universities.

TIS: Future work on academic curricular

93

Local post number

Not required

N/A

N/A

N

• Read only

Post

Localpostnumber

N/A

N/A

Vwpost

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

Grade

Name

?

?

Vwgrade

Gradename

Question for HCS on Field and table

09/04

This is collected at the end of programme for HCS. - Progression within curriculum

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

Post

Owner

?

?

?

?

Question for TIS and HCS on Field and table

09/04

TIS- Local Office

HCS - Funding provider. this might not be region based.

Training description

?

Post

Trainingdescription

?

?

Vwpost

Trainingdescription

Question for HCS on Field and table

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

Placement

Placementtype

?

?

Vwplacement

Placementtype

Question for HCS on Field and table

09/04

HCS - record programme

maternity might be cover here

97

Date from

Should go with TIS field

N/A

N/A

Y

• Free text - or calendar picker

• date format DD/MM/YYYY

Placement

Datefrom

?

?

Vwplacement

Startdate

Question for HCS on Field and table

98

Date to

Should go with TIS field

N/A

N/A

Y

• Free text - or calendar picker

• date format DD/MM/YYYY

Placement

Dateto

?

?

Vwplacement

Enddate

Question for HCS on Field and table

99

Comment

Not required

N/A

Alex Response: Not Required

N/A

• Free text

?

?

N/A

N/A

Vwplacement

Comments

Question for TIS on Field and table

100

Whole time equivalent

To be captured especially for HSST

N/A

N/A

Y

• Numerical

• equal to, or less than 1

Placement

Placementwholetimeequivalent

?

?

Vwplacement

Wholetimeequivalent

Question for HCS on Field and table

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

Placement

Status

?

?

Vwplacement

Status

Question for HCS on Field and table

102

Educational Supervisor

Covered under Placement supervisor in TIS

N/A

N/A

N

• drop down

?

?

Vwplacementsupervisor

Supervisorforenames

Supervisorsurname

Question for TIS and HCS on Field and table

103

Clinical Supervisor

Covered under Placement supervisor in TIS

N/A

N/A

N

• drop down

?

?

?

?

Question for TIS and HCS on Field and table

Approval

TIS List:

APPROVED

DRAFT

Is this required?

?

?

?

?

Vwplacement

Lifecyclestate

Question for TIS and HCS on Field and table

Placement approval

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

Trainee First Name

Should go with TIS field

Assessment Event

Assessment

Firstname

?

?

Vwassessment

Forenames

Question for HCS on Field and table

Trainee Surname

Should go with TIS field

Assessment Event

Assessment

Lastname

?

?

Vwassessment

Surname

Question for HCS on Field and table

Type

TIS List:

ACADEMIC
ARCP
FRCP
FRCP_STAGE_2
IRCP
RITA

Should go with TIS field

Assessment Event

Assessment

Type

?

?

Vwassessment

Assessmenttype

Question for HCS on Field and table

HCS assessment type to be added ?

Review Date

Should go with TIS field

Assessment Event

Assessment

Reviewdate

?

?

Vwassessment

Reviewdate

Question for HCS on Field and table

Programme Number

Should go with TIS field

Assessment Event

Assessment

Programmenumber

?

?

Vwassessment

Programmenumber

Question for HCS on Field and table

Programme name

Should go with TIS field

Assessment Event

Assessment

Programmename

Vwassessment

Programmename

Question for HCS on Field and table

Curriculum name

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Curriculumname

Vwassessment

Curriculumname

Question for HCS on Field and table

Curriculum specialty

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Curriculumspecialty

Vwassessment

Specialtyname??

Question for TIS and HCS on Field and table

Curriculum sub-type

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Curriculumsubtype

Vwassessment

Curriculumsubtype

Question for HCS on Field and table

WTE months OOPR/T during period

(out of programme research or training)

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Monthswteduringperiod

Vwassessment

Wtemonthsooprt

Question for HCS on Field and table

PYA

(penultimate year assessment)

TIS list:

YES

NO

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Pya

Vwassessment

pya

Question for HCS on Field and table

Days out of training

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Daysoutoftraining

Vwassessment

Timeoutoftrainingdays

Question for HCS on Field and table

Curriculum start date

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Curriculumstartdate

Vwassessment

Curriculumstartdate

Question for HCS on Field and table

Curriculum end date

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Curriculumenddate

Vwassessment

Curriculumenddate

Question for HCS on Field and table

Membership type

Should go with TIS field

Pre-Assessment Detail

Pre-populated as Substansive

Assessmentdetail

Membershiptype

Vwcurriculummembership

Membershiptype

Question for HCS on Field and table

Period covered from

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Periodcoveredfrom

Vwassessment

Periodcoveredfrom

Question for HCS on Field and table

Period covered to

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Periodcoveredto

Vwassessment

Periodcoveredto

Question for HCS on Field and table

Months OOPR/OOPT counted towards training

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Monthscountedtotraining

Vwassessment

Trainingmonthsooprt

Question for HCS on Field and table

Grade at time

Should go with TIS field

Pre-Assessment Detail

Assessmentdetail

Gradename

Vwdrade

Gradename

Question for HCS on Field and table

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

Assessmentoutcome

Outcome

Vwassessment

Outcome

Question for HCS on Field and table

09/04

HCS - don’t use code

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.

?

?

?

?

?

?

Question for TIS and HCS on Field and table

Outcome

Why do you need this?

OSFA Result  - Must have

Post- Assessment- Outcome

?

?

?

?

?

?

Question for TIS and HCS on Field and table

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.

?

?

?

?

?

?

Question for TIS and HCS on Field and table
Outcome

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

?

?

?

?

?

?

Question for TIS and HCS on Field and table

Under Appeal

TIS List:

YES

NO

Should go with TIS field

Post- Assessment- Outcome

Read only - derived from assessment

Assessmentoutcome

Underappeal

Vwassessment

Appealed

Question for HCS on Field and table

Reason

Should go with TIS field

Post- Assessment- Reason

Assessmentoutcome

Reason

Vwassessment

Detailedreasonforrecommendedoutcome

Question for HCS on Field and table

Other

Should go with TIS field

Post- Assessment- Reason

Assessmentoutcomereason

Other

?

?

Question for TIS and HCS on Field and table

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

Assessmentoutcome

Externaltrainer

Vwassessment

Externaltrainer

Question for HCS on Field and table

Next review date

Should go with TIS field

Post-assessment - Details

Assessmentoutcome

Nextreviewdate

Vwassessment

Nextreviewdate

Question for HCS on Field and table

Completion of training date (prior to review)

Should go with TIS field

Post-assessment - Details

Assessmentoutcome

Trainingcompletiondate

Vwassessment

Trainingcompletiondateprereview

Question for HCS on Field and table

Grade at next rotation