Business rule creditor-instrument data omc0077 creditor cannot be protection provider of the same instrument

Card of business rule creditor-instrument data omc0077 creditor cannot be protection provider of the same instrument

Name

creditor-instrument data omc0077 creditor cannot be protection provider of the same instrument

Code

omc0077

Comment

This validation check ensures that the same counterparty is not both a creditor and a protection provider for the same instrument. This is performed by comparing a combination of unique identifiers with the role of the counterparty.

ECB Validation identifier: CN0622

Rule Type

Constraint


Server expression of the business rule creditor-instrument data omc0077 creditor cannot be protection provider of the same instrument

if exists (
select 1
from 'creditor'
join 'creditor-instrument data' on
'creditor'.'reporting agent identifier' = 'creditor-instrument data'.'reporting agent identifier' and
'creditor'.'counterparty identifier' = 'creditor-instrument data'.'counterparty identifier' and
'creditor'.'counterparty role' = 'creditor-instrument data'.'counterparty role' and
'creditor'.'reporting reference date' = 'creditor-instrument data'.'reporting reference date'
join 'instrument' on
'creditor-instrument data'.'reporting agent identifier' = 'instrument'.'reporting agent identifier' and
'creditor-instrument data'.'observed agent identifier' = 'instrument'.'observed agent identifier' and
'creditor-instrument data'.'contract identifier' = 'instrument'.'contract identifier' and
'creditor-instrument data'.'instrument identifier' = 'instrument'.'instrument identifier' and
'creditor-instrument data'.'reporting reference date' = 'instrument'.'reporting reference date'
join 'instrument-protection received data' on
'instrument'.'reporting agent identifier' = 'instrument-protection received data'.'reporting agent identifier' and
'instrument'.'observed agent identifier' = 'instrument-protection received data'.'observed agent identifier' and
'instrument'.'contract identifier' = 'instrument-protection received data'.'contract identifier' and
'instrument'.'instrument identifier' = 'instrument-protection received data'.'instrument identifier' and
'instrument'.'reporting reference date' = 'instrument-protection received data'.'reporting reference date'
join 'protection received' on
'instrument-protection received data'.'reporting agent identifier' = 'protection received'.'reporting agent identifier' and
'instrument-protection received data'.'protection identifier' = 'protection received'.'protection identifier' and
'instrument-protection received data'.'reporting reference date' = 'protection received'.'reporting reference date'
join 'protection provider-protection received' on
'protection received'.'reporting agent identifier' = 'protection provider-protection received'.'reporting agent identifier' and
'protection received'.'protection identifier' = 'protection provider-protection received'.'protection identifier' and
'protection received'.'reporting reference date' = 'protection provider-protection received'.'reporting reference date'
where 'protection provider-protection received'.'reporting agent identifier' = 'creditor'.'reporting agent identifier'
and 'protection provider-protection received'.'counterparty identifier' = 'creditor'.'counterparty identifier'
and 'protection provider-protection received'.'reporting reference date' = 'creditor'.'reporting reference date')


List of DNB-specific attributes of the business rule creditor-instrument data omc0077 creditor cannot be protection provider of the same instrument

Name

Value

business rule classification

other model constraint

business rule scope

Checked within the data delivery

severity

signalling


List of attached objects of the business rule creditor-instrument data omc0077 creditor cannot be protection provider of the same instrument

Short Description

Entity 'creditor-instrument data'