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.
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 |
---|---|
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 |
LocationID
|
Type: text (max 128 characters). Key. Nullable Any enterprise location associated with this end-user. Foreign key to the |
BusinessUnitID
|
Type: text (max 128 characters). Key. Nullable Any corporate unit in the enterprise associated with this end-user. Foreign key to the |
CostCenterID
|
Type: text (max 128 characters). Key. Nullable Any cost center in the enterprise associated with this end-user. Foreign key to the |
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 |
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 |
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 |
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 |
CurrencyID
|
Type: integer. Nullable No longer in use - default currency is now stored in the |
UserStatusID
|
Type: integer. Key The end-user’s status. Foreign key to the |
EmploymentStatusID
|
Type: integer. Nullable The end-user’s employment status. Foreign key to the |
IsIncluded
|
Type: boolean If |
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 |
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 |
FlexNet Manager Suite (On-Premises)
2020 R1