Preparation for Soft-Delete Functionality
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.
Tables
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.
Previous topic Data Management Next topic Testing a new application