WorkersPhotoLinks
The view that returns hyperlink references to worker photos that are stored within ADP systems. This view allows applications and reports to reference image assets without embedding the image data directly.
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 WorkersPhotoLinks WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPhotoLinks WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPhotoLinks 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 photo link record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker associated with the photo link. This field ensures consistent linkage between HR records and digital media references. |
| CanonicalUri | String | The canonical uniform resource identifier (URI) that defines the permanent, preferred reference location for the worker's photo. This field ensures that HR systems and external integrations consistently reference the same image asset. | |
| EncType | String | The encoding type that specifies the format that is used for the worker's photo data (for example, multipart/form-data or base64). This field supports secure file handling and consistent data transmission. | |
| Href | String | The hyperlink reference (HREF) that provides the direct path or endpoint for accessing the worker's photo. This field enables HR systems to retrieve or display the image dynamically. | |
| MediaType | String | The media type that defines the format of the photo file (for example, image/jpeg, or image/png). This field ensures compatibility across HR applications, portals, and downstream systems. | |
| Method | String | The HTTP method that is used to interact with the photo resource (for example, GET, POST, or PUT). This field supports standardized integration behavior between HR and external systems. | |
| PayLoadArguments | String | The arguments or parameters that are required to execute the method defined for the photo link. This field supports secure API interaction and automated image management workflows. | |
| Rel | String | The relationship type that defines how the linked-photo resource relates to the worker record (for example, self, edit, or alternate). This field supports structured linkage and API documentation standards. | |
| Schema | String | The schema that defines the data structure or format for the linked-photo resource. This field supports validation, data integrity, and HR integration consistency. | |
| TargetSchema | String | The schema that is applied to the destination system or endpoint where the photo link resolves. This field ensures format compatibility between HR systems and external integrations. | |
| Title | String | The title or descriptive label assigned to the photo link. This field supports human-readable identification within HR dashboards, reports, and user interfaces. | |
| AsOfDate | Date | The date that defines when this photo-link record became effective. This field supports version control, auditing, and compliance tracking for HR data accuracy. |