Sprint Priorities

The following list was the prioritisation output from Sprint Planning:

Noting availability is lengthened as the sprint 33 review is on Wednesday 04/10/2017

Joanne 1 day
Panos 3 days
Ashley 9 days
Alistair 8 days
Simon 5 days

Product Management

SMLs given access to Staging/Production - P&C and Posts
Approvals MVP product/solution design
Case Management product/solution MVP design
Leave Management and Course & Event Management MVP design
Assessments refinement
Admin User Management design
People field grouping and ordering

Development

People - revised styling, grouping and ordering (first section initially) for 2/3 column model, review 4 column model (approach and effort), push through all other sections on the CRUD
People back end - qualifications, people-programme,
Google analytics - lock to production
Connection discrepancies - check live and roll out further
Trainee UI continue to build out including landing page with placements, skin deep - hook into devops work
Posts 2nd increment

Data and ETLs

ETL performance issue
People ETL
Move to new platforms once GMC whitelist IPs
move to data warehouse SQL server
Provide ESR with sample docs for testing
Unlock Oriel

DevOps

Move to new platform
Keycloak upgrade production and 2nd instance for Trainee UI
TraineeUI build pipeline - sites through dev, staging, production, choose URL (Ray)

Contents

The following items to be shared by team members during this sprint review

Item

Owner

Link

Production Application releases / updates:

Releases

TIS-18

TIS-19

Product Management

Alistair Pringle (Unlicensed)

Joanne Watson (Unlicensed)

Former user (Deleted)

Russell Steel (Unlicensed)

Steven Pettengell (Unlicensed)

Approvals

discussions held with some SMLs, but no final design yet
blocker on engagement with SMLs due to non-attendance, (next sprint we'll try new things such as including weekly exports of Confluence analysis to MS Teams and continuing ad-hoc calls)

Approvals

Case Management

discussions held with some SMLs, but no final design yet
likely that concerns log will be re-purposed to suit case management

Case Management

Leave Management (incl Courses)

scenarios drafted, but pending validation

Absence Management - Scenarios

People refinement

Addition of Adding and subtracting whole paragraphs
Supported ui design / development of sub-sections, programme membership, re-ordering etc

Assessments refinement

initial scenarios defined, to be validated by Joanne & SMLs
field validation (round 1) completed

Assessments

Admin User Management

scenarios defined
password setting scenarios defined
password policy conversation scheduled

Admin User Management (roles and permissions)

Trainee UX / UI

Trainee UX on hold

Admin UX / UI: Long form iteration 2

The bringing together of work done on Programme/Curricula, Long form pages, People and Posts to refine long form system.

Showing how when optimised at 1200px screen size - we have a 3 column grid which should be utilised (not using just 2 of the 3 columns).

How long forms responsively adapt from 576 -1200-1600 . It is pointless having a responsive design unless tables and forms responsively adapt to utilise the extra real estate. Break points and expansion.

A new vertical grid making tighter looking units

Iterating height of individual fields, so they work better as individual units.

New position of field controls for various scenarios so far uncovered.
New visual design of field controls + - .
New visual design of field drop downs
New visual design of field lines.
New roll over state of field controls
New way of using ‘start typing’ on ACTIVE text field only’.

Responsive Field flow

Adding and subtracting whole paragraphs

Adding and subtracting multiple Fields under one field title.

TIS Admin UI - Form Design

Manage GMC Connections

Panos Paralakis (Unlicensed), Alex Dobre (Unlicensed)

Tweaks in Release 18

TIS Core Services Alpha build

Alex Dobre (Unlicensed)

Paul Hoang (Unlicensed)

Sunil Rochani (Unlicensed)

Panos Paralakis (Unlicensed)

Emanuele Fortunati (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)

Posts, People, Placements

		People
View	Server
	UI
Create	Server
	UI	~
Validate	Server
	UI
Entity Structure CRUD	Server
ETL
E2E

Intrepid Mirror

Graham O'Regan (Unlicensed)

Russell Steel (Unlicensed)

HEE signed off the Intrepid Data Consolidation project, and a Production single DB instance was released on 25/10, single instance means that the RecordOrigin is not set globally to HEELIVE, a new view vwLocalOffice has been created to enable the identification of the data back to the source region;

Though the LocalOffice data is not complete, as over 53k vwPerson rows currently have a NULL LocalOffice value, which means the Programme, Trust or Site data has to be used to determine which LocalOfffice a person belongs to;

TIS DR db moved from Azure to locally hosted SQL Server to improve performance, DR ETL jobs updated to sync to new DB server.

Intrepid DR v2

Graham O'Regan (Unlicensed)

Russell Steel (Unlicensed)

Hicom released DR v2 late on 02/10, though haven't yet pointed the DR and a consolidated data source, and some of the sensitive data fields are still to be exposed in the DR.

The updated DR now give access to AccreditationPathway, CPPS Cases, ESR, and additional Placement, Post and Programme data.

DR v2 also gives us a realtime sync to the underlying Intrepid data.

The LocalOffice data has been expanded to cover the following data objects;

Keycloak

Graham O'Regan (Unlicensed)

Oriel Integration / ESR Integration

Graham O'Regan (Unlicensed)

Joint communication statement agreed.
ESR team have provided sample outbound files.
Timescales for initial pilot discussed.

DevOps

Fayaz Abdul (Unlicensed)

Chris Mills (Unlicensed)

Migrated all environments to new vnets
Docker container cleanups
Snapshot of disks
Peering our vnets to reach DWH SQL
Cleanup ansible playbooks and new version of ansible (2.4)
Monitor the monitoring
Moving monitoring servers to tools network so that they can monitor the whole estate.

Work Done

Remove transformcloud.net from apache configs. Set up temporary GMC API proxy. Improved monitoring output into slack. Triaged issues with stack on various days. Corrected some issues with JAVA_OPTS on ES that were misconfigured. Worked on a number of other items which aren't fully complete yet.

Pending Work

Elasticsearch upgrade to 5+ (This is sat on a branch currently but I've hit some issues in regards to permissions within ES. They have altered quite a lot in the migration from 2→5 so just need to check a few things over.)
Registry UI Upgrade (This is also sat on a branch. It uses Jess Frazelle's Registry UI with Clair running from the ansible playbooks in docke-compose. We can use this to check standard vuns in binarys within the containers we use.) Pending is basic auth adding to the UI using the .htpasswd we pass with basic-auth.yml
N3 Bridge. (I've requested access so hopefully should get that soon but started mocking the tunnel. I've written the ansible parts to standardise the security of the machine. I've toiled with the idea of using the machine infront of me as a tunnel.)
Error Pages. I developed the basic example Steven created. Just requires some input from Alistar/Joanne

Resource Planning

Reuben Noot (Deactivated)

Full Time recruitment

Update on Joanna

Offers made to SDIT, DevOps, FE Dev - awaiting confirmation and start dates

Session recording:

......

Note:

Session recordings made with Webex. You will need to install the Webex video player appropriate to your device from here:

Browser not supported