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 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 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. |