Results for “ies_svy_summary_stats_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IES_SVY_SUMMARY_STATS_V is an Oracle E-Business Suite (EBS) reporting view owned by the APPS schema and associated with the IES - Scripting product module. It exposes aggregate survey deployment statistics held in the IES_SVY_SUMMARY_STATS table. The view surfaces summary metrics such as the number of survey invitations sent, errors encountered during deployment, and total responses received, joined with descriptive attributes including survey name, cycle name, deployment name, media type, and recipient list. In EBS 12.1.1 and 12.2.2, this view serves primarily as a read layer for operational reporting, analytics, and integration extracts, allowing downstream consumers—such as Oracle Business Intelligence, custom concurrent programs, or external applications—to query survey performance without accessing the base table directly.

Underlying Base Objects

The view is defined over a single documented base object: the synonym IES_SVY_SUMMARY_STATS, which resolves to the underlying IES_SVY_SUMMARY_STATS table in the APPS schema. The view definition selects from this synonym using the alias SSS and performs a direct column projection with no joins, unions, or aggregation at the view level; aggregation is presumed to be maintained in the base table by the survey deployment processing logic.

• Base object: IES_SVY_SUMMARY_STATS (SYNONYM)
• Owner/schema: APPS
• Object status: VALID
• Definition style: Simple SELECT with column aliasing; no filtering predicates are applied within the view text.

Because the view carries the SECURITY_GROUP_ID and F_DELETEDFLAG columns forward from the base table, multi-org and soft-delete semantics are preserved through the view layer.

Key Columns

• SURVEY_ID, SURVEY_CYCLE_ID, SURVEY_DEPLOYMENT_ID: Identifiers linking the summary row to the survey definition, its cycle, and a specific deployment instance.
• SURVEY_NAME, SURVEY_CYCLE_NAME, SURVEY_DEPLOYMENT_NAME: Human-readable descriptive labels for reporting.
• OBJECT_VERSION_NUMBER: Optimistic locking / row versioning attribute for concurrency control.
• DEPLOY_DATE, RESPONSE_END_DATE: Deployment start and response window end timestamps.
• MEDIA_TYPE_CODE, LIST_HEADER_ID, LIST_NAME: Delivery channel and recipient list context for the deployment.
• TOTAL_NO_SENT: Count of invitations successfully sent.
• TOTAL_NO_ERRORS: Count of delivery errors encountered.
• TOTAL_NO_RESPONSES_RECD: Count of responses received.
• REFRESH_DATE: The timestamp indicating when the summary statistic row was last refreshed or recalculated. This column is central to freshness-aware reporting; users searching on "refresh_date" typically need to identify the currency of the statistics or to extract only rows refreshed after a given point in time.
• F_DELETEDFLAG, SECURITY_GROUP_ID: Deletion indicator and security/operating group discriminator.

Common Use Cases and Queries

Typical scenarios include response-rate dashboards, deployment error monitoring, and incremental extracts driven by the refresh timestamp.

• Latest refresh status per deployment: SELECT SURVEY_NAME, SURVEY_DEPLOYMENT_NAME, REFRESH_DATE FROM APPS.IES_SVY_SUMMARY_STATS_V WHERE REFRESH_DATE >= SYSDATE - 1;
• Response rate calculation: SELECT SURVEY_NAME, TOTAL_NO_SENT, TOTAL_NO_RESPONSES_RECD, ROUND(TOTAL_NO_RESPONSES_RECD / NULLIF(TOTAL_NO_SENT,0) * 100, 2) RESPONSE_PCT FROM APPS.IES_SVY_SUMMARY_STATS_V WHERE F_DELETEDFLAG = 'N';
• Error monitoring: SELECT SURVEY_DEPLOYMENT_NAME, TOTAL_NO_ERRORS, REFRESH_DATE FROM APPS.IES_SVY_SUMMARY_STATS_V WHERE TOTAL_NO_ERRORS > 0 ORDER BY REFRESH_DATE DESC;
• Incremental integration extract: filter on REFRESH_DATE to pull only changed summary rows since the last ETL run.

All queries should be schema-qualified or executed under a responsibility whose MO: Security profile is appropriate, given the presence of SECURITY_GROUP_ID.