Symptom
Add Italy “National ID or Fiscal Code”
Environment
Employee Central
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 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 check-box 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 check-box is enabled then:
Valid values should be as per the logic defined for the respective country.
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 then validation should be thrown.
Enable validation:
- Login 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 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>
Logic:
Position 1 to 3
Surname (3 letters): the first three consonants of the surname are used
Position 4 to 6
First name (3 letters): the first three consonants of the name are used
Position 7 and 8
Year of birth – last two digits of year of birth
Position 9
Month
Position 10 and 11
Day of birth - if the person is a female, 40 is added
Position 12 to 15
Commune of birth – not validated so random numbers / char are accepted.
Position 16
Check digit
Keywords
Italy
National Identity
Fiscal Code
ECT-65351 : Commune of Birth- Italy National ID Validation , KBA , LOD-SF-EC-BCI , Manage Business Configuration (BCUI) & Data Models (XML) , Problem