Business rule creditor-instrument data omc0076 creditor cannot be debtor of the same instrument

Card of business rule creditor-instrument data omc0076 creditor cannot be debtor of the same instrument

Name

creditor-instrument data omc0076 creditor cannot be debtor of the same instrument

Code

omc0076

Comment

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

ECB Validation identifier: CN0621

Rule Type

Constraint


Server expression of the business rule creditor-instrument data omc0076 creditor cannot be debtor of the same instrument

the join of
('creditor-instrument data', 'debtor-instrument data')
on
('creditor-instrument data'.'reporting agent identifier' = 'debtor-instrument data'.'reporting agent identifier' and
'creditor-instrument data'.'observed agent identifier' = 'debtor-instrument data'.'observed agent identifier' and
'creditor-instrument data'.'counterparty identifier' = 'debtor-instrument data'.'counterparty identifier' and
'creditor-instrument data'.'contract identifier' = 'debtor-instrument data'.'contract identifier' and
'creditor-instrument data'.'instrument identifier' = 'debtor-instrument data'.'instrument identifier' and
'creditor-instrument data'.'reporting reference date' = 'debtor-instrument data'.'reporting reference date')
is empty.


List of DNB-specific attributes of the business rule creditor-instrument data omc0076 creditor cannot be debtor 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 omc0076 creditor cannot be debtor of the same instrument

Short Description

Entity 'creditor-instrument data'

Entity 'debtor-instrument data'