WorkersPersonBirthNameTitlePrefixCodes
The view that returns title prefix codes for worker birth names (for example, Mr., Mrs., or Dr). This view provides standardized title data that is used in employee identification and official reporting.
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 WorkersPersonBirthNameTitlePrefixCodes WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonBirthNameTitlePrefixCodes WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonBirthNameTitlePrefixCodes WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate in the Human Resources (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 birth name includes a title prefix. This field ensures accurate linkage between the worker's legal record and personal identification data in HR systems. |
| PrefixCode | String | The code that represents the title prefix associated with the worker's birth name (for example, Mr., Mrs., Ms., Dr.). This field standardizes naming prefixes across HR records and correspondence templates. | |
| PrefixCodeLongName | String | The full descriptive name of the code for the title prefix. This field provides the complete version of the prefix for use in formal HR documents and reporting outputs. | |
| PrefixCodeShortName | String | The abbreviated form of the code for the title prefix. This field supports compact display in HR user interfaces and communication systems. | |
| 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 in HR data and record presentation. | |
| AsOfDate | Date | The date that defines when this title-prefix record became effective. This field supports time-based version control, auditing, and compliance management for HR data accuracy. |