Results for “ivr_enabled”
13 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGSBV_ENRL_ELIGIBILITY_SETUPS is an Oracle E-Business Suite (EBS) read-only view owned by the APPS schema within the IGS — Student System product family. Its stated purpose is to expose the available enrollment method types to which students can be enrolled, together with the associated control flags that govern whether each method is active, exposed to self-service, or surfaced to interactive voice response (IVR) channels. In EBS 12.1.1 and 12.2.2, the view is registered as VALID and functions as a lightweight, denormalized access layer over the underlying enrollment method type configuration.
The view appears in reporting and integration contexts where external consumers — particularly self-service portals, call-center scripts, and IVR telephony integrations — require a filtered or simplified representation of enrollment method setup data. Because it is defined WITH READ ONLY, it cannot be used as a DML target; it is intended strictly for queries. The presence of the IVR_DISPLAY_IND source column, exposed as IVR_ENABLED, directly matches the "ivr_enabled" search term, indicating that this view is the likely discovery point for administrators validating which enrollment methods are available through IVR.
Underlying Base Objects
The view is defined over a single base table, IGS_EN_METHOD_TYPE, aliased as EMT. No additional joins, unions, or secondary objects are documented in the referenced base objects metadata, confirming a one-to-one projection relationship between the view rows and rows in the base table.
The definition uses a SELECT ... FROM IGS_EN_METHOD_TYPE EMT WITH READ ONLY construct. This means all filtering, enablement, and channel-display logic is inherited directly from the base table; the view adds no row-level security or predicate restrictions of its own. Any restriction visible to a querying user must therefore come from the base table's data or from Oracle EBS security applied elsewhere (for example, through responsibilities, function security, or supplementary WHERE clauses in consuming reports). Because the view is a straight projection, the number of rows returned equals the number of enrollment method type records present in the underlying table, subject only to any predicates the caller supplies.
Key Columns
- ENROLLMENT_METHOD_TYPE (base
ENR_METHOD_TYPE) — The code uniquely identifying the enrollment method type. This is the principal key used in joins and lookups. - DESCRIPTION — The human-readable name of the enrollment method, suitable for display in reports and IVR prompts.
- CLOSED_INDICATOR (base
CLOSED_IND) — Indicates whether the enrollment method is closed and therefore unavailable for new enrollments. - SELF_SERVICE — Flag controlling whether the method is exposed to student self-service channels.
- IVR_ENABLED (base
IVR_DISPLAY_IND) — Flag indicating whether the enrollment method is surfaced through interactive voice response. This is the column most relevant to IVR eligibility configuration and the "ivr_enabled" search context. - CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns recording the creating and last-modifying user and timestamps.
Common Use Cases and Queries
Typical usage centers on validating enrollment method configuration, feeding IVR or self-service integrations, and auditing method availability. A common query lists all open, IVR-enabled methods:
SELECT enrollment_method_type, description FROM igsbv_enrl_eligibility_setups WHERE ivr_enabled = 'Y' AND closed_indicator = 'N';SELECT enrollment_method_type, description, self_service, ivr_enabled FROM igsbv_enrl_eligibility_setups;SELECT * FROM igsbv_enrl_eligibility_setups WHERE self_service = 'Y' ORDER BY description;SELECT enrollment_method_type, last_update_date, last_updated_by FROM igsbv_enrl_eligibility_setups WHERE closed_indicator = 'Y';
Integration consumers typically join ENROLLMENT_METHOD_TYPE to enrollment transaction tables to translate method codes into descriptions, applying the SELF_SERVICE and IVR_ENABLED predicates to enforce channel eligibility.
-
This view queries the available method types that students can be enrolled to.
APPS.IGSBV_ENRL_ELIGIBILITY_SETUPS·↳ IGS_EN_METHOD_TYPE·Explore IGS module →
-
This view queries the available method types that students can be enrolled to.
APPS.IGSFV_ENRL_ELIGIBILITY_SETUPS·↳ IGS_EN_METHOD_TYPE·Explore IGS module →
-
View: IGSBV_CALENDAR_PERIODS 12.1.1
This is the base view for the entity Calendar Periods that describes an instance of a calendar type.
APPS.IGSBV_CALENDAR_PERIODS·↳ IGS_CA_INST_ALL·↳ IGS_CA_TYPE·Explore IGS module →
-
View: IGSFV_CALENDAR_PERIODS 12.1.1
This is the full view for the entity Calendar Periods that describes an instance of a calendar type.
APPS.IGSFV_CALENDAR_PERIODS·↳ IGS_CA_INST_ALL·↳ IGS_CA_STAT·↳ IGS_CA_TYPE·Explore IGS module →
-
This view queries the available method types that students can be enrolled to.
Not implemented in this database·Explore IGS module →
-
This view queries the available method types that students can be enrolled to.
Not implemented in this database·Explore IGS module →
-
View: IGSBV_CALENDAR_PERIODS 12.2.2
This is the base view for the entity Calendar Periods that describes an instance of a calendar type.
Not implemented in this database·Explore IGS module →
-
View: IGSFV_CALENDAR_PERIODS 12.2.2
This is the full view for the entity Calendar Periods that describes an instance of a calendar type.
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.