テーブル

本製品はADP のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

CData Python Connector for ADP テーブル


Name	Description
Input_AdditionalRemunerations	Create aggregates for WorkersWorkAssignments.AdditionalRemunerations using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_configurationTags	Add configurationTags aggregate for Input_DeductionInputs.DeductionConfigurationTags OR Input_EarningInputs.EarningConfigurationTags OR Input_ReimbursementInputs.ReimbursementConfigurationTags using this as TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_DeductionInputs	Create aggregates for PayrollRuns.DeductionInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_EarningInputs	Create aggregates for PayrollRuns.EarningInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
Input_ReimbursementInputs	Create aggregates for PayrollRuns.ReimbursementInputs using this as a TEMP table. This table values only last as long as the connection remains open. When the connection to ADP is closed, all tables names started with Input are cleared.
PayrollRuns	Add and view the payroll runs.
Workers	Returns workers details.
WorkersPersonCommunicationEmails	Returns workers person communication emails.
WorkersPersonCommunicationFaxes	Returns workers person communication faxes.
WorkersPersonCommunicationLandlines	Returns workers person communication landlines.
WorkersPersonCommunicationMobiles	Returns workers person communication mobiles.
WorkersPersonCommunicationPagers	Returns workers person communication pagers.
WorkersWorkAssignments	Returns workers details.