## spc0025 - observed agent delivery spc0025 each observed agent is reported as one unique counterparty

### Card of business rule observed agent delivery spc0025 each observed agent is reported as one unique counterparty

Name | observed agent delivery spc0025 each observed agent is reported as one unique counterparty
Code | spc0025
Comment | Each observed agent delivery combination also reported 1 and only 1 counterparty. This check ensures that the existing relationship and cardinality between OAD and counterparty can also be checked technically.
Rule Type | Definition

### Server expression of the business rule observed agent delivery spc0025 each observed agent is reported as one unique counterparty

FOR 'observed_agent_delivery.reported_as_counterparty_identifier', 'observed_agent_delivery.reporting_agent_identifier', observed_agent_delivery .reporting_reference_date FROM observed_agent_delivery JOIN counterparty ON observed_agent_delivery.reported_as_counterparty_identifier = counterparty.counterparty_identifier AND observed_agent_delivery.reporting_agent_identifier = counterparty.reporting_agent_identifier AND observed_agent_delivery.reporting_reference_date = counterparty.reporting_reference_date GROUP BY observed_agent_delivery.reported_as_counterparty_identifier, observed_agent_delivery.reporting_agent_identifier, observed_agent_delivery.reporting_reference_date COUNT observed_agent_delivery.reported_as_counterparty_identifier = 1

### List of DNB-specific attributes of the business rule observed agent delivery spc0025 each observed agent is reported as one unique counterparty

Name | Value
business rule classification | specialisation model constraint
business rule scope | Checked within the data delivery
business rule status | active business rule
number of dependencies | 1
severity | blocking

### List of attached objects of the business rule observed agent delivery spc0025 each observed agent is reported as one unique counterparty

Short Description
Entity Attribute 'observed agent delivery.reported as counterparty identifier'

Previous
Home
Next