Business rule 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'