API Data Provider - Online Help

TimeOff

Time off request management using PTO API.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Time off request ID

WorkspaceId String False

Workspaces.Id

Workspace ID

PolicyId String False

Policies.Id

Policy ID

PolicyName String True

Policy name

TimeUnit String True

Time unit (DAYS, HOURS)

UserId String False

WorkspaceUsers.Id

User ID

UserName String True

User name

UserEmail String True

User email

UserTimeZone String True

User timezone

PeriodStart Date False

Time off period start date (YYYY-MM-DD)

PeriodEnd Date False

Time off period end date (YYYY-MM-DD)

Days Integer False

Number of days for the time off request

HalfDay Boolean False

Is half day request

HalfDayPeriod String False

Half day period type

HalfDayHours Decimal True

Half day hours

Note String False

Request notes

StatusType String True

Status type

The allowed values are PENDING, APPROVED, REJECTED, CANCELLED.

StatusChangedByUserId String True

User who changed status

StatusChangedByUserName String True

Name of user who changed status

StatusChangedForUserName String True

Name of user for whom status changed

StatusChangedAt Datetime True

Status change timestamp

StatusNote String True

Status note

BalanceDiff Decimal True

Balance difference

CreatedAt Datetime True

Creation timestamp

Balance Decimal True

Current balance

RequesterUserId String True

Requester user ID

RequesterUserName String True

Requester user name

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770.0