Sprint Priorities
The following list was the prioritisation output from Sprint Planning:
...
Migrate to DR V2
ETL refactoring - performance and stability
Create User automation - becomes a non-developer task
Oriel - complete to load data into TIS Production
...
Item | Owner | Link |
---|
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.
Reviews UX reviews of current build. Created 3 lists 01 List - current | - 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
UX / Ui
Review Transferred the 3 review lists into confluence, rewriting/renumbering to make clearer - linking screen caps and design PDFs Covering: 01 implementation that does not match design 02 List - 02 designs created and not currently implemented 03 List - small tweaks to improve existing implementation (small design work needed) These now need to be written into dev stories https://hee-tis.atlassian.net/wiki/x/JgCKCQ Revised mega menu/ navigation based on review Menu: With current low Navigation L2 item content the mega menu is not working creating a disconnection between parent and children navigation items and excessive mouse travel. We need to either 1/ move content to sit under relevant menu item NOT justified to the left in the existing mega menu band or 2/ make individual menu drop downs. Menu can always switch back to original mega menu when content grows. Menu Indicators: Add Page indicator to L2 items Subtitles for MM Admin UI/Admin Looking at not available L2 items
Trainee Menu: Implement page highlight New back button on L2 mobile menuTrainee 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/GIB5CQ/CwBuBw
Recommend New Trainee site / desktop view - Long form style is carried across to Admin site / desktop view - Long form. |
Intrepid Data Quality | Russell Steel (Unlicensed)Active Post with NULL ManagingDeanery values now addresses by the Data Managers, outstanding on the Trust ManagingDeanery data cleanseQuery created to identify which Trainee is owned by which LocalOfffice How to Identify a which Local Office owns a Person from the Intrepid DRQuery created to identify which LocalOffice a Trainee has belonged too People | Trainee to Local Offices |
|
TIS Core Services Alpha build | | Admin UI Refactored all forms across the app, Programmes, Posts, People and Placements 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).
Extrasto use a Bootstrap layout rather than the custom one we previously developed Programmes Specialty / Specialty Group updates Posts - 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.
- First phase of Assessment ETL is completed - 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 Issues - PP: Fixed dropdown appearance
- PP: Delete option has been removed from all "create" forms
- PP: Orphanmenu items are now hidden from users
Improvements Code quality, and code coverage 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
Trainee UI - PP: Navigation menu is now ordered to match the design. Forms has been split to Form-R-a, Form-R-b
- PP: Mocked view of Form-R-a is in place
|
Intrepid Mirror | |
Upgraded the Mirror hardware which was limiting the ingest performanceHaving to move to a new mirror because the collation on the existing boxes was causing problems for the london reports |
Intrepid DR v2 | Graham O'Regan (Unlicensed) Russell Steel (Unlicensed) | - waiting on Hicom to relase the following DRv2 fixes;
vwCPPSPsychologicalReportOverview - currently only contains 1 column; Image Removed - vwCCPSCaseClose. CaseCloseReason field should be displaying a text reason, but is instead showing a system GUID.
| Intrepid ETLs | Extracts against DR2 have been running for the past two weeks to test performance |
Intrepid ETLs | Graham O'Regan (Unlicensed) 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 As part of the move to the new mirror the ETLs are being rerun, hitting problems with jobs timing out during runs. |
Oriel Integration | Graham O'Regan (Unlicensed) Sunil Rochani (Unlicensed) | Download Inbound xml file, parse it and upload parsed data to TISETL code is complete with unit tests and is now waiting Programme and Immigration data mapping from Data Managers in order that we fully automate the integration and don't need to implement the 'review and map' screen within Intrepid |
ESR Integration | 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 againstRaised issue around the deanery mappings that ESR useESR team have agreed that we can enable the interface with just one week's notice. Former user (Deleted) has picked up the code for the ETL and service. |
DevOps | | - 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/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
- UAT servers set up on production, needs to be redone because it is sharing the production vnet.
- 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.
|
TIS Cutover | Reuben Noot (Deactivated) | Summary of the TIS Cutover discussion had with Business Managers |
Resource Planning | Reuben Noot (Deactivated) Andy Nash (Unlicensed) | Full Time recruitmentWelcome to John Simmons (Deactivated) our new DevOps Engineer, to Anupama Roy our new User Researcher who started last weekStill waiting dates on SDIT, FE Dev and User Researcher - awaiting confirmation and start dates. Interviews for Stakeholder and Engagement Manager - 28/11/17. Offer will be made on the 29/11/17 for start in January. Quality Testing Engineer (Rana Shivani) starting in December - date still to be confirmed). Front End Developer (Satia Pattamatta) starting on 1 December. UX/UI Designer (Matt Leech) starting in December - date still to be confirmed ?11th? Agency update Fayaz replacement (Frederic Randriamora) starting on 11 December. |