DMMBRGRPPZN

This table contains customers that are explicitly included in a member group by the customer's personalization ID. This works in conjunction with the explicit inclusion and exclusion rules that are specified in the MBRGRPMBR table and the implicit inclusion rules that are specified in the MBRGRPCOND table. If both multiple criteria are specified, the following algorithm is used to evaluate if a member belongs to a member group: Explicit exclusion by member ID takes first precedence, then explicit inclusion by member ID, then inclusion by personalization ID, and then finally implicit inclusion.

Column Descriptions:

NameTypeDescription
MBRGRP_IDBIGINT NOT NULLForeign key to the MBRGRP for this member group.
PERSONALIZATIONIDVARCHAR (30) NOT NULLThe unique personalization identifier of a customer.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MBRGRP_ID+PERSONALIZATIONIDPrimary Key
I0001233PERSONALIZATIONIDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3592MBRGRP_IDMBRGRPMBRGRP_IDCascade