GroupEx Table

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