# EmployeeYearlyLeaveBudgets: Gripp CRM Employee Yearly Leave Budgets - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Employee Yearly Leave Budgets - Retrieve: True ## Table Columns The columns of the table `EmployeeYearlyLeaveBudgets` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `balance` | `decimal` | Balance | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `employee_discr` | `varchar2` | | ☐ | | | `employee_id` | `int32` | Employee ID | ☑ | | | `employee_searchname` | `varchar2` | Employee Search Name | ☑ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `id` | `int32` | ID | ☐ | | | `leavetype_discr` | `varchar2` | | ☐ | | | `leavetype_id` | `int32` | Leave Type ID | ☐ | | | `leavetype_searchname` | `varchar2` | Leave Type Search Name | ☐ | | | `newsaldothisyear` | `decimal` | New Balance this Year | ☐ | | | `note` | `varchar2` | Note | ☐ | | | `takeoverlastyear` | `decimal` | Take over Last Year | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | | | `year` | `int32` | Year | ☐ | |