Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData ADO.NET Provider for ADP Views


Name	Description
AdditionalRemunerationNameCode	The view that provides reference data for additional remuneration name codes. This view defines supplemental pay elements (for example, bonuses, commissions, or incentive payments) that are recognized in ADP payroll processing. This view is used to standardize remuneration types across payroll reports and calculations.
AssociatePaymentsAllocationsEarningsAndBenefits	The view that presents detailed information about how each associate's earnings and benefits are allocated in payroll outputs. This view enables reconciliation of earnings categories with corresponding benefit components to ensure accurate financial reporting.
AssociatePaymentsAllocationsEarningSections	The view that displays the earning section breakdowns for associate payment allocations. This view organizes payroll results by section (for example, regular pay, overtime, and adjustments) to support payroll review and compliance validation.
AssociatePaymentsAllocationsNonStatutoryDeductions	The view that returns non-statutory deduction details for associate payment allocations in payroll outputs. This view includes deductions that are not legally mandated, such as employee-elected benefits, charitable contributions, or loan repayments.
AssociatePaymentsAllocationsStatutoryDeductions	The view that displays statutory deduction information for associate payment allocations in payroll outputs. This view includes deductions that are required by law, such as income taxes, social security contributions, and other government withholdings.
AssociatePaymentsSummaryEarningsAndBenefits	The view that summarizes all earnings and benefits for each associate within a payroll output. This view provides a high-level snapshot for auditing and financial reconciliation of payroll data.
AssociatePaymentsSummaryEarningsSections	The view that aggregates earnings by section (for example, regular earnings, overtime, or bonuses) for each associate in payroll outputs. This view provides structured data for compliance and reporting purposes.
AssociatePaymentsSummaryNonStatutoryDeductions	The view that summarizes non-statutory deductions for each associate in payroll outputs. This view allows payroll teams to verify optional deductions that are applied according to employee elections or company policies.
AssociatePaymentsSummaryPayrollAccumulations	The view that provides cumulative payroll totals for each associate, including accumulated earnings, deductions, and benefits. This view supports audit trail validation and long-term payroll analytics.
AssociatePaymentsSummaryStatutoryDeductions	The view that summarizes all statutory deductions (for example, tax withholdings and mandated contributions) for each associate in payroll outputs. This view is used for compliance reporting and reconciliation with government filings.
CostCenters	The view that returns the cost center codes configured for the client in ADP. This view enables payroll expense tracking and departmental allocation of labor costs for internal reporting and financial analysis.
DeductionInputCode	The view that provides reference data for deduction input codes. This view defines each deduction type that is supported in payroll calculations, ensuring standardized mapping across payroll configurations.
EarningInputCode	The view that provides reference data for earning input codes. This view lists earning categories that are used to classify income types such as salary, overtime, or commission in payroll processing.
GenerationAffixCode	The view that returns standardized legal name affix codes (for example, Jr., Sr., or III). This view ensures consistent associate identity representation across Human Resources (HR) and payroll systems.
HighestEducationLevelCode	The view that returns standardized education level codes for associates. This view supports Human Resources (HR) analytics, diversity reporting, and compliance documentation that rely on education data.
JobApplications	The view that returns job-application records that are captured through the ADP recruiting module. It provides applicant data that is used for candidate tracking, evaluation, and onboarding workflows.
JobApplicationsCommunicationLandlines	The view that returns candidate landline phone numbers that are associated with job applications. It supports communication record management for recruiting and compliance reporting.
JobApplicationsCommunicationMobiles	The view that returns candidate mobile contact numbers that are linked to job applications. It provides mobile communication details for recruitment correspondence and tracking.
jobRequisitions	The view that returns job requisition data for open or closed positions. It supports hiring pipeline management and alignment of workforce planning with organizational goals.
JobRequisitionsOrganizationalUnits	The view that returns organizational unit details that are associated with each job requisition. It enables mapping between requisitions and the company's hierarchical structure for planning and reporting.
MaritalStatusCode	The view that provides standardized marital status codes that are used in associate profiles. It supports HR data accuracy and payroll tax configuration based on filing status.
OnboardingTemplate	The view that returns onboarding templates that are configured in ADP. Each template defines workflow steps, documentation requirements, and tasks that are applied to new-hire onboarding processes.
PaidTimeOffBalances	The view that returns current paid time-off (PTO) balances for associates. It is used to track available leave accruals, support scheduling, and ensure compliance with company PTO policies.
PaidTimeOffRequestEntries	The view that returns associate paid time-off (PTO) requests, including dates, hours, and request statuses. It supports HR workflows that manage approvals, scheduling, and payroll synchronization.
PaidTimeOffRequests	The view that returns detailed records of paid time-off (PTO) requests that are submitted by associates. It includes information such as request dates, hours, reasons, and approval statuses. This view is used to track leave management and synchronize approved requests with payroll and scheduling systems.
PayrollGroup	The view that returns payroll-group information that is configured in ADP. A payroll group defines a collection of workers that share the same payroll cycle, frequency, and processing rules. This view supports payroll scheduling, grouping, and administrative reporting.
PayrollMemos	The view that returns payroll memo entries that are used to record messages, notes, or instructions that are related to payroll processing. Payroll administrators use these memos to document special adjustments, approvals, or compliance notes for each pay run.
PersonalContacts	The view that returns personal and emergency contact information for each associate. This view includes contact names, relationships, and communication details. This view supports compliance with workplace safety and Human Resources (HR) record-keeping requirements.
QualificationAffixCode	The view that provides standardized codes for worker-qualification affixes. This view defines credential suffixes and related classification codes that are applied to worker records to indicate certifications, degrees, or titles.
ReimbursementInputCode	The view that provides reference data for reimbursement input codes. This view lists reimbursement types (for example, travel, mileage, or expenses) that are used in payroll processing. The view enables standardized mapping of reimbursement categories.
TeamTimeCards	The view that returns time card data for all workers in a specific team. This view includes time entries, attendance records, and worked hours. This view supports team-level scheduling, payroll validation, and labor reporting.
TeamTimeCardsAllTeams	The view that returns time card data for all teams within the organization. This view consolidates multiple team records into a single dataset for workforce management and payroll reconciliation.
TeamTimeCardsDailyTotals	The view that returns aggregated daily totals from team time cards. This view summarizes the total hours that are worked by team and day, enabling supervisors to monitor attendance patterns and manage overtime compliance.
TeamTimeCardsDayEntries	The view that returns daily time card entries for each worker, along with associated totals. This view provides a day-by-day breakdown of team activity that is used to verify attendance, validate time entries, and approve hours for payroll.
TeamTimeCardsHomeLaborAllocations	The view that returns home-labor allocation data for team time cards. This view identifies how hours worked are distributed across home cost centers, locations, or projects. This view supports labor allocation and cost accounting.
TeamTimeCardsPeriodTotals	The view that returns aggregated period totals from team time cards. This view summarizes total hours, regular pay, and overtime over a complete payroll period. This data supports payroll calculation and compliance with labor regulations.
TimeCards	The view that returns time card data for individual workers. This view includes daily and period totals, job codes, and pay types. This view supports time tracking, payroll preparation, and compliance with attendance policies.
TimeCardsAllActiveWorkers	The view that returns time card data for all active workers in the organization. It consolidates current worker time records to provide a comprehensive overview of attendance and worked hours across departments.
TimeCardsDailyTotals	The view that returns daily time card totals for individual workers. This view summarizes hours worked each day by category (for example, Regular, Overtime, or Leave) to support payroll review and reporting.
TimeCardsPeriodTotals	The view that returns total hours and earnings that are aggregated over an entire payroll period for each worker. This view provides summarized data that is used for payroll calculation and compliance tracking.
WageLawCoverageCode	The view that returns standardized wage-law coverage codes that are applied to worker records. This view identifies the regulatory wage-coverage classification for each position or location, supporting compliance with local and federal labor laws.
WorkAssignmentCustomHistoryCustomGroupAmountFields	The view that returns historical data for custom amount fields that are defined within work-assignment custom groups. This view tracks numeric compensation or allocation values that are associated with each work assignment.
WorkAssignmentCustomHistoryCustomGroupCodeFields	The view that returns historical data for code-based fields defined in work-assignment custom groups. This view includes classification or lookup values that are used to categorize historical work-assignment information.
WorkAssignmentCustomHistoryCustomGroupDateFields	The view that returns historical data for date fields that are defined within work-assignment custom groups. This view is used to track important milestone or effective dates for assignment changes and employment events.
WorkAssignmentCustomHistoryCustomGroupDateTimeFields	The view that returns historical data for date-time fields that are defined in work-assignment custom groups. This view captures both date and timestamp information for work-assignment changes and related Human Resources (HR) events.
WorkAssignmentCustomHistoryCustomGroupIndicatorFields	The view that returns historical data for indicator fields within work-assignment custom groups. This view stores Boolean or flag-based information that identifies specific employment conditions or attributes.
WorkAssignmentCustomHistoryCustomGroupLinks	The view that returns link field data for work-assignment custom groups. This view maintains relationships between custom fields and other reference entities, allowing traceability of historical assignment data.
WorkAssignmentCustomHistoryCustomGroupNumberFields	The view that returns historical data for numeric fields that are defined within work-assignment custom groups. This view tracks quantitative metrics (for example, hours, rates, or counts) that are related to historical work assignments.
WorkAssignmentCustomHistoryCustomGroupPercentFields	The view that returns historical data for percent fields that are defined within work-assignment custom groups. This view captures percentage-based metrics such as allocation ratios or contribution percentages that are tied to historical assignments.
WorkAssignmentCustomHistoryCustomGroupStringFields	The view that returns historical data for text-based fields that are defined within work-assignment custom groups. This view captures descriptive or narrative information stored in historical records.
WorkAssignmentCustomHistoryCustomGroupTelephoneFields	The view that returns historical data for telephone fields that are defined within work-assignment custom groups. This view captures contact numbers or communication Ids that are linked to historical assignments.
WorkAssignmentHistory	The view that returns the full historical record of work assignments for each associate. It tracks changes in position, department, or reporting structure over time. This view supports compliance, analytics, and employment verification.
WorkAssignmentHistoryAdditionalRemunerations	The view that returns historical records of additional remunerations that are associated with work assignments. This view captures supplemental earnings (for example, bonuses or allowances) that are applied to past payroll periods for auditing and reconciliation.
WorkAssignmentHistoryAssignedOrganizationalUnits	The view that returns the historical record of organizational units that are assigned to each work assignment. This view tracks how an associate's reporting structure and departmental affiliations have changed over time. This data supports organizational audits and workforce mobility analysis.
WorkAssignmentHistoryAssignedWorkLocations	The view that returns the historical record of work locations that are assigned to each associate's work assignment. This view captures location transfers, remote-work changes, and other location-based adjustments that are relevant for payroll taxation and compliance tracking.
WorkAssignmentHistoryCommunicationsEmails	The view that returns historical email communication details that are associated with work assignments. This view maintains a record of email addresses used by workers over time for internal correspondence and audit verification.
WorkAssignmentHistoryCommunicationsFaxes	The view that returns historical fax communication records for work assignments. This view preserves legacy fax contact data that is associated with employee assignments for historical or compliance purposes.
WorkAssignmentHistoryCommunicationsInstantMessages	The view that returns historical instant-messaging contact data that is linked to work assignments. This view supports audit and compliance reviews of internal communication methods over time.
WorkAssignmentHistoryCommunicationsInternetAddresses	The view that returns historical records of internet addresses that area associated with work assignments. This view includes data (for example, employee website or network Ids) that are tracked for security and compliance.
WorkAssignmentHistoryCommunicationsLandlines	The view that returns historical landline communication details that are associated with work assignments. This view records telephone contact numbers that were active during prior assignment periods for reference and compliance reporting.
WorkAssignmentHistoryCommunicationsMobiles	The view that returns historical mobile-phone contact data for each work assignment. This view tracks changes in mobile communication channels used by associates for accessibility and Human Resources (HR) audit purposes.
WorkAssignmentHistoryCommunicationsPagers	The view that returns historical pager contact data that is associated with work assignments. This view supports legacy communication recordkeeping and historical audit reviews.
WorkAssignmentHistoryCommunicationsSocialNetworks	The view that returns historical social-network contact information that is linked to work assignments. This view captures professional network Ids used in Human Resources (HR) systems for profile completeness and compliance documentation.
WorkAssignmentHistoryHomeOrganizationalUnits	The view that returns the historical record of home organizational units for each associate's work assignment. This view identifies an employee's primary business unit over time for historical analysis and payroll allocation.
WorkAssignmentHistoryIndustryClassifications	The view that returns historical industry classification codes that are associated with work assignments. This view tracks the classification of roles or departments according to industry-standard codes that are used for compliance and reporting.
WorkAssignmentHistoryOccupationalClassifications	The view that returns historical occupational classification codes for work assignments. This view maintains standardized occupation data for regulatory reporting and labor statistics tracking.
WorkAssignmentHistoryReport	The view that compiles a comprehensive report of historical work-assignment records. This view integrates multiple dimensions (for example, organizational units, locations, and communication fields) into a unified dataset for compliance and workforce analysis.
WorkAssignmentHistoryWorkerGroups	The view that returns historical records of worker-group assignments. This view tracks group memberships (for example, departments or teams) that are associated with work assignments across time for analytical and compliance purposes.
WorkerDemographics	The view that returns demographic information for each worker in the organization. This view includes attributes such as age range, gender, ethnicity, and marital status. This view supports diversity analytics, workforce planning, and compliance reporting.
WorkersBusinessCommunicationEmails	The view that returns business-email contact information for workers. This view includes primary and secondary email addresses that are used for company communication and identity verification.
WorkersBusinessCommunicationFaxes	The view that returns business fax numbers that are associated with worker profiles. This view maintains legacy fax-communication data for administrative and compliance use.
WorkersBusinessCommunicationLandlines	The view that returns business landline contact information for workers. This view lists office phone extensions and mainline numbers for Human Resources (HR) and directory reporting.
WorkersBusinessCommunicationMobiles	The view that returns business mobile-phone contact data for workers. This view captures mobile numbers that are linked to corporate communication systems and used for workforce contact management.
WorkersBusinessCommunicationPagers	The view that returns business-pager contact data for workers. This view preserves historical or legacy pager records that are used for on-call or field communication tracking.
WorkersPersonBirthNamePreferredSalutations	The view that returns preferred salutation information that is associated with each worker's birth name. This view standardizes greeting formats (for example, Mr., Ms., or Dr.), which are used in formal Human Resources (HR) and correspondence records.
WorkersPersonBirthNameTitleAffixCodes	The view that returns title affix codes for worker birth names (for example, Jr., Sr., or III). This view ensures legal name accuracy and consistent representation of personal Ids across Human Resources (HR) and payroll systems.
WorkersPersonBirthNameTitlePrefixCodes	The view that returns title prefix codes for worker birth names (for example, Mr., Mrs., or Dr). This view provides standardized title data that is used in employee identification and official reporting.
WorkersPersonGovernmentIDs	The view that returns government identification data for each worker. This view includes identifiers such as Social Security Numbers, Tax Ids, or national identification codes. It supports verification, payroll compliance, and reporting to government agencies.
WorkersPersonLegalNamePreferredSalutations	The view that returns preferred salutations that are associated with each worker's legal name. This view standardizes how names are displayed in Human Resources (HR) documents, correspondence, and system-generated communications.
WorkersPersonLegalNameTitleAffixCodes	The view that returns title affix codes associated with each worker's legal name (for example, Jr., Sr., or III). This view ensures consistent use of legal name suffixes across Human Resources (HR) and payroll records.
WorkersPersonLegalNameTitlePrefixCodes	The view that returns title prefix codes that are associated with each worker's legal name (for example, Mr., Mrs., or Dr). This view supports proper formatting of names in official Human Resources (HR) and payroll documentation.
WorkersPersonMilitaryClassificationCodes	The view that returns military classification codes for workers who have served or are serving in the military. This view supports compliance reporting and veteran status tracking for workforce diversity and government reporting.
WorkersPhotoLinks	The view that returns hyperlink references to worker photos that are stored within ADP systems. This view allows applications and reports to reference image assets without embedding the image data directly.
WorkersPhotos	The view that returns worker photos that are stored in ADP. This view provides image data that is associated with worker profiles for use in identification, security systems, and Human Resources (HR) applications.
WorkersWorkAssignmentReportsTo	The view that returns reporting relationships for worker assignments. This view identifies each associate's direct manager or supervisor and supports organizational hierarchy reporting.
WorkersWorkAssignmentsAssignedOrganizationalUnits	The view that returns the organizational units that are assigned to each worker's work assignment. This view links employees to departments or divisions for workforce management and financial reporting.
WorkersWorkAssignmentsAssignedWorkLocations	The view that returns assigned work location data for worker assignments. This view tracks where employees perform their duties, supporting payroll tax jurisdiction and location-based reporting.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationEmails	The view that returns email contact information that is associated with assigned work locations. This view enables communication with site administrators or location-specific Human Resources (HR) personnel.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationFaxes	The view that returns fax communication data that is associated with assigned work locations. This view preserves site-level fax information for administrative or compliance correspondence.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationLandlines	The view that returns landline phone numbers that are associated with assigned work locations. This view provides fixed-line contact details for Human Resources (HR) and operational communication.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationMobiles	The view that returns mobile phone contact data that is associated with assigned work locations. This view captures mobile communication numbers that are used for coordination and emergency communication.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationPagers	The view that returns pager contact data that is associated with assigned work locations. This view preserves historical or specialized paging contact records for field or shift-based communication tracking.
WorkersWorkAssignmentsHomeOrganizationalUnits	The view that returns home organizational unit data for worker assignments. This view identifies the primary organizational unit that is associated with each worker for payroll allocation and hierarchy reporting.
WorkersWorkAssignmentsHomeWorkLocationCommunicationEmails	The view that returns email communication information for workers' home work locations. This view provides site-level contact details that are used for administrative coordination.
WorkersWorkAssignmentsHomeWorkLocationCommunicationFaxes	The view that returns fax communication data for workers' home work locations. This view supports Human Resources (HR) and payroll correspondence that requires fax-based communication.
WorkersWorkAssignmentsHomeWorkLocationCommunicationLandlines	The view that returns landline communication data for workers' home work locations. This view provides fixed-line contact numbers that are maintained for Human Resources (HR) directory and compliance use.
WorkersWorkAssignmentsHomeWorkLocationCommunicationMobiles	The view that returns mobile phone communication data for workers' home work locations. This view supports contact and scheduling coordination for employees based at specific sites.
WorkersWorkAssignmentsHomeWorkLocationCommunicationPagers	The view that returns pager communication data for workers' home work locations. This view retains legacy contact information that can be used in operational or emergency contexts.
WorkersWorkAssignmentsIndustryClassifications	The view that returns industry classification data for worker assignments. This view aligns job functions and departments with industry-standard classification codes that are used in compliance and statistical reporting.
WorkersWorkAssignmentsLinks	The view that returns link data that is associated with worker assignments. This view identifies related entities (for example, departments or projects), enabling relational navigation between worker records and organizational structures.
WorkersWorkAssignmentsOccupationalClassifications	The view that returns occupational classification codes for worker assignments. This view categorizes workers by occupation for regulatory compliance, labor reporting, and analytics.
WorkersWorkAssignmentsWorkerGroups	The view that returns worker group associations within work assignments. This view identifies teams, projects, or groups that workers are assigned to for management and operational reporting.
WorkerTypeCode	The view that provides standardized worker type codes. This view classifies workers according to employment type (for example, full-time, part-time, or contractor) to ensure consistent payroll and Human Resources (HR) reporting.
WorkSchedules	The view that returns worker schedule data. This view defines standard working hours, shift patterns, and time-off rules that are used in scheduling and payroll processing.
WorkSchedulesEntries	The view that returns daily or weekly schedule entries that are defined within work schedules. This view includes shift dates, durations, and assignment details to support time tracking and compliance monitoring.