• Home
• de.adorsys.psd2
• event-service-db-report-impl
• 12.2
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

d2.event-service-db-report-impl.12.2.source-code.base_event_report_db.sql Maven / Gradle / Ivy

SELECT ev.*,
       CASE
         WHEN ev.consent_id IS NOT NULL THEN cst_psu_data.psu_id
         ELSE pmt_psu_data.psu_id
       END AS psu_ex_id,
       CASE
         WHEN ev.consent_id IS NOT NULL THEN cst_psu_data.psu_id_type
         ELSE pmt_psu_data.psu_id_type
       END AS psu_ex_id_type,
       CASE
         WHEN ev.consent_id IS NOT NULL THEN cst_psu_data.psu_corporate_id
         ELSE pmt_psu_data.psu_corporate_id
       END AS psu_ex_corporate_id,
       CASE
         WHEN ev.consent_id IS NOT NULL THEN cst_psu_data.psu_corporate_id_type
         ELSE pmt_psu_data.psu_corporate_id_type
       END AS psu_ex_corporate_id_type
FROM   .event ev
       LEFT JOIN .pis_common_payment pmt
              ON ev.payment_id = pmt.payment_id
       LEFT JOIN .ais_consent cst
              ON ev.consent_id = cst.external_id
       LEFT JOIN .pis_common_payment_psu_data pmt_psu
              ON pmt.id = pmt_psu.pis_common_payment_id
       LEFT JOIN .consent_psu_data cst_psu
              ON cst.id = cst_psu.consent_id
       LEFT JOIN .psu_data pmt_psu_data
              ON pmt_psu_data.id = pmt_psu.psu_data_id
       LEFT JOIN .psu_data cst_psu_data
              ON cst_psu_data.id = cst_psu.psu_data_id