User Guide

14 Using Breeze Reporting Views
EXT_USERS
This view lists users and associated profile attributes. The EXT_USERS view uses data listed
in the following table:
Data is generated in this view whenever a user creates, updates or deletes a user.
EXT_USERS sample entries
Constraints
The EXT_USERS view excludes the following fields:
■ Password, which is not stored in plain text
■ Time zone and language, which are not available in human readable form. For example,
PST is 323.
■ Last login, which is too resource-intensive to calculate. Instead, you can retrieve this data
using a max(date_visited) query from the EXT_TRANSACTIONS view.
■ Active session, which is data from the EXT_TRANSACTION view. Instead, you can
retrieve this data by executing a STATUS='IN-PROGRESS' query.
Column name Data type Description
LOGIN NVARCHAR Unique user identifier.
NAME NVARCHAR Unique user name.
EMAIL NVARCHAR User’s unique email address.
MANAGER NVARCHAR The login of the user’s manager. Manager is always
set to NULL in version 5.1.
TYPE NVARCHAR User or guest. Type is always set to user in version 5.1.
LOGIN NAME EMAIL MANAGER TYPE
[e-mail] system admin [e-mail] (null) user
[e-mail] IT manager [e-mail] (null) user
NOTE
Deleted users do not appear in the EXT_USERS view. Deleted users continue to exist in
the EXT_TRANSACTION view.