GroupEx Table

FlexNet Manager Suite (Cloud)

The GroupEx table stores information about enterprise groups and roles.

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

Database Column

Details

GroupID

Type: integer. Key. Generated ID

A unique identifier for a group.

GroupTypeID

Type: integer. Key

Identifies the group type. Foreign key to the GroupType table.

BusinessView

Type: boolean. Key

Set this to True if the group is a business view (that is, is a group heading like Roles or Categories.

Path

Type: text (max 500 characters)

Complete path of the group.

NextChild

Type: integer

The ID number for the next child to be created under this group. Internal use only: do not edit.

GroupExID

Type: text (max 128 characters). Key

Unique string identifier for this extension record.

BusinessPhoneNumber

Type: text (max 30 characters). Nullable

The business phone number of the group.

FaxPhoneNumber

Type: text (max 30 characters). Nullable

The fax number of the group.

Address_Street

Type: text (max 200 characters). Nullable

The street address of the group.

Address_City

Type: text (max 200 characters). Nullable

The city of the group.

Address_State

Type: text (max 200 characters). Nullable

The state of the group.

Address_ZIP

Type: text (max 20 characters). Nullable

The ZIP or postal code of the group.

Address_Country

Type: text (max 100 characters). Nullable

The country of the group.

Email

Type: text (max 200 characters). Nullable

The email address of the group.

Comments

Type: text. Nullable

Comments about the group.

IsStockLocation

Type: boolean

For locations only. If this field is set to True, the location is considered to be a stock or storage location.

ContactID

Type: integer. Nullable

A contact person for this group. This field is no longer in use in FlexNet Manager Suite

ManagerID

Type: integer. Nullable

A manager for this group. This field is no longer in use in FlexNet Manager Suite

GroupCN

Type: text (max 256 characters). Nullable

The common name for the group.

NameResourceName

Type: text (max 256 characters). Nullable

The unique name of the localizable resource string representing an enterprise group name (GroupCN). Foreign key to the ComplianceResourceString table.

DescriptionResourceName

Type: text (max 256 characters). Nullable

The unique name of the localizable resource string representing an enterprise group description (Comments). Foreign key to the ComplianceResourceString table.

ParentGroupExID

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

Unique string identifier for the parent record.

TreeLevel

Type: integer. Nullable

The level of this group in the hierarchy.

TreePath

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

A generated path that can be used to sort groups in tree order.

SpecifiedRegion

Type: boolean

RegionID specified explicitly by the user through the web UI.

RegionID

Type: integer. Key. Nullable

RegionID for each location inherit from itself or parent.

IsShared

Type: boolean

FlexNet Manager Suite (Cloud)

Current