CAMPAIGNASSOCIAT

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