|
|
|
|
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. |
