MemberEx Table

The MemberEx table stores the membership lists for every enterprise group or role.

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

Database Column

Details

GroupID

Type: integer. Key

The GroupEx to which the member belongs.

TargetTypeID

Type: integer. Key

The TargetType. Possible values are:

  • 3 = Enterprise Group
  • 9 = Asset
  • 10 = Contract
  • 11 = Purchase Order
  • 12 = Software License
  • 13 = Software Title
  • 14 = Computer
  • 15 = User
  • 16 = Operator
  • 17 = SAP system landscapes
  • 18 = SAP systems
  • 19 = SAP rule sets
TargetID

Type: integer. Key

The Asset, Contract, etc. identifier, depending on TargetType.