Assessments - Field Validation NEW (draft)

Outstanding Questions

should there be a list page? Yes, but needs to be reviewed
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				Does not need to be displayed on UI
2	Person 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	Does not need to be displayed on UI
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 MANDATORY	drop down limited to reference table limited to current values only MANDATORY	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 blanks	drop down limited to reference table limited to current values only allow blanks	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 - only available once mandatory fields in Event are completed
10	Curriculum name		Drop down MANDATORY		drop down limited to reference table limited to current values only limited to curricula input as part of Trainee's Programme	drop down limited to reference table limited to current values only limited to curricula input as part of Trainee's Programme	TBC if mandatory
11	Curriculum start date		Autofill Non-editable		derived from selected Curricula	derived from selected Curricula
12	Curriculum end date		Autofill Non-editable		derived from selected Curricula	derived from selected Curricula
13	Curriculum speciality		Autofill Non-editable		derived from selected Curricula	derived from selected Curricula
14	Curriculum sub-type		Autofill Non-editable		derived from selected Curricula	derived from selected Curricula	N/A
15	Membership type		Autofill Non-editable		derived from selected Curricula	derived from selected Curricula
16	Period covered from		Free text - or calendar picker Date format DD/MM/YYYY		Free text - or calendar picker Date format DD/MM/YYYY allow blanks	Free text - or calendar picker Date format DD/MM/YYYY allow blanks	Valid date format must be entered
17	Period covered to		Free text - or calendar picker Date format DD/MM/YYYY		Free text - or calendar picker Date format DD/MM/YYYY allow blanks	Free text - or calendar picker Date format DD/MM/YYYY allow blanks	Valid date format must be entered
18	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
19	WTE months OOPR/T during period		Autofill Non-editable		derived from Placement History (triggered from Period covered from/to) non-editable	derived from Placement History (triggered from Period covered from/to) non-editable	N/A
20	Months OOPR/OOPT counted training		numerical value		numerical value only	numerical value only	Only numerical values can be entered
19	PYA		Default "No" Drop down		default "no" drop down limited to reference table	default "no" drop down limited to reference table	Only entries from the reference table can be entered	ie PYA = penultimate year assessments
20	Grade at the time		Autofill Non-editable		derived from Person record (Placement history) non-editable in Assessment record	derived from Person record (Placement history) non-editable in Assessment record	N/A
21	Days out of training		numerical value		numerical value	numerical value	N/A
L3: Post-assessment Detail
22	Outcome		Drop down MANDATORY		drop down limited to reference table limited to current values only MANDATORY (if this section is completed)	drop down limited to reference table limited to current values only MANDATORY (if this section is completed)	Only entries from the reference table can be entered
23	Under appeal		Drop down		drop down restricted to reference table values	drop down restricted to reference table values	Only entries from the reference table can be entered
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		Autopopulated based on CCT date of Trainee's curricula	Autopopulated based on CCT date of Trainee's curricula	Valid date format must be entered
26	10% audit - lay member		Default to No Drop down		Default to no drop down	Default to no drop down	Only entries from the reference table can be entered
27	External trainer		Autofill Drop down		Default to no drop down	Default to no drop down	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	Requires new ref table to be built based on GMC ARCP survey - there are new/separate values applicable here
29	Trainee notified of outcome		Autofill Editable Drop down		Default to no drop down	Default to no drop down	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
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		derived from whether they were doing an academic curriculum within Assessment period non-editable	derived from whether they were doing an academic curriculum within Assessment period non-editable
33	Academic outcome		Drop down MANDATORY		drop down limited to reference table limited to current values only MANDATORY if academic curriculum assessed is populated	drop down limited to reference table limited to current values only MANDATORY if academic curriculum assessed is populated	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
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
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
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
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
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
L3: Re-validation
40	Known concerns		Drop down No default?		default to no drop down limited to reference table limited to current values only	default to no 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
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

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.