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	Additional remuneration name code.
AssociatePaymentsAllocationsEarningsAndBenefits	View the associate payment allocation earnings and benefits in the payroll outputs.
AssociatePaymentsAllocationsEarningSections	View the earning sections for the associate payments allocations in payroll outputs.
AssociatePaymentsAllocationsNonStatutoryDeductions	View the non-statutory deductions for the associate payments allocations in payroll outputs.
AssociatePaymentsAllocationsStatutoryDeductions	View the statutory deductions for the associate payments allocations in payroll outputs.
AssociatePaymentsSummaryEarningsAndBenefits	View the AssociatePayments Earnings and Benefits in the payroll outputs.
AssociatePaymentsSummaryEarningsSections	View the associate payments earnings sections items in the payroll outputs.
AssociatePaymentsSummaryNonStatutoryDeductions	To view the non statutory deduction for the associate in payroll outputs.
AssociatePaymentsSummaryPayrollAccumulations	To View the associate payments payroll accumulations in the payroll outputs.
AssociatePaymentsSummaryStatutoryDeductions	View the statutory deduction for the associate in payroll outputs.
CostCenters	Returns all Cost number codes setup for the client.
DeductionInputCode	Returns deduction input code.
EarningInputCode	Returns earning input code.
GenerationAffixCode	Returns legal name generation affix code.
HighestEducationLevelCode	Returns highest education level code value.
JobApplications	Returns a list of job applications.
JobApplicationsCommunicationLandlines	Returns a list of job applications communication landlines.
JobApplicationsCommunicationMobiles	Returns a list of job applications communication mobiles.
jobRequisitions	Returns a list of job requisitions.
JobRequisitionsOrganizationalUnits	View the organizational unit entries in Job Requisitions.
MaritalStatusCode	Returns marital status codes.
OnboardingTemplate	Returns onboarding template.
PaidTimeOffBalances	Returns Paid TimeOff Balances.
PaidTimeOffRequestEntries	Returns PaidTimeOff Requests.
PaidTimeOffRequests	Returns PaidTimeOff Requests.
PayrollGroup	Returns payroll group.
PayrollMemos	View the payroll memos.
PersonalContacts	Personal emergency contacts.
QualificationAffixCode	Returns work assignement worker type codes.
ReimbursementInputCode	Returns reimbursement input code.
TeamTimeCards	View the Team Time Cards.
TeamTimeCardsAllTeams	View the Team Time Cards of all teams.
TeamTimeCardsDailyTotals	View the Team Time Cards daily totals aggregate.
TeamTimeCardsDayEntries	View the Team Time Cards daily totals aggregate with day entries.
TeamTimeCardsHomeLaborAllocations	View the Team Time Cards period totals aggregate.
TeamTimeCardsPeriodTotals	View the Team Time Cards period totals aggregate.
TimeCards	View the worker Time Cards.
TimeCardsAllActiveWorkers	View the Time Cards of all active workers.
TimeCardsDailyTotals	View the worker Time Cards daily totals aggregate.
TimeCardsPeriodTotals	View the worker Time Cards period totals aggregate.
WageLawCoverageCode	Returns wage law coverage codes.
WorkAssignmentCustomHistoryCustomGroupAmountFields	Work assignment CustomGroup amount.
WorkAssignmentCustomHistoryCustomGroupCodeFields	Work assignment CustomGroup code.
WorkAssignmentCustomHistoryCustomGroupDateFields	Work assignment CustomGroup date.
WorkAssignmentCustomHistoryCustomGroupDateTimeFields	Work assignment CustomGroup date time.
WorkAssignmentCustomHistoryCustomGroupIndicatorFields	Work assignment CustomGroup indicator.
WorkAssignmentCustomHistoryCustomGroupLinks	Work assignment CustomGroup links.
WorkAssignmentCustomHistoryCustomGroupNumberFields	Work assignment CustomGroup number.
WorkAssignmentCustomHistoryCustomGroupPercentFields	Work assignment CustomGroup percent.
WorkAssignmentCustomHistoryCustomGroupStringFields	Work assignment CustomGroup string.
WorkAssignmentCustomHistoryCustomGroupTelephoneFields	Work assignment CustomGroup telephone.
WorkAssignmentHistory	Work assignment history.
WorkAssignmentHistoryAdditionalRemunerations	Work assignment additionsla remunerations history.
WorkAssignmentHistoryAssignedOrganizationalUnits	Work assignment organization units history.
WorkAssignmentHistoryAssignedWorkLocations	Work assignment Assigned locations history.
WorkAssignmentHistoryCommunicationsEmails	Work assignment communication history mail.
WorkAssignmentHistoryCommunicationsFaxes	Work assignment communication Fax History.
WorkAssignmentHistoryCommunicationsInstantMessages	Work assignment communication message History.
WorkAssignmentHistoryCommunicationsInternetAddresses	Work assignment communication Internet address History.
WorkAssignmentHistoryCommunicationsLandlines	Work assignment communication landline history.
WorkAssignmentHistoryCommunicationsMobiles	Work assignment communication mobile History.
WorkAssignmentHistoryCommunicationsPagers	Work assignment communication Pager History.
WorkAssignmentHistoryCommunicationsSocialNetworks	Work assignment communication social network history.
WorkAssignmentHistoryHomeOrganizationalUnits	Work assignment Home organization history.
WorkAssignmentHistoryIndustryClassifications	Work assignment industry classification history.
WorkAssignmentHistoryOccupationalClassifications	Work assignment occupational classification history.
WorkAssignmentHistoryReport	Work assignment Report.
WorkAssignmentHistoryWorkerGroups	Work assignment group history.
WorkerDemographics	Returns a list of demographics for each worker in the organization.
WorkersBusinessCommunicationEmails	Returns workers business communication emails.
WorkersBusinessCommunicationFaxes	Returns workers business communication faxes.
WorkersBusinessCommunicationLandlines	Returns workers business communication landlines.
WorkersBusinessCommunicationMobiles	Returns workers business communication mobiles.
WorkersBusinessCommunicationPagers	Returns workers business communication pagers.
WorkersPersonBirthNamePreferredSalutations	Returns workers person birth name preferred salutations.
WorkersPersonBirthNameTitleAffixCodes	Returns workers person birth name title affix codes.
WorkersPersonBirthNameTitlePrefixCodes	Returns workers person birth name title prefix codes.
WorkersPersonGovernmentIDs	Returns workers person government IDs.
WorkersPersonLegalNamePreferredSalutations	Returns workers person legal name preferred salutations.
WorkersPersonLegalNameTitleAffixCodes	Returns workers person legal name title affix codes.
WorkersPersonLegalNameTitlePrefixCodes	Returns workers person legal name title prefix codes.
WorkersPersonMilitaryClassificationCodes	Returns workers person military classification codes.
WorkersPhotoLinks	Returns workers photo links.
WorkersPhotos	Returns workers photos.
WorkersWorkAssignmentReportsTo	Returns workers work assignment ReportsTo.
WorkersWorkAssignmentsAssignedOrganizationalUnits	Returns workers work assignments assigned organizational units.
WorkersWorkAssignmentsAssignedWorkLocations	Returns workers work assignments assigned work locations.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationEmails	Returns workers work assignments assigned work locations communication emails.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationFaxes	Returns workers work assignments assigned work locations communication faxes.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationLandlines	Returns workers work assignments assigned work locations communication landlines.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationMobiles	Returns workers work assignments assigned work locations communication mobiles.
WorkersWorkAssignmentsAssignedWorkLocationsCommunicationPagers	Returns workers work assignments assigned work locations communication pagers.
WorkersWorkAssignmentsHomeOrganizationalUnits	Returns workers work assignments home organizational units.
WorkersWorkAssignmentsHomeWorkLocationCommunicationEmails	Returns workers work assignments home work location communication emails.
WorkersWorkAssignmentsHomeWorkLocationCommunicationFaxes	Returns workers work assignments home work location communication faxes.
WorkersWorkAssignmentsHomeWorkLocationCommunicationLandlines	Returns workers work assignments home work location communication landlines.
WorkersWorkAssignmentsHomeWorkLocationCommunicationMobiles	Returns workers work assignments home work location communication mobiles.
WorkersWorkAssignmentsHomeWorkLocationCommunicationPagers	Returns workers work assignments home work location communication pagers.
WorkersWorkAssignmentsIndustryClassifications	Returns workers work assignments industry classifications.
WorkersWorkAssignmentsLinks	Returns workers work assignments links.
WorkersWorkAssignmentsOccupationalClassifications	Returns workers work assignments occupational classifications.
WorkersWorkAssignmentsWorkerGroups	Work assignments worker groups.
WorkerTypeCode	Work assignment worker type codes.
WorkSchedules	View the Work Schedules.
WorkSchedulesEntries	View the schedule days entries in Work Schedules.