invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeSchedules: Nmbrs Employee Schedules

read only

  • Catalog: Nmbrs
  • Schema: Views
  • Label: Employee Schedules

Can only retrieve data.

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
EMPLOYEEID int32 Employee ID
EMP_COMPANY_CODE int64 Company ID
EMP_DISPLAYNAME varchar2 Display Name
EMP_ID int32 Employee ID
EMP_NUMBER int32 Employee Number
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)
PARTTIMEPERCENTAGE decimal Part-time (%)
STARTDATE datetime Start Date

Release Notes

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