EmployeeSchedules |
Catalog: Nmbrs
Schema: Employees
The data in this table is partitioned per value of the COMPANY_CODE column.
This is a read-only table. 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: Schedule_GetAll_AllEmployeesByCompany
Base XPath: /soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem
XPath: /nes:EmployeeSchedules/nes:Schedule_V2
Filters on API Server: CompanyID
Default Namespace Prefix: nes
Table Columns
The columns of the table EmployeeSchedules are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
COMPANY_CODE |
int64 |
Company ID |
☑ |
|
CREATIONDATE |
datetime |
Creation Date |
☐ |
|
EMPLOYEEID |
int32 |
Employee ID |
☑ |
|
HOURSFRIDAY |
decimal |
Friday (hr) |
☐ |
|
HOURSFRIDAY2 |
decimal |
Friday 2 (hr) |
☐ |
|
HOURSMONDAY |
decimal |
Monday (hr) |
☐ |
|
HOURSMONDAY2 |
decimal |
Monday 2 (hr) |
☐ |
|
HOURSSATURDAY |
decimal |
Saturday (hr) |
☐ |
|
HOURSSATURDAY2 |
decimal |
Saturday 2 (hr) |
☐ |
|
HOURSSUNDAY |
decimal |
Sunday (hr) |
☐ |
|
HOURSSUNDAY2 |
decimal |
Sunday 2 (hr) |
☐ |
|
HOURSTHURSDAY |
decimal |
Thursday (hr) |
☐ |
|
HOURSTHURSDAY2 |
decimal |
Thursday 2 (hr) |
☐ |
|
HOURSTUESDAY |
decimal |
Tuesday (hr) |
☐ |
|
HOURSTUESDAY2 |
decimal |
Tuesday 2 (hr) |
☐ |
|
HOURSWEDNESDAY |
decimal |
Wednesday (hr) |
☐ |
|
HOURSWEDNESDAY2 |
decimal |
Wednesday 2 (hr) |
☐ |
|
ID |
int32 |
ID |
☑ |
|
PARTTIMEPERCENTAGE |
decimal |
Part-time (%) |
☐ |
|
STARTDATE |
datetime |
Start Date |
☐ |
|
27-12-2021 10:56 Version 20.2.169-PROD+3633