Page content
...
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
| ||||||||||||||||||||||||||||||||||
1 | Suffix | See: TIS UI Fields - Dropdowns |
| N | Enabled NPN manual edit
Auto-generation NPN
| Enabled NPN manual edit
Auto-generation NPN
| 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 |
| N |
|
| Warning: If "No" selected, the NPN cannot be edited | ||||||||||||||||||||||||||||
3 | National post number | 'Enable/d NPN manually editing' No
'Enable/d NPN manually editing' Yes
| Y | Sort
| Enabled NPN manual edit
Autogeneration
| Enabled NPN manual edit
Autogeneration
| This field is required Only special characters allowed are / | The error message should only be displayed where "Enable/d NPN manually editing" = Yes | ||||||||||||||||||||||||||
Allocation
| ||||||||||||||||||||||||||||||||||
4 | Main site | See: TIS UI Fields - Dropdowns |
| Y (Primary Site) | Filter |
|
| This field is required | ||||||||||||||||||||||||||
5 | Other sites (optional) | See: TIS UI Fields - Dropdowns |
| N |
|
| 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 |
| Y (Primary Specialty | Filter |
|
| This field is required | ||||||||||||||||||||||||||
7 | Other specialities | See: TIS UI Fields - Dropdowns |
| N |
|
| 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 |
| N |
|
| 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 |
| Y | Filter |
|
| This field is required Warning: only Post grades can be selected | ||||||||||||||||||||||||||
10 | Other grades | See: TIS UI Fields - Dropdowns |
| N |
|
| Warning: only Post grades can be selected | |||||||||||||||||||||||||||
Ownership
| ||||||||||||||||||||||||||||||||||
11 | Owner | See: TIS UI Fields - Dropdowns |
| Y | Filter |
|
| This field is required | ||||||||||||||||||||||||||
12 | Employing body | See: TIS UI Fields - Dropdowns |
| N |
|
| This field is required | |||||||||||||||||||||||||||
13 | Training body | See: TIS UI Fields - Dropdowns |
| N |
|
| This field is required | |||||||||||||||||||||||||||
14 | Programme name* | See: TIS UI Fields - Dropdowns |
| Y | Filter |
|
| This field is required | ||||||||||||||||||||||||||
15 | Training description |
| N |
|
| Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) | ||||||||||||||||||||||||||||
18 | Status | See: TIS UI Fields - Dropdowns |
| Y | Filter |
|
| This field is required | ||||||||||||||||||||||||||
19 | Old post |
| N |
|
| |||||||||||||||||||||||||||||
20 | New post |
| N |
|
| |||||||||||||||||||||||||||||
21 | Post family |
| N |
|
| JW to discuss with SMEs | ||||||||||||||||||||||||||||
22 | Local post number |
| N |
|
| |||||||||||||||||||||||||||||
Funding (Needs to be discussed with SMEs - particularly EM & LASE)
| ||||||||||||||||||||||||||||||||||
23 | Funding type | See: TIS UI Fields - Dropdowns |
| Y | Filter |
|
| This field is required | ||||||||||||||||||||||||||
24 | If 'Other', please specify |
| N | If Funding type is "Other"
If Funding type is not "Other"
| If Funding type is "Other"
If Funding type is not "Other"
| Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) | ||||||||||||||||||||||||||||
25 | Funding body / organisation | See: TIS UI Fields - Dropdowns |
| N |
|
| This field is required | Should be pulling from "Funding Organisation table" | ||||||||||||||||||||||||||
26 | Start date |
| N | If Funding type is "No value provided"
If Funding type is not "No value provided"
|
| This field is required Only special characters allowed / | ||||||||||||||||||||||||||||
27 | End date |
| N | If Funding type is "No value provided"
If Funding type is not "No value provided"
| If Funding type is "No value provided"
If Funding type is not "No value provided"
| This field is required Only special characters allowed / | ||||||||||||||||||||||||||||
Rotation
| ||||||||||||||||||||||||||||||||||
29 | Rotation name |
| N |
|
| Warning: Only rotations from within the same programme as the post can be selected | ||||||||||||||||||||||||||||
History (Table)
| ||||||||||||||||||||||||||||||||||
30 | Trainee full name |
| Y (Current Trainee) | Sort Max 1 current trainee displayed in list page |
|
| ||||||||||||||||||||||||||||
31 | Start date |
| N |
|
| |||||||||||||||||||||||||||||
32 | End date |
| N |
|
| |||||||||||||||||||||||||||||
33 | Main site |
| N |
|
| |||||||||||||||||||||||||||||
34 | Main specialty |
| N |
|
| |||||||||||||||||||||||||||||
35 | Placement grade |
| N |
|
| |||||||||||||||||||||||||||||
36 | Placement type |
| N |
|
| |||||||||||||||||||||||||||||
37 | Status |
| N |
|
|
...
Row no. | Column heading | Add/Update/Matching Criteria | Mandatory | Rules | Questions for discussions | MVP (Y/N) | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | National Post Number* | Add | Y | Should be a Post that does not already exist on TIS. Should not appear more than once on the same template being uploaded. | 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. 26/11/2019: JamesH - No to auto generation and yes to the below.
| |||||||||
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 |
| 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 |
| ||||||||||
6 | Sub specialties | Add | N |
| 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 (Known as)* | 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 (Known as) | Add | N |
| ||||||||||
10 | Training body* | Add | Y | Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT | Not currently mandatory on TIS, but need to be made mandatory across the board (BE, FE, Bulk Upload) - Ticket? | |||||||||
11 | Employing body* | Add | Y | Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT | Not currently mandatory on TIS, but need to be made mandatory across the board (BE, FE, Bulk Upload) - Ticket? | |||||||||
12 | Programme name* (Use TIS_Programme_ID* in favour of this) | 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) Not currently mandatory, but need to be made mandatory across the board (BE, FE, Bulk Upload) - Ticket? | ||||||||
13 | Programme number* (Use TIS_Programme_ID* in favour of this) | 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) Not currently mandatory, but need to be made mandatory across the board (BE, FE, Bulk Upload) - Ticket? | ||||||||
14 | TIS_Programme_ID* | Add | Y |
| Instead of Story to make this field mandatory from all journeys:
| |||||||||
15 | Owner* | Add | Y | Accepted values should match to one of Local Office reference table and are CURRENT. | ||||||||||
16 | Old post | Add | N | Accepted values should match to one of existing NPN's held on TIS. | Is this required in a bulk create scenario? Yes |
...
Row no. | Column heading | Add/Update/Matching Criteria | Mandatory | Rules | Questions/Notes for discussions |
---|---|---|---|---|---|
1 | TIS_PostID* | Matching Criteria | Y |
| |
2 | Approved grade | Update | N |
| |
3 | Other grades | Update (replace all existing values) | N |
| |
4 | Specialty | Update | N |
| |
5 | Other specialties | Update (replace all existing values) | N |
| |
6 | Sub specialties | Update (replace all existing values) | N |
| Should this be constrained to specialty type SUB_SPECIALTY? Eventually, but only when the PAG has reviewed and validated the current sub_spec list. For MVP accepted values will match to one of the Specialty reference table and are CURRENT |
7 | Training description | Update | N | Freetext | |
8 | Main site | Update | N |
| Check that all 'SiteKnownAs' names have the site code afterwards (follow a standard convention) - JW run report to check |
9 | Other sites | Update (replace all existing values) | N |
| |
10 | Training body | Update | N |
| |
11 | Employing body | Update | N |
| |
|
|
| |||
|
|
| |||
12 | TIS_Programme_ID | Update (replace all existing values) | N |
| |
14 | Owner | Update | N |
| |
15 | Rotation | Update (replace all existing values) | N |
| |
16 | Status | Update | N |
| QUESTION: Is it a requirement to bulk update the status of a post e.g. from Current to Inactive? JW - Yes, this is a requirement |
17 | Old Post | Update | N |
| |
18 | Funding type | Add | N |
| |
19 | Funding type - If 'Other' please specify | Add | N | Free text
| |
20 | Funding Body | Add | N |
| |
21 | Date From | Add | N | Date format DD/MM/YYYY
| |
22 | Date to | Add | N | Date format DD/MM/YYYY |
...
Row no. | Column heading | Add/Update/Matching Criteria | Mandatory | Rules | Questions/Notes for discussions | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TIS_PostFunding_ID* | Matching Criteria | Y |
| |||||||||
2 | TIS_Post_ID* | Matching Criteria | Y |
|
| ||||||||
3 | Funding type | Update | N |
| |||||||||
4 | Funding type - If 'Other' please specify | Update | N | Free text
| |||||||||
5 | Funding Body | Update | N |
| |||||||||
6 | Date From | Update | N | Date format DD/MM/YYYY
| |||||||||
7 | Date to | Update | N | Date format DD/MM/YYYY |
Post Funding FE Fields Validation
Field name | Reference Table | Initial value in dropdown | Proposed value in dropdown | Current value in dropdown | Initial FE Validation & Rules | Proposed FE Validation Rules | Current FE Validation & Rules | Error Messages | List Page?(Y/N) | List Page Rules (Sort/Filter) | Comment |
---|---|---|---|---|---|---|---|---|---|---|---|
Funding type |
|
|
|
| In addition to the Initial FE Validation Rules;
|
|
| Y | Filter |
https://hee-tis.atlassian.net/browse/TIS21-4801
| |
Funding Details | N/A | N/A | N/A |
Then the ‘Funding Details’ field is greyed out; don’t accept text. If Funding type is "Other"
Then the ‘Funding Details’ field is NOT greyed out; accept text.
If Funding type is not "Other"
|
In addition to the Initial FE Validation Rules;
Then the ‘Funding Details’ field is greyed out; don’t accept text.
Then the ‘Funding Details’ field is NOT greyed out; accept text. |
Then the ‘Funding Details’ field is greyed out; don’t accept text. If Funding type is "Other"
Then the ‘Funding Details’ field is NOT greyed out; accept text.
If Funding type is not "Other"
| Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) | N |
| ||
Funding body | No value display, it is smart search |
Then the ‘Funding body’ field is NOT greyed out; accept text | Mandatory: No In addition to the Initial FE Validation Rules;
Then the ‘Funding body’ field is NOT greyed out; accept text |
Then the ‘Funding body’ field is NOT greyed out; accept text | This field is required | N |
| ||||
Start date |
Then the ‘Start date’ field is greyed out; don’t accept text.
Then the ‘Start date’ field is NOT greyed out; accept text.
|
In addition to the Initial FE Validation Rules:
Then the ‘Start date’ field is NOT greyed out; accept text. |
Then the ‘Start date’ field is greyed out; don’t accept text.
Then the ‘Start date’ field is NOT greyed out; accept text.
|
| N |
| |||||
End date |
Then the ‘End date ’ field is greyed out; don’t accept text.
Then the ‘End date ’ field is NOT greyed out; accept text.
| Apart form the list in the Initial FE Validation & Rules, the following should be added
Inputting Placement: Validation message for a posts with status ‘Inactive’/funding end date expires OR inadequate funding end date when inputting placement against an ‘inactive’ post ( using UI/PPT or Placement bulk upload) In addition to the Initial FE Validation Rules;
Then the ‘End date ’ field is NOT greyed out; accept text. |
Then the ‘End date’ field is greyed out; don’t accept text.
Then the ‘End date’ field is NOT greyed out; accept text.
|
| N |
https://hee-tis.atlassian.net/browse/TIS21-4801
| |||||
This is new field to be created; Sub-category | To be created | None because it is a new filed to be created. |
| None because it is a new filed to be created. |
| To be updated after implementation | Funding Type Sub-category | ||||
This is new field to be created; Funding Reason | To be created | None because it is a new filed to be created. |
| None because it is a new filed to be created. |
| To be updated after implementation | Funding Type- Funding reason; |