WorkersPersonBirthNamePreferredSalutations

The view that returns preferred salutation information that is associated with each worker's birth name. This view standardizes greeting formats (for example, Mr., Ms., or Dr.), which are used in formal Human Resources (HR) and correspondence records.

Table Specific Information

Select

The add-in uses the ADP API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.

AssociateOID supports the '=' comparison.
WorkerID supports the '=' comparison.
AsOfDate supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM WorkersPersonBirthNamePreferredSalutations WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPersonBirthNamePreferredSalutations WHERE WorkerID = 'DRH9M9NPW'

SELECT * FROM WorkersPersonBirthNamePreferredSalutations WHERE AsOfDate = '2020-01-01'

Columns


Name	Type	References	Description
AssociateOID	String	Workers.AssociateOID	The unique identifier (Id) that represents the associate in the HR system. This Id links the preferred salutation record to the correct worker profile.
WorkerID	String	Workers.WorkerID	The Id that identifies the worker for whom the preferred salutation applies. This field ensures consistent linkage across HR, payroll, and personal identification data.
SalutationCode	String		The code that represents the worker's preferred salutation (for example, Mr., Ms., Dr.). This field standardizes naming conventions across HR and business correspondence systems.
SalutationLongName	String		The full descriptive name of the preferred salutation code. This field provides the complete form that appears in formal documentation and communication outputs.
SalutationShortName	String		The abbreviated form of the preferred salutation code. This field provides a concise version for HR interfaces and summary views.
SequenceNumber	Integer		The numeric value that defines the display or processing order of the preferred salutations. This field supports sequencing for workers with multiple valid salutations.
TypeCode	String		The code that categorizes the type of salutation (for example, Birth Name, Legal Name, or Preferred Name). This field supports structured naming classification in HR systems.
TypeCodeLongName	String		The full descriptive name of the type code of the salutation. This field provides the detailed label that appears in HR documentation and data exports.
TypeCodeShortName	String		The abbreviated name that corresponds to the type code of the salutation. This field provides a compact label for internal HR and system displays.
AsOfDate	Date		The date that defines when this preferred salutation record became effective. This field supports historical tracking, auditing, and time-based HR data validation.

Excel Add-In for ADP

WorkersPersonBirthNamePreferredSalutations

Table Specific Information

Select

Columns