WorkersPersonLegalNameTitlePrefixCodes
The view that returns title prefix codes that are associated with each worker's legal name (for example, Mr., Mrs., or Dr). This view supports proper formatting of names in official Human Resources (HR) and payroll documentation.
Table Specific Information
Select
The provider 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 provider.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersPersonLegalNameTitlePrefixCodes WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonLegalNameTitlePrefixCodes WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonLegalNameTitlePrefixCodes 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 title-prefix record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose legal name includes a title prefix. This field ensures consistent linkage between the worker's legal naming information and HR records. |
| AffixCode | String | The code that represents the title prefix associated with the worker's legal name (for example, Mr., Mrs., Ms., Dr.). This field standardizes name prefixes across HR systems, correspondence templates, and formal documentation. | |
| AffixCodeLongName | String | The full descriptive name of the title-prefix code. This field provides the complete form of the prefix as it appears in official HR documentation and communication outputs. | |
| AffixCodeShortName | String | The abbreviated version of the title-prefix code. This field supports compact display in HR dashboards, data exports, and internal system interfaces. | |
| SequenceNumber | Integer | The numeric value that defines the display or processing order of multiple prefixes that are associated with a single worker. This field supports sequencing and formatting consistency across HR systems. | |
| AsOfDate | Date | The date that defines when this title-prefix record became effective. This field supports auditing, version control, and compliance tracking for HR data accuracy. |