Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Platform-generated schema changes

Updated on June 3, 2022

The schema for the Pega Platform database can grow and evolve through a variety of tools and automatic changes. Automatic changes are possible only if the primary account or the administrative account on the Database data instance that defines the connection to the Pega Platform database has the ALTER TABLE and CREATE TABLE capabilities.

Often these capabilities are on development systems but are not on production systems (as determined by the production level value in the System data instance.) In addition, certain capabilities require that you have specific privileges.

Automatic schema changes

In a development system, the Pega Platform automatically creates a new table each time you indirectly create a new concrete class by using App Studio, the Connector and Metadata wizard, and similar tools. You must have the SchemaTableCreation privilege to create these tables. The following types of tables are created:
  • Work- — When you define a concrete class derived from Work- that is a class group, the Pega Platform creates a database table that is a copy of the pc_work table. The table is named pc_zzzzz_work, where ZZZZZ is the class group name in all lowercase.
  • Data- — Optionally, you can save the rows of a data table in a dedicated table by using the Data Table wizard. The table is named pr_zzzzz, where zzzzz is the class name of the table.

    Note: Local data storage replaced data tables.
  • History — The new table is named pc_history_zzzzz_work, where ZZZZZ is the class group name in all lowercase.

Property optimization schema changes

To support reporting, you can expose a property value to make it a separate database column by using the Property Optimization or Modify Schema wizards. These tools can add or update a column in an existing database table.

Schema changes from an archive

You can import and apply schema changes from an archive by using the Import wizard page. This approach is useful when you want to keep the schemas of two systems synchronized. See Importing rules and data by using the Import wizard for more information.

Viewing generated schema changes

You can view consolidated information about changes applied to the database schema on this system. Information is drawn from three concrete classes derived from Log-System-Schema-.

  1. Click ConfigureSystemDatabase.
  2. Click the Schema Change Tracking tab.
  3. Select the schema changes that you want to view from the list at the top of the screen.
    • All – View all schema changes made to this system since it was installed or last upgraded.
    • PRPC Shipped – View schema changes created by the initial creation of the Pega Platform schema when the system was installed or upgraded.
    • PRPC Generated – View schema changes made by automated operations in Pega Platform, for example, the Import wizard, property optimization or database schema optimization.
    • Manual – View schema changes made directly by the Pega Platform developers.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us