1. Load

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

2. Pre-arrangement validation

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

3. Implicit information addition

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

4. Input data validation

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