WorkersPersonLegalNamePreferredSalutations
The view that returns preferred salutations that are associated with each worker's legal name. This view standardizes how names are displayed in Human Resources (HR) documents, correspondence, and system-generated communications.
Table Specific Information
Select
The connector 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 connector.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersPersonLegalNamePreferredSalutations WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonLegalNamePreferredSalutations WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonLegalNamePreferredSalutations 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 whose legal name includes a preferred salutation. This field ensures proper linkage between the worker's legal naming records and HR systems. |
| SalutationCode | String | The code that represents the worker's preferred salutation for the legal name (for example, Mr., Ms., Dr.). This field standardizes title formatting across HR, payroll, and correspondence systems. | |
| SalutationCodeLongName | String | The full descriptive name of the code for the preferred salutation. This field provides the complete form of the salutation for use in formal HR documentation and communication templates. | |
| SalutationCodeShortName | String | The abbreviated form of the code for the preferred salutation. This field supports concise display in HR dashboards, user interfaces, and data exports. | |
| SequenceNumber | Integer | The numeric value that defines the display or processing order of multiple salutations associated with a single worker. This field supports sequencing in HR systems and formal record presentation. | |
| TypeCode | String | The code that categorizes the salutation type (for example, Legal, Preferred, or Birth Name). This field supports structured classification of naming conventions within HR records. | |
| TypeCodeLongName | String | The full descriptive name of salutation type code. This field provides the detailed label that appears in HR documentation and exports. | |
| TypeCodeShortName | String | The abbreviated name that corresponds to the salutation type code. This field supports compact labeling for HR dashboards and record displays. | |
| AsOfDate | Date | The date that defines when this preferred salutation record became effective. This field supports time-based version control, auditing, and HR data accuracy. |