WorkersPhotos
The view that returns worker photos that are stored in ADP. This view provides image data that is associated with worker profiles for use in identification, security systems, and Human Resources (HR) applications.
Table Specific Information
Select
The driver 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 driver.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersPhotos WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPhotos WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPhotos 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 worker's photo record to the correct HR profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker associated with the stored photo. This field ensures consistent linkage between the worker's image and personal record across HR systems. |
| ItemID | String | The Id that uniquely identifies the specific photo record. This field supports version control, auditing, and tracking of multiple image instances associated with a single worker. | |
| Links | String | The collection of hyperlinks that provide access to the worker's photo resources (for example, view, edit, or download). This field supports integration with HR portals and external systems. | |
| NameCode | String | The code that categorizes the type or purpose of the worker's photo (for example, Badge, Profile, or Official). This field supports structured data management within HR systems. | |
| NameCodeLongName | String | The full descriptive name of the photo type code. This field provides the complete label that appears in HR reports, documentation, and data exports. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the photo type code. This field supports compact display in HR dashboards, forms, and user interfaces. | |
| AsOfDate | Date | The date that defines when this photo record became effective. This field supports time-based version control, auditing, and HR compliance tracking. |