Skip to main content

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?

Hi @Fbarreiro 

You can create a client script or a business rule to validate the existence of the SSN.

Depends on the exact scenario.

Cheers!


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.


Hi @Fbarreiro 

You can try to amend the custom metadata of the person table.

Set the column as ‘KEY’ or as ‘UNIQUE’ 

Cheers!


Reply