| 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 |
| 10 | 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 |
| Y | Error: must be unique | N | Y | Y | SD | Auto-created number based on the local office of the creator and the Site, Specialty and Grade tables. | ||
| 3 | Suffix | Smart search drop down Default: /A | Y | N/A | N | N | N | D | Options:
| |||||
| 4 | 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 | D | Needs to be called "Managing Local Office" in TIS | ||
| 14 | Post family | Keep this field until we see what is in DR2 | ||||||||||||
| 16 | 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 | N | N | D | Need field to newly linked ID - TBD | ||
| 17 | New post | Yes | Post list | NTH/RTD02/080/STR/003 | 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 | N | N | D | Need field to prior linked ID - TBD | ||
| 5 | 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 | Y | N | Y | SD | New name: Site Changing first site will impact national post no | |
| 6 | Other sites | Yes | Site | Freeman Hospital | Plus other sites known as | Need to keep this field for multi-site posts | ||||||||
| 9 | 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 | N/A | N | N | 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 | n/a | Y | N | Y | D | ||
| 7 | Approved Grade | Yes | Grade | Specialty Registrar | Plus approved grade abbr. | - smart search / drop down - add multiple subsidiary grades (20) | Y | n/a | Y | N | N | SD | ||
| 12 | Other grades | Yes | Grade | ST1, ST2, ST3, ST4, ST5 | Plus other grades names | Need to keep this site for placement grade validation | ||||||||
| 8 | Specialty | Yes | Specialty | Clinical Radiology | Plus specialty1number | - Smart search / drop down - add multiple subsidiary sites (50) - 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 | |
| 8.5 | Sub specialties | Yes | Specialty | Neuroradiology | Plus subspecialties numbers | - Smart search / drop down - allow user to change first specialty - include "no subspecialty" option | Y | Only one sub specialty per post | N | N | N | D | This field needs to remain for certain specialties which can offer sub-specialities TBD further | |
| 18 | Training description | Yes | Free text | Neuroradiology year 5 post | Free text (100 characters) | N | Error: character maximum | N | N | N | D | |||
| 19 | Local post no. | Free text | Free text (50 characters) | N | Error: character maximum | N | N | N | D | Keep this field until we see what is in DR2 | ||||
| 15 | Placement history | - Autopopulated - view only | Y | N/A | N | N | N | D | 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 | |||||
| 13 | Programmes | Clinical Radiology | - smart search / drop down - link / unlink | Y | 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 | SD | 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 date | ||||
| 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 | N | 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 | N | N | D | End date is not mandatory | ||||||
| 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 | |||
| Issue | Yes | Reference Table | Funding | - Smart search / drop down | N | N/A | N | N | N | D | ||||
| Funding comments | Free text | Funding provided indefinitely | Free text (100 characters) | N | N/A | N | N | N | D | |||||
| Level of post | Yes | Tariff rate | ST1 | - Smart search / drop down | Y | Rule: mandatory when funding type = "Tariff" | N | N | 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 | N | 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 | N | 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 | N | 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 | N | 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 | N | 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 | N | 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 | N | 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 | N | 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 | N | N | D | Tariff rates are subject to change - will need ability to update reference table and retain history | ||||
| 2 | Is training post | Drop-down
Only one can be selected | Yes | N/A | N | N | 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 | |||||
Manage space
Manage content
Integrations
0 Comments