---
title: "EmployeeSchedules (Nmbrs)"
description: "Company Employee Schedules"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/nmbrs/Nmbrs.Employees.EmployeeSchedules
original: https://documentation.invantive.eu/en/datamodels/nmbrs/Nmbrs.Employees.EmployeeSchedules
updated: 2026-11-01T17:57:29Z
license: https://documentation.invantive.eu/en/
---

# EmployeeSchedules: Nmbrs Company Employee Schedules

`popular` `read only` `per partition` `XML`

- Catalog: `Nmbrs`
- Schema: `Employees`
- Label: Company Employee Schedules

The data in this table is partitioned per value of the `COMPANY_CODE` column.

Can only retrieve data.

## API Source

- XML service: `EmployeeService.asmx`
- XML topic: `Schedule_GetAll_AllEmployeesByCompany`
- XML path: `/nes:EmployeeSchedules/nes:Schedule_V2`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 48 |

The result can be cached on the client.

## Table Columns

The columns of the table `EmployeeSchedules` 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 |
|---|---|---|:---:|---|---|
| `COMPANY_CODE` | `int64` | Company ID | [x] |  |  |
| `CREATIONDATE` | `datetime` | Creation Date | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:CreationDate` |  |
| `EMPLOYEEID` | `int32` | Employee ID | [x] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeId` |  |
| `HOURSFRIDAY` | `decimal` | Friday (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursFriday` |  |
| `HOURSFRIDAY2` | `decimal` | Friday 2 (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursFriday2` |  |
| `HOURSMONDAY` | `decimal` | Monday (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursMonday` |  |
| `HOURSMONDAY2` | `decimal` | Monday 2 (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursMonday2` |  |
| `HOURSSATURDAY` | `decimal` | Saturday (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursSaturday` |  |
| `HOURSSATURDAY2` | `decimal` | Saturday 2 (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursSaturday2` |  |
| `HOURSSUNDAY` | `decimal` | Sunday (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursSunday` |  |
| `HOURSSUNDAY2` | `decimal` | Sunday 2 (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursSunday2` |  |
| `HOURSTHURSDAY` | `decimal` | Thursday (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursThursday` |  |
| `HOURSTHURSDAY2` | `decimal` | Thursday 2 (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursThursday2` |  |
| `HOURSTUESDAY` | `decimal` | Tuesday (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursTuesday` |  |
| `HOURSTUESDAY2` | `decimal` | Tuesday 2 (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursTuesday2` |  |
| `HOURSWEDNESDAY` | `decimal` | Wednesday (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursWednesday` |  |
| `HOURSWEDNESDAY2` | `decimal` | Wednesday 2 (hr) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:HoursWednesday2` |  |
| `ID` | `int32` | ID | [x] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:Id` |  |
| `PARTTIMEPERCENTAGE` | `decimal` | Part-time (%) | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:ParttimePercentage` |  |
| `STARTDATE` | `datetime` | Start Date | [ ] | `/soap:Envelope/soap:Body/nes:Schedule_GetAll_AllEmployeesByCompanyResponse/nes:Schedule_GetAll_AllEmployeesByCompanyResult/nes:EmployeeScheduleItem/nes:EmployeeSchedules/nes:Schedule_V2/nes:StartDate` |  |



## Release Notes

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

- [Nmbrs](/en/release-notes/drivers?driver=nmbrs)

