Users (MEMBERHISTORY Table)

The MEMBER table is used to store user information. When changes are made to the MEMBER table, the old information is stored in the MEMBERHISTORY table.

The triggers capture information when:

  • Data is inserted into the MEMBER table.
  • Data from the MEMBER table is modified (an entry is added to the table).
  • Data is deleted from the MEMBER table. In this case, an inactive entry is added to history table. However, the timestamp is the same as the system date and modmemberID is the same as the old member record.
  • When an user is deleted, it is done by updating the Active column to N. This invokes the update trigger. However, no entries are made into the ROLEASSIGHISTORY and ResourceACLHistory tables.