EmployeeChanges
Retrieves employee records that have changed, including employment status, job, address, and contact details.
Columns
| Name | Type | References | |
| EmployeeId [KEY] | String |
PersonDetails.EmployeeId | |
| CompanyId [KEY] | String |
CompanyDetails.CompanyId | |
| AlternateEmailAddress | String | ||
| AlternateJobTitle | String | ||
| City | String | ||
| CompanyName | String | ||
| CountryCode | String | ||
| DateInJob | Datetime | ||
| DateOfLastHire | Datetime | ||
| EmailAddress | String | ||
| EmplStatusStartDate | Datetime | ||
| EmployeeAddress1 | String | ||
| EmployeeAddress2 | String | ||
| EmployeeNumber | String | ||
| EmployeeStatus | String | ||
| EmployeeType | String | ||
| FirstName | String | ||
| FullTimeOrPartTime | String |
The allowed values are F, P. | |
| Gender | String | ||
| HireDate | Datetime | ||
| HomePhone | String | ||
| IsActive | Boolean | ||
| JobCode | String | ||
| JobGroupCode | String | ||
| LanguageCode | String | ||
| LastName | String | ||
| MiddleName | String | ||
| OrgLevel1Code | String | ||
| OrgLevel2Code | String | ||
| OrgLevel3Code | String | ||
| OrgLevel4Code | String | ||
| PersonId | String |
PersonDetails.PersonId | |
| PreferredName | String | ||
| Prefix | String | ||
| ProjectCode | String | ||
| SalaryOrHourly | String |
The allowed values are S, H. | |
| State | String | ||
| Suffix | String | ||
| SupervisorId | String | ||
| SupervisorName | String | ||
| TerminationDate | Datetime | ||
| UserIntegrationKey | String | ||
| WorkLocationCode | String | ||
| WorkPhone | String | ||
| ZipCode | String |