|
|
|
|
Audit trail for manual transaction edits
To ensure that synchronization transaction changes are nevertheless recorded and available for audit, the following occurs when a user edits a transaction:
- An audit transaction is created and processed immediately the transaction edit. This XML contains the following information:
- Transaction IDs.
- User who edited the transaction.
- CIS application server computer and client computer where the edit occurred.
- Time and date of the change.
- Reason for the edit as entered on the Transaction Edit Screen.
- Body of the original transaction text.
- Body of the updated transaction text.
A sample of audit transaction XML follows, showing old and new transaction text within the <OLDDATA> and <NEWDATA> tags:
<?xml version="1.0" encoding="utf-8" ?>
<TRANSACTION GUID="{1FFF25A1-3A49-4ED8-8262-965C3DCB3B12}" REVISION="75725136419.000" USERGUIDREF="System User" TIME="5/27/2003 11:45:36 AM" SOURCEMACHINE="SRV34" INFORMVERSION="4.001" xmlns="PhaseForward-Sy_u99 ?XML-Inform4">
<MESSAGEEDIT GUID="{13333333-3A49-4ED8-8262-965C3DCB3B12}" USER="JDOE" USERIP="MEF.NORTH.PF.COM" REASON="fix external mapset refname">
<!-- OLDDATA_contains original transaction or message data -->
<OLDDATA>
_ <TRANSACTION GUID="{822C85AB-B71C-48AE-BADF-DD81BC68CC94}" REVISION="82308121856091.000" USERGUIDREF="System User" TIME="8/11/2003 8:22:01 PM" SOURCEMACHINE="{F3DD9640-32A1-4F86-AAA2-19E3E6564473}" INFORMVERSION="4.0024359">
_ <EXTERNALMAPSET REFNAME="M1" xmlns="PhaseForward-MedML-TDE" ACTIVE="true" AUTOGEN="true" TYPE="CLINFORM" GUID="{98A7BC6E-23FD-4391-B203-5EB915C87D71}" REVISION="82308121856091.000" />
_ </TRANSACTION>
</OLDDATA><!-- NEWDATA_contains modified transaction or message data -->
<NEWDATA>
_ <TRANSACTION GUID="{822C85AB-B71C-48AE-BADF-DD81BC68CC94}" REVISION="82308121856091.000" USERGUIDREF="System User" TIME="8/11/2003 8:22:01 PM" SOURCEMACHINE="{F3DD9640-32A1-4F86-AAA2-19E3E6564473}" INFORMVERSION="4.0024359">
_ <EXTERNALMAPSET REFNAME="MAPPINGS2" xmlns="PhaseForward-MedML-TDE" ACTIVE="true" AUTOGEN="true" TYPE="CLINFORM" GUID="{98A7BC6E-23FD-4391-B203-5EB915C87D71}" REVISION="82308121856091.000" />
… </TRANSACTION>
</NEWDATA></MESSAGEEDIT>
</TRANSACTION>
- If the InForm software encounters an audit transaction message, it stores audit information in the trial-specific INF_MSGEDIT_HISTORY table.
- The INF_MSGEDIT_HISTORY table has the following format:
INF_MSGEDIT_HISTORY
TRANSACTIONID
VARCHAR2(36)
MESSAGEID
EDITEDTRANSACTIONID
EDITORMACHINE
EDITUSER
EDITUSERHOST
EDITDATETIME
REASON
TRANSACTIONCONTENTVARCHAR2(36)
VARCHAR2(36)
VARCHAR2(255)
VARCHAR2(255)
VARCHAR2(255)
DATE
VARCHAR2(2000)
LONG VARCHAR
