CompanyCompensationDetails
Retrieves compensation details scoped to a specific company. Requires CompanyId as context. Use CompensationDetails for cross-company queries.
Columns
| Name | Type | References | |
| EmployeeId [KEY] | String | ||
| CompanyId | String |
CompanyDetails.CompanyId | |
| AnnualSalary | Decimal | ||
| AvgPayRateCurPer | Decimal | ||
| BonusTotalHrs | Decimal | ||
| BonusTotalOtHrs | Decimal | ||
| CurrencyCode | String | ||
| DateInJob | Datetime | ||
| DateLastPaid | Datetime | ||
| DateLastWorked | Datetime | ||
| DateOfLastSalaryReview | Datetime | ||
| DateOfNextSalaryReview | Datetime | ||
| DatePaidThru | Datetime | ||
| DistributionCenterCode | String | ||
| EmployeeStatus | String | ||
| FullTimeOrPartTimeCode | String |
The allowed values are F, P. | |
| HourlyPayRate | Decimal | ||
| IsAutoAllocated | Boolean | ||
| IsAutoPaid | Boolean | ||
| IsHighlyCompensated | Boolean | ||
| IsMultipleJob | Boolean | ||
| IsSeasonalWorker | Boolean | ||
| JobChangeReasonCode | String | ||
| JobGroupCode | String | ||
| JobSalaryGrade | String | ||
| JobTitle | String | ||
| NumberOfPayments | Integer | ||
| OtherRate1 | Decimal | ||
| OtherRate2 | Decimal | ||
| OtherRate3 | Decimal | ||
| OtherRate4 | Decimal | ||
| PayGroupCode | String | ||
| PayGroupDescription | String | ||
| PayPeriod | String | ||
| PayPeriodPayRate | Decimal | ||
| PayScaleCode | String | ||
| PerformanceReviewRating | String | ||
| PerformanceReviewType | String | ||
| PiecePayRate | Decimal | ||
| PrimaryJobCode | String | ||
| PrimaryShiftCode | String | ||
| PrimaryShiftGroupCode | String | ||
| SalaryOrHourlyCode | String |
The allowed values are S, H. | |
| ScheduledAnnualWorkHours | Decimal | ||
| ScheduledFullTimeEquivalency | Decimal | ||
| ScheduledPeriodWorkHours | Decimal | ||
| TotalAnnSalary | Decimal | ||
| WeeklyHours | Decimal | ||
| WeeklyPayRate | Decimal |