Tables
The connector models the data in Paylocity as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector 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. |