Tables

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

CData JDBC Driver for ADP Tables


Name	Description
Input_AdditionalRemunerations	To 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.