Tables

The connector models the data in ADP as a list of tables in a relational database that can be queried using standard SQL statements.

CData Python Connector for ADP Tables


Name	Description
Input_AdditionalRemunerations	The temporary table that is used to create aggregates for the WorkersWorkAssignments.AdditionalRemunerations table. The table supports temporary staging of remuneration data during payroll processing. The data exists only for the duration of the active connection and is cleared automatically when the connection to ADP is closed.
Input_configurationTags	The temporary table that is used to associate configuration tags with deduction, earning, or reimbursement inputs. The table enables dynamic configuration for payroll processing and exists only during the active connection. When the connection to ADP is closed, all tables that begin with Input_ are cleared.
Input_DeductionInputs	The temporary table that is used to create aggregates for the PayrollRuns.DeductionInputs table. The table supports staging of deduction entries for payroll runs and exists only while the connection remains active. When the connection to ADP is closed, all Input_ tables are cleared.
Input_EarningInputs	The temporary table that is used to create aggregates for the PayrollRuns.EarningInputs table. The table supports payroll run preparation by holding earning entries that are processed in temporary session storage. When the connection to ADP is closed, the data is cleared.
Input_ReimbursementInputs	The temporary table that is used to create aggregates for the PayrollRuns.ReimbursementInputs table. The table temporarily stores reimbursement data for payroll execution. All Input_ tables are cleared when the ADP connection closes.
PayrollRuns	The table that records details for each payroll run that is processed in ADP. This table includes key identifiers (Ids), pay-period information, and references to associated inputs such as earnings and deductions. This table enables audit tracking, reconciliation, and historical reporting of payroll operations.
Workers	The table that returns detailed information for all workers in the organization. This table includes core employee Ids, employment status, and work assignment references. This table serves as the foundation for Human Resources (HR), payroll, and reporting integration.
WorkersPersonCommunicationEmails	The table that stores personal email communication data for workers. This table includes primary and alternate personal email addresses that are maintained in Human Resources (HR) systems for contact and verification purposes.
WorkersPersonCommunicationFaxes	The table that stores personal fax contact data for workers. This table preserves personal fax information for employees in cases where legacy communication records must be retained for compliance.
WorkersPersonCommunicationLandlines	The table that stores personal landline contact information for workers. This table includes residential phone numbers that are maintained in Human Resources (HR) profiles for emergency or verification purposes.
WorkersPersonCommunicationMobiles	The table that stores personal mobile phone contact information for workers. This table supports Human Resources (HR) communications, emergency alerts, and verification processes requiring mobile contact access.
WorkersPersonCommunicationPagers	The table that stores personal pager communication data for workers. This table retains historical pager information that can be required for compliance review or archival purposes.
WorkersWorkAssignments	The table that stores comprehensive information about worker assignments. This table includes assignment Ids, job roles, departments, and reporting relationships. This table forms the foundation for payroll, scheduling, and Human Resources (HR) analytics.