• Table of contents
• Batches
  • PurgeRP
  • Report
  • Table

Batches¶

PurgeRP¶

Program Class : ECpurgeRP
Run Indicator :

0 - First Time run only, For earn and get from table MEMBER_ACCOUNT

1 - Subsequence to Calculate Earn and Utilize RP from table TRANSACTION

2 - Calculate Utilized RP and Deduct from ProcessDate Balance

3 - Purge expired RP

-3 - Roll back (3)

-2 - Roll back (2)

Report¶

Program Class : GenHKRPDaily
Steps :

1. Call webservice (EcHkMemberController.getRPBalanceExpiryDateList) get HK & MC RP balance with expiry date.
2. Write RP to file name : RPyymmdd.HK

Table¶

CREATE TABLE RP_PURGE (
PROCESS_DATE INTEGER NOT NULL,
MEMBER_ID VARCHAR NOT NULL,
RP_EARN DECIMAL,
RP_UTILIZE DECIMAL,
RP_TOTAL_UTILIZED DECIMAL DEFAULT 0,
RP_UTILIZED_PROCESS_DATE VARCHAR,
RP_PURGE DECIMAL,
RP_TO_BE_EXPIRED DECIMAL,
EXPIRY_DATE DATE,
PROCESS_IND VARCHAR DEFAULT 'N',
CREATE_DATETIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP,
MODIFY_DATETIME TIMESTAMP,
PRIMARY KEY (PROCESS_DATE,MEMBER_ID));