CPGNLOG

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
USRTRAFFIC_IDBIGINT NOT NULLReserved for HCL internal use.
STOREENT_IDINTEGER NOT NULLReserved for HCL internal use.
MPE_IDINTEGER NOT NULLReserved for HCL internal use.
MPETYPE_IDINTEGERReserved for HCL internal use.
MPENAMEVARCHAR (64)Reserved for HCL internal use.
INITIATIVE_IDINTEGER NOT NULLReserved for HCL internal use.
MPETYPENAMEVARCHAR (64)Reserved for HCL internal use.
CAMPAIGN_IDINTEGERReserved for HCL internal use.
SHOPSEGMENTSVARCHAR (254)Reserved for HCL internal use.
RESULTSVARCHAR (254)Reserved for HCL internal use.
INITIATIVENAMEVARCHAR (64)Reserved for HCL internal use.
CAMPAIGNNAMEVARCHAR (64)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>USRTRAFFIC_ID+MPE_ID+INITIATIVE_IDPrimary Key