WorkersPersonLegalNameTitleAffixCodes
The view that returns title affix codes associated with each worker's legal name (for example, Jr., Sr., or III). This view ensures consistent use of legal name suffixes across Human Resources (HR) and payroll records.
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 WorkersPersonLegalNameTitleAffixCodes WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonLegalNameTitleAffixCodes WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonLegalNameTitleAffixCodes 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 affix record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose legal name includes a title affix. This field ensures consistent linkage between legal naming data and HR records. |
| AffixCode | String | The code that represents the title affix associated with the worker's legal name (for example, PhD, Esq., or MD). This field standardizes the use of post-nominal or honorific titles across HR and official correspondence systems. | |
| AffixCodeLongName | String | The full descriptive name of the title-affix code. This field provides the complete label as it appears in formal HR documentation and government reporting outputs. | |
| AffixCodeShortName | String | The abbreviated version of the title-affix code. This field supports compact display in HR dashboards, data exports, and personnel management systems. | |
| SequenceNumber | Integer | The numeric value that defines the display or processing order of multiple title affixes associated with a single worker. This field ensures correct sequencing and readability in HR systems and reports. | |
| AsOfDate | Date | The date that defines when this title-affix record became effective. This field supports HR auditing, version control, and historical data tracking for compliance purposes. |