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 column 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.