Responses Table in Oracle Clinical

Oracle Clinical stores all values to questions in a table called the
Responses table.
The responses are stored either in Value_Text or
Exception_Value_Text.
− Data is stored in VALUE_TEXT if the data type, length, format
and value is valid.
− Data is stored in EXCEPTION_VALUE_TEXT if the data type,
length, format or value is not valid.
The VALUE_TEXT and EXCEPTION_VALUE_TEXT are extended
attributes of the questions.