# Leaves: ionBIZ Leaves - Catalog: `ionBIZ` - Label: Leaves - Retrieve: true ## Table Columns The columns of the table `Leaves` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ApprovalDate` | `datetimeoffset` | Approval Date | ☐ | | | `ApprovedByCustomer` | `boolean` | Approved by Customer | ☐ | | | `ApproverId` | `int32` | Approver ID | ☐ | | | `ApproverNotes` | `string` | Approver Notes | ☐ | | | `ClusterGroupId` | `int32` | Cluster Group ID | ☐ | | | `ClusterLeaveTypeId` | `int32` | Cluster Leave Type ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DateFrom` | `datetimeoffset` | Date from | ☐ | | | `DateUntil` | `datetimeoffset` | Date until | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `Duration` | `int64` | Duration | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `ExternalId` | `string` | External ID | ☐ | | | `ExternalLastSyncDate` | `datetimeoffset` | External Last Synchronization Date | ☐ | | | `ExtraValidation` | `int32` | Extra Validation | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LastModifiedDate` | `datetimeoffset` | Last Modified Date | ☐ | | | `LeaveStatus` | `int32` | Leave Status | ☐ | | | `LeaveTypeId` | `int32` | Leave Type ID | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `RecurrenceId` | `int32` | Recurrence ID | ☐ | | | `RequestDate` | `datetimeoffset` | Request Date | ☐ | | | `RequesterNotes` | `string` | Requester Notes | ☐ | | | `RequestValidatorId` | `int32` | Request Validator ID | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | |