Project

General

Profile

Actions
Copy link

Feature #132

closed

exclude lapsed VIP from DP profit batch file

Added by chin-yeh over 12 years ago. Updated over 12 years ago.

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

Download all files
DP_PROFIT_EXCEPTION_072011.csv (34 Bytes) DP_PROFIT_EXCEPTION_072011.csv exception report xls Chee-Hoong, 12/22/2011 12:13 PM
DP_PROFIT_FINANCE_REFERENCE_072011.xls (65.5 KB) DP_PROFIT_FINANCE_REFERENCE_072011.xls finance reference report xls Chee-Hoong, 12/22/2011 12:13 PM
DP_PROFIT_072011.txt (317 KB) DP_PROFIT_072011.txt profit report txt Chee-Hoong, 12/22/2011 12:13 PM
DP_PROFIT_EXCEPTION_112011.csv (34 Bytes) DP_PROFIT_EXCEPTION_112011.csv chin-yeh, 12/27/2011 10:01 AM
DP_PROFIT_FINANCE_REFERENCE_112011.xls (545 KB) DP_PROFIT_FINANCE_REFERENCE_112011.xls chin-yeh, 12/27/2011 10:01 AM

Related issues 1 (0 open — 1 closed)

Related to Feature #133: [EC-CR-1270] put those lapsed VIP into exception reportClosedChee-Hoong12/27/201101/13/2012

Actions
Actions
Copy link Download all files
 #1

Updated by Chee-Hoong over 12 years ago

here is the report with updated condition (excluding status lapsed) records

Actions
Copy link
 #2

Updated by chin-yeh over 12 years ago

  • Status changed from New to In Progress

Thanks for the help.

Liaise with Hann or Chee-Wei to deploy the changes to production environment before 23-Dec. After deployed, update us the deployed date & time.

Actions
Copy link
 #3

Updated by Chee-Hoong over 12 years ago

ok

Actions
Copy link
 #4

Updated by Chee-Hoong over 12 years ago

the DP batch is deployed on 22/12/2011 07:30 pm

Actions
Copy link Download all files
 #5

Updated by chin-yeh over 12 years ago

Below are the files that generated last week (24-Dec):

The above files was generated using this SQL query:

select *
FROM VIP_STAT VIP, VIP_NETWORK VIP_NET
WHERE VIP.DATA_MONTH = '2011-11-30' AND VIP.DP_EARNED <> 0
 AND VIP.DATA_MONTH = VIP_NET.DATA_MONTH
 AND VIP.VIP_REF = VIP_NET.VIP_REF
 AND VIP_NET.VIP_STATUS <> 'S'

Actions
Copy link
 #6

Updated by chin-yeh over 12 years ago

  • Status changed from In Progress to Closed
  • Resolution set to Fixed

Fixed and deployed.

See also #133

Actions
Copy link

Also available in: Atom PDF