People - Field Validation | NEW

• Editable via Forename, Surname field changes

• 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: No
• 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

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

• System generated field - Automated upon creation of record

• Read only

• System generated field - Automated upon creation of record 

• 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

Discussion to be held about this field and whether it remains in TIS UI

• System generated field - Automated upon creation of record 

• drop down

• Type: drop down
• 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: 

• Type: drop down
• Mandatory: no
• Editable: yes
• Default value: blank

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   )
• Multiple names allowable
• Upper and lower case allowed
• MANDATORY

• Sort

• 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

• 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

This field 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

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed

• 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

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

• Free text
• No special characters (excl spaces (   )) 
• Multiple initials allowable
• Upper case only

• wwType: derived
• Character type: numerical, alphanumerical, text, special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop)
• Character length: min/max
• Dependencies: derived from first character of Forename(s)
• Mandatory: yes/no
• Editable: yes/no
• Default value: XXX
• Special characters: apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )
• Anything else the doesn’t fall into the above, included as a bullet point e.g. add multiple, add all, remove all
• Error message text: XXX

• 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 

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 

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed
• MANDATORY

• 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

An entry must be made to create or update the record

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

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case 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

• 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

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed

• Type: Manual entry
• Character type: Text
• Special characters: apostrophes ( ' ), hyphens    ( - ) and spaces (   )
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

• Free text 
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   )) 
• Multiple names allowable 
• Upper and lower case allowed

• Free text
• No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
• Multiple names allowable
• Upper and lower case allowed

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

(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

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

• Type: Manual entry 
• Character type: Numerical
• Special characters: Allow ( + ) and ( - ) and spaces (   )
• Character length: Min characters 0, Max characters None
• Dependencies: 
• Mandatory: No
• Editable: Yes
• Default value: 

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 

Mobile number

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

• numerical values
• allow ( + ) and ( - )
• allow spaces
• no min/max length

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: 
• Mandatory: No
• Editable: Yes
• Default value: 

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 

Email address

• must be in email format

• Type: Manual entry
• Character type: Alphanumerical
• Special characters: Free text - no spaces (   )
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 
• Add multiple
• Must be in email format (i.e. Hello@NHS.com) 
• Allow lower and upper case characters

• add multiple
• must be in email format (i.e. Hello@NHS.com) 
• allow lower and upper case characters
• allow letters and numbers

Address line 1

• Free text
• no min/max length

• Type: Manual entry
• Character type: Alphanumerical
• Special characters: Free text
• Character length: Min characters 0, Max characters none
• Dependencies:
• Mandatory: No
• Editable: Yes
• Default value: 

• Manuel entry
• Free text 
• no min/max length 

Address line 2

• Free text
• no min/max length

• Type: Manual entry
• Character type: Alphanumerical
• Special characters: Free text
• Character length: Min characters 0, Max characters none
• Dependencies:
• Mandatory: No
• Editable: Yes
• Default value: 

• Manuel entry
• Free text 
• no min/max length 

Address line 3

• Free text
• no min/max length

• Type: Manual entry
• Character type: Alphanumerical
• Special characters: Free text
• Character length: Min characters 0, Max characters none
• Dependencies:
• Mandatory: No
• Editable: Yes
• Default value: 

• Manuel entry
• Free text 
• no min/max length 

Address line 4

• Free text
• no min/max length

• Type: Manual entry
• Character type: Alphanumerical
• Special characters: Free text
• Character length: Min characters 0, Max characters none
• Dependencies:
• Mandatory: No
• Editable: Yes
• Default value: 

• Manuel entry
• Free text 
• no min/max length 

Postcode

• Free text
• no min/max length

• Type: Manual entry
• Character type: Alphanumerical
• Special characters: Free text
• Character length: Min characters 0, Max characters none
• Dependencies:
• Mandatory: No
• Editable: Yes
• Default value: 

• Manuel entry
• Free text 
• no min/max length 

GMC number

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

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

Invalid characters - no special characters, with the exception of forward slashes ( / )

At least one registration number entry must be made to create or update the record

Registration value must be unique

Seven characters must be entered

GMC status

• Drop down

• Drop down

• Type: Drop down
• Character type: Text
• Special characters: Hyphen ( / )
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

• Drop down 

• Free text - or calendar picker
• date format DD/MM/YYYY

• Manual entry or calendar picker
• Date format must be DD/MM/YYYY

TISDEV-4403 - Getting issue details... STATUS

• Type: Manual entry or calendar picker 
• Character type: Numerical
• Date Format: DD/MM/YYYY
• Special characters: ( / )
• Character length: Min characters 9, Max characters 9
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

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

GMC end date

• Free text - or calendar picker
• date format DD/MM/YYYY

• Manual entry or calendar picker
• Date format must be DD/MM/YYYY

TISDEV-4403 - Getting issue details... STATUS

• Type: Manual entry or calendar picker 
• Character type: Numerical
• Date Format: DD/MM/YYYY
• Special characters: ( / )
• Character length: Min characters 9, Max characters 9
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

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

GDC number

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

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

At least one registration number entry must be made to create or update the record

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)

GDC status

• Free text

• drop down

• Type: Drop down
• Character type: Text
• Special characters: Hyphen ( / )
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

• drop down

• Free text - or calendar picker
• date format DD/MM/YYYY

• Type: Manual entry or calendar picker 
• Character type: Numerical
• Date Format: DD/MM/YYYY
• Special characters: ( / )
• Character length: Min characters 9, Max characters 9
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

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

GDC end date

• Free text - or calendar picker
• date format DD/MM/YYYY

• Manual entry or calendar picker
• Date format must be DD/MM/YYYY

TISDEV-4403 - Getting issue details... STATUS

• Type: Manual entry or calendar picker 
• Character type: Numerical
• Date Format: DD/MM/YYYY
• Special characters: ( / )
• Character length: Min characters 9, Max characters 9
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

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

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

• Filter

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

• Type: Manual entry 
• Character type: Alphanumerical
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: Mandatory if GDC or GMC has not been entered 
• Mandatory: Yes unless GDC or GMC has been entered 
• Editable: Yes
• Default value: 

At least one registration number entry must be made to create or update the record

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)

• N/A

• derived from Programme linkage
• non-editable

• Type: Derived from Programme linkage
• Character type: Text
• Special characters: apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: No
• Default value: 

• Drop down - TISDEV-4186

• Limit to drop down 
•  TISDEV-4186

• Drop down

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

TISDEV-4188 - Getting issue details... STATUS

• Limit to drop down
• TISDEV-4188

Settled

• Drop down

• Limit to drop down
• TISDEV-4189

31

• Free text - or calendar picker
• date format DD/MM/YYYY

No change

TISDEV-4404 - Getting issue details... STATUS

• Type: Manual entry or calendar picker 
• Character type: Numerical
• Date Format: DD/MM/YYYY
• Special characters: ( / )
• Character length: Min characters 9, Max characters 9
• Dependencies:
• Mandatory: Yes/No
• Editable: Yes
• Default value:

• Free text - or calendar picker 
• date format DD/MM/YYYY 

32

VisaValidTo

• Free text - or calendar picker
• date format DD/MM/YYYY

No change

TISDEV-4404 - Getting issue details... STATUS

• Type: Manual entry or calendar picker 
• Character type: Numerical
• Date Format: DD/MM/YYYY
• Special characters: ( / )
• Character length: Min characters 9, Max characters 9
• Dependencies:
• Mandatory: Yes/No
• Editable: Yes
• Default value:

• Free text - or calendar picker 
• date format DD/MM/YYYY 

VisaDetails

• Free text

• Type: Manual entry
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

• Free text 

34

NEW FIELD

• Free text

• Free text

• Manual entry

• Character type: Alphanumerical
• Special characters: 
• Character length: Min characters, Max characters 9 
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

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

35

DateOfBirth

• Free text - or calendar picker
• date format DD/MM/YYYY

No change

TISDEV-4405 - Getting issue details... STATUS

• Type: Manual entry or calendar picker 

• Character type: Numerical
• Date Format: DD/MM/YYYY
• Special characters: ( / )
• Character length: Min characters 9, Max characters 9
• Dependencies:
• Mandatory: Yes/No
• Editable: Yes
• Default value:

• Free text - or calendar picker 
• date format DD/MM/YYYY 

• Derived from date of birth

• Type: Derived from date of birth 
• Character type: Numerical
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: No
• Default value: 

• Derived from date of birth 

Gender

• Drop down

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

• Limit to drop down 

• Drop down

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

• Limit to drop down 

• Drop down

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

• Limit to drop down 

Ethnic origin

• Drop down

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

• Limit to drop down 

• Drop down

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

• Limit to drop down 

• Drop down

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

Sensitive - hidden

• Limit to drop down 

• Drop down

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

Sensitive - hidden

• Limit to drop down 

• Drop down
• TISDEV-4211

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value:

Sensitive - hidden

• Limit to drop down 

• Free text

• Type: Manual entry 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: 

Sensitive - hidden

• Limit to drop down 

• Drop down

• Filter

• Type: Drop down
• Character type: Text 
• Special characters: Free text 
• Character length: Min characters, Max characters
• Dependencies:
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

• Limit to drop down 

• Free text

• Type: Manual entry
• Character type: Numerical, Alphanumerical, Text
• Special characters: Free text
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: Yes
• Default value: 

• Free text  

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

• Filter

• Limit to drop down
• MANDATORY
• 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 

• Free text - or calendar picker
• date format DD/MM/YYYY

No change

TISDEV-4407 - Getting issue details... STATUS

• 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

• Free text

• Type: Manual entry
• Character type:Text
• Special characters: Free text 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: No
• Editable: Yes
• Default value: 

• Do we need both inactive notes and comments?
  Inactive notes are different to 'comments'.
• free text * 

• Drop down

• limit to drop down  TISDEV-4408 - Getting issue details... STATUS

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

• Drop down

• limit to drop down  TISDEV-4408 - Getting issue details... STATUS

• Type: Drop down 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: No
• Editable: Yes
• Default value: 

• Limit to drop down 

• Free text - or calendar picker
• date format DD/MM/YYYY

No change

TISDEV-4409 - Getting issue details... STATUS

• Type: Manual entry or calendar picker 
• Character type: Numerical
• Date Format: DD/MM/YYYY
• Special characters: ( / )
• Character length: Min characters 9, Max characters 9
• Dependencies:
• Mandatory: Yes/No
• Editable: Yes
• Default value:

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 

• Free text - or taken from Date attained field
• date format DD/MM/YYYY

• TISDEV-4410 - Getting issue details... STATUS
• Free text
• limit to a month of the year
• date format DD/MM/YYYY  
• derived (via import/bulk) or Date attained??

• Type: Derived from date attained 
• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: No
• Default value: 
• Limit to a month in the year 

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

• Free text - or taken from Date attained field
• date format DD/MM/YYYY

• TISDEV-4410 - Getting issue details... STATUS
• Free text
• limit to 4 digit year
• date format DD/MM/YYYY
• derived (via import/bulk) or Date attained??

• Type: Derived from date attained 
• Character type: Numerical
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: Yes/No
• Editable: No
• Default value: 
• Limit to 4 digit year  

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

• Drop down

• Type: Drop down

• Character type: Text
• Special characters: 
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: No
• Editable: Yes
• Default value: 

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 

• Drop down

• Type: Derived from 'Medical School'

• Character type: Text
• Special characters:
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: No
• Editable: Yes/No
• Default value: 

• Limit to drop down 
• Auto-fill from 'Medical School'

• Drop down (smartsearch)
• MANDATORY

• filter

No change 

TISDEV-4411 - Getting issue details... STATUS

• Limit to drop down 

• Type: Drop down 
• Character type: Text
• Special characters:
• Character length: Min characters, Max characters
• Dependencies: 
• Mandatory: No
• Editable: Yes
• Default value: 

We need the ability to delete a Programme membership if it has been entered by mistake

• Limit to drop down 

• Auto populated when Programme Name is selected

• Limit to drop down  Autofill

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Limit to drop down  Autofill

• Auto populated when Programme Name is selected

• Limit to drop down  Autofill

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Limit to drop down  Autofill

• Free text - or calendar picker
• date format DD/MM/YYYY
• MANDATORY

No change

TISDEV-4413 - Getting issue details... STATUS

• Free text - or calendar picker 
• date format DD/MM/YYYY 
• MANDATORY
• Start date cannot be after end date

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Free text - or calendar picker 
• date format DD/MM/YYYY 
• MANDATORY
• Start date cannot be after end date

• 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

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

TISDEV-4413 - Getting issue details... STATUS

• Editable 
• MANDATORY 
• End date cannot be before the start date

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

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

An entry must be made to create or update the record

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

• Drop down
• MANDATORY

• Filter

No change

TISDEV-4428 - Getting issue details... STATUS

• Limit to drop down 
• MANDATORY 

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Limit to drop down 
• MANDATORY 

See: TIS UI Fields - Dropdowns &

Programmes - Rotations - Solution Design, Field Validation & Scenarios

• Drop down

• Limit to drop down 

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Limit to drop down 

• Drop down

• Limit to drop down 

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Limit to drop down 

TBD at a later time - possibly needs overhaul

• rename to leaving reason?
• drop down values review

• Autogenerated
• Editable
• Free text (allowing special characters ( / ))

• Autogenerated
• Editable + manual entry
• Free text (allowing special characters ( / ))
• Allow blank

• Autogenerated
• Editable + manual entry
• Free text (allowing special characters ( / ))
• Allow blank

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Autogenerated
• Editable + manual entry
• Free text (allowing special characters ( / ))
• Allow blank

Format may be changing but TBC

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

• Drop down 
• Taken from the um/Curricula attached to the Programme the trainee is following 

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Drop down 
• Taken from the um/Curricula attached to the Programme the trainee is following 

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

• Default to the Programme start date but allow for editing via a calendar picker or manual update 
• Date format DD/MM/YYYY 
• Must be equal to or after 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 
• Date format DD/MM/YYYY 
• Must be equal to or after the Programme start date
• Must be before the Curriculum end date

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

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

• 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

• 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

• 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

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

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

NEW: Curriculum sub-type

TISDEV-3650 - Getting issue details... STATUS

• Limit to drop down values
• Autogenerated from Curriculum selected
• Non-editable

• Limit to drop down values
• Autogenerated from Curriculum selected
• Non-editable

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Limit to drop down values
• Autogenerated from Curriculum selected
• Non-editable

NEW: Curriculum specialty

TISDEV-3650 - Getting issue details... STATUS

• limit to drop down values
• Autogenerated from Curriculum selected
• Non-editable

• Limit to drop down values
• Autogenerated from Curriculum selected
• Non-editable

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Limit to drop down values
• Autogenerated from Curriculum selected
• Non-editable

• Drop down or smart search
• limit to Posts within the same Programme as Trainee

• filter

• Drop down or smart search
• limit to Posts within the same Programme as Trainee  TISDEV-4414 - Getting issue details... STATUS
• MANDATORY

• Drop down or smart search 
• limit to Posts within the same Programme as Trainee 
• MANDATORY

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

Confirm that this second bullet should be removed?

• Drop down or smart search 
• limit to Posts within the same Programme as Trainee 
• MANDATORY

• Drop down

• filter

• Auto-populate specialty from Post

• Editable
• Limited to specialty within a Post
• MANDATORY

• Autopopulate specialty from Post

• Editable
• Limited to specialty within a Post
• MANDATORY

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

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

• Drop down

• blank by default

• Limited to specialty within a Post

• blank by default

• Limited to specialty within a Post

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

Not previously specified

• blank by default

• Limited to specialty within a Post

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

• Filter

• Autopopulate site from Post
• Editable
• Limited to site within a Post
• MANDATORY

• Autopopulate site from Post
• Editable
• Limited to site within a Post
• MANDATORY

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Autopopulate site from Post
• Editable
• Limited to site within a Post
• MANDATORY

• Read only

No change

• Read only

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Read only

• Drop down (taken from 'other grades' in the post record)
• Autogenerated from Post record
• Editable from full grade list

• filter

• Autopopulate grade from Post
• Editable
• Limited to grades within a Post
• MANDATORY

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Autopopulate grade from Post
• Editable
• Limited to grades within a Post
• MANDATORY

• read only
• derived from Post

No change

• read only
• derived from Post

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• read only
• derived from Post

• Free text - or calendar picker
• date format DD/MM/YYYY

No change

TISDEV-4416 - Getting issue details... STATUS

• start date must be before end date
• MANDATORY

• Free text - or calendar picker 
• date format DD/MM/YYYY 
• start date must be before end date
• MANDATORY

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

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

• Free text - or calendar picker
• date format DD/MM/YYYY

No change 

TISDEV-4416 - Getting issue details... STATUS

• start date must be before end date
• MANDATORY

• Free text - or calendar picker 
• date format DD/MM/YYYY 
• start date must be before end date
• MANDATORY

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

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

• Drop down

• Filter

• MANDATORY

• Limit to drop down 
• MANDATORY

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• Limit to drop down 
• MANDATORY

• Free text

• Non-editable

• Derived from Post

• Non-editable

• Derived from Post

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

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

• Numerical
• equal to, or less than 1

• Numerical
• equal to, or less than 1  TISDEV-4422 - Getting issue details... STATUS
• To 2 decimal places
• MANDATORY

• Numerical 
• equal to, or less than 1 
• To 2 decimal places
• MANDATORY

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

Numerical values only

Value must be equal to, or less than 1

• Numerical 
• equal to, or less than 1 
• To 2 decimal places
• MANDATORY

• autodetermined based on dates
• read only

No change

• autodetermined based on dates 
• read only 

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

• autodetermined based on dates 
• read only 

• drop down

• Drop down

• Add multiple

• Restrict to people with the role containing “Educational Supervisor”

• Drop down

• Add multiple

• Restrict to people with the role containing “Educational Supervisor”

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

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”

• drop down

• Drop down

• Add multiple

• Restrict to people with the role containing “Clinical Supervisor”

• Drop down

• Add multiple

• Restrict to people with the role containing “Clinical Supervisor”

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

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”

Read only - derived from assessment 

• Type: Drop down / Manual entry / Auto generated / System generated
• Character type: Numerical, Alphanumerical, Text
• Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, full stop)/Free text
• Character length: Min characters, Max characters
• Dependencies: XXX
• Mandatory: Yes/No
• Editable: Yes/No
• Default value: XXX

Read only - derived from assessment 

Read only - derived from assessment 

• smart search drop down

• editable

• smart search drop down

• editable

• autopopulated
• derived from educational supervisor assignment or clinical supervisor assignment
• click through to Trainee record 
• MANDATORY if populated 

• smart search drop down

• editable

• smart search drop down

• editable

• smart search drop down

• editable

• smart search drop down

• editable

• smart search drop down
• editable

• autopopulated
• derived from placements
• MANDATORY if populated 

• autopopulated
• derived from placements
• MANDATORY if populated 

• autopopulated
• derived from placements
• MANDATORY if populated 

• autopopulated
• derived from placements
• MANDATORY if populated 

• autopopulated
• derived from placements
• MANDATORY if populated 

• autopopulated from "Associations" (as detailed above)
• list
• ability to click through to trainer record on click
• ability to remove trainer from list