/
2020-08-17 Meeting notes

2020-08-17 Meeting notes

Date

Attendees

Goals

  • Review weeks progress plan work for the week

Discussion items

ItemWhoNotes
General Reminder

Timesheets should be completed on the day work is done or the next morning not days later when exactly what was done has been forgotten. The entries should clearly identify what was being worked on using the   comment field so that time spent working on a specific ticket or task can be clearly identified. Currently everyone's time-sheets are not up to date.

Jira Tickets when work is done on a Jira ticket it should be assigned to you if it  isn't already. The ticket should be updated regularly to document the what work was done and how the ticket was completed. Ideally someone looking at the logs and comments should be able understand what was done to be able to extend or replicate it. Several tickets are indicated as being in progress with no documented work. Some have even been marked as done yet record no details of work completed.

When on holiday or out for an extended period please ensure you set up an autoresponse for emails so that those emailing you know you are out of the office and when you wil be back to attend to their email. 

Outstanding Items
  • NHS identity registration for accessing the DLP has been done by Tim and George. Retha confirmed she had had an email saying that two people were registered. Suggesting that there is no follow up email and it should be possible to login to the  DLP at https://dsp-portal.digital.nhs.uk/. Tim found he got a message saying account locked when trying. George will also try and if successful will upload a test file for the NHS England Extract. Retha has sent George the latest document defining the required data. This information needs to be added to the NHS England extract documentation... /wiki/spaces/RR/pages/1310883954/NHS England Extract which needs updating to reflect the changes to the  
  • Adding tracing records to UKRDC. James is in a position to test the adding of successful records to the ukrdc which he will do this week. He raised the question that the current documentation (https://confluence.ukrdc.org/display/TNG/Tracing+Response+to+RDA)  doesn't have locations to record success/failure codes This means currently only success can be recorded by adding a record (lack of a record implies no tracing  success). Failure will not be recorded against the record. George Swinnertonwill look at where/how this data could be recorded in the schema. Potentially this could be on the patient record as a tracing success/failure code. 
  • Tim@renalware should be back from holiday this week. George will chase him this week if he doesn't hear anything about the mapping fixes for medicine doses.
  • Quick loading of Q100 files is awaiting a decision from Retha and James...
  • James hasn't yet added any further documentation on the creation of the BCH virtual image. This will be done this week.
  • George didn't try to access the Alphastudy site until Friday when he found the credentials he had didn't work. He has asked Fioan if she has any more recent ones. Without these the site can't be backed up.
  • No questions have come back from the BCH Star registry.
  • National Opt out all extracts from now on need to be passed through national opt out as we will be expected to do this from the end of this month. This means ensuring we have a cr list of NHS numbers to submit and use to filter the extract.
  •  Andrew was responsible for the covid-19 reporting this week he reported it all worked as expected and no issues arose. He is confident that he fully understands the process and all the necessary documentation is in place though currently documentation on the jupyter notebook used by stats to pull out the files has not been done. He understands what is involved and will be managing the process from the system teams point of view moving forwards.
  • George reported that the Barts Q98 file contained odd values for QHD20 filed which had a string "Does Not Contain" rather than a valid lookup from the permitted list. This will be prevented moving forwards by validating the field and import. This will probably be done in code to ensure it validates against the correct lookup list. In this case they are using the values defined in the dataset whilst it is likely in the future some sites will start using snomed codes instead. The issue has been fixed for now.
  • NICOR linkage George reported that the credentials used whilst giving access to a dropbox folder were not the way the data should be uploaded and that the portal should be used. Currently no details of the portal login are known. Katharie is apparently following this up now she has returned from holiday.
  • HES the next HES linkage needs to be submitted by the end of August because it takes 3 months to do. This means the identifiers need to be extracted as soon as possible. Anna will do the paeds George will need to do AKI and renalreg database. These identifiers will need to be passed through national opt out before being submitted to ensure we meet the new data governance rules. George pointed out that the BAPN database does't hold all the paeds patients as some are only in the renalreg database. He also would like to find a better way to store study ids in the ukrdc and will raise this with Nick to see what he suggests.
  • PHE covid-19 linkage this extract is similar to HES but includes PV and Radar patients. This needs to be submitted at the beginning of September.  James at PHE was asking to get the files ideally on a Monday for processing that week so this would mean files need submitting on  If looking at around the 1st September.
 AKI Tim Whitlock (Deactivated)

 The AKI documentation needs reviewing by Andrew with James to ensure it clearly documents all that he needs to know to manage the AKI extracts.James warned some changes would be required to meet the latest requirements from Anna and this work will need to be scheduled in time for the extract to be done. Andrew will review the process and documentation with James and confirm everything is there. Where necessary he will ensure further documentation is added. 

George Swinnerton will look at https://jira.renalregistry.nhs.uk/projects/AKI/issues/AKI-109 and ensure that the necessary changes are made to the validation code as per the ticket. He will need to verify with Anna that this resolves the issues she has and also check what needs to happen with any historic data that failed to load correctly.

Action items

  • NICOR Linkage Update 
  • George Swinnerton to manage the HES Extract to be submitted before the end of August 
  • George Swinnerton PHE linkage for covid-19 this needs to be ready to submit by the beginning of September ideally submitted on   
  • George Swinnerton Look at 
  • Andrew Atterton to review AKI process and ensure all the necessary documentation is in place. If necessary ensure any extra notes are added  
  • George Swinnerton to resolve 
    Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
     and ensure it sorts the issues Anna has highlighted