JDBC Driver for ADP

Build 22.0.8462

Tables

The driver models the data in ADP into a list of tables that can be queried using standard SQL statements.

Generally, querying ADP tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

CData JDBC Driver for ADP Tables

Name Description
Input_AdditionalRemunerations Create aggregates for WorkersWorkAssignments.AdditionalRemunerations using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_configurationTags Add configurationTags aggregate for Input_DeductionInputs.DeductionConfigurationTags OR Input_EarningInputs.EarningConfigurationTags OR Input_ReimbursementInputs.ReimbursementConfigurationTags using this as TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_DeductionInputs Create aggregates for PayrollRuns.DeductionInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_EarningInputs Create aggregates for PayrollRuns.EarningInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_ReimbursementInputs Create aggregates for PayrollRuns.ReimbursementInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
PayrollRuns Add and view the payroll runs.
Workers Returns workers details.
WorkersPersonCommunicationEmails Returns workers person communication emails.
WorkersPersonCommunicationFaxes Returns workers person communication faxes.
WorkersPersonCommunicationLandlines Returns workers person communication landlines.
WorkersPersonCommunicationMobiles Returns workers person communication mobiles.
WorkersPersonCommunicationPagers Returns workers person communication pagers.
WorkersWorkAssignments Returns workers details.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462