Business rule debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

Card of business rule debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

Name

debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

Code

omc0021

Comment

If there is more than one debtor taking part in an instrument, then for each debtor reported in the counterparty-instrument data set, a joint liabilities record must exist.

Rule Type

Constraint


Server expression of the business rule debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

select "success"
from [joint liability] joint
where exists
(select count(*)
from [debtor-instrument data] debtor
   where joint.[reporting agent identifier] = debtor.[reporting agent identifier]
    and joint.[observed agent identifier] = debtor.[observed agent identifier]
and joint.[counterparty role] = 'debtor'
    and joint.[contract identifier] = debtor.[contract identifier]
    and joint.[instrument identifier] = debtor.[instrument identifier]
and joint.[reporting reference date] = debtor.[reporting reference date]
   having count(*) > 1 )
and joint.[reporting reference date] = 'current reporting date'


List of DNB-specific attributes of the business rule debtor-instrument data omc0021 joint liability must exist for multiple debtors on 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 debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

Short Description

Entity 'debtor-instrument data'