Database updates for electronic audit

Some objects and attributes can be updated for electronic audits without using administration mode.

An audit table is an object that the MAXTABLECFG.EAUDITTBNAME column references.

Example

If the Person table is audited and the audit table is named A_Person, two rows exist in the MAXTABLECFG table, as shown in the following example:

Table 1. Electronic Audit Tables
Table name Table name for electronic audit table
PERSON A_PERSON
A_PERSON (null)

For the base table, changes to the audit-related, object-level parameters in the following tables can be updated without using administration mode. For an audit table, if the object you add (that is, MAXOBJECTCFG.CHANGED = I) and its base table can be changed without using administration mode, then the audit table is also eligible.

The following table lists the object-level parameters that can be changed without using administration mode:

Table 2. Object-level parameters that are eligible for live updates
Description Table and object Additional rules to qualify for live update
Electronic Audit Filter MAXOBJECTCFG.EAUDITFILTER None
Electronic Audit Enabled MAXOBJECTCFG.EAUDITENABLED

No additional rules.

Field validation in the Database Configuration application ensures that when electronic auditing is enabled, there is a non-null value for EAUDITTBNAME.

Electronic Audit Table Name MAXTABLECFG.EAUDITTBNAME

If either of the following conditions is true, live updates for changes of EAUDITTBNAME are supported:

  • EAUDITTBNAME is non-null and the object that is referenced by EAUDITTBNAME is a new object (that is, MAXOBJECTCFG.CHANGED = I).
  • EAUDITTBNAME is being set to null (that is, EAUDITENABLED is being turned on).

The following table lists changes to the audit-related, attribute-level parameters on the base table that are eligible for live updates:

Table 3. Attribute-level parameters that are eligible for live update
Description Attribute Additional rules to qualify for live update
Electronic Audit Attribute Enabled MAXATTRIBUTECFG.EAUDITENABLED

No additional rules.

An attribute that is eligible for live update is turned on or off.