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) is a 9-digit number which Revenue Canada Agency assigns to a business such as a corporation, a sole proprietorship or a partnership in Canada. Each corporation is assigned only one Business Number but multiple accounts can be opened up under this number.
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
0000000000ETVY9NWRAK4TBKPN Specifies the allowed formats for the Business number (Canada) IDENTIFIER_FORMAT
^(\s*?\.*?-*?)(\d\s*\.*-*){9}$

Data quality rules

Rule Informal and comprehensive human-readable definition of a concept. Description nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates Release status 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
Identifier format inaccurate (Business number (Canada)) This rule checks the syntax, i.e. format of the Business number in Canada with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

The Canadian business number consists of exactly 9 numerical digits. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, hyphens or dots then the rule is violated.

IDEA INFO
Identifier format invalid (Business number (Canada)) The Canadian business number consists of exactly 9 numerical digits. The rule checks whether there are exactly 9 numerical digits available not considering possible whitespaces or other delimiters between the digits. RELEASED ERROR
Identifier missing (Business number (Canada)) Each legal entity in Canada requires a business number. RELEASED WARNING
Inconsistency between Business Number and GST number (Canada) The Canadian business number consists of 9 digits. The GST number in Canada is composed as follows: XXXXXXXXX RT YYYY whereby
  • X: is exactly the 9 digit business number
  • RT indicates that we are dealing with a GST number
  • Y: a four digit number (e.g. 0001, 0002). There could be more than exactly 1 GST number, e.g. when an entity has two separate businesses. Then the first business has the GST number with suffix 0001, and the second 0002, etc.

This rule checks whether there is a GST number and a business number, and whether the first 9 digits of the GST number are identical to the 9 digits of the business number. If this is not the case then either the GST or the business number are considered invalid.

RELEASED ERROR
Invalid checksum of BN CA (Canada) The Canadian Business number consists of exactly 9 digits. It is important to be correct as it is used as part of the GST/HST number as well. For these 9 digits the checkdigit is calculated in the following way:
  • a) Add all odd digits, except the 9th one,
  • b) String all even digits together and multiply by 2

,

  • c) Add all digits from the result b. together

,

  • d) Add the result of a. and c. together

,

  • e) Subtract the result of d. from the nearest 10 digit.
  • The result of e. must equal the 9th digit.
RELEASED ERROR