Red Dot Payment Data Source
| Background | Data Source | Methodology |
|---|
Metadata
Currently, we have managed to obtain the transaction data of 2017 provided by RDP.
Below are the definitions of common terms used in their business model:
MERCHANT - A merchant is a business, often a retailer, that operates online. Each merchant has appointed RDP to be its payment processor to handle online transactions between them and their customers.
CUSTOMER - A customer is an entity that makes a transaction with the merchant. For a transaction to be made, a customer must make contact with a merchant and provide their payment details (e.g. Credit card number) to the merchant through RDP’s payment processing gateway.
The following table shows the list of variables in the data and their associated description:
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| date_created | Date | Data and time at which the transaction was carried out between merchant and customer |
| name | Alphanumeric | Name of merchant |
| amount of money | Decimal | Total transaction amount |
| currency | CHAR(3) | Currency of the transaction amount - usually in SGD or USD |
| reason_code | Alphanumeric | A unique code tagged to each reason for each approved or rejected transaction by customer |
| reason_code_description | Alphanumeric | Description of the reason for each approved or rejected transaction by customer |
| card_data1 | Integer | First 6 digits of customer’s card number - reveals details about the issuing bank and card type |
| card_data2 | Integer | Last 4 digits of customer’s card number |
| contact_ip_address | Alphanumeric | IP address of the customer |
| contact_ip_country | Alphanumeric | IP country of the customer |
*Sample dataset shown in proposal, due to sensitivity of data
