Skip to main content
Question

FSM 6 - Person - How to avoid registering duplicate Social Security Number ?

  • January 24, 2024
  • 3 replies
  • 37 views

Forum|alt.badge.img+1

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?

3 replies

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • January 25, 2024

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!


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Employee)
  • January 25, 2024

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.


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • January 29, 2024

Hi @Fbarreiro 

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

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

Cheers!