JobHistoryDetails
Retrieves employee job history including past job titles, positions, org levels, and pay groups.
Columns
| Name | Type | References | |
| SystemId [KEY] | String | ||
| EmployeeId | String |
PersonDetails.EmployeeId | |
| CompanyId | String |
CompanyDetails.CompanyId | |
| AnnualSalary | Decimal | ||
| CreatedByUserId | Integer | ||
| DateTimeCreated | Datetime | ||
| EmployeeStatus | String | ||
| EmployeeType | String | ||
| FlsaCategory | String | ||
| FullTimeOrPartTime | String |
The allowed values are F, P. | |
| HomeCompanyId | String | ||
| HourlyPayRate | Decimal | ||
| IntegrationEffectiveDate | Datetime | ||
| IsJobChange | Boolean | ||
| IsOrgChange | Boolean | ||
| IsOutsideGuidelines | Boolean | ||
| IsOutsideRange | Boolean | ||
| IsPromotion | Boolean | ||
| IsRateChange | Boolean | ||
| IsSystem | Boolean | ||
| IsTransfer | Boolean | ||
| IsViewableByEmployee | Boolean | ||
| JobCode | String |
Jobs.JobCode | |
| JobDescription | String | ||
| JobEffectiveDate | Datetime | ||
| JobGroupCode | String | ||
| JobTitle | String | ||
| LocationCode | String | ||
| Notes | String | ||
| NumberOfPayments | Integer | ||
| OrgLevel1Code | String | ||
| OrgLevel2Code | String | ||
| OrgLevel3Code | String | ||
| OrgLevel4Code | String | ||
| OtherRate1 | Decimal | ||
| OtherRate2 | Decimal | ||
| OtherRate3 | Decimal | ||
| OtherRate4 | Decimal | ||
| PayGroupCode | String | ||
| PayPeriodCode | String | ||
| PayScaleCode | String | ||
| PercentChange | Decimal | ||
| PeriodPayRate | Decimal | ||
| PiecePayRate | Decimal | ||
| PositionCode | String |
Positions.PositionCode | |
| ProjectCode | String | ||
| ReasonCode | String | ||
| SalaryGrade | String | ||
| SalaryOrHourly | String |
The allowed values are S, H. | |
| ScheduledAnnualHours | Decimal | ||
| ScheduledFullTimeEquivalency | Decimal | ||
| ScheduledWorkHours | Decimal | ||
| ShiftCode | String | ||
| ShiftGroupCode | String | ||
| StepNumber | Decimal | ||
| SupervisorId | String |
PersonDetails.EmployeeId | |
| SupervisorNameFirst | String | ||
| SupervisorNameLast | String | ||
| SupervisorNameSuffix | String | ||
| IsSupervisorNotInList | Boolean | ||
| UnionLocal | String | ||
| UnionNational | String | ||
| UsePayScales | Boolean | ||
| WeeklyHours | Decimal | ||
| WeeklyPayRate | Decimal |