USER_DIMENSION
The User dimension stores details from user accounts. Only user accounts with usernames are transformed into the reporting database. User accounts that do not include a username are not available for reporting.
|
Columns |
Type |
Length |
Description |
|
ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the device record as defined in FlexNet Operations. The ID is the primary key for the User dimension. |
|
USER_ID |
string |
255 |
A non-nullable, user ID specified in FlexNet Operations for this user (the identifier the user uses to log in). |
|
FIRSTNAME |
string |
150 |
First name of the user, as defined in FlexNet Operations. |
|
LASTNAME |
string |
150 |
Last name of the user, as defined in FlexNet Operations. |
|
|
string |
100 |
Email address of the user, as defined in FlexNet Operations. |
|
PHONE |
string |
50 |
Phone number of the user, as defined in FlexNet Operations |
|
STREET_ADDRESS |
string |
3000 |
Street part of the address specified for the user. |
|
CITY |
string |
150 |
City part of the address specified for the user. |
|
COUNTRY |
string |
75 |
Country part of the address specified for the user. |
|
STATUS |
string |
255 |
Shows whether the user is ACTIVE or INACTIVE. |
|
TENANT_ID |
string |
255 |
An Identifier representing tenant, to which this maintenance belongs. |
|
RENEWAL_SUBSCRIPTION |
bit |
|
Indicates whether the user should receive renewal reminders about expiring and expired entitlements. The value for RENEWAL_SUBSCRIPTION is 0 (false) or 1 (true). |
|
SHAREDLOGIN |
bit |
|
Indicates whether the user is a shared login or not The value for SHAREDLOGIN is 0 (false) or 1 (true). |
|
SYSTEMADMIN |
bit |
|
Indicates whether the user is a system admin or not The value for SYSTEMADMIN is 0 (false) or 1 (true). |
|
LASTUPDATED |
datetime |
|
The date and time the user was last updated. LASTUPDATED can be null. |
|
LASTAUTHENTICATED |
datetime |
|
The date and time the user was last authenticated. LASTAUTHENTICATED can be null. |
|
CREATEDATE |
datetime |
|
The date and time the user was created. CREATEDATE can be null. |
|
RENEWAL_SUBSCRIPTION |
NUMBER |
1 |
Stores the user information for the Expiring entitlements email check box value. |