V_PRTCTN_ID1

Validation retrieves:

– [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip] for [simple_tooltip content='TYP_INSTRMNT; Classification of the instrument according to the type of contractual terms agreed between the parties.']Type of instrument[/simple_tooltip] Finance leases (80)
– and [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] for [simple_tooltip content='TYP_PRTCTN; Type of protection received, irrespective of its eligibility for credit risk mitigation.']Type of protection[/simple_tooltip]:
[simple_tooltip content='Other physical collateral (e.g. commercial equipment, machines and vehicles) in accordance with Regulation (EU) No 575/2013 and not included in the previous values.']Other physical collaterals (3)[/simple_tooltip]
[simple_tooltip content='Residential property as defined in Article 4(1)(75) of Regulation (EU) No 575/2013.']Residential real estate collateral (8)[/simple_tooltip]
[simple_tooltip content='Offices and commercial premises in accordance with Regulation (EU) No 575/2013.']Offices and commercial premises (9)[/simple_tooltip]
[simple_tooltip content='Real estate property other than residential property, offices and commercial premises.']Commercial real estate collateral (10)[/simple_tooltip]
[simple_tooltip content='Gold in accordance with Regulation (EU) No 575/2013.']Gold (13)[/simple_tooltip]

then retrieves the links between financial leases:
– [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip]
– [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]

Creates a dataset with all financial leases and values for associated types of protections
Validates that for each remaining [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip]:
– [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] is not null

Scheme dependencies:

Transformation Scheme ID

V_PRTCTN_ID1

Description

Consistency check of instruments representing financial leases regarding the presence of the leasing good (as a protection)

Classification

Phase Type Subtype Related entity
Preparation Validation Completeness LN

Natural language

Validation retrieves:

Instrument unique identifier for Type of instrument Finance leases (80)
– and Protection identifier for Type of protection:
Other physical collaterals (3)
Residential real estate collateral (8)
Offices and commercial premises (9)
Commercial real estate collateral (10)
Gold (13)

then retrieves the links between financial leases:
Instrument unique identifier
Protection identifier

Creates a dataset with all financial leases and values for associated types of protections
Validates that for each remaining Instrument unique identifier:
Protection identifier is not null

Scheme dependencies:

VTL Syntax

0 V_PRTCTN_ID1 := LN [filter (TYP_INSTRMNT = "80"), keep (INSTRMNT_UNQ_ID)];
1 PRTCTNS_FLTRD_NN_RL_ESTT := PRTCTN_RCVD [filter (TYP_PRTCTN in ("3", "13")), keep (PRTCTN_ID)];
2 PRTCTNS_FLTRD_RL_ESTT := RL_ESTT_CLM [keep (PRTCTN_ID)];
3 PRTCTNS_FLTRD := union (PRTCTNS_FLTRD_NN_RL_ESTT, PRTCTNS_FLTRD_RL_ESTT);
4 V_PRTCTN_ID1 := [left V_PRTCTN_ID1 as "A", INSTRMNTS_PRTCTNS as "B" on A.INSTRMNT_UNQ_ID = B.INSTRMNT_UNQ_ID] {keep (A.INSTRMNT_UNQ_ID, B.PRTCTN_ID)};
5 V_PRTCTN_ID1 := [left V_PRTCTN_ID1 as "A", PRTCTNS_FLTRD as "B" on A.PRTCTN_ID = B.PRTCTN_ID] {keep (A.INSTRMNT_UNQ_ID, B.PRTCTN_ID)};
6 V_PRTCTN_ID1 := V_PRTCTN_ID1 [filter (isnull (PRTCTN_ID)), keep (INSTRMNT_UNQ_ID)];
7 V_PRTCTN_ID1 := V_PRTCTN_ID1 [calc "V_PRTCTN_ID1" as "VLDTN_ID" role Measure];