Results for “ies_svy_reminders_v”

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

Overview

The view APPS.IES_SVY_REMINDERS_V is a reporting and integration artifact within the IES – Scripting product family of Oracle E-Business Suite, valid in both the 12.1.1 and 12.2.2 releases. It exposes survey reminder configuration records maintained by the Scripting engine, which governs the creation, deployment, and administration of online surveys. Reminder records determine how many follow-up notifications are issued to survey participants who have not yet responded, and the cadence at which those notifications are sent.

Functionally, the view is a thin projection rather than a transformation layer. It presents the complete column set of the underlying reminder entity without joins, filtering, or derivation, and therefore carries no business logic of its own. Its value lies in standardization: exposing the columns under a stable, documented name gives reporting tools, concurrent programs, and integration interfaces a supported read path against reminder data, allowing callers to avoid dependence on the physical table definition. Because the view exposes the SURVEY_DEPLOYMENT_ID foreign key, it is the natural entry point for any query that must associate reminder schedules with a specific survey deployment.

Underlying Base Objects

The view is owned by the APPS schema and is defined over a single object, IES_SVY_REMINDERS. In the documented metadata, that object is referenced as a synonym, meaning the view text resolves through the synonym to the reminder base table at execution time. The view text is a straightforward SELECT list of the base object's columns, with no WHERE clause, no GROUP BY, and no aggregation. There is consequently a one-to-one row correspondence between rows returned by the view and rows physically stored in the reminder table.

Because the view does not join to the survey or deployment entities, it does not itself return survey names, deployment names, or participant data. It carries only the reminder attribute set plus the deployment foreign key, which callers use to join outward to deployment and survey definition objects.

Key Columns

• SURVEY_REMINDER_ID — Primary identifier of the reminder configuration record.
• SURVEY_DEPLOYMENT_ID — Foreign key to the survey deployment for which the reminder policy applies. This is the column most frequently used in joins and filters.
• NO_OF_REMINDERS — Total number of reminder notifications permitted for the deployment.
• REMINDER_INTERVAL — Interval applied between successive reminder notifications.
• OBJECT_VERSION_NUMBER — Optimistic locking token used by the Scripting application when updating reminder records.
• F_DELETEDFLAG — Deletion indicator; rows are logically removed rather than physically purged.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking record creation and modification.
• SECURITY_GROUP_ID — Multi-tenant security grouping column used for data segregation.

Common Use Cases and Queries

Typical uses include verifying reminder policy for a deployment, auditing reminder configurations, and feeding downstream processes that orchestrate notification dispatch. A basic retrieval by deployment is shown below.

SELECT survey_reminder_id,
       survey_deployment_id,
       no_of_reminders,
       reminder_interval
FROM   apps.ies_svy_reminders_v
WHERE  survey_deployment_id = :p_deployment_id
AND    NVL(f_deletedflag, 'N') = 'N';

Note that f_deletedflag is commonly nullable or 'N'/'Y'-based, so callers should apply NVL or an equivalent filter when only active policies are required. An audit-oriented variant joins outward to the deployment entity to return human-readable survey context alongside the reminder settings.