ADO.NET Provider for ADP

Build 24.0.9062

WorkAssignmentHistory

Work assignment history.

Columns

Name Type References Description
PrimaryIndicator Boolean
OfferExtensionDate Date
OfferAcceptanceDate Date
HireDate Date
SeniorityDate Date
ExpectedStartDate Date
ActualStartDate Date
TerminationDate Date
AssignmentStatusCode String
AssignmentStatusCodeValue String
AssignmentStatusLongName String
AssignmentStatusreasonCodeValue String
AssignmentStatusreasonCodeShortName String
AssignmentStatusreasonCodeLongName String
AssignmentStatusEffectiveDate Date
WorkerTypeCodeValue String
WorkerTypeShortName String
WorkerTypeLongName String
AssignmentTermCodeValue String
AssignmentTermCodeShortName String
AssignmentTermCodeLongName String
WorkLevelCodeValue String
WorkLevelCodeShortName String
WorkLevelCodeLongName String
NationalityContextCodeValue String
NationalityContextCodeShortName String
NationalityContextCodeLongName String
VipIndicator Boolean
VipTypeCodeValue String
VipTypeCodeShortName String
VipTypeCodeLongName String
ExecutiveIndicator Boolean
ExecutiveTypeCodeValue String
ExecutiveTypeCodeShortName String
ExecutiveTypeCodeLongName String
OfficerIndicator Boolean
OfficerTypeCodeValue String
OfficerTypeCodeShortName String
OfficerTypeCodeLongName String
ManagementPositionIndicator Boolean
LegalEntityID String
HighlyCompensatedIndicator Boolean
HighlyCompensatedTypeCodeValue String
HighlyCompensatedTypeCodeShortName String
HighlyCompensatedTypeCodeLongName String
StockOwnerIndicator Boolean
StockOwnerPercentage Double
JobCodeValue String
JobCodeShortName String
JobCodeLongName String
JobTitle String
WageLawCoverageCodeValue String
WageLawCoverageCodeShortName String
WageLawCoverageCodeLongName String
WageLawCoverageLawNameCodeValue String
WageLawCoverageLawNameCodeShortName String
WageLawCoverageLawNameCodeLongName String
PositionID String
PositionTitle String
LaborUnionCodeValue String
LaborUnionshortName String
LaborUnionlongName String
LaborUnionSeniorityDate Date
BargainingUnitCodeValue String
BargainingUnitshortName String
BargainingUnitlongName String
BargainingUnitSeniorityDate Date
WorkShiftCodeValue String
WorkShiftCodeshortName String
WorkShiftCodelongName String
WorkArrangementCodeValue String
WorkArrangementCodeshortName String
WorkArrangementCodelongName String
StandardHoursQuality String
StandardHoursCodeValue Integer
StandardHoursCodeshortName String
StandardHoursCodelongName String
FullTimeEquivalenceRatio Integer
HomeWorkLocationCodeValue String
HomeWorkLocationCodeshortName String
HomeWorkLocationCodelongName String
HomeWorkLocationAddressScriptCodeValue String
HomeWorkLocationAddressScriptCodeshortName String
HomeWorkLocationAddressScriptCodelongName String
HomeWorkLocationAddresslineFour String
HomeWorkLocationAddresslineFive String
HomeWorkLocationAddressbuildingNumber String
HomeWorkLocationAddressbuildingName String
HomeWorkLocationAddressblockName String
HomeWorkLocationAddressstreetName String
HomeWorkLocationAddressstreetTypeCodeValue String
HomeWorkLocationAddressstreetTypeCodeshortName String
HomeWorkLocationAddressstreetTypeCodelongName String
HomeWorkLocationAddressunit String
HomeWorkLocationAddressfloor String
HomeWorkLocationAddressstairCase String
HomeWorkLocationAddressdoor String
HomeWorkLocationAddresspostOfficeBox String
HomeWorkLocationAddressdeliveryPoint String
HomeWorkLocationAddressplotID String
HomeWorkLocationAddresscountrySubdivisionLevel2Value String
HomeWorkLocationAddresscountrySubdivisionLevel2shortName String
HomeWorkLocationAddresscountrySubdivisionLevel2longName String
HomeWorkLocationAddresscountrySubdivisionLevel2subdivisionType String
HomeWorkLocationAddressnameCodeValue String
HomeWorkLocationAddressnameCodeshortName String
HomeWorkLocationAddressnameCodelongName String
HomeWorkLocationAddressattentionOfName String
HomeWorkLocationAddresscareOfName String
HomeWorkLocationAddresslineOne String
HomeWorkLocationAddresslineTwo String
HomeWorkLocationAddresslineThree String
HomeWorkLocationAddresscountrySubdivisionLevel1Value String
HomeWorkLocationAddresscountrySubdivisionLevel1shortName String
HomeWorkLocationAddresscountrySubdivisionLevel1longName String
HomeWorkLocationAddresscountrySubdivisionLevel1subdivisionType String
HomeWorkLocationAddresscountryCode String
HomeWorkLocationAddresspostalCode String
HomeWorkLocationAddressgeoCoordinateLatitude Double
HomeWorkLocationAddressgeoCoordinateLongitude Double
RemunerationBasisCodeValue String
RemunerationBasisCodeshortName String
RemunerationBasisCodelongName String
PayCycleCodeValue String
PayCycleCodeshortName String
PayCycleCodelongName String
StandardPayPeriodHourshoursQuantity Integer
StandardPayPeriodHoursCodeValue String
StandardPayPeriodHoursCodeshortName String
StandardPayPeriodHoursCodelongName String
BaseRemunerationhourlyRateAmountcodeValue String
BaseRemunerationhourlyRateAmountshortName String
BaseRemunerationhourlyRateAmountlongName String
BaseRemunerationhourlyRateAmountValue String
BaseRemunerationhourlyRateAmountCurrencyCode String
BaseRemunerationdailyRateAmountcodeValue String
BaseRemunerationdailyRateAmountshortName String
BaseRemunerationdailyRateAmountlongName String
BaseRemunerationdailyRateAmountValue String
BaseRemunerationdailyRateAmountCurrencyCode String
BaseRemunerationweeklyRateAmountcodeValue String
BaseRemunerationweeklyRateAmountshortName String
BaseRemunerationweeklyRateAmountlongName String
BaseRemunerationweeklyRateAmountValue String
BaseRemunerationweeklyRateAmountCurrencyCode String
BaseRemunerationbiweeklyRateAmountcodeValue String
BaseRemunerationbiweeklyRateAmountshortName String
BaseRemunerationbiweeklyRateAmountlongName String
BaseRemunerationbiweeklyRateAmountValue String
BaseRemunerationbiweeklyRateAmountCurrencyCode String
BaseRemunerationsemiMonthlyRateAmountcodeValue String
BaseRemunerationsemiMonthlyRateAmountshortName String
BaseRemunerationsemiMonthlyRateAmountlongName String
BaseRemunerationsemiMonthlyRateAmountValue String
BaseRemunerationsemiMonthlyRateAmountCurrencyCode String
BaseRemunerationmonthlyRateAmountcodeValue String
BaseRemunerationmonthlyRateAmountshortName String
BaseRemunerationmonthlyRateAmountlongName String
BaseRemunerationmonthlyRateAmountValue String
BaseRemunerationmonthlyRateAmountCurrencyCode String
BaseRemunerationannualRateAmountcodeValue String
BaseRemunerationannualRateAmountshortName String
BaseRemunerationannualRateAmountlongName String
BaseRemunerationannualRateAmountValue String
BaseRemunerationannualRateAmountCurrencyCode String
BaseRemunerationpayPeriodRateAmountcodeValue String
BaseRemunerationpayPeriodRateAmountshortName String
BaseRemunerationpayPeriodRateAmountlongName String
BaseRemunerationpayPeriodRateAmountValue String
BaseRemunerationpayPeriodRateAmountCurrencyCode String
BaseRemunerationcommissionRatePercentagecodeValue String
BaseRemunerationcommissionRatePercentageshortName String
BaseRemunerationcommissionRatePercentagelongName String
BaseRemunerationcommissionRatePercentageValue String
BaseRemunerationcommissionRatePercentagebaseUnitCodeValue String
BaseRemunerationcommissionRatePercentageCurrencyCodeshortName String
BaseRemunerationcommissionRatePercentageCurrencyCodelongName String
BaseRemunerationeffectiveDate Date
PayrollProcessingStatusCodecodeValue String
PayrollProcessingStatusCodeshortName String
PayrollProcessingStatusCodelongName String
PayrollProcessingStatusCodeEffectiveDate Date
PayrollGroupCode String
PayrollFileNumber String
PayrollRegionCode String
PayScaleCodecodeValue String
PayScaleCodeshortName String
PayScaleCodelongName String
PayGradeCodecodeValue String
PayGradeCodeshortName String
PayGradeCodelongName String
PayGradePayRangeminimumRateamountValue String
PayGradePayRangeminimumRatecurrencyCode String
PayGradePayRangeminimumRateUnitCodeValue String
PayGradePayRangeminimumRateUnitshortName String
PayGradePayRangeminimumRateUnitlongName String
PayGradePayRangeminimumRateBaseUnitCodeValue String
PayGradePayRangeminimumRateBaseUnitshortName String
PayGradePayRangeminimumRateBaseUnitlongName String
PayGradePayRangeminimumRatebaseMultiplierValue Integer
PayGradePayRangemedianRateamountValue String
PayGradePayRangemedianRatecurrencyCode String
PayGradePayRangemedianRateUnitCodeValue String
PayGradePayRangemedianRateUnitshortName String
PayGradePayRangemedianRateBaseUnitCodeValue String
PayGradePayRangemedianRateBaseUnitshortName String
PayGradePayRangemedianRateBaseUnitlongName String
PayGradePayRangemedianRatebaseMultiplierValue Integer
PayGradePayRangemaximumRateamountValue String
PayGradePayRangemaximumRatecurrencyCode String
PayGradePayRangemaximumRateUnitCodeValue String
PayGradePayRangemaximumRateUnitshortName String
PayGradePayRangemaximumRateUnitlongName String
PayGradePayRangemaximumRateBaseUnitCodeValue String
PayGradePayRangemaximumRateBaseUnitshortName String
PayGradePayRangemaximumRateBaseUnitlongName String
PayGradePayRangemaximumRatebaseMultiplierValue Integer
CompaRatio Double
PayGradeStepCodeValue String
PayGradeStepshortName String
PayGradeSteplongName String
PayGradeStepPayRateamountValue String
PayGradeStepPayRatecurrencyCode String
PayGradeStepPayRateUnitCodeValue String
PayGradeStepPayRateUnitshortName String
PayGradeStepPayRateUnitlongName String
PayGradeStepPayRateBaseUnitCodeValue String
PayGradeStepPayRateBaseUnitshortName String
PayGradeStepPayRateBaseUnitlongName String
PayGradeStepPayRatebaseMultiplierValue Integer
NextPayGradeStepDate Date
MinimumPayGradeStepDuration String
GeographicPayDifferentialCodeValue String
GeographicPayDifferentialshortName String
GeographicPayDifferentiallongName String
GeographicPayDifferentialPercentage Double
ItemID String
EffectiveDate Date
FromDate Date
ThruDate Date
HistoryEventID String
HistoryEventNameCodeValue String
HistoryEventNameshortName String
HistoryEventNamelongName String
HistoryReasonCodeValue String
HistoryReasonshortName String
HistoryReasonlongName String
HistoryEventActorId String
HistoryEventActorCodeValue String
HistoryEventActorshortName String
HistoryEventActorlongName String
HistoryEventActorassociateOID String
HistoryEventActorpersonOID String
HistoryEventActorformattedName String
HistoryEventActordeviceID String
HistoryEventActorlatitude Double
HistoryEventActorlongitude Double
HistoryEventActordeviceUserAgentID String
WorkAssignmentID String
AssociateOID String

Workers.AssociateOID

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062