ComplianceUser Table

ComplianceUser stores information about end-users in the enterprise, including contact details, login details and inventory source details (if applicable). End-users in ComplianceUser will not be able to log in to FlexNet Manager Suite unless they have a corresponding record in the ComplianceOperator table.

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 ComplianceUser table

Database Column

Details

ComplianceUserID

Type: integer. Key. Generated ID

A unique identifier for the end-user.

UserName

Type: text (max 512 characters). Nullable

The end-user’s full name. When creating a new end-user manually, defaults to a concatenation of title, first name, middle name, last name and suffix.

SAMAccountName

Type: text (max 64 characters). Key. Nullable

The login name (SAM account name) of the end-user.

ComplianceDomainID

Type: integer. Key. Nullable

Domain that the end-user belongs to. Foreign key to the ComplianceDomain table.

LocationID

Type: text (max 128 characters). Key. Nullable

Any enterprise location associated with this end-user. Foreign key to the GroupEx table.

BusinessUnitID

Type: text (max 128 characters). Key. Nullable

Any corporate unit in the enterprise associated with this end-user. Foreign key to the GroupEx table.

CostCenterID

Type: text (max 128 characters). Key. Nullable

Any cost center in the enterprise associated with this end-user. Foreign key to the GroupEx table.

CategoryID

Type: text (max 128 characters). Key. Nullable

No longer in use, but retained for legacy systems. Any enterprise category associated with this end-user. Foreign key to the GroupEx table.

EmployeeNumber

Type: text (max 128 characters). Key. Nullable

The employee number of the end-user (as defined in an organization’s own HR system).

UserTitleID

Type: integer. Nullable

The title of the end-user. Foreign key to the UserTitle table.

FirstName

Type: text (max 128 characters). Nullable

The first name of the end-user.

MiddleName

Type: text (max 128 characters). Nullable

The middle name(s) of the end-user.

LastName

Type: text (max 128 characters). Nullable

The last name (surname) of the end-user.

UserSuffixID

Type: integer. Nullable

The suffix to the name of the end-user. Foreign key to the UserSuffix table.

JobTitle

Type: text (max 128 characters). Nullable

The job title of the end-user.

BusinessPhoneNumber

Type: text (max 30 characters). Nullable

The work phone number of the end-user.

MobilePhoneNumber

Type: text (max 30 characters). Nullable

The mobile phone number of the end-user.

FaxPhoneNumber

Type: text (max 30 characters). Nullable

The fax number of the end-user.

Address_Street

Type: text (max 200 characters). Nullable

The street address of the end-user.

Address_City

Type: text (max 200 characters). Nullable

The city or suburb name of the end-user.

Address_State

Type: text (max 200 characters). Nullable

The state or province of the end-user.

Address_ZIP

Type: text (max 20 characters). Nullable

The ZIP or postal code of the end-user.

Address_Country

Type: text (max 100 characters). Nullable

The country of the end-user.

Email

Type: text (max 200 characters). Key. Nullable

The email address of the end-user.

AlternateEmail

Type: text (max 200 characters). Nullable

The alternate email address of the end-user.

Messenger

Type: text (max 200 characters). Nullable

The instant messenger address of the end-user.

ManagerID

Type: integer. Key. Nullable

The manager of the end-user. Foreign key to another end-user in the ComplianceUser table.

CurrencyID

Type: integer. Nullable

No longer in use - default currency is now stored in the OperatorTenantSetting table.

UserStatusID

Type: integer. Key

The end-user’s status. Foreign key to the ComplianceUserStatus table.

EmploymentStatusID

Type: integer. Nullable

The end-user’s employment status. Foreign key to the EmploymentStatus table.

IsIncluded

Type: boolean

If False, the end-user’s login name is in the list of excluded accounts, and this end-user will not consume licenses or be recorded as the last-logged-on or calculated end-user of a computer. This end-user will also not appear in many lists of end-users.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the record was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The operator who last updated the record.

UpdatedDate

Type: datetime. Nullable

The date the record was last updated.

ComplianceUser InventorySourceTypeID

Type: integer

Whether this end-user has ever been reported in inventory, or has been manually created and maintained. Foreign key to the ComplianceUserInventorySourceType table.

InventoryAgent

Type: text (max 64 characters). Nullable

If this end-user is reported in inventory, the name of the person or tool that performed the last inventory.

GeneratedFromEmail

Type: boolean

If True, the ComplianceUser record was generated using the email address provided by a source connection.