Purge Export Data (data_export_purge_job)
Module Name |
data_export_purge_job |
Description |
Purging of all the extracted records (week old) for Xstore. |
Functional Area |
Foundation1 |
Module Type |
Admin - Ad hoc |
Module Technology |
Background processing |
Catalog ID |
N/A |
Wrapper Script |
b8dwrap.ksh |
Design Overview
This background job is composed of one step processing only. It will retain the business logic processing from original KSH script algorithm.
The Business logic program will removed all old/aged records from the following staging tables related to data exported information which are considered week old regardless if data is extracted or not.
Key Tables Affected
Table 2-6 Key Tables Affected
Table | Select | Insert | Update | Delete |
---|---|---|---|---|
MERCHHIER_EXPORT_STG |
No |
No |
No |
Yes |
ORGHIER_EXPORT_STG |
No |
No |
No |
Yes |
STORE_EXPORT_STG |
No |
No |
No |
Yes |
DIFFS_EXPORT_STG |
No |
No |
No |
Yes |
DIFFGRP_EXPORT_STG |
No |
No |
No |
Yes |
ITEM_EXPORT_STG |
No |
No |
No |
Yes |
VAT_EXPORT_STG |
No |
No |
No |
Yes |
RELITEM_EXPORT_STG |
No |
No |
No |
Yes |
DATA_EXPORT_HIST |
No |
No |
No |
Yes |