...
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 NameSmart 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 |
| Y | derived | |||||||||
6 | Site | Site | Addenbrookes Hospital | derived
| Y | derived | ||||||||
13 | Managing Local Team(LOCAL OFFICE) Change to "Owner" | HEEOE | derived
| Y | derived | |||||||||
7 | Grade | Grade | ST1 | drop
| Y | derived but can be overwritten | ||||||||
8 | Specialty | Specialty | Cardiology |
| Y | derived from post, can be overwritten | ||||||||
9 | other Other specialties | Specialty | General Medicine |
| N | restricted to options from specialty ref table | other sites to work in the same way as other speciality. | |||||||
Sub | ||||||||||||||
3 | Date Date From (START DATE) | calendar
| Y | date from must be before the date to. | ||||||||||
4 | Date To (END DATE) | calendar
| Y | date to must be after date from | ||||||||||
11 | Placement Placement Type | Placement Type | Sick Leave | drop
| Y | restricted to options from placement type ref table | ||||||||
5 | Whole Whole Time Equivalent | 0.6 | free
| Y | must must be a number between 0 and 1, Default value = 1 | |||||||||
10 | Clinical Supervisor | Randy Jacobs | drop
| N | must be a clinical supervisor | Not Mandatory. | ||||||||
| ||||||||||||||
15 | Training Description | free
| N | N/A | ||||||||||
14 | Local Post Number | derived from post | derived
| N | N/A | |||||||||
| ||||||||||||||