Every Pega Platform internal database table in data or rulese schema contains a pzInskey column and is the primary key to the table. When we open a record from the database to get full data in the blob , rule or data instance, we use the pzInsKey as it's unique for the table .
Example: select pzpvstream from <pega_table> where pzInskey = '<key_value>'
The key(s) to a table, as defined in a class, can be made up one or more exposed properties to the table. The values become part of the pzInskey.
Take for example the Data-Admin-Operator-ID table.
Primary Key at database level: pzInkey (Unique = yes)
Class Key (as defined in Class record): pyUserIdentifier
Thanks ChrisKoyl for reply that cleared the concept. But few queries as below
From your example, can we use property name as pzInsKey & value as "DATA-ADMIN-OPERATOR-ID KOYLC@PEGA.COM" in the Obj-Open method? If yes, Pega internally append class name again as per your explanation, will it work?
Can we formulate pzInsKey = Class Name + Class Key for all internal tables?
The only article on pzInsKey describe the structure as below which contribute to my confusion. Can we say that this is limited to the PegaRules tables?