# CalendarItems: Gripp CRM Calendar Items - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Calendar Items - Retrieve: True ## Table Columns The columns of the table `CalendarItems` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `_ordering` | `int32` | Sorting Order | ☐ | | | `calendaritememployee_discr` | `varchar2` | | ☐ | | | `calendaritememployee_id` | `int32` | Calendar Item Employee ID | ☐ | | | `calendaritememployee_searchname` | `varchar2` | Calendar Item Employee Search Name | ☐ | | | `completedon_date` | `datetime` | Completed on (Date) | ☐ | | | `completedon_timezone_type` | `int32` | Completed on (Timezone Type) | ☐ | | | `completedon_timezone` | `varchar2` | Completed on (Timezone) | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `date_date` | `datetime` | Date Date | ☐ | | | `date_timezone_type` | `int32` | Date Timezone Type | ☐ | | | `date_timezone` | `varchar2` | Date Timezone | ☐ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `hours` | `double` | Hours | ☐ | | | `id` | `int32` | ID | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `subject` | `varchar2` | Subject | ☐ | | | `task_discr` | `varchar2` | | ☐ | | | `task_id` | `int32` | Task ID | ☐ | | | `task_searchname` | `varchar2` | Task Search Name | ☐ | | | `time` | `datetime` | Time | ☐ | | | `timelineentry_discr` | `varchar2` | | ☐ | | | `timelineentry_id` | `int32` | Timeline Entry ID | ☐ | | | `timelineentry_searchname` | `varchar2` | Timeline Entry Search Name | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | |