Purge Item Induction Staging Tables (itm_indctn_purge.ksh)
Module Name |
itm_indctn_purge.ksh |
Description |
Purge item induction staging tables |
Functional Area |
Foundation-Items |
Module Type |
Admin |
Module Technology |
Shell Script |
Catalog ID |
RMS498 |
Runtime Parameters |
N/A |
Design Overview
The purpose of this module is to remove old item records from the staging tables. Records that are candidates for deletion are:
-
Processes that have successfully been processed or processed with warnings that have been uploaded to Merchandising or downloaded to S9T
-
Processes that have status = 'PE', processed with errors and have no linked data
-
Processes in error status where all other related records containing the process ID have been processed successfully
-
Processes that have errors and are past the data retention days (system_options.proc_data_retention_days)
-
All item records within a process where all related records for the item in the other staging tables are successfully uploaded to Merchandising. The process tracker record for that process should not be deleted if there are other item records that are not uploaded to Merchandising.