invantive documentation
Invantive Support ForumsLog In / Sign Up

CompanyCurrentSchedules: Nmbrs Company Current Schedule

read only per partition XML

  • Catalog: Nmbrs
  • Schema: Company
  • Label: Company Current Schedule

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

Can only retrieve data.

API Source

  • XML service: CompanyService.asmx
  • XML topic: Schedule_GetCurrent
  • XML path: /ncs:Schedule_GetCurrentResult

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Table Columns

The columns of the table CompanyCurrentSchedules 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
FULLTIMESCHEDULEFOURHOURSFRIDAY decimal Schedule 4 Friday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursFriday
FULLTIMESCHEDULEFOURHOURSFRIDAY2 decimal Schedule 4 Friday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursFriday2
FULLTIMESCHEDULEFOURHOURSMONDAY decimal Schedule 4 Monday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursMonday
FULLTIMESCHEDULEFOURHOURSMONDAY2 decimal Schedule 4 Monday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursMonday2
FULLTIMESCHEDULEFOURHOURSSATURDAY decimal Schedule 4 Saturday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursSaturday
FULLTIMESCHEDULEFOURHOURSSATURDAY2 decimal Schedule 4 Saturday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncses:HoursSaturday2
FULLTIMESCHEDULEFOURHOURSSUNDAY decimal Schedule 4 Sunday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursSunday
FULLTIMESCHEDULEFOURHOURSSUNDAY2 decimal Schedule 4 Sunday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursSunday2
FULLTIMESCHEDULEFOURHOURSTHURSDAY decimal Schedule 4 Thursday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursThursday
FULLTIMESCHEDULEFOURHOURSTHURSDAY2 decimal Schedule 4 Thursday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursThursday2
FULLTIMESCHEDULEFOURHOURSTUESDAY decimal Schedule 4 Tuesday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursTuesday
FULLTIMESCHEDULEFOURHOURSTUESDAY2 decimal Schedule 4 Tuesday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursTuesday2
FULLTIMESCHEDULEFOURHOURSWEDNESDAY decimal Schedule 4 Wednesday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursWednesday
FULLTIMESCHEDULEFOURHOURSWEDNESDAY2 decimal Schedule 4 Wednesday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursWednesday2
FULLTIMESCHEDULEFOURSCHEDULECALCMETHOD varchar2 Schedule 4 Calculation Method /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:ScheduleCalcMethod
FULLTIMESCHEDULEONEHOURSFRIDAY decimal Schedule 1 Friday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursFriday
FULLTIMESCHEDULEONEHOURSFRIDAY2 decimal Schedule 1 Friday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursFriday2
FULLTIMESCHEDULEONEHOURSMONDAY decimal Schedule 1 Monday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursMonday
FULLTIMESCHEDULEONEHOURSMONDAY2 decimal Schedule 1 Monday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursMonday2
FULLTIMESCHEDULEONEHOURSSATURDAY decimal Schedule 1 Saturday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursSaturday
FULLTIMESCHEDULEONEHOURSSATURDAY2 decimal Schedule 1 Saturday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursSaturday2
FULLTIMESCHEDULEONEHOURSSUNDAY decimal Schedule 1 Sunday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursSunday
FULLTIMESCHEDULEONEHOURSSUNDAY2 decimal Schedule 1 Sunday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursSunday2
FULLTIMESCHEDULEONEHOURSTHURSDAY decimal Schedule 1 Thursday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursThursday
FULLTIMESCHEDULEONEHOURSTHURSDAY2 decimal Schedule 1 Thursday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursThursday2
FULLTIMESCHEDULEONEHOURSTUESDAY decimal Schedule 1 Tuesday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursTuesday
FULLTIMESCHEDULEONEHOURSTUESDAY2 decimal Schedule 1 Tuesday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursTuesday2
FULLTIMESCHEDULEONEHOURSWEDNESDAY decimal Schedule 1 Wednesday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursWednesday
FULLTIMESCHEDULEONEHOURSWEDNESDAY2 decimal Schedule 1 Wednesday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursWednesday2
FULLTIMESCHEDULEONESCHEDULECALCMETHOD varchar2 Schedule 1 Calculation Method /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:ScheduleCalcMethod
FULLTIMESCHEDULETHREEHOURSFRIDAY decimal Schedule 3 Friday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursFriday
FULLTIMESCHEDULETHREEHOURSFRIDAY2 decimal Schedule 3 Friday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursFriday2
FULLTIMESCHEDULETHREEHOURSMONDAY decimal Schedule 3 Monday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursMonday
FULLTIMESCHEDULETHREEHOURSMONDAY2 decimal Schedule 3 Monday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursMonday2
FULLTIMESCHEDULETHREEHOURSSATURDAY decimal Schedule 3 Saturday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursSaturday
FULLTIMESCHEDULETHREEHOURSSATURDAY2 decimal Schedule 3 Saturday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursSaturday2
FULLTIMESCHEDULETHREEHOURSSUNDAY decimal Schedule 3 Sunday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursSunday
FULLTIMESCHEDULETHREEHOURSSUNDAY2 decimal Schedule 3 Sunday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursSunday2
FULLTIMESCHEDULETHREEHOURSTHURSDAY decimal Schedule 3 Thursday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursThursday
FULLTIMESCHEDULETHREEHOURSTHURSDAY2 decimal Schedule 3 Thursday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursThursday2
FULLTIMESCHEDULETHREEHOURSTUESDAY decimal Schedule 3 Tuesday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursTuesday
FULLTIMESCHEDULETHREEHOURSTUESDAY2 decimal Schedule 3 Tuesday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursTuesday2
FULLTIMESCHEDULETHREEHOURSWEDNESDAY decimal Schedule 3 Wednesday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursWednesday
FULLTIMESCHEDULETHREEHOURSWEDNESDAY2 decimal Schedule 3 Wednesday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursWednesday2
FULLTIMESCHEDULETHREESCHEDULECALCMETHOD varchar2 Schedule 3 Calculation Method /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:ScheduleCalcMethod
FULLTIMESCHEDULETWOHOURSFRIDAY decimal Schedule 2 Friday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursFriday
FULLTIMESCHEDULETWOHOURSFRIDAY2 decimal Schedule 2 Friday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursFriday2
FULLTIMESCHEDULETWOHOURSMONDAY decimal Schedule 2 Monday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursMonday
FULLTIMESCHEDULETWOHOURSMONDAY2 decimal Schedule 2 Monday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursMonday2
FULLTIMESCHEDULETWOHOURSSATURDAY decimal Schedule 2 Saturday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursSaturday
FULLTIMESCHEDULETWOHOURSSATURDAY2 decimal Schedule 2 Saturday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursSaturday2
FULLTIMESCHEDULETWOHOURSSUNDAY decimal Schedule 2 Sunday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursSunday
FULLTIMESCHEDULETWOHOURSSUNDAY2 decimal Schedule 2 Sunday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursSunday2
FULLTIMESCHEDULETWOHOURSTHURSDAY decimal Schedule 2 Thursday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursThursday
FULLTIMESCHEDULETWOHOURSTHURSDAY2 decimal Schedule 2 Thursday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursThursday2
FULLTIMESCHEDULETWOHOURSTUESDAY decimal Schedule 2 Tuesday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursTuesday
FULLTIMESCHEDULETWOHOURSTUESDAY2 decimal Schedule 2 Tuesday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursTuesday2
FULLTIMESCHEDULETWOHOURSWEDNESDAY decimal Schedule 2 Wednesday 1 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursWednesday
FULLTIMESCHEDULETWOHOURSWEDNESDAY2 decimal Schedule 2 Wednesday 2 (Hours) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursWednesday2
FULLTIMESCHEDULETWOSCHEDULECALCMETHOD varchar2 Schedule 2 Calculation Method /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:ScheduleCalcMethod

Release Notes

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