WorkAssignmentHistoryAssignedWorkLocations
The view that returns the historical record of work locations that are assigned to each associate's work assignment. This view captures location transfers, remote-work changes, and other location-based adjustments that are relevant for payroll taxation and compliance tracking.
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate assigned to this work location. This Id links the work-location record to the correct worker profile within Human Resources (HR) and payroll systems. |
| AddressScriptCode | String | The code value that identifies the address script or format that is used for the assigned work location. This field ensures address data is formatted consistently according to regional or country standards. | |
| AddressShortName | String | The abbreviated name that corresponds to the address script code. This field provides a short label used in system configuration, reports, and address formatting. | |
| AddressLongName | String | The full descriptive name of the address script code. This field provides the complete label that appears in HR, payroll, and location management reports. | |
| AddressLineFour | String | The fourth line of the assigned work-location address. This field stores additional address details that are used for extended delivery or routing information. | |
| AddressLineFive | String | The fifth line of the assigned work-location address. This field is available for supplemental details that support complex or multi-part address structures. | |
| AddressBuildingNumber | String | The number that identifies the specific building at the work location. This field is used for mail delivery, navigation, and compliance reporting. | |
| AddressBuildingName | String | The name of the building associated with the assigned work location. This field identifies the physical structure used for HR reporting and facility management. | |
| AddressBlockName | String | The block, district, or development name in which the building is located. This field provides regional context for mapping and logistical purposes. | |
| AddressStreetName | String | The name of the street where the assigned work location is situated. This field provides the primary street Id used in mailing, mapping, and compliance reporting. | |
| AddressStreetTypeCode | String | The code value that identifies the type of street (for example, Avenue, Road, or Boulevard). This field defines the classification of the street in the address record. | |
| AddressStreetTypeShortName | String | The abbreviated name that corresponds to the street type code. This field provides a short label for dashboards and address summaries. | |
| AddressStreetTypeLongName | String | The full descriptive name of the street type code. This field provides the complete label used in HR, payroll, and facilities reports. | |
| AddressUnit | Integer | The unit number or Id within the building. This field identifies the suite, apartment, or office number used for correspondence and site access. | |
| AddressFloor | String | The floor number or designation within the building. This field identifies where the associate's workspace or department is located. | |
| AddressStairCase | String | The stairwell or section Id in a multi-unit building. This field supports internal wayfinding and emergency planning documentation. | |
| AddressDoor | String | The door or room Id for the assigned work location. This field provides specific access information for internal navigation or security records. | |
| AddressPostOfficeBox | String | The post office (PO) box number that is used for correspondence if the work location receives mail through a PO box instead of a physical address. | |
| AddressDeliveryPoint | String | The designated delivery point or routing code for mail delivery. This field ensures accurate and efficient postal distribution. | |
| AddressPlotID | String | The unique plot or parcel Id assigned to the property. This field supports mapping, facility management, and land use documentation. | |
| AddressCountrySubdivisionLevel2 | String | The code value that identifies the second-level country subdivision (for example, County, District, or Municipality). This field supports regional and compliance reporting. | |
| AddressCountrySubdivisionLevel2ShortName | String | The abbreviated name that corresponds to the second-level country subdivision. This field provides a short label used in dashboards and reports. | |
| AddressCountrySubdivisionLevel2LongName | String | The full descriptive name of the second-level country subdivision. This field provides the complete label for HR and geographic reports. | |
| AddressCountrySubdivisionLevel2Type | String | The type of administrative division represented by the second-level country subdivision (for example, County, District, or Province). This field clarifies jurisdictional context. | |
| AddressCountrySubdivisionLevel1 | String | The code value that identifies the first-level country subdivision (for example, State, Province, or Region). This field supports geographic, tax, and compliance reporting. | |
| AddressCountrySubdivisionShortName | String | The abbreviated name that corresponds to the first-level country subdivision. This field provides a short label for use in dashboards and address summaries. | |
| AddressCountrySubdivisionLongName | String | The full descriptive name of the first-level country subdivision. This field provides the complete label for HR, payroll, and compliance reports. | |
| AddressCountrySubdivisionType | String | The type of administrative division represented by the first-level country subdivision (for example, State, Province, or Territory). This field defines the jurisdictional level for reporting purposes. | |
| AddressNameCode | String | The code value that identifies the name or reference label for the address (for example, Headquarters, Branch Office, or Remote Site). This field defines the purpose of the assigned location. | |
| AddressNameShortName | String | The abbreviated name that corresponds to the address name code. This field provides a concise label for dashboards and location management tools. | |
| AddressNameLongName | String | The full descriptive name of the address name code. This field provides a complete label for HR, payroll, and organizational reports. | |
| AddressAttentionOfName | String | The name of the individual or department to whose attention correspondence should be sent. This field supports personalized delivery and contact accuracy. | |
| AddressCareOfName | String | The name of the individual or entity under whose care the address is maintained. This field is used for third-party or alternate mailing arrangements. | |
| AddressLineOne | String | The first line of the assigned work-location address. This field typically contains the building number and street name. | |
| AddressLineTwo | String | The second line of the assigned work-location address. This field is used for apartment, suite, or floor information. | |
| AddressLineThree | String | The third line of the assigned work-location address. This field supports extended address details for multi-tenant or complex buildings. | |
| AddressCityName | String | The name of the city, town, or municipality in which the assigned work location resides. This field supports payroll tax jurisdiction and compliance reporting. | |
| AddressCountryCode | String | The ISO country code that identifies the country of the assigned work location (for example, US, CA, or GB). This field supports global payroll and workforce analytics. | |
| AddressPostalCode | String | The postal or ZIP code for the assigned work location. This field is used for mail delivery, tax, and compliance reporting. | |
| AddressLatitude | Double | The latitude coordinate of the assigned work location. This field provides geospatial reference for mapping and workforce distribution analysis. | |
| AddressLongitude | Double | The longitude coordinate of the assigned work location. This field provides the complementary geospatial reference for mapping and audit tracking. | |
| NameCode | String | The code value that identifies the name of the assigned work location. This field defines the specific work site or facility associated with the worker's assignment (for example, Corporate HQ, Distribution Center, or Field Office). | |
| NameShortName | String | The abbreviated name that corresponds to the assigned work-location name code. This field provides a short label used in HR dashboards, reports, and analytics tools. | |
| NameLongName | String | The full descriptive name of the assigned work-location name code. This field provides the complete label used in HR documentation, payroll systems, and workforce planning reports. |