CZ_DIC (CZ - Tax identification number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/CZ DIC
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key CZ_DIC
The country a linked concept is active or generally relevant for. Country scope CZ (Czechia)
Language-specific name. Monolingual name Danové identifikacní císlo (cs), Tax identification number (en)
Language-specific short name. Monolingual short name CZ - Tax identification number (en)
Informal and comprehensive human-readable definition of a concept. Description A tax number in the Czech Republic consisting of prefix "CZ" followed by 8-10 digits.
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1

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
000000000009KAJJ6AA7G9RVE9 Specifies the allowed formats for the DIC number (Czech Republic) IDENTIFIER_FORMAT
^(CZ)\s*?\.*?-*?(\d\s*\.*-*){8,10}$
0000000000BGWDBG0HD1V5FAWY Specifies how to derive a sole proprietor from a DIC number. The DIC number may have different formats and thus different patterns apply for identifying individuals.
  • 10 digit case: If the number is represented by C1C2C3C4C5C6C7C8C9C10 then
    • C1 and C2 are representing the year of birth and must be in the range 00 - [current year] or 54-99
    • C3 and C4 are representing the month of birth:
      • More than 1 and less than 12 for men
      • or ore than 21 and less than 32 for men
      • or more than 51 and less than 62 for women
      • or more than 71 and less 82 for women.
    • C5 and C6 are representing the day of birth and must be 01 to 31
  • 9 digit case: If the number is represented by C1C2C3C4C5C6C7C8C9 then
    • C1 and C2 are representing the year of birth and must be in the range 00 to 53
    • C3 and C4 are representing the month of birth:
      • More than 1 and less than 12 for men
      • More than 51 and less than 62 for women
    • C5 and C6 are representing the day of birth and must be 01 to 31
NATURAL_PERSON_IDENTIFICATION
to be defined

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 checkdigit invalid (DIC number (Czech Republic)) This rule checks the checkdigit of the DIC number (Czech Republic). RELEASED ERROR
Identifier format inaccurate (DIC number (Czech Republic)) The DIC number (Czech Republic) for legal entities consists of 8 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 situated in the places where they are not expected to be then the rule is violated.

This rule checks the syntax, i.e. format of the DIC number (Czech Republic) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

IDEA INFO
Identifier format invalid (DIC number (Czech Republic)) DIC is a tax number in the Czech Republic consisting of prefix "CZ" followed by 8-10 digits.

This rule checks presence of the "CZ" prefix and exactly 8 digits (or 9 or 10 for legal entities) without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there is no prefix or the prefix is other than "CZ", or if there are less/more digits, unexpected non-digits characters then the rule is violated.

RELEASED ERROR