V_UNQNSS_PRTCTN

This transformation scheme validates if the [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 unique (taking into account all cubes where the [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 the primary key).

Scheme dependencies:

Transformation Scheme ID

V_UNQNSS_PRTCTN

Description

Validate uniqueness of protection identifiers

Classification

Phase Type Subtype Related entity
Preparation Validation Uniqueness PRTCTN

Natural language

This transformation scheme validates if the Protection identifier is unique (taking into account all cubes where the Protection identifier is the primary key).

Scheme dependencies:

VTL Syntax

0 OTHR_FNNCL_PRTCTN_E_IDS := OTHR_FNNCL_PRTCTN_E [keep (PRTCTN_ID)];
1 OTHR_PHYSCL_PRTCTN_E_IDS := OTHR_PHYSCL_PRTCTN_E [keep (PRTCTN_ID)];
2 PL_ITM_E_IDS := PL_ITM_E [keep (PRTCTN_ID)];
3 RL_ESTT_CLM_IDS := RL_ESTT_CLM [keep (PRTCTN_ID)];
4 RL_ESTT_PRTCTN_IDS := RL_ESTT_PRTCTN [keep (PRTCTN_ITM_ID as "PRTCTN_ID")];
5 SCRTS_PRTCTN_E_IDS := SCRTS_PRTCTN_E [keep (PRTCTN_ID)];
6 INTRSCTN_TMP := intersect (OTHR_FNNCL_PRTCTN_E_IDS, OTHR_PHYSCL_PRTCTN_E_IDS);
7 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
8 INTRSCTN := INTRSCTN_TMP;
9 INTRSCTN_TMP := intersect (OTHR_FNNCL_PRTCTN_E_IDS, PL_ITM_E_IDS);
10 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
11 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
12 INTRSCTN_TMP := intersect (OTHR_FNNCL_PRTCTN_E_IDS, RL_ESTT_CLM_IDS);
13 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
14 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
15 INTRSCTN_TMP := intersect (OTHR_FNNCL_PRTCTN_E_IDS, RL_ESTT_PRTCTN_IDS);
16 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
17 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
18 INTRSCTN_TMP := intersect (OTHR_FNNCL_PRTCTN_E_IDS, SCRTS_PRTCTN_E_IDS);
19 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
20 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
21 INTRSCTN_TMP := intersect (OTHR_PHYSCL_PRTCTN_E_IDS, PL_ITM_E_IDS);
22 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
23 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
24 INTRSCTN_TMP := intersect (OTHR_PHYSCL_PRTCTN_E_IDS, RL_ESTT_CLM_IDS);
25 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
26 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
27 INTRSCTN_TMP := intersect (OTHR_PHYSCL_PRTCTN_E_IDS, RL_ESTT_PRTCTN_IDS);
28 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
29 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
30 INTRSCTN_TMP := intersect (OTHR_PHYSCL_PRTCTN_E_IDS, SCRTS_PRTCTN_E_IDS);
31 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
32 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
33 INTRSCTN_TMP := intersect (PL_ITM_E_IDS, RL_ESTT_CLM_IDS);
34 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
35 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
36 INTRSCTN_TMP := intersect (PL_ITM_E_IDS, RL_ESTT_PRTCTN_IDS);
37 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
38 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
39 INTRSCTN_TMP := intersect (PL_ITM_E_IDS, SCRTS_PRTCTN_E_IDS);
40 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
41 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
42 INTRSCTN_TMP := intersect (RL_ESTT_CLM_IDS, RL_ESTT_PRTCTN_IDS);
43 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
44 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
45 INTRSCTN_TMP := intersect (RL_ESTT_CLM_IDS, SCRTS_PRTCTN_E_IDS);
46 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
47 INTRSCTN := union (INTRSCTN, INTRSCTN_TMP);
48 INTRSCTN_TMP := intersect (RL_ESTT_PRTCTN_IDS, SCRTS_PRTCTN_E_IDS);
49 INTRSCTN_TMP := INTRSCTN_TMP [calc "V_UNQNSS_PRTCTN" as "VLDTN_ID"];
50 V_UNQNSS_PRTCTN := union (INTRSCTN, INTRSCTN_TMP);