/
2024-03-11 Meeting notes

2024-03-11 Meeting notes

Participants

  • @Joel Collins

  • @Andre Ortega Alban

  • @Andrew Atterton

  • @Gleb Rysev

  • @Marta Badji

  • @Michael Ruston

  • @Oliver Reeves

  • @Philip Main

  • @Retha Steenkamp

  • @Sarah Evans

Priorities (and things what we did)

Andre

  • Reference ranges for PKB

    • Waiting for final confirmation (George) of last code

  • UKRDC tickets

    • Use the processed data to clean the codes and UoM

  • UKRR RDA extract

  • Run NHSE extract for March

  • Check UKRDC test files

Andy

  • RADAR 3

    • Ongoing

  • Catch up meetings

George

On leave

This Week

  • UKRDC Feed Testing

  • Investigate CUPID

  • Validation Testing

  • PHOSPHATE Extract migration, SIMPLIFIED feed migration

    • Investigate missing data

Not This Week

  • INS testing

    • Final queries for Citrus

  • NHSBT - Deletion of Irish Patients

  • PKB usage data transfer

    • Waiting for response to George RE encryption

      • George to chase up

Joel

  • Update (and hand over?) UKRDC Dashboard intro presentation

  • Actually start thinking about moving OneDrive somewhere

  • Schema conversion data storage

    • Merge

  • Finish testing ACT/Data-Collection

    • Work with Michael to archive and decommission Nurture and PV TEST servers

    • Get ACT set up on a new machine

  • Continue working through handover todo list

Marta

  • Data correction - with Data Team and RaDaR Team.

    • Ongoing

  • PKB queries

  • Continue Python course

  • Write a query - deceased patients in UKRDC

Michael

  • NHS SES DCB1596 stuff

  • Work with Joel on server decommissioning and upgrades

  • ACT install - pending firewall rules

  • Intune Updates

Phil

  • CUPID development (onging)

    • Clean up / annotate / test insert code

      • Decide how to handle sites switching renal systems

        • Kings EPIC feed - Likely going to be a combined feed with Guys with a new sending facility - Kind of sidesteps the issue

    • Expand investigations

      • Data model - now separate schema in ukrdc

      • Use case - how are they generated? write tests

      • Associated actions - what I/O does the UI need to resolve/progress investigations?

  • Quarterly Extracts (ongoing)

    • Provide any support for fixes with ongoing testing sites

Sarah

Data work the priority this week

  • Continue working through Python course.

  • Go through UKRR Extract work with Phil

    • On hold until Python course finished

  • General support/tickets

Gleb

  • Continue developing consented_cohort

    • Add/Improve front-end validation for all forms

    • SMS API

    • Email API/SMTP + templates

Oliver

  • RADAR stuff

    • Figure out key id between databases

  • PKB ticket Review Changes

Misc. Notes

Upgrading postgres on RHEL6 servers

https://www.postgresql.org/download/linux/redhat/

Outstanding Tasks