Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 61 Next »

Page content

Posts - Field Validation

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    TISDEV-4748 - Getting issue details... STATUS  /  TISDEV-4747 - Getting issue details... STATUS
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: 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  TISDEV-4749 - Getting issue details... STATUS  /  TISDEV-4750 - Getting issue details... STATUS
4Main 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 

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
  • 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 
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 down 
  • Smart search 
  • MANDATORY
YFilter 
  • Type: Smart search 
  • Mandatory: Yes
  • Editable: Yes
  • Limit to Post Grades
  • Type: Smart search 
  • Mandatory: Yes
  • Editable: Yes
  • Limit to Post Grades

This field is required 


Warning: only Post grades can be selected



10Other 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: No
  • Editable: Yes
  • Add multiple/all
  • Remove one/all
  • Limit to Post Grades
Warning: only Post grades can be selected

Ownership  TISDEV-4752 - Getting issue details... STATUS  /  TISDEV-4751 - Getting issue details... STATUS  ,  TISNEW-3651 - Getting issue details... STATUS
11OwnerSee: TIS UI Fields - Dropdowns
  • Drop down
  • Smart search 
  • MANDATORY 
YFilter 
  • Type: Drop down, current only
  • Mandatory: Yes
  • Editable: Yes
  • Type: Drop down, current only
  • Mandatory: Yes
  • Editable: Yes
This field is required 

12Employing bodySee: 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 

13Training bodySee: 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 

14Programme name* See: TIS UI Fields - Dropdowns
  • Drop down
  • Smart search 
  • + or - 
YFilter
  • Type: Drop down -  current only
    Mandatory: Yes -  TISNEW-3651 - Getting issue details... STATUS  
  • 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
  • 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 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 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 characters none
  • Mandatory: No
  • Editable: Yes



Funding (Needs to be discussed with SMEs - particularly EM & LASE)  TISDEV-4753 - Getting issue details... STATUS  /  TISDEV-4754 - Getting issue details... STATUS
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
  • 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 (   )

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 "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  TISDEV-4755 - Getting issue details... STATUS  /  TISDEV-4756 - Getting issue details... STATUS
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)  TISDEV-4757 - Getting issue details... STATUS  /  TISDEV-4758 - Getting issue details... STATUS
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 create column headers - validations

This was reviewed with data leads and there's no no dissenters on the columns and validations to include. 

TISNEW-3650 - Getting issue details... STATUS

TISNEW-3651 - Getting issue details... STATUS


Row no.Column headingAdd/Update/Matching CriteriaMandatoryRulesQuestions for discussionsMVP (Y/N)
1National Post Number*AddY

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. 

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'

2Approved grade*AddYAccepted values should match to one of the Grade reference table and are CURRENTValidation in here to match that on the FE
3Other gradesAddN
  • Semicolon ( ; ) 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
4Specialty*AddYAccepted values should match to one of the Specialty reference table and are CURRENT

5Other specialtiesAddN
  • Semicolon ( ; ) to add multiple
  • Accepted values should match to one of the Specialty reference table and are CURRENT


6Sub specialtiesAddN
  • Semicolon ( ; ) 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. 


7Training descriptionAdd
Freetext

8Main site (Known as)*AddYAccepted values should match to one of the SiteKnownAs from Site reference table and are CURRENTCheck that all 'SiteKnownAs' names have the site code afterwards - JW run report to check
9Other sites (Known as)AddN
  • Semicolon ( ; ) to add multiple
  • Accepted values should match to one of the SiteKnownAs from Site reference table and are CURRENT


10Training body*AddYAccepted 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?
11Employing body*AddYAccepted 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)

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

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

14TIS_Programme_ID*AddY
  • Semicolon ( ; ) separated to add multiple
  • Accepted values should match to CURRENT TIS Programme IDs.

Instead of Progamme Name and Programme Number as separate columns on the template, we could do TIS_Programme_ID. We have used TIS_Programme_ID on bulk post update, so to keep consistent with and hopefully easier to match on.

Story to make this field mandatory from all journeys:

TISNEW-3651 - Getting issue details... STATUS


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

16Old postAddNAccepted values should match to one of existing NPN's held on TIS.Is this required in a bulk create scenario? Yes 


Questions and Assumptions

#QuestionComments
1Should you be able to add Post fundings as part of the Post upload or should this be separate?Yes!
2Will the post funding information be available at the time of creating the posts?Yes
3What are the MVP fields for a Post Import template?Update template is MVP. 
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?Amend. 

Posts - Bulk Update column headers - validations

Note: Through the use of the bulk update function the NPN will not change.

AR: The Update template will be used to update existing TIS Posts details and also to add Rotations and Funding episodes to them.

TISNEW-2628 - Getting issue details... STATUS

TISNEW-2672 - Getting issue details... STATUS

TISNEW-2673 - Getting issue details... STATUS


Row no.Column headingAdd/Update/Matching CriteriaMandatoryRulesQuestions/Notes for discussions
1TIS_PostID*Matching CriteriaY
  • Should match to one of TIS_PostID's

2Approved gradeUpdateN
  • Accepted values should match to one of the Grade reference table and are CURRENT
  • Validation throughout matches the validation on the TIS Post front end

3Other gradesUpdate (replace all existing values)N
  • Comma separated to add multiple
  • Accepted values should match to one of the Grade names in the reference table and are CURRENT (NOTE: abbreviations will not be accepted to match the FE validation)


4SpecialtyUpdateN
  • Accepted values should match to one of the Specialty reference table and are CURRENT

5Other specialtiesUpdate (replace all existing values)N
  • Comma separated to add multiple
  • Accepted values should match to one of the Specialty reference table and are CURRENT


6Sub specialtiesUpdate (replace all existing values)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?

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


7Training descriptionUpdateNFreetext
8Main siteUpdateN
  • 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 (follow a standard convention) - JW run report to check
9Other sitesUpdate (replace all existing values)N
  • Comma separated to add multiple
  • Accepted values should match to one of the SiteKnownAs from Site reference table and are CURRENT


10Training bodyUpdateN
  • Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT

11Employing bodyUpdateN
  • Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT

12Programme name

Update

AR 22/03: This is being dscussed in DQ channel.

N
  • If populated on template, Programme Name and Number should both match to one of the existing programmes on TIS and are CURRENT.

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. 

Intrepid/TIS views for data audit will show posts with no programme attached

13Programme number

Update

AR 22/03: This is being dscussed in DQ channel.

N
  • If populated on template, Programme Name and Number should both match to one of the existing programmes on TIS and are CURRENT.

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. 

Intrepid/TIS views for data audit will show posts with no programme attached

12TIS_Programme_IDUpdate (replace all existing values)N
  • Comma separated to add multiple
  • Accepted values should match to CURRENT TIS Programme IDs.


14OwnerUpdateN
  • Accepted values should match to one of Local Office reference table and are CURRENT. 

15RotationUpdate (replace all existing values)N
  • Comma separated to add multiple
  • Accepted values should match to one of the CURRENT Rotations from the Rotation list.
  • The rotations list is populated with only those that match Programme name and Number in the UI - Accepted values should therefore be one of those that match the Programme Name and Number linked to the TIS_PostID. 



16StatusUpdateN
  • Accepted values should match to one of the allowed Status' and are CURRENT. 

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

17Old PostUpdateN
  • Accepted values should match to one of existing NPN's held on TIS.

18Funding typeAddN
  • Accepted values should match to one of Funding Type reference table and are CURRENT. 
  • Cannot be left blank on the template, if one of 20-22 is populated on template.
  • Can only add one Funding episode from one row of data from the template, for multiple episodes multiple rows for the same TIS_PostID is required.

19Funding type - If 'Other' please specifyAddN

Free text

  • Only use when Funding Type = Other



20Funding BodyAddN
  • Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT

21Date FromAddN

Date format DD/MM/YYYY

 



22Date toAddN

Date format DD/MM/YYYY




Post Fundings - Bulk Update Columns Headers - Validations 

TISNEW-3248 - Getting issue details... STATUS

Ashley Ransoo and Alistair Pringle (Unlicensed) to run through with Data leads / stakeholders.- Done on 19/08 - Data leads happy with the below.


Row no.Column headingAdd/Update/Matching CriteriaMandatoryRulesQuestions/Notes for discussions
1TIS_PostFunding_ID*Matching CriteriaY
  • Should match to one of TIS_PostFundingID's

2Funding typeUpdateN
  • Accepted values should match to one of Funding Type reference table and are CURRENT. 
  • Can only update one Funding episode from one row of data from the template, for multiple episodes of the same post, multiple rows for each TIS_PostFunding_ID is required.

3Funding type - If 'Other' please specifyUpdateN

Free text

  • Only use when Funding Type = Other



4Funding BodyUpdateN
  • Accepted values should match to one of the TrustKnownAs from Trust reference table and are CURRENT

5Date FromUpdateN

Date format DD/MM/YYYY

 



6Date toUpdateN

Date format DD/MM/YYYY





  • No labels