invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeSalariesCurrentByEmployee: Nmbrs Employee Current Salary

read only XML

  • Catalog: Nmbrs
  • Schema: Employees
  • Label: Employee Current Salary

Can only retrieve data.

API Source

  • XML service: EmployeeService.asmx
  • XML topic: Salary_GetCurrent
  • XML path: /nes:Salary_GetCurrentResult

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
EmployeeId number Numeric ID of employee.

Table Columns

The columns of the table EmployeeSalariesCurrentByEmployee 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
EMPLOYEEID int32 Employee ID
SALARYTABLE_SCHAAL_DESCRIPTION varchar2 Salary Table Scale Description /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:SalaryTable/nes:Schaal/nes:SchaalDescription
SALARYTABLE_SCHAAL_SCALE varchar2 Salary Table Scale /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:SalaryTable/nes:Schaal/nes:Scale
SALARYTABLE_SCHAAL_SCALEPERCENTAGEMAX decimal Salary Table Scale Percentage Maximum /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:SalaryTable/nes:Schaal/nes:ScalePercentageMax
SALARYTABLE_SCHAAL_SCALEPERCENTAGEMIN decimal Salary Table Scale Percentage Minimum /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:SalaryTable/nes:Schaal/nes:ScalePercentageMin
SALARYTABLE_SCHAAL_SCALEVALUE decimal Salary Table Scale Value /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:SalaryTable/nes:Schaal/nes:ScaleValue
SALARYTABLE_TREDE_STEP varchar2 Salary Table Level /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:SalaryTable/nes:Trede/nes:Step
SALARYTABLE_TREDE_STEPDESCRIPTION varchar2 Salary Table Level Description /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:SalaryTable/nes:Trede/nes:StepDescription
SALARYTABLE_TREDE_STEPVALUE decimal Salary Table Level Value /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:SalaryTable/nes:Trede/nes:StepValue
STARTDATE datetime Start Date /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:StartDate
TYPE varchar2 Type /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:Type One of 'None', 'Bruto_Salaris_Fulltime', 'Bruto_Salaris_Partime', 'Bruto_Uurloon', 'Netto_Salaris_Partime_incl_looncomp', 'Netto_Salaris_Partime_excl_looncomp', 'Netto_Uurloon_excl_looncomp', 'Werkgerverslasten', 'Netto_Uurloon_incl_looncomp'.
VALUE decimal Value /soap:Envelope/soap:Body/nes:Salary_GetCurrentResponse/nes:Salary_GetCurrentResult/nes:Value

Release Notes

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