JDBC Driver for ADP

Build 22.0.8462

WorkersWorkAssignments

Returns workers details.

Table Specific Information

Select

The driver will use the ADP API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

  • AssociateOID supports the '=' comparison.
  • WorkerIdValue supports the '=' comparison.
  • AsOfDate supports the '=' comparison.

For example, the following queries are processed server side: 

SELECT * FROM WorkersWorkAssignments WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersWorkAssignments WHERE WorkerIdValue = 'DRH9M9NPW'

SELECT * FROM WorkersWorkAssignments WHERE AsOfDate = '2020-01-01'

Update

Following is an example of how to Update BaseRemuneration: 

UPDATE WorkersWorkAssignments SET StandardHoursQuantity = '45', BaseRemunerationEffectiveDate = '2020-12-21', PayCycleCodeValue = '4', BaseRemunerationHourlyRateAmountValue = 300, WageLawCoverageCodeValue = 'N', BaseRemunerationCode = 'ADJ', ItemId = '34321368N' WHERE AssociateOID = 'G3GMC21PJFZT7K4F'

Following is an example of how to Update AdditionalRemuneration using aggregates: 

UPDATE WorkersWorkAssignments SET AdditionalRemunerations = '[{"remunerationTypeCode":{"code":"AE","name":"additional earnings"},"remunerationRate":{"rate":70,"currencyCode":"USD"},"effectiveDate":"2020-12-20","nameCode":{"code":"1FA"},"inactiveIndicator":false}]', itemid = '35777493N' WHERE AssociateOID = 'G3TGG0M57JZEXCP1'

Following is an example of how to Update AdditionalRemuneration using Temp Table: 

INSERT INTO Input_AdditionalRemunerations#TEMP (RemunerationTypeCode, RemunerationRate, RemunerationCurrencyCode, effectiveDate, NameCode, InactiveIndicator) VALUES ('AE', '70', 'USD', '2021-01-04', 'R', false)

UPDATE WorkersWorkAssignments SET AdditionalRemunerations = 'Input_AdditionalRemunerations#TEMP', itemid = '35777493N' WHERE AssociateOID = 'G3TGG0M57JZEXCP1'

Following is an example of how to Update Worker Assignment Termination: 

UPDATE WorkersWorkAssignments SET TerminationDate = '2020-01-31', LastWorkedDate = '2020-01-31', AssignmentStatusReasonCodeValue = 'A00', RehireEligibleIndicator = true, SeveranceEligibleIndicator = true, TerminationComments = 'Looking for better growth and oppurtunities', itemid = '00691088N' WHERE AssociateOID = 'G3TGG0M57JZECKRB'

Following is an example of how to Update Worker Type: 

UPDATE WorkersWorkAssignments SET WorkerTypeCodeValue = 'F', ItemId = '31095304_1668', EventReasonCode = 'ADL', EffectiveDate = '2021-01-01' WHERE AssociateOID = 'G3Q8G47NKHBV1SMT'

Columns

Name Type ReadOnly References Description
AssociateOID [KEY] String True

Workers.AssociateOID

WorkerIdValue String True

Workers.WorkerID

ItemID String False

ActualStartDate Date True

CompaRatio Integer True

AdditionalRemunerations String False

AnnualBenefitBaseRateAmountValue Integer True

AnnualBenefitBaseRateCurrencyCode String True

AnnualBenefitBaseRateNameCodeValue String True

AnnualBenefitBaseRateNameCodeLongName String True

AnnualBenefitBaseRateNameCodeShortName String True

AssignedOrganizationalUnits String False

AssignedWorkLocations String True

AssignmentCostCenters String True

AssignmentStatusEffectiveDate Date True

AssignmentStatusReasonCodeValue String False

AssignmentStatusReasonCodeLongName String True

AssignmentStatusReasonCodeShortName String True

AssignmentStatusStatusCodeValue String True

AssignmentStatusStatusCodeLongName String True

AssignmentStatusStatusCodeShortName String True

AssignmentTermCodeValue String True

AssignmentTermCodeLongName String True

AssignmentTermCodeShortName String True

BargainingUnitBargainingUnitCodeValue String False

BargainingUnitBargainingUnitCodeLongName String True

BargainingUnitBargainingUnitCodeShortName String False

BargainingUnitSeniorityDate Date False

BaseRemunerationAnnualRateAmountValue Decimal True

BaseRemunerationAnnualRateAmountCurrencyCode String True

BaseRemunerationAnnualRateAmountNameCodeValue String True

BaseRemunerationAnnualRateAmountNameCodeLongName String True

BaseRemunerationAnnualRateAmountNameCodeShortName String True

BaseRemunerationAssociatedRateQualifiers String True

BaseRemunerationBiweeklyRateAmountValue Decimal True

BaseRemunerationBiweeklyRateAmountCurrencyCode String True

BaseRemunerationBiweeklyRateAmountNameCodeLongName String True

BaseRemunerationBiweeklyRateAmountNameCodeValue String True

BaseRemunerationBiweeklyRateAmountNameCodeShortName String True

BaseRemunerationCommissionRatePercentageBaseUnitCodeValue String True

BaseRemunerationCommissionRatePercentageBaseUnitCodeLongName String True

BaseRemunerationCommissionRatePercentageBaseUnitCodeShortName String True

BaseRemunerationCommissionRatePercentageNameCodeValue String True

BaseRemunerationCommissionRatePercentageNameCodeLongName String True

BaseRemunerationCommissionRatePercentageNameCodeShortName String True

BaseRemunerationCommissionRatePercentagePercentageValue Integer True

BaseRemunerationDailyRateAmountValue Decimal False

BaseRemunerationDailyRateAmountCurrencyCode String True

BaseRemunerationDailyRateAmountNameCodeValue String False

BaseRemunerationDailyRateAmountNameCodeLongName String True

BaseRemunerationDailyRateAmountNameCodeShortName String True

BaseRemunerationEffectiveDate Date False

BaseRemunerationHourlyRateAmountValue Decimal False

BaseRemunerationHourlyRateAmountCurrencyCode String True

BaseRemunerationHourlyRateAmountNameCodeValue String True

BaseRemunerationHourlyRateAmountNameCodeLongName String True

BaseRemunerationHourlyRateAmountNameCodeShortName String True

BaseRemunerationMonthlyRateAmountValue Decimal True

BaseRemunerationMonthlyRateAmountCurrencyCode String True

BaseRemunerationMonthlyRateAmountNameCodeValue String False

BaseRemunerationMonthlyRateAmountNameLongName String True

BaseRemunerationMonthlyRateAmountNameShortName String False

BaseRemunerationPayPeriodRateAmountValue Decimal True

BaseRemunerationPayPeriodRateAmountCurrencyCode String True

BaseRemunerationPayPeriodRateAmountNameCodeValue String True

BaseRemunerationPayPeriodRateAmountNameCodeLongName String True

BaseRemunerationPayPeriodRateAmountNameCodeShortName String True

BaseRemunerationRecordingBasisCodeValue String True

BaseRemunerationRecordingBasisCodelongName String True

BaseRemunerationRecordingBasisCodeShortName String True

BaseRemunerationSemiMonthlyRateAmountValue Decimal True

BaseRemunerationSemiMonthlyRateAmountCurrencyCode String True

BaseRemunerationSemiMonthlyRateAmountNameCodeValue String True

BaseRemunerationSemiMonthlyRateAmountNameCodeLongName String True

BaseRemunerationSemiMonthlyRateAmountNameCodeShortName String True

BaseRemunerationWeeklyRateAmountValue Decimal True

BaseRemunerationWeeklyRateAmountCurrencyCode String True

BaseRemunerationWeeklyRateAmountNameCodeValue String True

BaseRemunerationWeeklyRateAmountNameCodeLongName String True

BaseRemunerationWeeklyRateAmountNameCodeShortName String True

ExecutiveIndicator Boolean True

ExecutiveTypeCodeValue String True

ExecutiveTypeCodeLongName String True

ExecutiveTypeCodeShortName String True

ExpectedStartDate Date True

ExpectedTerminationDate Date True

FullTimeEquivalenceRatio Integer True

GeographicPayDifferentialCodeValue String True

GeographicPayDifferentialCodeLongName String True

GeographicPayDifferentialCodeShortName String True

GeographicPayDifferentialPercentage Integer True

HighlyCompensatedIndicator Boolean True

HighlyCompensatedTypeCodeValue String True

HighlyCompensatedTypeCodeLongName String True

HighlyCompensatedTypeCodeShortName String True

HireDate Date True

HomeOrganizationalUnits String False

HomeWorkLocationAddressAttentionOfName String True

HomeWorkLocationAddressBlockName String True

HomeWorkLocationAddressBuildingName String True

HomeWorkLocationAddressBuildingNumber String True

HomeWorkLocationAddressCareOfName String True

HomeWorkLocationAddressCityName String False

HomeWorkLocationAddressCountryCode String False

HomeWorkLocationAddressCountrySubdivisionLevel1CodeValue String False

HomeWorkLocationAddressCountrySubdivisionLevel1LongName String True

HomeWorkLocationAddressCountrySubdivisionLevel1ShortName String False

HomeWorkLocationAddressCountrySubdivisionLevel1SubdivisionType String False

HomeWorkLocationAddressCountrySubdivisionLevel2CodeValue String False

HomeWorkLocationAddressCountrySubdivisionLevel2LongName String True

HomeWorkLocationAddressCountrySubdivisionLevel2ShortName String False

HomeWorkLocationAddressCountrySubdivisionLevel2SubdivisionType String False

HomeWorkLocationAddressDeliveryPoint String True

HomeWorkLocationAddressDoor String True

HomeWorkLocationAddressFloor String True

HomeWorkLocationAddressGeoCoordinateLatitude Integer True

HomeWorkLocationAddressGeoCoordinateLongitude Integer True

HomeWorkLocationAddressLineFive String True

HomeWorkLocationAddressLineFour String True

HomeWorkLocationAddressLineOne String False

HomeWorkLocationAddressLineTwo String False

HomeWorkLocationAddressLineThree String False

HomeWorkLocationAddressNameCodeValue String True

HomeWorkLocationAddressNameCodeLongName String True

HomeWorkLocationAddressNameCodeShortName String True

HomeWorkLocationAddressPlotID String True

HomeWorkLocationAddressPostalCode String False

HomeWorkLocationAddressPostOfficeBox String True

HomeWorkLocationAddressScriptCodeValue String True

HomeWorkLocationAddressScriptCodeLongName String True

HomeWorkLocationAddressScriptCodeShortName String True

HomeWorkLocationAddressStairCase String True

HomeWorkLocationAddressStreetName String True

HomeWorkLocationAddressStreetTypeCodeValue String True

HomeWorkLocationAddressStreetTypeCodeLongName String True

HomeWorkLocationAddressStreetTypeCodeShortName String True

HomeWorkLocationAddressUnit String True

HomeWorkLocationCommunicationEmails String True

HomeWorkLocationCommunicationFaxes String True

HomeWorkLocationCommunicationLandlines String True

HomeWorkLocationCommunicationMobiles String True

HomeWorkLocationCommunicationPagers String True

HomeWorkLocationNameCodeValue String False

HomeWorkLocationNameCodeLongName String True

HomeWorkLocationNameCodeShortName String False

IndustryClassifications String False

JobCodeValue String False

JobCodeEffectiveDate Date True

JobCodeLongName String True

JobCodeShortName String False

JobTitle String True

LaborUnionLaborUnionCodeValue String False

LaborUnionLaborUnionCodeLongName String True

LaborUnionLaborUnionCodeShortName String False

LaborUnionSeniorityDate Date True

LegalEntityID String True

Links String True

ManagementPositionIndicator Boolean False

MinimumPayGradeStepDuration String True

NationalityContextCodeValue String True

NationalityContextCodeLongName String True

NationalityContextCodeShortName String True

NextPayGradeStepDate Date True

OccupationalClassifications String False

OfferAcceptanceDate Date True

OfferExtensionDate Date True

OfficerIndicator Boolean True

OfficerTypeCodeValue String False

OfficerTypeCodeLongName String True

OfficerTypeCodeShortName String False

PayCycleCodeValue String False

PayCycleCodeLongName String True

PayCycleCodeShortName String False

PayGradeCodeValue String False

PayGradeCodeLongName String True

PayGradeCodeShortName String False

PayGradePayRangeMaximumRateAmountValue Decimal True

PayGradePayRangeMaximumRateBaseMultiplierValue Integer True

PayGradePayRangeMaximumRateBaseUnitCodeValue String True

PayGradePayRangeMaximumRateBaseUnitCodeLongName String True

PayGradePayRangeMaximumRateBaseUnitCodeShortName String True

PayGradePayRangeMaximumRateCurrencyCode String True

PayGradePayRangeMaximumRateUnitCodeValue String True

PayGradePayRangeMaximumRateUnitCodeLongName String True

PayGradePayRangeMaximumRateUnitCodeShortName String True

PayGradePayRangeMedianRateAmountValue Decimal True

PayGradePayRangeMedianRateBaseMultiplierValue Integer True

PayGradePayRangeMedianRateBaseUnitCodeValue String True

PayGradePayRangeMedianRateBaseUnitCodeLongName String True

PayGradePayRangeMedianRateBaseUnitCodeShortName String True

PayGradePayRangeMedianRateCcurrencyCode String True

PayGradePayRangeMedianRateUnitCodeValue String True

PayGradePayRangeMedianRateUnitCodeLongName String True

PayGradePayRangeMedianRateUnitCodeShortName String True

PayGradePayRangeMinimumRateAmountValue Decimal True

PayGradePayRangeMinimumRateBaseMultiplierValue Integer True

PayGradePayRangeMinimumRateBaseUnitCodeValue String True

PayGradePayRangeMinimumRateBaseUnitCodeLongName String True

PayGradePayRangeMinimumRateBaseUnitCodeShortName String True

PayGradePayRangeMinimumRateCurrencyCode String True

PayGradePayRangeMinimumRateUnitCodeValue String True

PayGradePayRangeMinimumRateUnitCodeLongName String True

PayGradePayRangeMinimumRateUnitCodeShortName String True

PayGradeStepCodeValue String True

PayGradeStepCodeLongName String True

PayGradeStepCodeShortName String True

PayGradeStepPayRateAmountValue Decimal True

PayGradeStepPayRateBaseMultiplierValue Integer True

PayGradeStepPayRateBaseUnitCodeValue String True

PayGradeStepPayRateBaseUnitCodeLongName String True

PayGradeStepPayRateBaseUnitCodeShortName String True

PayGradeStepPayRateCurrencyCode String True

PayGradeStepPayRateUnitCodeValue String True

PayGradeStepPayRateUnitCodeLongName String True

PayGradeStepPayRateUnitCodeShortName String True

PayrollFileNumber String False

PayrollGroupCode String False

PayrollProcessingStatusCodeValue String True

PayrollProcessingStatusCodeEffectiveDate Date True

PayrollProcessingStatusCodeLongName String True

PayrollProcessingStatusCodeShortName String True

PayrollRegionCode String True

PayrollScheduleGroupID String True

PayScaleCodeValue String True

PayScaleCodeLongName String True

PayScaleCodeShortName String True

PositionID String False

PositionTitle String True

PrimaryIndicator Boolean True

RemunerationBasisCodeValue String True

RemunerationBasisCodeLongName String True

RemunerationBasisCodeShortName String True

ReportsTo String False

SeniorityDate Date True

StandardHoursQuantity Integer False

StandardHoursUnitCodeValue String True

StandardHoursUnitCodeLongName String True

StandardHoursUnitCodeShortName String True

StandardPayPeriodHoursHoursQuantity Integer True

StandardPayPeriodHoursUnitCodeValue String True

StandardPayPeriodHoursUnitCodeLongName String True

StandardPayPeriodHoursUnitCodeShortName String True

StockOwnerIndicator Boolean True

StockOwnerPercentage Integer True

TerminationDate Date False

VipIndicator Boolean True

VipTypeCodeValue String True

VipTypeCodeLongName String True

VipTypeCodeShortName String True

WageLawCoverageCodeValue String False

WageLawCoverageCode.CodeValue

WageLawCoverageCodeLongName String True

WageLawCoverageCodeShortName String False

WageLawCoverageWageLawNameCodeValue String True

WageLawCoverageWageLawNameCodeLongName String True

WageLawCoverageWageLawNameCodeShortName String True

WorkArrangementCodeValue String True

WorkArrangementCodeLongName String True

WorkArrangementCodeShortName String True

WorkerGroups String True

WorkerProbationIndicator Boolean True

WorkerProbationPeriodEndDate Date True

WorkerProbationPeriodStartDate Date True

WorkerTypeCodeValue String False

WorkerTypeCode.CodeValue

WorkerTypeCodeLongName String True

WorkerTypeCodeShortName String True

WorkLevelCodeValue String True

WorkLevelCodeLongName String True

WorkLevelCodeShortName String True

WorkShiftCodeValue String True

WorkShiftCodeLongName String True

WorkShiftCodeShortName String True

AsOfDate Date True

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
EffectiveDate Date

To update positionid and AssignedOrganizationalUnits

LastWorkedDate Date

Worker Termination Update

RehireEligibleIndicator Boolean

Worker Termination Update

SeveranceEligibleIndicator Boolean

Worker Termination Update

TerminationComments String

Worker Termination Update

BaseRemunerationCode String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462