Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

EmployeesActive

Catalog: Nmbrs

Schema: Employees

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

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: List_GetByCompany

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

XPath: /nes:List_GetByCompanyResult/nes:Employee

Filters on API Server: CompanyId- active (active )

Default Namespace Prefix: nes

Table Function Columns

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

Name

Data Type

Label

Required

Documentation

COMPANY_CODE

int64

Company ID

 

DISPLAYNAME

string

Display Name

 

ID

int32

ID

 

NUMBER

int32

Number

 

 

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