SAP Knowledge Base Article - Public

2413962 - Validation criteria for Italy National ID Or Fiscal Code

Symptom

Add Italy “National ID or Fiscal Code”

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

Employee Central - National ID

Resolution

Italy “National ID or Fiscal Code” the following format shall be provided in the system:

Display format: AAAAAAYYANNXXXXA

Regular Expression: [A-Z]{6}[\d]{2}[A-Z]{1}[\d]{2}[A-Z 0-9]{4}[A-Z]{1}

The following format changes need to be completed in the country/region-specific XML for Succession Data Model.

To have this change completed, please log a ticket with Support Engineer, SAP Product Support support

 

Deep Validation logic:

If National ID deep validation checkbox is not enabled then:

Valid values should be as per the regular expression format in CSF SDM.
For Invalid values - validation should be thrown to match the regular expression values.
 If National ID deep validation checkbox is enabled then:

Valid values should be as per the logic defined for the respective country/region.
If a valid matching the regular expression as per CSF SDM is updated, but that value doesn't match the logic defined for that country/region then validation should be thrown.

Enable validation:

  1. log in to your Instance
  2. Go to Admin Tool- Company Settings
  3. Company System and Logo Settings
  4. Enable " Enable National ID"

Employee Central Support Engineer Action:

Add below information to customer country/region-specific XML for Succession Data Model

<country id="ITA">
<format-group id="national-id">
<format id="FC">
<instruction>FC- Fiscal Code</instruction>
<display-format>AAAAAAYYANNXXXXA</display-format>
<reg-ex>[A-Z]{6}[\d]{2}[A-Z]{1}[\d]{2}[A-Z 0-9]{4}[A-Z]{1}</reg-ex>
</format>
</format-group>
</country>

 

Calculating the Algorithm

Digits 1-3: The first three consonants of the surname

Digits 4-6: The first three consonants of the first name

Digits 7-8: The last two digits of the year of birth

Digit 9: Month represented by a letter:

A=January B=February C=March D=April E=May H=June L=July M=August P=September R=October S=November T=December

Digits 10-11: Day of birth. If the individual is female, 40 is added to the number.

Digits 12-15: Commune of birth. These digits are not validated, so random characters are accepted.

Digit 16: Check Digit, calculated as follows:

The eight odd digits (1st, 3rd, 5th and so on) are grouped together.

The eight even digits (2nd, 4th, 6th and so on) are grouped together.

Then, each digit is converted into a numeric value as follows (Character=Value):

Odd Characters

0=1, 1=0, 2=5, 3=7, 4=9, 5=13, 6=15, 7=17, 8=19, 9=21, A=1, B=0, C=5, D=7, E=9, F=13, G=15, H=17, I=19, J=21, K=2, L=4, M=18, N=20, O=11, P=3, Q=6, R=8, S=12, T=14, U=16, V=10, W=22, X=25, Y=24, Z=23

Even Characters

0=0, 1=1, 2=2, 3=3, 4=4, 5=5, 6=6, 7=7, 8=8, 9=9, A=0, B=1, C=2, D=3, E=4, F=5, G=6, H=7, I=8, J=9, K=10, L=11, M=12, N=13, O=14, P=15, Q=16, R=17, S=18, T=19, U=20, V=21, W=22, X=23, Y=24, Z=25

Finally, add all the values together and divide the final result by 26. The remainder will give the final digit based on the following (Remainder=Digit):

0=A, 1=B, 2=C, 3=D, 4=E, 5=F, 6=G, 7=H, 8=I, 9=J, 10=K, 11=L, 12=M, 13=N, 14O, 15=P, 16=Q, 17=R, 18=S, 19=T, 20=U, 21=V, 22=W, 23=X, 24=Y, 25=Z

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Guide: Country/Region-Specifics for Employee Central

Chapter: Validation Rules - Italy 

See Also

  • 2413032 - Rule On Display Name field (How to)
  • 2977339 - How To Configure Onchange Rule To Set one Field to Required When Selecting National ID Card Type
  •  2601647 - Is it possible to add National ID deep validation to custom national IDs?
  • 2668688 - National ID Card: How to create custom Regular Expression and Display Format
  • 2093378 - National ID validation issues - Employee Central

Keywords

Italy, National Identity, Fiscal Code, ECT-65351, Commune of Birth- Italy National ID Validation, Validation Rules - Italy , KBA , LOD-SF-EC-BCI , Manage Business Configuration (BCUI) & Data Models (XML) , Problem

Product

SAP SuccessFactors HCM Core 1611