Specific Validation Rules Page – Equality control groups
Admin
Application database > Data processing tile > Diagnostic > Validation > (Specific rules) Equality control groups
Application Database > Navigation Panel > Data processing > Diagnostic > Validation > (Specific Rules) Equality control groups
Page purpose¶
This page shows the validation rules for control groups with equality operators that are currently configured. It allows you to edit them and create new ones.
To override these rules on a per-process basis, see the Rules page in the Processes section.
Actions on this page
| Element | Description |
|---|---|
| Validation rules: opens a window to set and generate a preview, in Excel format, of all the elements impacted by the rule. |
Attributes on the page
| Element | Description |
|---|---|
| Data type | The control groups obtained by this definition are validated on the following types of data: - All (default) - Gross - Net - Intercompany This condition is intersected with what is indicated for the control groups in the relative table. See . |
| Source control group | Specifies which elements need to be validated - All elements (default) - An element in the control groups list - A node or an element in the control groups groupings If ‘All elements’ or a node is selected, the extracted elements use the ‘equals’ operator. |
| Category | Specifies the categories for which the data is checked: - All elements (default) - An element in the categories table - A node or an element of the categories groupings |
| Granularity | Sets the granularity with which the data are checked and is conditional on the Category attribute setting: - By node, only if Category contains a node of category groupings. - By category (default), only if Category contains an amount category or an entity journal category or All elements or a node of category groupings. In the two latter cases, the consolidation journals are discarded from the result categories. - By journal, only if Category contains an entity journal category or a consolidation journal category or All elements or a node of category groupings. In the two latter cases, By category granularity is applied to amount-type result categories. |
| Severity | This allows you to define the severity level to be applied to the rule, and consequently what happens if the data processing detects an error. - Automatic (default): the severity defined in the control groups list (Blocking or Non-blocking) is applied. - Blocking: Entity's data is not submitted - Non-blocking. - Only Diagnostic: the check is only run if explicitly requested by manually running the diagnostic from the Detail summary (for the contributor) or Overview (for the consolidator) cockpit tabs; in this case it is possible to customise the filters before running the data processing. However, whenever diagnostics are run automatically (from the cockpit/from other data processing), the check is not performed. - Do not run : data is not verified. A useful option for excluding elements from a node to be deployed. |
| Thresholds | |
| Currencies for thresholds | Currency in which the threshold amounts set in this section are considered to be expressed; for the comparison, these must be converted into the currency of the entities/journals to which it is applied. The FX rate used for the conversion is the final FX rate. If the currency is not set, the currency of the relative entity or journal will be used. |
| Submission threshold | If set, below the threshold value, the entity is submitted even if there are errors with Blocking severity. In the submission step, these errors are classified as Below threshold blocking. |
| Original scenarios balancing threshold | If this option is enabled, during the balancing data processing for the original scenarios, rows with an unbalanced amount below this value will be balanced. Control groups with the following levels of granularity are not balanced: - "by node" containing only journal categories - "by category" on journal categories. |
| Consolidation scenarios balancing threshold | If this option is enabled, during the balancing data processing for the consolidation scenarios, rows with an unbalanced amount below this value will be balanced. Control groups with the following levels of granularity are not balanced: - "by node" containing only journal categories - "by category" on journal categories. |
IMPORTANT: if thresholds are not set, the threshold on the row preceding the definition for the same data collection will be considered. If no other rows exist, the threshold will be set to zero.