Extend the purging program to include core extension tables

The Core Extension tables in SCV are designed for ’manual’ data entry using SCV datasheets; hence it is possible to manually delete records from these extension tables. However, it is also possible to import data directly to these extension tables from files.

The SCV program PURGE_PLANNING_DATA is extended with the new PURGE_SCOPE input parameter to allow users to purge the contents of extension tables using macros. This new optional parameter is used to determine the tables to consider during purging. This value is evaluated only when the specified table is a Core table, else not considered.

PURGE_SCOPE parameter can have these values:

  • 0: All tables which include core and extension tables, if exist.
  • 1: Only the base table in scope, default value.
  • 2: Extension table only
Note: When option 0 is selected, and other COLUMN* parameters are specified, the specified columns must exists in the specified main and extension tables.

Currently, system-defined macros are not delivered as part of the standard content to purge extension tables.

Note: By default, this feature is enabled. A new role or privilege is not required to access this feature.