VIEW DATA CHANGE LOG#
The View Data Change Log (VMCL) screen is used to view the information that has been generated by the DB change log triggers.
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.
- Date
- The date of the change is recorded in this field.
- Logged in As
- This field....
- Action
- This field identifies the change that was made to the database.
- Function Name
- This field identifies the function the change was made to.
- Column Name
- These field identifies the column where the change was made.
- User
- The user who changed the database is listed in this field.
- 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.