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 TISDEV-4706 - Getting issue details... STATUS / TISDEV-4739 - Getting issue details... STATUS
1	Assessment ID	N/A	system generated	TBC	system generated non-editable	Type: System generated Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value:		Does need to be displayed on the UI, however needs to be placed somewhere less prominent than top of screen system generated non-editable
2	Person ID		system generated	TBC	drop down list if multiple derived from Person record MANDATORY (to select 1)	Type: Drop down list derived from Person record Character type: Numerical Special characters: None Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: No Default value:	N/A	Does need to be displayed on the UI, however needs to be placed somewhere less prominent than top of screen Future work to be done to consolidate - may not need drop down to select ID's, further conversation required derived from Person record limit to registration fields entered on Person records
3	Trainee First name		Derived from Person Record		derived from Person record non-editable	Type: Derived from Person record Character type: Alphanumerical Special characters: : apostrophes ( ' ), hyphens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: None Mandatory: No Editable: No Default value:	N/A	derived from Person record non-editable
4	Trainee Surname		Derived from Person Record		derived from Person record non-editable	Type: Derived from Person record Character type: Alphanumerical Special characters: : apostrophes ( ' ), hyphens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 1, Max characters none Dependencies: None Mandatory: No Editable: No Default value:	N/A	derived from Person record non-editable
5	Type		Drop down MANDATORY		drop down limited to reference table limited to current values only MANDATORY	Type: Drop down Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value:	An entry must be made to create or update the record	drop down limited to reference table limited to current values only MANDATORY
6	Status		Drop down		drop down limited to reference table limited to current values only allow blanks	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: 'No value provided'	Only entries from the reference table can be entered	Do we really need this field? Not flagged as useful from DL perspective drop down limited to reference table limited to current values only allow blanks
7	Programme name		Drop down		drop down limited to trainee's current/past/future programmes MANDATORY	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value:	Only programmes from trainees current, future or past programme can be selected	drop down limited to trainee's current/past/future programmes MANDATORY
8	Programme number		Auto-populated from Programme name Non-editable		derived from selected Programme non-editable	Type: Auto-populated from Programme name Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value:	N/A	derived from Person record non-editable
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 MANDATORY	Type: Manual entry or calendar picker Character type: Numerical Date Format: DD/MM/YYYY Special characters: ( / ) Character length: Min characters 9, Max characters 9 Dependencies: Mandatory: Yes Editable: Yes Default value:	Valid date format must be entered	Free text - or calendar picker Date format DD/MM/YYYY can be any date in the past or future MANDATORY
L3: Pre-Assessment Detail - only available once mandatory fields in Event are completed << potentially merge this with "Event" section?? TBD w/ Matt TISDEV-4707 - Getting issue details... STATUS / TISDEV-4738 - Getting issue details... STATUS
10	Curriculum name		Drop down MANDATORY		drop down limited to curricula input as part of Trainee's Programme MANDATORY	Type: Drop down Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value:	This must be selected	drop down limited to curricula input as part of Trainee's Programme MANDATORY
11	Curriculum Membership start date		Autofill Non-editable		derived from selected Trainee's Curriculum Membership	Type: Derived from selected Trainee's Curriculum Membership Character type: Numerical Date Format: DD/MM/YYYY Special characters: ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes Default value:		derived from selected Trainee's Curriculum Membership
12	Curriculum Membership end date		Autofill Non-editable		derived from selected Trainee's Curriculum Membership	Type: Derived from selected Trainee's Curriculum Membership Character type: Numerical Date Format: DD/MM/YYYY Special characters: ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes Default value:		derived from selected Trainee's Curriculum Membership
13	Curriculum speciality		Autofill Non-editable		derived from selected Trainee's Curriculum Membership	Type: Derived from selected Trainee's Curriculum Membership Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes Default value:		derived from selected Trainee's Curriculum Membership
14	Curriculum sub-type		Autofill Non-editable		derived from selected Trainee's Curriculum Membership	Type: Derived from selected Trainee's Curriculum Membership Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes Default value:	N/A	derived from selected Trainee's Curriculum Membership
15	Membership type		Autofill Non-editable		derived from selected Trainee's Programme Membership	Type: Derived from selected Trainee's Programme Membership Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: No Default value:		derived from selected Trainee's Curriculum Membership
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 from date should be before end date	Type: Manual entry or calendar picker Character type: Numerical Special characters: ( / ) Date format: DD/MM/YYYY Character length: Min characters 9, Max characters 9 Dependencies: Mandatory: No Editable: Yes Default value:	Valid date format must be entered	Free text - or calendar picker Date format DD/MM/YYYY allow blanks from date should be before end date
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 from date should be before end date	Type: Manual entry or calendar picker Character type: Numerical Special characters: ( / ) Date format: DD/MM/YYYY Character length: Min characters 9, Max characters 9 Dependencies: Mandatory: No Editable: Yes Default value:	Valid date format must be entered	Free text - or calendar picker Date format DD/MM/YYYY allow blanks from date should be before end date
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	Type: Manual entry or calendar picker Character type: Numerical Special characters: ( / ) Date format: DD/MM/YYYY Character length: Min characters 9, Max characters 9 Dependencies: Mandatory: No Editable: Yes Default value:	Valid date format must be entered	Do we really need this? Free text - or calendar picker Date format DD/MM/YYYY allow blank
19	WTE months OOPR/T during period		Autofill Non-editable		derived from Placement History (triggered from Period covered from/to) non-editable	Type: Derived from Placement History (triggered from Period covered from/to) Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: No Default value:	N/A	derived from Placement History (triggered from Period covered from/to) non-editable
20	Months OOPR/OOPT counted training		numerical value		numerical value only	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value:	Only numerical values can be entered	numerical value only
19	PYA		Default "No" Drop down		default "no" drop down limited to reference table	Type: Drop down Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value:	N/A	ie PYA = penultimate year assessments default "no" drop down limited to reference table
20	Grade at the time		Autofill Non-editable		derived from Person record (Placement history) as at the review date allow blanks editable	Type: Derived from Person record (Placement history) as at the review date Character type: Numerical, Alphanumerical, Text, Free text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: No Editable: Yes Default value:	N/A	derived from Person record (Placement history) as at the review date allow blanks editable
21	Days out of training		numerical value			Type: Manual entry Character type: Numerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: YNo Editable: Yes Default value:	N/A	numerical value
22	WTE		NEW FIELD		derived from Person record editable	Type: Derived from Person record Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes Default value:		derived from Person record editable
L3: Post-assessment Detail TISDEV-4708 - Getting issue details... STATUS / TISDEV-4737 - Getting issue details... STATUS
22	Outcome		Drop down MANDATORY		drop down limited to reference table limited to current values only MANDATORY (if this section is completed) warn users that additional outcomes for the same curriculum membership cannot be added on the same day as previous	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes/No Default value:	Only entries from the reference table can be entered	This should be related to the Assessment type - so where a dental assessment type is selected, the outcomes should be limited to Dental outcomes only Dental analysis tbc drop down limited to reference table limited to current values only MANDATORY (if this section is completed) add multiple warn users that additional outcomes for the same curriculum membership cannot be added on the same day as previous
23	Under appeal		Drop down		drop down restricted to reference table values	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes Editable: Yes Default value: 'No'	Only entries from the reference table can be entered	drop down restricted to reference table values
24	Reason - unsatisfactory outcome		Drop down MANDATORY if Outcome is 'Not Assessed', otherwise non-editable		available when outcome 2, 3, 4 selected (for Matt to advise) drop down limited to reference table limited to current values only add multiple MANDATORY	Type: Drop down Character type: Alphanumerical Special characters: Character length: Min characters, Max characters Dependencies: available when outcome 2, 3, 4 selected (for Matt to advise) Mandatory: Yes Editable: Yes Default value: add multiple	Only entries from the reference table can be entered	Dental analysis tbc available when outcome 2, 3, 4 selected drop down limited to reference table limited to current values only MANDATORY
	Reason - not assessed		NEW SEPARATE FIELD ???		available when outcome not assessed selected (for Matt to advise) drop down limited to reference table limited to current values only add multiple MANDATORY	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No add multiple Editable: Yes/No Default value: XXX
	Reason - unsatisfactory outcome "other"		NEW FIELD		available only where they select "other reason" (for Matt to advise) add multiple free text	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX add multiple Mandatory: Yes/No Editable: Yes/No Default value: XXX		available only where they select "other reason" free text
	Reason - not assessed, "other"		NEW FIELD		available where not assessed, "other reason" is selected (for Matt to advise) free text add multiple	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX add multiple		available where not assessed is selected free text
25	Completion of training date (prior to review)		Autofill Non-editable		Autopopulated based on CCT date of Trainee's curricula	Type: Auto-populated based on CCT date of Trainee's curricula Character type: Numerical Special characters ( - ) Character length: Min characters 9, Max characters 9 Dependencies: Mandatory: Yes/No Editable: No Default value:	Valid date format must be entered	Autopopulated based on CCT date of Trainee's curricula
26	10% audit - lay member		Default to No Drop down		Default to no drop down	Type: Drop down Character type: Text Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value: 'NO'	Only entries from the reference table can be entered	Default to no drop down
27	External trainer		Autofill Drop down		Default to no drop down	Type: Auto-fill / Drop down Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value: 'No'	Only entries from the reference table can be entered	Default to no drop down
28	Grade at next rotation		Drop down		drop down limited to reference table limited to current values only	Type: Drop down Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value:	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 drop down limited to reference table limited to current values only
29	Trainee notified of outcome		Autofill Editable Drop down		Default to no drop down	Type: Auto-fill / Drop down Character type: Special characters: Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes Default value:	Only entries from the reference table can be entered	Default to no drop down
30	Next review date		Free text - or calendar picker Date format DD/MM/YYYY		Free text - or calendar picker Date format DD/MM/YYYY	Type: Manual entry or calendar picker Character type: Numerical Special characters ( / ) Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value:	Valid date format must be entered	Date format DD/MM/YYYY
31	Comments		Free text		free text text already input visible even when not being edited	Type: Manual entry Character type: Free text Special characters: (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: Mandatory: Yes/No Editable: Yes/No Default value:	N/A	free text text already input visible even when not being edited
Blue sub-section: Academic Progression (within Pre-assessment Detail) TISDEV-4709 - Getting issue details... STATUS / TISDEV-4735 - Getting issue details... STATUS
32	Academic curriculum assessed		Autofill Non-editable		derived from whether they were doing an academic curriculum within Assessment period non-editable	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX		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	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	Only entries from the reference table can be entered	drop down limited to reference table limited to current values only MANDATORY if academic curriculum assessed is populated
Blue sub-section: Supplementary Detail (within Pre-assessment Detail) TISDEV-4742 - Getting issue details... STATUS / TISDEV-4743 - Getting issue details... STATUS
34	Detailed reason		Free text		free text text already input visible even when not being edited	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	N/A	free text edits add to existing data
35	Mitigating circumstances		Free text		free text text already input visible even when not being edited	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	N/A	free text edits add to existing data
36	Competences which need to be developed by next ARCP		Free text		free text text already input visible even when not being edited	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	N/A	free text edits add to existing data
37	Other recommended actions		Free text		free text text already input visible even when not being edited	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	N/A	free text edits add to existing data
38	Recommended additional training time (if required)		Free text		free text text already input visible even when not being edited	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	N/A	free text edits add to existing data
39	Additional comments from the panel		Free text		free text text already input visible even when not being edited	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	N/A	free text edits add to existing data
L3: Re-validation
40	Known concerns		Drop down No default?		default to no drop down limited to reference table limited to current values only	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	Only entries from the reference table can be entered	default to no drop down limited to reference table limited to current values only
41	Concern summary		Free text		free text text already input visible even when not being edited	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	N/A	free text edits add to existing data
42	Responsible officer comments		Free text		free text text already input visible even when not being edited	Type: Drop down / Manual entry / Auto generated / System generated Character type: Numerical, Alphanumerical, Text, Free text Special characters (bracket, space, hyphen, apostrophe, speech marks, comma, fullstop) Character length: Min characters, Max characters Dependencies: XXX Mandatory: Yes/No Editable: Yes/No Default value: XXX	N/A	free text edits add to existing data

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.

Assessments - Field Validation NEW (draft)

0 Comments