Placements - Field Validation

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)

Summary (S) / Detail (D)

Notes

1

National Post Number

EOE/RGT00/030/STR/001

Post selected from post list.

Y

Must be a post that already exists.

N

10

Status

Past/Current/Future

derived from dates

Y

derived

4

Site

Addenbrookes Hospital

derived from the post, can be overwritten

Y

derived

?

ITP Post

tick box

N

Can we remove?

11

Managing Deanery

HEEOE

derived from post

Y

derived

?

Region

Can we remove?

5

Grade

ST1

drop down

Y

derived but can be overwritten

6

Specialty

Cardiology

drop down

Y

derived from post, can be overwritten

7

other specialties

Specialty

General Medicine

drop down

N

restricted to options from specialty ref table

8

Sub Specialties

Paediatric neuroscience

drop down

N

restricted to options from specialty ref table

2

Date From

calendar picker

Y

date from must be before the date to.

3

Date To

calendar picker

Y

date to must be after date from

9

Placement Type

Sick Leave

drop down

Y

restricted to options from placement type ref table

Honorary

Tick box

Can we remove?

12

Whole Time Equivalent

0.6

free text

Y

must be a number between 0 and 1, Default value = 1

13

Clinical Supervisor

Randy Jacobs

drop down

Y

must be a clinical supervisor

?

Educational Supervisor

Brian Boomsuckle

drop down

must be an ed supevsior

Proposal is to assign Ed Supervisor at Programme level. Can remove this from there

14

Training Description

free text

N

N/A

15

Local Post Number

free text

N

N/A

LTFT Confirmation Start Date

calendar picker

N

Can we remove?

Slot Share

tick box

N

Can we remove?

MIP (Months In Post)

6

Can we remove?

SLA Received Date

calendar picker

N

Can we remove?