Custom fields schema - Card Synchronization 3.0

Card Synchronization Plugin Guide 3.0

series
Card Synchronization 3.0
revised_modified
2018-08-29

For custom fields to be imported into Security Center, the database view for custom fields must follow the Card Synchronization schema.

NOTE: For each custom field you add, you must create a corresponding custom field in Security Center.
Column Data type Description
Mandatory columns
EntityUniqueId String The unique ID of a cardholder, cardholder group, or credential.
EntityType String The value that indicates the entity type:
  • 1 = Cardholder
  • 2 = Cardholder group
  • 4 = Credential
CustomFieldName String The name of the custom field.
CustomFieldValue String The value of the custom field.
The following image is an example of a custom fields view in a Microsoft SQL Server database.