LicenseUser Table
The LicenseUser
table lists account names (for end-users and other resources) that have been extracted
from other products (such as Oracle databases). These external accounts cannot be reconciled
with the end-users listed in the ComplianceUser
table. Nevertheless, these accounts can be very important
for licensing costs.
TenantID
has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.
Database Column |
Details |
---|---|
LicenseUserID
|
Type: integer. Key. Generated ID A unique identifier for an external end-user. |
LicenseUserLogin
|
Type: text (max 400 characters). Key The user login extracted from the original listing (for example, from an Oracle database). |
Description
|
Type: text (max 400 characters) The description is usually a group name. |
EmployeeNumber
|
Type: text (max 256 characters). Nullable The employee number of the external end-user. |
FirstName
|
Type: text (max 256 characters). Nullable The first name of the end-user extracted from the original listing. |
LastName
|
Type: text (max 256 characters). Nullable The last name of the end-user extracted from the original listing. |
Email
|
Type: text (max 400 characters). Nullable The email of the end-user extracted from the original listing. |
SAPClientCode
|
Type: text (max 2 characters). Nullable The end-user’s SAP client code, where applicable. |
SAPInstallationNumber
|
Type: text (max 10 characters). Nullable The end-user’s SAP installation number, where applicable. |
CostCenter
|
Type: text (max 128 characters). Nullable The SAP cost center that the end-user belongs to |
LicenseUserTypeID
|
Type: integer The type of external end-user. Foreign key to the |