CA_CNUM (CA - Corporation number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/CA CNUM
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key CA_CNUM
The country a linked concept is active or generally relevant for. Country scope CA (Canada)
Language-specific name. Monolingual name Corporation number (fr), Corporation number (en)
Language-specific short name. Monolingual short name CA - Corporation number (en)
Informal and comprehensive human-readable definition of a concept. Description The Corporation number, in French numéro de société, is the seven-digit number that Corporations Canada assigns to a company incorporated under federal law. It identifies the corporation in the federal register and in its annual filings.
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/CA CNUM/format Validates the format of the Canadian corporation number, assigned by Corporations Canada to every federally incorporated company. The pattern accepts seven digits, which may be written with spaces, dots or hyphens between them. IDENTIFIER_FORMAT
^(\s*?\.*?-*?)(\d\s*\.*-*){7}$

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 Qualification (Corporation number (Canada), Data source:CA.CR)
ACCURACY
CA (Canada) This rule compares the Canadian corporation number in the business partner record with the identifier held as reference in the Canadian corporation register. A value that does not match is flagged. INFO RELEASED(2025-06-25)
Identifier format invalid (Corporation number (Canada))
REPRESENTATIONAL_CONSISTENCY
CA (Canada) The Canadian corporation number consists of exactly seven numerical digits. This rule checks that exactly seven digits are present, disregarding whitespaces or other delimiters between them. ERROR RELEASED(2021-09-10)
Identifier missing (Corporation number (Canada))
COMPLETENESS
CA (Canada) A legal entity in Canada requires a corporation number, and this rule reports records in which it is missing. WARNING RELEASED(2021-09-10)
Identifier unknown (Corporation number (Canada))
ACCURACY
CA (Canada) This rule validates the Canadian corporation number against the Canadian corporation register. A corporation number that is available in the register counts as valid, anything else is flagged. ERROR RELEASED(2024-04-16)
Locality Qualification (Corporation number (Canada), Data source:CA.CR)
ACCURACY
CA (Canada) This rule compares the city of a Canadian business partner with the city that the Canadian corporation register holds as reference for its corporation number. A deviating city is flagged. INFO RELEASED(2024-04-16)
Name Qualification (Corporation number (Canada), Data source:CA.CR)
ACCURACY
CA (Canada) This rule compares the name of a Canadian business partner with the name that the Canadian corporation register holds as reference for its corporation number. A deviating name is flagged. INFO RELEASED(2024-04-16)
Post code Qualification (Corporation number (Canada), Data source:CA.CR)
ACCURACY
CA (Canada) This rule compares the post code of a Canadian business partner with the post code that the Canadian corporation register holds as reference for its corporation number. A deviating post code is flagged. INFO RELEASED(2024-04-16)
Thoroughfare Qualification (Corporation number (Canada), Data source:CA.CR)
ACCURACY
CA (Canada) This rule compares the street of a Canadian business partner with the street that the Canadian corporation register holds as reference for its corporation number. A deviating street is flagged. INFO RELEASED(2024-04-16)