/
2024-01-29 Meeting notes

2024-01-29 Meeting notes

 Participants

  • @Joel Collins

  • @Andre Ortega Alban

  • @Andrew Atterton

  • @George Swinnerton

  • @Marta Badji

  • @James Medcalf

  • @Michael Ruston

  • @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

  • Update UKRDC transfer script

    • On progress

  • UKRDC tickets

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

  • AKI tool ticket

  • UKRR RDA extract

  • NHS England extract

Andy

  • RADAR 3

    • Ongoing

George

This Week

  • UKRDC Feed Testing

  • New Starter Induction

Not This Week

  • INS testing

    • Final queries for Citrus

  • PHOSPHATE Extract migration, SIMPLIFIED feed migration

    • Investigate missing data

  • Validation Testing

  • NHSBT - Deletion of Irish Patients

  • PKB usage data transfer

    • Waiting for response to George RE encryption

      • George to chase up

Joel

Marta

  • Data correction - with Data Team and RaDaR Team.

    • Ongoing

  • PKB queries

  • Do SQL course

    • All relevant modules complete

    • Some additional modules still to do

  • (? Start Python course - Chat to Sarah)

  • Run some practice queries on UKRDC db

  • Plan new tasks

Michael

  • 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)

  • Go through UKRR Extract work with Sarah

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?

Helpdesk

Misc. Notes

Upgrading postgres of RHEL6 servers

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

Outstanding Tasks