DirectDeposit
Get All Direct Deposit
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.
For example, the following queries are processed server side:
SELECT * FROM DirectDeposit WHERE EmployeeId = '123'
Columns
| Name | Type | References | Description |
| EmployeeId [KEY] | String |
Employees.EmployeeId | Id of the Employee. |
| AdditionalDirectDeposit | String | Additional Direct Deposits that are not the main Direct Deposit. | |
| MainDirectDepositRoutingNumber | String | ABA Transit Routing Number, entered without dashes or spaces. | |
| MainDirectDepositNameOnAccount | String | Name on the bank account. Defaults to employee's name. | |
| MainDirectDepositBlockSpecial | Bool | Indicates if direct deposit should be blocked when special check types such as Bonus are processed. | |
| MainDirectDepositAccountNumber | String | Account number, entered without special characters and spaces. | |
| MainDirectDepositIsSkipPreNote | Bool | Indicates if account will not pre-note. | |
| MainDirectDepositAccountType | String | Account type. Valid values are *C* (Checking), *S* (Saving), *P* (Pay Card). | |
| MainDirectDepositPreNoteDate | Date | Date to end the pre-note of the account. Common formats include *MM-DD-CCYY*, *CCYY-MM-DD*. | |
| CompanyId | String | Id of the Company. |