--- title: "Default Queries in the PSD2 Report Model in OneSpan Risk Analytics for Corporate Banking" slug: "default-psd2-report-queries-corporate-banking" updated: 2025-07-04T10:07:17Z published: 2025-07-07T11:23:03Z canonical: "docs.onespan.com/default-psd2-report-queries-corporate-banking" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.onespan.com/llms.txt > Use this file to discover all available pages before exploring further. # Default Queries in the PSD2 Report Model in OneSpan Risk Analytics for Corporate Banking ## Monitoring Global Transactions 3 previous months The Monitoring Global Transactions 3 previous months query provided in the PSD2 model reports the data listed in [Monitoring Global Transactions 3 previous months – columns](/sec/docs/default-psd2-report-queries-corporate-banking#TAB_Glob_TXN_3_Prev_Mnths_Colmns).

Monitoring Global Transactions 3 previous months – columns

Expression

Title

Sorting

Count of LV_PSD2_TXN.TXN_ID

TOTAL_TX_NB

Not sorted

Sum of LV_PSD2_TXN.AMT_CH_BILL

TOTAL_TX_AMT

Not sorted

Average of LV_PSD2_TXN.AMT_CH_BILL

TX_AMT_AVG

Not sorted

Sum of LV_PSD2_TXN.IS_DISPUTED

TOTAL_DISPUTED_TX_NB

Not sorted

Sum of LV_PSD2_TXN. DISPUTED_AMT_CH_BILL

TOTAL_DISPUTED_TX_AMT

Not sorted

Average of LV_PSD2_TXN.DISPUTED_AMT_CH_BILL

DISPUTED_TX_AMT_AVG

Not sorted

The query applies the following conditions: LV_PSD2_TXN.CREATED_DATE *within* 90 *previous days* AND { LV_PSD2_TXN.RESPONSE_CODE *is equal to* 0 //i.e. Accept OR LV_PSD2_TXN.RESPONSE_CODE *is equal to* 1 //i.e. Declined } ## Monitoring Transactions 3 previous months with SCA performed The Monitoring Transactions 3 previous months with SCA performed query provided in the PSD2 model reports the data listed in [Monitoring Transactions 3 previous months with SCA performed – columns](/sec/docs/default-queries-in-the-psd2-report-model-in-onespan-risk-analytics-for-corporate-banking#TAB_3_Prev_Mnths_With_SCA_Colmns).

Monitoring Transactions 3 previous months with SCA performed – columns

Expression

Title

Sorting

Count of LV_PSD2_TXN.TXN_ID

TOTAL_TX_NB

Not sorted

Sum of LV_PSD2_TXN.AMT_CH_BILL

TOTAL_TX_AMT

Not sorted

Average of LV_PSD2_TXN.AMT_CH_BILL

TX_AMT_AVG

Not sorted

Sum of LV_PSD2_TXN.IS_DISPUTED

TOTAL_DISPUTED_TX_NB

Not sorted

Sum of LV_PSD2_TXN. DISPUTED_AMT_CH_BILL

TOTAL_DISPUTED_TX_AMT

Not sorted

Average of LV_PSD2_TXN.DISPUTED_AMT_CH_BILL

DISPUTED_TX_AMT_AVG

Not sorted

The query applies the following conditions: LV_PSD2_TXN.CREATED_DATE *within* 90 *previous days* AND { LV_PSD2_TXN.RESPONSE_CODE *is equal to* 0 //i.e. Accept OR LV_PSD2_TXN.RESPONSE_CODE *is equal to* 1 //i.e. Declined } AND LV_PSD2_TXN.AUTHENTT_STATUS *is equal to* 4 //i.e Strong Authentication Success ## Monitoring Transactions 3 previous months with exemption on value transaction <= ETV The Monitoring Transactions 3 previous months with exemption on value transaction <= ETV query provided in the PSD2 model reports the data listed in [Monitoring Transactions 3 previous months with exemption on value transaction <= ETV – columns](/sec/docs/default-psd2-report-queries-corporate-banking#TAB_Exempt_Value_TXN_Colmns).

Monitoring Transactions 3 previous months with exemption on value transaction <= ETV – columns

Expression

Title

Sorting

Count of LV_PSD2_TXN.TXN_ID

TOTAL_TX_NB

Not sorted

Sum of LV_PSD2_TXN.AMT_CH_BILL

TOTAL_TX_AMT

Not sorted

Average of LV_PSD2_TXN.AMT_CH_BILL

TX_AMT_AVG

Not sorted

Sum of LV_PSD2_TXN.IS_DISPUTED

TOTAL_DISPUTED_TX_NB

Not sorted

Sum of LV_PSD2_TXN. DISPUTED_AMT_CH_BILL

TOTAL_DISPUTED_TX_AMT

Not sorted

Average of LV_PSD2_TXN.DISPUTED_AMT_CH_BILL

DISPUTED_TX_AMT_AVG

Not sorted

The query applies the following conditions: LV_PSD2_TXN.CREATED_DATE *within* 90 *previous days* AND { LV_PSD2_TXN.RESPONSE_CODE *is equal to* 0 //i.e. Accept OR LV_PSD2_TXN.RESPONSE_CODE *is equal to* 1 //i.e. Declined } AND { LV_PSD2_TXN.RULE_MATCHES.RULENAME *is equal to* Exemption on transaction value <= high ETV OR LV_PSD2_TXN.RULE_MATCHES.RULENAME *is equal to* Exemption on transaction value <= medium ETV OR LV_PSD2_TXN.RULE_MATCHES.RULENAME *is equal to* Exemption on transaction value <= low ETV } ## Monitoring Transactions 3 previous with exemption on recurring subsequent transaction The Monitoring Transactions 3 previous months with exemption on recurring subsequent transaction query provided in the PSD2 model reports the data listed in [Monitoring Transactions 3 previous months with exemption on recurring subsequent transaction – columns](/sec/docs/default-psd2-report-queries-corporate-banking#TAB_Exempt_Value_Recur_TXN_Colmns).

Monitoring Transactions 3 previous months with exemption on recurring subsequent transaction – columns

Expression

Title

Sorting

Count of LV_PSD2_TXN.TXN_ID

TOTAL_TX_NB

Not sorted

Sum of LV_PSD2_TXN.AMT_CH_BILL

TOTAL_TX_AMT

Not sorted

Average of LV_PSD2_TXN.AMT_CH_BILL

TX_AMT_AVG

Not sorted

Sum of LV_PSD2_TXN.IS_DISPUTED

TOTAL_DISPUTED_TX_NB

Not sorted

Sum of LV_PSD2_TXN. DISPUTED_AMT_CH_BILL

TOTAL_DISPUTED_TX_AMT

Not sorted

Average of LV_PSD2_TXN.DISPUTED_AMT_CH_BILL

DISPUTED_TX_AMT_AVG

Not sorted

The query applies the following conditions: LV_PSD2_TXN.CREATED_DATE *within* 90 *previous days* AND { LV_PSD2_TXN.RESPONSE_CODE *is equal to* 0 //i.e. Accept OR LV_PSD2_TXN.RESPONSE_CODE *is equal to* 1 //i.e. Declined } AND LV_PSD2_TXN.RULE_MATCHES.RULENAME *is equal to* Exemption on Recurring subsequent transaction ## Monitoring Transactions 3 previous months with exemption on transfer to same customer The Monitoring Transactions 3 previous months with exemption on transfer to same customer query provided in the PSD2 model reports the data listed in [Monitoring Transactions 3 previous months with exemption on transfer to same customer – columns](/sec/docs/default-psd2-report-queries-corporate-banking#TAB_Exempt_Transfer_Same_Cust_Colmns).

Monitoring Transactions 3 previous months with exemption on transfer to same customer – columns

Expression

Title

Sorting

Count of LV_PSD2_TXN.TXN_ID

TOTAL_TX_NB

Not sorted

Sum of LV_PSD2_TXN.AMT_CH_BILL

TOTAL_TX_AMT

Not sorted

Average of LV_PSD2_TXN.AMT_CH_BILL

TX_AMT_AVG

Not sorted

Sum of LV_PSD2_TXN.IS_DISPUTED

TOTAL_DISPUTED_TX_NB

Not sorted

Sum of LV_PSD2_TXN. DISPUTED_AMT_CH_BILL

TOTAL_DISPUTED_TX_AMT

Not sorted

Average of LV_PSD2_TXN.DISPUTED_AMT_CH_BILL

DISPUTED_TX_AMT_AVG

Not sorted

The query applies the following conditions: LV_PSD2_TXN.CREATED_DATE *within* 90 *previous days* AND { LV_PSD2_TXN.RESPONSE_CODE *is equal to* 0 //i.e. Accept OR LV_PSD2_TXN.RESPONSE_CODE *is equal to* 1 //i.e. Declined } AND LV_PSD2_TXN.RULE_MATCHES.RULENAME *is equal to* Exemption on transfer to Same Customer ## Monitoring Transactions 3 previous months with exemption on trusted beneficiary The Monitoring Transactions 3 previous months with exemption on trusted beneficiary query provided in the PSD2 model reports the data listed in [Monitoring Transactions 3 previous months with exemption on trusted beneficiary – columns](/sec/docs/default-psd2-report-queries-corporate-banking#TAB_Exempt_Trusted_Benef).

Monitoring Transactions 3 previous months with exemption on trusted beneficiary – columns

Expression

Title

Sorting

Count of LV_PSD2_TXN.TXN_ID

TOTAL_TX_NB

Not sorted

Sum of LV_PSD2_TXN.AMT_CH_BILL

TOTAL_TX_AMT

Not sorted

Average of LV_PSD2_TXN.AMT_CH_BILL

TX_AMT_AVG

Not sorted

Sum of LV_PSD2_TXN.IS_DISPUTED

TOTAL_DISPUTED_TX_NB

Not sorted

Sum of LV_PSD2_TXN. DISPUTED_AMT_CH_BILL

TOTAL_DISPUTED_TX_AMT

Not sorted

Average of LV_PSD2_TXN.DISPUTED_AMT_CH_BILL

DISPUTED_TX_AMT_AVG

Not sorted

The query applies the following conditions: LV_PSD2_TXN.CREATED_DATE *within* 90 *previous days* AND { LV_PSD2_TXN.RESPONSE_CODE *is equal to* 0 //i.e. Accept OR LV_PSD2_TXN.RESPONSE_CODE *is equal to* 1 //i.e. Declined } AND LV_PSD2_TXN.RULE_MATCHES.RULENAME *is equal to* Exemption on Trusted Beneficiary ## Monitoring Transactions 3 previous with exemption on low value transaction The Monitoring Transactions 3 previous months with exemption on low value transaction query provided in the PSD2 model reports the data listed in [Monitoring Transactions 3 previous months with exemption on low value transaction – columns](/sec/docs/default-psd2-report-queries-corporate-banking#TAB_Exempt_Low_Value_TXN_Colmns).

Monitoring Transactions 3 previous months with exemption on low value transaction – columns

Expression

Title

Sorting

Count of LV_PSD2_TXN.TXN_ID

TOTAL_TX_NB

Not sorted

Sum of LV_PSD2_TXN.AMT_CH_BILL

TOTAL_TX_AMT

Not sorted

Average of LV_PSD2_TXN.AMT_CH_BILL

TX_AMT_AVG

Not sorted

Sum of LV_PSD2_TXN.IS_DISPUTED

TOTAL_DISPUTED_TX_NB

Not sorted

Sum of LV_PSD2_TXN. DISPUTED_AMT_CH_BILL

TOTAL_DISPUTED_TX_AMT

Not sorted

Average of LV_PSD2_TXN.DISPUTED_AMT_CH_BILL

DISPUTED_TX_AMT_AVG

Not sorted

The query applies the following conditions: LV_PSD2_TXN.CREATED_DATE *within* 90 *previous days* AND { LV_PSD2_TXN.RESPONSE_CODE *is equal to* 0 //i.e. Accept OR LV_PSD2_TXN.RESPONSE_CODE *is equal to* 1 //i.e. Declined } AND { LV_PSD2_TXN.RULE_MATCHES.RULENAME *is equal to* Exemption on Low value transaction and Low amount sum OR LV_PSD2_TXN.RULE_MATCHES.RULENAME *is equal to* Exemption on Low value transaction and Low frequency }