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 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 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. |