Sprint 46 Review (2018-04-18)

Availability

(assume Team Availability Calendar is up to date, otherwise, everyone is available for 12 days: 3 week Sprint, but with 2 Bank Holidays):

Andy Ashley Joanne John S Matt Ola Ray Reuben Simon	-5 -1 -8 -6 -1 -1 -1 -4 -6

Sprint Priorities

The following list was the prioritisation output from Sprint Planning:

Product Management

Developer Support

Bulk upload / ESR support and integration testing

North East team support

Prep for remaining roll-out

Prioritisation of P1s and others (including Rotations - especially for London)
Relative prioritisation between live feedback and planned development

Development

4Ps and A

Stability of NE - triage and fix
P1s for other LOs - PO Group to keep under review
Testing of P1s - updating tests and retesting - continuing with automation of tests

TIS → NDW ETL

TIS data is in tis_interim for further processing.
Support NDW if there are questions regarding the mapping.

ESR

Infrastructure set up for ESR and ESR-ETL services to work with tcs.
And make the services deployed and available in Dev/Stage and Prod.
Initiate the testing on Stage.

Bulk upload

Suneet Kamath (Unlicensed) - update please

Frontend

Bug fixes on displaying errors
Now supports placements (changes icon and provides template)
Templates now stored in Azure bucket rather than in codebase

Document management

Backend API has now support for

Searching tags
Download documents

Frontend changes

Now handles all API errors
Some test coverage (needs more)
Downloads section placed into the person section dropdown
Searching with changes now shows confirmation prompt
Delete file requires confirmation using new modal component
Navigating away with unsaved changs shows unsaved prompt
Shows CSS loader animation when fetching data
Uses Bootstrap date picker
UI tweaks to make list a little clearer

User Management

New roles created(HEE Admin, HEE Admin Sensitive, HEE Admin Revalidation, HEE TIS Admin) with relevant permissions. Yet to be rolled into Prod.

Tidy up of existing roles and permissions via flyway

"New User Form" details given to Naz for Service Desk

Updating Service Desk user creation guide

Separate release of Profile to prod planned to allow SD users to take on user management

Reval

Sunil Rochani (Unlicensed) - update please

DevOps

Frederic Randriamora (Unlicensed) / John Simmons (Deactivated)
Document Storage Chris Mills (Unlicensed)
Terraform now modular, repeatable and secure.

Data

Can we get DQ leads to do a more thorough review?

Item	Owner	Description of work	Loom video of completed work https://www.useloom.com/
Production Application releases / updates:	Simon Meredith (Unlicensed) Oladimeji Onalaja (Unlicensed) (and anyone else that needs to conduct a release)	Releases 75 tickets moved to 'Ready to Release' or 'Done' in this sprint: TIS-39 TIS-40
Product Management	Alistair Pringle (Unlicensed) Joanne Watson (Unlicensed) Former user (Deleted) Ashley Ransoo Matt Leech (Unlicensed) Anupama Roy (Unlicensed)	Analysis and refinement: Rotations - Bulk People Import Discussion with data leads and story created for Bulk Rotations import. Assessment Import Template: Discussion with data leads and agreeing on the fields/validations/rules requirements for the template. Developer support: Bulk Uploads Test coordination of the bulk upload and raised feedback on Jira. ESR Integration Testing: Test coordination of ESR integration testing and raised feedback on Jira. North East Support: Relatively quiet this sprint Yorhshire and Humber rollout: Performance concerns Prep for remaining rollout: Rotations UX/UI: Matt TIS Admin UI - Removing items and user feedback: TIS Admin UI - Programmes in People - Removing a programme and user feedback TIS Admin UI Enhancement - UI background and section containers: TIS Admin UI - UI Enhancement - UI background and section containers TIS User Guide: TIS Admin UI User Guide TIS Design to development pre Sketch: TIS Design to development - Post April 2018 - Design files and dev notes
DevOps	Chris Mills (Unlicensed) John Simmons (Deactivated) Frederic Randriamora (Unlicensed)	Chris: Terraform: Modular structure https://github.com/Health-Education-England/terraform-modules (Allows better usability, less copy and pasting, best practice) Remote State managed in Azure (Removes need for keeping state in git and enabled open sourcing/best practice and stops state conflicts Document Storage: Mainly blocked by Hicom but created storage account/container, wrote basic integrity checks and modified them when arrived (2018-04-17) Workflow Improvements: Added basic stuff we should have in github i.e: editorconfig, precommit hooks and simple linting on commit. Keycloak: Begun debug of major issues with keycloak configuration including session cookies, mod_auth_oidc_state problems from apache module. Frederic: ESR, NDW-ETL and Generic Upload deployment process into dev, stage and prod Jenkins documentation, BAU
TIS Core Services: Back end	Paul Hoang (Unlicensed) Sunil Rochani (Unlicensed) Simon Meredith (Unlicensed) Luís Matos (Unlicensed) Suneet Kamath (Unlicensed) Former user (Deleted) Oladimeji Onalaja (Unlicensed)	Post to Programme many to many Changed the One-to-One relationship to Many-to-Many Rotations TIS-NDW ETL General refinement of queries to return more accurate data Added support for CurriculumMembership entity Added support forSpecialty entity Added support forProgrammePost entity Automated the daily run of NDW ETL together with DevOps - daily at 7am Consolidated DR ETL Added support to sincronize ProgrammePost entity betweem Intrepid and TIS databases Added support to sincronize PlacementOtherSpeciality entity betweem Intrepid and TIS databases Fixed issue in Assessment that was preventing CurriculumID from being imported from Intrepid and therefore preventing NDW ETL from exporting Programme, Curriculum and Specialty data to NDW databases Bulk Uploads - People and Placements Reference data refresh Back end field validation improvements Revalidation converted to work against TIS rather than Intrepid
TIS Core Services: Front end	Panos Paralakis (Unlicensed) Oladimeji Onalaja (Unlicensed) Matt Leech (Unlicensed) Shivani Rana (Unlicensed) Former user (Deleted)	Bulk Uploads See Loom video Document Management Backend: Added support to dowload documents Added support to search and retrieve tags Frontend: See Loom videos Multi-Select Widget - Person:Roles Review, Update and Maintain E2E across components New Dropdowns NPN feedback to user following Post creation Panos Rotations CRUD - Create, Edit, Delete (soft) List View/ FIlters Unit testing People-ProgrammeMembership - SIngle select field added fot Rotation Slow Loading Messages Adds new spinner and some messages when API calls are taking time (only on people and posts at the moment). E2E Testing: Implement Cucumber - Protractor framework to implement E2E in BDD Manner Create User Mangement Test Plan in Gherkin Implement User Managment Test Sceanrios in Cucumber Support Release by running E2E regression Test Suite and Report Bugs Update E2E Test cases suite as and When required due to UI Changes	Bulk Uploads (error and auto-refresh toggle): https://www.useloom.com/share/4bb3cd94dba34255861bbb1ca046590f Document Manager (Features): https://www.useloom.com/share/2f8d808ba9494ec1a6bf8970cc5bbb27 Document Manager (Errors): https://www.useloom.com/share/b0b43241c7524d068f4718d8da900199 People - slow loading messages: https://www.useloom.com/share/641cc8fa15a242ac93353e870b14682a
ESR Integration	Former user (Deleted) Ashley Ransoo	Load earliest eligible trainee placement notifications Change ESR ETL to use the PostView to Post referencing (4303) Fix ESR endpoint to not to refer PostView Notification for Applicant withdrawn scenario - Update to medical rotations Notification for new training position created Solution design around new requirements coming out of the testing reviews. Integration testing on a good progress path.
Data Quality	Data_quality colleagues
Resource Planning	Reuben Noot (Deactivated) Andy Nash (Unlicensed)	Agency update One unsuccessful interview on 16/04/18. Currently reviewing more CVs with a view to find a FE dev Full Time recruitment Jayanta Saha (Full Stack Developer) started on 09/04/2018