How to Delete HL7 Old Header Data

benji

Hi, how do I delete old HL7 data? I see some of the HL7 tables are taking up a lot of space.

kairo_Decisions

You can definitely delete from the following HL7 tables as it's really just historical data on messages you've received and sent:

hl7_received_msg_header

hl7_received_msg_data

hl7_sent_msg_data

You can truncate these tables or do regular delete queries.

In order to prevent these from piling up again, it may be helpful to set up a job to automate archiving/deleting the data.