9.4 Aggregates List
The section provides the list of aggregates available for RL and HT.
The following table provides the list of aggregates available for RL and HT.
Table 9-1 List of Aggregate
| Aggregate Name | Aggregate Description | Scenario Type |
|---|---|---|
| AGGREGATE_NAME | AGGREGATE_DESC | SCENARIO_TYPE |
| TOT_CASH_DEBIT_AMT | Total Cash Debit Amount for HT Transactions | HT |
| TOT_CASH_CREDIT_AMT | Total Cash Credit Amount for HT Transactions | HT |
| TOT_CASH_DEBIT_CT | Total Cash Debit Count for HT Transactions | HT |
| TOT_CASH_CREDIT_CT | Total Cash Credit Count for HT Transactions | HT |
| TOT_WIRE_DEBIT_AMT | Total Wire Debit Amount for HT Transactions | HT |
| TOT_WIRE_CREDIT_CT | Total Wire Credit Count for HT Transactions | HT |
| TOT_CRYPTO_DEBIT_AMT | Total Crypto Debit Amount for HT Transactions | HT |
| TOT_CRYPTO_CREDIT_CT | Total Crypto Credit Count for HT Transactions | HT |
| TOT_CASH_DEBIT_AMT_DAY | Total Cash Debit Amount for HT Transactions during the daytime | HT |
| TOT_CASH_CREDIT_AMT_DAY | Total Cash Credit Amount for HT Transactions during the daytime | HT |
| TOT_CASH_DEBIT_CT_DAY | Total Cash Debit Count for HT Transactions during the daytime | HT |
| TOT_CASH_CREDIT_CT_DAY | Total Cash Credit Count for HT Transactions during the daytime | HT |
| TOT_CASH_DEBIT_AMT_NIGHT | Total Cash Debit Amount for HT Transactions during the nighttime | HT |
| TOT_CASH_CREDIT_AMT_NIGHT | Total Cash Credit Amount for HT Transactions during the nighttime | HT |
| TOT_CASH_DEBIT_CT_NIGHT | Total Cash Debit Count for HT Transactions during the nighttime | HT |
| TOT_CASH_CREDIT_CT_NIGHT | Total Cash Credit Count for HT Transactions during the nighttime | HT |
| TOT_WIRE_DEBIT_AMT_DAY | Total Wire Debit Amount for HT Transactions during the daytime | HT |
| TOT_WIRE_CREDIT_AMT_DAY | Total Wire Credit Amount for HT Transactions during the daytime | HT |
| TOT_WIRE_DEBIT_CT_DAY | Total Wire Debit Count for HT Transactions during the daytime | HT |
| TOT_WIRE_CREDIT_CT_DAY | Total Wire Credit Count for HT Transactions during the daytime | HT |
| TOT_WIRE_DEBIT_AMT_NIGHT | Total Wire Debit Amount for HT Transactions during the nighttime | HT |
| TOT_WIRE_CREDIT_AMT_NIGHT | Total Wire Credit Amount for HT Transactions during the nighttime | HT |
| TOT_WIRE_DEBIT_CT_NIGHT | Total Wire Debit Count for HT Transactions during the nighttime | HT |
| TOT_WIRE_CREDIT_CT_NIGHT | Total Wire Credit Count for HT Transactions during the nighttime | HT |
| TOT_CRYPTO_DEBIT_AMT_DAY | Total Crypto Debit Amount for HT Transactions during the daytime | HT |
| TOT_CRYPTO_CREDIT_AMT_DAY | Total Crypto Credit Amount for HT Transactions during the daytime | HT |
| TOT_CRYPTO_DEBIT_CT_DAY | Total Crypto Debit Count for HT Transactions during the daytime | HT |
| TOT_CRYPTO_CREDIT_CT_DAY | Total Crypto Credit Count for HT Transactions during the daytime | HT |
| TOT_CRYPTO_DEBIT_AMT_NIGHT | Total Crypto Debit Amount for HT Transactions during the nighttime | HT |
| TOT_CRYPTO_CREDIT_AMT_NIGHT | Total Crypto Credit Amount for HT Transactions during the nighttime | HT |
| TOT_CRYPTO_DEBIT_CT_NIGHT | Total Crypto Debit Count for HT Transactions during the nighttime | HT |
| TOT_CRYPTO_CREDIT_CT_NIGHT | Total Crypto Credit Count for HT Transactions during the nighttime | HT |
| TOT_HOTELS_DEBIT_AMT | Total Hotels Debit Amount for HT Transactions | HT |
| TOT_HOTELS_CREDIT_AMT | Total Hotels Credit Amount for HT Transactions | HT |
| TOT_HOTELS_DEBIT_CT | Total Hotels Debit Count for HT Transactions | HT |
| TOT_HOTELS_CREDIT_CT | Total Hotels Credit Count for HT Transactions | HT |
| TOT_DATING_SERVICES_DEBIT_AMT | Total Dating Services Debit Amount for HT Transactions | HT |
| TOT_DATING_SERVICES_CREDIT_AMT | Total Dating Services Credit Amount for HT Transactions | HT |
| TOT_DATING_SERVICES_DEBIT_CT | Total Dating Services Debit Count for HT Transactions | HT |
| TOT_DATING_SERVICES_CREDIT_CT | Total Dating Services Credit Count for HT Transactions | HT |
| TOT_DRUG_STORES_DEBIT_AMT | Total Drug Stores Debit Amount for HT Transactions | HT |
| TOT_DRUG_STORES_CREDIT_AMT | Total Drug Stores Credit Amount for HT Transactions | HT |
| TOT_DRUG_STORES_DEBIT_CT | Total Drug Stores Debit Count for HT Transactions | HT |
| TOT_DRUG_STORES_CREDIT_CT | Total Drug Stores Credit Count for HT Transactions | HT |
| TOT_TAXIS_DEBIT_AMT | Total Taxis Debit Amount for HT Transactions | HT |
| TOT_TAXIS_CREDIT_AMT | Total Taxis Credit Amount for HT Transactions | HT |
| TOT_TAXIS_DEBIT_CT | Total Taxis Debit Count for HT Transactions | HT |
| TOT_TAXIS_CREDIT_CT | Total Taxis Credit Count for HT Transactions | HT |
| TOT_BARS_DEBIT_AMT | Total Bars Debit Amount for HT Transactions | HT |
| TOT_BARS_CREDIT_AMT | Total Bars Credit Amount for HT Transactions | HT |
| TOT_BARS_DEBIT_CT | Total Bars Debit Count for HT Transactions | HT |
| TOT_BARS_CREDIT_CT | Total Bars Credit Count for HT Transactions | HT |
| TOT_RENTAL_CARS_DEBIT_AMT | Total Rental Cars Debit Amount for HT Transactions | HT |
| TOT_RENTAL_CARS_CREDIT_AMT | Total Rental Cars Credit Amount for HT Transactions | HT |
| TOT_RENTAL_CARS_DEBIT_CT | Total Rental Cars Debit Count for HT Transactions | HT |
| TOT_RENTAL_CARS_CREDIT_CT | Total Rental Cars Credit Count for HT Transactions | HT |
| TOT_MOVIE_THEATERS_DEBIT_AMT | Total Movie Theaters Debit Amount for HT Transactions | HT |
| TOT_MOVIE_THEATERS_CREDIT_AMT | Total Movie Theaters Credit Amount for HT Transactions | HT |
| TOT_MOVIE_THEATERS_DEBIT_CT | Total Movie Theaters Debit Count for HT Transactions | HT |
| TOT_MOVIE_THEATERS_CREDIT_CT | Total Movie Theaters Credit Count for HT Transactions | HT |
| TOT_WOMEN_ACCESSORY_STORES_DEBIT_AMT | Total Women Accessory Stores Debit Amount for HT Transactions | HT |
| TOT_WOMEN_ACCESSORY_STORES_CREDIT_AMT | Total Women Accessory Stores Credit Amount for HT Transactions | HT |
| TOT_WOMEN_ACCESSORY_STORES_DEBIT_CT | Total Women Accessory Stores Debit Count for HT Transactions | HT |
| TOT_WOMEN_ACCESSORY_STORES_CREDIT_CT | Total Women Accessory Stores Credit Count for HT Transactions | HT |
| TOT_JEWLERY_DEBIT_AMT | Total Jewelry Stores Debit Amount for HT Transactions | HT |
| TOT_JEWLERY_CREDIT_AMT | Total Jewelry Stores Credit Amount for HT Transactions | HT |
| TOT_JEWLERY_DEBIT_CT | Total Jewelry Stores Debit Count for HT Transactions | HT |
| TOT_JEWLERY_CREDIT_CT | Total Jewelry Stores Credit Count for HT Transactions | HT |
| TOT_WOMEN_WEAR_STORES_DEBIT_AMT | Total Women Wear Stores Debit Amount for HT Transactions | HT |
| TOT_WOMEN_WEAR_STORES_CREDIT_AMT | Total Women Wear Stores Credit Amount for HT Transactions | HT |
| TOT_WOMEN_WEAR_STORES_DEBIT_CT | Total Women Wear Stores Debit Count for HT Transactions | HT |
| TOT_WOMEN_WEAR_STORES_CREDIT_CT | Total Women Wear Stores Credit Count for HT Transactions | HT |
| TOT_OTHER_DEBIT_AMT | Total Other Debit Amount for HT Transactions | HT |
| TOT_OTHER_CREDIT_AMT | Total Other Credit Amount for HT Transactions | HT |
| TOT_OTHER_DEBIT_CT | Total Other Debit Count for HT Transactions | HT |
| TOT_OTHER_CREDIT_CT | Total Other Credit Count for HT Transactions | HT |
| TOT_WIRE_CREDIT_AMT | Total Wire Credit Amount for HT Transactions. | HT |
| TOT_WIRE_DEBIT_CT | Total Wire Debit Count for HT Transactions. | HT |
| TOT_CRYPTO_CREDIT_AMT | Total Crypto Credit Amount for HT Transactions | HT |
| TOT_CRYPTO_DEBIT_CT | Total Crypto Debit Count for HT Transactions | HT |
| tot_credit_amount | Total credit amount | RL |
| tot_debit_amount | Total debit amount | RL |
| tot_amount | Total credit amount + Total debit amount | RL |
| tot_credit_amount_with_mita(min_ind_val_tshld) | Total credit amount with minimum individual transaction value as a parameter. min_ind_val_tshld should be present in the thresholds field of JSON value. If min_ind_val_tshld is not provided, it will default to zero. | RL |
| tot_debit_amount_with_mita(min_ind_val_tshld) | Total credit amount with minimum individual transaction value as a parameter. min_ind_val_tshld should be present in the thresholds field of JSON value. If min_ind_val_tshld is not provided, it will default to zero. | RL |
| tot_credit_amount_cash | Total credit amount in cash | RL |
| tot_debit_count_cash_with_rita(min_ind_val_tshld=,max_ind_val_tshld=) | Total debit count with a range of minimum and maximum individual transaction amounts. For CASH channel only | RL |
| tot_credit_amount_with_rita(min_ind_val_tshld,max_ind_val_tshld) | Total credit amount with range between min_ind_val_tshld and max_ind_val_tshld. Both min_ind_val_tshld and max_ind_val_tshld should be present in thresholds field of JSON value. | RL |
| tot_credit_count | Total credit count | RL |
| tot_debit_count | Total debit count | RL |
| tot_credit_amount_cash_with_rita(min_ind_val_tshld=,max_ind_val_tshld=) | Total credit amount with a range of minimum and maximum individual transaction amounts. For CASH channel only | RL |
| tot_credit_count_cash_with_rita(min_ind_val_tshld=,max_ind_val_tshld=) | Total credit count with a range of minimum and maximum individual transaction amounts. For CASH channel only | RL |
| tot_debit_amount_cash_with_rita(min_ind_val_tshld=,max_ind_val_tshld=) | Total debit amount with a range of minimum and maximum individual transaction amounts. For CASH channel only | RL |
| tot_debit_amount_cash | Total debit amount in cash | RL |