| Data quality rule
|
The country a linked concept is active or generally relevant for. Country scope
|
Informal and comprehensive human-readable definition of a concept. Description
|
Criticality<br/>Specifies how critical of the violation of a data quality rule.<br/>ERROR: Indicates a critical data quality rule violation that requires correction.<br/>WARNING: Indicates a potential data quality issue that should be reviewed.<br/>INFO: Indicates an informational finding with no immediate impact on data quality. Criticality
|
Rule release status<br/>The release status in terms of development progress or maturity of a data quality rule.<br/>IDEA: Initial rule definition that documents a business requirement but is not yet active in services.<br/>PLANNED: Rule is specified and scheduled for implementation, but not yet active in services.<br/>DRAFT: Rule concept is being prepared or refined but is not yet finalized for implementation or execution.<br/>HYPERCARE: Rule is newly released and under increased observation to ensure stable behaviour and correct results.<br/>RELEASED: Rule has passed verification and is actively executed in productive CDQ services.<br/>DEACTIVATED: Rule is temporarily removed from the active rule set because it needs correction or clarification before re release.<br/>BLOCKED: Rule cannot be released because something it depends on is missing, for example a data source or a clarification.<br/>ARCHIVED: Rule is permanently retired and no longer maintained or intended for future activation. Rule release status
|
Dummy post code detected (JE)
ACCURACY
|
JE (Jersey)
|
Post codes in Jersey are checked here against patterns that mark a value as a placeholder rather than a real post code. The patterns from the CDQ regular expression library cover a mononumerical post code with a delimiter, a not available post code, one digit repeated several times, an ordinal sequence of numbers, a single digit post code and a very long string of digits.
|
ERROR
|
RELEASED
|
Identifier format inaccurate (Social Security Number (Jersey))
REPRESENTATIONAL_CONSISTENCY
|
JE (Jersey)
|
This rule checks that the social security number of Jersey is written in its reference schema of two letters, six digits and a final letter, including that all applicable hyphens, dots and spaces are in place. A value formatted differently is flagged.
|
INFO
|
RELEASED(2024-04-16)
|
Identifier format inaccurate (Tax Reference Number (Jersey))
REPRESENTATIONAL_CONSISTENCY
|
JE (Jersey)
|
This rule checks that the tax reference number of Jersey is written in its reference schema, which ranges from two letters and one digit to two letters and five digits, including that all applicable hyphens, dots and spaces are in place. A value formatted differently is flagged.
|
INFO
|
RELEASED(2024-04-16)
|
Identifier format invalid (Social Security Number (Jersey))
REPRESENTATIONAL_CONSISTENCY
|
JE (Jersey)
|
This rule checks that the social security number of Jersey consists of exactly nine characters in the pattern of two letters, six digits and one final letter, disregarding any whitespaces, hyphens or dots in the value. The first two letters are usually, but not exclusively, JY, and the last letter must be A, B, C or D. A value with too few or too many digits or letters, or with an unexpected letter, violates the rule. An example of the identifier is JY123456A.
|
ERROR
|
RELEASED
|
Identifier format invalid (Tax Reference Number (Jersey))
REPRESENTATIONAL_CONSISTENCY
|
JE (Jersey)
|
This rule checks that the tax reference number of Jersey consists of three to seven characters, namely two letters followed by up to five digits, so that the value ranges from two letters and one digit to two letters and five digits, disregarding any whitespaces, hyphens or dots in the value. The first letter is C for companies, D or E for partnerships and E for other entities. A value with too few or too many digits or letters, or with an unexpected letter, violates the rule. An example of the identifier is CC00000.
|
ERROR
|
RELEASED
|
Identifier missing (Social Security Number (Jersey))
COMPLETENESS
|
JE (Jersey)
|
Every individual in Jersey is expected to hold a social security number, and this rule flags records in which it is missing.
|
INFO
|
RELEASED(2024-04-16)
|
Identifier missing (Tax Reference Number (Jersey))
COMPLETENESS
|
JE (Jersey)
|
Every legal entity in Jersey is expected to hold a tax reference number, and this rule flags records in which it is missing.
|
INFO
|
RELEASED(2024-04-16)
|
Identifier unknown (Social Security Number (Jersey))
ACCURACY
|
JE (Jersey)
|
This rule checks whether the social security number is known, meaning that it is assigned to a business partner listed in the official registry of Jersey. A value that cannot be found there is flagged.
|
ERROR
|
IDEA
|
Identifier unknown (Tax Reference Number (Jersey))
ACCURACY
|
JE (Jersey)
|
This rule checks whether the tax reference number is known, meaning that it is assigned to a business partner listed in the official registry of Jersey. A value that cannot be found there is flagged.
|
ERROR
|
IDEA
|
Length of domestic bank account Id invalid (Jersey)
REPRESENTATIONAL_CONSISTENCY
|
JE (Jersey)
|
In Jersey a domestic bank account identifier must not exceed the maximum length used there. This rule flags values that do.
|
ERROR
|
RELEASED(2024-04-16)
|
Mandatory post code missing (Jersey)
COMPLETENESS
|
JE (Jersey)
|
The post code belongs to every street address in Jersey, and this rule reports addresses that do not carry it.
|
ERROR
|
RELEASED(2024-04-16)
|
Post code format invalid (Jersey)
REPRESENTATIONAL_CONSISTENCY
|
JE (Jersey)
|
This rule checks the post code format of Jersey, where a postal code system was introduced only in June 1993. It follows the same structure and format as United Kingdom postal codes: every code begins with the letters JE followed by a digit, a space, a digit and two letters.
|
ERROR
|
RELEASED(2020-01-01)
|
Unallowed pattern in name detected (JE)
ACCURACY
|
JE (Jersey)
|
This rule identifies business partner names in Jersey that follow a dubious pattern rather than naming a real company. The patterns taken from the CDQ regular expression library cover a one time vendor, aggregated payments, a no new orders note, a do not use duplicates note, a reference to another record, a no use note, a reference to a new record, a reference to the former name, a long number in the name, a duplicate record note, a deletion note, a dummy record note, a sequence of digits, unsorted keywords and the length of the name.
|
WARNING
|
RELEASED(2024-09-04)
|