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