Data Model
The connector models entities in the ADP API as an easy-to-use SQL database, using tables, views, and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your ADP account. The following table includes a list of common tables and views:| Table | Description |
| AdditionalRemunerationNameCode | Provides reference data for additional remuneration name codes. This view defines supplemental pay elements (for example, bonuses, commissions, or incentive payments) that are recognized in ADP payroll processing. This view is used to standardize remuneration types across payroll reports and calculations. |
| AssociatePaymentsAllocationsEarningsAndBenefits | Presents detailed information about how each associate's earnings and benefits are allocated in payroll outputs. This view enables reconciliation of earnings categories with corresponding benefit components to ensure accurate financial reporting. |
| AssociatePaymentsSummaryEarningsAndBenefits | Summarizes all earnings and benefits for each associate within a payroll output. This view provides a high-level snapshot for auditing and financial reconciliation of payroll data. |
| CostCenters | Returns the cost center codes configured for the client in ADP. This view enables payroll expense tracking and departmental allocation of labor costs for internal reporting and financial analysis. |
| EarningInputCode | Provides reference data for earning input codes. This view lists earning categories that are used to classify income types such as salary, overtime, or commission in payroll processing. |
| JobApplications | Returns job-application records that are captured through the ADP recruiting module. It provides applicant data that is used for candidate tracking, evaluation, and onboarding workflows. |
| jobRequisitions | Returns job requisition data for open or closed positions. It supports hiring pipeline management and alignment of workforce planning with organizational goals. |
| PaidTimeOffBalances | Returns current paid time-off (PTO) balances for associates. It is used to track available leave accruals, support scheduling, and ensure compliance with company PTO policies. |
| PaidTimeOffRequests | Returns detailed records of paid time-off (PTO) requests that are submitted by associates. It includes information such as request dates, hours, reasons, and approval statuses. This view is used to track leave management and synchronize approved requests with payroll and scheduling systems. |
| PayrollGroup | Returns payroll-group information that is configured in ADP. A payroll group defines a collection of workers that share the same payroll cycle, frequency, and processing rules. This view supports payroll scheduling, grouping, and administrative reporting. |
| PayrollRuns | Records details for each payroll run that is processed in ADP. This table includes key identifiers (Ids), pay-period information, and references to associated inputs such as earnings and deductions. This table enables audit tracking, reconciliation, and historical reporting of payroll operations. |
| TeamTimeCards | Returns time-card data for all workers in a specific team. This view includes time entries, attendance records, and worked hours. This view supports team-level scheduling, payroll validation, and labor reporting. |
| TeamTimeCardsDailyTotals | Returns aggregated daily totals from team time cards. This view summarizes the total hours that are worked by team and day, enabling supervisors to monitor attendance patterns and manage overtime compliance. |
| TeamTimeCardsPeriodTotals | IReturns aggregated period totals from team time cards. This view summarizes total hours, regular pay, and overtime over a complete payroll period. This data supports payroll calculation and compliance with labor regulations. |
| TimeCards | Returns time-card data for individual workers. This view includes daily and period totals, job codes, and pay types. This view supports time tracking, payroll preparation, and compliance with attendance policies. |
| TimeCardsDailyTotals | eturns daily time-card totals for individual workers. This view summarizes hours worked each day by category (for example, regular, overtime, or leave) to support payroll review and reporting. |
| TimeCardsPeriodTotals | Returns total hours and earnings that are aggregated over an entire payroll period for each worker. This view provides summarized data that is used for payroll calculation and compliance tracking. |
| WorkerDemographics | Returns demographic information for each worker in the organization. This view includes attributes such as age range, gender, ethnicity, and marital status. This view supports diversity analytics, workforce planning, and compliance reporting. |
| Workers | Returns detailed information for all workers in the organization. This table includes core employee Ids, employment status, and work assignment references. This table serves as the foundation for HR, payroll, and reporting integration. |