DirectDeposit
Get All Direct Deposit
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.
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. |