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

Short Description

Entity 'debtor-instrument data'