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 specified in the MBRGRPMBR table and the implicit inclusion rules 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:

Name	Type	Description
MBRGRP_ID	BIGINT NOT NULL	Foreign key to the MBRGRP for this member group.
PERSONALIZATIONID	VARCHAR (30) NOT NULL	The unique personalization identifier of a customer.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	MBRGRP_ID+PERSONALIZATIONID	Primary Key
I0001233	PERSONALIZATIONID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3592	MBRGRP_ID	MBRGRP	MBRGRP_ID	Cascade