Reference: Merge Rules for Personal Data Fields

This table illustrates how Workday merges specific fields in the absence or presence of source and target values using particular operations.

These merge rules apply to all person types except employee. When you merge an employee record, you have the option to append data that doesn't match from the source to the target. You can also leave that data on the source.

Field	Source Value?	Target Value?	Operation	Behavior
Sexual Orientation and Gender Identity	Yes	Yes	Last Updated (from Audit)	When functionally equivalent, keep the value on the target if the source and target have matching values for: Expiration Date ID Issuing Authority Identifier ID Issued Date Passport ID Type Visa ID Type
Sexual Orientation and Gender Identity	Yes	Yes	Last Updated (from Audit)	When not functionally equivalent, keep the most recent update on the target if the source and target have unique values for: Expiration Date ID Issuing Authority Identifier ID Issued Date Passport ID Type Visa ID Type
Sexual Orientation and Gender Identity	Yes	No	Last Updated (from Audit)	When not functional equivalent and the source has a value and the target doesn't, keep the source value on the target.
Sexual Orientation and Gender Identity	No	Yes	Last Updated (from Audit)	When not functionally equivalent and the source doesn't have a value and the target does, keep the target value.
Citizenship Status	Yes	Yes	Append	When functionally equivalent, keep the value on the target if the source and target have matching values for: Expiration Date ID Issuing Authority Identifier ID Issued Date Passport ID Type Visa ID Type
Citizenship Status	Yes	Yes	Append	When not functionally equivalent, keep the most recent update on the target if the source and target have unique values for: Expiration Date ID Issuing Authority Identifier ID Issued Date Passport ID Type Visa ID Type
Citizenship Status	Yes	No	Append	When not functional equivalent and the source has a value and the target doesn't, keep the source value on the target.
Citizenship Status	No	Yes	Append	When not functionally equivalent and the source doesn't have a value and the target does, keep the target value.
Date of Birth	Yes	Yes	Last Updated (from Audit)	When functionally equivalent, keep the value on the target if the source and target have matching values for: Expiration Date ID Issuing Authority Identifier ID Issued Date
Date of Birth	Yes	Yes	Last Updated (from Audit)	When not functionally equivalent, keep the most recent update on the target if the source and target have unique values for: Expiration Date ID Issuing Authority Identifier ID Issued Date License Class License Identifier Verification Date Verification by Worker
Date of Birth	Yes	No	Last Updated (from Audit)	When not functionally equivalent and the source has a value and the target doesn't, keep the source value on the target.
Date of Birth	No	Yes	Last Updated (from Audit)	When not functionally equivalent and the source doesn't have a value and the target does, keep the target value.
Date of Death	Yes	Yes	Last Updated (from Audit)	When functionally equivalent, keep the value on the target if the source and target have matching values for: Custom Description Custom ID Type Expiration Date ID Issuing Authority Identifier ID Issued Date Organization
Date of Death	Yes	Yes	Last Updated (from Audit)	When not functionally equivalent, keep the most recent update on the target if the source and target have unique values for: Custom Description Custom ID Type Expiration Date ID Issuing Authority Identifier ID Issued Date Organization
Date of Death	Yes	No	Last Updated (from Audit)	When not functionally equivalent and the source has a value and the target doesn't, keep the source value on the target.
Date of Death	No	Yes	Last Updated (from Audit)	When not functionally equivalent and the source doesn't have a value and the target does, keep the target value.
Gender	Yes	Yes	Last Updated (from Audit)	When functionally equivalent, keep the value on the target if the source and target have matching values for: DHS Document Expiration Date Government ID Type ID Issuing Authority Identifier ID Issuing Agency Issued Date National ID Type Series
Gender	Yes	Yes	Last Updated (from Audit)	When not functionally equivalent, find the most recent update and keep it on the target.
Gender	Yes	No	Last Updated (from Audit)	When not functionally equivalent and the source has a value and the target doesn't, keep the source value on the target.
Gender	No	Yes	Last Updated (from Audit)	When not functionally equivalent and the source doesn't have a value and the target does, keep the target value.
Gender Identity (New)	Yes	Yes	Last Updated (from Audit)	When functionally equivalent, keep the value on the target if the source and target have matching values for: DHS Document Expiration Date Government ID Type ID Issuing Authority Identifier ID Issuing Agency Issued Date National ID Type Series
Gender Identity (New)	Yes	Yes	Last Updated (from Audit)	When not functionally equivalent, keep the most recent update on the target if the source and target have unique values for: DHS Document Expiration Date Government ID Type ID Issuing Authority Identifier ID Issuing Agency Issued Date National ID Type Series
Gender Identity (New)	Yes	No	Last Updated (from Audit)	When not functionally equivalent and the source has a value and the target doesn't, keep the source value on the target.
Gender Identity (New)	No	Yes	Last Updated (from Audit)	When not functionally equivalent and the source doesn't have a value and the target does, keep the target value.
Sexual Orientation (New)	Yes	Yes	Last Updated (from Audit)	When functionally equivalent, keep the value on the target if the source and target have matching values.
Sexual Orientation (New)	Yes	Yes	Last Updated (from Audit)	When not functionally equivalent, find the most recent update and keep it on the target.
Sexual Orientation (New)	Yes	No	Last Updated (from Audit)	When not functionally equivalent and the source has a value and the target doesn't, keep the source value on the target.
Sexual Orientation (New)	No	Yes	Last Updated (from Audit)	When not functionally equivalent and the source doesn't have a value and the target does, keep the target value.
Pronoun (New)	Yes	Yes	Last Updated (from Audit)	When functionally equivalent, keep the value on the target if the source and target have matching values.
Pronoun (New)	Yes	Yes	Last Updated (from Audit)	When not functionally equivalent, find the most recent update and keep it on the target.
Pronoun (New)	Yes	No	Last Updated (from Audit)	When not functionally equivalent and the source has a value and the target doesn't, keep the source value on the target.
Pronoun (New)	No	Yes	Last Updated (from Audit)	When not functionally equivalent and the source doesn't have a value and the target does, keep the target value.