This table holds the page names used to display CatalogGroups. The selection is based on Store, MemberGroup, DeviceType, CatalogGroup, Language, or any combination of the above. If many pages satisfy the criteria, the page that best fits will be chosen.

Column Descriptions:

CATGROUP_IDBIGINT NOT NULLThe reference number of the CatalogGroup for which this page name will be displayed. A value of 0 indicates that this page name will be used for all CatalogGroups.
DISPCGPREL_IDBIGINT NOT NULLThe reference number of this entry.
LANGUAGE_IDINTEGERThe language in which this page displays. For a list of language components, see the LANGUAGE table.
DEVICEFMT_IDINTEGER NOT NULLThe reference number of the device type that the page will be displayed on. Foreign key to the DEVICEFMT table.
PAGENAMEVARCHAR (254) NOT NULLThe name and path of the display page template. The path is relative to the application document root.
STOREENT_IDINTEGER NOT NULLThe reference number of the Store for which this page will be displayed.
MBRGRP_IDBIGINT NOT NULLThe reference number of the MemberGroup for which this template page will display. A value of 0 indicates that this template page will be used for all MemberGroups.
DESCRIPTIONVARCHAR (254)A descriptive comment of this entry.
RANKDOUBLEA sequence number used to break ties when more than one page satisfies the selection criteria. The larger the rank, the lower the precedence of the page.
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
OIDVARCHAR (64)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000554STOREENT_IDNon-Unique Index
I0000555CATGROUP_IDNon-Unique Index
I0000556MBRGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType