1. Input data enrichment

D_CRRYNG_AMNT1 (D_CRRYNG_AMNT1) Derivation of "Carrying amount" for IFRS related "Accounting classificiations" (loans cube)
D_CRRYNG_AMNT2 (D_CRRYNG_AMNT2) Derivation of "Carrying amount" for IFRS related "Accounting classificiations" (instruments cube)
D_ENTRPRS_SZ_CLCLTD1 (D_ENTRPRS_SZ_CLCLTD1) Derivation of “Enterprise size”
D_EXPSR_CLSS_AND_RSK_WGHT (D_EXPSR_CLSS_AND_RSK_WGHT) Preparation of dataset containing Risk weight and Exposure class

1. Load

T_GT_CMPSTN_LGL_ENTTY (T_GT_CMPSTN_LGL_ENTTY) Get "Composition of legal entity"
T_GT_CNTRPRTS (T_GT_CNTRPRTS) Get "Counterparties"
T_GT_CNTRPRTS_CDS (T_GT_CNTRPRTS_CDS) Get "Counterparty codes"
T_GT_CNTRPRTS_PD (T_GT_CNTRPRTS_PD) Get "Probability of default of the counterparty "
T_GT_CNTRY (T_GT_CNTRY) Get "Countries"
T_GT_CRDT_CRD_DBT_CNVNNC_CRDT (T_GT_CRDT_CRD_DBT_CNVNNC_CRDT) Get "Credit card debt: convenience credit"
T_GT_CRDT_CRD_DBT_EXTNDD_CRDT (T_GT_CRDT_CRD_DBT_EXTNDD_CRDT) Get "Credit card debt: extended credit"
T_GT_CRDT_FCLTS (T_GT_CRDT_FCLTS) Get "Credit facilities"
T_GT_CRDT_FCLTS_INSTRMNTS (T_GT_CRDT_FCLTS_INSTRMNTS) Get "Credit facilities-Instruments"
T_GT_ENTRPRS_SZ_PRVS_PRD (T_GT_ENTRPRS_SZ_PRVS_PRD) Get "Enterprise size (previous period)"
T_GT_EXTRNL_CRDT_ASSSSMNT (T_GT_EXTRNL_CRDT_ASSSSMNT) Get "External credit assessments"
T_GT_FCTRNG (T_GT_FCTRNG) Get "Factoring"
T_GT_FNNCL_LSS (T_GT_FNNCL_LSS) Get "Financial leases"
T_GT_GRP (T_GT_GRP) Get "Group"
T_GT_GRP_CNTRPRTY_RLTNSHP (T_GT_GRP_CNTRPRTY_RLTNSHP) Get "Group counterparty relationship"
T_GT_GRP_DT (T_GT_GRP_DT) Get "Group data"
T_GT_INDRCT_FCTRNG (T_GT_INDRCT_FCTRNG) Get "Indirect factoring"
T_GT_INSTRMNTS_PRTCTNS (T_GT_INSTRMNTS_PRTCTNS) Get "Instruments-protections"
T_GT_JNT_CNTRPRTS (T_GT_JNT_CNTRPRTS) Get "Joint counterparties"
T_GT_LNKD_ENTRPRSS (T_GT_LNKD_ENTRPRSS) Get "Linked enterprises"
T_GT_OTHR_DPSTS (T_GT_OTHR_DPSTS) Get "Other deposits"
T_GT_OTHR_FNNCL_PRTCTN (T_GT_OTHR_FNNCL_PRTCTN) Get "Other financial protection"
T_GT_OTHR_LNS (T_GT_OTHR_LNS) Get "Other loans"
T_GT_OTHR_PHYSCL_PRTCTN (T_GT_OTHR_PHYSCL_PRTCTN) Get "Other physical protection"
T_GT_OTHR_TRD_RCVBLS (T_GT_OTHR_TRD_RCVBLS) Get "Other trade receivables"
T_GT_OVRDRFTS (T_GT_OVRDRFTS) Get "Overdrafts"
T_GT_OWND_SCRTY (T_GT_OWND_SCRTY) Get "Owned securities"
T_GT_PL_ITM (T_GT_PL_ITM) Get "Pool of (repo) items"
T_GT_PRMTR (T_GT_PRMTR) Get "Parameters"
T_GT_PRTNR_ENTRPRSS (T_GT_PRTNR_ENTRPRSS) Get "Partner enterprises"
T_GT_PSTV_CRRNT_ACCNT (T_GT_PSTV_CRRNT_ACCNT) Get "Positive current accounts"
T_GT_RGSTRY_TBL_SCRTS (T_GT_RGSTRY_TBL_SCRTS) Get "Registry table of securities"
T_GT_RL_ESTT_CLM (T_GT_RL_ESTT_CLM) Get "Real estate claim"
T_GT_RL_ESTT_PRTCTN (T_GT_RL_ESTT_PRTCTN) Get "Real estate protection item"
T_GT_RL_ESTT_PRTCTN_CLM (T_GT_RL_ESTT_PRTCTN_CLM) Get "Real estate protection claim"
T_GT_RVRS_RPRCHS_LNS (T_GT_RVRS_RPRCHS_LNS) Get "Reverse repurchase loans"
T_GT_SCRTSTNS_OTHR_CRDT_TRNSFRS (T_GT_SCRTSTNS_OTHR_CRDT_TRNSFRS) Get "Securitisations and other credit transfers"
T_GT_SCRTS_PRTCTN (T_GT_SCRTS_PRTCTN) Get "Securities protection"
T_GT_TRNSCTNS_CNTRPRTS (T_GT_TRNSCTNS_CNTRPRTS) Get "Transactions-Counterparties"
T_GT_TRNSFRBL_DPSTS (T_GT_TRNSFRBL_DPSTS) Get "Transferable deposits"

1. Setup

T_CSH_RSRV (T_CSH_RSRV) Get cash reserve information for factoring operations

2. Data arrangement

T_CNTRPRTS_E (T_CNTRPRTS_E) Counterparties enriched input layer.
T_CNTRY_E (T_CNTRY_E) Countries reference information enriched input layer
T_CRDT_FCLTS_E (T_CRDT_FCLTS_E) Credit facilities enriched input layer.
T_CRDT_FCLTS_INSTRMNTS_E (T_CRDT_FCLTS_INSTRMNTS_E) Credit facilities instruments enriched input layer.
T_INSTRMNTS_PRTCTNS_E (T_INSTRMNTS_PRTCTNS_E) Instruments protections enriched input layer.
T_JNT_CNTRPRTS_E (T_JNT_CNTRPRTS_E) Joint counterparties enriched input layer
T_LN_E (T_LN_E) Loans enriched input layer.
T_OWND_SCRTY_E (T_OWND_SCRTY_E) Owned security enriched input layer.
T_PRTCTN_RCVD_E (T_PRTCTN_RCVD_E) Protection received enriched input layer
T_PSTV_CRRNT_ACCNT_E (T_PSTV_CRRNT_ACCNT_E) Positive current account enriched input layer..
T_RGSTRY_TBL_SCRTS_E (T_RGSTRY_TBL_SCRTS_E) Registry table of securities enriched input layer
T_RL_ESTT_CLM_E (T_RL_ESTT_CLM_E) Real estate claim enriched input layer.
T_RL_ESTT_PRTCTN_CLM_E (T_RL_ESTT_PRTCTN_CLM_E) Real estate protection claim enriched input layer.
T_RL_ESTT_PRTCTN_E (T_RL_ESTT_PRTCTN_E) Real estate protection enriched input layer.
T_SCRTSTNS_OTHR_CRDT_TRNSFRS_E (T_SCRTSTNS_OTHR_CRDT_TRNSFRS_E) Securitisations and other credit transfers enriched input layer
T_TRNSCTNS_CNTRPRTS_E (T_TRNSCTNS_CNTRPRTS_E) Transaction counterparties enriched input layer.

2. Pre-arrangement validation

V_UNQNSS_LN (V_UNQNSS_LN) Validate uniquess of instrument identifiers
V_UNQNSS_PRTCTN (V_UNQNSS_PRTCTN) Validate uniqueness of protection identifiers

2. Setup

G_ANCRDT_ENTTY_INSTRMNT_DBTR_APPRCH1 (G_ANCRDT_ENTTY_INSTRMNT_DBTR_APPRCH1) Generation of Counterparty-instrument data for joint liabilities approach 1
G_ANCRDT_ENTTY_INSTRMNT_DBTR_APPRCH2 (G_ANCRDT_ENTTY_INSTRMNT_DBTR_APPRCH2) Generation of Counterparty-instrument data for joint liabilities approach 2
G_ANCRDT_JNT_LBLTS_APPRCH1 (G_ANCRDT_JNT_LBLTS_APPRCH1) Generation of "Joint liabilities data - ECB Collection (ANCRDT_JNT_LBLTS_C)" for approach 1
G_ANCRDT_JNT_LBLTS_APPRCH2 (G_ANCRDT_JNT_LBLTS_APPRCH2) Generation of "Joint liabilities data - ECB Collection (ANCRDT_JNT_LBLTS_C)" for approach 2
G_CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS (G_CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS) Generation of unique credit facilities for each instrument.
G_CSH_RSRV_FCTRNG (G_CSH_RSRV_FCTRNG) Generation of cash reserve with respect to AnaCredit
G_ENTTY_INFRMTN (G_ENTTY_INFRMTN) Setup of the dataset Entity information
G_GRP_INFRMTN (G_GRP_INFRMTN) Setup of the dataset Group information
G_IMPLCT_PSTV_CRRNT_ACCNT_AC (G_IMPLCT_PSTV_CRRNT_ACCNT_AC) Derivation of the variables with implict value for Positive current accounts with respect to AnaCredit
G_IS_CMPNNT_LGL_ENTTY (G_IS_CMPNNT_LGL_ENTTY) Generation of a dataset {Instrument unique idnetifier, Is component legel entity}
G_PRPRTN_FCTRNG (G_PRPRTN_FCTRNG) Preparation of factoring operations for generation of cash reserve
G_PRP_LNS (G_PRP_LNS) Preparation of loans and Positive current accounts for AnaCredit
G_PRTCTN_RCVD_AC (G_PRTCTN_RCVD_AC) Preparation of subsets of protection cubes not related to real estate
G_RL_ESTT_PRTCTN_RCVD_AC (G_RL_ESTT_PRTCTN_RCVD_AC) Preparation of subsets of protection cubes related to real estate
G_SCRTY_MSTR_DT (G_SCRTY_MSTR_DT) Setup of the dataset Security master data
G_SHSG4_ENTITY (G_SHSG4_ENTITY) Setup of the dataset Entity information
G_SHSG_GNRL (G_SHSG_GNRL) Setup of generation SHSG information
G_TRNSCTNS_CNTRPRTS (G_TRNSCTNS_CNTRPRTS) Preparation of a dataset containing explicit information about counterparties of transactions

3. Creation

G_ANCRDT_ACCNTNG_C (G_ANCRDT_ACCNTNG_C) Generation of the output cube "Accounting data - ECB Collection (ANCRDT_ACCNTNG_C)"
G_ANCRDT_ENTTY (G_ANCRDT_ENTTY) Generation of the output cube "Counterparty reference data (ANCRDT_ENTTY)"
G_ANCRDT_ENTTY_DFLT_C (G_ANCRDT_ENTTY_DFLT_C) Generation of "Counterparty default data - ECB Collection (ANCRDT_ENTTY_DFLT_C)"
G_ANCRDT_ENTTY_INSTRMNT_C (G_ANCRDT_ENTTY_INSTRMNT_C) Generation of the output cube "Instrument data - ECB Collection (ANCRDT_INSTRMNT_C)"
G_ANCRDT_ENTTY_RSK_C (G_ANCRDT_ENTTY_RSK_C) Generation of "Counterparty risk data - ECB Collection (ANCRDT_ENTTY_RSK_C)"
G_ANCRDT_FNNCL_C (G_ANCRDT_FNNCL_C) Generation of the output cube "Financial data - ECB Collection (ANCRDT_FNNCL_C)"
G_ANCRDT_INSTRMNT_C (G_ANCRDT_INSTRMNT_C) Generation of the output cube "Instrument data - ECB Collection (ANCRDT_INSTRMNT_C)"
G_ANCRDT_INSTRMNT_PRTCTN_RCVD_C (G_ANCRDT_INSTRMNT_PRTCTN_RCVD_C) Generation of the output cube 'Instrument-protection received data - ECB Collection (ANCRDT_INSTRMNT_PRTCTN_RCVD_C)'
G_ANCRDT_JNT_LBLTS_C (G_ANCRDT_JNT_LBLTS_C) Generation of the output cube "Joint liabilities data - ECB Collection (ANCRDT_JNT_LBLTS_C)"
G_ANCRDT_PRTCTN_RCVD_C (G_ANCRDT_PRTCTN_RCVD_C) Generation of the output cube 'Protection received data - ECB Collection (ANCRDT_PRTCTN_RCVD_C)'
G_SHSG4_GROUP (G_SHSG4_GROUP) Generation of the cube SHSG4_GROUP
G_SHSG4_ISIN (G_SHSG4_ISIN) Generation of the cube SHSG4_ISIN
G_SHSG4_NON_ISIN (G_SHSG4_NON_ISIN) Generation of the cube SHSG4_NON_ISIN

3. Implicit information addition

D_IMPLCT_CRDT_CRD_DBT_CNVNNC_CRDT (D_IMPLCT_CRDT_CRD_DBT_CNVNNC_CRDT) Derivation of the variables with implict value for "Credit card debt: convenience credit"
D_IMPLCT_CRDT_CRD_DBT_EXTNDD_CRDT (D_IMPLCT_CRDT_CRD_DBT_EXTNDD_CRDT) Derivation of the variables with implict value for "Credit card debt: extended credit"
D_IMPLCT_FCTRNG (D_IMPLCT_FCTRNG) Derivation of the variables with implict value for "Factoring"
D_IMPLCT_FNNCL_LSS (D_IMPLCT_FNNCL_LSS) Derivation of the variables with implict value for "Financial leases"
D_IMPLCT_INDRCT_FCTRNG (D_IMPLCT_INDRCT_FCTRNG) Derivation of the variables with implict value for "Indirect factoring"
D_IMPLCT_OTHR_DPSTS (D_IMPLCT_OTHR_DPSTS) Derivation of the variables with implict value for "Other deposits"
D_IMPLCT_OTHR_FNNCL_PRTCTN (D_IMPLCT_OTHR_FNNCL_PRTCTN) Derivation of the variables with implict value for "Other financial protection"
D_IMPLCT_OTHR_LNS (D_IMPLCT_OTHR_LNS) Derivation of the variables with implict value for "Other loans"
D_IMPLCT_OTHR_PHYSCL_PRTCTN (D_IMPLCT_OTHR_PHYSCL_PRTCTN) Derivation of the variables with implict value for "Other physical protection"
D_IMPLCT_OTHR_TRD_RCVBLS (D_IMPLCT_OTHR_TRD_RCVBLS) Derivation of the variables with implict value for "Other trade receivables"
D_IMPLCT_OVRDRFTS (D_IMPLCT_OVRDRFTS) Derivation of the variables with implict value for "Overdrafts"
D_IMPLCT_PL_ITM (D_IMPLCT_PL_ITM) Derivation of the variables with implict value for "Pool of (Repo) items"
D_IMPLCT_RVRS_RPRCHS_LNS (D_IMPLCT_RVRS_RPRCHS_LNS) Derivation of the variables with implict value for "Reverse repurchase loans"
D_IMPLCT_SCRTS_PRTCTN (D_IMPLCT_SCRTS_PRTCTN) Derivation of the variables with implict value for "Securities protection"
D_IMPLCT_TRNSFRBL_DPSTS (D_IMPLCT_TRNSFRBL_DPSTS) Derivation of the variables with implict value for "Transferable deposits"
T_UNN_LN (T_UNN_LN) Union of all the cubes related to the "Loans" entity.
T_UNN_PRTCTN_RCVD (T_UNN_PRTCTN_RCVD) Union of all protection cube not related to real estates

3. Write

T_PT_CNTRPRTS_E (T_PT_CNTRPRTS_E) Put "Counterparties - Enriched"
T_PT_CNTRY_E (T_PT_CNTRY_E) Put "Countries reference information - Enriched"
T_PT_CRDT_FCLTS_E (T_PT_CRDT_FCLTS_E) Put "Credit facilities - Enriched"
T_PT_CRDT_FCLTS_INSTRMNTS_E (T_PT_CRDT_FCLTS_INSTRMNTS_E) Put "Credit facilities-instruments - Enriched"
T_PT_INSTRMNTS_PRTCTNS_E (T_PT_INSTRMNTS_PRTCTNS_E) Put "Instruments-protections - Enriched"
T_PT_JNT_CNTRPRTS_E (T_PT_JNT_CNTRPRTS_E) Put "Joint counterparties - Enriched"
T_PT_LN_E (T_PT_LN_E) Put "Loan - Enriched"
T_PT_OWND_SCRTY_E (T_PT_OWND_SCRTY_E) Put "Owned security - Enriched"
T_PT_PRTCTN_RCVD_E (T_PT_PRTCTN_RCVD_E) Put "Protection received - Enriched"
T_PT_PSTV_CRRNT_ACCNT_E (T_PT_PSTV_CRRNT_ACCNT_E) Put "Positive current accounts - Enriched"
T_PT_RGSTRY_TBL_SCRTS_E (T_PT_RGSTRY_TBL_SCRTS_E) Put "Registry table of securities - Enriched"
T_PT_RL_ESTT_CLM_E (T_PT_RL_ESTT_CLM_E) Put "Real estate claim - Enriched"
T_PT_RL_ESTT_PRTCTN_CLM_E (T_PT_RL_ESTT_PRTCTN_CLM_E) Put "Real estate protection-Real estate claim - Enriched"
T_PT_RL_ESTT_PRTCTN_E (T_PT_RL_ESTT_PRTCTN_E) Put "Real estate protection - Enriched"
T_PT_SCRTSTNS_OTHR_CRDT_TRNSFRS_E (T_PT_SCRTSTNS_OTHR_CRDT_TRNSFRS_E) Put "Securitisations and other credit transfers - Enriched"
T_PT_TRNSCTNS_CNTRPRTS_E (T_PT_TRNSCTNS_CNTRPRTS_E) Put "Transactions-Counterparties - Enriched"

4. Input data validation

V_ACCMLTD_CHNGS_FV_CR1 (V_ACCMLTD_CHNGS_FV_CR1) Consistency check of "Accounting classification" and "Accumulated changes in fair value due to credit risk"
V_ACCMLTD_CHNGS_FV_CR2 (V_ACCMLTD_CHNGS_FV_CR2) Consistency check of "Accounting classification" and "Accumulated changes in fair value due to credit risk"
V_ACCMLTD_IMPRMNT1 (V_ACCMLTD_IMPRMNT1) Consistency check of "Accounting classification" and "Accumulated impairment"
V_ACCMLTD_IMPRMNT2 (V_ACCMLTD_IMPRMNT2) Consistency check of "Accounting classification" and "Accumulated impairment"
V_ACCNTNG_CLSSFCTN1 (V_ACCNTNG_CLSSFCTN1) Consistency check of "Accounting framework for solo reporting" and "Accounting classification"
V_BLNC_SHT_TTL2 (V_BLNC_SHT_TTL2) Presence of "Balance sheet total" or "Annual turnover" in Partner enterprises cube
V_BLNC_SHT_TTL3 (V_BLNC_SHT_TTL3) Presence of "Balance sheet total" or "Annual turnover" in Linked enterprises cube
V_BLNC_SHT_TTL4 (V_BLNC_SHT_TTL4) Presence of "Balance sheet total" or "Annual turnover" in Group data cube
V_CNTRPRTS_CDS_ID (V_CNTRPRTS_CDS_ID) Validates referential integrity of counterparty codes referring to counterparties.
V_CNTRPRTS_PD_ID (V_CNTRPRTS_PD_ID) Validates referential integrity of Probability of default of the counterparty to counterparties.
V_CNTRPRTY_ID1 (V_CNTRPRTY_ID1) Check if counterparties classified as "Head office undertaking" are included as counterparties
V_CNTRPRTY_ID2 (V_CNTRPRTY_ID2) Check if counterparties classified as "Ultimate parent undertaking" are included as counterparties
V_CNTRPRTY_ID3 (V_CNTRPRTY_ID3) Check if counterparties classified as "Immediate parent undertaking" are included as counterparties
V_CNTRPRTY_RL1 (V_CNTRPRTY_RL1) Validation whether every instrument has a debtor
V_CNTRY1 (V_CNTRY1) Consistency check of "Country of residence" and "Territorial unit"
V_CRDT_FCLTS_INSTRMNTS_ID1 (V_CRDT_FCLTS_INSTRMNTS_ID1) Validates that credit facilities are referred in the credit facilities instrument cube.
V_CRDT_FCLTS_INSTRMNTS_ID2 (V_CRDT_FCLTS_INSTRMNTS_ID2) Validates referential integrity of credit facilities instrument to credit facilities.
V_DT_END_INTRST_ONLY1 (V_DT_END_INTRST_ONLY1) Consistency check of "End date of interest-only period" and "Inception date"
V_DT_END_INTRST_ONLY2 (V_DT_END_INTRST_ONLY2) Consistency check of "End date of the interest-only period" and "Settlement date"
V_DT_ENTRPRS_SZ1 (V_DT_ENTRPRS_SZ1) Consistency check of "Date of enterprise size" and "Reference date"
V_DT_INCPTN1 (V_DT_INCPTN1) Consistency check of "Next interest rate reset date" and "Inception date"
V_DT_INTTN_LGL_PRCDNGS1 (V_DT_INTTN_LGL_PRCDNGS1) Consistency check of "Date of initiation of legal proceedings" and "Reference date"
V_DT_LGL_FNL_MTRTY1 (V_DT_LGL_FNL_MTRTY1) Consistency check of "Legal final maturity date" and "Inception date"
V_DT_LGL_FNL_MTRTY2 (V_DT_LGL_FNL_MTRTY2) Consistency check of "Legal final maturity date" and "Settlement date"
V_DT_LGL_FNL_MTRTY3 (V_DT_LGL_FNL_MTRTY3) Consistency check of "Legal final maturity date" and "End date of interest-only period"
V_DT_LGL_FNL_MTRTY4 (V_DT_LGL_FNL_MTRTY4) Consistency check of "Legal final maturity date" and "Next interest rate reset date"
V_DT_NXT_INTRST_RT_RST1 (V_DT_NXT_INTRST_RT_RST1) Consistency check of "Next interest rate reset date" and "Settlement date"
V_DT_STTLMNT1 (V_DT_STTLMNT1) Consistency check of "Settlement date" and "Inception date"
V_ENTRPRS_SZ_PRVS_PRD_ID (V_ENTRPRS_SZ_PRVS_PRD_ID) Validates referential integrity of enterprise size (previous period) referring to counterparties.
V_FV1 (V_FV1) Consistency check of "Fair value" and "Accounting classification"
V_FV_CHNG_HDG_ACCNTNG1 (V_FV_CHNG_HDG_ACCNTNG1) Consistency check of "Accounting classification" and "Fair value changes due to hedge accounting"
V_GRP_CNTRPRTY_ID (V_GRP_CNTRPRTY_ID) Validates referential integrity of group counterparty relationship referring to counterparties.
V_GRP_INTRNL_ID1 (V_GRP_INTRNL_ID1) Referencial integrity check for "Group internal identifier"
V_GRP_INTRNL_ID2 (V_GRP_INTRNL_ID2) Validates that group data are referred in the group counterparty relationship cube.
V_GRSS_CRRYNG_AMNT_E_INTRST1 (V_GRSS_CRRYNG_AMNT_E_INTRST1) Consistency check of "Accounting classification" and "Gross carrying amount excluding accrued interst"
V_IMPRMNT_ASSSSMNT_MTHD1 (V_IMPRMNT_ASSSSMNT_MTHD1) Consistency check of "Impairment assessment method" and "Accounting classification"
V_IMPRMNT_ASSSSMNT_MTHD2 (V_IMPRMNT_ASSSSMNT_MTHD2) Consistency check of "Impairment assessment method" and "Accounting classification"
V_IMPRMNT_STTS1 (V_IMPRMNT_STTS1) Consistency check of "Impariment status" and "Accounting classification"
V_IMPRMNT_STTS2 (V_IMPRMNT_STTS2) Consistency check of "Impairment status" and "Accounting framework for solo reporting"
V_IMPRMNT_STTS3 (V_IMPRMNT_STTS3) Consistency check of "Impariment status" and "Accounting classification"
V_INSTRMNTS_PRTCTNS_ID1 (V_INSTRMNTS_PRTCTNS_ID1) Validates that instruments protections are referred to real estate claim.
V_INSTRMNTS_PRTCTNS_ID2 (V_INSTRMNTS_PRTCTNS_ID2) Validates referential integrity of real estate claim to instruments protections.
V_INSTTTNL_SCTR1 (V_INSTTTNL_SCTR1) Consistency check of "Institutional sector" and "Economic activity"
V_INTRST_RT_CP1 (V_INTRST_RT_CP1) Consictency check of "Interest rate cap" and "Interest rate"
V_INTRST_RT_FLR1 (V_INTRST_RT_FLR1) Consistency check of "Interest rate floor" and "Interest rate"
V_IS_CRRYNG_AMNT_DRVD1 (V_IS_CRRYNG_AMNT_DRVD1) Validation whether "Carrying amount" is not applicable for banks using NGAAPs
V_JNT_CNTRPRTS_ID (V_JNT_CNTRPRTS_ID) Validates referential integrity of joint counterparties referring to counterparties.
V_JNT_CNTRPRTS_ID2 (V_JNT_CNTRPRTS_ID2) Validates referential integrity of joint counterparties components referring to counterparties.
V_JNT_LBLTY_AMNT1 (V_JNT_LBLTY_AMNT1) Consistency check of "Outstanding nominal amount" with respect to the "Joint liability amount"
V_LGL_PRCDNG_STTS1 (V_LGL_PRCDNG_STTS1) Consistency check of "Legal proceeding status" and "Date of initiation of legal proceedings"
V_LNKD_ENTRPRSS_ID (V_LNKD_ENTRPRSS_ID) Validates referential integrity of linked enterprises referring to counterparties.
V_LN_CRDT_FCLTS_INSTRMNT (V_LN_CRDT_FCLTS_INSTRMNT) Validates referential integrity of credit facilities-instruments to loans
V_LN_INSTRMNT_PRTCTNS_ID (V_LN_INSTRMNT_PRTCTNS_ID) Validates that loans are referred in the instruments-protections cube.
V_NMBR_EMPLYS1 (V_NMBR_EMPLYS1) Presence of "Number of employees"
V_PRCNTG_INTRST_CPTL_VTNG_RGHTS1 (V_PRCNTG_INTRST_CPTL_VTNG_RGHTS1) Validates whether "Percentage interest in the capital or voting rights" >= 25%
V_PRDNTL_PRTFL1 (V_PRDNTL_PRTFL1) Validates whether for IFRS institutions, instruments classified in the prudential trading book are classified as held for trading Consistency check of "Accounting classification" and "Prudential portfolio"
V_PRTCTN_ID1 (V_PRTCTN_ID1) Consistency check of instruments representing financial leases regarding the presence of the leasing good (as a protection)
V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID1 (V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID1) Validates that protection received is referred in the instruments-protections cube.
V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID2 (V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID2) Validates referential integrity of instruments-protections to loans.
V_PRTNR_ENTRPRSS_ID (V_PRTNR_ENTRPRSS_ID) Validates referential integrity of partner enterprises referring to counterparties.
V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID1 (V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID1) Validates that positive current accounts are referred in the credit facilities instruments cube.
V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID2 (V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID2) Validates referential integrity of credit facilities instruments to positive current accounts.
V_PSTV_CURR_ACCNT_ID1 (V_PSTV_CURR_ACCNT_ID1) Validates that positive current accounts are referred in the transations-counterparties cube.
V_PSTV_CURR_ACCNT_ID2 (V_PSTV_CURR_ACCNT_ID2) Validates referential integrity of transactions-counterparties to positive current accounts.
V_PYMNT_FRQNCY1 (V_PYMNT_FRQNCY1) Consistency check of "Payment frequency" and "Type of amortisation"
V_RGSTRY_TBL_SCRTS_CNTRPRTS_ID (V_RGSTRY_TBL_SCRTS_CNTRPRTS_ID) Validates referential integrity of registry table securities to counterparties.
V_RGSTRY_TBL_SCRTS_ID (V_RGSTRY_TBL_SCRTS_ID) Validates referential integrity of owned security to registry table securities.
V_RL_ESTT_PRTCTN_CLM_ID (V_RL_ESTT_PRTCTN_CLM_ID) Validates that real estate protection claim is referred in the real estate protection claim item cube.
V_RL_ESTT_PRTCTN_CLM_ID2 (V_RL_ESTT_PRTCTN_CLM_ID2) Validates referential integrity of real estate protection claim to real estate claim cube.
V_RL_ESTT_PRTCTN_ID (V_RL_ESTT_PRTCTN_ID) Validates that real estate protection is referred in the real estate protection claim item cube.
V_RL_ESTT_PRTCTN_ID2 (V_RL_ESTT_PRTCTN_ID2) Validates referential integrity of real estate protection claim to real estate protection cube.
V_SCRTSTNS_OTHR_CRDT_TRNSFR_LN_ID (V_SCRTSTNS_OTHR_CRDT_TRNSFR_LN_ID) Validates referential integrity of loans to securitisations and other credit transfers.
V_SCRTSTN_TRNSFR_ID1 (V_SCRTSTN_TRNSFR_ID1) Validates whether for each traditional securitisation there is an originator
V_SCRTSTN_TRNSFR_ID2 (V_SCRTSTN_TRNSFR_ID2) Validates whether for each traditional securitisation there is a transferee
V_SCRTS_PRTCTN_ID (V_SCRTS_PRTCTN_ID) Validates referential integrity of securities protection to protections received.
V_SCRTY_ID (V_SCRTY_ID) Validates referential integrity of securities protection referring to registry table securities.
V_TRNSCTNS_CNTRPRTS_ID (V_TRNSCTNS_CNTRPRTS_ID) Validates referential integrity of transaction counterparties referring to counterparties.
V_TRNSCTN_ID1 (V_TRNSCTN_ID1) Validates whether loans are referred in the "Transactions-counterparties" cube
V_TRNSCTN_ID3 (V_TRNSCTN_ID3) Validates whether credit facilities are referred in the "Transactions-counterparties" cube
V_TRNSCTN_ID4 (V_TRNSCTN_ID4) Validates whether securitisations and other credit transfers are referred in the "Transactions-counterparties" cube
V_TRNSCTN_ID5 (V_TRNSCTN_ID5) Validates referential integrity of Transactions-counterparties referring to loans.
V_TRNSCTN_ID6 (V_TRNSCTN_ID6) Validates referential integrity of transactions-counterparties referring to protections.
V_TRNSCTN_ID7 (V_TRNSCTN_ID7) Validates referential integrity of transactions-counetparties referring to credit facilities.
V_TRNSCTN_ID8 (V_TRNSCTN_ID8) Validates referential integrity of transactions-counetparties referring to securitisations and other credit transfers.
V_TYP_INTRST_RT2 (V_TYP_INTRST_RT2) Consistency check of the variables "Reference rate" and "Type of interest rate"
V_TYP_PRTCTN_VL1 (V_TYP_PRTCTN_VL1) Consistency check of the variables "Type of protection value" and "Type of protection" for real estate protection

Anacredit

G_ANCRDT_ACCNTNG_C (G_ANCRDT_ACCNTNG_C) Generation of the output cube "Accounting data - ECB Collection (ANCRDT_ACCNTNG_C)"
G_ANCRDT_ENTTY (G_ANCRDT_ENTTY) Generation of the output cube "Counterparty reference data (ANCRDT_ENTTY)"
G_ANCRDT_ENTTY_DFLT_C (G_ANCRDT_ENTTY_DFLT_C) Generation of "Counterparty default data - ECB Collection (ANCRDT_ENTTY_DFLT_C)"
G_ANCRDT_ENTTY_INSTRMNT_C (G_ANCRDT_ENTTY_INSTRMNT_C) Generation of the output cube "Instrument data - ECB Collection (ANCRDT_INSTRMNT_C)"
G_ANCRDT_ENTTY_INSTRMNT_DBTR_APPRCH1 (G_ANCRDT_ENTTY_INSTRMNT_DBTR_APPRCH1) Generation of Counterparty-instrument data for joint liabilities approach 1
G_ANCRDT_ENTTY_INSTRMNT_DBTR_APPRCH2 (G_ANCRDT_ENTTY_INSTRMNT_DBTR_APPRCH2) Generation of Counterparty-instrument data for joint liabilities approach 2
G_ANCRDT_ENTTY_RSK_C (G_ANCRDT_ENTTY_RSK_C) Generation of "Counterparty risk data - ECB Collection (ANCRDT_ENTTY_RSK_C)"
G_ANCRDT_FNNCL_C (G_ANCRDT_FNNCL_C) Generation of the output cube "Financial data - ECB Collection (ANCRDT_FNNCL_C)"
G_ANCRDT_INSTRMNT_C (G_ANCRDT_INSTRMNT_C) Generation of the output cube "Instrument data - ECB Collection (ANCRDT_INSTRMNT_C)"
G_ANCRDT_INSTRMNT_PRTCTN_RCVD_C (G_ANCRDT_INSTRMNT_PRTCTN_RCVD_C) Generation of the output cube 'Instrument-protection received data - ECB Collection (ANCRDT_INSTRMNT_PRTCTN_RCVD_C)'
G_ANCRDT_JNT_LBLTS_APPRCH1 (G_ANCRDT_JNT_LBLTS_APPRCH1) Generation of "Joint liabilities data - ECB Collection (ANCRDT_JNT_LBLTS_C)" for approach 1
G_ANCRDT_JNT_LBLTS_APPRCH2 (G_ANCRDT_JNT_LBLTS_APPRCH2) Generation of "Joint liabilities data - ECB Collection (ANCRDT_JNT_LBLTS_C)" for approach 2
G_ANCRDT_JNT_LBLTS_C (G_ANCRDT_JNT_LBLTS_C) Generation of the output cube "Joint liabilities data - ECB Collection (ANCRDT_JNT_LBLTS_C)"
G_ANCRDT_PRTCTN_RCVD_C (G_ANCRDT_PRTCTN_RCVD_C) Generation of the output cube 'Protection received data - ECB Collection (ANCRDT_PRTCTN_RCVD_C)'
G_CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS (G_CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS) Generation of unique credit facilities for each instrument.
G_CSH_RSRV_FCTRNG (G_CSH_RSRV_FCTRNG) Generation of cash reserve with respect to AnaCredit
G_IMPLCT_PSTV_CRRNT_ACCNT_AC (G_IMPLCT_PSTV_CRRNT_ACCNT_AC) Derivation of the variables with implict value for Positive current accounts with respect to AnaCredit
G_IS_CMPNNT_LGL_ENTTY (G_IS_CMPNNT_LGL_ENTTY) Generation of a dataset {Instrument unique idnetifier, Is component legel entity}
G_PRPRTN_FCTRNG (G_PRPRTN_FCTRNG) Preparation of factoring operations for generation of cash reserve
G_PRP_LNS (G_PRP_LNS) Preparation of loans and Positive current accounts for AnaCredit
G_PRTCTN_RCVD_AC (G_PRTCTN_RCVD_AC) Preparation of subsets of protection cubes not related to real estate
G_RL_ESTT_PRTCTN_RCVD_AC (G_RL_ESTT_PRTCTN_RCVD_AC) Preparation of subsets of protection cubes related to real estate
G_TRNSCTNS_CNTRPRTS (G_TRNSCTNS_CNTRPRTS) Preparation of a dataset containing explicit information about counterparties of transactions
T_CSH_RSRV (T_CSH_RSRV) Get cash reserve information for factoring operations

Business

D_CRRYNG_AMNT1 (D_CRRYNG_AMNT1) Derivation of "Carrying amount" for IFRS related "Accounting classificiations" (loans cube)
D_CRRYNG_AMNT2 (D_CRRYNG_AMNT2) Derivation of "Carrying amount" for IFRS related "Accounting classificiations" (instruments cube)
D_ENTRPRS_SZ_CLCLTD1 (D_ENTRPRS_SZ_CLCLTD1) Derivation of “Enterprise size”
D_EXPSR_CLSS_AND_RSK_WGHT (D_EXPSR_CLSS_AND_RSK_WGHT) Preparation of dataset containing Risk weight and Exposure class

Completeness

V_BLNC_SHT_TTL2 (V_BLNC_SHT_TTL2) Presence of "Balance sheet total" or "Annual turnover" in Partner enterprises cube
V_BLNC_SHT_TTL3 (V_BLNC_SHT_TTL3) Presence of "Balance sheet total" or "Annual turnover" in Linked enterprises cube
V_BLNC_SHT_TTL4 (V_BLNC_SHT_TTL4) Presence of "Balance sheet total" or "Annual turnover" in Group data cube
V_CNTRPRTY_RL1 (V_CNTRPRTY_RL1) Validation whether every instrument has a debtor
V_PRTCTN_ID1 (V_PRTCTN_ID1) Consistency check of instruments representing financial leases regarding the presence of the leasing good (as a protection)
V_SCRTSTN_TRNSFR_ID1 (V_SCRTSTN_TRNSFR_ID1) Validates whether for each traditional securitisation there is an originator
V_SCRTSTN_TRNSFR_ID2 (V_SCRTSTN_TRNSFR_ID2) Validates whether for each traditional securitisation there is a transferee

Consistency

V_ACCMLTD_CHNGS_FV_CR1 (V_ACCMLTD_CHNGS_FV_CR1) Consistency check of "Accounting classification" and "Accumulated changes in fair value due to credit risk"
V_ACCMLTD_CHNGS_FV_CR2 (V_ACCMLTD_CHNGS_FV_CR2) Consistency check of "Accounting classification" and "Accumulated changes in fair value due to credit risk"
V_ACCMLTD_IMPRMNT1 (V_ACCMLTD_IMPRMNT1) Consistency check of "Accounting classification" and "Accumulated impairment"
V_ACCMLTD_IMPRMNT2 (V_ACCMLTD_IMPRMNT2) Consistency check of "Accounting classification" and "Accumulated impairment"
V_ACCNTNG_CLSSFCTN1 (V_ACCNTNG_CLSSFCTN1) Consistency check of "Accounting framework for solo reporting" and "Accounting classification"
V_CNTRY1 (V_CNTRY1) Consistency check of "Country of residence" and "Territorial unit"
V_DT_END_INTRST_ONLY1 (V_DT_END_INTRST_ONLY1) Consistency check of "End date of interest-only period" and "Inception date"
V_DT_END_INTRST_ONLY2 (V_DT_END_INTRST_ONLY2) Consistency check of "End date of the interest-only period" and "Settlement date"
V_DT_ENTRPRS_SZ1 (V_DT_ENTRPRS_SZ1) Consistency check of "Date of enterprise size" and "Reference date"
V_DT_INCPTN1 (V_DT_INCPTN1) Consistency check of "Next interest rate reset date" and "Inception date"
V_DT_INTTN_LGL_PRCDNGS1 (V_DT_INTTN_LGL_PRCDNGS1) Consistency check of "Date of initiation of legal proceedings" and "Reference date"
V_DT_LGL_FNL_MTRTY1 (V_DT_LGL_FNL_MTRTY1) Consistency check of "Legal final maturity date" and "Inception date"
V_DT_LGL_FNL_MTRTY2 (V_DT_LGL_FNL_MTRTY2) Consistency check of "Legal final maturity date" and "Settlement date"
V_DT_LGL_FNL_MTRTY3 (V_DT_LGL_FNL_MTRTY3) Consistency check of "Legal final maturity date" and "End date of interest-only period"
V_DT_LGL_FNL_MTRTY4 (V_DT_LGL_FNL_MTRTY4) Consistency check of "Legal final maturity date" and "Next interest rate reset date"
V_DT_NXT_INTRST_RT_RST1 (V_DT_NXT_INTRST_RT_RST1) Consistency check of "Next interest rate reset date" and "Settlement date"
V_DT_STTLMNT1 (V_DT_STTLMNT1) Consistency check of "Settlement date" and "Inception date"
V_FV1 (V_FV1) Consistency check of "Fair value" and "Accounting classification"
V_FV_CHNG_HDG_ACCNTNG1 (V_FV_CHNG_HDG_ACCNTNG1) Consistency check of "Accounting classification" and "Fair value changes due to hedge accounting"
V_GRSS_CRRYNG_AMNT_E_INTRST1 (V_GRSS_CRRYNG_AMNT_E_INTRST1) Consistency check of "Accounting classification" and "Gross carrying amount excluding accrued interst"
V_IMPRMNT_ASSSSMNT_MTHD1 (V_IMPRMNT_ASSSSMNT_MTHD1) Consistency check of "Impairment assessment method" and "Accounting classification"
V_IMPRMNT_ASSSSMNT_MTHD2 (V_IMPRMNT_ASSSSMNT_MTHD2) Consistency check of "Impairment assessment method" and "Accounting classification"
V_IMPRMNT_STTS1 (V_IMPRMNT_STTS1) Consistency check of "Impariment status" and "Accounting classification"
V_IMPRMNT_STTS2 (V_IMPRMNT_STTS2) Consistency check of "Impairment status" and "Accounting framework for solo reporting"
V_IMPRMNT_STTS3 (V_IMPRMNT_STTS3) Consistency check of "Impariment status" and "Accounting classification"
V_INSTTTNL_SCTR1 (V_INSTTTNL_SCTR1) Consistency check of "Institutional sector" and "Economic activity"
V_INTRST_RT_CP1 (V_INTRST_RT_CP1) Consictency check of "Interest rate cap" and "Interest rate"
V_INTRST_RT_FLR1 (V_INTRST_RT_FLR1) Consistency check of "Interest rate floor" and "Interest rate"
V_IS_CRRYNG_AMNT_DRVD1 (V_IS_CRRYNG_AMNT_DRVD1) Validation whether "Carrying amount" is not applicable for banks using NGAAPs
V_JNT_LBLTY_AMNT1 (V_JNT_LBLTY_AMNT1) Consistency check of "Outstanding nominal amount" with respect to the "Joint liability amount"
V_LGL_PRCDNG_STTS1 (V_LGL_PRCDNG_STTS1) Consistency check of "Legal proceeding status" and "Date of initiation of legal proceedings"
V_NMBR_EMPLYS1 (V_NMBR_EMPLYS1) Presence of "Number of employees"
V_PRCNTG_INTRST_CPTL_VTNG_RGHTS1 (V_PRCNTG_INTRST_CPTL_VTNG_RGHTS1) Validates whether "Percentage interest in the capital or voting rights" >= 25%
V_PRDNTL_PRTFL1 (V_PRDNTL_PRTFL1) Validates whether for IFRS institutions, instruments classified in the prudential trading book are classified as held for trading Consistency check of "Accounting classification" and "Prudential portfolio"
V_PYMNT_FRQNCY1 (V_PYMNT_FRQNCY1) Consistency check of "Payment frequency" and "Type of amortisation"
V_TYP_INTRST_RT2 (V_TYP_INTRST_RT2) Consistency check of the variables "Reference rate" and "Type of interest rate"
V_TYP_PRTCTN_VL1 (V_TYP_PRTCTN_VL1) Consistency check of the variables "Type of protection value" and "Type of protection" for real estate protection

Functions

D_ASSGN_CRDT_QLTY_STP_BIRD (D_ASSGN_CRDT_QLTY_STP_BIRD)
D_ASSGN_EXPSR_CLSS1 (D_ASSGN_EXPSR_CLSS1)
D_CLCLT_RSK_WGHT (D_CLCLT_RSK_WGHT)
D_CRRYNG_AMNT (D_CRRYNG_AMNT)
D_EXPSR_CNTR_GVRNMNTS1 (D_EXPSR_CNTR_GVRNMNTS1)
D_IS_EXPSR_CLSS_APPLCBL1 (D_IS_EXPSR_CLSS_APPLCBL1)
D_IS_LE_3MNTH (D_IS_LE_3MNTH)
D_LGL_FNL_MTRTY1 (D_LGL_FNL_MTRTY1)
D_NMBR_OF_DYS (D_NMBR_OF_DYS)
G_ACCNTNG_FRMWK_SL (G_ACCNTNG_FRMWK_SL)
G_CMMTMNT_INCPTN1 (G_CMMTMNT_INCPTN1)
G_DFLT_STTS1 (G_DFLT_STTS1)
G_DFLT_STTS_CNTRPRTY1 (G_DFLT_STTS_CNTRPRTY1)
G_DT_DFLT_STTS1 (G_DT_DFLT_STTS1)
G_DT_DFLT_STTS_CNTRPRTY1 (G_DT_DFLT_STTS_CNTRPRTY1)
G_DT_DFLT_STTS_INSTRMNT1 (G_DT_DFLT_STTS_INSTRMNT1)
G_DT_INCPTN1 (G_DT_INCPTN1)
G_DT_LGL_FNL_MTRTY1 (G_DT_LGL_FNL_MTRTY1)
G_DT_PRFRMNG_STTS (G_DT_PRFRMNG_STTS)
G_ENTITY_AREA1 (G_ENTITY_AREA1)
G_ENTTY_ID_CRTR (G_ENTTY_ID_CRTR)
G_ENTTY_ID_SRVCR (G_ENTTY_ID_SRVCR)
G_INSTR_CLASS1 (G_INSTR_CLASS1)
G_INSTTTNL_SCTR (G_INSTTTNL_SCTR)
G_INTRA_GROUP_ACC_SCOPE (G_INTRA_GROUP_ACC_SCOPE)
G_INTRA_GROUP_PRUD_SCOPE (G_INTRA_GROUP_PRUD_SCOPE)
G_ISSUER_SECTOR1 (G_ISSUER_SECTOR1)
G_LGD_DWNTRNS1 (G_LGD_DWNTRNS1)
G_LGD_NRML1 (G_LGD_NRML1)
G_OBSRVD_AGNT_ID1 (G_OBSRVD_AGNT_ID1)
G_PD1 (G_PD1)
G_PD2 (G_PD2)
G_PRFRMNG_STTS1 (G_PRFRMNG_STTS1)
G_PRFRMNG_STTS2 (G_PRFRMNG_STTS2)
G_PRPS1 (G_PRPS1)
G_RCGNTN_STTS1 (G_RCGNTN_STTS1)
G_SENIORITY_TYPE (G_SENIORITY_TYPE)
G_TRNSFRRD_AMNT1 (G_TRNSFRRD_AMNT1)
G_TYP_INSTRMNT1 (G_TYP_INSTRMNT1)
G_TYP_SCRTSTN1 (G_TYP_SCRTSTN1)
M_ENTITY_SECTOR (M_ENTITY_SECTOR)
M_GROUP_TYPE (M_GROUP_TYPE)
M_ISSUER_NACE_SECTOR (M_ISSUER_NACE_SECTOR)

Get

T_GT_CMPSTN_LGL_ENTTY (T_GT_CMPSTN_LGL_ENTTY) Get "Composition of legal entity"
T_GT_CNTRPRTS (T_GT_CNTRPRTS) Get "Counterparties"
T_GT_CNTRPRTS_CDS (T_GT_CNTRPRTS_CDS) Get "Counterparty codes"
T_GT_CNTRPRTS_PD (T_GT_CNTRPRTS_PD) Get "Probability of default of the counterparty "
T_GT_CNTRY (T_GT_CNTRY) Get "Countries"
T_GT_CRDT_CRD_DBT_CNVNNC_CRDT (T_GT_CRDT_CRD_DBT_CNVNNC_CRDT) Get "Credit card debt: convenience credit"
T_GT_CRDT_CRD_DBT_EXTNDD_CRDT (T_GT_CRDT_CRD_DBT_EXTNDD_CRDT) Get "Credit card debt: extended credit"
T_GT_CRDT_FCLTS (T_GT_CRDT_FCLTS) Get "Credit facilities"
T_GT_CRDT_FCLTS_INSTRMNTS (T_GT_CRDT_FCLTS_INSTRMNTS) Get "Credit facilities-Instruments"
T_GT_ENTRPRS_SZ_PRVS_PRD (T_GT_ENTRPRS_SZ_PRVS_PRD) Get "Enterprise size (previous period)"
T_GT_EXTRNL_CRDT_ASSSSMNT (T_GT_EXTRNL_CRDT_ASSSSMNT) Get "External credit assessments"
T_GT_FCTRNG (T_GT_FCTRNG) Get "Factoring"
T_GT_FNNCL_LSS (T_GT_FNNCL_LSS) Get "Financial leases"
T_GT_GRP (T_GT_GRP) Get "Group"
T_GT_GRP_CNTRPRTY_RLTNSHP (T_GT_GRP_CNTRPRTY_RLTNSHP) Get "Group counterparty relationship"
T_GT_GRP_DT (T_GT_GRP_DT) Get "Group data"
T_GT_INDRCT_FCTRNG (T_GT_INDRCT_FCTRNG) Get "Indirect factoring"
T_GT_INSTRMNTS_PRTCTNS (T_GT_INSTRMNTS_PRTCTNS) Get "Instruments-protections"
T_GT_JNT_CNTRPRTS (T_GT_JNT_CNTRPRTS) Get "Joint counterparties"
T_GT_LNKD_ENTRPRSS (T_GT_LNKD_ENTRPRSS) Get "Linked enterprises"
T_GT_OTHR_DPSTS (T_GT_OTHR_DPSTS) Get "Other deposits"
T_GT_OTHR_FNNCL_PRTCTN (T_GT_OTHR_FNNCL_PRTCTN) Get "Other financial protection"
T_GT_OTHR_LNS (T_GT_OTHR_LNS) Get "Other loans"
T_GT_OTHR_PHYSCL_PRTCTN (T_GT_OTHR_PHYSCL_PRTCTN) Get "Other physical protection"
T_GT_OTHR_TRD_RCVBLS (T_GT_OTHR_TRD_RCVBLS) Get "Other trade receivables"
T_GT_OVRDRFTS (T_GT_OVRDRFTS) Get "Overdrafts"
T_GT_OWND_SCRTY (T_GT_OWND_SCRTY) Get "Owned securities"
T_GT_PL_ITM (T_GT_PL_ITM) Get "Pool of (repo) items"
T_GT_PRMTR (T_GT_PRMTR) Get "Parameters"
T_GT_PRTNR_ENTRPRSS (T_GT_PRTNR_ENTRPRSS) Get "Partner enterprises"
T_GT_PSTV_CRRNT_ACCNT (T_GT_PSTV_CRRNT_ACCNT) Get "Positive current accounts"
T_GT_RGSTRY_TBL_SCRTS (T_GT_RGSTRY_TBL_SCRTS) Get "Registry table of securities"
T_GT_RL_ESTT_CLM (T_GT_RL_ESTT_CLM) Get "Real estate claim"
T_GT_RL_ESTT_PRTCTN (T_GT_RL_ESTT_PRTCTN) Get "Real estate protection item"
T_GT_RL_ESTT_PRTCTN_CLM (T_GT_RL_ESTT_PRTCTN_CLM) Get "Real estate protection claim"
T_GT_RVRS_RPRCHS_LNS (T_GT_RVRS_RPRCHS_LNS) Get "Reverse repurchase loans"
T_GT_SCRTSTNS_OTHR_CRDT_TRNSFRS (T_GT_SCRTSTNS_OTHR_CRDT_TRNSFRS) Get "Securitisations and other credit transfers"
T_GT_SCRTS_PRTCTN (T_GT_SCRTS_PRTCTN) Get "Securities protection"
T_GT_TRNSCTNS_CNTRPRTS (T_GT_TRNSCTNS_CNTRPRTS) Get "Transactions-Counterparties"
T_GT_TRNSFRBL_DPSTS (T_GT_TRNSFRBL_DPSTS) Get "Transferable deposits"

Implicit

D_IMPLCT_CRDT_CRD_DBT_CNVNNC_CRDT (D_IMPLCT_CRDT_CRD_DBT_CNVNNC_CRDT) Derivation of the variables with implict value for "Credit card debt: convenience credit"
D_IMPLCT_CRDT_CRD_DBT_EXTNDD_CRDT (D_IMPLCT_CRDT_CRD_DBT_EXTNDD_CRDT) Derivation of the variables with implict value for "Credit card debt: extended credit"
D_IMPLCT_FCTRNG (D_IMPLCT_FCTRNG) Derivation of the variables with implict value for "Factoring"
D_IMPLCT_FNNCL_LSS (D_IMPLCT_FNNCL_LSS) Derivation of the variables with implict value for "Financial leases"
D_IMPLCT_INDRCT_FCTRNG (D_IMPLCT_INDRCT_FCTRNG) Derivation of the variables with implict value for "Indirect factoring"
D_IMPLCT_OTHR_DPSTS (D_IMPLCT_OTHR_DPSTS) Derivation of the variables with implict value for "Other deposits"
D_IMPLCT_OTHR_FNNCL_PRTCTN (D_IMPLCT_OTHR_FNNCL_PRTCTN) Derivation of the variables with implict value for "Other financial protection"
D_IMPLCT_OTHR_LNS (D_IMPLCT_OTHR_LNS) Derivation of the variables with implict value for "Other loans"
D_IMPLCT_OTHR_PHYSCL_PRTCTN (D_IMPLCT_OTHR_PHYSCL_PRTCTN) Derivation of the variables with implict value for "Other physical protection"
D_IMPLCT_OTHR_TRD_RCVBLS (D_IMPLCT_OTHR_TRD_RCVBLS) Derivation of the variables with implict value for "Other trade receivables"
D_IMPLCT_OVRDRFTS (D_IMPLCT_OVRDRFTS) Derivation of the variables with implict value for "Overdrafts"
D_IMPLCT_PL_ITM (D_IMPLCT_PL_ITM) Derivation of the variables with implict value for "Pool of (Repo) items"
D_IMPLCT_RVRS_RPRCHS_LNS (D_IMPLCT_RVRS_RPRCHS_LNS) Derivation of the variables with implict value for "Reverse repurchase loans"
D_IMPLCT_SCRTS_PRTCTN (D_IMPLCT_SCRTS_PRTCTN) Derivation of the variables with implict value for "Securities protection"
D_IMPLCT_TRNSFRBL_DPSTS (D_IMPLCT_TRNSFRBL_DPSTS) Derivation of the variables with implict value for "Transferable deposits"

Integrity

V_CNTRPRTS_CDS_ID (V_CNTRPRTS_CDS_ID) Validates referential integrity of counterparty codes referring to counterparties.
V_CNTRPRTS_PD_ID (V_CNTRPRTS_PD_ID) Validates referential integrity of Probability of default of the counterparty to counterparties.
V_CNTRPRTY_ID1 (V_CNTRPRTY_ID1) Check if counterparties classified as "Head office undertaking" are included as counterparties
V_CNTRPRTY_ID2 (V_CNTRPRTY_ID2) Check if counterparties classified as "Ultimate parent undertaking" are included as counterparties
V_CNTRPRTY_ID3 (V_CNTRPRTY_ID3) Check if counterparties classified as "Immediate parent undertaking" are included as counterparties
V_CRDT_FCLTS_INSTRMNTS_ID1 (V_CRDT_FCLTS_INSTRMNTS_ID1) Validates that credit facilities are referred in the credit facilities instrument cube.
V_CRDT_FCLTS_INSTRMNTS_ID2 (V_CRDT_FCLTS_INSTRMNTS_ID2) Validates referential integrity of credit facilities instrument to credit facilities.
V_ENTRPRS_SZ_PRVS_PRD_ID (V_ENTRPRS_SZ_PRVS_PRD_ID) Validates referential integrity of enterprise size (previous period) referring to counterparties.
V_GRP_CNTRPRTY_ID (V_GRP_CNTRPRTY_ID) Validates referential integrity of group counterparty relationship referring to counterparties.
V_GRP_INTRNL_ID1 (V_GRP_INTRNL_ID1) Referencial integrity check for "Group internal identifier"
V_GRP_INTRNL_ID2 (V_GRP_INTRNL_ID2) Validates that group data are referred in the group counterparty relationship cube.
V_INSTRMNTS_PRTCTNS_ID1 (V_INSTRMNTS_PRTCTNS_ID1) Validates that instruments protections are referred to real estate claim.
V_INSTRMNTS_PRTCTNS_ID2 (V_INSTRMNTS_PRTCTNS_ID2) Validates referential integrity of real estate claim to instruments protections.
V_JNT_CNTRPRTS_ID (V_JNT_CNTRPRTS_ID) Validates referential integrity of joint counterparties referring to counterparties.
V_JNT_CNTRPRTS_ID2 (V_JNT_CNTRPRTS_ID2) Validates referential integrity of joint counterparties components referring to counterparties.
V_LNKD_ENTRPRSS_ID (V_LNKD_ENTRPRSS_ID) Validates referential integrity of linked enterprises referring to counterparties.
V_LN_CRDT_FCLTS_INSTRMNT (V_LN_CRDT_FCLTS_INSTRMNT) Validates referential integrity of credit facilities-instruments to loans
V_LN_INSTRMNT_PRTCTNS_ID (V_LN_INSTRMNT_PRTCTNS_ID) Validates that loans are referred in the instruments-protections cube.
V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID1 (V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID1) Validates that protection received is referred in the instruments-protections cube.
V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID2 (V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID2) Validates referential integrity of instruments-protections to loans.
V_PRTNR_ENTRPRSS_ID (V_PRTNR_ENTRPRSS_ID) Validates referential integrity of partner enterprises referring to counterparties.
V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID1 (V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID1) Validates that positive current accounts are referred in the credit facilities instruments cube.
V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID2 (V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID2) Validates referential integrity of credit facilities instruments to positive current accounts.
V_PSTV_CURR_ACCNT_ID1 (V_PSTV_CURR_ACCNT_ID1) Validates that positive current accounts are referred in the transations-counterparties cube.
V_PSTV_CURR_ACCNT_ID2 (V_PSTV_CURR_ACCNT_ID2) Validates referential integrity of transactions-counterparties to positive current accounts.
V_RGSTRY_TBL_SCRTS_CNTRPRTS_ID (V_RGSTRY_TBL_SCRTS_CNTRPRTS_ID) Validates referential integrity of registry table securities to counterparties.
V_RGSTRY_TBL_SCRTS_ID (V_RGSTRY_TBL_SCRTS_ID) Validates referential integrity of owned security to registry table securities.
V_RL_ESTT_PRTCTN_CLM_ID (V_RL_ESTT_PRTCTN_CLM_ID) Validates that real estate protection claim is referred in the real estate protection claim item cube.
V_RL_ESTT_PRTCTN_CLM_ID2 (V_RL_ESTT_PRTCTN_CLM_ID2) Validates referential integrity of real estate protection claim to real estate claim cube.
V_RL_ESTT_PRTCTN_ID (V_RL_ESTT_PRTCTN_ID) Validates that real estate protection is referred in the real estate protection claim item cube.
V_RL_ESTT_PRTCTN_ID2 (V_RL_ESTT_PRTCTN_ID2) Validates referential integrity of real estate protection claim to real estate protection cube.
V_SCRTSTNS_OTHR_CRDT_TRNSFR_LN_ID (V_SCRTSTNS_OTHR_CRDT_TRNSFR_LN_ID) Validates referential integrity of loans to securitisations and other credit transfers.
V_SCRTS_PRTCTN_ID (V_SCRTS_PRTCTN_ID) Validates referential integrity of securities protection to protections received.
V_SCRTY_ID (V_SCRTY_ID) Validates referential integrity of securities protection referring to registry table securities.
V_TRNSCTNS_CNTRPRTS_ID (V_TRNSCTNS_CNTRPRTS_ID) Validates referential integrity of transaction counterparties referring to counterparties.
V_TRNSCTN_ID1 (V_TRNSCTN_ID1) Validates whether loans are referred in the "Transactions-counterparties" cube
V_TRNSCTN_ID3 (V_TRNSCTN_ID3) Validates whether credit facilities are referred in the "Transactions-counterparties" cube
V_TRNSCTN_ID4 (V_TRNSCTN_ID4) Validates whether securitisations and other credit transfers are referred in the "Transactions-counterparties" cube
V_TRNSCTN_ID5 (V_TRNSCTN_ID5) Validates referential integrity of Transactions-counterparties referring to loans.
V_TRNSCTN_ID6 (V_TRNSCTN_ID6) Validates referential integrity of transactions-counterparties referring to protections.
V_TRNSCTN_ID7 (V_TRNSCTN_ID7) Validates referential integrity of transactions-counetparties referring to credit facilities.
V_TRNSCTN_ID8 (V_TRNSCTN_ID8) Validates referential integrity of transactions-counetparties referring to securitisations and other credit transfers.

Other

T_CNTRPRTS_E (T_CNTRPRTS_E) Counterparties enriched input layer.
T_CNTRY_E (T_CNTRY_E) Countries reference information enriched input layer
T_CRDT_FCLTS_E (T_CRDT_FCLTS_E) Credit facilities enriched input layer.
T_CRDT_FCLTS_INSTRMNTS_E (T_CRDT_FCLTS_INSTRMNTS_E) Credit facilities instruments enriched input layer.
T_INSTRMNTS_PRTCTNS_E (T_INSTRMNTS_PRTCTNS_E) Instruments protections enriched input layer.
T_JNT_CNTRPRTS_E (T_JNT_CNTRPRTS_E) Joint counterparties enriched input layer
T_LN_E (T_LN_E) Loans enriched input layer.
T_OWND_SCRTY_E (T_OWND_SCRTY_E) Owned security enriched input layer.
T_PRTCTN_RCVD_E (T_PRTCTN_RCVD_E) Protection received enriched input layer
T_PSTV_CRRNT_ACCNT_E (T_PSTV_CRRNT_ACCNT_E) Positive current account enriched input layer..
T_PT_CNTRPRTS_E (T_PT_CNTRPRTS_E) Put "Counterparties - Enriched"
T_PT_CNTRY_E (T_PT_CNTRY_E) Put "Countries reference information - Enriched"
T_PT_CRDT_FCLTS_E (T_PT_CRDT_FCLTS_E) Put "Credit facilities - Enriched"
T_PT_CRDT_FCLTS_INSTRMNTS_E (T_PT_CRDT_FCLTS_INSTRMNTS_E) Put "Credit facilities-instruments - Enriched"
T_PT_INSTRMNTS_PRTCTNS_E (T_PT_INSTRMNTS_PRTCTNS_E) Put "Instruments-protections - Enriched"
T_PT_JNT_CNTRPRTS_E (T_PT_JNT_CNTRPRTS_E) Put "Joint counterparties - Enriched"
T_PT_LN_E (T_PT_LN_E) Put "Loan - Enriched"
T_PT_OWND_SCRTY_E (T_PT_OWND_SCRTY_E) Put "Owned security - Enriched"
T_PT_PRTCTN_RCVD_E (T_PT_PRTCTN_RCVD_E) Put "Protection received - Enriched"
T_PT_PSTV_CRRNT_ACCNT_E (T_PT_PSTV_CRRNT_ACCNT_E) Put "Positive current accounts - Enriched"
T_PT_RGSTRY_TBL_SCRTS_E (T_PT_RGSTRY_TBL_SCRTS_E) Put "Registry table of securities - Enriched"
T_PT_RL_ESTT_CLM_E (T_PT_RL_ESTT_CLM_E) Put "Real estate claim - Enriched"
T_PT_RL_ESTT_PRTCTN_CLM_E (T_PT_RL_ESTT_PRTCTN_CLM_E) Put "Real estate protection-Real estate claim - Enriched"
T_PT_RL_ESTT_PRTCTN_E (T_PT_RL_ESTT_PRTCTN_E) Put "Real estate protection - Enriched"
T_PT_SCRTSTNS_OTHR_CRDT_TRNSFRS_E (T_PT_SCRTSTNS_OTHR_CRDT_TRNSFRS_E) Put "Securitisations and other credit transfers - Enriched"
T_PT_TRNSCTNS_CNTRPRTS_E (T_PT_TRNSCTNS_CNTRPRTS_E) Put "Transactions-Counterparties - Enriched"
T_RGSTRY_TBL_SCRTS_E (T_RGSTRY_TBL_SCRTS_E) Registry table of securities enriched input layer
T_RL_ESTT_CLM_E (T_RL_ESTT_CLM_E) Real estate claim enriched input layer.
T_RL_ESTT_PRTCTN_CLM_E (T_RL_ESTT_PRTCTN_CLM_E) Real estate protection claim enriched input layer.
T_RL_ESTT_PRTCTN_E (T_RL_ESTT_PRTCTN_E) Real estate protection enriched input layer.
T_SCRTSTNS_OTHR_CRDT_TRNSFRS_E (T_SCRTSTNS_OTHR_CRDT_TRNSFRS_E) Securitisations and other credit transfers enriched input layer
T_TRNSCTNS_CNTRPRTS_E (T_TRNSCTNS_CNTRPRTS_E) Transaction counterparties enriched input layer.

Procedures

PRCDR_CHCK_RLST (PRCDR_CHCK_RLST)
PRCDR_RFRNTL_INTGRTY (PRCDR_RFRNTL_INTGRTY)

Rulesets

DR_ACCMLTD_CHNGS_FV_CR1 (DR_ACCMLTD_CHNGS_FV_CR1)
DR_ACCMLTD_IMPRMNT1 (DR_ACCMLTD_IMPRMNT1)
DR_ACCNTNG_CLSSFCTN1 (DR_ACCNTNG_CLSSFCTN1)
DR_BLNC_SHT_TTL (DR_BLNC_SHT_TTL)
DR_CMMTMNT_INCPTN1 (DR_CMMTMNT_INCPTN1)
DR_CNTRY1 (DR_CNTRY1)
DR_DT_DFLT_STTS1 (DR_DT_DFLT_STTS1)
DR_DT_END_INTRST_ONLY1 (DR_DT_END_INTRST_ONLY1)
DR_DT_END_INTRST_ONLY2 (DR_DT_END_INTRST_ONLY2)
DR_DT_ENTRPRS_SZ1 (DR_DT_ENTRPRS_SZ1)
DR_DT_INCPTN1 (DR_DT_INCPTN1)
DR_DT_INTTN_LGL_PRCDNGS1 (DR_DT_INTTN_LGL_PRCDNGS1)
DR_DT_LGL_FNL_MTRTY1 (DR_DT_LGL_FNL_MTRTY1)
DR_DT_LGL_FNL_MTRTY2 (DR_DT_LGL_FNL_MTRTY2)
DR_DT_LGL_FNL_MTRTY3 (DR_DT_LGL_FNL_MTRTY3)
DR_DT_LGL_FNL_MTRTY4 (DR_DT_LGL_FNL_MTRTY4)
DR_DT_NXT_INTRST_RT_RST1 (DR_DT_NXT_INTRST_RT_RST1)
DR_DT_PRFRMNG_STTS1 (DR_DT_PRFRMNG_STTS1)
DR_DT_PST_D1 (DR_DT_PST_D1)
DR_DT_PST_D2 (DR_DT_PST_D2)
DR_DT_STTLMNT1 (DR_DT_STTLMNT1)
DR_FV1 (DR_FV1)
DR_FV_CHNG_HDG_ACCNTNG1 (DR_FV_CHNG_HDG_ACCNTNG1)
DR_GRSS_CRRYNG_AMNT_E_INTRST1 (DR_GRSS_CRRYNG_AMNT_E_INTRST1)
DR_IMPRMNT_ASSSSMNT_MTHD1 (DR_IMPRMNT_ASSSSMNT_MTHD1)
DR_IMPRMNT_STTS1 (DR_IMPRMNT_STTS1)
DR_IMPRMNT_STTS2 (DR_IMPRMNT_STTS2)
DR_IMPRMNT_STTS_INSTRMNT1 (DR_IMPRMNT_STTS_INSTRMNT1)
DR_INSTTTNL_SCTR1 (DR_INSTTTNL_SCTR1)
DR_INTRST_RT_CP1 (DR_INTRST_RT_CP1)
DR_INTRST_RT_FLR1 (DR_INTRST_RT_FLR1)
DR_LGL_PRCDNG_STTS1 (DR_LGL_PRCDNG_STTS1)
DR_NMBR_EMPLYS (DR_NMBR_EMPLYS)
DR_PRCNTG_INTRST_CPTL_VTNG_RGHTS1 (DR_PRCNTG_INTRST_CPTL_VTNG_RGHTS1)
DR_PRDNTL_PRTFL1 (DR_PRDNTL_PRTFL1)
DR_PYMNT_FRQNCY1 (DR_PYMNT_FRQNCY1)
DR_TYP_INTRST_RT2 (DR_TYP_INTRST_RT2)
DR_TYP_PRTCTN_VL_RL_ESTT1 (DR_TYP_PRTCTN_VL_RL_ESTT1)

SHS

G_ENTTY_INFRMTN (G_ENTTY_INFRMTN) Setup of the dataset Entity information
G_GRP_INFRMTN (G_GRP_INFRMTN) Setup of the dataset Group information
G_SCRTY_MSTR_DT (G_SCRTY_MSTR_DT) Setup of the dataset Security master data
G_SHSG4_ENTITY (G_SHSG4_ENTITY) Setup of the dataset Entity information
G_SHSG4_GROUP (G_SHSG4_GROUP) Generation of the cube SHSG4_GROUP
G_SHSG4_ISIN (G_SHSG4_ISIN) Generation of the cube SHSG4_ISIN
G_SHSG4_NON_ISIN (G_SHSG4_NON_ISIN) Generation of the cube SHSG4_NON_ISIN
G_SHSG_GNRL (G_SHSG_GNRL) Setup of generation SHSG information

Union

T_UNN_LN (T_UNN_LN) Union of all the cubes related to the "Loans" entity.
T_UNN_PRTCTN_RCVD (T_UNN_PRTCTN_RCVD) Union of all protection cube not related to real estates

Uniqueness

V_UNQNSS_LN (V_UNQNSS_LN) Validate uniquess of instrument identifiers
V_UNQNSS_PRTCTN (V_UNQNSS_PRTCTN) Validate uniqueness of protection identifiers