Business rule each entity type omc0034 row count check

Card of business rule each entity type omc0034 row count check

Name

each entity type omc0034 row count check

Code

omc0034

Comment

For each entity type E, the total number of rows of E must correspond to the value of the attribute 'rowcount' in the entity type 'entity type delivery' for E.

Rule Type

Constraint


Server expression of the business rule each entity type omc0034 row count check

For each entity type E in AnaCredit GLO:
select case when count(1) = rowcount then true else false end as validation
from 'check entiteit', 'entity delivery'
where 'entity delivery'.'code' = E
group by rowcount;


List of DNB-specific attributes of the business rule each entity type omc0034 row count check

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 each entity type omc0034 row count check

Short Description

Logical Data Model 'AnaCredit GLO per bank LDM'