Introduction

This page details dropdown data items in use on the Trainee Information System (TIS) for the following.

• People
• Programmes and Curricula
• Posts
• Placements

There is a currently a requirement to surface historical dropdown/reference values that exist against existing trainee records for viewing only, however in a create/edit mode, allowing the user to only be able to choose a current reference value from the list to update/create records with.

Narrative

Dropdown - Normal dropdown: 

Search Dropdown - Search as you type dropdown:

Dropdown (Read only) - Dropdowns that are pre-populated as a result of selecting another field and not editable:

People and Placements

#	TIS UI label	Field type	Notes (P1 or not?)	FE Status	BE Status	Reference data checked	Ticket #
Personal details
1	Title	Dropdown	P1	Ref DD needed	No Validation	Use Oriel list, agreed with JamesH.	TISDEV-4184
2	GMC status	Dropdown		Ref DD needed	No Validation	Use LRMP list, agreed with JamesH.	TISDEV-4183
2a	GDC Status	Dropdown		Ref DD needed	No Validation	Use centrally managed s/s values	TISDEV-4185
Sensitive data
3	EEA resident	Dropdown	P1	Enum DD needed	No Validation	Use centrally managed s/s values	TISDEV-4186
4	Permit to work	Dropdown	P1	Enum DD needed (temporary - new ref table + endpoints to task up)	No Validation	Use all Oriel + Tier 3, agreed with JamesH	TISDEV-4188
5	Settled	Dropdown	P1	Enum DD needed	No Validation	Use centrally managed s/s values	TISDEV-4189
6	Gender	Dropdown		Ref DD needed	No Validation	Use Oriel list, agreed with JamesH.	TISDEV-4183
7	Nationality	Dropdown		Ref DD needed	No Validation	Request list from Hicom with 'Status' and use their list of Current values. - Use ESR list agreed with JH/DS.	TISDEV-4220
8	Dual Nationality	Dropdown		Ref DD needed	No Validation	Request list from Hicom with 'Status' and use their list of Current values. Use ESR list agreed with JH/DS.	TISDEV-4220
9	Ethnic origin	Dropdown		Ref DD needed	No Validation	Use Oriel list, agreed with JamesH.	TISDEV-4202
10	Marital status	Dropdown		Ref DD needed	No Validation	Use centrally managed s/s values, confirmed with JH.	TISDEV-4207
11	Sexual orientation	Dropdown		Ref DD needed	No Validation	Use centrally managed s/s values	TISDEV-4208
12	Religious belief	Dropdown		Ref DD needed	No Validation	Use centrally managed s/s values, confirmed with JH.	TISDEV-4209
13	Disability	Dropdown		Enum DD needed	No Validation	Use Oriel list, agreed with JH/CL.	TISDEV-4211
14	Role	Dropdown	P1	Needs separate story to include new multi-select control	Using flyway script, roles are inserted
15	Status	Dropdown	P1	Enum DD needed	No Validation
Qualifications
16	Qualification	Dropdown	P1	Enum DD needed		Request list from Hicom with 'Status' and use their list of Current values.
17	Qualification type	Dropdown		Enum DD needed - should this be a reference table - will ask DQ/POs		Use centrally managed s/s values, confirmed by JH.	TISDEV-4218
18	Medical school	Dropdown (needs to be Search Dropdown)	P1	Needs converting to Search Dropdown (too much data for DD - broken on Prod as stops at 'R')	validation made case insensitive	Request list from Hicom with 'Status' and use their list of Current values.
19	Country of qualification	Dropdown		Ref DD needed	validation made case insensitive	Request list from Hicom with 'Status' and use their list of Current values.List is consistent with Oriel and ESR.	TISDEV-4223
Programme membership
20	Programme name	Search Dropdown	P1
21	Programme number	Dropdown (Read only)
22	Owner	Dropdown (Read only)
23	Programme membership type	Search Dropdown	P1			Request list from Hicom with 'Status' and use their list of Current values. List already alighed.	Already aligned.
24	Rotation	Dropdown (Read only)			validation made case insensitive
25	Leaving destination	Dropdown				Request list from Hicom with 'Status' and use their list of Current values.
26	Training number	?
27	Curriculum	Dropdown	P1
Placements
28	National post number	Search Dropdown	P1
29	Site	Search Dropdown	P1		validation made case insensitive	Surface Current sites on TIS.
30	Owner	Dropdown (Read only)	P1
31	Grade	Search Dropdown	P1		validation made case insensitive	Request list from Hicom with 'Status' and use their list of Current values.
32	Local post number	Dropdown (Read only)
33	Specialty	Search Dropdown	P1			Request list from Hicom with 'Status' and use their list of Current values.
34	Other specialties	Search Dropdown				Request list from Hicom with 'Status' and use their list of Current values.
35	Status	Dropdown (Read only)
36	Placement type	Search Dropdown	P1		validation made case insensitive	Centrally managed spreadsheet	TISDEV-4210
Assessments - Event
37	Type	Dropdown	P1
38	Status	Dropdown
39	Programme name	Dropdown	P1
40	Programme number	Dropdown (Read only)
Assessments - Pre-assessment detail
41	Curriculum name	Dropdown	P1
42	Curriculum specialty	Dropdown (Read only)
43	Curriculum sub-type	Dropdown (Read only)	P1
44	Membership type	Dropdown (Read only)	P1
45	PYA	Dropdown
46	Grade at time	Dropdown (Read only)
Assesssments - Post-assessment detail
47	Outcome	Dropdown	P1
48	Under appeal	Dropdown	P1
49	Reason	Dropdown	P1
50	10% audit - lay member	Dropdown
51	External trainer	Dropdown
52	Grade at next rotation	Search Dropdown
53	Trainee notified of outcome	Dropdown
54	Academic curriculum assessed	Dropdown (Read only)
55	Academic outcome	Dropdown (Read only)
Assessments - Revalidation
56	Known concerns	Dropdown

Programmes

Curriculum

Posts

#	TIS UI label	Field type	Notes (P1 or not?)	Reference data checked	Ticket #
1	Main site	Search Dropdown
2	Other sites	Search Dropdown
3	Specialty	Seacrh Dropdown
4	Other specialties	Seacrh Dropdown
5	Sub specialties	Seacrh Dropdown
6	Approved grade	Seacrh Dropdown
7	Other grades	Seacrh Dropdown
8	Owner	Seacrh Dropdown
9	Employing body	Seacrh Dropdown		Request list from Hicom with 'Status' and use their list of Current values.
10	Training body	Seacrh Dropdown		Request list from Hicom with 'Status' and use their list of Current values.
11	Programme name	Seacrh Dropdown
12	Old post	Seacrh Dropdown
13	New post	Seacrh Dropdown
14	Funding type	Dropdown		Use centrally managed s/s values. Already aligned on TIS	Already aligned.
15	Funding body	Seacrh Dropdown		Legacy field - to be looked at separately. Ticket? Follow up with JW. To make read-only for now on TIS.