---
title: Specifying a unique ID database column
description: PingFederate uses the database column you specify on the Unique ID tab to check whether a user record already exists for the incoming single sign-on (SSO) token.
component: pingfederate
version: 13.1
page_id: pingfederate:administrators_reference_guide:help_userprovisioningtasklet_userprovisioningjdbcuniqueidstate
canonical_url: https://docs.pingidentity.com/pingfederate/13.1/administrators_reference_guide/help_userprovisioningtasklet_userprovisioningjdbcuniqueidstate.html
llms_txt: https://docs.pingidentity.com/pingfederate/llms.txt
docs_for_agents: https://developer.pingidentity.com/build-with-ai/docs-for-agents.md
revdate: July 5, 2022
section_ids:
  about-this-task: About this task
  steps: Steps
---

# Specifying a unique ID database column

PingFederate uses the database column you specify on the **Unique ID** tab to check whether a user record already exists for the incoming single sign-on (SSO) token.

## About this task

![Screenshot of the Unique ID tab showing the Unique ID Column field.](_images/juj1564003517483.jpg)

|   |                                                                                                                                                                           |
| - | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|   | This tab only appears if you have chosen a Microsoft SQL Server datastore on the **User Repository** tab and you selected the **Table** option on the **SQL Method** tab. |

## Steps

* Select a column that represents a unique characteristic about the database entry for a particular user.