RO_TAX_ID (RO - Personal Numerical Code)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/RO TAX ID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key RO_TAX_ID
The country a linked concept is active or generally relevant for. Country scope RO (Romania)
Language-specific name. Monolingual name Cod Numeric Personal (ro), Personal Numerical Code (en)
Language-specific short name. Monolingual short name RO - Personal Numerical Code (en)
Informal and comprehensive human-readable definition of a concept. Description The Cod Numeric Personal (CNP) is the thirteen-digit Romanian personal numeric code, built from a digit for sex and century of birth, the date of birth, the county code, a serial number and a check digit. It serves as the tax number of a natural person and is used in employment, banking and dealings with the authorities.
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
Regular expression/RO TAX ID/format Validates the format of the Romanian personal numeric code (CNP), the tax number of a natural person, which encodes the sex and century of birth, the date of birth and the county of registration. The pattern accepts thirteen digits beginning with the sex and century digit, followed by a valid date of birth, the county code and a serial number with check digit. IDENTIFIER_FORMAT
^[1-9][0-9]{2}(0[1-9]|1[0-2])(0[1-9]|[12][0-9]|3[0-1])(([0-4][0-9])|(5[0-2])|99)(\d\s*\.*-*){4}$

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 checkdigit invalid (Tax number (Romania))
ACCURACY
RO (Romania) This rule verifies the checksum digit of the Romanian tax number. Every digit of the number is multiplied by the digit in the same position of the constant 279146358279, all these products are added together and the sum is divided by 11. If the remainder is 10 the checksum digit is 1, otherwise it is the remainder itself. A tax number whose checksum digit differs from this result is flagged. ERROR RELEASED(2020-12-28)
Identifier format inaccurate (Tax number (Romania))
REPRESENTATIONAL_CONSISTENCY
RO (Romania) The Romanian tax number consists of thirteen digits. This rule checks whether the value is written exactly in its reference format and flags any whitespace, dot or hyphen it contains. INFO IDEA(2020-01-01)
Identifier format invalid (Tax number (Romania))
REPRESENTATIONAL_CONSISTENCY
RO (Romania) The Romanian tax number is the unique identification code of each citizen. This rule checks the value against the following restrictions: the identifier must be exactly thirteen digits long, the first digit must not be zero, the fourth and fifth digits must lie between 01 and 12, the sixth and seventh digits must lie between 01 and 31, and the eighth and ninth digits must lie between 01 and 52, or be 99. Any breach of these restrictions, disregarding whitespaces, hyphens or dots in the value, results in a rule violation. ERROR RELEASED(2020-01-01)