Posts - Field Validation

Posts - Field Validation

Posts - Bulk create import column headers - validations - (DRAFT)

Questions and Assumptions

Posts - Bulk Update import column headers - validations - (DRAFT)

Questions and Assumptions

Posts - Field Validation

Posts - Field Validation

Posts - Bulk create import column headers - validations - (DRAFT)

Questions and Assumptions

Posts - Bulk Update import column headers - validations - (DRAFT)

Questions and Assumptions

Page Comparison

Posts - Field Validation

Posts - Field Validation

Posts - Bulk create import column headers - validations - (DRAFT)

Questions and Assumptions

Posts - Bulk Update import column headers - validations - (DRAFT)

Questions and Assumptions

Versions Compared

Key

Versions Compared

Key

Page content

Table of Contents

...

Jira Legacy

server	System JIRA
serverId	4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key	TISDEV-4748

...

Jira Legacy

server	System JIRA
serverId	4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key	TISDEV-4747

...

Page content

Table of Contents

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

Smart search

MANDATORY (Primary Specialty Smart search Add one Main specialty only Smart search Add one Main specialty only7

Drop down

Smart search

+ or -

Add multiple/all

Remove one/all No

Add multiple/all

Remove one/all

+ or -

Add multiple/all

Remove one/all

sub-specialties of the Main specialty

Add multiple/all

Remove one/all sub-specialties of the Main specialty

This field is required

Warning: only Post grades can be selected

Type: Smart search

Add multiple/all

Remove one/all

Limit to Post Grades

Type: Smart search

Add multiple/all

Remove one/all

Limit to Post Grades

Employing body

Smart search

N Smart search

Editable: Yes

Type: Smart search

Mandatory: Yes YesType: Smart search

Editable: Yes

N Text

Type: Manual entry

Characters: Text

Special forward )

Character length: Min characters 0, Max characters none

Mandatory: No

Editable: Yes

Funding (Needs to be discussed with SMEs - particularly EM & LASE)

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 Table

Current FE Validation & Rules

List Page?(Y/N)

List Page Rules (Sort/Filter)

Proposed FE Validation Rules

Proposed BE Validation / Rules

Error Messages

Notes

Delete (Y/N)

National Post Number
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4748
/

Jira Legacy

server	System JIRA
serverId	4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key	TISDEV-4747

1

Suffix

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

2

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

3

National 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"
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
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4749
/
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4750

4

Main site

See: TIS UI Fields - Dropdowns

Drop down
Smart search
MANDATORY

Y (Primary Site)

Filter

Type: Smart search
Mandatory: Yes
Editable: Yes
Display SiteKnownAs+SiteNumber

Type: Smart search
Mandatory: Yes
Editable: Yes
Display SiteKnownAs+SiteNumber

This field is required

5

Other 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

6

Main specialty

See: TIS UI Fields - Dropdowns

Drop down
Smart search
MANDATORY

Y (Primary Specialty

Filter

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

7

Other specialities

See: TIS UI Fields - Dropdowns

Drop down
Smart search
+ or -

N

Type: Smart search
Mandatory: No
Editable: Yes
Add multiple/all
Remove one/all

Type: Smart search
Mandatory: No
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

Sub specialities

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

Investigate whether multiple sub-specialties is required (Data Leads)

9

Approved grade

See: 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"Smart search
MANDATORY

Y

Filter

Type: Smart search
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

Limit to Post Grades

Type: Smart search
Mandatory: Yes
Editable: Yes
Limit to Post Grades

This field is required

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

2

Enable/d NPN manually editing

Drop down

Default to Yes

Warning: only Post grades can be selected

10

Other grades

See: TIS UI Fields - Dropdowns

Drop down
Smart search
+ or -

N

Type: Drop down Smart search
Mandatory: YesNo
Editable: YesDefault value: Yes
Add multiple/all
Remove one/all
Limit to Post Grades

4

Main site

See: TIS UI Fields - Dropdowns

Drop down
Smart search
MANDATORY

Y (Primary Site)

Filter

Type: Smart search
Mandatory: Yes
Editable: Yes
Display SiteKnownAs+SiteNumber

Type: Smart search
Mandatory: Yes
Editable: Yes
Display SiteKnownAs+SiteNumber

This field is required

5

Other 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

6

Main specialty

Type: Drop down Smart search
Mandatory: YesNo
Editable: Yes
Default value: Yes

Warning: If "No" selected, the NPN cannot be edited

3

National 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

The error message should only be displayed where "Enable/d NPN manually editing" = Yes

Allocation
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4749
/
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4750

Add multiple/all
Remove one/all
Limit to Post Grades

Warning: only Post grades can be selected

Ownership
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4752
/
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4751

11

Owner

See: TIS UI Fields - Dropdowns

Drop down
Smart search
MANDATORY

Y

Filter

Type: Drop down, current only
Mandatory: Yes
Editable: Yes

Type: Drop down, current only
Mandatory: Yes
Editable: Yes

This field is required

12

Employing body

See: TIS UI Fields - Dropdowns

Drop down
Smart search

N

Type: Smart search
Mandatory: Yes
Editable: Yes

Type: Smart search
Mandatory: Yes
Editable: Yes

This field is required

13

Training body

See: TIS UI Fields - Dropdowns

Drop down
Smart search

N

Type: Smart search
Mandatory: Yes
Editable: Yes

Type: Smart search
Mandatory: Yes
Editable: Yes

This field is required

14

Programme name

See: TIS UI Fields - Dropdowns

Drop down
Smart search
+ or -

Y

Filter

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

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

15

Training 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

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

18

Status

See: TIS UI Fields - Dropdowns

Drop down

Default to CURRENT

Y

Filter

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

Other specialities

See: TIS UI Fields - Dropdowns

Old post

Drop down
Smart search

N

Type: Smart search
Mandatory: No
Editable: Yes

Type: Smart search
Mandatory:

No
Editable: Yes

Users should be able to add multiple fields individually, or add all fields from the drop down

8

Sub specialities

See: TIS UI Fields - Dropdowns

20

New 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

Warning: only sub-specialties o the Main specialty can be selected

Investigate whether multiple sub-specialties is required (Data Leads)

9

Approved grade

See: TIS UI Fields - Dropdowns

Drop down
Smart search
MANDATORY

Y

Filter

Type: Smart search
Mandatory: Yes
Editable: Yes
Limit to Post Grades

Type: Smart search
Mandatory: Yes
Editable: Yes
Limit to Post Grades

10

Other grades

See: TIS UI Fields - Dropdowns

Drop down
Smart search
+ or -

N

already created Posts

21

Post 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 SMEs

22

Local 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 characters none
Mandatory: No
Editable: Yes

Warning: only Post grades can be selected

Ownership Funding (Needs to be discussed with SMEs - particularly EM & LASE)

Jira Legacy

server	System JIRA
serverId	4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key	TISDEV-

4752

4753

/

Jira Legacy

server	System JIRA
serverId	4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key	TISDEV-

4751

4754

11

Owner

See: TIS UI Fields - Dropdowns

Drop down
Smart search
MANDATORY

Y

Filter

Type: Drop down, current only
Mandatory: Yes
Editable: Yes

Type: Drop down, current only
Mandatory: Yes
Editable: Yes

This field is required

12

23

Funding type

See: TIS UI Fields - Dropdowns

Drop down

Default to 'No value provided'

Y

Filter

Type:

Drop down
Mandatory: Yes

Dependencies:"If 'Other', please specify," "Start date," "End date"
Editable:

This field is required

13

Training body

See: TIS UI Fields - Dropdowns

Drop down
Smart search

N

Yes
Default value: "No value provided"

Type: Smart search
Mandatory: Yes
Editable: Yes

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

14

Programme name

See: TIS UI Fields - Dropdowns

Drop down
Smart search
+ or -

Y

Filter

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

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

15

Training description

Free text

24

If '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

If Funding type is not "Other"

Editable: No

Only special characters allowed:

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

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

18

Status

See: TIS UI Fields - Dropdowns

Drop down
Default to CURRENT

Y

Filter

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

Old post

Drop down
Smart search

N

Type: Smart search
Mandatory: No
Editable: Yes

Type: Smart search
Mandatory: No
Editable: Yes

20

New 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

21

Post 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 SMEs

22

Local 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 characters none
Mandatory: No
Editable: Yes

)

25

Funding body / organisation

See: 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"

26

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

27

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

Rotation
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-
4753
4755
/
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7

key

TISDEV-4754

23

Funding type

See: TIS UI Fields - Dropdowns

Drop down
Default to 'No value provided'

Y

Filter

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

24

If '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

If Funding type is not "Other"

Editable: No

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

25

Funding body / organisation

See: 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"

26

Start date

Free text or calendar pick
Date format DD/MM/YYYY

N

27

End date

Free text or calendar pick
Date format DD/MM/YYYY

N

Rotation
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4755
/
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4756

29

Rotation 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
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4757
/
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4758

30

Trainee 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

31

Start 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

32

End 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

33

Main 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

34

Main 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

35

Placement 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

36

Placement 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

37

Status

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

...

key TISDEV-4756

29

Rotation 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
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4757
/
Jira Legacy
server System JIRA
serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7
key TISDEV-4758

30

Trainee 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

31

Start 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

32

End 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

33

Main 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

34

Main 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

35

Placement 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

36

Placement 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

37

Status

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

Row no.	Column heading	Add/Update/Matching Criteria	Mandatory	Rules	Questions for discussions	MVP (Y/N)
	PostID
1	National Post Number*	Add	Y	Should 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 as a column. If not, then: the column should be mandatory on the template It would be an Add type The import will only be successful for the row if the NPN does not already exist, if already exist then throw an error in the downloadable template 'Cannot add post with this NPN as there are other posts with the same NPN' The 'Manually edit NPN / Auto-generate NPN' will be automatically set to 'Manually edit'
2	Approved grade*	Add	Y	Accepted values should match to one of the Grade reference table and are CURRENT	Validation in here to match that on the FE
3	Other grades	Add	N	Comma separated to add multiple Accepted values should match to one of the Grade reference table and are CURRENT	Make clear that it is the grade name not abbreviation
4	Specialty*	Add	Y	Accepted values should match to one of the Specialty reference table and are CURRENT
5	Other specialties	Add	N	Comma separated to add multiple Accepted values should match to one of the Specialty reference table and are CURRENT
6	Sub specialties	Add	N	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? Yes, but only when the PAG has reviewed and validated the current sub_spec list.
7	Training description	Add		Freetext
8	Main site*	Add	Y	Accepted values should match to one of the SiteKnownAs from Site reference table and are CURRENT	Check that all 'SiteKnownAs' names have the site code afterwards - JW run report to check
9	Other sites	Add	N	Comma separated to add multiple Accepted values should match to one of the SiteKnownAs from Site reference table and are CURRENT
10	Training body	Add	N	Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT
11	Employing body	Add	N	Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT
12	Programme name	Add	N	If populated on template, Programme 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 as not all posts will be training posts so therefore not attached to a training programme. However, when using the template, users should be conscious that this does need to be populated for the Placement Planning Tool to return the Post from the Programme view.	Can be made mandatory - what about existing posts? Alice and James (Intrepid/TIS views for data audit will show posts with no programme attached)
13	Programme number	Add	N	If populated on template, Programme 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 as not all posts will be training posts so therefore not attached to a training progamme. However, when using the template, users should be conscious that this does need to be populated for the Placement Planning Tool to return the Post from the Programme view.	Can be made mandatory - what about existing posts? Alice and James (Intrepid/TIS views for data audit will show posts with no programme attached)
14	Owner*	Add	Y	Accepted values should match to one of Local Office reference table and are CURRENT.
	Old post				Is this required in a bulk create scenario? Yes and for amend
	New post				Is this required in a bulk create scenario? For amend
	Local post number				Is this required in a bulk create scenario? No
	Post family				Is this required in a bulk create scenario? No

#	Question	Comments
1	Should you be able to add Post fundings as part of the Post upload or should this be separate?	Yes!
2	Will the post funding information be available at the time of creating the posts?	Yes
3	What are the MVP fields for a Post Import template?
4	Should the MVP be to use the template to only create new Posts and consider update as a post-MVP future increment or the other way round?	Amend.

Row no.	Column heading	Add/Update/Matching Criteria	Mandatory	Rules	Questions for discussions	MVP (Y/N)
1	TIS_PostID	Matching Criteria	Y
1	National Post Number*

Add

~~Update~~

Y

~~Should 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 as a column.~~

~~If not, then:~~

~~the column should be mandatory on the template~~
~~It would be an Add type~~
The import will only be successful for the row if the NPN does not already exist, if already exist then throw an error in the downloadable template 'Cannot add post with this NPN as there are other posts with the same NPN'
The 'Manually edit NPN / Auto-generate NPN' will be automatically set to 'Manually edit'

2

Approved grade

*Y

Add

Update		Accepted values should match to one of the Grade reference table and are CURRENT	Validation in here to match that on the FE
3	Other grades

Add

Update	N	Comma separated to add multiple Accepted values should match to one of the Grade reference table and are CURRENT	Make clear that it is the grade name not abbreviation
4	Specialty

*

Add

Update	Y	Accepted values should match to one of the Specialty reference table and are CURRENT
5	Other specialties

Add

Update	N	Comma separated to add multiple Accepted values should match to one of the Specialty reference table and are CURRENT
6	Sub specialties

Add

Update

N

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?

Yes, but only when the PAG has reviewed and validated the current sub_spec list.

7

Training description

Add

Update		Freetext
8	Main site

*

Add

Update

Y

Accepted values should match to one of the SiteKnownAs from Site reference

table and are CURRENT

table and are CURRENT	Check that all 'SiteKnownAs' names have the site code afterwards - JW run report to check
9	Other sites

Add

Update	N	Comma separated to add multiple Accepted values should match to one of the SiteKnownAs from Site reference table and are CURRENT
10	Training body

Add

Update	N	Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT
11	Employing body

Add

Update	N	Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT
12	Programme name

Add

Update

N

If populated on template, Programme 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 as not all posts will be training posts so therefore not attached to a training programme.

However, when using the template, users should be conscious that this does need to be populated for the Placement Planning Tool to return the Post from the Programme view.

Can be made mandatory - what about existing posts?

Alice and James (Intrepid/TIS views for data audit will show posts with no programme attached)

13

Programme number

Add

Update

N

If populated on template, Programme 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 as not all posts will be training posts so therefore not attached to a training progamme.

However, when using the template, users should be conscious that this does need to be populated for the Placement Planning Tool to return the Post from the Programme view.

for discussion

Can be made mandatory - what about existing posts?

Alice and James (Intrepid/TIS views for data audit will show posts with no programme attached)

14

Owner

*

Add

Update	Y	Accepted values should match to one of Local Office reference table and are CURRENT.
15	Old post	Update	Is this required in a bulk create scenario? Yes and for amend
16	New post

Is this required in a bulk create scenario?Local post number

Update

Is this required in a bulk create

scenario?Post familyIs this required in a bulk create scenario?

#QuestionComments1Should you be able to add Post fundings as part of the Post upload or should this be separate?2Will the post funding information be available at the time of creating the posts?3What are the MVP fields for a Post Import template?4Should the MVP be to use the template to only create new Posts and consider update as a post-MVP future increment or the other way round?

Version	Old Version 30	New Version 31
Changes made by	Ashley Ransoo	Ashley Ransoo
Saved on	25 Jan 2019	25 Jan 2019

scenario? For amend

Local post number

Is this required in a bulk create scenario? No

Post family

Is this required in a bulk create scenario? No