Absence management - Field validation

Next steps:

Confirm fields are as discussed

Field Sequence (ordinal)	Field name (V10)	DR field (View)	Reference table	Example value	Other fields available in DR	Type (free text, drop down, check box) & Interaction	Mandatory (Y/N)	Validation / Error Messaging	Filter (Y/N)	Search (Y/N)	Sort (Y/N)	List (S) / Detail (D)	Notes	Delete (Y / N)
MVP Fields
Entitlements v Actuals
	Leave Type	Leavetype (Vwleave)		STUDY LEAVE, SICKNESS, EXPENSES, COURSE (for Trainers)		drop down: multiple rows can be selected one type per row	N
	Leave Name	Coursename (Vwleave)		e.g. Cardiology for Geniuses		free text up to 100 characters	N
	Entitlement Value	Budget??? Entitlement (Vwentitlement)		300.00 30		Free text Number to 2 decimal places Include guidance note stating that "if expenses, this should be in GBP only"	N
	Actual Value	Actualcost (Vwleaveexpense) Takendays (Vwentitlement)		116.75 2		Free text Number to 2 decimal places Include guidance note stating that "if expenses, this should be in GBP only"	N
	Leave year	Leaveyear (Vwentitlement)		2016/2017		Free text	N						This not aligned with the financial year. It runs from August to August. (IO) Should this be a year only ie 2016 - 2017, rather than a date? Alistair Pringle (Unlicensed)
	Financial year	Financialyear (Vwleaveexpense)		2016/2017		Free text	N						This not aligned with the study leave year. It runs from April to March. (IO) Should this be a year only ie 2016 - 2017, rather than a date? Alistair Pringle (Unlicensed)
	Leave Start date	Leavestartdate (Vwleaveexpense)		01/02/2016		Calendar picker	N
	Leave End date	Leaveenddate (Vwleaveexpense)		31/01/2017		Calendar picker	N
	Teaching Sessions					Free text Number	N						Post-MVP
	Remaining Time (Study leave)	Remainingdays (Vwentitlement)		50.00		Read-only calculated field (Time (Study leave) minus Total time taken(Study leave)) Number (of days) displayed per leave type	N						(IO) Is this still needed for MVP? Alistair Pringle (Unlicensed)
	Remaining Expenses			250.00		Read-only calculated field (Time (Study leave) minus Total time taken(Study leave)) Number (GBP) displayed per leave type	N						(IO) Is this still needed for MVP? Alistair Pringle (Unlicensed)
	Total expenses claimed			150.00		Read-only calculated field (Sum of all Actuals Expenses for Leave year) displayed per leave type (if expenses)	N						(IO) Is this still needed for MVP? Alistair Pringle (Unlicensed)
	Total time taken (Study leave)	Takendays (Vwentitlement)		10.00		Read-only calculated field (Sum of all Actuals for Time (Study leave))	N						(IO) Is this still needed for MVP? Alistair Pringle (Unlicensed)

Field Sequence (ordinal)	Field name (V10)	DR field	Reference table	Example value	Other fields available in DR	Type (free text, drop down, check box) & Interaction	Mandatory (Y/N)	Validation / Error Messaging	Filter (Y/N)	Search (Y/N)	Sort (Y/N)	List (S) / Detail (D)	Notes	Delete (Y / N)
POST-MVP Fields
Study leave/Course details (Leave Manager)
MVP	Status	Y (STATUS)	Y - Status	Current	N	Dropdown							Default is current
MVP	Start date	Y (LeaveStartDate)	N	05/06/2016		Date field / Date picker
MVP	End date	Y (LeaveEndDate)	N	05/12/2017		Date field / Date picker
MVP	Leave type	Y (LeaveType)	Y	Study, Exam, Private or Other.		Dropdown
MVP	Days (NumberOfDays)	Y (NumberOfDays)	N	44.25									Should this not be whole numbers only?
	Authorised	Y (Authorised)
	Authorisation type	Y (????)		Full, Limited, Locum, SSP, Grant, Leave only.		Dropdown
	Online	Y (Online)	N	Yes, No		Boolean
	Estimated Cost	Y (EstimatedCost)	N			Float
	Actual	Y (ActualCost)	N			Float
	Submitted date	Y (DateAppliedFor)	N	05/12/2017		datetime
	Person covering	Y (NameOfPersonCovering)
	Rota manager	Y (NameOfRotaManager)
	Comments	Y (Comments)
	Internal/External	Y (???)		Internal, External		Dropdown
	Reference	Y (Referenve)	N			Freetext
	Exception application	???	N
	Approved Course	???
	Course name	Y (CourseName)	Y			Dropdown
	Course venue	Y (CourseVenue)	Y			Freetext
	Course website	Y	N			Freetext
	Course Provider	Y	N			Freetext
Field Sequence (ordinal)	Field name (V10)	DR field	Reference table	Example value	Other fields available in DR	Type (free text, drop down, check box) & Interaction	Mandatory (Y/N)	Validation / Error Messaging	Filter (Y/N)	Search (Y/N)	Sort (Y/N)	List (S) / Detail (D)	Notes	Delete (Y / N)
Teaching sessions (Vwteachingsession)
	Status	Y (Status)	Y	Active		Dropdown
	Session id	Y (Teachingsessionid)				Auto-generated id
	Teaching year	Y (Teachingyear)	N	2016/2017		Freetext
	Teaching session date	Y (Teachingsessiondate)		21/01/2017		Date field/ Date picker
	Start time			10:00		Freetext
	Duration			3		Freetextv
	Teaching session title	Y (Title)				Freetext
	Subject					Textarea
	Session type	Y (Teachingsessiontype)	Y	Regional Teaching, Specialty Teaching		Dropdown
	Venue					Freetext
	Local Office
	Session number					Freetext
	Parent Trust	Y (Location) ???	Y			Dropdown
	Parent Site		Y			Dropdown
	Mandatory			Yes/No		Dropdown
	CPD Points (Hours/Days)	Y (Cpdpoints)				Integer
	No. of Places			100		Integer
	Places remaining			20		Integer (readonly and auto calculated from No.of Places and the number of trainee added to session)
	Notes					Textarea
Teaching sessions - Teachers and facilitators (Vwteachingsession)
	Name					Dropdown
	Type			Facilitator, Teacher		<<Reference data>>
Teaching sessions - Competencies (Vwteachingsession)
	Competencies		Y	Cannulation, ES -2 Trainee assessments		multi-select dropdown <<Reference data>>
Teaching sessions - Finance (Vwteachingsession)
	Finance type		Y	Income, Expense		Dropdown <<Reference data>>
	Finance Detail					Textarea
	Amount					Float
	Comments					Textarea
Field Sequence (ordinal)	Field name (V10)	DR field	Reference table	Example value	Other fields available in DR	Type (free text, drop down, check box) & Interaction	Mandatory (Y/N)	Validation / Error Messaging	Filter (Y/N)	Search (Y/N)	Sort (Y/N)	List (S) / Detail (D)	Notes	Delete (Y / N)
Person - Teaching sessions (Vwteachingsession)
	Post			PEN/L83133/800/GPST/002		Dropdown
	Teaching year	Y (Teachingyear)		2016/2017		Freetext
	Date			04/08/2017		Date
	Duration (Days)			3		Integer
	Session type		Y	Single		Dropdown
	Location
	CPD Points
	Mandatory
	Teaching session (Title)	Title	N			Dropdown
	Subject
	Session number			1		Integer
	Number of places			10		Integer
	Notes					Textarea
	Attended		Y	Yes		Yes/No
	Unable to attend			Yes		Yes/No
	Absence reason		Y	Annual leave, Study, Exam, Off site etc.		Dropdown
	Status		Y	Current		Yes/No
Leaves Approval
	Authorised status
	Approve
	Comments
	Confirmed decision
	Allow advance expenses application
Person - Expenses Claims/Funding
	Applicant
	Applied date
	Processed
	Expense type
	Estimated cost
	Actual cost
	Claim amount
	Authorised
	Passed for Paymnent date
	Comments
	Reference