Working with the PegaRULES database
Link and Index tables

Instances of concrete classes derived from the Index- base class support reporting and rapid data access. These instances are created and deleted by Declare Index rules.

Eight standard database tables can store index instances.

Table	Description
pr_indexaccessgrouproles	Rows correspond to instances of the Index-AccessGroupRolesclass, which allows quick access to the access roles in access groups.
pr_indexaccessgroupwkpools	Rows correspond to instances of the Index-AccessGroupWorkPools class, which allows quick access to the work pools in access groups.
pr_indexassignmentskills	Rows correspond to instances of the Index-AccessGroupAssignmentSkills class, which allows quick access the skills needed by an assignment that uses intelligent routing.
pc_index_accel	Rows correspond to instances of Index-UpdateAccessUsers class.
pc_index_flowref	Rows correspond to instances of the Index-FlowRef class, which contains indexes of flow rules cross referenced by cover class.
pr_index_circumstance-def	Rows correspond to instances of the Index-CircumstanceDefinition class, which supports searches for rules by circumstance. About Circumstance Definition rules.
pr_index_customfields	Rows correspond to instances of the Index-CustomFields class, which contains instances that allow developers to search for rules with one or more custom fields. See How to select and classify rules using Custom Fields.
pr_index_operatorskills	Rows correspond to instances of the Index-OperatorSkills class, which supports skill-based routing. See More about skill rules.
pr_index_reference	Rows correspond to instances of the Index-Reference class, which contains instances supporting the Referencing Rules display, available from the Related Rules toolbar button (). See About the Referencing Rules display.
pc_index_workparty	Rows correspond to instances of the Index-WorkPartyURI class. These instances support rapid lookup work objects based on a party identifier such as an e-mail address, Zip code, telephone number or account number.
pr_index_warnings	Holds instances of the Index-Warning class, containing warning messages produced upon Save or revalidate operations. Used in the Preflight operations. (Introduced with new installations of 4.2SP6, this table may not exist on older systems upgraded from older versions.)
pr_index	Holds rows (if any) for other concrete classes derived from the Index- base class not covered by the four tables listed previously.

The pzInsKey value for rows of these tables is formed from the properties pxInsIndexedKey, pxIndexCount, and pxIndexPurpose, in that order. The pxIndexCount property makes each row unique. This property is zero-based; the first (oldest) index instance has a pxIndexCount of 0. The pxIndexPurpose key part identifies the Declare Index rule that created the index instance.

Don't confuse these tables — which contain rows automatically created and deleted by Process Commander rules of type Rule-Declare-Index — with database indexes, defined by SQL that is maintained within the database by Oracle or other database software. Both support alternate key access to other instances (rows), but the two indexing facilities are independent and unrelated.

Four tables can hold instances of concrete classes derived from the Link- base class: