Versions Compared

Version Old Version 17 New Version 18
Changes made by

Former user

Ashley Ransoo

Saved on

Key

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

Enabled NPN manual edit

...


...

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

...

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

...

  • Drop down 
  • Default to NONE

...

Page content

Table of Contents

Posts - Field Validation

Type: Drop down 

This field is required 

Warning: only Post grades can be selected

  • Smart search 
  • MANDATORY 
    • down, current only down, current onlyEditable Yes12Drop down Yes YesDrop down Yes Yes
  • Editable: Yes
    • Filter -  current only Yes Type: Drop down -  current only
    Mandatory: Yes 
  • Add multiple/all
  • Remove one/all
  • Dependencies: "Rotation name" only editable after "Programme name" is selected 
  • Add multiple/all
  • Remove one/all
  • Dependencies: "Rotation name" only editable after "Programme name" is selected 
    •  forward slash ( ), apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   ) characters none
  • Mandatory: No
  • Editable: Yes

    • If Funding type is "No value provided"

    • Editable: No

    If Funding type is not "No value provided"

    • Type: Free text  or calendar pick 
    • Date format DD/MM/YYYY
    • Character type: Numerical 
    • Special characters allowed: /
    • Mandatory: Yes 
    • Dependencies: Only active when "Funding type" is not "No value provided" otherwise greyed out
    • Editable: Yes
    • Type otherwise greyed out
    • Editable: Yes 

    If Funding type is "No value provided"

    • Editable: No

    If Funding type is not "No value provided"

    • Type: Free text  or calendar pick 
    • Date format DD/MM/YYYY
    • Character type: Numerical 
    • Special characters allowed: /
    • Mandatory: Yes 
    • Dependencies: Only active when "Funding type" is not "No value provided" otherwise greyed out
    • Editable: Yes
    • Type otherwise greyed out
    • Editable: Yes 

    This field is required 

    Only special characters allowed /

    If Funding type is "No value provided"

    Editable: no

    If Funding type is not "No value provided"

    • Type: Free text  or calendar pick 
    • Date format DD/MM/YYYY
    • Character type: Numerical 
    • Special characters allowed: /
    • Mandatory: Yes 
    • Dependencies:Only active when "Funding type" is not "No value provided" otherwise greyed out
    • Editable: Yes
    • Type otherwise greyed out
    • Editable: Yes 

    If Funding type is "No value provided"

    • Editable: No

    If Funding type is not "No value provided"

    • Type: Free text  or calendar pick 
    • Date format DD/MM/YYYY
    • Character type: Numerical 
    • Special characters allowed: /
    • Mandatory: Yes 
    • Dependencies:Only active when "Funding type" is not "No value provided" otherwise greyed out
    • Editable: Yes
    • Type otherwise greyed out
    • Editable: Yes 

    This field is required 

    Only special characters allowed /

    Field Sequence Field name Reference TableCurrent FE Validation & RulesList Page?(Y/N) List Page Rules (Sort/Filter)Proposed FE Validation Rules Proposed BE Validation / Rules Error Messages NotesDelete (Y/N) 
    National Post Number   
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4748
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4747
    1SuffixSee: TIS UI Fields - Dropdowns
    • Drop down 
    • Default to NONE
    		N

    Enabled NPN manual edit

    • Type: Drop down 
    • Dependencies: "Enable/d NPN manually editing" = "Yes"
    • Mandatory: Yes
    • Editable: Yes
    • Default value: 'NONE'

    Auto-generation NPN

    • Dependencies: "Enable/d NPN manually editing" = "No"
    • Editable: No

    Enabled NPN manual edit

    • Type: Drop down 
    • Dependencies: "Enable/d NPN manually editing" = "Yes"
    • Mandatory: Yes
    • Editable: Yes
    • Default value: 'NONE'

    Auto-generation NPN

    • Dependencies: "Enable/d NPN manually editing" = "No"
    • Editable: No

    Warning: Suffix cannot be amended for autogenerated NPN


    This field is required 

    		Can Suffix be amended (changed, added, or removed) in an autogenerated NPN after it's been created?
    2Enable/d NPN manually editing
    • Drop down 
    • Default to Yes
    		N
    • Type: Drop down 
    • Mandatory: Yes
    • Editable: Yes
    • Default value: Yes
    • Type: Drop down 
    • Mandatory: Yes
    • Editable: Yes
    • Default value: Yes
    		Warning: If "No" selected, the NPN cannot be edited

    3National post number

    'Enable/d NPN manually editing' No

    • Auto-created number based on the managing local office code, grade code, speciality code and postfix
    • Not editable 
    • Not visible until post is created 

    'Enable/d NPN manually editing' Yes

    • Free text
    		Y

    Sort

    • ascending order

    Enabled NPN manual edit

    • Type: Manual entry 
    • Character type: Alphanumeric 
    • Special characters allowed: /
    • Character length: Min characters 1, Max characters none
    • Dependencies: "Enable/d NPN manually editing" = "Yes"
    • Mandatory: Yes
    • Editable: YesIf  NPN manual edit is enabled
    • Default value: 'NONE'
    Auto-generation NPN
    • N/A


    Autogeneration

    • Type: Auto-generated
    • Derived from owner code, grade code, specialty code, suffix
    • Dependencies:  "Enable/d NPN manually editing
    " = "No"
  • Editable: No
    • " = "No"
    • Mandatory: No
    • Editable: No
    • Default value: N/A
    • Display in real time i.e. as the user enters fields

    Enabled NPN manual edit

    • Type: Drop down Manual entry 
    • Character type: Alphanumeric 
    • Special characters allowed: /
    • Character length: Min characters 1, Max characters none
    • Dependencies:  "Enable/d NPN manually editing" = "Yes"
    • Mandatory: Yes
    • Editable: YesIf  NPN manual edit is enabled
    • Default value: 'NONE'
    Auto-generation NPN
    • N/A


    Autogeneration

    • Type: Auto-generated
    • Derived from owner code, grade code, specialty code, suffix
    • Dependencies:  "Enable/d NPN manually editing" = "No"
    • Mandatory: No
    • Editable: No
    Warning: Suffix cannot be amended for autogenerated NPN
    • Default value: N/A
    • Display in real time i.e. as the user enters fields

    This field is required 

    		Can Suffix be amended (changed, added, or removed) in an autogenerated NPN after it's been created?2

    Only special characters allowed are /










    		The error message should only be displayed where "Enable/d NPN manually editing
    • Drop down 
    • Default to Yes
    		N
    • Type: Drop down 
    • Mandatory: Yes
    • Editable: Yes
    • Default value: Yes
    		" = Yes
    Allocation 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4749
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4750
    4Main site See: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search 
    • MANDATORY
    		Y (Primary Site)Filter 
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Default value: Yes
    		Warning: If "No" selected, the NPN cannot be edited3National post number

    'Enable/d NPN manually editing' No

    • Auto-created number based on the managing local office code, grade code, speciality code and postfix
    • Not editable 
    • Not visible until post is created 

    'Enable/d NPN manually editing' Yes

    • Free text
    		Y

    Sort

    • ascending order

    Enabled NPN manual edit

    • Type: Manual entry 
    • Character type: Alphanumeric 
    • Special characters allowed: /
    • Character length: Min characters 1, Max characters none
    • Dependencies: "Enable/d NPN manually editing" = "Yes"
    • Mandatory: Yes
    • Editable: If  NPN manual edit is enabled
    • Default value: N/A

    Autogeneration

    • Type: Auto-generated
    • Derived from owner code, grade code, specialty code, suffix
    • Dependencies:  "Enable/d NPN manually editing" = "No"
    • Mandatory: No
    • Editable: No
    • Default value: N/A
    • Display in real time i.e. as the user enters fields

    Enabled NPN manual edit

    • Type: Manual entry 
    • Character type: Alphanumeric 
    • Special characters allowed: /
    • Character length: Min characters 1, Max characters none
    • Dependencies:  "Enable/d NPN manually editing" = "Yes"
    • Mandatory: Yes
    • Editable: If  NPN manual edit is enabled
    • Default value: N/A

    Autogeneration

    • Type: Auto-generated
    • Derived from owner code, grade code, specialty code, suffix
    • Dependencies:  "Enable/d NPN manually editing" = "No"Display SiteKnownAs+SiteNumber
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Display SiteKnownAs+SiteNumber
    		This field is required 

    5Other sites (optional)See: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search 
    • + or - button 
    		N
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Display SiteKnownAs+SiteNumber
    • Add multiple/all
    • Remove one/all
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Display SiteKnownAs+SiteNumber
    • Add multiple/all
    • Remove one/all

    		Users should be able to add multiple fields individually, or add all fields from the drop down 
    6Main specialtySee: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search 
    • MANDATORY 
    		Y (Primary SpecialtyFilter 
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Add one Main specialty only
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Add one Main specialty only

    This field is required 




    7Other specialitiesSee: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search 
    • + or -
    		N
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    		4Main site 
    • Type: Smart search 
    • Mandatory: No
    • Editable: No
    • Default value: N/A
    • Display in real time i.e. as the user enters fields

    This field is required 

    Only special characters allowed are /

    		The error message should only be displayed where "Enable/d NPN manually editing" = Yes
    Allocation 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4749
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4750
    • Yes
    • Add multiple/all
    • Remove one/all

    		Users should be able to add multiple fields individually, or add all fields from the drop down 
    8Sub specialitiesSee: TIS UI Fields - Dropdowns
    • Drop down 
    • Smart search 
    • + or -
    		N
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    • Limit to sub-specialties of the Main specialty
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    • Limit to sub-specialties of the Main specialty
    		Warning: only sub-specialties o the Main specialty can be selectedInvestigate whether multiple sub-specialties is required (Data Leads)
    9Approved grade See: TIS UI Fields - Dropdowns
    • Drop downdown 
    • Smart search 
    • MANDATORY
    		Y (Primary Site)Filter 
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: YesDisplay
    • SiteKnownAs+SiteNumberLimit to Post Grades
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: YesDisplay
    • SiteKnownAs+SiteNumberLimit to Post Grades

    This field is required 

    		5Other sites (optional)


    Warning: only Post grades can be selected



    10Other grades See: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search 
    • + or - button 
    N
    • down
    • Smart search 
    • + or -
    		N
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    • Limit to Post Grades
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Display SiteKnownAs+SiteNumber
    • Add multiple/all
    • Remove one/all
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Display SiteKnownAs+SiteNumber
    • Add multiple/all
    • Remove one/all
    		Users should be able to add multiple fields individually, or add all fields from the drop down 6Main specialty
    • Limit to Post Grades
    		Warning: only Post grades can be selected

    Ownership 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4752
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4751
    11OwnerSee: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search 
    • MANDATORY 
    		Y (Primary SpecialtyFilter 
    • Type: Smart search Drop down, current only
    • Mandatory: Yes
    • Editable: YesAdd one Main specialty only
    • Type: Smart search Drop down, current only
    • Mandatory: Yes
    • Editable: Yes
    • Add one Main specialty only
    		This field is required 

    712Other specialitiesEmploying bodySee: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search + or -
    		N
    • Type: Smart search 
    • Mandatory: NoYes
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    		Sub specialities
    • Type: Smart search 
    • Mandatory: NoYes
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    		Users should be able to add multiple fields individually, or add all fields from the drop down 8
    • Yes
    		This field is required 

    13Training bodySee: TIS UI Fields - Dropdowns
    • Drop down down
    • Smart search 
    • + or -
    		N
    • Type: Smart search 
    • Mandatory: NoYes
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    • Limit to sub-specialties of the Main specialty
    		Approved grade 
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    • Limit to sub-specialties of the Main specialty
    		Warning: only sub-specialties o the Main specialty can be selectedInvestigate whether multiple sub-specialties is required (Data Leads)9
    • Mandatory: Yes
    • Editable: Yes
    		This field is required 

    14Programme name See: TIS UI Fields - Dropdowns
    • Drop down down
    • Smart search MANDATORY
    • + or - 
    		YFilter Filter10Other grades See: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search 
    • + or -
    		N
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Add multiple/all
    • Remove one/all
    • Limit to Post Grades
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Limit to Post Grades
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Limit to Post Grades
    • Type: Smart search Drop down -  current only
      Mandatory: Yes 
    • Editable: Yes 
    • Add multiple/all
    • Remove one/all
    • Dependencies: "Rotation name" only editable after "Programme name" is selected 
    • Type: Drop down -  current only
      Mandatory: Yes 
    • Editable: Yes 
    • Add multiple/all
    • Remove one/all
    • Dependencies: "Rotation name" only editable after "Programme name" is selected 
    		This field is required 

    15Training description
    • Free text 
    		N
    • Type: Manual entry 
    • Characters: Text 
    • Special characters allowed: 

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

    • Character length: Min characters 0, Max characters none
    • Mandatory: No
    • Editable: Yes
  • Add multiple/all
  • Remove one/all
  • Limit to Post Grades
    		• Warning: only Post grades can be selected
    Ownership 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4752
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4751
    11Owner
    • Type: Manual entry 
    • Characters: Text 
    • Special characters allowed:

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

    • Character length: Min characters 0, Max characters none
    • Mandatory: No 
    • Editable: Yes
    		Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )

    18Status See: TIS UI Fields - Dropdowns
    • Drop down
    • Default to CURRENT
    		YFilter 
    • Type: Drop
    • down 
    • Mandatory: Yes
    • Editable: Yes
    • Default value: CURRENT 
    • Type: Drop
    • down 
    • Mandatory: Yes
    • Editable: Yes
    • Default value:
    • CURRENT 
    		This field is required 

    19 Employing bodySee: TIS UI Fields - DropdownsOld post 
    • Drop down 
    • Smart search 
    		N
    • Type: Smart search 
    • Mandatory:
    • No
    • Editable: Yes
    • Type: Smart search 
    • Mandatory:
    • No 
    • Editable: Yes
    		This field is required 13Training bodySee: TIS UI Fields - Dropdowns


    20New post 
    • Drop down 
    • Smart search 
    		N
    • Type: Smart search 
    • Mandatory:
    • No
    • Editable: Yes
    • Limit to already created Posts
    • Type: Smart search 
    • Mandatory:
    		This field is required 14Programme name See: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search 
    • + or - 
    		Y
    • No
    • Editable: Yes
    • Limit to already created Posts



    21Post family 
    • Free text
    		N
    • Type: Drop down
    • Mandatory:
    • No
    • Editable: Yes 
    • Limit to ref table
    • Type: Drop down
    • Mandatory: No
    • Editable: Yes 
    		This field is required 15Training description
    • Free text 
    		N
    • Limit to ref table

    		JW to discuss with SMEs
    22Local post number
    • Free text 
    		N
    • Type: Manual entry 
    • Characters: Text
    • Special characters allowed: /
    • Character length: Min characters 0, Max characters none
    • Mandatory: No
    • Editable: Yes
    • Type: Manual entry 
    • Characters: Text 
    • Special characters allowed:
    • /
    • Character length: Min characters 0, Max
    • Type: Manual entry 
    • Characters: Text 
    • Special characters allowed:

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

    • Character length: Min characters 0, Max characters none
    • Mandatory: No 
    • Editable: Yes
    		Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )18Status 
    • characters none
    • Mandatory: No
    • Editable: Yes



    Funding (Needs to be discussed with SMEs - particularly EM & LASE) 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4753
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4754
    23Funding type See: TIS UI Fields - Dropdowns
    • Drop down
    • Default to CURRENT'No value provided'
    		YFilter 
    • Type: Drop down down
    • Mandatory: Yes
    • Editable: Yes
    • Default value: CURRENT 
    • Type: Drop down 
    • Mandatory: Yes
    • Editable: YesDependencies:"If 'Other', please specify," "Start date," "End date"
    • Editable: Yes 
    • Default value:CURRENT 
    		This field is required 19 Old post 
    • Drop down 
    • Smart search 
    		N
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Type: Smart search 
    • Mandatory: No 
    • Editable: Yes
    		20New post 
    • Drop down 
    • Smart search 
    		N
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Limit to already created Posts
    • Type: Smart search 
    • Mandatory: No
    • Editable: Yes
    • Limit to already created Posts
    		21Post family 
    • Free text
    		N
    • Type: Drop down
    • Mandatory: No
    • Editable: Yes 
    • Limit to ref table
    • Type: Drop down
    • Mandatory: No
    • Editable: Yes 
    • Limit to ref table
    		JW to discuss with SMEs22Local post number
    • Free text 
    		N
    •  "No value provided"
    • Type: Drop down
    • Mandatory: Yes
    • Dependencies:"If 'Other', please specify," "Start date," "End date"
    • Editable: Yes 
    • Default value: "No value provided"
    		This field is required 

    24If 'Other', please specify 
    • Free text, if 'Funding type' 'OTHER is selected 
    		N

    If Funding type is "Other"

    • Type: Manual entry 
    • Characters: Text
    • Special characters allowed: 

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

    • Character length: Min characters 0, Max characters none
    • Mandatory: No
    • Dependencies:Only active when "Funding type" is "Other" otherwise greyed out
    • Editable: Yes

    If Funding type is not "Other"

    • Editable: No

    If Funding type is "Other"

    • Type: Manual entry 
    • Characters: Text
    • Special characters allowed: 

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

    • Character length: Min characters 0, Max characters none
    • Mandatory: No
    • Dependencies:Only active when "Funding type" is "Other" otherwise greyed out
    • Editable: Yes
    • Type: Manual entry 
    • Characters: Text 
    • Special characters allowed: /
    • Character length: Min characters 0, Max characters none
    • Mandatory: No
    • Editable: Yes
    Funding (Needs to be discussed with SMEs - particularly EM & LASE) 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4753
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4754
    23Funding type See: TIS UI Fields - Dropdowns
    • Drop down
    • Default to 'No value provided'
    		YFilter 
    • Type: Drop down
    • Mandatory: Yes
    • Dependencies:"If 'Other', please specify," "Start date," "End date"
    • Editable: Yes 
    • Default value: "No value provided"
    • Type: Drop down
    • Mandatory: Yes
    • Dependencies:"If 'Other', please specify," "Start date," "End date"
    • Editable: Yes 
    • Default value: "No value provided"
    		This field is required 24If 'Other', please specify 
    • Free text, if 'Funding type' 'OTHER is selected 
    		N

    If Funding type is "Other"

  • Type: Manual entry 
  • Characters: Text
  • Special characters allowed: 

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

  • Character length: Min characters 0, Max characters none
    • Mandatory: No

    If Funding type is not "Other"

    • Editable: No
    		Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )

    25Funding body / organisationSee: TIS UI Fields - Dropdowns
    • Drop down
    • Smart search
    		N
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Add multiple
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Add multiple
    		This field is required Should be pulling from "Funding Organisation table"
    26Start date
    • Free text or calendar pick
    • Date format DD/MM/YYYY
    		N

    If Funding type is "No value provided"

    • Editable: No


    If Funding type is not "No value provided"

    • Type: Free text  or calendar pick 
    • Date format DD/MM/YYYY
    • Character type: Numerical 
    • Special characters allowed: /
    • Mandatory: Yes 
    • Dependencies: Only active when "Funding type" is not "No value provided" otherwise greyed out
    • Editable: Yes
    • Type otherwise greyed out
    • Editable: Yes 

    • If Funding type is "No value provided"

      • Editable: No


      If Funding type is not "No value provided"

      • Type: Free text  or calendar pick 
      • Date format DD/MM/YYYY
      • Character type: Numerical 
      • Special characters allowed: /
      • Mandatory: Yes 
      • Dependencies: Only active when "Funding type" is not "No value provided" otherwise greyed out
      • Editable: Yes
      • Type otherwise greyed out
      • Editable: Yes 

    This field is required 


    Only special characters allowed /



    27End date 
    • Free text or calendar pick
    • Date format DD/MM/YYYY
    		N

    If Funding type is "No value provided"


    • Editable: no


    If Funding type is not "No value provided"

    • Type: Free text  or calendar pick 
    • Date format DD/MM/YYYY
    • Character type: Numerical 
    • Special characters allowed: /
    • Mandatory: Yes 
    • Dependencies:Only active when "Funding type" is not "OtherNo value provided" otherwise greyed out
    • Editable: Yes
    • Type otherwise greyed out
    • Editable: Yes 

    If Funding type is not "OtherNo value provided"

    • Editable: No


    If Funding type is not "OtherNo value provided"

    • Type: Manual entry 
    • Characters: Text
    • Special characters allowed: 

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

    • Character length: Min characters 0, Max characters none
    • Mandatory: NoFree text  or calendar pick 
    • Date format DD/MM/YYYY
    • Character type: Numerical 
    • Special characters allowed: /
    • Mandatory: Yes 
    • Dependencies:Only active when "Funding type" is not "Other" otherwise greyed out
    • Editable: Yes

    If Funding type is not "Other"

    • Editable: No
    		Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens  ( - ), full stops ( . ) and spaces (   )25Funding body / organisationSee: TIS UI Fields - Dropdowns
    • Drop down
    • Smart searchNo value provided" otherwise greyed out
    • Editable: Yes
    • Type otherwise greyed out
    • Editable: Yes 

    This field is required 


    Only special characters allowed /



    Rotation 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4755
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4756
    29Rotation name 
    • Drop down
    • Smart search 
    		N
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Add multiple
    • Type: Smart search 
    • Mandatory: Yes
    • Editable: Yes
    • Add multiple
    		This field is required Should be pulling from "Funding Organisation table"26Start date
    • Free text or calendar pick
    • Date format DD/MM/YYYY
    		N27End date 
    • Free text or calendar pick
    • Date format DD/MM/YYYY
    		N
    Rotation 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4755
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4756
    29Rotation name 
    • Drop down
    • Smart search 
    		N
    • Type: Smart search 
    • Mandatory: No 
    • Editable: Yes 
    • Add multiple/all
    • Remove one/all
    • Dependencies: Only active when Programme selected, otherwise greyed out. History only populates if Rotation is selected.
    • Limit to Rotations already created
    • Current values only
    • Limited to Rotations in same Programme
    • Type: Smart search 
    • Mandatory: No 
    • Editable: Yes 
    • Add multiple/all
    • Remove one/all
    • Dependencies: Only active when Programme selected, otherwise greyed out. History only populates if Rotation is selected.
    • Limit to Rotations already created
    • Current values only
    • Limited to Rotations in same Programme
    		Warning: Only rotations from within the same programme as the post can be selected
    History (Table) 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4757
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4758
    30Trainee full name
    • Read only

    Y (Current Trainee) 

    Sort 

    Max 1 current trainee displayed in list page

    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    		31Start date
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    		32End date
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    		33Main site 
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    		 34Main specialty
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    		35Placement grade
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    		36Placement type
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    		37Status 
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: NoNo 
    • Editable: Yes 
    • Add multiple/all
    • Remove one/all
    • Dependencies: Only active when Programme selected, otherwise greyed out. History only populates if Rotation is selected.
    • Limit to Rotations already created
    • Current values only
    • Limited to Rotations in same Programme
    • Type: Smart search 
    • Mandatory: No 
    • Editable: Yes 
    • Add multiple/all
    • Remove one/all
    • Dependencies: Only active when Programme selected, otherwise greyed out. History only populates if Rotation is selected.
    • Limit to Rotations already created
    • Current values only
    • Limited to Rotations in same Programme
    		Warning: Only rotations from within the same programme as the post can be selected

    History (Table) 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4757
     / 
    Jira Legacy
    serverSystem JIRA
    serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
    keyTISDEV-4758
    30Trainee full name
    • Read only

    Y (Current Trainee) 

    Sort 

    Max 1 current trainee displayed in list page

    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No



    31Start date
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No



    32End date
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No



    33Main site 
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No



     34Main specialty
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No



    35Placement grade
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No



    36Placement type
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No



    37Status 
    • Read only
    		N
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No
    • Type: Derived from Placements
    • Dependencies: Populates if Rotation is selected 
    • Editable: No




    Posts - Bulk import column header - validations - (DRAFT)


    Column headingAdd/Update/Matching CriteriaMandatoryRulesQuestions for discussionsMVP (Y/N)
    National Post Number*AddYShould be a Post that does not already exist on TIS.

    Do we need this to be auto generated as in the UI? If so, there are some fields that are mandatory and it will also need the addition of the Suffix. 

    If not, then:

    • the column should be mandatory on the template
    • It would be an Add type
    • The import will only be successful or the row if the NPN does not already exist, if already exist then thrown an error in the downloadable template 'Cannot update post with this NPN as there are other posts with the same NPN' 
    • The 'Enable/d NPN manually editing' will be automatically set to 'Manually edit'

    Approved grade*AddYAccepted values should match to one of the Grade reference table and are CURRENT

    Other gradesAddN
    • Comma separated to add multiple
    • Accepted values should match to one of the Grade reference table and are CURRENT


    Specialty*Add
    		Accepted values should match to one of the Specialty reference table and are CURRENT

    Other specialtiesAddN
    • Comma separated to add multiple
    • Accepted values should match to one of the Specialty reference table and are CURRENT


    Sub specialtiesAddN
    • Comma separated to add multiple
    • Accepted values should match to one of the Specialty reference table and are CURRENT
    		Should this be constrained to specialty type SUB_SPECIALTY?
    Training descriptionAdd
    		Freetext

    Main site*AddYAccepted values should match to one of the SiteKnownAs from Site reference table and are CURRENT

    Other sitesAddN
    • Comma separated to add multiple
    • Accepted values should match to one of the Site reference table and are CURRENT


    Training BodyAddNAccepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT

    Employing BodyAddNAccepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT

    Programme Name*AddYProgramme Name and Number should both match to one of the existing programmes on TIS and are CURRENT.

    This is not currently mandatory on the UI. This may be because of the data inherited from Intrepid migration which would mean that if this was made mandatory then the whole post record would be made un-editable.

    However, this does need to be mandatory for the Placement Planning Tool to return the Post from the Programme view. 

    This requires some work for the data leads to correct the posts with no programme name & number to avoid Programmes from being created as such going forward. 


    Programme Number*AddYProgramme Name and Number should both match to one of the existing programmes on TIS and are CURRENT.

    This is not currently mandatory on the UI. This may be because of the data inherited from Intrepid migration which would mean that if this was made mandatory then the whole post record would be made un-editable.

    However, this does need to be mandatory for the Placement Planning Tool to return the post from the Programme view.

    This requires some work for the data leads to correct the posts with no programme name & number to avoid Programmes from being created as such going forward. 


    Owner*AddYAccepted values should match to one of Local Office reference table and are CURRENT. 


























    Questions and Assumptions

    #QuestionComments
    1Should you be able to add Post fundings as part of the Post upload or should be separate?
    2What are the MVP fields for a Post Import template?
    3Should the MVP be to use the template to only create new Posts and consider update as a post-MVP future increment?