G_RL_ESTT_PRTCTN_RCVD_AC

Connect cubes:
– [simple_tooltip content='RL_ESTT_PRTCTN_CLM_E']Real estate protection-Real estate claim – Enriched[/simple_tooltip]
– [simple_tooltip content='RL_ESTT_PRTCTN_E']Real estate protection – Enriched[/simple_tooltip]
on their [simple_tooltip content='PRTCTN_ITM_ID; An identifier applied by the reporting agent to uniquely identify each real estate. Each real estate must have one Protection item identifier. This value will not change over time and cannot be used as the Protection item identifier for any other protection.']Protection item identifier[/simple_tooltip]

Connect with cube:
– [simple_tooltip content='RL_ESTT_CLM_E']Real estate claim – Enriched[/simple_tooltip]
on [simple_tooltip content='PRTCTN_ID; An identifier applied by the reporting agent to uniquely identify each protection (except for real estate protection) used to secure the instrument. Each protection must have one protection identifier. This value will not change over time and cannot be used as the protection identifier for any other protection.']Protection identifier[/simple_tooltip]

Extract a subset for which:
– [simple_tooltip content='TYP_TRNSCTN; It defines the type of transaction to which the transaction identifier refers.']Type of transaction[/simple_tooltip] is Protection received other than real estate (3)
– [simple_tooltip content='CNTRPRTY_RL; Role of the counterparty in a transaction.']Counterparty role in a transaction[/simple_tooltip] is Protection provider (2)
– [simple_tooltip content='IS_PRMRY_PRTCTN_PRVDR; It identifies the primary protection provider in case of multiple protection providers (related to one protection).']Is primary protection provider[/simple_tooltip] is TRUE (T)

Add a Protection provider identifier to the dataset

Connect to related instrument using cube:
– [simple_tooltip content='INSTRMNTS_PRTCTNS_E']Instruments-protections – Enriched[/simple_tooltip]

Connect to loans in order to retrieve:
– [simple_tooltip content='INSTRMNT_ID; An identifier applied by the reporting agent to uniquely identify each instrument under a single contract. Each instrument must have one instrument identifier. This value will not change over time and cannot be used as the instrument identifier for any other instrument under the same contract.']Instrument identifier[/simple_tooltip]
– [simple_tooltip content='CNTRCT_ID; An identifier applied by the reporting agent to uniquely identify each contract. Each contract must have one contract identifier. This value will not change over time and cannot be used as the contract identifier for any other contract.']Contract identifier[/simple_tooltip]
– [simple_tooltip content='OBSRVD_AGNT_ID; Counterparty identifier for the observed agent.']Observed agent identifier [/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

G_RL_ESTT_PRTCTN_RCVD_AC

Description

Preparation of subsets of protection cubes related to real estate

Classification

Phase Type Subtype Related entity
Generation Generation AnaCredit

Natural language

Connect cubes:
Real estate protection-Real estate claim – Enriched
Real estate protection – Enriched
on their Protection item identifier

Connect with cube:
Real estate claim – Enriched
on Protection identifier

Extract a subset for which:
Type of transaction is Protection received other than real estate (3)
Counterparty role in a transaction is Protection provider (2)
Is primary protection provider is TRUE (T)

Add a Protection provider identifier to the dataset

Connect to related instrument using cube:
Instruments-protections – Enriched

Connect to loans in order to retrieve:
Instrument identifier
Contract identifier
Observed agent identifier

Scheme dependencies:

VTL Syntax

0 RL_ESTT_PRTCTN_RCVD_AC := [left RL_ESTT_PRTCTN_CLM_E as "A", RL_ESTT_PRTCTN_E as "B" on A.PRTCTN_ITM_ID = B.PRTCTN_ITM_ID] {keep (A.PRTCTN_ID, A.PRTCTN_ITM_ID, B.PRTCTN_VLTN_DT, B.OBSRVD_AGNT_INTRNL_ID, B.PRTCTN_VL, B.PRTCTN_VLTN_APPRCH, B.RL_ESTT_CLLTRL_LCTN, B.TYP_PRTCTN, B.TYP_PRTCTN_VL)};
1 RL_ESTT_PRTCTN_RCVD_AC := [left RL_ESTT_PRTCTN_RCVD_AC as "A", RL_ESTT_CLM_E as "B" on A.PRTCTN_ID = B.PRTCTN_ID] {keep (A.PRTCTN_ID, A.PRTCTN_ITM_ID, A.PRTCTN_VLTN_DT, A.OBSRVD_AGNT_INTRNL_ID, A.PRTCTN_VL, A.PRTCTN_VLTN_APPRCH, A.RL_ESTT_CLLTRL_LCTN, A.TYP_PRTCTN, A.TYP_PRTCTN_VL, B.DT_MTRTY_PRTCTN, B.THRD_PRTY_PRRTY_CLMS)};
2 TRNSCTNS_CNTRPRTS_SUB := TRNSCTNS_CNTRPRTS_E [filter (TYP_TRNSCTN = "6" and CNTRPRTY_RL = "2" and IS_PRMRY_PRTCTN_PRVDR = "T"), keep (TRNSCTN_ID as "PRTCTN_ID")];
3 RL_ESTT_PRTCTN_RCVD_AC := [inner RL_ESTT_PRTCTN_RCVD_AC as "A", TRNSCTNS_CNTRPRTS_SUB as "B" on A.PRTCTN_ID = B.PRTCTN_ID] {keep (A.ALL_VARIABLES, B.PRTCTN_PRVD_ID)};
4 RL_ESTT_PRTCTN_RCVD_AC := [inner RL_ESTT_PRTCTN_RCVD_AC as "A", INSTRMNTS_PRTCTNS_E as "B" on A.PRTCTN_ID = B.PRTCTN_ID] {keep (A.ALL_VARIABLES, B.INSTRMNT_UNQ_ID, B.PRTCTN_ALLCTD_VL)};
5 RL_ESTT_PRTCTN_RCVD_AC := [inner RL_ESTT_PRTCTN_RCVD_AC as "A", LN_AC as "B" on A.PRTCTN_ID = B.PRTCTN_ID] {keep (A.ALL_VARIABLES, B.INSTRMNT_ID, B.CNTRCT_ID, B.OBSRVD_AGNT_ID)};