Posts - Field Validation - NEW

Field Sequence	Field name	Reference Table	Current FE Validation & Rules	List Page?(Y/N)	List Page Rules (Sort/Filter)	Proposed FE Validation Rules	Proposed BE Validation / Rules	Error Messages	Notes
National Post Number TISDEV-4748 - Getting issue details... STATUS / TISDEV-4747 - Getting issue details... STATUS
1	Suffix	See: TIS UI Fields - Dropdowns	Drop down Default to NONE	N		Enabled NPN manual edit Type: Drop down Dependencies: "Enable/d NPN manually editing" = "Yes" Mandatory: Yes Editable: Yes Default value: 'NONE' Auto-generation NPN Dependencies: "Enable/d NPN manually editing" = "No" Editable: No	Enabled NPN manual edit Type: Drop down Dependencies: "Enable/d NPN manually editing" = "Yes" Mandatory: Yes Editable: Yes Default value: 'NONE' Auto-generation NPN Dependencies: "Enable/d NPN manually editing" = "No" Editable: No	Warning: Suffix cannot be amended for autogenerated NPN This field is required	Can Suffix be amended (changed, added, or removed) in an autogenerated NPN after it's been created?
2	Enable/d NPN manually editing		Drop down Default to Yes	N		Type: Drop down Mandatory: Yes Editable: Yes Default value: Yes	Type: Drop down Mandatory: Yes Editable: Yes Default value: Yes	Warning: If "No" selected, the NPN cannot be edited
3	National post number		'Enable/d NPN manually editing' No Auto-created number based on the managing local office code, grade code, speciality code and postfix Not editable Not visible until post is created 'Enable/d NPN manually editing' Yes Free text	Y	Sort ascending order	Enabled NPN manual edit Type: Manual entry Character type: Alphanumeric Special characters allowed: / Character length: Min characters 1, Max characters none Dependencies: "Enable/d NPN manually editing" = "Yes" Mandatory: Yes Editable: If NPN manual edit is enabled Default value: N/A Autogeneration Type: Auto-generated Derived from owner code, grade code, specialty code, suffix Dependencies: "Enable/d NPN manually editing" = "No" Mandatory: No Editable: No Default value: N/A Display in real time i.e. as the user enters fields	Enabled NPN manual edit Type: Manual entry Character type: Alphanumeric Special characters allowed: / Character length: Min characters 1, Max characters none Dependencies: "Enable/d NPN manually editing" = "Yes" Mandatory: Yes Editable: If NPN manual edit is enabled Default value: N/A Autogeneration Type: Auto-generated Derived from owner code, grade code, specialty code, suffix Dependencies: "Enable/d NPN manually editing" = "No" Mandatory: No Editable: No Default value: N/A Display in real time i.e. as the user enters fields	This field is required Only special characters allowed are /	The error message should only be displayed where "Enable/d NPN manually editing" = Yes
Allocation TISDEV-4749 - Getting issue details... STATUS / TISDEV-4750 - Getting issue details... STATUS
4	Main site	See: TIS UI Fields - Dropdowns	Drop down Smart search MANDATORY	Y (Primary Site)	Filter	Type: Smart search Mandatory: Yes Editable: Yes Display SiteKnownAs+SiteNumber	Type: Smart search Mandatory: Yes Editable: Yes Display SiteKnownAs+SiteNumber	This field is required
5	Other sites (optional)	See: TIS UI Fields - Dropdowns	Drop down Smart search + or - button	N		Type: Smart search Mandatory: No Editable: Yes Display SiteKnownAs+SiteNumber Add multiple/all Remove one/all	Type: Smart search Mandatory: No Editable: Yes Display SiteKnownAs+SiteNumber Add multiple/all Remove one/all		Users should be able to add multiple fields individually, or add all fields from the drop down
6	Main specialty	See: TIS UI Fields - Dropdowns	Drop down Smart search MANDATORY	Y (Primary Specialty	Filter	Type: Smart search Mandatory: Yes Editable: Yes Add one Main specialty only	Type: Smart search Mandatory: Yes Editable: Yes Add one Main specialty only	This field is required
7	Other specialities	See: TIS UI Fields - Dropdowns	Drop down Smart search + or -	N		Type: Smart search Mandatory: No Editable: Yes Add multiple/all Remove one/all	Type: Smart search Mandatory: No Editable: Yes Add multiple/all Remove one/all		Users should be able to add multiple fields individually, or add all fields from the drop down
8	Sub specialities	See: TIS UI Fields - Dropdowns	Drop down Smart search + or -	N		Type: Smart search Mandatory: No Editable: Yes Add multiple/all Remove one/all Limit to sub-specialties of the Main specialty	Type: Smart search Mandatory: No Editable: Yes Add multiple/all Remove one/all Limit to sub-specialties of the Main specialty	Warning: only sub-specialties o the Main specialty can be selected	Investigate whether multiple sub-specialties is required (Data Leads)
9	Approved grade	See: TIS UI Fields - Dropdowns	Drop down Smart search MANDATORY	Y	Filter	Type: Smart search Mandatory: Yes Editable: Yes Limit to Post Grades	Type: Smart search Mandatory: Yes Editable: Yes Limit to Post Grades	This field is required Warning: only Post grades can be selected
10	Other grades	See: TIS UI Fields - Dropdowns	Drop down Smart search + or -	N		Type: Smart search Mandatory: No Editable: Yes Add multiple/all Remove one/all Limit to Post Grades	Type: Smart search Mandatory: No Editable: Yes Add multiple/all Remove one/all Limit to Post Grades	Warning: only Post grades can be selected
Ownership TISDEV-4752 - Getting issue details... STATUS / TISDEV-4751 - Getting issue details... STATUS
11	Owner	See: TIS UI Fields - Dropdowns	Drop down Smart search MANDATORY	Y	Filter	Type: Drop down, current only Mandatory: Yes Editable: Yes	Type: Drop down, current only Mandatory: Yes Editable: Yes	This field is required
12	Employing body	See: TIS UI Fields - Dropdowns	Drop down Smart search	N		Type: Smart search Mandatory: Yes Editable: Yes	Type: Smart search Mandatory: Yes Editable: Yes	This field is required
13	Training body	See: TIS UI Fields - Dropdowns	Drop down Smart search	N		Type: Smart search Mandatory: Yes Editable: Yes	Type: Smart search Mandatory: Yes Editable: Yes	This field is required
14	Programme name	See: TIS UI Fields - Dropdowns	Drop down Smart search + or -	Y	Filter	Type: Drop down - current only Mandatory: Yes Editable: Yes Add multiple/all Remove one/all Dependencies: "Rotation name" only editable after "Programme name" is selected	Type: Drop down - current only Mandatory: Yes Editable: Yes Add multiple/all Remove one/all Dependencies: "Rotation name" only editable after "Programme name" is selected	This field is required
15	Training description		Free text	N		Type: Manual entry Characters: Text Special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 0, Max characters none Mandatory: No Editable: Yes	Type: Manual entry Characters: Text Special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 0, Max characters none Mandatory: No Editable: Yes	Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( )
18	Status	See: TIS UI Fields - Dropdowns	Drop down Default to CURRENT	Y	Filter	Type: Drop down Mandatory: Yes Editable: Yes Default value: CURRENT	Type: Drop down Mandatory: Yes Editable: Yes Default value:CURRENT	This field is required
19	Old post		Drop down Smart search	N		Type: Smart search Mandatory: No Editable: Yes	Type: Smart search Mandatory: No Editable: Yes
20	New post		Drop down Smart search	N		Type: Smart search Mandatory: No Editable: Yes Limit to already created Posts	Type: Smart search Mandatory: No Editable: Yes Limit to already created Posts
21	Post family		Free text	N		Type: Drop down Mandatory: No Editable: Yes Limit to ref table	Type: Drop down Mandatory: No Editable: Yes Limit to ref table		JW to discuss with SMEs
22	Local post number		Free text	N		Type: Manual entry Characters: Text Special characters allowed: / Character length: Min characters 0, Max characters none Mandatory: No Editable: Yes	Type: Manual entry Characters: Text Special characters allowed: / Character length: Min characters 0, Max characters none Mandatory: No Editable: Yes
Funding (Needs to be discussed with SMEs - particularly EM & LASE) TISDEV-4753 - Getting issue details... STATUS / TISDEV-4754 - Getting issue details... STATUS
23	Funding type	See: TIS UI Fields - Dropdowns	Drop down Default to 'No value provided'	Y	Filter	Type: Drop down Mandatory: Yes Dependencies:"If 'Other', please specify," "Start date," "End date" Editable: Yes Default value: "No value provided"	Type: Drop down Mandatory: Yes Dependencies:"If 'Other', please specify," "Start date," "End date" Editable: Yes Default value: "No value provided"	This field is required
24	If 'Other', please specify		Free text, if 'Funding type' 'OTHER is selected	N		If Funding type is "Other" Type: Manual entry Characters: Text Special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 0, Max characters none Mandatory: No Dependencies:Only active when "Funding type" is "Other" otherwise greyed out Editable: Yes If Funding type is not "Other" Editable: No	If Funding type is "Other" Type: Manual entry Characters: Text Special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( ) Character length: Min characters 0, Max characters none Mandatory: No Dependencies:Only active when "Funding type" is "Other" otherwise greyed out Editable: Yes If Funding type is not "Other" Editable: No	Only special characters allowed: forward slash ( / ), apostrophes ( ' ), hypens ( - ), full stops ( . ) and spaces ( )
25	Funding body / organisation	See: TIS UI Fields - Dropdowns	Drop down Smart search	N		Type: Smart search Mandatory: Yes Editable: Yes Add multiple	Type: Smart search Mandatory: Yes Editable: Yes Add multiple	This field is required	Should be pulling from "Funding Organisation table"
26	Start date		Free text or calendar pick Date format DD/MM/YYYY	N		If Funding type is "No value provided" Editable: No If Funding type is not "No value provided" Type: Free text or calendar pick Date format DD/MM/YYYY Character type: Numerical Special characters allowed: / Mandatory: Yes Dependencies: Only active when "Funding type" is not "No value provided" otherwise greyed out Editable: Yes Type otherwise greyed out Editable: Yes	If Funding type is "No value provided" Editable: No If Funding type is not "No value provided" Type: Free text or calendar pick Date format DD/MM/YYYY Character type: Numerical Special characters allowed: / Mandatory: Yes Dependencies: Only active when "Funding type" is not "No value provided" otherwise greyed out Editable: Yes Type otherwise greyed out Editable: Yes	This field is required Only special characters allowed /
27	End date		Free text or calendar pick Date format DD/MM/YYYY	N		If Funding type is "No value provided" Editable: no If Funding type is not "No value provided" Type: Free text or calendar pick Date format DD/MM/YYYY Character type: Numerical Special characters allowed: / Mandatory: Yes Dependencies:Only active when "Funding type" is not "No value provided" otherwise greyed out Editable: Yes Type otherwise greyed out Editable: Yes	If Funding type is "No value provided" Editable: No If Funding type is not "No value provided" Type: Free text or calendar pick Date format DD/MM/YYYY Character type: Numerical Special characters allowed: / Mandatory: Yes Dependencies:Only active when "Funding type" is not "No value provided" otherwise greyed out Editable: Yes Type otherwise greyed out Editable: Yes	This field is required Only special characters allowed /
Rotation TISDEV-4755 - Getting issue details... STATUS / TISDEV-4756 - Getting issue details... STATUS
29	Rotation name		Drop down Smart search	N		Type: Smart search Mandatory: No Editable: Yes Add multiple/all Remove one/all Dependencies: Only active when Programme selected, otherwise greyed out. History only populates if Rotation is selected. Limit to Rotations already created Current values only Limited to Rotations in same Programme	Type: Smart search Mandatory: No Editable: Yes Add multiple/all Remove one/all Dependencies: Only active when Programme selected, otherwise greyed out. History only populates if Rotation is selected. Limit to Rotations already created Current values only Limited to Rotations in same Programme	Warning: Only rotations from within the same programme as the post can be selected
History (Table) TISDEV-4757 - Getting issue details... STATUS / TISDEV-4758 - Getting issue details... STATUS
30	Trainee full name		Read only	Y (Current Trainee)	Sort Max 1 current trainee displayed in list page	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No
31	Start date		Read only	N		Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No
32	End date		Read only	N		Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No
33	Main site		Read only	N		Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No
34	Main specialty		Read only	N		Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No
35	Placement grade		Read only	N		Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No
36	Placement type		Read only	N		Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No
37	Status		Read only	N		Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No	Type: Derived from Placements Dependencies: Populates if Rotation is selected Editable: No