IRV_USER_ACTIVESTATE_CHANGES

This view contains a history of each time a user's Active state has changed.

Column Name (Key indicator)	Column Description
USERID (PK)	Numeric identifier for the user.
USERREV (PK)	Revision number for the user.
FIRSTREV	First user revision: 0 - No 1 - Yes
CURRENTREV	Most recent user revision: 0 - No 1 - Yes
USERACTIVESTATE	New active state: 0 - inactive 1 - active
ENTEREDBY	Numeric identifier of the user who made the state change.
ENTEREDDATE	Time of the state change.
ENTEREDREASON	Action that caused the state change.
CREATEDBYUSERID	User ID of the user whose action resulted in the given view row being created.
CREATEDBYDATETIME	Date and time when the view row was created.
MODIFIEDBYUSERID	User ID of the user whose action resulted in the most recent change to data in the given view row.
MODIFIEDDATETIME	Date and time when the data in the view row was most recently updated.