## omc0034 - 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 | Let the set S contain each entity type where it is true that the value of 'rowcount reporting indicator' = "entity type with reported rowcount". For each entity type E in set S, 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 where 'E'.'rowcount reporting indicator' = "entity type with reported rowcount": select case when count(1) = rowcount then true else false end as validation from 'check entiteit', 'entity type delivery' where 'entity type delivery'.'entity type 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
business rule status | active business rule
number of dependencies | 1
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'

Previous
Home
Next