Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData JDBC Driver for Paylocity Views
| Name | Description |
| CompanyCodes | Get All Company Codes |
| CustomFields | Get All Custom Fields |
| DirectDeposit | Get All Direct Deposit |
| EmployeePunchDetails | Get employee punch details. |
| Employees | Get all employee info |
| PayStatementsDetails | Get employee pay statement details data for the specified year.. Get employee pay statement details data for the specified year and check date. |
| PayStatementsSummary | Get employee pay statement summary data for the specified year.. Get employee pay statement summary data for the specified year and check date. |