Created by User 87682, last modified on Dec 28, 2022

Historical Cross-Reference Features - cards_transaction_historical_features

  • What’s the occurrence and/or amount or accumulative amount of the transactions observed in last 10 mins, 1 hour, 2 hours, 24 hours, in last 360 days, and during this timeframe 10pm - 6am:

    • transaction unique key

      • transactionId

    • transaction amount

      • cardHolderBillingAmount

    • online transaction

      • ECOMindicator

    • transaction

      • panEntryMode

    • ATM transaction

      • panEntryMode, pinValidation

    • datetime field

      • localtransactiondatetime

    • Acquirer Country Code

      • acquirerCountryCode

feature_id

Description

Feature Calculation

Type

proxynumber

entity_id

-

STRING

sum_online_transaction_24hrs

SUM of online transactions amount in last 24 hours

SUM(cardHolderBillingAmount)

localtransactiondatetime

ECOMindicator=2

FLOAT

sum_virtual_transaction_24hrs

SUM of virtual transactions amount in last 24 hours

SUM(cardHolderBillingAmount)

localtransactiondatetime

ECOMindicator=2

FLOAT

sum_contactless_transaction_24hrs

SUM of contactless transactions amount in last 24 hours

SUM(cardHolderBillingAmount)

localtransactiondatetime

ECOMindicator=6

FLOAT

sum_atm_transactions_24hrs

SUM of ATM transactions amount in last 24 hours

SUM(cardHolderBillingAmount)

panEntryMode

FLOAT

count_virtual_transaction_24hrs

Count of unique Virtual Transactions in last 24hours

COUNT(DISTINCT transactionId)

localtransactiondatetime

ECOMindicator=2

INT64

count_online_transaction_24hrs

Count of unique Online Transactions in last 24hours

COUNT(DISTINCT transactionId)

localtransactiondatetime

ECOMindicator=2

INT64

count_contactless_transactions_2hrs

Count of unique Contactless Transactions in last 2hours

COUNT(DISTINCT transactionId)

localtransactiondatetime

panEntryMode

INT64

count_contactless_transactions_24hrs

Count of unique Contactless Transactions in last 24hours

COUNT(DISTINCT transactionId)

localtransactiondatetime

panEntryMode

INT64

is_online_after_pos_1hr

OL transactions after a POS card transaction within 1 hour

 

BOOL