Sprint 27 Review (2017-07-11)

Alistair Pringle (Unlicensed), Joanne Watson (Unlicensed)

West Midlands training undertaken, now live. North West is to be implemented on Thursday of this week. Wessex and South West implementation blocked by an Intrepid DR issue linked to the consolidation project which also disabled Thames Valley.

All Local teams bar will have been implemented by Thursday and the delay is caused by issues outside our control.

Revalidation deployments to Local Teams

App here: http://dev-apps.tis.nhs.uk/

• Bulk submission issue has been observed again in Revalidation Alex Dobre (Unlicensed) → turns out the users where double clicking on the submit button 

Panos Paralakis (Unlicensed), Alex Dobre (Unlicensed)

• Manage Connections UI inside the Admin portal - https://dev-apps.tis.nhs.uk/ui/
• Alex Dobre (Unlicensed) → no progress during this sprint

Alex Dobre (Unlicensed)

Paul Hoang (Unlicensed)

Sunil Rochani (Unlicensed)

Panos Paralakis (Unlicensed)

Graham O'Regan (Unlicensed)

Steven Pettengell (Unlicensed)

Alex Dobre (Unlicensed), Paul Hoang (Unlicensed), Sunil Rochani (Unlicensed), Panos Paralakis (Unlicensed), Graham O'Regan (Unlicensed) Steven Pettengell (Unlicensed)

ETLs and Data Quality

• Paul Hoang (Unlicensed) -
  • Configuration for TCS now in place with multi field equality
  • Fixed performance issues on TCS entities
  • Fixed getAllDtos for all clients
• Sunil Rochani (Unlicensed) - 
  • Change intrepid-dr-etl to support view name prefixes (Revalidation ETL)
  • Modify db-to-csv to support a view name prefix environment variable.

• Russell Steel (Unlicensed) -
  • familiarised with the Hicomm Intrepid data repository database, data flows & known data quality issues.
    
  • built and tested reconciliation queries being the Hicom DR and TIS Mirror database
  • assisted DEV team in identifying and resolving DR tables with duplicated data
    
  • investigated the GAP analysis between the Intrepid DR and TIS CRUD screens
  • investigated how to identify the current Programme for a Trainee, and found some examples where a trainee has multiple vwProgrammeMembership.PCFStatus = 'Current' rows - Trainees with Duplicated Current Progs.xlsx
  • assisted the ProductOwners by data profiling the Post and PostFunding data available in the Hicom DR tables and schemas - Intrepid Data Repository Profiling & Quality 

Admin UI

• https://dev-apps.tis.nhs.uk/ui/
• Panos Paralakis (Unlicensed)
  • Full code coverage
• Imported services Unit Testing improvements

• Steven Pettengell (Unlicensed) Navigation for 'People', creation of a form design system, general level 3 navigation plus suggested landing page. https://hee-tis.atlassian.net/wiki/x/ZiKNAw
  

Programme and Curricula

• Alex Dobre (Unlicensed) / Panos Paralakis (Unlicensed)
• View Programmes
  • Smart Search added (backend and UI) - show which fields are searchable
  • Column Sort added (backend and UI)
  • Column Filtering added (backend and UI) - show filter data retrieved from reference?
  • User roles implemented to filter programme visibility, including London aggregate ( Alex Dobre (Unlicensed))
  • UI changes - remove ID column, make 'Managing Deanery' into 'Local Team', tidy the Active/Inactive flag texts, replace View/Edit/Delete button column with row click
• Create/Read/Update Programmes and Linking Curricula to a Programme
  • Steven Pettengell (Unlicensed) further UX/UI increment on linking curricula to a programme. Two iterations: 1st - Landscape layout for improved desktop experience, 2nd - Changing page structure from modal pop up to inline editing and therefore optimising design for this, plus creation of a form design system. https://hee-tis.atlassian.net/wiki/x/hQyJAw
  • Panos Paralakis (Unlicensed) UI implemented - modal create/update form merged into View page
  • Alex Dobre (Unlicensed) 

• Alex Dobre (Unlicensed) - show programme validation on the server side
 

• View Curricula
  • Smart Search backend implemented
  • Column Sort added backend implemented
  • Column Filtering added backend implemented
  • User roles implemented to filter Curricula visibility

• Mirror has been running properly for a few days, aiming to swap reval to the mirror on Monday.
• Had to add support for table prefixes (Sunil Rochani (Unlicensed)) and using a different database to the intrepid-extract and intrepid-load jobs in Ansible and Jenkins.

• New server set up with N3 access on the london network
• Moved developer virtual network to new CIDR block so we can connect the London network using a VPN
• Stage and Prod are due to be moved tomorrow.

Fayaz Abdul (Unlicensed)

• Simplified the inventory management in Ansible
• Added new tasks for extracting data from the UAT environment.

Fayaz Abdul (Unlicensed) tasks

• Tuned down the elasticsearch memory alerts
• Moved intrepid mirror to producion resource group.
• Cleanup of archived jenkins projects

Alistair Pringle (Unlicensed)

Joanne Watson (Unlicensed)

• Former user (Deleted) / Joanne Watson (Unlicensed) / Alistair Pringle (Unlicensed)

Components have been updated on both JIRA and the Product Wall with the dev stories and TCS MVP stories separated out from the remainder of the backlog.

After Programmes and Curricula we are now working on the Post component. User journey has been plotted and stories placed against each step.  Fields to be included in the post form have been shared.

Digital Outcome procurement - TIS Core Services Alpha/Beta

Contractual terms and negotiations continue, resourcing the roles is continuing, Ravindra (FE Dev) has left the team.

Full Time recruitment

A number of full time roles are back at advert - Building the HEE Team