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   TISNEW-4260 - Getting issue details... STATUS
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 converted to Free Text Field	P1	Enum DD needed Converted to Free Text Field		Request list from Hicom with 'Status' and use their list of Current values. Agreed with JH to use Current list for now and revisit in future to cleanse redundant ones. We will come back and revisit qualification later with a new version of the dropdown which allows free text input but allows searching existing reference values	TISDEV-4231
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.	TISDEV-4230
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	Search Dropdown
21	Programme number	Dropdown (Read only)		Not Required
22	Owner	Dropdown (Read only)		Not Required
23	Programme membership type	Search Dropdown	P1	Ref DD needed		Request list from Hicom with 'Status' and use their list of Current values. List already alighed.	Already aligned.
24	Rotation	Dropdown (Read only)		Ref DD needed	validation made case insensitive
25	Leaving destination	Dropdown		Ref DD needed		Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4229
26	Training number	?		Not Required
27	Curriculum	Dropdown	P1	Not Required
Placements
28	National post number	Search Dropdown	P1	Search Dropdown
29	Site	Search Dropdown	P1	Search Dropdown	validation made case insensitive	10/04: Data leads recommendation is to display the SiteKnownAs Current values in the Site dropdowns on TIS	TISDEV-4327 - Getting issue details... STATUS
30	Owner	Dropdown (Read only)	P1	Not Required
31	Grade	Search Dropdown	P1	Search Dropdown	validation made case insensitive	Request list from Hicom with 'Status' and use their list of Current values. Recommendation is to show Current grades that are Training AND Placement type.	TISDEV-4225
32	Local post number	Dropdown (Read only)		Not Required
33	Specialty	Search Dropdown	P1	Search Dropdown		Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4227
34	Other specialties	Search Dropdown		Search Dropdown		Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4227
35	Status	Dropdown (Read only)		Not Required
36	Placement type	Search Dropdown	P1	Reference Dropdown	validation made case insensitive	Centrally managed spreadsheet	TISDEV-4210
Assessments - Event
37	Type	Dropdown	P1	Reference Dropdown
38	Status	Dropdown		Enum DD
39	Programme name	Dropdown	P1	Not Required
40	Programme number	Dropdown (Read only)		Not Required
Assessments - Pre-assessment detail
41	Curriculum name	Dropdown	P1	Not Required
42	Curriculum specialty	Dropdown (Read only)		Not Required		Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4227
43	Curriculum sub-type	Dropdown (Read only)	P1	Not Required
44	Membership type	Dropdown (Read only)	P1	Not Required
45	PYA	Dropdown		Enum DD
46	Grade at time	Dropdown (Read only)		Not Required
Assesssments - Post-assessment detail
47	Outcome	Dropdown	P1	Not Required
48	Under appeal	Dropdown	P1	Enum DD
49	Reason	Dropdown	P1	Not Required
50	10% audit - lay member	Dropdown		Enum DD
51	External trainer	Dropdown		Enum DD
52	Grade at next rotation	Search Dropdown		Search Dropdown
53	Trainee notified of outcome	Dropdown		Enum DD
54	Academic curriculum assessed	Dropdown (Read only)		Not Required
55	Academic outcome	Dropdown (Read only)		Not Required
Assessments - Revalidation
56	Known concerns	Dropdown		Enum DD

Programmes

Curriculum

#	TIS UI label	Field type	Notes (P1 or not?)	FE Status	BE Status	Reference data checked
1	Curriculum sub type (optoinal)	Dropdown
2	Assessment type	Dropdown
3	Status	Dropdown
4	Does this curriculum lead to cct	Dropdown
5	Specialty	Dropdown				Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4227

Posts

#	TIS UI label	Field type	Notes (P1 or not?)	FE Status	BE Status	Reference data checked	Ticket #
1	Main site	Search Dropdown				10/04: Data leads recommendation is to display the SiteKnownAs Current values in the Site dropdowns on TIS	TISDEV-4327 - Getting issue details... STATUS
2	Other sites	Search Dropdown				10/04: Data leads recommendation is to display the SiteKnownAs Current values in the Site dropdowns on TIS	TISDEV-4327 - Getting issue details... STATUS
3	Specialty	Search Dropdown				Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4227
4	Other specialties	Search Dropdown				Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4227
5	Sub specialties	Search Dropdown				Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4227
6	Approved grade	Search Dropdown				Recommendation is to show Current grades that are Training AND Post grade type.	TISDEV-4225
7	Other grades	Search Dropdown				Recommendation is to show Current grades that are Training AND Post grade type.	TISDEV-4225
8	Owner	Search Dropdown
9	Employing body	Search Dropdown				Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4228
10	Training body	Search Dropdown				Request list from Hicom with 'Status' and use their list of Current values.	TISDEV-4228
11	Programme name	Search Dropdown
12	Old post	Search Dropdown
13	New post	Search Dropdown
14	Funding type	Dropdown				Use centrally managed s/s values. Already aligned on TIS	Already aligned.
15	Funding body	Search Dropdown				AR 11/10/2018: Currently using Trust reference table current values.  IO: Legacy field - to be looked at separately. (JW/IO/JH) Follow up with JW. To make read-only for now on TIS.