Priorities (and things what we did)

Andre

• 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

• New Starter “Stuff”

• Investigate CUPID

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

• Finish chore: migrate to select api by jtc42 · Pull Request #780 · renalreg/ukrdc-fastapi (github.com)

• Schema conversion data storage

  • Waiting on schema release 4.2

• 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

• SQL course complete

• Start Python course

• Run practice queries on UKRDC db

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)

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 going through consented cohort spec and docs

• Tickets?

Oliver

• RADAR induction with Andy

• Tickets?

Misc. Notes

Upgrading postgres of RHEL6 servers

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

Outstanding Tasks