Required columns for tables

Updated on May 11, 2022

Every database table that you add to the Pega Platform database must contain these five columns.

pxObjClass — The Pega Platform class name, typically VARCHAR2(96 ).
pxCreateDateTime — The date, typically DATE. This column has a different name in a few tables.
pyLabel — A short description, VARCHAR2(64)
pzInsKey — Primary key, always includes the pxObjClass value or a class group name, VARCHAR2 (255) NOT NULL. The pzInskey column is identified as the unique key to the table by using a constraint.
pzPVStream — The storage stream ( BLOB).

Have a question? Get answers now.

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

Visit the Support Center