invantive documentation
Invantive Support ForumsLog In / Sign Up

Schedules: Exact Online Schedules

insert update delete per partition REST

  • Catalog: ExactOnlineREST
  • Schema: HRM
  • Primary Keys: ID
  • Label: Schedules

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

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /api/v1/{division}/HRM/Schedules
  • Metadata: /api/v1/{division}/hrm/$metadata

Performance Characteristics

Characteristic Value
Average access latency (ms) 5
Full scan rows per minute 7,200
Point query rows per minute 300
Write rows per minute 300

The result can be cached on the client.

Table Columns

The columns of the table Schedules 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
Active int16 Active filters on the platform, writable Obsolete.
AverageHours double Average Hours filters on the platform, writable Average hours per week in a schedule.
BillabilityTarget double Billability Target filters on the platform, writable
Code varchar2 Code filters on the platform, writable Schedule code.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Created (UTC) writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Creator Full Name filters on the platform, writable Name of creator.
Days double itgen_eol_days filters on the platform, writable Average days per week in the schedule.
Description varchar2 Description filters on the platform, writable Description of the schedule.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Division Chamber of Commerce Number writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Division IBAN Number writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division Company Name writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Division RSIN Number writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Division VAT Number writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Division Wage Tax Number writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Division Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administration Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Subscription Holder Name writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Subscription Holder Number writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Division Short Name writable Short name of the Exact Online division.
Employee guid Employee filters on the platform
EmployeeFullName varchar2 Employee Full Name filters on the platform
Employment guid Employment filters on the platform, writable Employment ID for schedule.
EmploymentCLA guid itgen_eol_employmentcla filters on the platform
EmploymentHID int32 Employment Number filters on the platform, writable Employment number.
EmploymentNumber int32 itgen_eol_employmentnumber filters on the platform
EndDate datetime End Date filters on the platform, writable End date of the schedule.
Hours double Hours filters on the platform, writable Number of hours per week in a CLA for which the schedule is built.
ID guid ID filters on the platform, writable Primary key.
LeaveHoursCompensation double Leave Compensation (hours) filters on the platform, writable Number of hours which are built up each week for later leave.
Main int16 Main filters on the platform, writable Indication if the schedule is a main schedule for a CLA. 1 = Yes, 0 = No.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modified (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Modified Full Name filters on the platform, writable Name of modifier.
PaymentParttimeFactor double Payment Part-time Factor filters on the platform, writable Part-time factor for payroll calculation. Value between 0 and 1.
ScheduleType int32 Schedule Type filters on the platform, writable Type of schedule. 1 = Hours and average days, 2 = Hours and specific days, 3 = Hours per day, 4 = Time frames per day.
ScheduleTypeDescription varchar2(240) Schedule Type Description filters on the platform, writable Description of the schedule type.
StartDate datetime Start Date filters on the platform, writable Week in the schedule which is used to start with. By default the number will be 1.
StartWeek int32 Start Week filters on the platform, writable Week to start the schedule from for an employee.

Keys

Key Column Refers to Kind Description
Schedules_Creator_Users_fk Creator Users.UserID Key
Schedules_Employment_Employments_fk Employment Employments.ID Key
Schedules_Modifier_Users_fk Modifier Users.UserID Key

Referenced By

Release Notes

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