Last Updated: caa. 28 Dec 22
Following JSON details the fields that will be sent to both Slacker Manager. The source for the intrabank transactions historical features is retrieved from the following source.
transactions.transactions_intrabank_transaction_occurred_event_v2BigQuery Table:
PROJECT_ENV.transactions.transactions_intrabank_transaction_occurred_event_v2
Current method of retrieving the historical features, is to run an SQL query against the specified BigQuery table and aggregate the historical features as part of this query. A sample of the query execution will return the following table and values.
The keys of the table are:
cust_id-senderInfo.customerIdbeneficiary_acc_id-beneficiaryInfo.customerId
Historical features are calculated as the difference in the number of hours between now and the expectedDate of transaction. Here one day is defined as 24 hours in the hour_diff variable.
DATETIME_DIFF(CURRENT_DATE(), SAFE_CAST(expectedDate as date), HOUR) as hour_diff
360 days:
hour_diff <= 360*2430 days:
hour_diff <= 30*247 days:
hour_diff <= 7*241 day:
hour_diff <= 1*24
Intrabank Transaction Features - transaction_intrabank_history_features
Response Result | Description | feature_id | Feature Type | Type |
|---|---|---|---|---|
cust_id |
|
|
| UUID |
beneficiary_acc_id | The recipient account id |
|
| UUID |
status | The status of the transaction - E.g. PENDING, SUCCESS, etc. |
| STRING | |
tx_total_count | Total count of transactions made till date |
|
| INT |
tx_count_1d | Total count of transactions made in the last 24 hours |
|
| INT |
tx_sum_1d | Total amount of transactions made in the last 1 day |
|
| FLOAT |
tx_days_since_last | Number of days since the last transaction was made |
|
| INT |
tx_avg_last5_out | Average amount of the last 5 outgoing transactions |
|
| FLOAT |
tx_count_30d | Total count of transactions made in the last 30 days |
|
| INT |
tx_sum_30d | Total amount of transactions made in the last 30 days |
|
| FLOAT |
tx_count_7d | Total count of transactions made in the last 7 days |
|
| INT |
tx_sum_7d | Total amount of transactions made in the last 7 days |
|
| FLOAT |
tx_count_360d | Total count of transactions made in the last 360 days |
|
| INT |
tx_sum_360d | Total amount of transactions made in the last 360 days |
|
| FLOAT |
tx_avg_360d | Total amount of transactions made in the last 360 days |
| Inter-day | FLOAT |
