User story
As a DNAP team lead looking into turn-around times I would like to be able to include time points from Mini LIMS (=SM Workflow LIMS) in my existing reports, which run off the Events Warehouse. This is of particular interest as the biggest time window is currently between when labware is first scanned into LabWhere, and when library prep is started, but there is no detail in between to help determine what's causing the delay. The most important time points to start off with are:
- When first scanned into Mini LIMS
- When reaches 'Report Required' tab
This story is to scope out the work needed to make this happen.
Who are the primary contacts for this story
Danni, Liz E, Katy, Andrew
Acceptance criteria
To be considered successful the solution must allow:
Additional context
It looks like Mini LIMS has an internal 'events' table - these events might already be created at the time points we need - so we could add the RabbitMQ / Warehouse integration to the same points.
Danni has a Tableau report (made / maintained by Matt F) that has a 'created date' in it of interest, which is what prompted them to ask for this feature. It looks like this probably runs purely off the Mini LIMS database, but it might be worth talking to Matt to investigate:
- Whether adding new information into this report would be a useful stop-gap.
- The queries behind this report.
User story
As a DNAP team lead looking into turn-around times I would like to be able to include time points from Mini LIMS (=SM Workflow LIMS) in my existing reports, which run off the Events Warehouse. This is of particular interest as the biggest time window is currently between when labware is first scanned into LabWhere, and when library prep is started, but there is no detail in between to help determine what's causing the delay. The most important time points to start off with are:
This story is to scope out the work needed to make this happen.
Who are the primary contacts for this story
Danni, Liz E, Katy, Andrew
Acceptance criteria
To be considered successful the solution must allow:
Additional context
It looks like Mini LIMS has an internal 'events' table - these events might already be created at the time points we need - so we could add the RabbitMQ / Warehouse integration to the same points.
Danni has a Tableau report (made / maintained by Matt F) that has a 'created date' in it of interest, which is what prompted them to ask for this feature. It looks like this probably runs purely off the Mini LIMS database, but it might be worth talking to Matt to investigate: