Skip to main content

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

Preparation for Soft-Delete Functionality

Updated on January 18, 2022

Soft-Delete represents functionality to omit data from being displayed or processed without physically deleting records from tables. Table record can be marked as Active or Inactive, allowing functionality to determine which records to retrieve. Since data is not physically deleted, customer has extra safety net that Soft-Delete can always be reversed by simply changing the status of the record from Inactive to Active.


Pega Foundation for Financial Services (PFFS) implemented Soft-Delete functionality on several reference data tables:

FSF_REF_COUNTRY (Country codes, names and risk)

FSF_REF_SECTOR (Industry sector codes and descriptions)

FSF_REF_EXCHANGE (International exchange codes and names)

FSF_REF_REGULATOR (International regulator codes and names)

FSF_REF_INDUSTRY (Industry codes and descriptions)

FSF_REF_SUBINDUSTRY (Subindustry codes and descriptions)

FSF_REF_INDUSTRYGROUP (Industry group codes and descriptions)

FSF_RELCODE (Related party codes and descriptions)

Each table has been extended with status column representing if record is Active or Inactive. Default status value is ‘Active’ or NULL represents active record.

Possible values for status column are Active, Inactive, and NULL. Values are not case sensitive.

View of FSF_REF_EXCHANGE table with status column values set to ‘Active’ for each record.

Each corresponding data class structure has been extended with new status property and mapping of status value to and from tables via CRUD.

Visually, status column and value can be observed in the Dev Studio: Configure > Financial Services > Reference Data, landing page for country data.

This functionality contains only data structure, logic to handle active vs. inactive records is coming in the future release.

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. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us