Sanction List History

Every change (add/delete/modify) to the Sanction List, Alt. Name or Exceptions will create a record in the sanction history table. This not only service as audit purpose, it also can be used to restored the data to any point of past time.

This function is used to search sanction history. Click the "Sanction History" in the left navigation menu under List management, a new "Sanction History" Tab folder will created in the right panel. There are 2 sub-Tab folders, Search Sanction History and Search result Sanction History.

Screenshot

a) Search Sanction History

Search Criteria

HistoryId Unique record identifier.
entNum Link to SDN unique record identifier.
GG_ALT_ID Link to Alt. Name or Exception record identifier; If the change is on SDN table, this field will be empty
Filed Name Name of Field.
New Value The new value of this field
ChangeDate Date and time that changes occurred.
Changer User who made the change.
Table Name Sanction, Alter Name or GoodGuy.
AND and OR Select AND radio box if you want those criteria add together.
Select OR radio box if you want to get the result of either criteria meet

Functional buttons

  1. Find:
    click Find button to search.
  2. Clear:
    click Clear button to clear all the criteria.
  3. Complex Search:
    switch to Complex search mode.

b) Search Result Sanction History

Screenshot

The top part is the table, shows the list sanction list history that meet the search criteria. The bottom part is the details of the selected entry. There is no create/update/delete function in Sanction History