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. |