Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

EmployeeDepartmentsCurrentByEmployee: NMBRS Employee Current Department

Catalog: Nmbrs

Schema: Employees

Label: Employee Current Department

This is a read-only table function. The NMBRS API may not support changing the data or the Invantive SQL driver for NMBRS does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the NMBRS API.

NMBRS API URL: EmployeeService.asmx

Topic: Department_GetCurrent

Base XPath: /soap:Envelope/soap:Body/nes:Department_GetCurrentResponse

XPath: /nes:Department_GetCurrentResult

Filters on API Server: EmployeeId

Default Namespace Prefix: nes

Table Function Columns

The columns of the table function EmployeeDepartmentsCurrentByEmployee are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

CODE

int32

Code

 

DESCRIPTION

string

Description

 

EMPLOYEEID

int32

Employee ID

 

ID

int32

ID

 

 

27-12-2021 10:56 Version 20.2.169-PROD+3633