invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeScheduleByEmployeeYearPeriod: Nmbrs Employee Period Year Schedule

read only XML

  • Catalog: Nmbrs
  • Schema: Employees
  • Label: Employee Period Year Schedule

Can only retrieve data.

API Source

  • XML service: EmployeeService.asmx
  • XML topic: Schedule_Get
  • XML path: /nes:Schedule_GetResult

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.
Period number Payroll period within year.
Year number Payroll year.

Table Columns

The columns of the table EmployeeScheduleByEmployeeYearPeriod 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
HOURSFRIDAY decimal Friday (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursFriday
HOURSFRIDAY2 decimal Friday 2 (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursFriday2
HOURSMONDAY decimal Monday (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursMonday
HOURSMONDAY2 decimal Monday 2 (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursMonday2
HOURSSATURDAY decimal Saturday (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursSaturday
HOURSSATURDAY2 decimal Saturday 2 (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursSaturday2
HOURSSUNDAY decimal Sunday (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursSunday
HOURSSUNDAY2 decimal Sunday 2 (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursSunday2
HOURSTHURSDAY decimal Thursday (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursThursday
HOURSTHURSDAY2 decimal Thursday 2 (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursThursday2
HOURSTUESDAY decimal Tuesday (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursTuesday
HOURSTUESDAY2 decimal Tuesday 2 (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursTuesday2
HOURSWEDNESDAY decimal Wednesday (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursWednesday
HOURSWEDNESDAY2 decimal Wednesday 2 (hr) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:HoursWednesday2
PARTTIMEPERCENTAGE decimal Part-time (%) /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:ParttimePercentage
STARTDATE datetime Start Date /soap:Envelope/soap:Body/nes:Schedule_GetResponse/nes:Schedule_GetResult/nes:StartDate

Release Notes

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