# LeaveTypes: ionBIZ Leave Types - Catalog: `ionBIZ` - Label: Leave Types - Retrieve: true ## Table Columns The columns of the table `LeaveTypes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AcertaShowPayrollCodeOnNonWorkingDays` | `boolean` | Acerta Show Payroll Code on Non-Working Days | ☐ | | | `Active` | `boolean` | Active | ☐ | | | `ApprovalRequired` | `boolean` | Approval Required | ☐ | | | `CalculateInAbsenteeism` | `boolean` | Calculate in Absenteeism | ☐ | | | `Cluster` | `boolean` | Cluster | ☐ | | | `Color` | `string` | Colour | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DefaultDescription` | `string` | Default Description | ☐ | | | `DefaultName` | `string` | Default Name | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `Favourite` | `boolean` | Favourite | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Interval` | `decimal` | Interval | ☐ | | | `IsCluster` | `boolean` | Is Cluster | ☐ | | | `IsDefault` | `boolean` | Is Default | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `Limited` | `boolean` | Limited | ☐ | | | `MaxSelfApprovedLeaveDays` | `decimal` | Maximum Self-approved Leave Days | ☐ | | | `OverrulePublicHolidays` | `boolean` | Overrule Public Holidays | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `PayrollCode` | `string` | Payroll Code | ☐ | | | `RequestRequiresCustomerApproval` | `boolean` | Request Requires Customer Approval | ☐ | | | `RequestRequiresValidation` | `boolean` | Request Requires Validation | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `ShortName` | `string` | Short Name | ☐ | | | `UseForFlexCounter` | `boolean` | Use for Flex Counter | ☐ | | | `UseForOvertimeCounter` | `boolean` | Use for Overtime Counter | ☐ | |