PayStatementsdetails
Get employee pay statement details data for the specified year.. Get employee pay statement details data for the specified year and check date.
Table Specific Information
Select
The connector will use the Paylocity API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- EmployeeId supports the '=' comparison.
- Year supports the '=' comparison.
- CheckDate supports the '=' comparison.
In the case of simple SELECT the Paylocity will return present and last year records.
For example, the following queries are processed server side:
SELECT * FROM PayStatementsDetails WHERE EmployeeId = '24' AND Year = 2019 SELECT * FROM PayStatementsDetails WHERE EmployeeId = '24' AND Year = 2019 AND CheckDate = '2019-02-01'
Columns
| Name | Type | References | Description |
| EmployeeId [KEY] | String |
Employees.EmployeeId | Id of the Employee |
| CheckDate [KEY] | Date | The Check Date of pay statement details data | |
| CompanyId [KEY] | String | Id of the Company | |
| TransactionNumber | Int | The Transaction Number of pay statement details data | |
| DetCode | String | The Det Code of pay statement details data | |
| Det | String | The Det of pay statement details data | |
| Hours | Decimal | The Hours of pay statement details data | |
| Rate | Decimal | The Rate of pay statement details data | |
| TransactionType | String | The Transaction type of pay statement details data | |
| Year | Int | The The year for which to retrieve pay statement data | |
| Amount | Decimal | The Amount of pay statement details data | |
| DetType | String | Pay statement details related to specific deduction, earning or tax types. | |
| EligibleCompensation | Decimal | The Eligible Compensation of pay statement details data |