Proposed Survey Transfer Process
Currently the proposal for the Survey transfer from Patientview to the Renal Units System is based on the simple diagram below
Description
Patients answer the survey using a computer or tablet via the patientview web interface. The input screens will be developed as part of this project allowing the collection of all 3 surveys PAM, PROM and PREM. However this project will only collect and return the PROM and PREM surveys.
Patientview will then send back the filled survey details via a webapi to the UKRDC using the rda survey schema referenced below. This survey will then be saved to the UKRDC repository.
The same rda file schema will then be used to send the survey data to the patients unit for display in the clinical system. Initially the plan is to use an sftp based transfer system where the ukrdc uploads the files to the units site or the units poll an sftp server at the UKRR though this is not envisaged to be the only method long term.
Transfers to Renal Unit Clinical Systems
There are a number of potential transfer methods that could be used to send the survey data as an xml file back to a given renal unit. Initially it is proposed that an sftp server is used to transfer the files. This could be the sftp server UKRR host sftp.ukrdc.nhs.uk or it could be sent from the UKRR to an sftp server hosted at the renal unit.
The current process configured in mirth is to identify which unit the survey is for and then use a specific sftp transfer process for that unit. This connects to an sftp server configured at the unit. By default initially each units files went ot a folder on the N3 SFTP server internally. This setup just needs pointing to the correct units server when details are available. It will also be necessary to ensure aimes has enabled outgoing transfers to their server ip on the required port.
It is envisaged that this transfer process could be developed further to use more web based protocols.
Schema for Transfers
https://github.com/renalreg/ukrdc/blob/master/Schema/Surveys/Survey.xsd survey xml definition this would be combined within a PatientRecord which would contain the necessary matching fields/identifiers.
Schema Notes
The ProgramMembership should be used to record which project(s) the patient has consented to. This will then be used to control which surveys are them made available to different projects. If the source system does not know the date of recruitment then the date the survey was completed should be used. The UKRDC Repository has logic to manage these dates.
The Template Field records metadata for the scanning process and should not be completed by other systems.
The main change from previous versions is that for the PAM survey the Score and Level are now separated out into different elements to allow them to be coded separately.
We do have SNOMED codes for most of the Tests and Levels however these are not available for individual questions and so at the moment we are leaving PV and other external systems to use our own codes for everything.
Sample RDA FIle containing the Four Surveys
Developers should make use of the schema at https://github.com/renalreg/ukrdc and not just use the example below.
<?xml version="1.0" ?>
<ns1:PatientRecord xmlns:ns1="http://www.rixg.org.uk/">
<SendingFacility>RL7</SendingFacility>
<SendingExtract>SURVEY</SendingExtract>
<Patient>
<PatientNumbers>
<PatientNumber>
<Number>1745438912</Number>
<Organization>CHI</Organization>
<NumberType>NI</NumberType>
</PatientNumber>
<PatientNumber>
<Number>1745438912</Number>
<Organization>CHI</Organization>
<NumberType>MRN</NumberType>
</PatientNumber>
</PatientNumbers>
<Names>
<Name use="L">
<Family>OLDERSHAW</Family>
<Given>RICHARD</Given>
</Name>
</Names>
<BirthTime>1985-04-28T00:00:00</BirthTime>
<Gender>0</Gender>
<Addresses>
<Address>
<Postcode>RM14 3PJ</Postcode>
</Address>
</Addresses>
<EthnicGroup>
<CodingStandard>NHS_DATA_DICTIONARY</CodingStandard>
<Code>A</Code>
<Description>White British</Description>
</EthnicGroup>
</Patient>
<ProgramMemberships>
<ProgramMembership>
<ProgramName>YHS</ProgramName>
<FromTime>2018-04-16</FromTime>
</ProgramMembership>
<ProgramMembership>
<ProgramName>SHD</ProgramName>
<FromTime>2018-04-16</FromTime>
</ProgramMembership>
</ProgramMemberships>
<Surveys>
<Survey>
<SurveyTime>2018-04-16T00:00:00</SurveyTime>
<SurveyType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>PROM</Code>
</SurveyType>
<Questions>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ1</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ2</Code>
</QuestionType>
<Response>0</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ3</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ4</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ5</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ6</Code>
</QuestionType>
<Response>4</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ7</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ8</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ9</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ10</Code>
</QuestionType>
<Response>0</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ11</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ12</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ13</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ14</Code>
</QuestionType>
<Response>4</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ15</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ16</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YSQ17</Code>
</QuestionType>
<Response>1</Response>
</Question>
</Questions>
<EnteredBy>
<Description>Patient</Description>
</EnteredBy>
<EnteredAt>
<Description>Home</Description>
</EnteredAt>
<TypeOfTreatment>Haemodialysis</TypeOfTreatment>
<HDLocation>In Centre</HDLocation>
<Template>IGNORE THIS</Template>
</Survey>
<Survey>
<SurveyTime>2018-04-16T00:00:00</SurveyTime>
<SurveyType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>PAM</Code>
</SurveyType>
<Questions>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ1</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ2</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ3</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ4</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ5</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ6</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ7</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ8</Code>
</QuestionType>
<Response>4</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ9</Code>
</QuestionType>
<Response>4</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ10</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ11</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ12</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>MYHQ13</Code>
</QuestionType>
<Response>1</Response>
</Question>
</Questions>
<Scores>
<Score>
<ScoreType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>PAM13_SCORE</Code>
</ScoreType>
<Value>45.3</Value>
</Score>
</Scores>
<Levels>
<Level>
<LevelType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>PAM13_LEVEL</Code>
</LevelType>
<Value>1</Value>
</Level>
</Levels>
<EnteredBy>
<Description>Patient</Description>
</EnteredBy>
<EnteredAt>
<Description>Home</Description>
</EnteredAt>
<TypeOfTreatment>Haemodialysis</TypeOfTreatment>
<HDLocation>In Centre</HDLocation>
<Template>YH2018 P1 1</Template>
</Survey>
<Survey>
<SurveyTime>2018-04-16T00:00:00</SurveyTime>
<SurveyType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>EQ5D</Code>
</SurveyType>
<Questions>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YOHQ1</Code>
</QuestionType>
<Response>4</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YOHQ2</Code>
</QuestionType>
<Response>3</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YOHQ3</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YOHQ4</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YOHQ5</Code>
</QuestionType>
<Response>2</Response>
</Question>
</Questions>
<TypeOfTreatment>Haemodialysis</TypeOfTreatment>
<HDLocation>In Centre</HDLocation>
<Template>YH2018 P1 1</Template>
</Survey>
<Survey>
<SurveyTime>2018-04-16T00:00:00</SurveyTime>
<SurveyType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YHS</Code>
</SurveyType>
<Questions>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YHS1</Code>
</QuestionType>
<Response>Quite a bit</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YHS2</Code>
</QuestionType>
<Response>Own</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YHS3</Code>
</QuestionType>
<Response>Renal Unit</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>YHS4</Code>
</QuestionType>
<Response>Yes</Response>
</Question>
</Questions>
<EnteredBy>
<Description>Patient</Description>
</EnteredBy>
<EnteredAt>
<Description>Home</Description>
</EnteredAt>
<TypeOfTreatment>Haemodialysis</TypeOfTreatment>
<HDLocation>In Centre</HDLocation>
<Template>IGNORE THIS</Template>
</Survey>
<Survey>
<SurveyTime>2018-04-16T00:00:00</SurveyTime>
<SurveyType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHAREDHD</Code>
</SurveyType>
<Questions>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ1</Code>
</QuestionType>
<Response>0</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ2</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ3</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ4</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ5</Code>
</QuestionType>
<Response>0</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ6</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ7</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ8</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ9</Code>
</QuestionType>
<Response>0</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ10</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ11</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ12</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ13</Code>
</QuestionType>
<Response>0</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ14</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ15</Code>
</QuestionType>
<Response>2</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ16</Code>
</QuestionType>
<Response>1</Response>
</Question>
<Question>
<QuestionType>
<CodingStandard>YOUR_HEALTH</CodingStandard>
<Code>SHQ17</Code>
</QuestionType>
<Response>Monday|Wednesday|Friday</Response>
</Question>
</Questions>
<EnteredBy>
<Description>Patient</Description>
</EnteredBy>
<EnteredAt>
<Description>Home</Description>
</EnteredAt>
<TypeOfTreatment>Haemodialysis</TypeOfTreatment>
<HDLocation>In Centre</HDLocation>
<Template>IGNORE THIS</Template>
</Survey>
</Surveys>
</ns1:PatientRecord>