Actions
Feature #132
closedexclude lapsed VIP from DP profit batch file
Status:
Closed
Priority:
Immediate
Assignee:
Chee-Hoong
Category:
-
Target version:
-
Start date:
12/21/2011
Due date:
12/23/2011
% Done:
0%
Estimated time:
Resolution:
Fixed
Description
In the coming profit month, those lapsed VIP needed to be excluded from the batch file:
- use VIP_NETWORK table to determine the status of the VIP, by combining the following 2 fields:
- DATA_MONTH - the profit month
- VIP_STATUS - the status of the VIP in that particular profit month
- S means lapsed
The data is still retrieving from VIP_STAT table.
Since the next publish date will be on 24-Dec, this change have to be fully tested and ready by 23-Dec.
If there's any question on the requirement, you can check with Ting-Ting. For other matters, you can refer to me.
Files
Actions