ODBC Driver for ADP

Build 25.0.9434

WorkAssignmentHistoryCommunicationsLandlines

The view that returns historical landline communication details that are associated with work assignments. This view records telephone contact numbers that were active during prior assignment periods for reference and compliance reporting.

Columns

Name Type References Description
Access String The access code or prefix that is used to initiate a landline telephone call. This field defines the dialing sequence that is required before the main number (for example, 9 for an outside line).
AreaDialing String The area dialing code that identifies the regional telephone area. This field is used to route calls correctly within a country or region (for example, 212 for New York or 213 for Los Angeles).
CountryDialing String The international country dialing code that identifies the country of the landline number (for example, 1 for the United States or 44 for the United Kingdom). This field ensures proper routing for international calls.
DialNumber String The full landline telephone number that is dialed after the access, area, and country codes. This field represents the worker's contact number that is stored for Human Resources (HR) and communication purposes.
Extension String The internal extension number that routes the call to a specific department or desk within the organization. This field supports internal dialing for shared phone systems.
FormattedNumber String The fully formatted version of the landline telephone number that includes access, area, country, and extension details. This field provides a standardized format for HR reports and communication directories.
ItemID String The unique identifier (Id) that represents the individual landline communication record within the worker's contact history. This Id is used to track and audit phone records over time.
NameCode.codeValue String The code value that identifies the classification of the landline number. This field defines the purpose or context of the phone record (for example, Work, Home, or Department).
NameCode.longName String The full descriptive name of the landline number type code. This field provides the complete label that appears in HR communication reports and directories.
NameCode.shortName String The abbreviated name that corresponds to the landline-number type code. This field provides a concise label for dashboards, reports, and HR analytics.
AssociateOID String

Workers.AssociateOID

The Id that represents the associate to whom this landline record belongs. This field links the communication record to the correct worker profile within HR and payroll systems.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434