Sprint 37 Review (2017-11-29)

Production Application releases / updates:

Product Management

• Looked at Automated ingestion of Oriel import rather than managing incomplete fields in a UI
• Programmes mapping identified as a task to be completed by Data Leads and get confirmation from LO's
• Looked at mapping and managing Immigration statuses and identified discrepancies. This is another task identified for Data Leads to complete.

Bulk Upload of People

• Finalised stories and validation rules as well as the minimum set of fields to validate in the import.

Reporting

• National Datawarehouse meeting with TIS Team and Data Department colleagues took place on Friday 24th to discuss steps taken in the project so far and creation of actions.
  • JW ran through the needs of the end users
  • Actions split into two parts - technical and business
  • Business actions:
    • JW to forward to JT a list of example reports that are needed by all/majority of local offices to allow us to see if the data warehouse in its current build can produce these reports. If not it will be improved/fixed to allow this.
    • Use Tableau to test if the reports can be accessed by a variety of end users with the use of filters to allow the production of reports by local offices, programmes, trusts etc.
    • Look at automation of production of reports

Autogeneration of NTNs

• Data flow from Oriel to TIS and additional info needed for NTN creation
• Meeting set up with SMLs for the 28/11/17 to agree/understand NTN creation requirements

Rationalise MVP Stories

• MVP stories moved across from TIS backlog into TISDEV
• all other product focused stories reviewed and moved as appropriate

ESR Mapping

• ESR mapping completed and updated to meet current values

Case Management

• walkthrough of concerns log held and confirmed as okay for use fro case management if,
  • case types can be added
  • case types can be limited to a particular audience

• entry of new case records, or manual entry of current cases
• manual upload of historical cases against trainee record

https://hee-tis.atlassian.net/wiki/x/JgCKCQ

Trainee site / desktop view - Long form (responsive up)

More columns at 1200 and 1600  than current Admin site / desktop view (therefore more below 1200) So an increase of columns per break point excluding mobile phones portrait.

Tighter vertical grid (than current Admin site / desktop view)

New way of measuring/labelling vertical grid based all on baselines which will allow type size to be tweaked without breaking grid.

Smaller type sizes (than current Admin site / desktop view)

New graphic treatment so page works when sections are in read only mode as well as edit mode.

1600 max form size rather than full screen

Background / side border treatment as information stays at 1600 and centers when on a 1900 screen.

https://hee-tis.atlassian.net/wiki/x/CwBuBw

Recommend New Trainee site / desktop view - Long form style is carried across to Admin site / desktop view - Long form.

• Funding body added to Posts
• Local office field 'narrow as you type' fixed

Placements

Alex - refactoring of ETL, microservice and UI

Assessments

• New service built and deployed on DEV.
• ETL status - Sunil
• UI update - Ola

Test coverage

Unit test coverage on Posts has been improved

E2E tests has been improved across all objects - Panos to summarise

User Management

• Create admin user has been fully automated behind the Keycloak user creation screen so no requirement for a developer to script users or roles/permissions into the Profile service anymore. (Update roles still to add so permission changes to existing user still need develper input)
• Password Reset implemented and styled within Keycloak including emailing reset token to user, our first outbound system email

Graham O'Regan (Unlicensed)

Russell Steel (Unlicensed)

Chris Mills (Unlicensed) 

Paul Hoang (Unlicensed)

Russell Steel (Unlicensed)

Graham O'Regan (Unlicensed)

Sunil Rochani (Unlicensed)

• Blue/Green is now deployed on dev/stage/prod this will allow us to make smaller changes within normal hours. You can check which node you're on by checking the Headers section of the request and looking for X-Request-Node: BLUE/GREEN
• IE 11 compatability mode has now been forced off for all users, this is a meta tag added server side.
• We have a postgres server terraformed under azure managed service that you can use.
• Logs and ES have been seperated and all monitoring changes been made to match new hosts.
• TIghtened up some issues security wise within the infrastructure and saved some money by shutting down unused sample resources.

Reuben Noot (Deactivated)

Sprint 37 Review (2017-11-29)