invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeCustomAttributeValuesByEmployeeId: Bouw7 Employee Custom Attribute Values by Employee ID

read only REST

  • Catalog: Bouw7
  • Schema: Organization
  • Label: Employee Custom Attribute Values by Employee ID

Returns a single employee based on the given ID. Returns a single employee based on the given ID.

Can only retrieve data.

Summary

Returns a single employee based on the given ID.

API Source

  • Endpoint: /organization/employee/{id}
  • Operation: get /organization/employee/{id}

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table EmployeeCustomAttributeValuesByEmployeeId 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
address varchar2 Address filters on the platform, writable, ::ancestor.address The address of the employee.
afasWarehouse varchar2 AFAS Warehouse filters on the platform, writable, ::ancestor.afasWarehouse The warehouse material bookings of an employee will be booked on. Only applicable for AFAS.
avatarFileHash varchar2 Avatar File Hash filters on the platform, writable, ::ancestor.avatarFileHash The hash of the avatar/profile picture of this employee.
birthDate datetime Birth Date filters on the platform, writable, ::ancestor.birthDate The birth date of the employee.
bsn varchar2 SSN filters on the platform, writable, ::ancestor.bsn The BSN of the employee.
city varchar2 City filters on the platform, writable, ::ancestor.city The city of the employee.
createdAt datetime Created at filters on the platform, writable, ::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, ::ancestor.createdBy The user that created the entity.
customAttribute_fieldType varchar2 Custom Attribute Field Type writable, customAttribute.fieldType The I18N key of the field type.
customAttribute_fieldTypeId int64 Custom Attribute Field Type ID writable, customAttribute.fieldTypeId The ID of the field type.
customAttribute_id int64 Custom Attribute ID writable, customAttribute.id The ID of the custom attribute.
customAttribute_isDisplayedOnCompletion char Custom Attribute Is Displayed on Completion writable, customAttribute.isDisplayedOnCompletion Whether the custom attribute is displayed on a completion document.
customAttribute_isDisplayedOnInvoice char Custom Attribute Is Displayed on Invoice writable, customAttribute.isDisplayedOnInvoice Whether the custom attribute is displayed on an invoice document.
customAttribute_isReadOnly char Custom Attribute Is Read-only writable, customAttribute.isReadOnly Whether the custom attribute is a read-only field.
customAttribute_isRequired char Custom Attribute Is Required writable, customAttribute.isRequired Whether the custom attribute is a required field.
customAttribute_name varchar2 Custom Attribute Name writable, customAttribute.name The name of the custom attribute.
dateOfEmployment varchar2 Date of Employment filters on the platform, writable, ::ancestor.dateOfEmployment The date of employment of the employee in Y-m-d format.
dateOfResignation varchar2 Date of Resignation filters on the platform, writable, ::ancestor.dateOfResignation The date of resignation of the employee in Y-m-d format.
department_id int64 Department ID filters on the platform, writable, ::ancestor.department.id ID of the department.
department_name varchar2 Department Name filters on the platform, writable, ::ancestor.department.name Name of the department.
employeeMail varchar2 Employee Mail filters on the platform, writable, ::ancestor.employeeMail The email of the employee.
external char External filters on the platform, writable, ::ancestor.external Whether the employee is external.
firstName varchar2 First Name filters on the platform, writable, ::ancestor.firstName The first name of the employee.
function varchar2 Function filters on the platform, writable, ::ancestor.function The function of the employee.
hourlyRate varchar2 Hourly Rate filters on the platform, writable, ::ancestor.hourlyRate The hourly rate
id int64 ID filters on the platform, writable, ::ancestor.id The ID of the employee.
lastName varchar2 Last Name filters on the platform, writable, ::ancestor.lastName The last name of the employee.
payrollDivision_description varchar2 Payroll Division Description filters on the platform, writable, ::ancestor.payrollDivision.description The description of the division.
payrollDivision_exactDivisionId varchar2 Payroll Division Exact Division ID filters on the platform, writable, ::ancestor.payrollDivision.exactDivisionId The division ID of an Exact Online environment.
payrollDivision_glAccountCode varchar2 Payroll Division GL Account Code filters on the platform, writable, ::ancestor.payrollDivision.glAccountCode A default general ledger account code to use for sales related items.
payrollDivision_glAccountCodePurchase varchar2 Payroll Division GL Account Code Purchase filters on the platform, writable, ::ancestor.payrollDivision.glAccountCodePurchase A default general ledger account code to use for purchase related items.
payrollDivision_id int64 Payroll Division ID filters on the platform, writable, ::ancestor.payrollDivision.id The ID of the division.
payrollDivision_journalCode varchar2 Payroll Division Journal Code filters on the platform, writable, ::ancestor.payrollDivision.journalCode A default journal code to use for sales related items.
payrollDivision_journalCodePurchase varchar2 Payroll Division Journal Code Purchase filters on the platform, writable, ::ancestor.payrollDivision.journalCodePurchase A default journal code to use for purchase related items.
payrollDivision_salesInvoiceNumberPrefix varchar2(3) Payroll Division Sales Invoice Number Prefix filters on the platform, writable, ::ancestor.payrollDivision.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
phoneNumber varchar2 Phone Number filters on the platform, writable, ::ancestor.phoneNumber The phone number of the employee.
scabEmployeeId varchar2 SCAB Employee ID filters on the platform, writable, ::ancestor.scabEmployeeId The internal ID of the Scab employee associated with this employee.
sellingHourlyRate varchar2 Selling Hourly Rate filters on the platform, writable, ::ancestor.sellingHourlyRate The selling hourly rate
signatureFileHash varchar2 Signature File Hash filters on the platform, writable, ::ancestor.signatureFileHash The hash of the signature file of this employee.
updatedAt datetime Updated At filters on the platform, writable, ::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, ::ancestor.updatedBy The user that last updated the entity.
userActivatedAt varchar2 User Activated at filters on the platform, writable, ::ancestor.userActivatedAt The activation date of the user in ATOM/ISO-8601 format.
userInvitationSentAt varchar2 User Invitation Sent at filters on the platform, writable, ::ancestor.userInvitationSentAt The invitation date of the user in ATOM/ISO-8601 format, for as long as the user has not accepted the invitation to this organization, NULL otherwise.
userType int64 User Type filters on the platform, writable, ::ancestor.userType The type of user associated with this employee. 0 = None, 1 = Admin, 2 = Basic, 3 = Platform.
username varchar2 User Name filters on the platform, writable, ::ancestor.username The username of the user associated with this employee.
value varchar2 Value writable, value The value of the custom attribute.
workhoursFriday varchar2 Work Hours Friday filters on the platform, writable, ::ancestor.workhoursFriday The standard amount of workhours on a friday.
workhoursMonday varchar2 Work Hours Monday filters on the platform, writable, ::ancestor.workhoursMonday The standard amount of workhours on a monday.
workhoursSaturday varchar2 Work Hours Saturday filters on the platform, writable, ::ancestor.workhoursSaturday The standard amount of workhours on a saturday.
workhoursSunday varchar2 Work Hours Sunday filters on the platform, writable, ::ancestor.workhoursSunday The standard amount of workhours on a sunday.
workhoursThursday varchar2 Work Hours Thursday filters on the platform, writable, ::ancestor.workhoursThursday The standard amount of workhours on a thursday.
workhoursTuesday varchar2 Work Hours Tuesday filters on the platform, writable, ::ancestor.workhoursTuesday The standard amount of workhours on a tuesday.
workhoursWednesday varchar2 Work Hours Wednesday filters on the platform, writable, ::ancestor.workhoursWednesday The standard amount of workhours on a wednesday.
workload varchar2 Work Load filters on the platform, writable, ::ancestor.workload The workload of the employee, this value is ignored when the workhour fields contain a value.
zipCode varchar2 ZIP Code filters on the platform, writable, ::ancestor.zipCode ZIP code of the address.

Release Notes

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