EG_CCN (EG - Chamber of Commerce Num.)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/EG CCN
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key EG_CCN
The country a linked concept is active or generally relevant for. Country scope EG (Egypt)
Language-specific name. Monolingual name Chamber of Commerce Egypt (ar), Chamber of Commerce Number (en)
Language-specific short name. Monolingual short name EG - Chamber of Commerce Num. (en)
Informal and comprehensive human-readable definition of a concept. Description The Chamber of Commerce Number is the membership number that an Egyptian chamber of commerce assigns to a company registered with it. Members use it for trade services such as certificates of origin and export documentation.
Category of business identifiers. Identifier category Identification Number

Formal definition

Details Informal and comprehensive human-readable definition of a concept. Description The type in terms of a categorization of regular expressions. Regular expression type TThe formal expression of a regular expression. Regular expression
Regular expression/EG CCN/format Validates the format of the Egyptian Chamber of Commerce Number, under which a company is registered with its local chamber of commerce. The pattern accepts the fixed prefix US followed by 13 digits, with optional spaces, dots or hyphens. IDENTIFIER_FORMAT
^(\s*?\.*?-*?)U(-*?\s*?\.*?)S(-*?\s*?\.*?)(\d-*?\s*\.*-*){13}\s*?$
Regular expression/EG CCN/reference schema Defines the reference format in which the Egyptian Chamber of Commerce Number is stored, namely the prefix US, a hyphen, the two-digit chamber code, a hyphen and eleven further digits, seventeen characters in total. Used to bring values into a single canonical notation. IDENTIFIER_SCHEMA
^\w{2}\-\d{2}\-\d{11}$

Data quality rules

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
Identifier format inaccurate (Chamber of Commerce Number (Egypt))
REPRESENTATIONAL_CONSISTENCY
EG (Egypt) This rule checks that the Egyptian Chamber of Commerce Number is written in its reference schema of two letters, a hyphen, two digits, a hyphen and eleven 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 (Chamber of Commerce Number (Egypt))
REPRESENTATIONAL_CONSISTENCY
EG (Egypt) This rule checks the format of the Egyptian Chamber of Commerce Number, disregarding any whitespaces, hyphens or dots that the value may contain. A value with fewer or more digits, with unexpected non-digit characters or with leading zeros violates the rule. ERROR RELEASED(2024-04-16)
Identifier missing (Chamber of Commerce Number (Egypt))
COMPLETENESS
EG (Egypt) Every legal entity in Egypt is expected to hold a Chamber of Commerce Number, and this rule reports records where it is missing. ERROR RELEASED(2024-04-16)
Identifier unknown (Chamber of Commerce Number (Egypt))
ACCURACY
EG (Egypt) This rule checks whether the Chamber of Commerce Number is known, meaning that it is assigned to a business partner listed in the official registry of Egypt. A value that cannot be found there is flagged. ERROR IDEA