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 3 changed one line
Detailed change auditing was created to fulfill the need to identify “who” has changed “what” data, “when” and “how”. The rules of what data to log are configurable by table and column. The scope of detailed change auditing embraces all changes made by P2K users, eP users, SS users, Candidates and external users (e.g. SQL*Plus).
Detailed change auditing was created to fulfill the need to identify “who” has changed “what” data, “when” and “how”. The rules of what data to log are configurable by table and column. The scope of detailed change auditing embraces all changes made by Professional users, Self Service users, Candidates and external users (e.g. SQL*Plus).
At line 44 changed one line
** Context information required for all parent key information will be stored in XML format \\e.g. Distribution 1 \\of Assignment Detail effective 01 Jan 2006 \\ of Assignment 01 \\ of Employment with High Line \\ for Person # 000001
** Context information required for all parent key information will be stored in XML format \\e.g. Distribution 1 \\of Assignment Detail effective 01 Jan 2006 \\ of Assignment 01 \\ of Employment with the organization \\ for Person # 000001
At line 65 added one line
*Set the system preference [ENABLE_AUDITING(System_Preference)] to "Y" in IMST, and __restart the application instance__
At line 67 added one line
* Changes made outside the application are only captured if you have created the data base logging triggers. To do this, execute the script AM_XMLT.sql, as the P2K user, in SQL*Plus.
At line 81 changed one line
*It is possible to view the historical changes associated with each record within a screen. This can be done via the “[Show Change History|MMTCL]’ dialog. This dialog is displayed by pressing the icon found in the header of all forms or by pressing F10.
*It is possible to view the historical changes associated with each record within a screen. This can be done via the “[Show Change History|MMTCL]’ dialog. This dialog is displayed by pressing the [CHANGE_HISTORY.JPG] icon found in the header of all forms or by pressing F10.
At line 86 changed 3 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.
!Show Audit Details Dialog
*The [Show Audit Details|MMCRA] dialog displays the current information for each record on the table that is currently in focus.
*The dialog can be called up by pressing F12 or by pressing the [AUDIT_DETAILS.JPG] icon
At line 90 changed 2 lines
*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 can be used to determine the row id of the parent table as well as the dependent table.
*The user can determine when the last change was made to the table and by whom by reviewing the [Change Date|CHANGE_DATE] and [Change User|CHANGE_USER] columns.
At line 98 removed 2 lines
[{If var='loginstatus' contains 'authenticated'
At line 101 changed 4 lines
![Discussion|Edit:Internal.DETAILED CHANGE AUDITING]
[{InsertPage page='Internal.DETAILED CHANGE AUDITING' default='Click to create a new discussion page'}]
}]
![Notes|Edit:Internal.DETAILED CHANGE AUDITING]
[{InsertPage page='Internal.DETAILED CHANGE AUDITING' default='Click to create a new notes page'}]