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

Status

Past/Current/Future

derived from dates

Y

derived

Site

Addenbrookes Hospital

derived from the post, can be overwritten

Y

derived

ITP Post

tick box

N

Managing Deanery

HEEOE

derived from post

Y

derived

Region

Grade

ST1

drop down

Y

derived but can be overwritten

Specialty

Cardiology

drop down

Y

derived from post, can be overwritten

other specialties

Specialty

General Medicine

drop down

N

restricted to options from specialty ref table

Sub Specialties

Paediatric neuroscience

drop down

N

restricted to options from specialty ref table

Date From

calendar picker

Y

date from must be before the date to.

Date To

calendar picker

Y

date to must be after date from

Placement Type

Sick Leave

drop down

Y

restricted to options from placement type ref table

Honorary

Tick box

Whole Time Equivalent

0.6

free text

Y

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

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

Training Description

free text

N

N/A

Local Post Number

free text

N

N/A

LTFT Confirmation Start Date

calendar picker

N

Slot Share

tick box

N

MIP (Months In Post)

6

SLA Received Date

calendar picker

N