Page Comparison

Next steps:

Alistair Pringle (Unlicensed) - More sessions to be arranged to understand teaching sessions, HR and Training absence and TOOT.
Add fields validation, reorder/re-arrange categories as necessary following the sessions.
Look at DR V2 and update the below.

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)

Study and non-study leave

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

Courses/Exams/EventsTeaching sessions

Field Sequence (ordinal)	Field name (V10)	DR field	Reference table	Example value	Type (free text, drop down, check box) & Interaction

Teaching sessions (Vwteachingsession)
	Status	Y (Status)	Y	Active	Dropdown
	Session id	Y (Teachingsessionid)			Auto-generated id
	Teaching year	Y (

TeachingYear

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

Testarea

Textarea

Session type

Y (Teachingsessiontype)

Y

Regional Teaching, Specialty Teaching

Dropdown

Venue

Freetext

Local Office

Session number

N

Freetext

Parent Trust

Y (Location) ???

Y

Dropdown

Parent Site

Y

Dropdown

Mandatory

N

Yes/No

DropdownStatusY

		Dropdown
	CPD Points

N

(Hours/Days)

Y (Cpdpoints)

Integer

No. of Places

N

100

Integer

Places remaining

N

20

Integer (readonly and auto calculated from No.of Places and the number of trainee added to session)

Notes

NTextareaFacilitaror 1

Textarea

Teaching sessions - Teachers and facilitators (Vwteachingsession)

Name

Dropdown

Facilitaror 2DropdownFacilitator 3DropdownCompetencies

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

Field Sequence (ordinal)	Field name (V10)	DR field	Example value	Type (free text, drop down, check box) & Interaction
	Dropdown <<Reference data>>
	Finance Detail			Textarea
	Amount			Float
	Comments			Textarea
Person - Teaching sessions (Vwteachingsession)
	Post		PEN/L83133/800/GPST/002	Dropdown
	Teaching year	Y (Teachingyear)	2016/2017	Freetext

Teaching sessionN

Dropdown


	Date

21

04/

01

08/2017

Date

field/ Date pickerTime10:00Time formatAttendedYesYes/NoAbsence reasonYAnnual leave, Study, Exam, Off site etc.DropdownUnable to attendYesYes/NoPerson - Course AttendanceCourseY (CourseName)YMonogenic Diabetes Symposium 2016DropdownDue date

Y (CourseDueDate)

N21/05/2016Date field/ Date PickerAttended??????Yes, No, PartialDrdopdownAttended date Y (AttendedDate)N21/05/2016Date field/ Date PickerAttended timeY (CourseAttendedTime)N15:00FreetextVenueY (Venue)YBathDropdownExpiry dateY (ExpiryDate)N21/05/2016Date field/ Date PickerCPD PointsY (CPD Points)N50Read-only - Whole number of hours or daysCommentsY (Comments)NFreetextFreetext

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

Entitlements (Leaves)Entitlement typeStatusLeave yearStart dateEnd dateEntitledBrought ForwardLieuCRTotal LeaveTaken LeaveRemaining LeaveCompensatory REntitlements (Expenses)Budget typeStatusFinancial YearStart dateEnd dateBrought ForwardBudget(£)TotalCommittedActualRemaining

Versions Compared

Old Version 12

New Version Current

Key