Simplified Data Set (Tracing Data)
Received File
This file is received from the SIMPLIFIED project via SFTP to our Internet SFTP Server. It contains 1 row per patient and every enrolled patient will be submitted each time. The numbers of patients involved in the project are small enough that this will not pose an issue. Note that there is no header row.
Field | Notes |
---|---|
Simplified ID | |
NHS Number | |
Surname | |
Forename | |
Sex | M/F |
DOB | YYYY-MM-DD |
Postcode |
Output File
The SIMPLIFIED Data is converted into NHS Batch Tracing format and submitted. The response is retrieved 40 minutes later. Tracing Status and NHS Number, if found are appended to the file.
The code to generate this can be found on rr-systems-live in /home/rrbatch/simplified-tracing
It is executed by two cronjobs (-t option to trace and -m option to merge traced file back into original):
55 * * * * /home/rrbatch/simplified-tracing/venv/bin/python3.6 /home/rrbatch/simplified-tracing/tracer.py -t --log /var/tracing/log.txt
35 * * * * /home/rrbatch/simplified-tracing/venv/bin/python3.6 /home/rrbatch/simplified-tracing/tracer.py -m --log /var/tracing/log.txt
This file is then placed on our Internet SFTP Server for them to collect.
Field | Notes |
---|---|
Simplified ID | |
NHS Number | |
Surname | |
Forename | |
Sex | |
DOB | |
Postcode | |
Tracing NHS Number | |
Tracing Status Code | 20 - Single Match (Alphanumeric Trace) 21 - No Match (Alphanumeric Trace) 22 - Multiple Match (Alphanumeric Trace) 30 - NHS Number Cross Checked Successfully 31 - NHS Number Failed Cross Check, No Alphanumeric Trace 32 - NHS Number Failed Cross Check, Alphanumeric Trace returns multiple matches 33 - NHS Number Failed Cross Check, Alphanumeric Trace returned single match 40 - NHS Number Failed Cross Check. The NHS Number has been merged with another record. |