WorkersWorkAssignmentsLinks
The view that returns link data that is associated with worker assignments. This view identifies related entities (for example, departments or projects), enabling relational navigation between worker records and organizational structures.
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 WorkersWorkAssignmentsLinks WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsLinks WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsLinks WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate linked to the record for the work-assignment link. This field supports Human Resources (HR) record management, data synchronization, and system-to-system integration. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose assignment is linked through this record. This field supports HR communication tracking, relationship mapping, and record consistency across integrated systems. |
| CanonicalUri | String | The canonical uniform resource identifier (URI) that provides a permanent, system-recognized reference to the work assignment resource. This field supports consistent HR data retrieval and cross-application linking. | |
| EncType | String | The encoding type that is used to specify how the linked resource's data is formatted. This field supports secure data exchange, HR system compatibility, and compliance with integration standards. | |
| Href | String | The hyperlink reference (HREF) that defines the target location of the linked work-assignment resource. This field supports HR system navigation, automated data queries, and integration with external APIs. | |
| MediaType | String | The media type that describes the format of the linked resource (for example, application/json or text/xml). This field supports HR system interoperability and ensures that linked data is processed correctly. | |
| Method | String | The method that is used to interact with the linked resource (for example, GET, POST, PUT, or DELETE). This field supports HR application programming interface (API) operations and data synchronization workflows. | |
| PayLoadArguments | String | The parameters that are passed in the payload when interacting with the linked resource. This field supports HR data exchange, secure system calls, and automation of workflow processes. | |
| Rel | String | The relationship type that defines how the current work-assignment record is related to the linked resource (for example, self, next, or previous). This field supports HR data modeling and relational mapping across systems. | |
| Schema | String | The schema that defines the data structure of the linked resource. This field supports HR integration consistency, system validation, and data governance. | |
| TargetSchema | String | The schema that is targeted by the link when the associated resource is called or retrieved. This field supports HR data exchange, system mapping, and schema-level validation. | |
| Title | String | The title or label that describes the linked work-assignment resource. This field supports HR documentation, user interface display, and accessibility in linked data environments. | |
| AsOfDate | Date | The date that defines when the link record became effective. This field supports HR auditing, historical recordkeeping, and synchronization across integrated systems. |