Sprint 37 Review (2017-11-29)

Production Application releases / updates:

Product Management

Reporting

• Discussion opened up with BM's. Proposed solutions overview run through. Outcome of which are:
  
  • Data analysts group – Process component should be defined by the business on how to drive the data output
  • Local Offices to be involved with Data analysts group to ensure their current reporting tools/standards still work when TIS go live
  • Local Offices to provide examples of reports currently used that could be created by Kais and/or JT to test the validity of the proposed plan.
• High level overview of data warehouse presented by Kais - Data marts in the data warehouse will need to have data refreshed more often if not real time.

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.

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

• Active Post with NULL ManagingDeanery values now addresses by the Data Managers, outstanding on the Trust ManagingDeanery data cleanse
• Query created to identify which Trainee is owned by which LocalOfffice How to Identify a which Local Office owns a Person from the Intrepid DR
• Query created to identify which LocalOffice a Trainee has belonged too People | Trainee to Local Offices

Post

People

• Form validation on all required fields now set to trigger on form load. This now applies to all forms currently in TCS with a 'Create'  method (.i.e Programme, Curricula).

Extras

• Upgraded the Mirror hardware which was limiting the ingest performance

Graham O'Regan (Unlicensed)

Russell Steel (Unlicensed)

• waiting on Hicom to relase the following DRv2 fixes;
  vwCPPSPsychologicalReportOverview - currently only contains 1 column;
  
• vwCCPSCaseClose. CaseCloseReason field should be displaying a text reason, but is instead showing a system GUID.

Chris Mills (Unlicensed) 

Paul Hoang (Unlicensed)

Russell Steel (Unlicensed)

• Simplified the ingest code to make it more performant and easier to understand and optimise.
• Fayaz Abdul (Unlicensed) moved the ETLs onto their own machine which allows us to debug seperately the 'out of memory' issue and provide a better space for running such large jobs.

Graham O'Regan (Unlicensed)

Sunil Rochani (Unlicensed)

• Download Inbound xml file, parse it and upload parsed data to TIS

Graham O'Regan (Unlicensed)

Tamer Moustafa (Deactivated)

• Sent Inbound file to ESR, they asked some questions that have been clarified and they have asked for a larger file to test against
• Raised issue around the deanery mappings that ESR use.

• Blue/green changes are ready in development, planning to release over the weekend.
  • (This will enable development to deploy code without massivly affecting the live system and roll back their changes if they see any issues on the seperate instance removing the blocker/possible implications of 'Friday Deploys')
• Separate Elastic search server and ETL server 
  • (Removes any possible issues caused by having a hefty system such as elastic search on the same system as other services. Applications are now split off anything that could affect them increasing resiliancy)
• Migration of Hosted Docker repositority onto Azure Container Registry.
  • (We now no longer need to be running another instance just for our hosted images. They're backed up automatically and managed by Azure, moving more of our infrastructure into Azure's management)
• Added helper scripts to assist creation of docker-compose files from application.yml files.
  • (Speeds up DevOps development and improves onboarding of new Ops staff)
• Added pipeline and files for Oriel ETL and ESR ETL
• Created mock SFTP server for Oriel Testing
• Refactored a number of playbooks for latest Ansible