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

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

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
11 26-Nov-2021 10:22 3 KB JAiken to previous
10 26-Nov-2021 10:22 2 KB JEscott to previous | to last
9 26-Nov-2021 10:22 1 KB JEscott to previous | to last
8 26-Nov-2021 10:22 1 KB JEscott to previous | to last
7 26-Nov-2021 10:22 1 KB JMyers to previous | to last
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 904 bytes JMyers to previous | to last
2 26-Nov-2021 10:22 902 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 905 bytes JMyers to last

Page References

Incoming links Outgoing links
VMCL
VMCL

Version management

Difference between version and

At line 5 changed 19 lines
You may access this feature through the Screens/Forms menu:
Application Administration > Audit/Control Information > View Data Change Logs
Action
This field identifies the change that was made to the database.
Date
The date of the change is recorded in this field.
User
The user who changed the database is listed in this field.
Function Name
This field identifies the function the change was made to.
Logged in As This field....
Context 1 / Context 2 This field
Column / Column Name
These field identifies the column where the change was made.
Time
The time of the change is identified in this field.
Before Value / After Value
These field show the value in the column before and after the change was made.
The definition data for the View Data Change Log screen is stored in the [P2K_AM_TABLE_DETAILS], [P2K_AM_DATABASE_CHANGE_LOGS] and [P2K_AM_CHANGE_LOG_DETAILS] table.
From the Find select the Table to view the changes for.
\\Use the Calendar to select the day you to view the changes on.
\\
; Update Subject Ref :Pressing this button will run a routine that will populate the Subject Ref ID and Subject Ref Code for change logs on EID, EEM, ECT, and EAS if they are blank.
;[Date|CHANGE_DATE]:The date of the change is recorded in this field.
;[Logged in As|DRV_CHANGE_ACCESSOR]:This field will display the [IMUS] user name associated to the employee if they are logged into the Professional application while making changes. If they are logged into Self Service while making the change, the user’s [Person Code|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 also display here.
;[Action|CHANGE_ACTION]:This field identifies the type of action that was performed by the user to change the data i.e delete, create.
;[Function Name|FUNCTION_NAME]:This field identifies the function the change was made to.
;[Context 1|CONTEXT_1]: 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. This field will show the person code, candidate code or recruiter code of the user logged in making the change.
;[Context 2|CONTEXT_2]: Context 2 will hold (in XML format) all columns and values except those with domains of VARCHAR2000 & VARCHAR4000
;: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.
\\
;[Column Name|COLUMN_NAME]:These field identifies the column the change was made to.
;[User|USER_FIELD_NAME]:The user who made the change is listed in this field.
;[Time|CREATE_DATE]:The date and time of the change is identified in this field.
;[Before Value|DRV_BEFORE_VALUE_FORMATTED] / [After Value|DRV_AFTER_VALUE_FORMATTED]:These fields show the value in the column before and after the change was made.
----
![Notes|Edit:Internal.VMCL]
[{InsertPage page='Internal.VMCL' default='Click to create a new notes page'}]
This page (revision-11) was last changed on 26-Nov-2021 10:22 by JAikenTop