Page Comparison

national post number
is training post

Allocation

main site
other sites
specialty
other specialties
sub-specialties (tbc)
approved grade
other grades

Ownership

post owner
employing body
training body
programmes
training description
status
new post
post family
local post no

Funding

funding types
funding start date
funding end date

History

placement history

102Drop Down or selection box with 3 options supernumerary millitary41416Would only populated N17Would only populated to new N5N Changing 69
- add multiple subsidiary grades (20)128 add multiple subsidiary sites (50)
- 8.5Y1519?D18?Y []SD dateEnd is not mandatoryN1

Order

Field name (V10)

DR field

Reference table

Example value

Other fields available in DR

Type (free text, drop down, check box) & Interaction

Mandatory (Y/N)

Validation / Error Messaging

Filter (Y/N)

Search (Y/N)

Sort (Y/N)

Summary (S) / Detail (D)

Notes

Delete field

14

Status

Yes

Fixed list - not a HEE reference table

Current

Drop-down, default to current

Y

n/a

Y

N

Y

SD

Statuses: Current, Inactive, Delete

1

National post no.

Yes

derived from the deanery, Site, Specialty and Grade tables

NTH/RTD01/080/STR/005

Auto-created number based on the managing local office and the Site, Specialty and Grade tables

Not editable
Not visible until post is created

Y

Error: must be unique

N

Y

SD

Auto-created number based on the local office of the creator and the Site, Specialty and Grade tables.

3

Suffix

Need to add (where required) upon creation of post number.

Manual addition so no field required for this

N

N/A

N

D

Options:

/S =

Supernumerary
/M =

Military
/A = Academic

9

Managing Deanery/LETB

Yes

LETB/Deanery

Health Education North East

Default to user's local office
Drop down to select others

Y

- Search on location acronyms
- must be entered before national post no can be generated

Y

N

Y

S/D

Needs to be called "Managing Local Office" in TIS

17

Post family

Keep this field until we see what is in DR2

15

Old post

Yes

Post list

NTH/RTD02/080/STR/002

Must be

autopopulated if this post had been converted from a previous post

or manually linked

Editable

Smart search/drop-down for manual linkage

Y

n/a

N

D

Need field to newly linked ID - TBD

16

New post

Yes

Post list

NTH/RTD02/080/STR/003

Must be

autopopulated if this post had been converted

from a

Editable

Smart search/drop-down for manual linkage

Y

n/a

N

D

Need field to prior linked ID - TBD

2

Main site located

Yes

Site

Royal Victoria Infirmary

Plus main site known as and main site number

- Smart search / drop down
- add multiple subsidiary sites (3)
- allow user to change first site

Y

N/A

N

Y

SD

New name: Site

NB: During edit journey, changing first site will impact national post no

, this should be flagged to user

3

Other sites

Yes

Site

Freeman Hospital

Plus other sites known as

Need to keep this field for multi-site posts

~~Lead site~~

~~Yes~~

~~Site~~

~~Royal Victoria Infirmary~~

~~Plus lead site known as and lead site number~~

~~Unsure how this works on V10 as seems to be a read only field~~

~~Yes~~

10

Employing Body

Yes

Trust

CDDFT - LET

Plus employing body known as and employing body trust number

- smart search / drop down
- autopopulate to Training Body
- add / remove

Y - when training post

N/A

N

D

11

Training Body

Yes

Trust

Newcastle upon Tyne Hospitals NHS FT

Plus training body known as and training body trust number

- smart search / drop down

Y - when training post

n/a

Y

N

Y

D

7

Approved Grade

Yes

Grade

Specialty Registrar

Plus approved grade abbr.

- smart search / drop down

Y

n/a

Y

N

SD

8

Other grades

Yes

Grade

ST1, ST2, ST3, ST4, ST5

Plus other grades names

- smart search / drop down
- add multiple subsidiary grades (20)

Need to keep this site for placement grade validation

4

Specialty

Yes

Specialty

Clinical Radiology

Plus specialty1number

- Smart search / drop down
-

allow user to change first specialty

Y

Only one specialty per post

Y

N

Y

SD

If first specialty is amended, it will impact the National Post No

5

Other specialties

Specialty

~~Yes~~

Clinical Oncology, Anaesthetics

- Smart search / drop down

N

Multi specialty selection

N

D

~~Yes~~

6

Sub specialties

Yes

Specialty

Neuroradiology

Plus subspecialties numbers

- Smart search / drop down
- allow user to change first specialty
- include "no subspecialty" option

N

Only one sub specialty per post

N

D

This field needs to remain for certain specialties which can offer sub-specialities
TBD further

13

Training description

Yes

Free text

Neuroradiology year 5 post

Free text (100 characters)

N

Error: character maximum

N

D

18

Local post no.

Free text

Free text (50 characters)

N

Error: character maximum

N

D

Keep this field until we see what is in DR2

~~Lead provider known as~~

~~London only - maybe outdated by the time TCS is released~~

~~Yes~~

~~Lead provider Name~~

~~Yes~~

~~Lead Provider~~

~~London only - maybe outdated by the time TCS is released~~

~~Yes~~

~~Lead provider trust number~~

~~London only - maybe outdated by the time TCS is released~~

~~Yes~~

Placement history

- Autopopulated
 - view only

Y

N/A

N

S/D (for current trainee only)

List of placements for each post - currently found in separate screen on V10 [PersonPlacement] - tech notes - just view the list of placements this post is linked to

.

Fields to be shown:

Trainee name
Date from
Date to
Placement grade
Placement specialty
Site
Placement Type
Whole time equivalent
Status

12

Programme

Programmes

Clinical Radiology

- smart search /

drop down

- link / unlink

N

Rule: only

link one

post to one

programme,

at a single

point in time

(multiple

posts can

be linked to

a single

Programme)

Error: this

post is

already

linked to

Programme

XXX, this

action will

unlink

(confirm/cancel

)

Y

N

Y

S/D

Programme or

programmes that the

post is attached to:

need to be able to

record the history of

this relationship

- There may come a

point in time where

this changes - should

be able to link a

single post to multiple

Programmes (to be

reviewed) -

tech

notes -> many to

many, one link active

at a time, via

Start date

01/04/2014

- calendar entry (as in Reval)

Y

Rule: date can be any time in the future or past, must be a valid date

N

D

Relates to, and should be re-named, Funding Start Date

End date

- calendar entry (as in Reval)

N

Rule: date can be any time in the future or past, must be a valid date

N

D

date

Funding types

Yes

Fixed list - not a HEE reference table

Tariff

- Smart search / drop down
 - add multiple funding types (5)??

Y

N/A

Y

N

Y

SD

Currently a Hicom Lookup Table, built in back end, requires new ref table
 Tech notes
  many to many, optional, interesting to get from intrepid

~~Funding type 2~~

~~Yes~~

~~Fixed list - not a HEE reference table~~

~~Trust~~

~~Yes~~

Issue

Yes

Reference Table

Funding

- Smart search / drop down

N

N/A

N

D

Funding comments

Free text

Funding provided indefinitely

Free text (100 characters)

N

N/A

N

D

Level of post

Yes

Tariff rate

ST1

- Smart search / drop down

Y

Rule: mandatory when funding type = "Tariff"

N

D

Select that scopes tariff rate, can only have one

~~Effective date from~~

~~Tariff rate~~

~~01/04/2014~~

~~Autopopulated~~

Y

~~Rule: brought in when triff rate is selected~~

N

D

~~Outstanding question - what happens when a tariff rate changes? Extra info visible when selecting a tariff rate~~

~~Effective date to~~

~~Tariff rate~~

~~Autopopulated~~

Y

~~Rule: brought in when triff rate is selected~~

N

D

~~Outstanding question - what happens when a tariff rate changes? Extra info visible when selecting a tariff rate~~

~~Tariff Rate~~

~~Yes~~

~~Tariff rate~~

~~37,503~~

~~Autopopulated~~
~~- editable~~

Y

~~Rule: when level of post is selected~~

N

D

~~display with dates, auto completed with level of post~~

~~Placement rate - Funded by~~

~~Yes~~

~~Combination of Trust and LETB/Deanery tables~~

~~Health Education North East~~

~~- Smart search / drop down~~

Y

~~Rule: mandatory when funding type = "Tariff"~~

N

D

~~one to many but the many are across two tables, tech notes - flatten this out into two columns~~

~~Placement rate - Provided to~~

~~Yes~~

~~Combination of Trust and LETB/Deanery tables~~

~~Newcastle upon Tyne Hospitals NHS FT~~

~~- Smart search / drop down~~

Y

~~Rule: mandatory when funding type = "Tariff"~~

N

D

~~one to many but the many are across two tables - flatten this out into two columns~~

~~Placement rate calculation~~

~~Yes~~

~~Placement Rate and MFF from Trust table~~

~~12400*1.035817~~

~~Autopopulated~~

Y

~~Rule: apply MFF based on Trust selected~~
~~Rule: apply placement rate held in ref table~~

N

D

Base placement rate (£[0]) * Market forces Factor (MFF) ([]) - taken from Placement Rate reference table -> tech notes -> if placement rate provided to is a trust, get a base rate + the modifier - display the results

~~Placement Rate~~

~~Yes~~

~~Placement Rate~~

~~12844.13~~

~~Autopopulated~~
~~- editable~~

Y

N

D

~~prepopulated with the above calculation but editable~~

~~Funding Organisations~~

~~Combination of Trust and LETB/Deanery tables~~

~~Health Education North East~~

~~- Smart search / drop down~~
~~- add multiple funding types (10)~~
~~- add / remove~~

Y

N

D

~~Can be multiple funding organisations for each post, can be trusts or deaneries -> split this into two many to many relationships~~

~~Amount £~~

~~Free number~~

~~21,000~~

~~editable~~

Y

~~Rule: cannot be higher than £200k~~

N

D

~~Tariff rates are subject to change - will need ability to update reference table and retain history~~

~~Percentage~~

~~Free text~~

~~56%~~

~~Need to check with local offices if maintaining the percentage is still valuable~~

~~For further discussion~~

~~Yes~~

~~Paymaster~~

~~Legacy field~~

~~Yes~~

~~Post status~~

~~Legacy field~~

~~Yes~~

~~Limited funding~~

~~Legacy field~~

~~Yes~~

~~Hospital scheme~~

~~Legacy field~~

~~Yes~~

~~V9 Sub specialties~~

~~Legacy field~~

~~Yes~~

~~V9 College 1~~

~~Legacy field~~

~~Yes~~

~~V9 College 2~~

~~Legacy field~~

~~Yes~~

~~V9 College 3~~

~~Legacy field~~

~~Yes~~

~~Pay scale~~

~~Legacy field~~

~~Yes~~

~~College no.~~

~~Legacy field~~

~~Yes~~

~~Post type~~

~~Legacy field~~

~~Yes~~

~~Accreditation type~~

~~Legacy field~~

~~Yes~~

~~Quality status~~

~~Legacy field~~

~~Yes~~

~~Full time equivalent~~

~~Legacy field~~

~~Yes~~

~~Post control form number~~

~~Legacy field~~

~~Yes~~

~~Core Specialty~~

~~Legacy field~~

~~Yes~~

~~ESR Position number~~

~~Where is this on V10 as it is in the repository but not on the post form.~~

~~Yes~~

2

Is training post

Drop-down

trainee
non-trainee

Only one can be selected

Yes

N/A

N

D

Where is this on V10 as it is in the repository but not on the post form.

Confirmation that the post is for trainee or non-trainee

19

Clinical Supervisors

Smart search drop down
add multiple

20

Education Supervisors

Smart search drop down
add multiple

21

Education Groups

Smart search drop down
add multiple

22

Rotations

Smart search drop down
add multiple

Versions Compared

Old Version 9

New Version Current

Key