Tableau Connector for ADP

Build 25.0.9434

WorkSchedulesEntries

The view that returns daily or weekly schedule entries that are defined within work schedules. This view includes shift dates, durations, and assignment details to support time tracking and compliance monitoring.

Columns

Name Type References Description
AssociateOID String The unique identifier (Id) that represents the associate linked to the work schedule entry. This field supports Human Resources (HR) time management, attendance tracking, and payroll synchronization.
ScheduleID String The Id that identifies the overall schedule to which this entry belongs. This field supports HR scheduling processes, shift management, and reporting alignment.
WorkerFormattedName String The full formatted name of the worker that is associated with the schedule entry. This field supports identification across HR systems, timekeeping applications, and workforce reports.
workAssignmentID String The Id that represents the specific work assignment connected to this schedule entry. This field supports HR job mapping, compliance reporting, and data linkage between assignments and schedules.
ScheduleEntryID String The Id that uniquely identifies the schedule-entry record within the schedule. This field supports HR audit tracking, version control, and accurate time allocation.
DaySequenceNumber String The number that represents the sequential order of the day within the schedule period. This field supports HR forecasting, reporting, and automation in shift sequencing.
ScheduleDayDate Date The calendar date associated with the scheduled workday. This field supports HR attendance tracking, payroll processing, and compliance verification.
Actions String The list of actions that are associated with the schedule entry (for example, Created, Modified, Approved). This field supports HR workflow tracking and auditing.
categoryTypeCode String The code that represents the category type assigned to the schedule entry. This field supports HR classification, reporting, and policy enforcement for scheduling.
ShiftTypeCode String The code that identifies the type of shift scheduled for the worker (for example, Regular, Overtime, or Night). This field supports HR time management, labor cost reporting, and compliance with scheduling rules.
EarningAllocations String The earnings that are allocated to the schedule entry based on worked or scheduled time. This field supports payroll integration and HR compensation reporting.
EntryComments String The comments that are associated with the schedule entry. This field supports HR communication, audit documentation, and supervisor notes related to scheduling changes.
PayCodeValue String The code that represents the pay category assigned to the schedule entry. This field supports HR payroll mapping, accounting integration, and earnings classification.
PayCodeShortName String The abbreviated name that corresponds to the pay code value. This field supports HR reporting, payroll summaries, and compact data displays.
EntryStatusCode String The code that represents the current processing status of the schedule entry (for example, Active, Pending, or Completed). This field supports HR validation, auditing, and data synchronization.
StateDateTimePeriod Datetime The date and time that indicate when the scheduled work period begins. This field supports HR shift tracking, time calculation, and payroll accuracy.
EndDateTimePeriod Datetime The date and time that indicate when the scheduled work period ends. This field supports HR shift management, time reporting, and compliance with working hour policies.
StartDatePeriod Date The date that marks the beginning of the work schedule period associated with this entry. This field supports HR scheduling, payroll processing, and time validation.
EndDatePeriod Date The date that marks the end of the work schedule period associated with this entry. This field supports HR reporting, forecasting, and payroll integration.
TotalTimeValue String The total time value that represents the duration of the scheduled period. This field supports HR payroll calculations, overtime validation, and scheduling accuracy.
TotalTimeNameCode String The code that identifies the naming convention used for the total time category. This field supports HR reporting and consistency in schedule duration calculations.
TotalTimeNameCodeShortName String The abbreviated name that corresponds to the total time name code. This field supports HR summaries, reporting layouts, and integration with time tracking systems.
ScheduledHoursQuantity String The total number of hours that are scheduled for the worker during this entry. This field supports HR time allocation, capacity planning, and payroll validation.

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