The Historical Tracking of Assignments page provides an inquiry into the historical details of any assignment/revocation actions done on a particular administration reference pages when the parameter IN_HIST_TRACK is set to true on Application Parameters (APPCTRL). Each action and details are stored and can be queried. Such logging is particularly useful for Security tables, for example, tracking assignment/revocation of Security Role to User can provide the following information:
When a Role was assigned?
How long did the User have a Role assigned?
When was the Role removed from the User?
Details logged include the Table Name on which the action occurred, Assignee, Assigned Object, date of the action and User ID of the user performing the action. For the Security Role Link table the Table Name is R_SC_USER_ROLE_LNK, Assignee is the User ID to whom the Security Role was assigned/revoked, Assigned Object is the Security Role and From Date is the date on which the Security Role is assigned and To Date is the date on which the Security Role is revoked and Admin / Revoke Admin ID is the User ID of the user performing the assignment or revocation of the Role. During assignment, a new Historical tracking entry is logged populating the fields tracking its assignment, and for revocation, the existing Historical Tracking entry that logged its assignment is updated with To Date, Revoke Admin ID, and Revoke Reason, if any.
By default, the following tables are designed to log assignment/revocation details into the Historical Tracking of Assignments:
Security Role Link
Workflow Role Link
MSS Security Role
If additional tables need to be tracked in a similar way then refer to the ”Historical/Tracking of Assignments” section in the CGI Advantage Developer Guide to understand the feasibility and the required steps to enable it.