User Guide

Database views and data relationships 15
EXT_USER_FIELDS
This view lists custom fields that can be used for each user. The EXT_USERS_FIELDS view
uses data listed in the following table:
Data is generated in this view whenever a user does any of the following:
■ Creates, updates, or deletes a group
■ Changes group membership attributes
EXT_USER_FIELDS sample entries
EXT_USER_GROUPS
This view lists data about groups and associated group members. The
EXT_USER_GROUPS view uses the data listed in the following table:
Data is generated in this view whenever a user does any of the following:
■ Creates, updates or deletes a group
■ Changes group membership
Column name Data type Description
LOGIN NVARCHAR Unique user identifier.
NAME NVARCHAR Field name such as telephone number.
VALUE NVARCHAR Field value such as 415.555.1212.
LOGIN NAME VALUE
[e-mail] {admins} 617-555-1212
[e-mail] {authors} 415-555-1212
[e-mail] {course-admins} 408-555-1212
Column name Data type Description
LOGIN NVARCHAR Name of user.
NAME NVARCHAR Name of group.