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
This is what I think the file contains. I am unable to find any documentation or version controlled code for the process.
| 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. |