Groupings should be as follows:
- Trainee Name (1) & National Post Number (2) as title
- Location: (3) - (6)
- Programme: (7) - (10)
- Status: (11) - (15)
Field Sequence | 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) | List (S) / Detail (D) | Notes |
1 | Trainee Name | Smart search drop down | Y | ||||||||||
2 | National Post Number | EOE/RGT00/030/STR/001 | Post selected from post list. | Y | Must be a post that already exists. | N | N | ||||||
12 | Status | Past/Current/Future | derived from dates | Y | derived | ||||||||
6 | Site | Site | Addenbrookes Hospital | derived from the post, can be overwritten | Y | derived | |||||||
REMOVE | ITP Post | tick box | N | Get Russel to check data. Do we need to record ITP posts? | |||||||||
13 | Managing Local Team (LOCAL OFFICE) | HEEOE | derived from post | Y | derived | ||||||||
REMOVE | Region | agreeing to remove. | |||||||||||
7 | Grade | Grade | ST1 | drop down | Y | derived but can be overwritten | |||||||
8 | Specialty | Specialty | Cardiology | drop down | Y | derived from post, can be overwritten | |||||||
9 | other specialties | Specialty | General Medicine | drop down | N | restricted to options from specialty ref table | other sites to work in the same way as other speciality. | ||||||
REMOVE | Sub Specialties | Paediatric neuroscience | drop down | N | restricted to options from specialty ref table | ||||||||
3 | Date From (START DATE) | calendar picker | Y | date from must be before the date to. | |||||||||
4 | Date To (END DATE) | calendar picker | Y | date to must be after date from | |||||||||
11 | Placement Type | Placement Type | Sick Leave | drop down | Y | restricted to options from placement type ref table | |||||||
REMOVE | Honorary | Tick box | No SMLs use this tick box. check with Russel. | ||||||||||
5 | Whole Time Equivalent | 0.6 | free text | Y | must be a number between 0 and 1, Default value = 1 | ||||||||
10 | Clinical Supervisor | Randy Jacobs | drop down | N | must be a clinical supervisor | Not Mandatory. | |||||||
REMOVE | Educational Supervisor | Brian Boomsuckle | drop down | must be an ed supevsior | SMLs agree that Programme membership is more common sense. Need historical info. | ||||||||
15 | Training Description | free text, max 100 characters | N | N/A | |||||||||
14 | Local Post Number | derived from post | derived from post | N | N/A | ||||||||
REMOVE | LTFT Confirmation Start Date | calendar picker | N | need to change wording. This means that the funding has been agreed. | |||||||||
REMOVE | Slot Share | tick box | N | can we derive this from 2 trainees being in a concurrent placement. | |||||||||
REMOVE | MIP (Months In Post) | 6 | Can we remove? Explore to make more useful. | ||||||||||
REMOVE | SLA Received Date | calendar picker | N | no one uses. get Russel to check. |
Add Comment