Please enable JavaScript.
Coggle requires JavaScript to display documents.
Customer Loyalty Transaction (Transaction master - Data model, Use case …
Customer Loyalty Transaction
Transaction master - Data model
Use case
1) Seperate
mixed records
in Raw deposit table
2) Capture info on transaction types , programs, transaction amount
Deposit Master
Non flight redemption + redeposit
Deposit Master Residual
Withdrawal Master
Gives full picture of redemption Behaviour
Flight + Non Flight Data
Redemption + Non redepmtion records
It is result of
Union
Use case
1) Mileage burned
2) partner engagement
Fields: 33
withdrawal_master.yaml
key Fields
1) • WDL_DT
2) • ORI_SOURCE
3) • RETURNED_DT
4) • REDEEMED_MILES
5) • WDL_TYPE_LEFT/WDL_TYPE_RIGHT
6) • TXN_TYPE
7) • CAT
8) • PROD
Copied to
Raw deposit table +
Flight Deposit table +
ref_policy category
Left Join
Left Join
Raw Deposit Table
Flight related
Non Flight related
Withdrawal
General deposit
Reguar deposit
Alternative Deposit
Mileage
Award Accelerator
Buy Miles
Employee Incentive
Mileage Transfer
Compensation
BuyMiles BookingPath
Charity
Redeposit
rewards
ref_policy category
This will give products and categories info
Flight Deposit table
Filter
1) 1. CAT is not "Mileage Redemption"
2) 2. PROD is not "Air Re-credit"
Persist
the filtered records
Used for residual table
Additional column
specific record is a general deposit type
Use cases
1) Calculating Yields
2 ) Mileage earned
3) partner engagement
47 fields
•
Unique keys
: MATCHED_CUSTOMER_ID
*
DEPOSIT_DT
*
SEQ_NUM
• deposit_master.yaml
Key Fields
1) CAT
2) PROD
3) IND_DPST
Raw Withdrawal Table
flight withdrawal
non-flight withdrawal
To classify in Deposit master
records with Category - "RDM Accrual "
Earned by regular Consumption behaviour
loyalty Transaction
