Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

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 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4429

...

Field SequenceField name (V10)Reference table

Current FE Validation & Rules

List Page?

(Y / N)

List Page Rules (sort/filter)Proposed FE Validation & RulesProposed BE Validation & RulesError MessagesNotesBE Validation applicable to Bulk People Upload (Y/N)Delete (Y / N)
HEADER 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4478
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4479
1Full NameN/A
  • Editable via Forename, Surname field changes
NN/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
2PersonIDNA
  • System generated field - Automated upon creation of record
  • Read only
YN/A
  • Type: System generated (tick)
  • 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 (tick)
  • 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 (tick)
N
PERSONAL DETAILS: Personal 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4480
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4516

3TitleSee: TIS UI Fields - Dropdowns
  • drop down
NN/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
4ForenameN/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 (tick)
  • Character type: alphanumerical
  • Character length: min 1/ no max
  • Dependencies: Full name (record header)
  • Mandatory: yes (tick)
  • Editable: yes
  • Default value: blank
  • Special characters: 

    apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )

  • Multiple names allowed
  • Upper and lower case letters allowed
Y
5Legal ForenamesN/A
  • Free text
  • No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
  • Multiple names allowable
  • Upper and lower case allowed
NN/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 (tick)
  • 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
6InitialsN/A
  • Free text
  • No special characters (excl spaces (   )) 
  • Multiple initials allowable
  • Upper case only
NN/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(tick)
  • No special characters (excl apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )
  • Multiple initials allowable
  • Upper case only 
N
7SurnameN/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 (tick)
  • Character type: Alpha numerical 
  • Character length: Min characters, max charters 
  • Multiple names allowable(tick)
  • Upper and lower case allowed(tick)
  • MANDATORY(tick)
  • At least 1 character must be entered
Y
8Legal SurnamesN/A
  • Free text
  • No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
  • Multiple names allowable
  • Upper and lower case allowed
NN/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 (tick)
  • No special characters (excl apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )
  • Multiple names allowable(tick)
  • Upper and lower case allowed(tick)
  • MANDATORY
  • At least 1 character must be entered
N
9Known AsN/A
  • Free text
  • No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
  • Multiple names allowable
  • Upper and lower case allowed
NN/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 (tick)
  • No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   )) (tick)
  • Multiple names allowable (tick)
  • Upper and lower case allowed(tick)
N
10Maiden NameN/A
  • Free text
  • No special characters (excl apostrophes ( ' ), hypens    ( - ) and spaces (   ))
  • Multiple names allowable
  • Upper and lower case allowed
NN/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 (tick)
  • No special characters (excl apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )
  • Multiple names allowable(tick)
  • Upper and lower case allowed(tick)
N
PERSONAL DETAILS: Contact 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4485
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4486
11Telephone numberN/A
  • additional validation - limit to only numerical values / no spaces
NN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4399

  • 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 (tick)
  • allow ( + ) and ( - ) 
  • allow spaces (tick)
  • no min/max length (tick)
Y
12

Mobile number

N/A
  • additional validation - limit to only numerical values / no spaces
NN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4400

  • 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 (tick)
  • allow ( + ) and ( - )
  • allow spaces (tick)
  • no min/max length (tick)
Y
13

Email address

N/A
  • must be in email format
NN/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
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4290
  • Allow lower and upper case characters

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4401

  • 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(tick)
  • allow lower and upper case characters
  • allow letters and numbers
Y
13

Address line 1

N/A
  • Free text
  • no min/max length
NN/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 (tick)
  • no min/max length (tick)
Y
14

Address line 2

N/A
  • Free text
  • no min/max length
NN/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 (tick)
  • no min/max length (tick)
Y
15

Address line 3

N/A
  • Free text
  • no min/max length
NN/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 (tick)
  • no min/max length (tick)
Y
16

Address line 4


N/A
  • Free text
  • no min/max length
NN/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 (tick)
  • no min/max length (tick)
N
17

Postcode

N/A
  • Free text
  • no min/max length
NN/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 (tick)
  • no min/max length (tick)
Y

PERSONAL DETAILS: Registration details << re-name 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4487
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4488

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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4402

  • 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
NN/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
20GMC start dateN/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
NN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4403
?????? Not done

New ticket 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3556

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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4403
?????? Not done

New ticket 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3556

  • 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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4402

  • 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
NN/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
24GDC start dateN/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
NN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4403
?????? Not done

New ticket 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3556

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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3556

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
NN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4403
?????? Not done

New ticket 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3556

  • 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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3556

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
26Public health numberN/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"

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4402

  • 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
27CollegeTBC
  • N/A
NTBC
  • 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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4489
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4490
 L3 label name to be changed


28EEA residentSee: TIS UI Fields - DropdownsNN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4186

N/AY
29Permit to workSee: TIS UI Fields - Dropdowns
  • Drop down
NN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4188

N/AY
30

Settled

See: TIS UI Fields - Dropdowns
  • Drop down
NN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4189

N/AY

31

Visa issuedN/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
NN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4404
 Not done

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3559

  • 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


Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3559

Valid date format required
  • Free text - or calendar picker (tick)
  • date format DD/MM/YYYY (tick)
Y

32

VisaValidTo

N/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
NN/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 None 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4404
Not done

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEVTISNEW-44043559

  • 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 


Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3559

Valid date format required
  • Free text - or calendar picker (tick)
  • date format DD/MM/YYYY (tick)
Y
33

VisaDetails

N/A
  • Free text
NN/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 (tick)
Y

34


NEW FIELD

NI numberN/A
  • Free text
NN/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 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4491
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4492

35

DateOfBirth

N/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
NN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4405

  • 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 (tick)
  • date format DD/MM/YYYY (tick)
Y
36AgeN/A
  • Derived from date of birth
NN/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 (tick)
N
37

Gender

See: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
Y
38NationalitySee: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
Y
39Dual nationalitySee: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
N
40

Ethnic origin

See: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
Y
41Marital statusSee: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
Y
42Sexual orientationSee: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
Y
43Religious beliefSee: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
Y
44DisabilitySee: TIS UI Fields - DropdownsNN/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 (tick)
Y
45DisabilityDetailsN/A
  • Free text
NN/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 (tick)
Y

SENSITIVE DATA: Manage record function 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4493
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4494

46RoleSee: 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 (tick)
Y
47CommentsN/A
  • Free text
NN/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  (tick)
N
48StatusSee: 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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4406

  • 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 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-2935
N/A

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 (tick)
  • Remove DELETE status TISDEV-2935
  • MANDATORY(tick)
  • Default to current on create journey (tick)
Y
49Inactive from dateN/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
NN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4407

  • 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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4546

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
50Inactive notesN/A
  • Free text
NN/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 * (tick)
N
QUALIFICATIONS: Qualification 1 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4495
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4496

50QualificationSee: TIS UI Fields - Dropdowns
  • Drop down
NN/A
  • Type: Drop down
  • Character type: Alphanumerical
  • Special characters:
  • Character length: Min characters, Max characters
  • Dependencies: None 
  • Mandatory: No
  • Editable: Yes
  • Default value: None 
  • Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4408
  • Type: Drop down
  • Character type: Alphanumerical
  • Special characters:
  • Character length: Min characters, Max characters
  • Dependencies: None 
  • Mandatory: No
  • Editable: Yes
  • Default value: None 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4231

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?

Y
51Qualification TypeSee: TIS UI Fields - Dropdowns
  • Drop down
NN/a
  • Type: Drop down 
  • Character type: Text
  • Special characters: 
  • Character length: Min characters, Max characters
  • Dependencies: None 
  • Mandatory: No
  • Editable: Yes
  • Default value: None 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4408

  • 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 (tick)
N
52Date attainedN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4409

  • 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 (tick)
  • date format DD/MM/YYYY (tick)
YY
53Month attainedN/A
  • Free text - or taken from Date attained field
  • date format DD/MM/YYYY
NN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4410

  • 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
54Year attainedN/A
  • Free text - or taken from Date attained field
  • date format DD/MM/YYYY
NN/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  

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4410

  • 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
55Medical SchoolSee: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
Y
56Country of QualificationSee: TIS UI Fields - Dropdowns
  • Drop down
NN/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 (tick)
  • Auto-fill from 'Medical School'
Y

PROGRAMME MEMBERSHIP: Programme 1  

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4498
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4497


57Programme NameSee: 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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4411

  • 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 (tick)
Y
58Programme No.See: TIS UI Fields - Dropdowns
  • Auto populated when Programme Name is selected
NN/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 (tick) Autofill
Y
59OwnerSee: TIS UI Fields - Dropdowns
  • Auto populated when Programme Name is selected
NN/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 (tick) Autofill
N
60Programme Start dateN/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
  • MANDATORY
NN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4413
? No

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3560

  • 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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3560

Programme Start date is required 
  • Free text - or calendar picker (tick)
  • date format DD/MM/YYYY (tick)
  • MANDATORY(tick)
  • Start date cannot be after end date
N - taken from 'Curriculum 1 Start Date'
61Programme End DateN/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
NN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4413
? No

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3560

  • 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
  • Default value: None 
  • End date cannot be before the start date

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3560

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 (tick)
  • MANDATORY (tick)
  • End date cannot be before the start dat
Y
62Membership TypeSee: 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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4428

  • 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 (tick)
  • MANDATORY (tick)
N
63Rotation

See: TIS UI Fields - Dropdowns &

Programmes - Rotations - Solution Design, Field Validation & ScenariosScenarios

  • Drop down
NN/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
64Leaving destinationSee: TIS UI Fields - Dropdowns
  • Drop down
NN/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/A64Leaving destinationSee: TIS UI Fields - DropdownsDrop down
  • Limit to drop down 
Y
  • (tick)

TBD at a later time - possibly needs overhaul

  • rename to leaving reason?
  • drop down values review
N
65Training numberN/A
  • Autogenerated
  • Editable
  • Readonly textbox (allowing special characters ( / ) in the autogeneration
NN/A
  • Type: Drop down System generated or manual entry 
  • Character type: TextAlphanumerical
  • Special characters: Slash ( / ) 
  • Character length: Min characters none, Max characters noneDependencies: None 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: 'No value provided'Type: Drop down None
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISNEW-2292
65Training numberN/A
  • Autogenerated
  • Editable
  • Free text (allowing special characters ( / ))
NN/A
  • Type: System generated or manual entry 
  • Character type: Alphanumerical
  • Special characters: Slash ( / ) 
  • Character length: Min characters none, Max characters
  • Dependencies: None 
  • Mandatory: No
  • Editable: Yes
  • Default value: None
  • Type: System generated or manual entry 
  • Character type: Alphanumerical
  • Special characters: Slash ( / ) 
  • Character length: Min characters none, Max characters
  • Dependencies: None 
  • Mandatory: No
  • Editable: Yes
  • Default value: None
N/A
  • Autogenerated
  • Editable + manual entry
  • Free text (allowing special characters ( / ))
  • Allow blank

Format may be changing but TBC

TBC -  Removed from template until functionality decided for NTN.
  • Type: System generated or manual entry 
    • Character type:
    Text
    • Alphanumerical
    • Special characters: Slash ( / ) 
    • Character length: Min characters none, Max characters
    noneDependencies: None 
    • 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:
    'No value provided'
N/A
  • Limit to drop down (tick)

TBD at a later time - possibly needs overhaul

  • rename to leaving reason?
  • drop down values review
N
    • None
      Jira Legacy
      serverSystem JIRA
      serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
      keyTISNEW-2292

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:

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-454


PROGRAMME MEMBERSHIP: Programme 1 > Curricula 1 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4500
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4499

66CurriculumSee: TIS UI Fields - Dropdowns
  • Drop down
  • Taken from the Curriculum/Curricula attached to the Programme the trainee is following
  • MANDATORY 
NN/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 (tick)
  • Taken from the um/Curricula attached to the Programme the trainee is following (tick)
Y - Curriculum 1, 2 & 3.
67Curriculum Start DateN/A
  • Default to the Programme start date but allow for editing via a calendar picker or manual update
NN/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. 

68Curriculum End DateN/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
NN/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 (tick)
  • Editable (tick)
  • Date format DD/MM/YYYY (tick)
  • Must be after the Curriculum start date
Y - Curriculum 1,2 & 3 End Dates.
69

NEW: Curriculum sub-type

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-3650

See: TIS UI Fields - DropdownsN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-3650

See: TIS UI Fields - DropdownsN/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 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4502
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4501

69Post NumberN/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

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4414

  • 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
70Main Placement SpecialtySee: 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
71Other Placement  specialtiesSee: TIS UI Fields - Dropdowns
  • Drop down
NN/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
72SiteSee: 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
73Local post numberN/A
  • Read only
NN/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
74GradeSee: 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
75Owner
  • 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" 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4417
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4503
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4504

76Date fromN/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
NN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4416
?

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3561

  • 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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3561

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 (tick)
  • date format DD/MM/YYYY (tick)
  • start date must be before end date
  • MANDATORY
N
77Date toN/A
  • Free text - or calendar picker
  • date format DD/MM/YYYY
NN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4416
?

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3561

  • 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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISNEW-3561

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 (tick)
  • date format DD/MM/YYYY (tick)
  • start date must be before end date
  • MANDATORY
N
PLACEMENT: Placement 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4505
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4506
78Placement TypeSee: 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 (tick)
  • MANDATORY
N
79Training description << moved to Placements: Post (TISDEV-4794)N/A
  • Free text
N/AN/AN/AN/AN/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
80WTEN/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 

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4422

  • 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 (tick)
  • equal to, or less than 1 (tick)
  • To 2 decimal places
  • MANDATORY
N
81StatusTIS UI Fields - Dropdowns
  • autodetermined based on dates
  • read only
NN/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 (tick)
  • read only (tick)
N
82Educational SupervisorN/A
  • drop down
NN/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
83Clinical SupervisorN/A
  • drop down
NN/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 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4507
 / 
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4508

84Curriculum assessedN/ARead only - derived from assessmentNN/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/ARead only - derived from assessment (tick)N
85Review dateN/ARead only - derived from assessmentNN/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/ARead only - derived from assessment (tick)N
86OutcomeN/ARead only - derived from assessmentNN/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/ARead only - derived from assessment (tick)N
85Period assessed fromN/ARead only - derived from assessmentNN/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/ARead only - derived from assessment (tick)N
86Period assessed toN/ARead only - derived from assessmentNN/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/ARead only - derived from assessment (tick)N
ASSOCIATIONS  (trainer records only) POST MVP
87Programme 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
88Programme 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
89Trainee 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
90Site 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
91Site 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
92Trust 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
92Trust 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
93Education 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
94Placement - 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
95Placement - 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
98Placement - 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/ATrainer 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

...