Transplant Status - current PV-UKT process

Patientview Export

1. Patientview runs an extract job against the PV database each night at 22.00 
2. This produces a csv file in /opt/ukt/export/ukt_rpv_export.txt 
3. This file contains a list of the NHSNo, Lastname, Firstname, DoB, Postcode  for each patient to be queried.
4. A cron job running under the account pv2 then sftp the file to the internet sftp server renalpatientview.org to /data/pv/uploads/renal/ukt/incoming  at 22:45

UKTBT Return file

1. UKTBT downloads the file daily using its ukt account

2. NHSBT return a file uktstatus.gpg  encrypted using gpg with a underlying format of:
   NHSNo | A/T/O/R/S | N/T/U | 
   Each column contains a single letter. PV translate the first column from the letter to the following text on the patient record

   Letter	Meaning in PV
   R,N,O	Not on List
   U	No Status uploaded
   A	Kidney - Active
   S	Kidney - suspended
   T	Kidney - Transplanted

3. This gpg file is decrypted and a .txt extension added and stored in /data/pv/feeds/pv2/outgoing/  on the sftpp server.
4. This is then picked up by a cron job daily at 19:30 by the PV webserver using the pv2 account and stored in /opt/ukt/import/uktstatus.gpg.txt 
5. PV then imports this and updates the patient transplant status.