/
2023-11-06 Meeting notes

2023-11-06 Meeting notes

 Participants

  • @Joel Collins

  • @Andre Ortega Alban

  • @Andrew Atterton

  • @George Swinnerton

  • @Marta Badji

  • @Philip Main

  • @Retha Steenkamp

Discussion Points

Priorities (and things what we did)

Andre

  • Reference ranges for PKB

    • Waiting for feedback from PKB

    • Then sending screenshots around

  • PKB Scotland send

    • Waiting for confirmation to send last 2 units

  • Data extracts for RECOVERY study

  • Plan AKI extract

    • Likely next week

Andy

  • RADAR 3

    • Ongoing

  • NHSBT

    • File received

    • Ongoing

George

  • INS testing

    • Finishing up

  • 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

  • Go through pentest reports

    • Scope out work needed to secure any high risk points, send to SMT

  • Finish testing ACT/Data-Collection

    • On hold until SQL server is resolved

  • Look into loosening postcode and GP code restrictions in UKRDC incoming feeds

  • Schema conversion data storage

    • Little SQLite database?

    • Use SQL models being used in CUPID?

    • Each new file replaces the previous entry

      • Only need to store most recent entry for each patient

  • Website memberships situation

Marta

  • Start contacting people for data fixes - with Data Team.

    • 2 still waiting

  • Looking at issues with PKB Send (multiple NIs)

    • Ongoing

  • Contact PKB around errors with existing feeds

    • Got a kind-of-final response

    • They have identified the problem but there is no fix

      • They will update us

  • Start looking into common errors (as opposed to work items)

    • Sent around info

    • Aberdeen datetime issue - Discuss with Gary

  • Look through CUPID specs, particularly work items

    • Comments added

  • Data correction/work item documentation

    • Started documenting

Michael

  • Pentest reports

    • Waiting on us for responses

  • SQL Server

    • This week

  • NHS SES DCB1596 stuff

    • Continue through requirements list

  • SSL Certs

    • Abandoning Digicert

    • ukrdc.nhs.uk ordered and received

    • Start order of *.ukkidney.org pro cert org verification

Phil

  • CUPID development

    • Continuing insert logic

      • Document and share plan

    • Decide how to handle sites switching renal systems

      • Kings EPIC feed

  • Quarterly Extracts

Helpdesk

Misc. Notes

Outstanding Tasks