IT_FISC_ID (IT - Tax Identification Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/IT FISC ID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key IT_FISC_ID
The country a linked concept is active or generally relevant for. Country scope IT (Italy)
Language-specific name. Monolingual name Codice Fiscale. (it), Tax Identification Number (en)
Language-specific short name. Monolingual short name IT - Tax Identification Number (en)
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1
Registration authority Ministry of Economy and Finance

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
REGEXP_0242 Specifies the allowed formats for the Fiscal code (Italy) IDENTIFIER_FORMAT ^((\w\s*\.*-*){6}(\d\s*\.*-*){2}(A
REGEXP_0243 16 characters: "AAABBB11B11C222D", 1-3 letters - surname, 4-6 letters - name, 7-8 digits - date of birth (day), 9th letter - month of birth, 10-11th digits - date of birth (year), 12-15th - town of birth, 16th - check character. NATURAL_PERSON_IDENTIFICATION ^(\w{3})(\w{3})(\d{2})([A-EHLMPRST])(\d{2})(\w{4})(\w{1})$

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 Specifies how critical of the violation of a data quality rule. The following levels are defined:<br/><code>ERROR</code>: The violation (e.g. missing information) puts a process at risk or hinders regular processing of data.<br/><code>WARNING</code>: The violation does not hinder regular processing of data but represents semantically defective data.<br/><code>INFO</code>: The data quality rule has not uncovered a data defect, but some information is available that might be interesting for the user.<br/> Criticality
Identifier Format invalid (Fiscal code (Italy)) STCD1 in Italy can consist either of 11 digits (equal to EU_VAT_ID_IT without prefix "IT") for legal entities or 16 alphanumeric digits for freelancers and natural persons.

Tax Identification Number(Italy) is known as Codice Fiscale and consists of 16 digits of characters, where C1 to C6 Alphabetic, C7, and C8 is Numeric, C9 is Alphabetic, C10, and C11 is Numeric, C12 is Alphabetic, C13 to C15 belongs to Numeric and C16 is the Numeric. C1 C2 C3 - Are letters for the last name. C4 C5 C6 - Are letter for the name. C7 C8 - Are numbers for the year of birth. C9 - Is a letter for the month of birth. C10 C11 -Are numbers for the day of birth and sex. C12 C13 C14 C15 - Are one letter and three numbers for the Italian town or to the foreign state of birth. C16 - Have a supervisory function. It is a checksum digit.

LIVE ERROR
Identifier format inaccurate (Fiscal code (Italy)) STCD1 in Italy can consist either of 11 digits (equal to EU_VAT_ID_IT without prefix "IT") for legal entities or 16 alphanumeric digits for freelancers and natural persons.

Fiscal code (Italy) consists of 16 characters.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 Fiscal code (Italy) with respect to the Fiscal code (Italy)

IDEA INFO
Identifier missing (Fiscal code (Italy)) Each business partner in Italy requires a Fiscal code. LIVE INFO
Invalid checksum of Fiscal code (Italy) This rule checks the checkdigit of the Fiscal code (Italy). This checksum rule should be applied only for the identifier which is 16 characters long. In case of 11 digits the same logic as here shoule be applied: https://meta.cdq.ch/Invalid_checksum_of_EU_VAT_ID_IT_(Italy) for checking the checksum.

The checksum is done in the following way. Starting from the preceding 15 characters, a check digit is determined as follows:

  • the eight odd characters (1st, 3rd, 5th, etc.) are set apart, same thing for the seven even ones (2nd, 4th, 6th, etc.).
  • after that, each single character is converted into a numeric value as show in the tables below:
  • after that, all of the values are to be added up, and the final result has to be divided by 26, the remainder (Modulo) will give the last character, according to the following table:
ERROR