Back Forward Working with the PegaRULES database — Views and Indexes

Working with the PegaRULES database

 

Six database views are defined in the database to support searching and reporting.

CautionWhen an existing PRPC system is upgraded to a new version, SQL scripts may update the standard tables. To avoid possible collisions or other issues with future upgrades, make schema changes (other than simple new columns) only to copies of the standard tables and views. Adjust table rows and Data-Admin-DB-Table mappings to reference your copies. This is especially important for database views, as upgrade processing may drop view definitions and add revised view definitions.

Views for assignments

Work History view

Views for rules

Database Indexes

Definitions check out, circumstance, referencing rules, view, visible key
Standard rules Atlas — Standard classes derived from the Index- base class

HomeWorking with the PegaRULES database