IRV_USERS_SITES

This view contains user-site associations.

Column Name (Key indicator)	Column Description
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.