Results for “igs_en_method_type”

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

Overview

IGS_EN_METHOD_TYPE is a reference (lookup) table in the Oracle E-Business Suite Student System (IGS) product family. It enumerates the available enrollment method types by which a student can be enrolled into an offering or course — for example online self-service, IVRS (telephony), or batch keying. The table also carries flags that govern how self-service and interactive voice response channels behave, making it the controlling reference for channel-specific enrollment processing in Oracle Student System releases 12.1.1 and 12.2.2. It is owned by the IGS schema and holds a VALID status in the ETRM dictionary.

Because IGS_EN_METHOD_TYPE acts primarily as a stable, descriptive code list that is referenced by transactional child tables, the mined Data Vault classification is hub-leaning. In a dimensional or Data Vault model this object is best treated as a reference hub (or a small dimension) keyed on the enrollment method type code, with surrounding descriptive and control attributes carried alongside. The child tables that reference it are the links or satellites that consume the code.

Key Information Stored

The table documents 13 physical columns at the 12.1.1 level. The most significant are:

• ENR_METHOD_TYPE — the primary business key and the sole column of the primary key constraint IGS_EN_METHOD_TYPE_PK, also backed by the unique index IGS_EN_METHOD_TYPE_U1. It is the code that all dependent tables point to via foreign key.
• DESCRIPTION — the human-readable name of the method type (for example "Online", "IVRS", "Batch Key") used in reports and list-of-values lookups.
• SELF_SERVICE — a control flag indicating whether the method type is available through student self-service channels; the metadata states this table was extended specifically to capture self-service enrollment methods.
• IVR_DISPLAY_IND — an indicator governing whether the method type is presented to the interactive voice response channel.
• BULK_JOB_IND — an indicator identifying method types driven by batch/bulk processing jobs.
• TRANSFER_FLAG — a flag controlling behavior for transfer enrollments under this method type.
• DFLT_TRANS_DETAILS_FLAG — a flag indicating whether transactional details should default for enrollments created under this method.
• CLOSED_IND — a soft-disable indicator; when set, the method type is retained historically but is no longer offered.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO audit columns recording row creation and last modification.

There is no separate numeric surrogate key: ENR_METHOD_TYPE itself serves as both the business key and the join key. This is a deliberate design choice for code-list tables, and it means the unique index and primary key are functionally identical.

Common Use Cases and Queries

Typical uses include populating list-of-values in self-service enrollment pages, validating inbound enrollment feeds, and reporting enrollment volumes by channel. A representative lookup query is:

• SELECT ENR_METHOD_TYPE, DESCRIPTION FROM IGS_EN_METHOD_TYPE WHERE NVL(CLOSED_IND,'N') = 'N'; — returns only active method types for LOV or configuration screens.
• SELECT ENR_METHOD_TYPE, DESCRIPTION FROM IGS_EN_METHOD_TYPE WHERE SELF_SERVICE = 'Y'; — restricts results to methods exposed to student self-service.
• A join to a dependent enrollment table such as IGS_EN_CAT_PRC_DTL on ENR_METHOD_TYPE yields per-method enrollment counts, which can be grouped by DESCRIPTION for channel-mix reporting.
• Filtering on IVR_DISPLAY_IND or BULK_JOB_IND supports IVR and batch operations teams auditing which methods are active for their channels.

Related Objects

Two child tables reference this table through the ENR_METHOD_TYPE foreign key column:

• IGS_EN_CPD_EXT_ALL.ENR_METHOD_TYPE — references IGS_EN_METHOD_TYPE; captures enrollment-related extended attributes tied to a method type.
• IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE — references IGS_EN_METHOD_TYPE; a catalog/process detail table recording enrollment method type alongside other processing keys.

These two foreign key relationships confirm the hub-leaning classification: both child tables depend on the code held here, and a join on ENR_METHOD_TYPE provides the descriptive enrichment needed for reporting across the IGS enrollment subsystem.