Would anyone know how to check when registering the social security number (person.social_security_number) if it is already registered in the system?
How to avoid duplicating the social security number from another person on a new registration?
Userlevel 6
+26
Hi
You can create a client script or a business rule to validate the existence of the SSN.
Depends on the exact scenario.
Cheers!
+1
The scenario:
Thanks for our prompt reply on my request.
Let me describe the scenario, we are creating a new contact and a new person register and the SSN is a mandatory field, we need to verify the SSN in order to make sure that it is a unique identifier (Like the the Person ID and the Client ID).
We started with the business rule idea.
Maybe someone already have a easier solution for this verification.
Userlevel 6
+26
Hi
You can try to amend the custom metadata of the person table.
Set the column as ‘KEY’ or as ‘UNIQUE’
Cheers!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.