Page content:

Field Validation

Order	Field Name	Example Value	Type (Free text etc)	Mandatory (Y/N)	Validation	Comments
Site Approval (displayed within Reference Data)
1	Start Date		date picker	N
2	End Date		date picker	N	if end date is before "today", site status should be inactive NOT FOR MVP
Trainer Approval (displayed within Person Record)
1	Trainer Type		Read only	N	This will be populated based on the roles the Person has. Cannot be null as this having one of the trainer type determine whether the Person is a Trainer.	Options should be Clinical Supervisor Educational Supervisor Clinical & Educational Supervisor Leave Approver This will be populated based on the roles the Person has.
2 (tbc)	Approval Type (tbc)		drop down	N	one must be selected if record recorded	Options should be course evidence other 02/10: Discussed with NW and LDN. This was not deemed MVP to record and unsure how this field would be used.
3	Name		These are the Person fields that have already been developed on TIS	N		These are the Person fields that have already been developed on TIS
4	Start Date	DD/MM/YYYY	date picker	N	Start date cannot be after End date
5	End Date	DD/MMYYYY	date picker	N	End date cannot be before start date If end date is before "today", trainer should not be available for assignation to programmes/trainees (NOT FOR MVP)
6	Approval Status	CURRENT INACTIVE	Default value is CURRENT		CURRENT set as default Ability to change this to INACTIVE from the UI	For MVP, default will be CURRENT and no automatic setting based on start and end dates. This is because it requires lot of work for the admins to set the from and to dates on all CS/ES when we have developed the Trainer Approval functionality. Note: When creating placements, the Approval Status should be used to populate with the lists of CURRENT Educational or Clinical Supervisors.

Bulk Upload Site Approvals Column Headers

(Reviewed by data leads)

This tool is intended to allow admins that have access to manage sites to be able to amend the start/end dates of Site approvals in bulk. These set of fields have been talked through with Data Leads and agreed upon. If more columns are required to this upload, then these could be added post-mvp.

TISNEW-4885 - Getting issue details... STATUS

Row no.	Column Heading	Add/Update/Matching Criteria	Mandatory Y/N?	Rules	Questions/Comments
1.	TIS_Site_ID*	Matching Criteria	Y	SiteID has to match an existing site on TIS regardless of their status
2.	Date from	Update	N	dd/mm/yyyy format Date from must be before Date to valid dates only
3..	Date to	Update	N	dd/mm/yyyy format Date from must be before Date to valid dates only
4.	Status	Update	N	MVP - Accepted values are CURRENT and INACTIVE only Post MVP- Calculate based on dates entered once data leads have tidied up all existing sites dates from/to
					More fields could be added later if required post MVP.

TIS21 Confluence Space

Approvals - Field Validation

Field Validation

Site Approval (displayed within Reference Data)

Trainer Approval (displayed within Person Record)

Bulk Upload Site Approvals Column Headers