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 Tax number (Individual's Cod Numeric Personal (CNP), or Personal Numeric Code) a unique identifying number in Romania which is created by using the citizen's gender and century of birth (1/3/5/7 for male, 2/4/6/8 for female and 9 for foreign citizen), date of birth (six digits, YYMMDD), the country zone (two digits, from 01 to 52, or 99), followed by a serial number (3 digits), and finally a checksum digit.

CNP number consists of 13 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
00000000004QCT3E8TN2ZGM2ST Specifies the allowed formats for the Tax number (Romania) 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

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 (Tax number (Romania)) This rule checks the checksum of the Tax number in Romania.

To calculate the checksum digit, every digit from CNP is multiplied with the corresponding digit in number 279146358279, the sum of all these multiplications is then divided by 11.

If the remainder is 10 then the checksum digit is 1, otherwise it's the remainder itself.

Any difference result in a rule violation.

RELEASED ERROR
Identifier format inaccurate (Tax number (Romania)) Tax number in Romania consists of 13 digits. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, dots or hyphens then the rule is violated.

This rule checks the syntax, i.e. format of the Tax number (Romania) 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 (Tax number (Romania)) Tax number (Romania) is a unique identification code for each citizen. This rule checks the identifier's format wiht respect to the following restrictions:

1) lenth of the identifier should be exactly 13 digits, 2) first digit cannot be zero, 3) 4th and 5th digits should be in a range [01:12], 4) 6th i 7th digits shouldbe in arange [01:31], 5) 8th and 9th digits should be in a range [01:52] or 99.

Violation of the above mentioned restrictions without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value result in arue violation.

RELEASED ERROR