Employees
Generated schema file.
Columns
Name | Type | References | |
Id | String | ||
EmployeeCode | String | ||
LastName | String | ||
FirstName | String | ||
LastNameEnglish | String | ||
FirstNameEnglish | String | ||
LastNamePhonetic | String | ||
FirstNamePhonetic | String | ||
BirthDate | Date | ||
Gender | String | ||
GenderName | String | ||
String | |||
MobilePhone | String | ||
EmploymentType | String | ||
EmploymentTypeName | String | ||
EnrollmentStatus | String | ||
EnrollmentStatusName | String | ||
JoiningDate | Date | ||
RetirementDate | Date | ||
RejoiningDate | Date | ||
ExcludesImport | Boolean | ||
PositionEffectiveDate | Date | ||
PositionDepartmentCode | String | ||
PositionDepartmentName | String | ||
PositionJobTitle | String | ||
PositionJobTitleName | String | ||
AddressesMetaTotalCount | Integer | ||
AddressesDataId | Integer | ||
AddressesDataEmployeeId | String | ||
AddressesDataMovingDate | Date | ||
AddressesDataPostNumber | String | ||
AddressesDataState | String | ||
AddressesDataMunicipalities | String | ||
AddressesDataHouseNumber | String | ||
AddressesDataBuilding | String | ||
AddressesDataHomePhone | String | ||
AddressesDataMobilePhone | String | ||
AddressesDataEmail1 | String | ||
AddressesDataEmail2 | String | ||
AddressesDataCreatedDate | Datetime | ||
AddressesDataUpdatedDate | Datetime | ||
FamilyRegistersMetaTotalCount | Integer | ||
FamilyRegistersDataId | Integer | ||
FamilyRegistersDataEmployeeId | String | ||
FamilyRegistersDataLastName | String | ||
FamilyRegistersDataFirstName | String | ||
FamilyRegistersDataLastNamePhonetic | String | ||
FamilyRegistersDataFirstNamePhonetic | String | ||
FamilyRegistersDataPostNumber | String | ||
FamilyRegistersDataState | String | ||
FamilyRegistersDataMunicipalities | String | ||
FamilyRegistersDataHouseNumber | String | ||
FamilyRegistersDataBuilding | String | ||
FamilyRegistersDataCreatedDate | Datetime | ||
FamilyRegistersDataUpdatedDate | Datetime | ||
TransportationExpensesData | String | ||
TransportationExpensesMetaTotalCount | Integer |