The CAMPAIGNASSOCIAT table lists the association between a campaign and any associated entities.
This table is used by the following domain.
|Name||Comment||Datatype||Null Option||Is PK|
|CAMPAIGNASSOC_ID||A unique, system-generated key that identifies a Campaign Group in the system.||BIGINT||Not Null||Yes|
|ENTITY_NAME||The name of the business entity that is associated with the Campaign.||VARCHAR(20)||Not Null||No|
|INSTANCE_PK||The actual primary key of the row in the logical entity that is associated with the Campaign.||BIGINT||Not Null||No|
|CAMPAIGN_ID||The primary key of a campaign record.||BIGINT||Not Null||No|
|ASSOCIATE_IND||Identifies whether this is a target association or regarding association.||CHAR(1)||Null||No|
|START_DT||The date when this record becomes active.||TIMESTAMP||Not Null||No|
|END_DT||The date when this record becomes inactive.||TIMESTAMP||Null||No|
|LAST_UPDATE_USER||The ID of the user who last updated the data.||VARCHAR(20)||Null||No|
|LAST_UPDATE_DT||When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails.||TIMESTAMP||Not Null||No|
|LAST_UPDATE_TX_ID||A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row.||BIGINT||Null||No|