Search Results survey_description

Overview

IES_SVY_SURVEYS_ALL is the master definition table for surveys within the Oracle E-Business Suite Scripting (IES) module. It stores the header-level record for each survey a customer defines through the Scripting survey authoring tools, holding naming, status, typing, and resource assignment attributes. The table is owned by the IES schema and is documented as VALID in the ETRM reference set for both EBS 12.1.1 and 12.2.2, with a physical schema of 34 columns recorded for the 12.2.2 release.

Surveys in IES are the scripted instruments used to collect structured responses — for example, customer satisfaction questionnaires, quality audit checklists, or task-verification scripts — and each survey depends on an underlying deployed script definition to drive its runtime behavior. IES_SVY_SURVEYS_ALL is therefore the parent of the survey cycle and summary statistics entities, making it the gateway record for all survey execution and analysis activity. Based on the foreign-key structure mined from the ETRM metadata, a Data Vault heuristic classifies this table as hub-leaning: it carries a single-column surrogate primary key, distributes references to related hubs such as deployed scripts and survey resources, and does not itself resolve many-to-many relationships.

Key Information Stored

The table is anchored by its primary key constraint IES_SVY_SURVEYS_ALL_PK on the SURVEY_ID column. SURVEY_ID is the surrogate identifier assigned to every survey definition and is also the column exposed through the unique index IES_SVY_SURVEYS_N1, making it the principal business-key candidate for lookups and joins. The most significant stored attributes are:

• SURVEY_ID — surrogate primary key and unique-indexed identifier for the survey.
• SURVEY_NAME — the business-facing name of the survey.
• SURVEY_DESCRIPTION — free-text description of the survey's purpose or content.
• SURVEY_STATUS_CODE — lifecycle state of the survey definition (for example, draft, active, or inactive).
• SURVEY_TYPE — categorization of the survey, distinguishing its behavioral class.
• DSCRIPT_ID — foreign key to IES_DEPLOYED_SCRIPTS, linking the survey to the deployed script that governs its execution.
• SURVEY_RESOURCE_ID — foreign key to IES_SVY_RESOURCES, identifying the resource-level constraints associated with the survey.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling row-level access.
• ORG_ID — the operating unit (multi-org) identifier scoping the survey.
• PROTOTYPE and SUSPENDABLE — flags indicating whether the survey is a reusable prototype and whether it may be suspended mid-execution.
• F_DELETEDFLAG — soft-delete indicator used to retire surveys without physical removal.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OA Framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard DFF/extension flexfield columns for customer-defined data.

Common Use Cases and Queries

Typical use cases include building a survey catalog report, validating which surveys are linked to which deployed scripts, and diagnosing why a survey cycle failed to launch. A basic catalog query filters on status and organization:

• Survey catalog: SELECT survey_id, survey_name, survey_status_code FROM ies.ies_svy_surveys_all WHERE org_id = :p_org AND f_deletedflag = 'N';
• Survey-to-script mapping: join on DSCRIPT_ID to IES_DEPLOYED_SCRIPTS to report which script drives each active survey.
• Execution reporting: join SURVEY_ID to IES_SVY_CYCLES_ALL and IES_SVY_SUMMARY_STATS to produce completion and scoring statistics per survey.
• Security review: join SECURITY_GROUP_ID to FND_SECURITY_GROUPS to audit which group authorizes visibility of each survey.
• Prototype management: filter on PROTOTYPE = 'Y' to list reusable template surveys available for cloning.

Related Objects

The table participates in a compact but well-defined dependency network:

• IES_DEPLOYED_SCRIPTS — referenced via IES_SVY_SURVEYS_ALL.DSCRIPT_ID; supplies the executable script bound to the survey.
• IES_SVY_RESOURCES — referenced via IES_SVY_SURVEYS_ALL.SURVEY_RESOURCE_ID; defines resource constraints for the survey.
• FND_SECURITY_GROUPS — referenced via IES_SVY_SURVEYS_ALL.SECURITY_GROUP_ID; governs access control.
• IES_SVY_CYCLES_ALL — child table referencing IES_SVY_SURVEYS_ALL via SURVEY_ID; stores survey execution cycles.
• IES_SVY_SUMMARY_STATS — child table referencing IES_SVY_SURVEYS_ALL via SURVEY_ID; holds aggregated response statistics.

Together these relationships establish IES_SVY_SURVEYS_ALL as the definitional hub for survey execution and analysis in the IES Scripting module, and any reporting or integration touching survey cycles or summary statistics must resolve SURVEY_ID against this table first.