BN_CA (CA - Federal Business Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/BN CA
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key BN_CA
The country a linked concept is active or generally relevant for. Country scope CA (Canada)
Language-specific name. Monolingual name Federal Business Number (fr), Federal Business Number (en)
Language-specific short name. Monolingual short name CA - Federal Business Number (en)
Informal and comprehensive human-readable definition of a concept. Description The Federal Business Number (BN), in French numéro d'entreprise, is the nine-digit number that the Canada Revenue Agency assigns to a corporation, sole proprietorship or partnership. Each business has only one such number, and the programme accounts for payroll, GST or HST and corporate income tax are opened as extensions of it.
Category of business identifiers. Identifier category Tax 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/BN CA/format Validates the format of the Canadian Federal Business Number (BN), the nine-digit number that the Canada Revenue Agency assigns to a corporation, sole proprietorship or partnership as its account with the federal tax administration. The pattern accepts nine digits, which may be written with spaces, dots or hyphens between them. IDENTIFIER_FORMAT
^(\s*?\.*?-*?)(\d\s*\.*-*){9}$

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 (Business number (Canada))
REPRESENTATIONAL_CONSISTENCY
CA (Canada) The Canadian business number consists of exactly nine numerical digits. This rule checks whether the value is written exactly in its reference format and flags any whitespace, hyphen or dot it contains. INFO IDEA(2020-01-01)
Identifier format invalid (Business number (Canada))
REPRESENTATIONAL_CONSISTENCY
CA (Canada) The Canadian business number consists of exactly nine numerical digits. This rule checks that exactly nine digits are present, disregarding whitespaces or other delimiters between them. ERROR RELEASED(2020-01-01)
Identifier missing (Business number (Canada))
COMPLETENESS
CA (Canada) A legal entity in Canada requires a business number, and this rule flags records in which it has not been maintained. WARNING RELEASED(2021-09-10)
Inconsistency between Business Number and GST number (Canada)
CONSISTENCY
CA (Canada) The Canadian business number consists of nine digits, and the Canadian GST number is built from it: nine digits that are exactly the business number, followed by the letters RT, which mark the value as a GST number, followed by a four-digit suffix such as 0001 or 0002. An entity can hold more than one GST number, for example when it runs two separate businesses, in which case the first carries the suffix 0001, the second 0002 and so on.

This rule checks that both a GST number and a business number are present and that the first nine digits of the GST number are identical to the business number. If they are not, either the GST number or the business number is wrong.

ERROR RELEASED(2020-12-28)
Inconsistency between Business Number and HST number (Canada)
CONSISTENCY
CA (Canada) The Canadian HST number is built from the business number: nine digits that are exactly the business number, followed by the program identifier RT and a four-digit reference number such as 0001 or 0002.

This rule checks that both an HST number and a business number are present and that the first nine digits of the HST number are identical to the business number. If they are not, either the HST number or the business number is wrong.

ERROR HYPERCARE
Invalid checksum of BN CA (Canada)
ACCURACY
CA (Canada) The Canadian business number consists of exactly nine digits and must be correct because it also forms part of the GST/HST number. Its ninth digit is a check digit calculated as follows.

All odd-positioned digits except the ninth are added together. All even-positioned digits are then strung together as one number and multiplied by two, and the digits of that result are added together. The two totals are added, and that sum is subtracted from the nearest higher multiple of ten. The result must equal the ninth digit, if it does not, the rule is violated.

ERROR RELEASED(2020-10-12)