Search Results ies_svy_response_entries




Overview
Explore in AI Chat

Overview

The IES_SVY_RESPONSE_ENTRIES table is a core transactional data object within the IES – Scripting (Interactive Scripting / iScript) module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores individual survey response entries collected through deployed iScript surveys, capturing the granular answers, media, and status metadata associated with each survey interaction. The table is owned by the IES schema and is documented as VALID with 37 physical columns in the ETRM 12.2.2 repository.

From a Data Vault modeling perspective, the heuristic classification of this object is link. This classification is inferred from the foreign key structure: the table principally resolves relationships between survey deployments, survey list entries, deployed scripts, and security groups, rather than acting purely as a descriptive hub or a historical satellite. This should be treated as a modeling suggestion rather than an enforced design property.

Key Information Stored

The primary key of the table is RESPONSE_ID, enforced through the IES_SVY_RESPONSE_ENTRIES_PK constraint. A unique index, IES_SVY_RESP_ENTRS_N1, also exists on RESPONSE_ID, identifying it as the sole documented business-key candidate within the table.

The most significant columns include:

Common Use Cases and Queries

Typical reporting scenarios include retrieving all responses for a given deployment, analyzing response status distribution, or joining responses to script and security metadata for audit purposes.

  • Response counts by deployment: SELECT SURVEY_DEPLOYMENT_ID, COUNT(*) FROM IES.IES_SVY_RESPONSE_ENTRIES GROUP BY SURVEY_DEPLOYMENT_ID;
  • Active (non-deleted) responses: SELECT * FROM IES.IES_SVY_RESPONSE_ENTRIES WHERE F_DELETEDFLAG = 'N';
  • Joining to deployed scripts: SELECT r.RESPONSE_ID, d.NAME FROM IES.IES_SVY_RESPONSE_ENTRIES r, IES.IES_DEPLOYED_SCRIPTS d WHERE r.DSCRIPT_ID = d.DSCRIPT_ID;

Related Objects

  • IES_SVY_DEPLYMENTS_ALL — Joined via SURVEY_DEPLOYMENT_ID.
  • IES_SVY_LIST_ENTRIES — Joined via SURVEY_LIST_ENTRY_ID.
  • FND_SECURITY_GROUPS — Joined via SECURITY_GROUP_ID.
  • IES_DEPLOYED_SCRIPTS — Joined via DSCRIPT_ID.
  • Standard EBS audit objects such as FND_USER are referenced indirectly via audit columns.