---
title: "user_input (Odoo)"
description: "itgen_odoo_user_input"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.survey.user_input
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.survey.user_input
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# user_input: Odoo itgen_odoo_user_input

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `survey`
- Label: itgen_odoo_user_input

Survey User Input

Can only retrieve data.

## Summary

Metadata for a set of one user's answers to a particular survey

## Table Columns

The columns of the table `user_input` 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 |
|---|---|---|:---:|---|---|
| `access_token` | `varchar2` | Identification token | [x] |  |  |
| `activity_calendar_event_id` | `varchar2` |  | [ ] |  |  |
| `activity_calendar_event_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_date_deadline` | `datetime` | Next Activity Deadline | [ ] |  |  |
| `activity_exception_decoration` | `varchar2` | Activity Exception Decoration | [ ] |  | Type of the exception activity on record. |
| `activity_exception_icon` | `varchar2` | Icon | [ ] |  | Icon to indicate an exception activity. |
| `activity_ids` | `varchar2` |  | [ ] |  |  |
| `activity_state` | `varchar2` | Activity State | [ ] |  | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. |
| `activity_summary` | `varchar2` | Next Activity Summary | [ ] |  |  |
| `activity_type_icon` | `varchar2` | Activity Type Icon | [ ] |  | Font awesome icon e.g. fa-tasks |
| `activity_type_id` | `varchar2` |  | [ ] |  |  |
| `activity_type_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_user_id` | `varchar2` |  | [ ] |  |  |
| `activity_user_id_label` | `varchar2` |  | [ ] |  |  |
| `attempts_count` | `int32` | Attempts Count | [ ] |  |  |
| `attempts_limit` | `int32` | Number of attempts | [ ] |  |  |
| `attempts_number` | `int32` | Attempt n° | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `deadline` | `datetime` | Deadline | [ ] |  | Datetime until customer can open the survey and submit answers |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `email` | `varchar2` | Email | [ ] |  |  |
| `end_datetime` | `datetime` | End date and time | [ ] |  |  |
| `has_message` | `boolean` | Has Message | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `invite_token` | `varchar2` | Invite token | [ ] |  |  |
| `is_attempts_limited` | `boolean` | Limited number of attempts | [ ] |  | Check this option if you want to limit the number of attempts per user |
| `is_session_answer` | `boolean` | Is in a Session | [ ] |  | Is that user input part of a survey session or not. |
| `last_displayed_page_id` | `varchar2` |  | [ ] |  |  |
| `last_displayed_page_id_label` | `varchar2` |  | [ ] |  |  |
| `message_attachment_count` | `int32` | Attachment Count | [ ] |  |  |
| `message_follower_ids` | `varchar2` |  | [ ] |  |  |
| `message_has_error` | `boolean` | Message Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_has_error_counter` | `int32` | Number of errors | [ ] |  | Number of messages with delivery error |
| `message_has_sms_error` | `boolean` | SMS Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_ids` | `varchar2` |  | [ ] |  |  |
| `message_is_follower` | `boolean` | Is Follower | [ ] |  |  |
| `message_main_attachment_id` | `varchar2` |  | [ ] |  |  |
| `message_main_attachment_id_label` | `varchar2` |  | [ ] |  |  |
| `message_needaction` | `boolean` | Action Needed | [ ] |  | If checked, new messages require your attention. |
| `message_needaction_counter` | `int32` | Number of Actions | [ ] |  | Number of messages which requires an action |
| `message_partner_ids` | `varchar2` |  | [ ] |  |  |
| `my_activity_date_deadline` | `datetime` | My Activity Deadline | [ ] |  |  |
| `nickname` | `varchar2` | Nickname | [ ] |  | Attendee nickname, mainly used to identify them in the survey session leaderboard. |
| `partner_id` | `varchar2` |  | [ ] |  |  |
| `partner_id_label` | `varchar2` |  | [ ] |  |  |
| `predefined_question_ids` | `varchar2` |  | [ ] |  |  |
| `question_time_limit_reached` | `boolean` | Question Time Limit Reached | [ ] |  |  |
| `scoring_percentage` | `numeric` | Score (%) | [ ] |  |  |
| `scoring_success` | `boolean` | Quizz Passed | [ ] |  |  |
| `scoring_total` | `numeric` | Total Score | [ ] |  |  |
| `scoring_type` | `varchar2` | Scoring | [ ] |  |  |
| `slide_id` | `varchar2` |  | [ ] |  | The related course slide when there is no membership information |
| `slide_id_label` | `varchar2` |  | [ ] |  | The related course slide when there is no membership information |
| `slide_partner_id` | `varchar2` |  | [ ] |  | Slide membership information for the logged in user |
| `slide_partner_id_label` | `varchar2` |  | [ ] |  | Slide membership information for the logged in user |
| `start_datetime` | `datetime` | Start date and time | [ ] |  |  |
| `state` | `varchar2` | Status | [ ] |  |  |
| `survey_id` | `varchar2` |  | [ ] |  |  |
| `survey_id_label` | `varchar2` |  | [ ] |  |  |
| `survey_time_limit_reached` | `boolean` | Survey Time Limit Reached | [ ] |  |  |
| `test_entry` | `boolean` | Test Entry | [ ] |  |  |
| `user_input_line_ids` | `varchar2` |  | [ ] |  |  |
| `website_message_ids` | `varchar2` |  | [ ] |  | Website communication history |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

