Tables
The driver models the data in Paylocity into a list of tables that can be queried using standard SQL statements.
Generally, querying Paylocity 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 Paylocity Tables
| Name | Description |
| AdditionalRates | Add/update additional rates |
| Earnings | Get All Earnings. Delete Earning by Earning Code and Start Date. Add/Update Earning. Get Earnings by Earning Code. Get Earning by Earning Code and Start Date |
| EmergencyContacts | Add/update emergency contacts |
| EmployeeBenefitSetup | Add/update employee's benefit setup |
| EmployeeDetails | Add new employee. Get employee. Update employee |
| Input_TimeEntry | To create the csv content for the CreatePayEntryImportBatch.TimeEntry using this as a TEMP Table. When the connection to Paylocity is closed, all tables names started with Input are cleared. |
| LocalTaxes | Get local taxes by tax code. Get all local taxes. Add new local tax. Delete local tax by tax code |
| NonPrimaryStateTax | Add/update non-primary state tax |
| PrimaryStateTax | Add/update primary state tax |
| SensitiveData | Gets employee sensitive data information directly from Web Pay. |