Cardholder group members schema - Card Synchronization 3.0

Card Synchronization Plugin Guide 3.0

Card Synchronization 3.0

If you have cardholder groups to import into Security Center, the database view or file for cardholder group members must define which cardholders or cardholder groups are part of the cardholder groups.

Column Data type Description
Mandatory columns
GroupId String The unique ID of a cardholder group.
GroupMemberId String The unique ID of a cardholder or cardholder group.
GroupMemberType Integer The value that indicates the entity type:
  • 1 = Cardholder
  • 2 = Cardholder group
The following image is an example of a view for cardholder group members in a Microsoft SQL Server database.