Employees
Employee records and profile information
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| LegalEntityId | Integer | ||
| LocationId | Integer |
Locations.Id | |
| String | |||
| FullName | String | ||
| IsActive | Boolean | ||
| IsTerminating | Boolean | ||
| CreatedAt | Datetime | ||
| AccessId | Integer | ||
| AddressLine1 | String | ||
| AddressLine2 | String | ||
| AgeNumber | Integer | ||
| BankNumber | String | ||
| BankNumberFormat | String | ||
| BirthName | String | ||
| Birthplace | String | ||
| BirthdayOn | Date | ||
| City | String | ||
| CompanyId | Integer | ||
| CompanyIdentifier | String | ||
| ContactName | String | ||
| ContactNumber | String | ||
| Country | String | ||
| CountryOfBirth | String | ||
| DisabilityPercentageCents | Integer | ||
| FirstName | String | ||
| Gender | String |
The allowed values are male, female, other. | |
| Identifier | String | ||
| IdentifierExpirationDate | Date | ||
| IdentifierType | String |
The allowed values are passport, national_id, other. | |
| IsAttendable | Boolean | ||
| LastName | String | ||
| LoginEmail | String | ||
| ManagerId | Integer | ||
| Nationality | String | ||
| PersonalEmail | String | ||
| PhoneNumber | String | ||
| PostalCode | String | ||
| PreferredName | String | ||
| Pronouns | String | ||
| SeniorityCalculationDate | Date | ||
| SocialSecurityNumber | String | ||
| State | String | ||
| SwiftBic | String | ||
| TerminatedOn | Date | ||
| TerminationObservations | String | ||
| TerminationReason | String | ||
| TerminationReasonType | String | ||
| TerminationTypeDescription | String | ||
| TimeoffManagerId | Integer |