Assessments - Field Validation NEW (draft)

Outstanding Questions

should there be a list page?
should assessment and trainee IDs be displayed?

Field Sequence	Field Name	Reference Table	Current FE Validation / Rules	List Page (Y/N)	Proposed FE Validation/Rules	Proposed BE Validation / Rules	Error Messages	Notes
L3: Event
1	Assessment ID	N/A		TBC
2	Trainee ID			TBC	drop down list if multiple derived from Person record MANDATORY (to select 1)	derived from Person record limit to registration fields entered on Person records	N/A
3	Trainee First name		Derived from Person Record		derived from Person record non-editable	derived from Person record non-editable	N/A
4	Trainee Surname		Derived from Person Record		derived from Person record non-editable	derived from Person record non-editable	N/A
5	Type		Drop down MANDATORY		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	An entry must be made to create or update the record
6	Status		Drop down		drop down limited to reference table limited to current values only allow blank	drop down limited to reference table limited to current values only allow blank	Only entries from the reference table can be entered
7	Programme name		Drop down		drop down limited to reference table limited to current values only MANDATORY	drop down limited to reference table limited to current values only MANDATORY	Only entries from the reference table can be entered
8	Programme number		Auto-populated from Programme name Non-editable		derived from Person record drop down list if multiple select 1 only MANDATORY	derived from Person record drop down list if multiple select 1 only MANDATORY	N/A
9	Review date		Free text - or calendar picker Date format DD/MM/YYYY		Free text - or calendar picker Date format DD/MM/YYYY can be any date in the past or future allow blank	Free text - or calendar picker Date format DD/MM/YYYY can be any date in the past or future allow blank	Valid date format must be entered
L3: Pre-Assessment Detail
10	Curriculum name		Drop down MANDATORY		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	TBC if mandatory
11	Curriculum start date		Autofill Non-editable		Free text - or calendar picker Date format DD/MM/YYYY allow blank	Free text - or calendar picker Date format DD/MM/YYYY allow blank	Valid date format must be entered
12	Curriculum end date		Autofill Non-editable		Free text - or calendar picker Date format DD/MM/YYYY allow blank	Free text - or calendar picker Date format DD/MM/YYYY allow blank	Valid date format must be entered
13	Curriculum speciality		Autofill Non-editable		Free text - or calendar picker Date format DD/MM/YYYY allow blank	Free text - or calendar picker Date format DD/MM/YYYY allow blank	Valid date format must be entered
14	Curriculum sub-type		Autofill Non-editable		derived from TBC non-editable	derived from TBC non-editable	N/A
14	Period covered from		Free text - or calendar picker Date format DD/MM/YYYY		Free text - or calendar picker Date format DD/MM/YYYY allow blank	Free text - or calendar picker Date format DD/MM/YYYY allow blank	Valid date format must be entered
15	Period covered to		Free text - or calendar picker Date format DD/MM/YYYY		Free text - or calendar picker Date format DD/MM/YYYY allow blank	Free text - or calendar picker Date format DD/MM/YYYY allow blank	Valid date format must be entered
16	Portfolio review date		Free text - or calendar picker Date format DD/MM/YYYY		Free text - or calendar picker Date format DD/MM/YYYY allow blank	Free text - or calendar picker Date format DD/MM/YYYY allow blank	Valid date format must be entered
17	WTE months OOPR/T during period		Autofill Non-editable		derived from TBC non-editable	derived from TBC non-editable	N/A
18	Months OOPR/OOPT counted training		0-9		derived from TBC non-editable	derived from TBC non-editable	N/A
19	PYA		Autofill Drop down		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	Only entries from the reference table can be entered	Should this be editable, and/or derived?
20	Grade at the time		Autofill Non-editable		derived from Person record non-editable in Assessment record	derived from Person record non-editable in Assessment record	TBC
21	Days out of training		0-9		derived from TBC non-editable	derived from TBC non-editable	TBC
L3: Pre-assessment Detail
22	Outcome		Drop down MANDATORY		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	Only entries from the reference table can be entered
23	Under appeal		Autofill Editable Drop down		TBC	TBC	Only entries from the reference table can be entered	Review this field in Prod
24	Reason		Drop down MANDATORY if Outcome is 'Not Assessed', otherwise non-editable		drop down limited to reference table limited to current values only MANDATORY if Outcome is 'Not Assessed', otherwise non-editable	drop down limited to reference table limited to current values only MANDATORY if Outcome is 'Not Assessed', otherwise non-editable	Only entries from the reference table can be entered
25	Completion of training date (prior to review)		Autofill Non-editable		Free text - or calendar picker Date format DD/MM/YYYY	Free text - or calendar picker Date format DD/MM/YYYY	Valid date format must be entered	review this field in Prod
26	10% audit - lay member		Autofill Drop down		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	Only entries from the reference table can be entered	review this field in Prod
27	External trainer		Autofill Drop down		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	Only entries from the reference table can be entered
28	Grade at next rotation		Drop down		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	Only entries from the reference table can be entered
29	Trainee notified of outcome		Autofill Editable Drop down		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	Only entries from the reference table can be entered
30	Next review date		Free text - or calendar picker Date format DD/MM/YYYY		Free text - or calendar picker Date format DD/MM/YYYY	Date format DD/MM/YYYY	Valid date format must be entered	review this field
31	Comments		Free text		free text text already input visible even when not being edited	free text text already input visible even when not being edited	N/A
Blue sub-section: Academic Progression (within Pre-assessment Detail)
32	Academic curriculum assessed		Autofill Non-editable		TBC	TBC		review this field
33	Academic outcome		Drop down MANDATORY		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	Only entries from the reference table can be entered
Blue sub-section: Supplementary Detail (within Pre-assessment Detail)
34	Detailed reason		Free text		free text text already input visible even when not being edited	free text edits add to existing data	N/A	review this field
35	Mitigating circumstances		Free text		free text text already input visible even when not being edited	free text edits add to existing data	N/A	review this field
36	Competences which need to be developed by next ARCP		Free text		free text text already input visible even when not being edited	free text edits add to existing data	N/A	review this field
37	Other recommended actions		Free text		free text text already input visible even when not being edited	free text edits add to existing data	N/A	review this field
38	Recommended additional training time (if required)		Free text		free text text already input visible even when not being edited	free text edits add to existing data	N/A	review this field
39	Additional comments from the panel		Free text		free text text already input visible even when not being edited	free text edits add to existing data	N/A	review this field
L3: Re-validation
40	Known concerns		Drop down No default?		drop down limited to reference table limited to current values only	drop down limited to reference table limited to current values only	Only entries from the reference table can be entered
41	Concern summary		Free text		free text text already input visible even when not being edited	free text edits add to existing data	N/A	Should this be editable?
42	Responsible officer comments		Free text		free text text already input visible even when not being edited	free text edits add to existing data	N/A	Should this be editable?

Assessment outcomes and reasons

Assessment outcomes and reasons for adverse outcomes and 'Not assessed' outcome to be allowed for each assessment are given here:

Brief explanation -

If a trainee is on the Foundation programme and their placement grade at time of assessment = F1 the outcomes allowed will be limited to 1, 3, 4 5 or 8

If the Programme is neither Dental Foundation, Dental Core or Foundation allow 1, 2, 3, 4, 5, 6, 8 or 9

If the Programme is Dental Foundation and the Assessment Type is IRCP (one of the new assessment types) allow 1, 2, or 5.

Note about legacy outcomes

Outcomes on assessments dated 2016 or earlier should be set to read only.