ADO.NET Provider for Paylocity

Build 23.0.8839

DirectDeposit

Get All Direct Deposit

Table Specific Information

Select

The 本製品 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 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839