AbsenceRequests: Gripp CRM Absence Requests
read only REST
- Catalog:
GrippCrm - Schema:
GrippCrm - Primary Keys:
id - Label: Absence Requests
Can only retrieve data.
API Source
- Endpoint:
api3.php
Performance Characteristics
| Characteristic | Value |
|---|---|
| Write rows per minute | 8,930 |
The result can be cached on the client.
Table Columns
The columns of the table AbsenceRequests are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
absencetype_ |
varchar2 |
itgen_gripp_absencetype_discr | writable, absencetype. |
||
absencetype_ |
int32 |
Absence Type ID | filters on the platform, writable, absencetype. |
||
absencetype_ |
varchar2 |
Absence Type Search Name | writable, absencetype. |
||
comment |
varchar2 |
Comment | filters on the platform, writable | ||
createdon_ |
datetime |
Created on Date | filters on the platform, writable, createdon. |
||
createdon_ |
varchar2 |
Created on Time Zone | writable, createdon. |
||
createdon_ |
int32 |
Created on Time Zone Type | writable, createdon. |
||
description |
varchar2 |
Description | filters on the platform, writable | ||
employee_ |
varchar2 |
itgen_gripp_employee_discr | writable, employee. |
||
employee_ |
int32 |
Employee ID | filters on the platform, writable, employee. |
||
employee_ |
varchar2 |
Employee Search Name | writable, employee. |
||
extendedproperties |
varchar2 |
Extended Properties | filters on the platform, writable | ||
id |
int32 |
ID | filters on the platform, writable | ||
searchname |
varchar2 |
Search Name | filters on the platform, writable | ||
updatedon_ |
datetime |
Updated on Date | filters on the platform, writable, updatedon. |
||
updatedon_ |
varchar2 |
Updated on Time Zone | writable, updatedon. |
||
updatedon_ |
int32 |
Updated on Time Zone Type | writable, updatedon. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Absence |
employee_ |
Employees.id |
Key |
Referenced By
- AbsenceRequestAbsenceRequestLines
parent_id(Key) - AbsenceRequestLines
absencerequest_id(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
Table GrippCrm..AbsenceRequests is renamed to GrippCrm.GrippCrm.AbsenceRequests
A statement that names GrippCrm..AbsenceRequests fails after the upgrade; use GrippCrm.GrippCrm.AbsenceRequests. The table has 17 columns. The driver registered its objects without a schema in release 26.0; from 27.0 the schema is GrippCrm.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 5