WorkersWorkAssignmentsAssignedWorkLocations
The view that returns assigned work location data for worker assignments. This view tracks where employees perform their duties, supporting payroll tax jurisdiction and location-based reporting.
Table Specific Information
Select
The server 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 server.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocations WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocations WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocations 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 assigned work location. This field supports Human Resources (HR) record management, payroll processing, and location-based reporting. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose assignment includes this work location. This field ensures accurate HR and payroll association with location-specific data. |
| AddressAttentionOfName | String | The name of the individual or department that should receive correspondence at this address. This field supports HR documentation, worksite routing, and organizational communication. | |
| AddressBlockName | String | The name of the neighborhood or block where the work location is situated. This field supports HR site mapping and regional analysis. | |
| AddressBuildingName | String | The name of the building where the worker is assigned. This field supports HR workplace identification and facility tracking. | |
| AddressBuildingNumber | String | The number assigned to the building where the worker performs duties. This field supports HR address validation and location management. | |
| AddressCareOfName | String | The name of the person or department designated to receive communications on behalf of the worker or organization. This field supports HR correspondence and logistical accuracy. | |
| AddressCityName | String | The city where the assigned work location is situated. This field supports HR reporting, payroll tax jurisdiction, and regulatory compliance. | |
| AddressCountryCode | String | The code that identifies the country of the assigned work location (for example, US, CA, or MX). This field supports HR international operations and payroll taxation rules. | |
| AddressCountrySubdivisionLevel1CodeValue | String | The code that identifies the primary administrative division of the country (for example, state or province). This field supports HR regional compliance and location reporting. | |
| AddressCountrySubdivisionLevel1LongName | String | The full descriptive name of the primary country subdivision (for example, California or Ontario). This field provides context for HR documentation and payroll reporting. | |
| AddressCountrySubdivisionLevel1ShortName | String | The abbreviated name of the primary country subdivision. This field supports compact HR and payroll reporting. | |
| AddressCountrySubdivisionLevel1SubdivisionType | String | The type of administrative division represented by the subdivision code (for example, State, Province, or Territory). This field supports HR and payroll classification. | |
| AddressCountrySubdivisionLevel2CodeValue | String | The code that identifies the secondary subdivision within the country (for example, county or district). This field supports HR site management and regional reporting. | |
| AddressCountrySubdivisionLevel2LongName | String | The full descriptive name of the secondary subdivision. This field supports HR address clarity and local compliance reporting. | |
| AddressCountrySubdivisionLevel2ShortName | String | The abbreviated name of the secondary subdivision. This field supports compact HR recordkeeping and address display. | |
| AddressCountrySubdivisionLevel2SubdivisionType | String | The type of administrative level represented by the secondary subdivision (for example, County, District, or Municipality). This field supports HR and payroll classification. | |
| AddressDeliveryPoint | String | The delivery point designation within the address (for example, a mail stop or internal routing code). This field supports HR correspondence accuracy and logistics management. | |
| AddressDoor | String | The specific door number or identifier used for the work location. This field supports HR facility access tracking and mail delivery accuracy. | |
| AddressFloor | String | The floor number or designation where the worker's office or workspace is located. This field supports HR workspace management and emergency planning. | |
| AddressGeoCoordinateLatitude | Integer | The latitude coordinate of the assigned work location. This field supports HR mapping, safety planning, and compliance with geographic regulations. | |
| AddressGeoCoordinateLongitude | Integer | The longitude coordinate of the assigned work location. This field supports HR mapping, reporting, and compliance management. | |
| AddressLineFive | String | The fifth line of the street address used to provide extended address information. This field supports HR address precision and formatting for international locations. | |
| AddressLineFour | String | The fourth line of the street address used for supplemental information. This field supports HR mail routing and location identification. | |
| AddressLineOne | String | The first line of the street address. This field typically contains the primary building number and street name and supports HR record accuracy and postal compliance. | |
| AddressLineThree | String | The third line of the street address. This field supports HR documentation for extended address details such as suite or unit numbers. | |
| AddressLineTwo | String | The second line of the street address used for additional address elements (for example, floor or department). This field supports HR address completeness and verification. | |
| AddressNameCode | String | The code that identifies the name of the assigned address record. This field supports HR and payroll reference linking for address records. | |
| AddressNameCodeLongName | String | The full descriptive name of the address code. This field supports HR data clarity and location-based reporting. | |
| AddressNameCodeShortName | String | The abbreviated name that corresponds to the address code. This field supports compact HR reporting and system exports. | |
| AddressPlotID | String | The Id that identifies the plot or lot on which the building or facility is located. This field supports HR facility management and geographic recordkeeping. | |
| AddressPostalCode | String | The postal or ZIP code associated with the work location. This field supports HR regional tax assignment and payroll processing. | |
| AddressPostOfficeBox | String | The post office box (PO) number for the work location. This field supports HR mailing address validation and correspondence tracking. | |
| AddressScriptCodeValue | String | The code that identifies the script used in the address representation (for example, Latin, Cyrillic, or Arabic). This field supports HR internationalization and multilingual recordkeeping. | |
| AddressScriptCodeLongName | String | The full descriptive name of the address script code. This field supports HR documentation and data interoperability. | |
| AddressScriptCodeShortName | String | The abbreviated name that corresponds to the address script code. This field supports compact HR and payroll data exports. | |
| AddressStairCase | String | The stair or staircase identifier used within the building address. This field supports HR location identification and safety management. | |
| AddressStreetName | String | The name of the street where the assigned work location is located. This field supports HR address validation and payroll jurisdiction mapping. | |
| AddressStreetTypeCode | String | The code that identifies the type of street (for example, Avenue, Boulevard, or Road). This field supports HR address formatting and standardization. | |
| AddressStreetTypeCodeLongName | String | The full descriptive name of the type code for the street. This field supports HR address validation and documentation. | |
| AddressStreetTypeCodeShortName | String | The abbreviated name that corresponds to the type code for the street. This field supports compact HR address display. | |
| addressUnit | String | The unit number, apartment, or suite designation for the work location. This field supports HR workspace assignment and address completeness. | |
| CommunicationEmails | String | The collection of email addresses associated with the assigned work location. This field supports HR contact routing and facility-level notifications. | |
| CommunicationFaxes | String | The collection of fax numbers associated with the assigned work location. This field supports HR document transmission and business communication. | |
| CommunicationLandlines | String | The collection of landline telephone numbers associated with the assigned work location. This field supports HR and payroll contact reference. | |
| CommunicationMobiles | String | The collection of mobile numbers associated with the assigned work location. This field supports HR emergency communication and accessibility. | |
| CommunicationPagers | String | The collection of pager numbers associated with the assigned work location. This field supports HR legacy communication and internal alerting systems. | |
| ItemID | String | The Id that represents the assigned work-location record. This field supports HR and payroll linkage to location-specific data. | |
| NameCode | String | The code that identifies the name assigned to the work location (for example, Main Office, Warehouse, or HQ North). This field supports HR facility tracking and payroll reporting. | |
| NameCodeLongName | String | The full descriptive name of the work location. This field provides clarity in HR and payroll documentation. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the work location. This field supports compact HR and payroll reporting. | |
| AsOfDate | Date | The date that defines when the assigned work-location record is effective. This field supports HR historical tracking, payroll synchronization, and compliance management. |