HL7 message log fields

  • Release version: Australia
  • Updated May 11, 2026
  • 1 minute to read

    • 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 sn_hl7_v2.admin role, consistent with HIPAA minimum-necessary requirements.
    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.