This page (revision-27) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
27 26-Nov-2021 10:22 9 KB rforbes to previous DETAILED CHANGE AUDITING ==> AUDIT LOGGING
26 26-Nov-2021 10:22 9 KB rforbes to previous | to last
25 26-Nov-2021 10:22 9 KB jmyers to previous | to last ENABLE_AUDITING ==> ENABLE_AUDITING(System_Preference)
24 26-Nov-2021 10:22 9 KB rforbes to previous | to last
23 26-Nov-2021 10:22 9 KB rforbes to previous | to last
22 26-Nov-2021 10:22 9 KB rforbes to previous | to last DEaTAILED CHANGE AUDITINGx ==> DETAILED CHANGE AUDITING
21 26-Nov-2021 10:22 9 KB rforbes to previous | to last DeTAILED CHANGE AUDITINGx ==> DEaTAILED CHANGE AUDITINGx

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 69 added 12 lines
----
!!View Change Logs and Audit Details
!VMCL
*The VMCL screen is used to view the Data Change Logs per table. The header section of the form displays the date the change was made, which user made the change, what action was done and in what function.
*Context 1 will hold (in XML format) the Parent Context information; this is based on the Unique Keys of the changed record and its parents.
*Context 2 will hold (in XML format) all columns and values except those with domains of VARCHAR2000 & VARCHAR4000.
*The details section shows which columns were changed, when the change took place and what the before and after values are.
*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.
*The Logged in As will display the IMUS user name associated to the employee if logged into eP while making changes. If logged into Self Service while making the change the user’s Person Code will be displayed. Changes mapped to roles will display the role name. If a change is made in Self Service that is tied to a Personnel Action, the IMUS user name of the individual who processes the PA will display in the Logged In As field.
*Context 1 will show the person code, candidate code or recruiter code of the user logged in making the change.
At line 82 added 5 lines
!Show Change History Dialog
*It is possible to view the historical changes associated with each record within a screen. This can be done via the “Show Change History’ dialog. This dialog is displayed by pressing the icon found in the header of all forms or by pressing F10.
*The dialog will display the following information for each column within the record in focus: time the change was made, what action was done, in what function, who made the change and what the before and after values are.
*A derived field was added to the Change History dialog to display the System Accessor code for each change log detail. Therefore, if an eP user is logged in and has made a change the user name will be displayed as the one who made the change, if logged into Self Service while making the change the person code will be displayed, changes mapped to roles will display role name, recruiter will display the recruiter code and candidates will display candidate code.
*The second tab will display the change history for any user fields associated to the table.
At line 88 added 7 lines
!Show Audit Details
*The Show Audit Details dialog displays the current information for each record on the table that is currently in focus.
*The dialog can be called up by pressing the icon or by pressing F12.
*The user can navigate through the list of column names to determine the changed value for each column on the table in focus.
*The dialog can be used to determine the row id of the parent table as well as the dependant table.
*The user can determine when the last change was made to the table and by whom by reviewing the Change_Date and Change_User columns.
*The dialog also displays a preference value should one exist for a column within the table in focus.
At line 96 added 4 lines