Symptom
For the Belgium “National Register Number” the following format shall be provided in the system:
Display format: YY.NN.NN-NNN.NN
Regular Expression: [\d]{2}.[\d]{2}.[\d]{2}-[\d]{3}.[\d]{2}
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.
Environment
SAP SuccessFactors Employee Central
Resolution
Validation Details:
The National Register Number consists of 11 digits:
- First 6 digits: date of birth YYMMDD
Note: For persons whose complete date of birth cannot be determined based on official documents, only the year of birth is taken into account followed by a sequential number i.e. 560000, 560001, 560002,…
- Next 3 digits: day counter for the births (even = female, odd = male)
- Last 2 digits: check digit
To verify if the national register number is correct, the ‘check digit’ of the number has to be determined.
The check digit (A) is a number of two digits and corresponds to the difference between 97 and the modulo 97 of the value B, which is determined as:
- For persons born until 31/12/1999 (see first 6 digits of the number, YYMMDD):
First 9 digits of the national register number (Y)
- For persons born since 01/01/2000 (see first 6 digits of the number, YYMMDD):
Concatenation of the value ‘2’ with the first 9 digits of the national register number
Support Engineer Action:
Add below information to customer Country Specific XML for Succession Data Model
<country id="BEL">
<format-group id="national-id">
<format id="NationalRegisterNumber">
<instruction>National Register Number</instruction>
<instruction xml:lang="en-GB">National Register Number</instruction>
<instruction xml:lang="fr-FR">Numéro de registre national</instruction>
<display-format>YY.NN.NN-NNN.NN</display-format>
<reg-ex>[\d]{2}.[\d]{2}.[\d]{2}-[\d]{3}.[\d]{2}</reg-ex>
</format>
</format-group>
</country>
Customer Action:
- Login to your Instance
- Go to Admin Tool- Company Settings
- Company System and Logo Settings
- Enable " Enable National ID"
Steps 3: Maintain Test user "Date of Birth" and "Gender"
- Go to Admin Tool
- Navigate to a test user Personal Information Portlet
- In Biographical Information add is : Date of Birth
- In Personal Information add is : Gender
Steps 4: Maintain Test user National Id Information:
- Enter a valid: National Register Number
- Save
Keywords
Belgium, deep validation for Belgium National Register Number, National Identity, country/region-specific , KBA , LOD-SF-EC-PER-NAT , National ID - Config, Rules, RBP, UI , Problem