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 |