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:
- log in to your Instance
- Go to Admin Tool- Company Settings
- Company System and Logo Settings
- 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