## omc0040 - creditor-instrument data omc0040 creditor cannot be protection provider of the same instrument

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

Name | creditor-instrument data omc0040 creditor cannot be protection provider of the same instrument
Code | omc0040
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.
Rule Type | Constraint

### Server expression of the business rule creditor-instrument data omc0040 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 extended attributes of the business rule creditor-instrument data omc0040 creditor cannot be protection provider of the same instrument

Name | Data Type | Value | Target Name
business rule classification | (String) | other model constraint | Local Extensions
business rule scope | (String) | Checked within the data delivery | Local Extensions
severity | (String) | signalling | Local Extensions

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

Short Description
Entity 'creditor-instrument data'

Previous
Home
Next