/
2024-02-12 Meeting notes

2024-02-12 Meeting notes

Participants

  • @Joel Collins

  • @Andre Ortega Alban

  • @Andrew Atterton

  • @George Swinnerton

  • @Gleb Rysev

  • @Marta Badji

  • @Oliver Reeves

  • @Philip Main

  • @Retha Steenkamp

  • @Sarah Evans

  • @James Medcalf

Priorities (and things what we did)

Andre - Not in Meeting

  • Reference ranges for PKB

    • Waiting for final confirmation (George) of last code

  • Update UKRDC transfer script

    • Replace AKI script with the new script and monitor

  • UKRDC tickets

    • Extract to get test results per renal unit done, next steps to confirm with George

  • AKI tool ticket

  • Help Beth with AKI db updates

  • UKRR RDA extract

Andy

  • RADAR 3

    • Ongoing

  • RADAR induction type stuff with Oliver

  • PGAdmin issue with Marta

George

This Week

  • UKRDC Feed Testing

  • Investigate CUPID

  • PHOSPHATE Extract migration, SIMPLIFIED feed migration

    • Investigate missing data

Not This Week

  • INS testing

    • Final queries for Citrus

  • Validation Testing

  • NHSBT - Deletion of Irish Patients

  • PKB usage data transfer

    • Waiting for response to George RE encryption

      • George to chase up

Joel - Not in Call

Marta

  • Data correction - with Data Team and RaDaR Team.

    • Ongoing

  • PKB queries

  • SQL course complete

  • Start Python course

  • Run practice queries on UKRDC db

Michael - Not in Call

  • Data Protection Toolkit - Ongoing

  • NHS SES DCB1596 stuff

    • InTune on mobile stuff - further android testing this week, send email this week

  • SSL Certs

    • Validation in progress

    • Ticket in with Gandi to see if we can use UK Charities Register, we don’t have an account with the one we usually use and steph hasn’t heard of it so isn’t keen to pay for it

  • Work with Joel on server decommissioning and upgrades

Phil

  • CUPID development (onging)

    • Clean up / annotate / test insert code

      • Decide how to handle sites switching renal systems

        • Kings EPIC feed

    • Plan investigations (workitems) with Joel

  • Quarterly Extracts (ongoing)

    • Provide any support for fixes with ongoing testing sites

  • Schema converter (ongoing)

Sarah

  • Continue working through Python course.
    Go through data correction work with Marta

  • Go through UKRR Extract work with Phil

  • Working through setup stuff

  • General support/tickets?

Gleb

  • Finish training courses

  • Start Developing consented_cohort

Oliver

  • RADAR induction with Andy

  • NHSBT Tickets

  • PKB Tickets - with Andre

Misc. Notes

Upgrading postgres of RHEL6 servers

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

Outstanding Tasks