Tables

• Period (field STRDAT)

If this date is entered, only those data whose last modification or creation date is later than or equal to it are viewed in the inquiry.

Except if there is a memo that specifies its value, the default value for this date is defined by the DATEDEBDFTuserparameter.

• field ENDDAT

If this date is entered, only those data whose last modification or creation date is earlier than or equal to it are viewed in the inquiry.

Except if there is a memo that specifies its value, the default value for this date is defined by the DATEFINDFTuserparameter.

• Table (field TABLE)

It is used to define a filter on the audited table. If this field is entered, only those lines relating to the table in question are viewed.

• User (field USER)

It is used to define a filter on the user code. If this field is assigned, only those modifications made by the corresponding user appear in the inquiry.

• Login (field LOGIN)

It is used to define a filter on the user login code. If this field is entered, only those modifications made by the users connected under the corresponding login code appear in the inquiry.

To view only those modifications made directly to the database without going through the software, the External login code needs only to be selected (by right click).

• Event (field EVENEMENT)

It is used to filter the lines to be presented on the event at the origin of the audit. In the absence of any values, all the lines are presented, but if a filtering is required, only 3 values are possible:

• INSERT (to view all the creations)
• UPDATE (to view all the modifications)
• DELETE (to view all the deletions)

Only the first character (I,U,D) needs to be entered for the entry to be completed in this field.

• Audit bl (field AUDBI)

• Sequence no. (field SEQ)

Unique chronological number assigned upon releasing of the audited event. A single number is assigned by record at the origin of the audit, and if the audit has been activated on some fields, the corresponding lines will share this chronological number.

• Table (field TBL)

It corresponds to the table in which the audited event took place.

• Date (field DAT)

It defines the system date on the data server at the moment of execution of the audited event.

• Time (field HOU)

It defines the system time on the data server at the moment of execution of the audited event.

• Event (field EVT)

It defines the type of audited event. There are three possible choices:

• INSERT defines a line creation.
• DELETE defines a line deletion.
• UPDATE defines a line modification.

• Key (field ID1)

It defines the key value of the record at the origin of the audit, when the key is composed of a single field. When it is composed of several fields, only the value of the first field is stored here.

The key identifying the record is defined in the Audit tab of the tables management. By default, it is the first key.

• Secondary key (field ID2)

When the key of the record at the origin of the audit is composed of several fields, the value of the fields can be found here in the proper order from the second field, these fields being separated by the ~ character (tilde).

The key identifying the record is defined in the Audit tab of the tables management. By default, it is the first key.

• User (field ADOUSR)

It defines the user code (in the meaning of the software) that triggered the audited event.

If the event has been triggered outside of the software, this field is empty.

• Login (field SYSUSR)

It corresponds to the system login of the user at the origin of the audited event. If the event has been triggered outside of the software, the login that appears here is External.

• Client (field ADRCLI)

It defines the address (in the network meaning) of the user at the origin of the audited event. If this address cannot be determined, the field is entered with Unknown. This is namely the case for all the modifications performed outside of the software.

• Workflow status (field STA)

This status is used to find out if a Workflow has been requested on this audit. It can take the following values:

• None: The Workflow box is not checked in the audit parameterization for the corresponding table.
• To process: The Workflow box is checked, but no Workflow event of the Manual type based on the run thgrough of the audit table has processed a notification and updated this field.
• Processed: The Workflow box is checked, and a later notification processing took place.

• Status BI (field STABI)