IRV_USERS_SITES
This view contains user-site associations.
Columns in the IRV_USERS_SITES view
IRV_USERS_SITES |
IRV_USERS_SITES |
---|---|
USERID (PK) |
Numeric identifier for the user. |
SITEID (PK) |
Numeric identifier for the site with which the user is associated. |
RIGHTSGROUPID |
Numeric identifier of the rights group to which the user is currently assigned. |
USERNAME |
Account name for the user. |
RIGHTSGROUP |
Name of the rights group to which the user is currently assigned. |
SITEMNEMONIC |
Abbreviated name for the site with which the user is associated. |
SITENAME |
Name of the site with which the user is associated. |
SITECOUNTRY |
Country in which the site address with which the user is associated is located. |
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. |