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

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

Name

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

Code

omc0008

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 omc0008 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.[reporting agent identifier]
and joint.[counterparty role] = 'debtor'
    and joint.[contract identifier] = debtor.[contract identifier]
    and joint.[instrument identifier] = debtor.[instrument identifier]
   having count(*) > 1 )
and joint.[reporting reference date] = 'current reporting date'


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

Short Description

Entity 'debtor-instrument data'