Data formats
Terms used on this page (7)
- HL7 - Health Level Seven - the standard family for exchanging healthcare messages
- FHIR - Fast Healthcare Interoperability Resources - a modern web API standard for health data
- ORM - an HL7 v2 order message
- OML - an HL7 v2 laboratory order message
- ORU - an HL7 v2 observation result message
- CSV - comma-separated values - a text file with one record per row
- XLSX - the Excel workbook file format
See the Glossary for every term.
A connection is a transport (how data arrives or leaves - MLLP, SFTP, a database...) carrying a format (what the data is - HL7 v2, CSV, JSON...). The two are independent, so the same transport can carry different formats.
| Code | Format | What it is |
|---|---|---|
HL7V2 | HL7 v2 | ORM / OML orders, ORU results - pipe-delimited segments |
FHIR_R4 | FHIR R4 | ServiceRequest / DiagnosticReport bundles, JSON or XML |
JSON | JSON | Any JSON document, mapped field by field |
XML | XML | Any XML document, mapped by path |
CSV | CSV | One order or result per row, columns from the header line |
XLSX | Excel (XLSX) | A worksheet, one order or result per row |
FIXED_WIDTH | Fixed-width text | Positional flat files from older systems |
PDF | Result reports going out - not parsed on the way in |
Which connector carries which format
| Connector | HL7 v2 | FHIR R4 | JSON | XML | CSV | Excel (XLSX) | Fixed-width text | |
|---|---|---|---|---|---|---|---|---|
| MLLP (HL7 over TCP) | ✅ | |||||||
| Apache Kafka | ✅ | ✅ | ✅ | ✅ | ✅ | |||
| RabbitMQ | ✅ | ✅ | ✅ | ✅ | ✅ | |||
| ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
| HTTP / REST API | ✅ | ✅ | ✅ | ✅ | ✅ | |||
| Inbound webhook | ✅ | ✅ | ✅ | ✅ | ✅ | |||
| FHIR server | ✅ | |||||||
| SOAP web service | ✅ | ✅ | ||||||
| SFTP | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| FTP / FTPS | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Shared folder | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Database | ✅ | |||||||
| Amazon S3 | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Azure Blob Storage | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
note
PDF is for result reports going out - it is not parsed on the way in.
A ticked format is what you can configure, not what carries orders today
Which connector and format combinations carry real orders right now is on the Stage 1 and Stage 2 page.