Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

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