WorkersPersonBirthNameTitleAffixCodes
The view that returns title affix codes for worker birth names (for example, Jr., Sr., or III). This view ensures legal name accuracy and consistent representation of personal Ids across Human Resources (HR) and payroll systems.
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 WorkersPersonBirthNameTitleAffixCodes WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonBirthNameTitleAffixCodes WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonBirthNameTitleAffixCodes 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 birth name includes a title affix. This field ensures proper linkage between the worker record and naming attributes in HR systems. |
| AffixCode | String | The code that represents the title affix associated with the worker's birth name (for example, Dr., Sir, Lady). This field standardizes naming titles used in formal and regulatory documentation. | |
| AffixCodeLongName | String | The full descriptive name of the code for the title affix. This field provides the complete title as it appears in legal or formal HR records. | |
| AffixCodeShortName | String | The abbreviated form of the code for the title affix. This field supports compact display in HR systems, reports, and interfaces. | |
| SequenceNumber | Integer | The numeric value that determines the display or processing order when multiple title affixes are associated with a single worker. This field ensures proper sequencing in HR and compliance records. | |
| AsOfDate | Date | The date that defines when this title-affix information became effective. This field supports time-based auditing, version control, and regulatory compliance tracking within HR systems. |