INITIATIVE

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

Column Descriptions:

NameTypeDescription
INITIATIVE_IDINTEGER NOT NULLReserved for HCL internal use.
NAMEVARCHAR (64) NOT NULLReserved for HCL internal use.
DESCRIPTIONVARCHAR (254)Reserved for HCL internal use.
CAMPAIGN_IDINTEGERReserved for HCL internal use.
TYPEINTEGERReserved for HCL internal use.
STATUSCHAR (1)Reserved for HCL internal use.
FIELD1VARCHAR (254)Reserved for HCL internal use.
LASTUPDATETIMESTAMP NOT NULLReserved for HCL internal use.
LASTUPDATEDBYVARCHAR (254) NOT NULLReserved for HCL internal use.
STOREENT_IDINTEGER NOT NULLReserved for HCL internal use.
RULECLOB (1000000)Reserved for HCL internal use.
RESULTTYPECHAR (1)Reserved for HCL internal use.
SELLTYPEINTEGERReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>INITIATIVE_IDPrimary Key
I0000134NAME+STOREENT_IDUnique Index
I0000588STOREENT_IDNon-Unique Index
I0000589CAMPAIGN_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_384CAMPAIGN_IDCAMPAIGNCAMPAIGN_IDCascade
F_385STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_266INITIATIVE_IDCPPMNINITIATIVE_IDCascade