IRV_USER_ACTIVESTATE_CHANGES
This view contains a history of each time a user's Active state has changed.
Columns in the IRV_USER_ACTIVESTATE_CHANGES view
IRV_USER_ACTIVESTATE_CHANGES |
IRV_USER_ACTIVESTATE_CHANGES |
---|---|
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. |