Back Forward Working with the PegaRULES database
System tables

Working with the PegaRULES database

In the initial PegaRULES database schema, twenty four PegaRULES database tables contain instances of concrete classes derived from the System- base class.

CautionDo not alter the mapping, schema, or structure of these tables except as advised by Pegasystems support staff.

Table

Description

pr_page_store Contains rows corresponding to instances of the System-SavedPages class. When a user session times out, the system saves a user's entire thread context automatically in this table, until that user completes a log-in challenge or an expiration timeout occurs. The system automatically deletes rows of this table that are more than three days old.
pr4_rule_sysgen Contains instances of the System-CachedConclusion class.
pr_sys_appcache_dep Supports operations in AppCache mode. See Understanding Application-Based Assembly mode.
pr_sys_appcache_dep Supports operations in AppCache mode. See Understanding Application-Based Assembly mode.
pr_sys_appcache_dep Supports operations in AppCache mode. See Understanding Application-Based Assembly mode.
pr_sys_app_ruleset_index Contains instances of the System-ApplicationRuleSetIndex class, an index relating RuleSet versions to applications that reference those RuleSet versions.
pr_sys_cache_dep Contains instances of the System-Cache-Dependency class, maintaining facts used in internal operations, supporting rules assembly and the static assembler.
pr_sys_cache_entry Contains instances of the System-Cache-Dependency class, maintaining facts used in internal operations, supporting rules assembly and the static assembler.
pr_sys_cache_impl Contains instances of the System-Cache-Dependency class, maintaining facts used in internal operations, supporting rules assembly and the static assembler.
pr_sys_class_ancestors Contains instances of the Data-Rule-ClassAncestor class, which supports rule resolution.
pr_sys_context Contains rows corresponding to instances of the System-Requestor-Context class, for passivated requestors.
pr_sys_decchg Contains rows corresponding to instances of the System-Declare-Changes class, to support execution of declarative expression rules.
pr_sys_locks Contains rows corresponding to locks held, instances of the System-Locks class.
pr_sys_queues Contains rows for queued service requests from concrete classes such as System-Queue-DefaultEntry, derived from the System-Queue- abstract class, except for classes explicitly mapped to another table.
pr_sys_queue_autotest Contains rows for queued unit test suite runs, instances of the System-Queue-TestSuite class.
pr_sys_queue_execreq_conn Contains rows for queued connector requests, instances of concrete classes derived from the System-Queue-ExecutionRequest-Service- class. About Connector Request Processor data instances.
pr_sys_queue_execreq_svc Contains rows for queued service requests, instances of concrete classes derived from the System-Queue-ExecutionRequest-Connect- class. About Service Request Processor data instances.
pr_sys_queue_sla Contains rows for instances of the System-Queue-ServiceLevel class, supporting event-driven processing of service level deadlines and goals by the Pega-ProCom agent. Understanding the Pega-ProCom agent.
pr_sys_queue_startflows Contains rows for starter flows, reflected in instances of the System-Queue-StartingFlows class. Facilitates fast operation of the drop-down list of starting flows by application on application portals.
pr_sys_ruleset_index Contains rows for the System-RuleSet-Index class, supporting improved performance by providing quick access to RuleSet list has codes.
pr_sys_statusnodes Contains one row for each participating node in the system, corresponding to instances of the System-Status-Nodes class.
This table occasionally can contain apparently duplicate rows, because the true key is based on an encrypted form of the node name, system name, and path of the temporary directory. Run the RemoveOldNodes activity to purge rows corresponding to nodes that have been inactive for at least 24 hours.
pr_sys_updatescache Contains one row for each change to the rules since the most recent pulse processing by the PegaRULES agent. These rows correspond to instances of the System-Updates-Cache class. When rules are updated and added to the cache, this table is scanned by a trigger; the table is emptied when cache processing completes. See Understanding the PegaRULES agent.
pr_sys_workindexer_queue Contains rows of the System-Work-Index class, identifying work items that need re-indexing for full-text search.
pr_sys_user Contains one row for each rule delegation, corresponding to instances of the System-User-MyRules class.
pr_sysjobs Contains rows for queued column population jobs, instances of the System-Job-PropertyOptimization class, reported on the Column Population Jobs tab of the Database landing page. See System category — Database landing page.

The database table pr_portal_state holds instances of the two classes Pega-Portal-Developer and Pega-Portal-User, which contain saved information about portal use by each connected user.

Definitions passivation, referencing rules, timeouts
Standard rules Atlas — Initial Database Table data instances
Atlas — Standard classes derived from the System- base class

HomeWorking with the PegaRULES database