Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

EmployeeEstimatedCostsPerHourByEmployeeYearPeriod: NMBRS Estimated Costs per Hour by Employee, Year and Period

Catalog: Nmbrs

Schema: Employees

Label: Estimated Costs per Hour by Employee, Year and Period

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

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

XPath: /nes:Salary_GetEstimatedCostPerHourResult

Filters on API Server: EmployeeId- Year- Period

Default Namespace Prefix: nes

Table Function Columns

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

Name

Data Type

Label

Required

Documentation

EMPLOYEEID

int32

Employee ID

 

VALUE

decimal

Value

 

 

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