The following import fields are required when using the 2017 dataset:
ImportIdentifier | |
S1HospitalNumber | |
S1NHSNumber | |
S1Surname | |
S1Forename | |
S1BirthDate | |
S1FirstArrivalDateTime | |
S1Diagnosis | Must be S - cannot be T or O (cannot import TIA or other cases) |
S4ArrivalDateTime | Must equal S1FirstArrivalDateTime |
When using the 2017 dataset, the file must contain 280 fields.
Minimum fields required for import where PIs not allowed
If Northern Ireland team OR PIs not allowed because 7.102 or 8.1.5 = ‘patient refused’, then the import does not do duplicate checks as above and the minimum fields required for import are:
- Import Identifier
- Arrival date/time