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.
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MVP Fields | ||||||||||||||
| Person - Entitlements | ||||||||||||||
| Expenses | 300.00 |
| N | |||||||||||
| Time (Study leave) | 100.00 |
| N | |||||||||||
| Leave year | 2016/2017 |
| N | |||||||||||
| Start date | 01/02/2016 |
| N | |||||||||||
| End date | 31/01/2017 |
| N | |||||||||||
| Teaching Sessions |
| N | Post-MVP | |||||||||||
| Remaining Time (Study leave) | 50.00 |
| N | |||||||||||
| Remaining Expenses | 250.00 |
| N | |||||||||||
| Total expenses claimed | 150.00 | Read-only calculated field (Sum of all Actuals Expenses for Leave year) | N | |||||||||||
| Total time taken (Study leave) | 10.00 | Readonly calculated field (Sum of all Actuals for Time (Study leave)) | N | |||||||||||
| Person - Actuals | ||||||||||||||
| Expenses | 100.00 |
| N | |||||||||||
| Time (Study leave) | 3.00 |
| N | |||||||||||
| Leave year | 2016/2017 |
| N | |||||||||||
| Start date | 01/02/2016 |
| N | |||||||||||
| End date | 31/01/2017 |
| N | |||||||||||
| Teaching Sessions |
| N | Post-MVP | |||||||||||
| Person - Course | ||||||||||||||
| Course topic | Mandatory Training | Dropdown (in DR)
| N | |||||||||||
| Course name | Monogenic Diabetes Symposium 2016 | Dropdown (in DR)
This can be made a free text for MVP if the facility to manage pre-approved coursed will not be available. | N | This can be made a free text for MVP if the facility to manage pre-approved coursed will not be available. | ||||||||||
| Course venue |
| N | ||||||||||||
| Course type | Internal | Dropdown: Internal/External | N | |||||||||||
| Number of days | 3 | Freetext | N | |||||||||||
| Comments | Freetext | Freetext | N | |||||||||||
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 | ||||||||||||||
| 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 | ||||||||||||||
Add Comment