Power BI Connector for ADP

Build 25.0.9454

TeamTimeCardsAllTeams

The view that returns time card data for all teams within the organization. This view consolidates multiple team records into a single dataset for workforce management and payroll reconciliation.

Columns

Name Type References Description
AssociateOID String

Workers.AssociateOID

The unique identifier (Id) that represents the associate whose time card record appears in the all-teams view. This Id links the time entry to the associate's employment profile in ADP.
WorkerID String The Id that identifies the worker that is associated with the time card entry across all teams. This Id connects the worker's time data to related payroll and scheduling records.
TimeCardID String The Id that identifies the time card record for the specified payroll period. This Id distinguishes each time card entry within the associate's time-tracking data across multiple teams.
PersonLegalName String The legal name of the associate as recorded in Human Resources (HR) systems. This name is used for compliance, reporting, and identification within team time card records.
PersonLegalFamilyName1 String The first family name or surname of the associate. This value ensures naming consistency across ADP's HR and payroll modules.
PersonLegalFormattedName String The formatted full legal name of the associate. This field provides a standardized name format for display in reports and dashboards.
ProcessingStatusCodeValue String The code that identifies the processing status of the time card (for example, Draft, Submitted, or Approved). This code supports time card workflow tracking across teams.
ProcessingStatusCodeShortName String The short descriptive name that corresponds to the processing status code. This field provides a readable label for reports and dashboards.
periodCodeValue String The code that identifies the time-tracking period that the time card represents (for example, Current, Next, or Previous). This code determines which pay period's data is being viewed or processed.
periodCodeShortName String The short descriptive name that corresponds to the period code. This field provides a concise label for display in reports and dashboards.
periodCodeLongName String The long descriptive name that corresponds to the period code. This field provides the full label used in reports and time-tracking summaries.
TimePeriodStartDate Date The start date of the time card period. This date marks when the pay or work period begins.
TimePeriodEndDate Date The end date of the time card period. This date marks when the pay or work period concludes.
TimePeriodPeriodStatus String The status of the time period that the time card represents (for example, Open, Closed, or Locked). This status supports payroll readiness and approval workflows.
PositionID String The Id that identifies the associate's job position that is linked to the time card. This Id connects time records to position-based reporting and labor cost allocation.
PeriodTotals String The summarized totals for the time card period. This field aggregates hours, earnings, or other time-based values for reporting and payroll processing.
DailyTotals String The daily totals that are associated with the time card. Each entry represents the total worked time or pay data for a single day within the period.
TotalPeriodTimeDuration String The total time duration that is recorded across the entire time card period. This value reflects the cumulative worked or payable time for the associate.
HomeLaborAllocations String The home-labor allocation details that are associated with the time card. These details identify the cost center or department where the associate's time is charged.
ExceptionsIndicator Boolean The indicator that specifies whether any exceptions exist in the time card record. A value of 'true' indicates that exceptions are present (for example, missing punches or policy violations), while a value of 'false' indicates that the time card has no exceptions.
ManagerOID String

Workers.AssociateOID

The Id that identifies the manager who oversees or approves the time cards for multiple teams. This Id links the time card record to the manager's profile in ADP.

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