Process to record GMC number, GDC number and PH number on TIS

Data leads have agreed and validated the below (11/12/2019) for rules around recording registration numbers on TIS:

UKNOWN should be used GMC/GDC/PH number when not known but trainee is on a relevant programme for either Medical, Dental or Public Health respectively.
N/A should be used for non-clinical person records
If a GMC number is provided and the trainee does not have a GDC and PH, then these can be left as Nulls
If a GDC and a GMC number is provided then, PH can be left as null
If GDC is provided and this is the only registration number for the trainee, then GMC and PH can be left as nulls
If the GMC number is not known and this is not a dental trainee at the time of adding a trainee, and no other registration numbers are provided, then GMC should be entered as UNKNOWN and the other 2 left as nulls
If trainee is from a dental programme and no registration numbers is known, then GMC and PH can be left as nulls and UNKNOWN entered in GDC
If a trainee is a PH trainee, then PH number is entered or if not known then entered as UNKNOWN and the GDC and GMC numbers left as nulls.

People - Field Validation

The below details the rules and validation criteria for People related data.

General Rules that should apply are as follows

limit all drop down fields to the selection of Current Values only TISDEV-4429 - Getting issue details... STATUS

Bulk People Rules can be viewed in Scenario PP-6 here: People - Scenarios | Bulk Imports

Any rule / constraint highlighted in blue needs to be revisited for a particular area

Field Sequence	Field name (V10)	Reference table	Current FE Validation & Rules	List Page? (Y / N)	List Page Rules (sort/filter)	Proposed FE Validation & Rules	Proposed BE Validation & Rules	Error Messages	Notes	BE Validation applicable to Bulk People Upload (Y/N)	Delete (Y / N)
HEADER TISDEV-4478 - Getting issue details... STATUS / TISDEV-4479 - Getting issue details... STATUS
1	Full Name	N/A	Editable via Forename, Surname field changes	N	N/A	Type: Derived Character type: Alphanumerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: derived from Forename + Surname Mandatory: Yes Editable: Yes (via changes in Forename and Surname fields) Default value: None	Type: Derived Character type: Alphanumerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: derived from Forename + Surname Mandatory: Yes Editable: Yes (via changes in Forename and Surname fields) Default value: None	N/A	Type: Derived Character type: alphanumerical Character length: min 1 / no max Dependencies: derived from Forename + Surname Mandatory: No Editable: Yes (via changes in Forename and Surname fields) Default value: blank Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( )	N
2	PersonID	NA	System generated field - Automated upon creation of record Read only	Y	N/A	Type: System generated Character type: Numerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters, Max characters Dependencies: derived from Forename + Surname Mandatory: Yes Editable: Yes (via changes in Forename and Surname fields) Default value: None	Type: System generated Character type: Numerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters, Max characters Dependencies: derived from Forename + Surname Mandatory: Yes Editable: Yes (via changes in Forename and Surname fields) Default value: None	N/A	Discussion to be held about this field and whether it remains in TIS UI System generated field - Automated upon creation of record	N
PERSONAL DETAILS: Personal TISDEV-4480 - Getting issue details... STATUS / TISDEV-4516 - Getting issue details... STATUS
3	Title	See: TIS UI Fields - Dropdowns	drop down	N	N/A	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: Blank	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: Blank	N/A	Type: drop down Mandatory: no Editable: yes Default value: blank	N
4	Forename	N/A	Free text No special characters (excl apostrophes ( ' ), hypens ( - ) and spaces ( ) Multiple names allowable Upper and lower case allowed MANDATORY	Y	Sort	Type: Manual entry Character type: Alphanumerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: Mandatory: Yes Editable: Yes Default value: Multiple names allowed Upper and lower case letters allowed	Type: Manual entry Character type: Alphanumerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: Mandatory: Yes Editable: Yes Default value: Multiple names allowed Upper and lower case letters allowed	Forename is required No special characters, with the exception of apostrophes, full stops, hyphens and spaces	Type: manual entry Character type: alphanumerical Character length: min 1/ no max Dependencies: Full name (record header) Mandatory: yes Editable: yes Default value: blank Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Multiple names allowed Upper and lower case letters allowed	Y
5	Legal Forenames	N/A	Free text No special characters (excl apostrophes ( ' ), hypens ( - ) and spaces ( )) Multiple names allowable Upper and lower case allowed	N	N/A	Type: Manual entry Character type: Alphanumerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: Full name (record header) Mandatory: No Editable: Yes Default value: Derived from Forename Multiple names allowed Upper and lower case letters allowed	Type: Manual entry Character type: Alphanumerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: Full name (record header) Mandatory: No Editable: Yes Default value: Derived from Forename Multiple names allowed Upper and lower case letters allowed	No special characters, with the exception of apostrophes, full stops, hyphens and spaces	Type: manual entry Character type: alphanumerical Character length: min 1/ no max Dependencies: Full name (record header) Mandatory: no Editable: yes Default value: derived from Forename Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Multiple names allowed Upper and lower case letters allowed	N
6	Initials	N/A	Free text No special characters (excl spaces ( )) Multiple initials allowable Upper case only	N	N/A	Type: Derived from first character of forename(s) Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: Derived from first character of forename(s) Multiple initials allowable Upper case only	Type: Derived from first character of forename(s) Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: Derived from first character of forename(s) Multiple initials allowable Upper case only	Initials are required	Do we really need this field? TBD Free text No special characters (excl apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Multiple initials allowable Upper case only	N
7	Surname	N/A	Free text No special characters (excl apostrophes ( ' ), hypens ( - ) and spaces ( )) Multiple names allowable Upper and lower case allowed MANDATORY	Y	Sort	Type: Manual entry Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ) and spaces ( ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: None	Type: Manual entry Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ) and spaces ( ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: None	Surname is required No special characters, with the exception of apostrophes, hyphens and spaces	Type: Manual entry Character type: Alpha numerical Character length: Min characters, max charters Multiple names allowable Upper and lower case allowed MANDATORY At least 1 character must be entered	Y
8	Legal Surnames	N/A	Free text No special characters (excl apostrophes ( ' ), hypens ( - ) and spaces ( )) Multiple names allowable Upper and lower case allowed	N	N/A	Type: Manual entry Character type: Alphanumerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: Full name (record header) Mandatory: No Editable: Yes Default value: Derived from Forename Multiple names allowed Upper and lower case letters allowed	Type: Manual entry Character type: Alphanumerical Special characters: apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: Full name (record header) Mandatory: No Editable: Yes Default value: Derived from Forename Multiple names allowed Upper and lower case letters allowed	No special characters, with the exception of apostrophes, hyphens and spaces	Autopopulated from Surname Editable Free text No special characters (excl apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Multiple names allowable Upper and lower case allowed MANDATORY At least 1 character must be entered	N
9	Known As	N/A	Free text No special characters (excl apostrophes ( ' ), hypens ( - ) and spaces ( )) Multiple names allowable Upper and lower case allowed	N	N/A	Type: Manual entry Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ) and spaces ( ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ) and spaces ( ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	No special characters, with the exception of apostrophes, hyphens and spaces	Free text No special characters (excl apostrophes ( ' ), hypens ( - ) and spaces ( )) Multiple names allowable Upper and lower case allowed	N
10	Maiden Name	N/A	Free text No special characters (excl apostrophes ( ' ), hypens ( - ) and spaces ( )) Multiple names allowable Upper and lower case allowed	N	N/A	Type: Manual entry Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ) and spaces ( ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ) and spaces ( ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	No special characters, with the exception of apostrophes, hyphens and spaces	(IO) Should this be changed to "Previous Surnames"? Joanne Watson (Unlicensed) Former user (Deleted) no, the end users know it as Maiden Name so I would retain the naming. (IO) ok Free text No special characters (excl apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Multiple names allowable Upper and lower case allowed	N
PERSONAL DETAILS: Contact TISDEV-4485 - Getting issue details... STATUS / TISDEV-4486 - Getting issue details... STATUS
11	Telephone number	N/A	additional validation - limit to only numerical values / no spaces	N	N/A	Type: Manual entry Character type: Numerical Special characters: Allow ( + ) and ( - ) and spaces ( ) Character length: Min characters 0, Max characters None Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4399 - Getting issue details... STATUS	Type: Manual entry Character type: Numerical Special characters: Allow ( + ) and ( - ) and spaces ( ) Character length: Min characters 0, Max characters None Dependencies: None Mandatory: No Editable: Yes Default value: None	Only numerical values allowed No special characters, with the exception of plus, minus and spaces	Oriel telephone numbers are numbers only and upto 70 digits length. TBD: Should this be alphanumeric or allow EXT as a phrase? numerical values allow ( + ) and ( - ) allow spaces no min/max length	Y
12	Mobile number	N/A	additional validation - limit to only numerical values / no spaces	N	N/A	Type: Manual entry Character type: Numerical Special characters: Allow ( + ) and ( - ) and spaces ( ) Character length: Min characters 0, Max characters None Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4400 - Getting issue details... STATUS	Type: Manual entry Character type: Numerical Special characters: Allow ( + ) and ( - ) and spaces ( ) Character length: Min characters 0, Max characters None Dependencies: None Mandatory: No Editable: Yes Default value: None	No special characters, with the exception of plus, minus and spaces	Oriel telephone numbers are numbers only and upto 70 digits length and it has its own reason it was done this way. numerical values allow ( + ) and ( - ) allow spaces no min/max length	Y
13	Email address	N/A	must be in email format	N	N/A	Type: Manual entry Character type: Alphanumerical Email format: Hello@NHS.com Special characters: Free text - no spaces ( ) Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None Add multiple TISDEV-4290 - Getting issue details... STATUS Allow lower and upper case characters TISDEV-4401 - Getting issue details... STATUS	Type: Manual entry Character type: Alphanumerical Email format: Hello@NHS.com Special characters: Free text - no spaces ( ) Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None Add multiple Allow lower and upper case characters	Valid email format required	add multiple must be in email format (i.e. Hello@NHS.com) allow lower and upper case characters allow letters and numbers	Y
13	Address line 1	N/A	Free text no min/max length	N	N/A	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Manuel entry Free text no min/max length	Y
14	Address line 2	N/A	Free text no min/max length	N	N/A	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Manuel entry Free text no min/max length	Y
15	Address line 3	N/A	Free text no min/max length	N	N/A	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Manuel entry Free text no min/max length	Y
16	Address line 4	N/A	Free text no min/max length	N	N/A	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Manuel entry Free text no min/max length	N
17	Postcode	N/A	Free text no min/max length	N	N/A	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Alphanumerical Special characters: Free text Character length: Min characters 0, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Manuel entry Free text no min/max length	Y
PERSONAL DETAILS: Registration details << re-name TISDEV-4487 - Getting issue details... STATUS / TISDEV-4488 - Getting issue details... STATUS
18	GMC number	N/A	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 ( )	Y	Filter	Type: Manual entry Character type: Alphanumerical Special characters: Character length: Min characters 7, Max characters 7 Dependencies: Madantory if PH or GDC has not been entered Mandatory: Yes unless PH or GDC has been entered Editable: Yes Default value: None TISDEV-4402 - Getting issue details... STATUS	Type: Manual entry Character type: Alphanumerical Special characters: Character length: Min characters 7, Max characters 7 Dependencies: Madantory if PH or GDC has not been entered Mandatory: Yes unless PH or GDC has been entered Editable: Yes Default value: None	Invalid characters - no special characters, with the exception of forward slashes ( / ) GMC, GDC or PH number is required Registration value must be unique Seven characters must be entered	Joanne Watson (Unlicensed) do any of the registration numbers have special characters? Former user (Deleted) Legacy dental ones may have a '/' as you have already covered. Do we need min/max character length? Former user (Deleted) No validation please for length Former user (Deleted) Once all N/A values have been changed to 'UNKNOWN' this field should either be a valid GMC number or 'UNKNOWN,' therefore I do not believe there should be any special characters TBD: 7 characters needs to be discussed Alphanumerical field, unless "Unknown" Allow "Unknown" and "N/A" Must be unique (i.e. not duplicated in another record), unless "Unknown" no special characters apart from ( / ) Min/max character length 7 numbers (unless Unknown or N/A) Mandatory (at least 1 registration field must be entered)	Y
19	GMC status	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Drop down	N
20	GMC start date	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4403 - Getting issue details... STATUS ?????? Not done New ticket TISNEW-3556 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None	Valid date format required	TBD: How will this impact dates that have been entered from Intrepid that are incomplete? Do we need this field in TIS? DL's say no Manual entry or calendar picker Date format must be DD/MM/YYYY	N
21	GMC end date	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4403 - Getting issue details... STATUS ?????? Not done New ticket TISNEW-3556 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None	Valid date format required	TBD: How will this impact dates that have been entered from Intrepid that are incomplete? Do we need this field in TIS? DL's say no Manual entry or calendar picker Date format must be DD/MM/YYYY	N
22	GDC number	N/A	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 ( )	Y	Filter	Type: Manual entry Character type: Alphanumerical Special characters: Character length: Min characters , Max characters Dependencies: Mandatory if PH or GMC has not been entered Mandatory: Yes unless PH or GMC has been entered Editable: Yes Default value: None TISDEV-4402 - Getting issue details... STATUS	Type: Manual entry Character type: Alphanumerical Special characters: Character length: Min characters , Max characters Dependencies: Mandatory if PH or GMC has not been entered Mandatory: Yes unless PH or GMC has been entered Editable: Yes Default value: None	GMC, BGC or PH number is required No special characters, with the exception of apostrophes, hyphens and spaces Registration value must be unique	Joanne Watson (Unlicensed) do any of the registration numbers have special characters? Do we need min/max character length? Former user (Deleted) as above Manual entry Alphanumerical field, unless "Unknown" Allow "Unknown" and "N/A" Must be unique (i.e. not duplicated in another record), unless "Unknown" no special characters apart from ( / ) No min/max character length Mandatory (at least 1 registration field must be entered)	Y
23	GDC status	See: TIS UI Fields - Dropdowns	Free text	N	N/A	Type: Drop down Character type: Text Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	drop down	N
24	GDC start date	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4403 - Getting issue details... STATUS ?????? Not done New ticket TISNEW-3556 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISNEW-3556 - Getting issue details... STATUS	Valid date format required	TBD: How will this impact dates that have been entered from Intrepid that are incomplete? Do we need this field in TIS? DL's say no Manual entry or calendar picker Date format must be DD/MM/YYYY	N
25	GDC end date	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4403 - Getting issue details... STATUS ?????? Not done New ticket TISNEW-3556 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISNEW-3556 - Getting issue details... STATUS	Valid date format required	TBD: How will this impact dates that have been entered from Intrepid that are incomplete? Do we need this field in TIS? DL's say no Manual entry or calendar picker Date format must be DD/MM/YYYY	N
26	Public health number	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 ( / )	Y	Filter	Type: Manual entry Character type: Alphanumerical Special characters: Slash ( / ) Character length: Min characters none, Max characters none Dependencies: Mandatory if GDC or GMC has not been entered Mandatory: Yes unless GDC or GMC has been entered Editable: Yes Default value: None Must be unique (i.e. not duplicated in another record), unless "Unknown" TISDEV-4402 - Getting issue details... STATUS	Type: Manual entry Character type: Alphanumerical Special characters: Slash ( / ) Character length: Min characters none, Max characters none Dependencies: Mandatory if GDC or GMC has not been entered Mandatory: Yes unless GDC or GMC has been entered Editable: Yes Default value: None Must be unique (i.e. not duplicated in another record), unless "Unknown"	GDC, GMC or PHC is required No special characters, with the exception of apostrophes, hyphens and spaces Registration value must be unique Must include at least "Unknown" in the field if no known PH registration number	Joanne Watson (Unlicensed) do any of the registration numbers have special characters? Do we need min/max character length? Former user (Deleted) as above Manual entry Alphanumerical field, unless "Unknown" Allow "Unknown" and "N/A" Must be unique (i.e. not duplicated in another record), unless "Unknown" no special characters apart from ( / ) No min/max character length Mandatory (at least 1 registration field must be entered)	Y
27	College	TBC	N/A	N	TBC	Type: Derived from Programme linkage Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None	Type: Derived from Programme linkage Character type: Text Special characters: apostrophes ( ' ), hyphens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None	N/A	NEW This is yet to be added to ETL; needs to be added to the Programme membership Alistair Pringle (Unlicensed) / Joanne Watson (Unlicensed) can we confirm which ref table this should be? Royal Colleges e.g Royal College of General Practice Former user (Deleted) yes - on TIS this is called College. Suspect it needs to be tidied up by the data leads derived from Programme linkage non-editable
SENSITIVE DATA: Right to work TISDEV-4489 - Getting issue details... STATUS / TISDEV-4490 - Getting issue details... STATUS L3 label name to be changed
28	EEA resident	See: TIS UI Fields - Dropdowns	Drop down - TISDEV-4186	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4186 - Getting issue details... STATUS	N/A	Limit to drop down TISDEV-4186	Y
29	Permit to work	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4188 - Getting issue details... STATUS	N/A	Limit to drop down TISDEV-4188	Y
30	Settled	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4189 - Getting issue details... STATUS	N/A	Limit to drop down TISDEV-4189	Y
31	Visa issued	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4404 - Getting issue details... STATUS Not done TISNEW-3559 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISNEW-3559 - Getting issue details... STATUS	Valid date format required	Free text - or calendar picker date format DD/MM/YYYY	Y
32	VisaValidTo	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4404 - Getting issue details... STATUS Not done TISNEW-3559 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISNEW-3559 - Getting issue details... STATUS	Valid date format required	Free text - or calendar picker date format DD/MM/YYYY	Y
33	VisaDetails	N/A	Free text	N	N/A	Type: Manual entry Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Free text	Y
34 NEW FIELD	NI number	N/A	Free text	N	N/A	Manual entry Character type: Alphanumerical Special characters: Character length: Min characters, Max characters 9 Dependencies: None Mandatory: No Editable: Yes Default value: None	Manual entry Character type: Alphanumerical Special characters: Character length: Min characters, Max characters 9 Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Alistair Pringle (Unlicensed) Joanne Watson (Unlicensed)Former user (Deleted) - Is this an acceptable/logical area to display the National Insurance Number on TIS? i.e. within Sensitive data > Under Right to work sub-heading? On Intrepid this is displayed within Personal Details. Free text	Y
SENSITIVE DATA: Diversity TISDEV-4491 - Getting issue details... STATUS / TISDEV-4492 - Getting issue details... STATUS
35	DateOfBirth	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4405 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None	Valid date format	Free text - or calendar picker date format DD/MM/YYYY	Y
36	Age	N/A	Derived from date of birth	N	N/A	Type: Derived from date of birth Character type: Numerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None	Type: Derived from date of birth Character type: Numerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None	N/A	Derived from date of birth	N
37	Gender	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Limit to drop down	Y
38	Nationality	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Limit to drop down	Y
39	Dual nationality	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Limit to drop down	N
40	Ethnic origin	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Limit to drop down	Y
41	Marital status	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Limit to drop down	Y
42	Sexual orientation	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Sensitive - hidden Limit to drop down	Y
43	Religious belief	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Sensitive - hidden Limit to drop down	Y
44	Disability	See: TIS UI Fields - Dropdowns	Drop down TISDEV-4211	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Sensitive - hidden Limit to drop down	Y
45	DisabilityDetails	N/A	Free text	N	N/A	Type: Manual entry Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes/No Default value: None	Type: Manual entry Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes/No Default value: None	N/A	Sensitive - hidden Limit to drop down	Y
SENSITIVE DATA: Manage record function TISDEV-4493 - Getting issue details... STATUS / TISDEV-4494 - Getting issue details... STATUS
46	Role	See: TIS UI Fields - Dropdowns	Drop down	Y	Filter	Type: Drop down Character type: Text Special characters: Free text Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Free text Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Limit to drop down	Y
47	Comments	N/A	Free text	N	N/A	Type: Manual entry Character type: Numerical, Alphanumerical, Text Special characters: Free text Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type: Numerical, Alphanumerical, Text Special characters: Free text Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Free text	N
48	Status	See: TIS UI Fields - Dropdowns	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)	Y	Filter	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: 'CURRENT' Remove delete status Default to current on create journey TISDEV-4406 - Getting issue details... STATUS	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: 'CURRENT' Remove delete status TISDEV-2935 - Getting issue details... STATUS	N/A	Default to current upon creation of record Should delete still be there? What does/should it do? Joanne Watson (Unlicensed) / Alistair Pringle (Unlicensed) We need a way to remove a trainee record if incorrectly created I suppose. Former user (Deleted) this links to the conversation we still need to have with the People SMLs about how to manage trainee records - deletion included. If we set the status to delete is it a hard delete or soft? If soft leave for moment, if hard delete either make soft or remove delete option. Limit to drop down Remove DELETE status TISDEV-2935 MANDATORY Default to current on create journey	Y
49	Inactive from date	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4407 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4546 - Getting issue details... STATUS	Valid date format required	Should this be the same as Programme end date as default? No it's a manual field that allows users to set a trainee record to change to 'inactive' on a given future date. free text or calendar picker date format DD/MM/YYYY TISDEV-4546	N
50	Inactive notes	N/A	Free text	N	N/A	Type: Manual entry Character type:Text Special characters: Free text Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Manual entry Character type:Text Special characters: Free text Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Do we need both inactive notes and comments? Inactive notes are different to 'comments'. free text *	N
QUALIFICATIONS: Qualification 1 TISDEV-4495 - Getting issue details... STATUS / TISDEV-4496 - Getting issue details... STATUS
50	Qualification	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4408 - Getting issue details... STATUS	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4231 - Getting issue details... STATUS	N/A	No this should be a reference table called Qualification. Longer term work for Data Leads TBD: this should be freetext, no min/max characters? Limit to drop down - TISDEV-4231	Y
51	Qualification Type	See: TIS UI Fields - Dropdowns	Drop down	N	N/a	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4408 - Getting issue details... STATUS	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	Limit to drop down	N
52	Date attained	N/A	Free text - or calendar picker date format DD/MM/YYYY		N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None TISDEV-4409 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: No Editable: Yes Default value: None	Valid date format required	Need confirmation of the need for the entire date - month and/or year may just be needed. Month and year only needed but if the full date is known and input the month and year should (and currently is) auto populated. Okay to delete this field? TBD: Confirm what is entered via Oriel Free text - or calendar picker date format DD/MM/YYYY	Y	Y
53	Month attained	N/A	Free text - or taken from Date attained field date format DD/MM/YYYY	N	N/A	Type: Derived from date attained Character type: Text Special characters: Free Text Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None Limit to a month in the year TISDEV-4410 - Getting issue details... STATUS	Type: Derived from date attained Character type: Text Special characters: Free Text Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None Limit to a month in the year	Valid date format required	TBD: Confirm what is entered via Oriel Free text limit to a month of the year ~~date format DD/MM/YYYY~~ derived (via import/bulk) or Date attained??	N
54	Year attained	N/A	Free text - or taken from Date attained field date format DD/MM/YYYY	N	N/A	Type: Derived from date attained Character type: Numerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None Limit to 4 digit year TISDEV-4410 - Getting issue details... STATUS	Type: Derived from date attained Character type: Numerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None Limit to 4 digit year	Valid date format required	TBD: Confirm what is entered via Oriel Free text limit to 4 digit year ~~date format DD/MM/YYYY~~ derived (via import/bulk) or Date attained??	N
55	Medical School	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None	N/A	On the Medical School reference table there should be the ability to link a medical school to the country it is in. Agree TBD: should be freetext Limit to drop down	Y
56	Country of Qualification	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Derived from 'Medical School' Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes/No Default value: None	Type: Derived from 'Medical School' Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes/No Default value: None	N/A	Limit to drop down Auto-fill from 'Medical School'	Y
PROGRAMME MEMBERSHIP: Programme 1 TISDEV-4498 - Getting issue details... STATUS / TISDEV-4497 - Getting issue details... STATUS
57	Programme Name	See: TIS UI Fields - Dropdowns	Drop down (smartsearch) MANDATORY	Y	filter	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: Yes if Programme is being added Editable: Yes Default value: None TISDEV-4411 - Getting issue details... STATUS	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: Yes if Programme is being added Editable: Yes Default value: None	Programme Name is required	We need the ability to delete a Programme membership if it has been entered by mistake Limit to drop down	Y
58	Programme No.	See: TIS UI Fields - Dropdowns	Auto populated when Programme Name is selected	N	N/A	Type: Auto-populate when Programme Name is selected Character type: Alphanumerical Special characters: Character length: Min characters none, Max characters none Dependencies: Programme Name Mandatory: Yes if Programme is being added Editable: No Default value: None	Type: Auto-populate when Programme Name is selected Character type: Alphanumerical Special characters: Character length: Min characters none, Max characters none Dependencies: Programme Name Mandatory: Yes if Programme is being added Editable: No Default value: None	Programme No. is required	Limit to drop down Autofill	Y
59	Owner	See: TIS UI Fields - Dropdowns	Auto populated when Programme Name is selected	N	N/A	Type: Auto-populate when Programme Name is selected Character type:Text Special characters: Character length: Min characters none, Max characters none Dependencies: Programme name Mandatory: Yes if Programme is being added Editable: No Default value: None	Type: Auto-populate when Programme Name is selected Character type:Text Special characters: Character length: Min characters none, Max characters none Dependencies: Programme name Mandatory: Yes if Programme is being added Editable: No Default value: None	Owner is required	Limit to drop down Autofill	N
60	Programme Start date	N/A	Free text - or calendar picker date format DD/MM/YYYY MANDATORY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: Yes if Programme is being added Editable: Yes Default value: None Start date cannot be after end date TISDEV-4413 - Getting issue details... STATUS ? No TISNEW-3560 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: None Mandatory: Yes if Programme is being added Editable: Yes Default value: None Start date cannot be after end date TISNEW-3560 - Getting issue details... STATUS	Programme Start date is required	Free text - or calendar picker date format DD/MM/YYYY MANDATORY Start date cannot be after end date	N - taken from 'Curriculum 1 Start Date'
61	Programme End Date	N/A	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	N	N/A	Type: Manual entry or calendar picker or auto-populated when trainee's curriculum and Programme Start Date are selected (Programme end date is the programme start date plus the length of the curriculum with the latest end date plus any period of grace applicable) Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Auto-populated when trainee's Curriculum and Programme Start Date Mandatory: Yes if Programme is being added Editable: Yes Default value: None End date cannot be before the start date TISDEV-4413 - Getting issue details... STATUS ? No TISNEW-3560 - Getting issue details... STATUS	Type: Manual entry or calendar picker or auto-populated when trainee's curriculum and Programme Start Date are selected (Programme end date is the programme start date plus the length of the curriculum with the latest end date plus any period of grace applicable) Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Auto-populated when trainee's Curriculum and Programme Start Date Mandatory: Yes if Programme is being added Editable: Yes Default value: None End date cannot be before the start date TISNEW-3560 - Getting issue details... STATUS	Programme End Date If curriculum end date is changed, the programme end date may change, depending on how many curricula are associated (latest end date)	Note- Period of grace is related to Curriculum - outstanding conversation to be held asap on whether this should be included in calculation Auto populated when adding a trainee's curriculum (Programme end date is the programme start date plus the length of the curriculum with the latest end date plus any period of grace applicable) Editable MANDATORY End date cannot be before the start dat	Y
62	Membership Type	See: TIS UI Fields - Dropdowns	Drop down MANDATORY	Y	Filter	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if Programme is being added Editable: Yes Default value: None TISDEV-4428 - Getting issue details... STATUS	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if Programme is being added Editable: Yes Default value: None	Membership Type is required	Limit to drop down MANDATORY	N
63	Rotation	See: TIS UI Fields - Dropdowns & Programmes - Rotations - Solution Design, Field Validation & Scenarios	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters none, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: 'No value provided'	Type: Drop down Character type: Text Special characters: Character length: Min characters none, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: 'No value provided'	N/A	Limit to drop down	Y
64	Leaving destination	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Character type: Text Special characters: Character length: Min characters none, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: 'No value provided'	Type: Drop down Character type: Text Special characters: Character length: Min characters none, Max characters none Dependencies: None Mandatory: No Editable: Yes Default value: 'No value provided'	N/A	Limit to drop down TBD at a later time - possibly needs overhaul rename to leaving reason? drop down values review	N
65	Training number	N/A	Autogenerated ~~Editable~~ Readonly textbox (allowing special characters ( / ) in the autogeneration	N	N/A	Type: System generated ~~or manual entry~~ Character type: Alphanumerical Special characters: Slash ( / ) Character length: Min characters none, Max characters Dependencies: All mandatory fields that are required to create a programme membership All mandatory fields that are required to create a curriculum membership Valid GMC Number to be present ( not UNKNOWN or N/A) Programme associated to a Local Office, so that a suffix can be assigned in the calculation Suffix of C or D to denote NTN or DRN respectively. Not applicable to GDC and PH number ~~Mandatory: No~~ ~~Editable: Yes~~ Default value: None TISNEW-2292 - Getting issue details... STATUS	Type: System generated ~~or manual entry~~ Character type: Alphanumerical Special characters: Slash ( / ) Character length: Min characters none, Max characters Dependencies: All mandatory fields that are required to create a programme membership All mandatory fields that are required to create a curriculum membership Valid GMC Number to be present ( not UNKNOWN or N/A) Programme associated to a Local Office, so that a suffix can be assigned in the calculation Suffix of C or D to denote NTN or DRN respectively. Not applicable to GDC and PH number ~~Mandatory: No~~ ~~Editable: Yes~~ Default value: None TISNEW-2292 - Getting issue details... STATUS	AR 30/07/2018: Bulk Error Messages: NTN already exists against a different person on TIS. NTN entered in duplicates on the template against different persons. Cannot have an NTN without specifying the Programme name and Programme number on the template.	Autogenerated Editable + manual entry Free text (allowing special characters ( / )) Allow blank Format may be changing but TBC AR 30/07/2018: Alistair Pringle (Unlicensed): Can you check the BE validation rules and any error messages you'd expect for Bulk Upload. I've listed some but there may be others that we would need to consider.	AR 30/07/2018: Y TISNEW-454 - Getting issue details... STATUS
PROGRAMME MEMBERSHIP: Programme 1 > Curricula 1 TISDEV-4500 - Getting issue details... STATUS / TISDEV-4499 - Getting issue details... STATUS
66	Curriculum	See: TIS UI Fields - Dropdowns	Drop down Taken from the Curriculum/Curricula attached to the Programme the trainee is following MANDATORY	N	N/A	Type: Drop down- taken from the um/Curricula attached to the Programme the trainee is following Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: Yes if curricula is added Editable: Yes Default value: None	Type: Drop down- taken from the um/Curricula attached to the Programme the trainee is following Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: Yes if curricula is added Editable: Yes Default value: None	N/A	Drop down Taken from the um/Curricula attached to the Programme the trainee is following	Y - Curriculum 1, 2 & 3.
67	Curriculum Start Date	N/A	Default to the Programme start date but allow for editing via a calendar picker or manual update	N	N/A	Type: Auto-populate with Programme Start Date or manual entry or calendar picker Character type: Numerical Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Auto-populate with Programme Start Date Mandatory: Yes Editable: Yes Default value: Programme Start Date Must be equal to or after the Programme start date Must be before the Curriculum end date	Type: Auto-populate with Programme Start Date or manual entry or calendar picker Character type: Numerical Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Auto-populate with Programme Start Date Mandatory: Yes Editable: Yes Default value: Programme Start Date Must be equal to or after the Programme start date Must be before the Curriculum end date	Curriculum Start Date is required Valid date format required Must be equal to or before the Programme start date Must be before the Curriculum end date	Default to the Programme start date but allow for editing via a calendar picker or manual update Former user (Deleted) (AR: defaulting first Curriculum Start date to be Programme Start date is OK, but not for the additional curriculum I supose?) Date format DD/MM/YYYY Must be equal to or after the Programme start date Must be before the Curriculum end date	Y - Curriculum 1,2 & 3 Start Dates. Programme Start Date is taken from Curriculum 1 start date.
68	Curriculum End Date	N/A	Auto populated after the Curriculum start date has been entered - will be Curriculum start date plus the duration of the curriculum Editable Date format DD/MM/YYYY	N	N/A	Type: Auto-populate when Curriculum Start Date has been selected - Curriculum start date plus the duration of the curriculum Date format: DD/MM/YYYY Character type: Numerical Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Curriculum Start Date for auto-populate Mandatory: Yes Editable: Yes Default value: Curriculum Start Date	Type: Auto-populate when Curriculum Start Date has been selected - Curriculum start date plus the duration of the curriculum Date format: DD/MM/YYYY Character type: Numerical Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Curriculum Start Date for auto-populate Mandatory: Yes Editable: Yes Default value: Curriculum Start Date	Curriculum End Date is required Valid date format required	NB: if curriculum end date is changed, the programme end date may change, depending on how many curricula are associated (latest end date) 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 Must be after the Curriculum start date	Y - Curriculum 1,2 & 3 End Dates.
69	NEW: Curriculum sub-type TISDEV-3650 - Getting issue details... STATUS	See: TIS UI Fields - Dropdowns	N/A			Type: Drop down / Auto-generated from Curriculum selected Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Curriculum (auto-population) Mandatory: No Editable: No Default value: None	Type: Drop down / Auto-generated from Curriculum selected Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Curriculum (auto-population) Mandatory: No Editable: No Default value: None	N/A	Limit to drop down values Autogenerated from Curriculum selected Non-editable	N
70	NEW: Curriculum specialty TISDEV-3650 - Getting issue details... STATUS	See: TIS UI Fields - Dropdowns	N/A			Type: Drop down / Auto-generated from Curriculum selected Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None	Type: Drop down / Auto-generated from Curriculum selected Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: No Default value: None	N/A	Limit to drop down values Autogenerated from Curriculum selected Non-editable	N
PLACEMENTS: Post TISDEV-4502 - Getting issue details... STATUS / TISDEV-4501 - Getting issue details... STATUS
69	Post Number	N/A (Refer to Post list)	Drop down or smart search limit to Posts within the same Programme as Trainee	Y	filter	Type: Drop down or smart search Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: Yes Editable: Yes Default value: None TISDEV-4414 - Getting issue details... STATUS	Type: Drop down or smart search Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: Yes Editable: Yes Default value: None	Post Number is required	Confirm that this second bullet should be removed? Drop down or smart search ~~limit to Posts within the same Programme as Trainee~~ MANDATORY	N
70	Main Placement Specialty	See: TIS UI Fields - Dropdowns	Drop down	Y	filter	Type: Auto-populate from National Post Number Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Auto-populate from National Post Number Mandatory: Yes Editable: Yes Default value: None Limited to speciality within a Post	Type: Auto-populate from National Post Number Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Auto-populate from National Post Number Mandatory: Yes Editable: Yes Default value: None Limited to speciality within a Post	Placement Speciality is required Warn user where there is already a Trainee in the selected post Warn user where there is a future planned placement for a Trainee in the selected post	Feedback was given that specialities should be limited to Post specialties, but decided that this can be overidden New requirement: add all specialties to a Post (for e.g.) Autopopulate specialty from Post Editable Limited to specialty within a Post MANDATORY	N
71	Other Placement specialties	See: TIS UI Fields - Dropdowns	Drop down	N	N/A	Type: Drop down Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: Blank by default Limited to speciality within a Post	Type: Drop down Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: Blank by default Limited to speciality within a Post	N/A	Not previously specified blank by default Limited to specialty within a Post	N
72	Site	See: TIS UI Fields - Dropdowns	Drop down (taken from 'site' in the post record) editable	Y	Filter	Type: Auto-populate from National Post Number Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Auto-populate from National Post Number Mandatory: Yes Editable: Yes Default value: None	Type: Auto-populate from National Post Number Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Auto-populate from National Post Number Mandatory: Yes Editable: Yes Default value: None	Site is required	Autopopulate site from Post Editable Limited to site within a Post MANDATORY	N
73	Local post number	N/A	Read only	N	N/A	Type: Auto-populate from National Post Number Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: National Post Number Mandatory: No Editable: No Default value: None	Type: Auto-populate from National Post Number Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: National Post Number Mandatory: No Editable: No Default value: None	N/A	Read only This should be read only as it is derived from Post	N
74	Grade	See: TIS UI Fields - Dropdowns	Drop down (taken from 'other grades' in the post record) Autogenerated from Post record Editable from full grade list	Y	filter	Type: Auto-populate from National Post Number or drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: National Post Number Mandatory: Yes Editable: Yes Default value: None Limited to grades within a Post	Type: Auto-populate from National Post Number or drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: National Post Number Mandatory: Yes Editable: Yes Default value: None Limited to grades within a Post	Grade is required	Autopopulate grade from Post Editable Limited to grades within a Post MANDATORY	N
75	Owner		read only derived from Post	Y		Type: Auto-populate from National Post Number Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: National Post Number Mandatory: No Editable: No Default value: None	Type: Auto-populate from National Post Number Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: National Post Number Mandatory: No Editable: No Default value: None	N/A	read only derived from Post This should be read only as it is derived from Post	N/A
PLACEMENT: Location << needs to be renamed to "Period" TISDEV-4417 - Getting issue details... STATUS / TISDEV-4503 - Getting issue details... STATUS / TISDEV-4504 - Getting issue details... STATUS
76	Date from	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Mandatory: Yes Editable: Yes Default value: None TISDEV-4416 - Getting issue details... STATUS ? TISNEW-3561 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Mandatory: Yes Editable: Yes Default value: None TISNEW-3561 - Getting issue details... STATUS	Date from required Valid date required Start date must be before end date	Can we also limit this to be contained by Programme duration? If so, this should be a warning Free text - or calendar picker date format DD/MM/YYYY start date must be before end date MANDATORY	N
77	Date to	N/A	Free text - or calendar picker date format DD/MM/YYYY	N	N/A	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Mandatory: Yes Editable: Yes Default value: None TISDEV-4416 - Getting issue details... STATUS ? TISNEW-3561 - Getting issue details... STATUS	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: Slash ( / ) Character length: Min characters 8, Max characters 8 Dependencies: Mandatory: Yes Editable: Yes Default value: None TISNEW-3561 - Getting issue details... STATUS	Date to is required Valid date required Start date must be before end date	Can we also limit this to be contained by Programme duration? If so, this should be a warning Free text - or calendar picker date format DD/MM/YYYY start date must be before end date MANDATORY	N
PLACEMENT: Placement TISDEV-4505 - Getting issue details... STATUS / TISDEV-4506 - Getting issue details... STATUS
78	Placement Type	See: TIS UI Fields - Dropdowns	Drop down	Y	Filter	Type: Drop down Character type: Text Special characters: Hyphen ( - ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: None	Type: Drop down Character type: Text Special characters: Hyphen ( - ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: None	Placement Type is required	Limit to drop down MANDATORY	N
79	Training description << moved to Placements: Post (TISDEV-4794)	N/A	Free text	N/A	N/A	N/A	N/A	N/A	Not previously specified - why was this included? Some local offices use this to describe in more detail the contents of the post e.g. a Trauma and Orthopaedics post can deliver foot and ankle surgery training, another can deliver hand and wrist training and another spinal surgery training etc. Important when managing placements. Non-editable Derived from Post	N
80	WTE	N/A	Numerical equal to, or less than 1		N/A	Type: Manual entry Character type: Numerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: Only values between 0 and 1 allowed To 2 decimal places TISDEV-4422 - Getting issue details... STATUS	Type: Manual entry Character type: Numerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: Only values between 0 and 1 allowed To 2 decimal places	WTE is required Numerical values only Value must be equal to, or less than 1	Numerical equal to, or less than 1 To 2 decimal places MANDATORY	N
81	Status	TIS UI Fields - Dropdowns	autodetermined based on dates read only	N	N/A	Type: Auto-determined based on dates Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Date from and Date to Mandatory: No Editable: No Default value: None	Type: Auto-determined based on dates Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Date from and Date to Mandatory: No Editable: No Default value: None	N/A	autodetermined based on dates read only	N
82	Educational Supervisor	N/A	drop down	N	N/A	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None Add multiple Restrict to people with the role containing “Educational Supervisor”	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None Add multiple Restrict to people with the role containing “Educational Supervisor”	N/A	Future requirements to be discussed: Roles need a tidy up and consolidation so that educational / clinical supervisors can be distinguished Restrict to supervisors who are currently approved Drop down Add multiple Restrict to people with the role containing “Educational Supervisor”	N
83	Clinical Supervisor	N/A	drop down	N	N/A	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None Add multiple Restrict to people with the role containing “Clinical Supervisor”	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: None Mandatory: No Editable: Yes Default value: None Add multiple Restrict to people with the role containing “Clinical Supervisor”	N/A	Future requirements to be discussed: Roles need a tidy up and consolidation so that educational / clinical supervisors can be distinguished Restrict to supervisors who are currently approved Drop down Add multiple Restrict to people with the role containing “Clinical Supervisor”	N
ASSESSMENT TISDEV-4507 - Getting issue details... STATUS / TISDEV-4508 - Getting issue details... STATUS
84	Curriculum assessed	N/A	Read only - derived from assessment	N	N/A	Type: Derived from assessment Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	Type: Derived from assessment Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	N/A	Read only - derived from assessment	N
85	Review date	N/A	Read only - derived from assessment	N	N/A	Type: Derived from assessment Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	Type: Derived from assessment Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	N/A	Read only - derived from assessment	N
86	Outcome	N/A	Read only - derived from assessment	N	N/A	Type: Derived from assessment Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	Type: Derived from assessment Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	N/A	Read only - derived from assessment	N
85	Period assessed from	N/A	Read only - derived from assessment	N	N/A	Type: Derived from assessment Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	Type: Derived from assessment Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	N/A	Read only - derived from assessment	N
86	Period assessed to	N/A	Read only - derived from assessment	N	N/A	Type: Derived from assessment Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	Type: Derived from assessment Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value: None	N/A	Read only - derived from assessment	N
ASSOCIATIONS (trainer records only) POST MVP
87	Programme Name		smart search drop down editable			Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None			N
88	Programme Number		smart search drop down editable			Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None			N
89	Trainee Name		autopopulated derived from educational supervisor assignment or clinical supervisor assignment click through to Trainee record MANDATORY if populated			Type: Derived from educational supervisor assignment or clinical supervisor assignment Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value: None	Type: Derived from educational supervisor assignment or clinical supervisor assignment Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value: None	Trainee Name is required		N
90	Site Name		smart search drop down editable			Type: Smart search drop down Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value:	Type: Smart search drop down Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value:			N
91	Site Number		smart search drop down editable			Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None			N
92	Trust Name		smart search drop down editable			Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None			N
92	Trust Number		smart search drop down editable			Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None			N
93	Education Group		smart search drop down editable			Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None	Type: Smart search drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value: None			N
94	Placement - Post Number		autopopulated derived from placements MANDATORY if populated			Type: Derived from placements Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value:	Type: Derived from placements Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value:	Placement - Post Number is required		N
95	Placement - Trainee Name		autopopulated derived from placements MANDATORY if populated			Type: Derived from placements Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value:	Type: Derived from placements Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value:	Placement - Trainee Name is required		N
96	Placement - Site		autopopulated derived from placements MANDATORY if populated			Type: Derived from placements Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value:	Type: Derived from placements Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value:	Placement - Site is required		N
97	Placement - Start Date		autopopulated derived from placements MANDATORY if populated			Type: Derived from placements Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value:	Type: Derived from placements Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value:	Placement - Start Date is required		N
98	Placement - End Date		autopopulated derived from placements MANDATORY if populated			Type: Derived from placements Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value: Mado	Type: Derived from placements Character type: Numerical Special characters: Slash ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes if populated Editable: Yes/No Default value: Mado	Placement - End Date is required		N
Associated Trainers & Schools (as part of the Site Reference Table - this is an additional field) POST MVP
N/A	Trainer Name		autopopulated from "Associations" (as detailed above) list ability to click through to trainer record on click ability to remove trainer from list			Type: Auto-populated from "Associations" Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value: None List Ability to click through to trainer record on click Ability to remove trainer from list	Type: Auto-populated from "Associations" Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value: None List Ability to click through to trainer record on click Ability to remove trainer from list			N

Browser not supported