## omc0077 - 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
business rule status | active business rule
number of dependencies | 1
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'

Previous
Home
Next