invantive documentation
Invantive Support ForumsLog In / Sign Up

checkin_event: AFAS Profit itgen_aoe_checkin_event

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: itgen_aoe_checkin_event

Can only retrieve data.

Summary

CheckIn_Event

API Source

  • Endpoint: /connectors/CheckIn_Event
  • Metadata: metainfo/get/CheckIn_Event

Performance Characteristics

Characteristic Value
Average access latency (ms) 353
Full scan rows per minute 65,100
Point query rows per minute 169

The result can be cached on the client.

Table Columns

The columns of the table checkin_event 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
company varchar2(255) company fetched only when named, company
event_id int32 event_id fetched only when named, event_id
event_name varchar2(100) event_name fetched only when named, event_name
event_session_id int32 event_session_id fetched only when named, event_session_id
first_name varchar2(50) first_name fetched only when named, first_name
given_name varchar2(80) given_name fetched only when named, given_name
initials varchar2(15) initials fetched only when named, initials
location_id varchar2(25) location_id fetched only when named, location_id
location_name varchar2(100) location_name fetched only when named, location_name
org_id varchar2(15) org_id fetched only when named, org_id
person_id int32 person_id fetched only when named, person_id
surname varchar2(255) surname fetched only when named, surname
time_from datetime time_from fetched only when named, time_from
time_to datetime time_to fetched only when named, time_to