Versions Compared

Old Version 3

changes.mady.by.user Andy Nash (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Oladimeji Onalaja (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Availability (assume Team Availability Calendar is up to date, otherwise, everyone was available for 7.5 days (this Sprint includes a Bank Holiday) of the 2-week Sprint)

Full team availability 7.5-day Sprint * 9 dev team members (adjusted as below)67.5 days

Pepe -5, Jay -1, Simon -2, Ola -Knowledge transfer


Total team availability this Sprint77%



POs present a review of Sprint goals and other committed work



Sprint Goal: Improve HEE Admin users ability to manage PostFunding more accurately for financial reporting, and ensuring NDW allows users to interrogate up to date data.

Other committed-to work in the Sprint:

  • Remove use of SUPER account on all databases
  • Add WTE to placement overview
  • Dev feedback for Trainee UI to help define possible MVP
  • Deleting We need to move our databases to be managed by our hosting provider (to ensure greater resiliency). To do this we need to modify them (all) slightly first.
  • To indicate which placements are whole time equivalents on the summary screen, rather than force users to drill down to find out this information.
  • Team to assess outputs from the Trainee workshops, to determine what work should be carried out to get us to an MVP.
  • Introduce validation to prevent users from accidentally deleting a curriculum on a trainee record needs a validation message (like when removing a programme from a trainee record)Tech debt: SYNC SERVICE: API Endpoints for each routine and basic web interface to launch them.
  • Work remaining from last Sprint: For those services that don't auto-restart, create an interface for any member of the team to restart any service that fails at any time of day in order to get that service back up and running as quickly as possible for users.



POs supported by Dev team provide narrative on why, and what, emergency work was brought into the Sprint and which committed-to tickets were moved out as a result


Live Issues:

Jira Legacy
serverSystem JIRA
columnstype,summary,story points (effort),assignee,created,status
maximumIssues20
jqlQueryproject = TISNEW AND issuetype in (LiveDefect) AND Sprint = 224 order by created DESC
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7


Dev team demo 'done' work contributing to those goals (no more reference to specific list of Jira tickets, and no more reference to work not 'done')



Item
Non-technical description
Demo - from Prod URL where feasible

1.Add Funding Body to VwPostFunding in NDW for reporting

Ensure that the funding body data is passed over to the NDW each day.
2.Add Field to indicate whether trainee is CCT (Cert of Completion of Training) or CESR (Cert of Eligiblity for Specialist Registration)

NDW ETL is the piece of code which runs everynight 12:20 am to export TIS data to NDW data warehouse so that report can be generated. The user requirements were to export the data of FundingbodyId field of PostFunding table and newly introduced TrainingPathway field  of ProgrammeMembership to the NDW. Those were exposed to NDW through the NDW ETL. NDW Team have confirmed those fields are in Prod.

Work remaining from last Sprint:
Ensure that the training pathway field is included in the data passed over to the NDW each day.
3.Bulk Update Post Funding Episodes using TIS_PostFundingIDs

As above

Give HEE Admins the ability to bulk update Posts Funding details as an efficient way of managing existing Post Fundings in bulk.
4.Remove use of SUPER account on all databases

Video for demo:

https://www.loom.com/share/c8046f0042094fcfae344025f2db2a75

We need to move our databases to be managed by our hosting provider (to ensure greater resiliency).
To do this we need to modify them (all) slightly first
.5
.
Add WTE to placement overview


To indicate which placements are whole time equivalents on the summary screen, rather than force users to drill down to find out this information.
6.Dev feedback for Trainee UI to help define possible MVP

Loom video for demo:

https://www.loom.com/share/6eac79d353b943b88cb2f5cb9e7c0eae

Team to assess outputs from the Trainee workshops, to determine what work should be carried out to get us to an MVP.
7.Deleting a curriculum on a trainee record needs a validation message (like when removing a programme from a trainee record)

Introduce validation to prevent users from accidentally deleting a curriculum on a trainee record.
8. Tech debt: SYNC SERVICE: API Endpoints for each routine and basic web interface to launch them

Demo videos:

  1. Before TIS-ADMINS-UI - ticket 3056 validation_before_inspect.mp4
  2.  After TIS-ADMINS-UI - ticket 3056 validation_after_trim.mp4
Work remaining from last Sprint:
For those services that don't auto-restart, create an interface for any member of the team to restart any service that fails at any time of day in order to get that service back up and running as quickly as possible for users.

sync service dashboard page:

https://stage-apps.tis.nhs.uk/sync/

ARCP Upload support
  1. Input data issues



Stakeholders / Users invited to query / interrogate / applaud (after Sprint Review POs convert consensus inputs into backlog tickets, giving the option to consider them in the coming Sprint Planning)



Sprint Goal: Improve HEE Admin users ability to manage PostFunding more accurately for financial reporting, and ensuring NDW allows users to interrogate up to date data.



POs present the roadmap: https://ext.prodpad.com/ext/roadmap/d8a231e0ec66a7a9ead4f1464ab24fca5b816dbf



Next Sprint priorities