2019-04-15 Meeting notes

Tim Whitlock (Deactivated)

• Simplified is still not automated. The code has been added to systems-live but now needs code to make an SSH connection for database connection on the UKRDC database server.
• Kings have not resent data, acknowledged emails or updated the extract so are no further forward. George will chase again.
• George Swinnerton has followed up on the paeds fields that don't map readily. Fiona is visiting GOSH today and it is unclear how much development resource is available to produce an extract/ spreadsheet. Some of the visit is about whether/how the data is being recorded for some of the required fields.
• George Swinnerton has created JIRAs for each of the PV issues raised during the pentest. Nadim has apparently responded that they are a low priority. Currently they are being reviewed by SSG developers.
• PenTest issues raised for both the internet and N3 have been addressed and corrected for SSL/.htaccess related issues. SO now the sites report A+ ratings for SSL. Issues with out of date Nginx on the metabase docker setup have been corrected.
• rapolas (Unlicensed) hasn't yet addressed the pentest issues raised on international radar yet.
• All radar related N3 issues are now resolved.
• George Swinnerton has made no further progress on resolving the study groups and programmemberships.
• Tim Whitlock (Deactivated) Jira servers as RedHat 7 to allow newer git deployments for bitbucket.
• UKRR Extract nothing further can be done until we have more kings data.
• All validation tickets due have been addressed and are in review. Fran was due to look at these last week. The only outstanding issue is the new reporting requirements which is currently a work in progress.
• rapolas (Unlicensed) flagged a ticket 
  Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
   that requires exports of data from two different cohorts that is not supported by design. Also RaDaR supports 0 and 9 for unknown gender one meaning unknown one meaning not stated. UKRDC only has 9 decided to restrict RaDaR to 9 only. 

 Tim Whitlock (Deactivated)

 The current schema definitions for PV and the UKRDC contain no changelog or version information. It would seem sensible that we include version information in the schema file the suggestion is to include:

<?xml version="1.0"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" version="X.XX">
    <xs:element name="patientview">
        <xs:annotation>
            <xs:documentation>
                PatientView XML Schema
                Version Info:
                Version Number: X.XX
                Date of Creation: 15th April 2019
            </xs:documentation>
        </xs:annotation>
     </xs:element>

</xs:schema>

This will be particularly important when rolling out the ukrdc schema implementations and ensuring the extracts conform. Currently changes are not documented except by version control and it is unclear to a third party why changes may have been made.

Proper document control will be required to ensure developers of extracts know what is expected.

Tim Whitlock (Deactivated)

Shaun has pointed out that the login report produced for Leeds only uses the last login field and not the "current login field" It should really report the current field unless empty in which case it should report the last login page. George Swinnerton will look at the code and correct.