Previous Topic

Next Topic

Book Contents

IRV_USERS_SITES

This view contains user-site associations.

Columns in the IRV_USERS_SITES view

IRV_USERS_SITES
Column Name (Key indicator)

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

Send Feedback