invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeDepartments: Horeko Employee Departments

read only

  • Catalog: Horeko
  • Schema: Views
  • Label: Employee Departments

Can only retrieve data.

Table Columns

The columns of the table EmployeeDepartments are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
Birthday datetime Birthday
Email varchar2 Email
EmergencyPhoneNo varchar2 Emergency Phone Number
EmployedSince datetime Employed since
EmployeeBirthday datetime Birthday
EmployeeEmail varchar2 Email
EmployeeEmergencyPhoneNo varchar2 Emergency Phone Number
EmployeeEmployedSince datetime Employed since
EmployeeExternalSystemId int32 External System ID
EmployeeFirstName varchar2 First Name
EmployeeFullName varchar2 Full Name
EmployeeHasDriverLicense char Has Driver License
EmployeeHasERO char Has ERO
EmployeeHasSocialHygene char Has Social Hygene
EmployeeId int32 ID
EmployeeImage varchar2 Image
EmployeeInactive char Inactive
EmployeeLastName varchar2 Last Name
EmployeeMidName varchar2 Middle Name
EmployeeMobilePhoneNo varchar2 Mobile Phone Number
EmployeePhoneNo varchar2 Phone Number
ExternalSystemId int32 External System ID
FirstName varchar2 First Name
HasDriverLicense char Has Driver License
HasERO char Has ERO
HasSocialHygene char Has Social Hygene
Id int32 ID
Id_2 int32 itgen_horeko_id_2
Image varchar2 Image
Inactive char Inactive
LastName varchar2 Last Name
MidName varchar2 Middle Name
MobilePhoneNo varchar2 Mobile Phone Number
Name varchar2 Name
PhoneNo varchar2 Phone Number

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: