CompanyEmploymentDetails
Retrieves employment details scoped to a specific company. Requires CompanyId as context. Use EmploymentDetails for cross-company queries.
Columns
| Name | Type | References | |
| EmployeeId [KEY] | String |
PersonDetails.EmployeeId | |
| CompanyId | String |
CompanyDetails.CompanyId | |
| AutoAllocate | Boolean | ||
| ClockCode | String | ||
| CompanyCode | String | ||
| CompanyGLSegment | String | ||
| CompanyName | String | ||
| DateInJob | Datetime | ||
| DateLastPayDatePaid | Datetime | ||
| DateLastWorked | Datetime | ||
| DateOfBenefitSeniority | Datetime | ||
| DateOfEarlyRetirement | Datetime | ||
| DateOfLocalUnion | Datetime | ||
| DateOfNationalUnion | Datetime | ||
| DateOfRetirement | Datetime | ||
| DateOfSeniority | Datetime | ||
| DateOfSuspension | Datetime | ||
| DateOfTermination | Datetime | ||
| DatePaidThru | Datetime | ||
| DateTimeChanged | Datetime | ||
| DateTimeCreated | Datetime | ||
| DeductionGroupCode | String | ||
| EarningGroupCode | String | ||
| EmployeeNumber | String | ||
| EmployeeStatusCode | String |
The allowed values are A, L, O, R, S, T. | |
| EmployeeTypeCode | String | ||
| FullTimeOrPartTimeCode | String | ||
| HireSource | String | ||
| IsAutoAllocated | Boolean | ||
| IsAutopaid | Boolean | ||
| IsMultipleJob | Boolean | ||
| JobChangeReasonCode | String | ||
| JobDescription | String | ||
| JobGroupCode | String | ||
| JobTitle | String | ||
| LanguageCode | String | ||
| LastHireDate | Datetime | ||
| LeaveReasonCode | String | ||
| LocationGLSegment | String | ||
| Mailstop | String | ||
| OkToRehire | Boolean | ||
| OrgLevel1Code | String |
OrgLevels.Code | |
| OrgLevel2Code | String | ||
| OrgLevel3Code | String | ||
| OrgLevel4Code | String | ||
| OriginalHireDate | Datetime | ||
| PayGroup | String | ||
| PayGroupDescription | String | ||
| PayPeriod | String | ||
| PlannedLeaveReason | String | ||
| PositionCode | String |
Positions.PositionCode | |
| PrimaryJobCode | String |
Jobs.JobCode | |
| PrimaryProjectCode | String | ||
| PrimaryWorkLocationCode | String | ||
| SalaryOrHourly | String |
The allowed values are S, H. | |
| ScheduledAnnualHrs | Decimal | ||
| ScheduledFTE | Decimal | ||
| ScheduledWorkHrs | Decimal | ||
| Shift | String | ||
| ShiftGroup | String | ||
| StatusStartDate | Datetime | ||
| SupervisorCompanyCode | String | ||
| SupervisorCompanyId | String | ||
| SupervisorEmployeeNumber | String | ||
| SupervisorFirstName | String | ||
| SupervisorId | String |
PersonDetails.EmployeeId | |
| SupervisorLastName | String | ||
| TermReason | String | ||
| TermType | String | ||
| TerminationReasonDescription | String | ||
| TimeclockId | String | ||
| UnionLocal | String | ||
| UnionNational | String | ||
| WeeklyHours | Decimal | ||
| WorkPhoneCountry | String | ||
| WorkPhoneExtension | String | ||
| WorkPhoneNumber | String |