CPGNSTATS

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

Column Descriptions:

NameTypeDescription
INITIATIVE_IDINTEGER NOT NULLReserved for HCL internal use.
MPE_IDINTEGER NOT NULLReserved for HCL internal use.
STOREENT_IDINTEGER NOT NULLReserved for HCL internal use.
MPENAMEVARCHAR (64)Reserved for HCL internal use.
MPETYPE_IDINTEGERReserved for HCL internal use.
INITIATIVENAMEVARCHAR (64)Reserved for HCL internal use.
VIEWSINTEGERReserved for HCL internal use.
CLICKSINTEGERReserved for HCL internal use.
MPETYPENAMEVARCHAR (64)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>INITIATIVE_ID+MPE_ID+STOREENT_IDPrimary Key
I0000315MPE_IDNon-Unique Index