CONTEXT_1 is a field that will hold (in XML format) the Parent Table Context information; this is based on the Unique Keys of the changed record and its parents. This field will show the person code, candidate code or recruiter code of the user logged in making the change.

When a change takes place, but before the values are committed to the database, a Change Log record is created without the context columns populated. When the changes are committed to the database, the context columns are added to the new Change Log record, and the Change Log Details records are created for every changed column and added to the database.

If logging is turned on for a table and turned off for a changed column, no Change Log Details record will be created.

If there is an exception between the time the Change Log is created and before the Change Log Details and context information are created, then Context 1 will hold a message indicating that auditing was not complete.

---

Notes #

Click to create a new notes page