invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeAbsences: Nmbrs Employee Absences

popular read only per partition XML

  • Catalog: Nmbrs
  • Schema: Employees
  • Label: Employee Absences

The data in this table is partitioned per value of the COMPANY_CODE column.

Can only retrieve data.

API Source

  • XML service: EmployeeService.asmx
  • XML topic: Absence_GetAll_AllEmployeesByCompany
  • XML path: /nes:EmployeeAbsence

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Table Columns

The columns of the table EmployeeAbsences 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
ABSENCEID int32 Absence ID /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:AbsenceId
COMMENT varchar2 Comment /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:Comment
COMPANY_CODE int64 Company ID
DOSSIER varchar2 File /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:Dossier
DOSSIERNR int32 File Number /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:Dossiernr
EMPLOYEEID int32 Employee ID /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:EmployeeId
END datetime End /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:End
PERCENTAGE int32 Percentage /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:Percentage
REGISTRATIONENDDATE datetime Registration End Date /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:RegistrationEndDate
REGISTRATIONSTARTDATE datetime Registration Start Date /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:RegistrationStartDate
START datetime Start /soap:Envelope/soap:Body/nes:Absence_GetAll_AllEmployeesByCompanyResponse/nes:Absence_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAbsence/nes:Start

Release Notes

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