The EMS export shows 22.4. The tag, the unit, the time stamp and the status flag that sat beside it in the database stayed behind.
What the export dropped is metadata. The MHRA's GXP data integrity guidance (2018) defines metadata as data that describe the attributes of other data and provide context and meaning. It adds that without the context provided by metadata, the data has no meaning.
For one value in an environmental monitoring system the list is short: the sensor tag, the engineering unit, the time stamp, the status flag, the user or system account that wrote it, and the audit trail entries attached to it.
Trouble starts when data moves. Once the status flag is gone, a value logged while the sensor was in fault looks like any other.
The guidance counts metadata as part of a backup, and says a true copy must retain the metadata and audit trail needed to keep the full meaning of the data. The 2011 text of EU GMP Annex 11 never uses the word, yet says much the same about migration: validation should include checks that data are not altered in value and/or meaning.
Try it on your own EMS. Restore last month's backup on a test machine, pull one alarm event, and see whether tag, unit, time, user and audit trail come back with the value.
Industries



