テーブル
本製品 はPaylocity のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。
CData Excel Add-In for Paylocity テーブル
Name | Description |
AdditionalRates | Add/update additional rates |
Earnings | Get All Earnings. Delete Earning by Earning Code and Start Date. Add/Update Earning. Get Earnings by Earning Code. Get Earning by Earning Code and Start Date |
EmergencyContacts | Add/update emergency contacts |
EmployeeBenefitSetup | Add/update employee's benefit setup |
EmployeeDetails | Add new employee. Get employee. Update employee |
Input_TimeEntry | To create the csv content for the CreatePayEntryImportBatch.TimeEntry using this as a TEMP Table. When the connection to Paylocity is closed, all tables names started with Input are cleared. |
LocalTaxes | Get local taxes by tax code. Get all local taxes. Add new local tax. Delete local tax by tax code |
NonPrimaryStateTax | Add/update non-primary state tax |
PrimaryStateTax | Add/update primary state tax |
SensitiveData | Gets employee sensitive data information directly from Web Pay. |