2019-07-22 Meeting notes

Tim Whitlock (Deactivated)

• George sent a summary update to Kings last week:

  1) Missing Patients

  We still have ~130 patients that our Validation identifies as being missing.

  2) Placement Treatment Centre

  Done

  3) QBL05 needed

  Done

  4) Treatment Record Discharge Reasons

  I don't think this has been done?

  5) The Treatment Reason (Modality) code needs to be done in as much detail as possible.

  Done - although not checked in detail yet.

  6) The Actual Treatment Center needs to be populated

  We are getting the expected codes with the exception of ones that are coming through as "RJZ?" - if this was migrated data you were unsure about and are unable to confirm could you send it as just "RJZ" please.

  There are also still quite a few where no center is supplied - PD still?

  7) Invalid Doses

  Done

  8) Need to switch to UKRR Code List

  I still need to do this.

  9) DialysisSession/Attributes/QHD21 needs to be SB, RC, BC etc. and not L/R as it is now.

  QHD21 is now being submitted as AVF/AVG/TLN etc. which is also incorrect.

  It should be:

  QHD20 = AVF/AVG/TLN etc.

  QHD21 = SB/RC/BC etc.

  10) Invalid Test Values

  Done.

  11) Lack of Early Biochemistry

  I haven't had chance to investigate the test patient you sent across with full data yet.

  12) Patient with Next of Kin in their Address

  Done

  13) Patient with invalid medication date

  Done

  George Swinnerton will send the updated code list to Hugh this week. There is also a potential issue with validation to do with multiple treatments on the same day. There is an issue in the validation to do with two treatments on the same day with the same modality causing a key issue in the database. Kings appear to have 400+ entries which could fall foul of this issue. In theory there shouldn't be two treatments for the same modality on the same day but there can be more than one. This could be an issue when processing the extract.

• Validation versioning has not been updated yet.
• rapolas (Unlicensed) has added documentation on the rr-hs-live transfer process  File Transfers Andrew Atterton and james.griffin (Unlicensed) to review.
• Andrew Atterton and james.griffin (Unlicensed) have started looking at the documentation. james.griffin (Unlicensed) has highlighted some gaps he will add info on. George Swinnerton will ensure any changes he has made are correctly covered.
• RDA_To_RDA has not been fixed to validate satellite codes yet
• George Swinnerton has started the documentation of the study groups https://confluence.ukrdc.org/display/TNG/Study+Identifiers this would be insufficient for certain scenarios that might be require din the future.
• Andrew Atterton and  james.griffin (Unlicensed) have started at looking at all documentation updated by rapolas (Unlicensed) to ensure he has covered all the gaps.  rapolas (Unlicensed) will produce a list of links to help with this. 
• No progress on the nurture extract
• Atlassian has published another security advisory and recommend upgrading. JIRA and confluence. Tim Whitlock (Deactivated)will aim to get this done this week. We are not actually vulnerable to the issue due to our settings.
• Relocation has a final meet on Wednesday to sign off various required documents for the refurbishment. Once that is done the contract can be signed and the project kicked off.
• George Swinnerton and Andrew Atterton need to look at progressing some of the tickets in the current sprint ready for Validation meeting next week. Currently little has been done.
• RaDaR rapolas (Unlicensed)raised the question a request from Fiona to produce a list of consented users on the old form and what it means this is for the reconsenting that has been planned. He also explained the RaDaR syncing has some issues due to the pid change because previously the pid was split to identify the extract now that information is not directly available in the pid. He had also found as a result of the kings feeds the syncing has never been processing the drug details fully with the dose unit being ignored. This is probably because much of the data had to be derived from comment fields in PV feeds. With the RDA feeds more of the correct fields have data and so the syncing code has been updated. This is now currently working on staging.

George Swinnerton

George Swinnerton has produced extracts for

EQUAL Project -Barney

ANNA - Scottish data and some back loading of data

NHSBT can now be processed as we have the PAEDS csv file. Andrew Attertonto progress this under George's guidance.