The User Object

This item maps to the User object in the FlexNet Manager Suite compliance database. It supports the addition of custom properties through the Business Importer.

Properties

The User object exposes the following properties in the data model for the Business Importer and the Business Adapter Studio.

Table 1. Data model properties for User object (alphabetical listing)

Property

Details

Account Name

Type: nvarchar. Maximum: 64.

Maps to User.SAMAccountName in the compliance database.

Address - City

Type: nvarchar. Maximum: 200.

Maps to User.Address_City in the compliance database.

Address - Country

Type: nvarchar. Maximum: 100.

Maps to User.Address_Country in the compliance database.

Address - State

Type: nvarchar. Maximum: 200.

Maps to User.Address_State in the compliance database.

Address - Street

Type: nvarchar. Maximum: 200.

Maps to User.Address_Street in the compliance database.

Address - Zip

Type: nvarchar. Maximum: 20.

Maps to User.Address_ZIP in the compliance database.

AlternateEmail

Type: nvarchar. Maximum: 200.

Maps to User.AlternateEmail in the compliance database.

Category ID

Type: varchar. Maximum: 128.

Stores the categoryID as a foreign key to the category table in the compliance database.

Corporate Unit ID

Type: varchar. Maximum: 128.

Stores the businessunitID as a foreign key to the CorporateUnit table in the compliance database.

Cost Center ID

Type: varchar. Maximum: 128.

Stores the costcenterID as a foreign key to the costcenter table in the compliance database.

Domain ID

Type: int.

Stores the ComplianceDomainID as a foreign key to the ComplianceDomain table in the compliance database.

Email

Type: nvarchar. Maximum: 200.

Maps to User.Email in the compliance database.

Employee Number

Type: nvarchar. Maximum: 128.

Maps to User.EmployeeNumber in the compliance database.

Employment Status

Type: nvarchar. Maximum: 1000.

Values of Employment Status must match those stored in the EmploymentStatus table of the compliance database.

Fax Number

Type: nvarchar. Maximum: 30.

Maps to User.FaxPhoneNumber in the compliance database.

First Name

Type: nvarchar. Maximum: 128.

Maps to User.FirstName in the compliance database.

Inventory Source

Type: nvarchar. Maximum: 64.

Maps to User.InventoryAgent in the compliance database.

Job Title

Type: nvarchar. Maximum: 128.

Maps to User.JobTitle in the compliance database.

Last Name

Type: nvarchar. Maximum: 128.

Maps to User.LastName in the compliance database.

Location ID

Type: varchar. Maximum: 128.

Stores the locationID as a foreign key to the location table in the compliance database.

Manager ID

Type: int.

Stores the ManagerID as a foreign key to the user table in the compliance database.

Middle Name

Type: nvarchar. Maximum: 128.

Maps to User.MiddleName in the compliance database.

Mobile Number

Type: nvarchar. Maximum: 30.

Maps to User.MobilePhoneNumber in the compliance database.

Phone Number

Type: nvarchar. Maximum: 30.

Maps to User.BusinessPhoneNumber in the compliance database.

User Full Name

Type: nvarchar. Maximum: 512.

Maps to User.UserName in the compliance database.

User Status

Type: nvarchar. Maximum: 1000.

Values of User Status must match those stored in the ComplianceUserStatus table of the compliance database.

User Suffix

Type: nvarchar. Maximum: 1000.

Values of User Suffix must match those stored in the UserSuffix table of the compliance database.

User Title

Type: nvarchar. Maximum: 1000.

Values of User Title must match those stored in the UserTitle table of the compliance database.

Data model version 13.2

2021 R1