Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for ADP Views


Name	Description
AdditionalRemunerationNameCode	Returns 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 associate payments 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.
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.
QualificationAffixCode	Returns work assignement worker type code.
ReimbursementInputCode	Returns reimbursement input code.
TeamTimeCards	View the Team Time Cards.
TeamTimeCardsDailyTotals	View the Team Time Cards daily totals aggregate.
TeamTimeCardsHomeLaborAllocations	View the Team Time Cards period totals aggregate.
TeamTimeCardsPeriodTotals	View the Team Time Cards period totals aggregate.
TimeCards	View the worker Time Cards.
TimeCardsDailyTotals	View the worker Time Cards daily totals aggregate.
TimeCardsPeriodTotals	View the worker Time Cards period totals aggregate.
WageLawCoverageCode	Returns wage law coverage code.
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.
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.
WorkersWorkAssignmentsHomeWorkLocationCommunicationInstantMessages	Returns workers work assignments home work location communication instant messages.
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	Returns workers work assignments worker groups.
WorkerTypeCode	Returns work assignement worker type code.
WorkSchedules	View the Work Schedules.
WorkSchedulesEntries	View the schedule days entries in Work Schedules.