How Person Records Are Matched

When you create a person record, the application searches if a record already exists with the same details.

How Matching Records Are Identified

The application searches all person records (with the exception of Oracle Recruiting candidates) to find potential matches, based on the enterprise setting in the Person Creation Duplicate Check option.

These are the Person Creation Duplicate Check option settings.

Serial Number	Setting	Will Find Duplicates
1	None	There are no potential matches identified for the new person record.
2	National ID Country-Type-ID	If a person's national identifier matches the national identifier value, country, and type of ID. Note that if the person's national identifier value is null, no duplicates are found.
3	Last Name, First Initial, DOB Or NID Country-Type-ID	If the new person's national identifier matches a person's national identifier within the same country and type, irrespective of whether the names and birth dates match. Alternately, if the last name and the initial of the first name match, and if the new person's birth date matches or either person's birth date is null, irrespective of whether the NID matches or doesn't match or is null.
4	Last Name, First Initial, DOB, Gender Or NID Country-Type-ID	If the new person's national identifier matches a person's national identifier within the same country and type, irrespective of whether the names, gender, and birth dates match. Alternately, if the last name and the initial of the first name do match, and if the new person's birth date and gender match or either person's birth date or gender are null, irrespective of whether the NID matches or doesn't match or is null.
5	Last Name, First Name, DOB, Gender Or NID Country-Type-ID	If the new person's national identifier matches an existing person's national identifier within the same country and type, irrespective of whether the names, gender, and birth dates match. Alternately, if the last name and the first name do match, and if the new person's birth date and gender match or either person's birth date or gender are null, irrespective of whether the NID matches or doesn't match or is null
6	NID	Similar behavior as setting 2 above, except if national identifiers from different countries have matching numbers then additional duplicates may be found.
7	Last Name, First Initial, Date of Birth or National ID	Similar behavior as setting 3 above, except if national identifiers from different countries have matching numbers then additional duplicates may be found. Note that this is the default behavior when no option has been explicitly selected for the check.
8	Last Name, First Initial, Date of Birth, Gender or National ID	Similar behavior as setting 4 above, except if national identifiers from different countries have matching numbers then additional duplicates may be found.
9	Last Name, Full First Name, Date of Birth, Gender or National ID	Similar behavior as setting 5 above, except if national identifiers from different countries have matching numbers then additional duplicates may be found.

Examples of Matching Person records

You're an HR specialist creating this person record:

First Name	Last Name	Date of Birth	National Identifier Country	National Identifier Type	National Identifier Number
John	Ward	25 March 1963	US	Social Security Number	390-89-8128

The application compares these details with those in existing person records and displays these 4 potentially matching person records. By default, the enterprise option is null, which is equivalent to selecting the option which matches last name, first initial, and date of birth, or national ID and its country and its type.

First Name	Last Name	Date of Birth	National Identifier Country-Type-Number
Jennifer	Tyler	19 June 1969	US-SSN-390-89-8128
Juana	Ward	25 March 1963	FR-DL-558743776318
Josie	Ward	25 March 1963	US-SSN-872-19-9398

Let's see which options would find each of these people as potential duplicates, and why:

First Name	Person Creation Duplicate Check Setting	Reason for Match
Jennifer Tyler	Any option except None	Though the first name, last name, and date of birth don't match, still Jennifer's person record qualifies as a potential match with John due to the match of the national ID and its country and its type
Juana Ward	Either of the above options that check first name initial but not full first name.	Though the national identifiers don't match, still Juana's person record qualifies as a potential match with John due to the following reasons: Same last name as John Ward Same date of birth as John Ward First name starts with same character
Josie Ward	Either of the options that check first name initial but not full first name.	Though the national identifiers don't match, still Josie's person record qualifies as a potential match with John due to the following reasons: Same last name as John Ward First name starts with the same character Same date of birth as John Ward

First Name

Person Creation Duplicate Check Setting

Reason for Match

Jennifer Tyler

Any option except None

Though the first name, last name, and date of birth don't match, still Jennifer's person record qualifies as a potential match with John due to the match of the national ID and its country and its type

Juana Ward

Either of the above options that check first name initial but not full first name.

Though the national identifiers don't match, still Juana's person record qualifies as a potential match with John due to the following reasons:

Same last name as John Ward
Same date of birth as John Ward
First name starts with same character

Josie Ward

Either of the options that check first name initial but not full first name.

Though the national identifiers don't match, still Josie's person record qualifies as a potential match with John due to the following reasons:

Same last name as John Ward
First name starts with the same character
Same date of birth as John Ward