Search Results freeform_string

Overview

The view IES_SVY_RESPONSES_V belongs to the Oracle E-Business Suite product family IES – Scripting, a component historically associated with the Oracle Advanced Outbound and TeleSales scripting framework used to present guided scripts and surveys to end users. In ETRM 12.1.1 and 12.2.2, this view acts as a reporting and integration layer over the survey response data model, exposing response records captured against survey questions and answers. The view is a straight projection over a single underlying table, IES_SVY_RESPONSES, and carries no additional join or filter logic beyond column renaming. Its principal role is to provide a stable, read-oriented interface through which reporting tools, integrations, and custom extensions can query survey responses without referencing the base table directly. Because it exposes the freeform answer columns, it is frequently the object consulted when users need to retrieve or report on free-text survey input.

Underlying Base Objects

According to the documented view text, the sole base object is the table IES_SVY_RESPONSES, aliased as SRS. No other referenced base objects are documented in the ETRM metadata. The view performs a simple SELECT … FROM IES_SVY_RESPONSES SRS, mapping each source column one-to-one to a view column. Notable implementation metadata states that the view is not implemented in this database, indicating that in some environments the underlying object may be absent or the view may not have been deployed. Where present, the relationship between view and base table is therefore direct and non-transforming, and any columns not listed in the view text remain accessible only through the base table.

Key Columns

• SURVEY_QUES_ANS_KEY — Identifier linking the response to its survey question-and-answer definition.
• SURVEY_CYCLE_ID — Identifies the specific administration cycle of the survey.
• RESPONSE_ID — Unique identifier for the response record.
• LIST_ENTRY_ID — References the selected list entry when the answer is chosen from a predefined list.
• FREEFORM_STRING — The free-text answer captured when the response is not constrained to a list; this is the column most often targeted by searches such as "freeform_string".
• FREEFORM_INT and FREEFORM_DATE — Numeric and date variants of freeform responses.
• INTERACTION_ID and TRANSACTION_ID — Contextual links to the interaction and transaction in which the response was collected.
• DEPLOYMENT_MEDIA_TYPE and RESPONSE_MEDIA_TYPE — Indicate the media through which the survey was deployed and answered.
• EXISTENCE, F_DELETEDFLAG, and SECURITY_GROUP_ID — Control record state, soft deletion, and multi-org/security grouping.

Common Use Cases and Queries

The view supports survey analytics, free-text answer extraction, and integration feeds. A representative query retrieving freeform answers is:

• SELECT RESPONSE_ID, SURVEY_CYCLE_ID, FREEFORM_STRING, FREEFORM_DATE FROM IES_SVY_RESPONSES_V WHERE FREEFORM_STRING IS NOT NULL AND F_DELETEDFLAG = 'N';
• SELECT SURVEY_CYCLE_ID, COUNT(*) FROM IES_SVY_RESPONSES_V WHERE EXISTENCE = 'Y' GROUP BY SURVEY_CYCLE_ID;
• SELECT a.RESPONSE_ID, a.FREEFORM_STRING FROM IES_SVY_RESPONSES_V a WHERE a.SECURITY_GROUP_ID = :p_security_group;

Analysts use these patterns to audit free-text responses, measure survey completion, and feed response data into downstream reporting or CRM integrations. All queries should account for soft-deleted records and security group restrictions.