Repository navigation
Implement EHR queries #75
Description
Description
Implement EHR
Definition of Done
- Automatic queries populate a csv with data listed in the requirements in ticket #129
- This is linked using the #ID to the patient where it came from
Dependencies
Comments
@skeating to check what we have available in Chimera
Metadata
Metadata
Assignees
Labels
No labels
Activity
MonikaSvata commentedon Aug 5, 2026
@skeating reviewed the code written for Chimera and Waveform controller.
Writing plain SQL queries progressing
MonikaSvata commentedon Aug 7, 2026
MRN or location string would be useful to receive for @skeating - @jeremyestein to send
MonikaSvata commentedon Aug 10, 2026
Claire to email MRNs to @thompson318 on UCLH email.
skeating commentedon Aug 17, 2026
@thompson318 is working on automating the running of the queries
@skeating will continue from where she left off
thompson318 commentedon Aug 19, 2026
In progress, no blockers.
skeating commentedon Aug 24, 2026
Steve still working through connecting to 2 different data bases via snakemake
Sarah still working on queries
thompson318 commentedon Aug 26, 2026
Steve will be busy on other projects for the next couple of week. Arrange to catch up with Jeremy to discuss possible handover.
[-]Implement EHR[/-][+]Implement EHR queries[/+]MonikaSvata commentedon Sep 4, 2026
@jeremyestein to review Steve's two branches.
Caboodle queries are in a separate repository and need to be copied over.
MonikaSvata commentedon Sep 7, 2026
@jeremyestein to
MonikaSvata commentedon Sep 9, 2026
Airway query - the flowsheet IDs we have do not match up and we are getting strange information.
@skeating and Claire to meet on 11th Sept to try to work this out.
All other queries are done.
MonikaSvata commentedon Sep 9, 2026
Scripts need to be sanitised.
MonikaSvata commentedon Sep 11, 2026
PR 181 from EMAP repo to be reviewed
MonikaSvata commentedon Sep 14, 2026
Jeremy and Steve to review and address comments from Sarah's review.
System test the changes on database queries.
MonikaSvata commentedon Sep 28, 2026
To be merged after Jeremy reviews comments