Mastercard Incorporated
Database system architecture for refund data harmonization

Abstract:

A refund tracking (RT) computing device including a processor and a memory in communication with the processor is provided. The RT computing device is configured to receive historical transaction data from a payment network or a merchant data source, the historical transaction data received in different formats, parse data fields from the historical transaction data, store the parsed data fields for each of the transactions in a respective harmonized refund data structure in a database, receive current transaction data for a current transaction from a merchant computing device, retrieve at least one harmonized refund data structure from the database, determine a refund risk score based on comparing the current transaction data to the at least one harmonized refund data structure, and transmit the refund risk score to the merchant terminal.