Results for “enrollment_method_type”
13 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGSFV_ENRL_ELIGIBILITY_SETUPS is a read-only view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. As documented in the ETRM metadata for release 12.1.1 and 12.2.2, the view queries the available enrollment method types to which students can be enrolled. In practical terms, it exposes the institution's configured enrollment method types — such as web self-service enrollment, administrative (staff) enrollment, interactive voice response (IVR) enrollment, and other defined methods — together with their descriptive and status attributes.
Because the object is a view rather than a base table, it serves as a reporting and integration convenience layer. External systems, custom reports, and concurrent programs can query IGSFV_ENRL_ELIGIBILITY_SETUPS without needing to understand the underlying IGS_EN_METHOD_TYPE table structure or join logic. The view's read-only nature (defined with the WITH READ ONLY clause) guarantees that consumers cannot inadvertently modify enrollment method type configuration data through the view, which protects the integrity of institutional enrollment setup data.
Underlying Base Objects
The view is defined over a single base table: IGS_EN_METHOD_TYPE, aliased as EMT in the view text. No additional documented base objects are referenced in the ETRM metadata. The view definition performs a straightforward projection of columns from that table:
- IGS_EN_METHOD_TYPE — the enrollment method type setup table, which stores the institution-defined methods by which a student may be enrolled into a program, course, or unit offering. Each row represents one configured method type.
Because the view selects directly from IGS_EN_METHOD_TYPE without joins, filters, or aggregation, its row set mirrors the base table exactly. Any row inserted, updated, or deleted in IGS_EN_METHOD_TYPE is immediately reflected when the view is queried, since the view stores no data of its own. The view's WITH READ ONLY clause enforces that DML cannot be issued against it.
Key Columns
- ENROLLMENT_METHOD_TYPE (base column ENR_METHOD_TYPE) — the code identifying the enrollment method type. This is the primary business key and typically drives lookups and joins against enrollment records.
- DESCRIPTION — the user-facing description of the enrollment method type, displayed in forms, reports, and self-service pages.
- CLOSED_INDICATOR (base column CLOSED_IND) — indicates whether the method type is closed and therefore unavailable for new enrollment activity.
- SELF_SERVICE — indicates whether the method type is available through student self-service channels.
- IVR_ENABLED (base column IVR_DISPLAY_IND) — indicates whether the method type is displayed or selectable through the IVR channel.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard Oracle EBS audit columns recording who created and last modified the row, and when.
Common Use Cases and Queries
The view is typically used to populate LOVs, validate enrollment method values, and produce setup reports that document which enrollment methods are active. A common pattern is to list only open, self-service-enabled methods:
- Querying all currently active (not closed) enrollment method types for display in enrollment screens.
- Identifying which method types are exposed to self-service or IVR channels for channel-specific configuration review.
- Auditing setup changes by filtering on CREATION_DATE or LAST_UPDATE_DATE.
Sample query:
SELECT enrollment_method_type, description, self_service, ivr_enabled
FROM apps.igsfv_enrl_eligibility_setups
WHERE closed_indicator = 'N'
ORDER BY description;
For channel-specific analysis, add predicates on SELF_SERVICE = 'Y' or IVR_ENABLED = 'Y'. Because the view is a thin projection of IGS_EN_METHOD_TYPE, any diagnostic or reconciliation query may alternatively target the base table; the view remains the preferred access point for read-only reporting and integration.
-
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 →
-
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 entity describes a student's attempt at studying a particular unit offered by the university.
APPS.IGSFV_STUDENT_UNIT_ATTEMPTS·↳ HZ_PARTIES·↳ IGS_AD_ADM_UNIT_STAT_ALL·↳ IGS_AD_LOCATION_ALL·Explore IGS module →
-
This entity describes a student's attempt at studying a particular unit offered by the university.
APPS.IGSBV_STUDENT_UNIT_ATTEMPTS·↳ HZ_PARTIES·↳ IGS_CA_INST_ALL·↳ IGS_EN_STDNT_PS_ATT_ALL·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 →
-
This entity describes a student's attempt at studying a particular unit offered by the university.
Not implemented in this database·Explore IGS module →
-
This entity describes a student's attempt at studying a particular unit offered by the university.
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'.