CSV Upload
The first requirement of PKB is a csv upload of basic demographics for all PV patients including emails if available. This is used to create the records and identify patients already on the system. This is then followed up with an HL7 upload of all historic data to sync with PV. After this we just send the regular PV updatesPatient Knows Best says:-
Mass creation of patient records by CSV upload . The CSV should include all available demographics and email addresses. CSV upload process has the additional benefits of:
- The CSV upload reporting of creation outcomes is valuable: https://manual.patientsknowbest.com/coordinator/records-mass. This can be used to determine which patients are already on PKB but part of another organisation.
- The CSV upload can trigger an invite to an existing record when an email is included. This is not currently possible via HL7.
This will then be followed by supplementary information to enrich the patient record via HL7 messages including.
- Demographics (ADT^A31).
- Verified NHS filtered.
- ZRX medication segments included where available.
- DG1 diagnosis segments included where available.
- Email address included in PID segment where available.
- Test Results (ORU^R01).
- LOINC codes should be included in OBX-3.1/OBX-3.3 where available. PKB has an existing set of LOINC mappings where there is likely beneficial overlap.
- Documents (MDM^T02)
- Appointments (SIU^S12)
This would then be followed by:
PKB should be sent all the data that is currently on RPV. This will mean that the upload of data to the patient records may be broken into two pieces of work:
- A one off upload of existing historical data to PKB to ensure that PKB records are equivalent to the current RPV records. This should be done prior to the patient invite or in parallel to the invite so that the records are present when the patient registers on PKB.
- An ongoing feed of new / updated data to the PKB records.
PV/RDA Feed to PKB
Two options/methods for this task:
...