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.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database 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.
Table 1. Database columns for LicenseUser table

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 LicenseUserType table.