Archiving of Loyalty Objects
Archiving involves copying of data from the database to external archive files. The copied data is later deleted from the database. The following table contains the list of objects you can archive for loyalty management along with the list of programs available for each archiving object:
Object |
Description |
Programs |
|---|---|---|
LOY_ATC |
To archive all anonymous temporary cards data. |
RLOY_ATC_ARCHIVE_WRITE RLOY_ATC_ARCHIVE_DELETE RLOY_ATC_ARCHIVE_READ |
LOY_CARD |
To archive data of cards with status lost, stolen, locked, returned, invalid, and cards that are ordered but validity has expired. |
RLOY_CARD_ARCHIVE_WRITE RLOY_CARD_ARCHIVE_DELETE RLOY_CARD_ARCHIVE_READ |
LOY_MA |
To archive member activity data. |
RLOY_MA_ARCHIVE_WRITE RLOY_MA_ARCHIVE_DELETE RLOY_MA_ARCHIVE_READ |
LOY_MSH |
To archive membership data along with tier data. |
RLOY_MSH_ARCHIVE_WRITE RLOY_MSH_ARCHIVE_DELETE RLOY_MSH_ARCHIVE_READ |
LOY_PPT |
To archive partner point transactions that are older than six months. |
RLOY_PPT_ARCHIVE_WRITE RLOY_PPT_ARCHIVE_DELETE RLOY_PPT_ARCHIVE_READ |
LOY_PTACCT |
To archive expired point account sets. |
RLOY_PT_ACCT_ARCHIVE_WRITE RLOY_PT_ACCT_ARCHIVE_DELETE RLOY_PT_ACCT_ARCHIVE_READ |
LOY_PT_TXN |
To archive point account transactions. |
RLOY_PT_TXN_ARCHIVE_WRITE RLOY_PT_TXN_ARCHIVE_DELETE RLOY_PT_TXN_ARCHIVE_READ |
Prerequisites
The aspect of loyalty program, which you want to archive must have the system status To Archive
.
The following Customizing is to be maintained for archiving:
Archive Object
You maintain the archive object using the transaction ABOJ.
Field Catalog
Field catalogs are the basis for single document access through Archive Information Systems. You define the fields to be archived using the transaction SARI.
Archive Infostructure
An archive infostructure is created using archiving object and field catalog mentioned. Archive infostructures are used to read data from archive files. You create archive infrastructures using the transaction SARI.
Process
Write
In transaction SARA, schedule a job to write your loyalty program data. At the scheduled time, all the aspect of a loyalty program, which meet the archiving conditions are determined and written to an archive file.
Delete
Once the system has written all the data to the archive, the archived data is deleted from the database. You schedule the relevant deletion program in Archive Administration for this purpose.
Read
There is also a read program in transaction SARA, which you can use to display archived data again later, if required.
Result
You have archived the aspects of loyalty program in the archive infostructure and the archived data is deleted from the database.
Note
To include archived objects in your search, choose the Archive Search
pushbutton on the CRM Webclient UI.