HL7 message log fields
Field reference for the HL7 Message Log table (sn_hl7_v2_message_log).
| Field | Type | Description |
|---|---|---|
| `number` | String | Auto-generated unique identifier for the message log record. Uses the HL7 prefix. |
| `raw_payload` | MultiLine String | The complete raw inbound HL7 v2.x message as received. Caution: This field may contain protected health information (PHI). Access is restricted by a column-level ACL to the |
| `status` | Choice | Processing status of the message. Values: Pending, Processing, Processed, Failed. |
| `message_type` | String \(20\) | HL7 message type extracted from MSH-9.1 \(for example, `ADT`\). |
| `message_event` | String \(20\) | HL7 trigger event extracted from MSH-9.2 \(for example, `A03`\). |
| `hl7_version` | String \(20\) | HL7 version extracted from MSH-12 \(for example, `2.5.1`\). |
| `sending_application` | String \(100\) | Sending application extracted from MSH-3. |
| `sending_facility` | String \(100\) | Sending facility extracted from MSH-4. |
| `message_control_id` | String \(100\) | Message control ID extracted from MSH-10. Used for correlation between the original message and its ACK response. |
| `message_datetime` | DateTime | Message timestamp extracted from MSH-7 and converted to ServiceNow format. |
| `ack_code` | Choice | The acknowledgment code returned to the integration engine. Values: AA \(Application Accept\), AE \(Application Error\), AR \(Application Rejection\). |
| `ack_response` | MultiLine String | The complete raw HL7 ACK response body returned to the integration engine. |
| `error_message` | String \(1000\) | Failure detail text populated when processing results in an AE or AR ACK code or a Failed status. |
| `additional_notes` | String \(4000\) | Non-MSH segment data captured during processing. |
| `parsed_data` | JSON | The structured result of parsing the message against the matched parser configuration. Its shape is determined by the `field_name` dotted paths on the configuration's active field maps. Values are raw HL7 strings; HL7 fields absent from the message are stored as `null`. |