Purpose
This report archives all the loyalty cards whose status is either oneamong lost/stolen/locked/returned/invalid. All cards whose status isordered but whose valid to date has lapsed are also archived.

Selection
The cards selected for archiving are:
1. All cards that are in the status lost/stolen/locked/returned/invalid.
2. All cards that are in the status ordered but whose valid to date haslapsed.

Output
All cards with the following status will be deleted from the loyaltycards database table and would be archived.

• All cards that are in the status lost/stolen/locked/returned/invalid


• All cards that are in the status ordered but whose valid to date has
lapsed.