Results for “encumbrance_level”

12 results




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

Overview

The view APPS.IGS_EN_ENCMB_EFCTTYP_V is a reporting and integration object within the Oracle E-Business Suite Student System (product code IGS). Its purpose is to expose the set of encumbrance effects that the institution has configured as available for application against a student record. Encumbrances in the Student System represent administrative holds or restrictions that limit a student's privileges — for example, suppression of transcript issuance or restriction of the maximum enrollment load. This view provides the descriptive and control attributes associated with each encumbrance effect type, resolving the internal effect-type code against the corresponding lookup meaning so that the output is directly usable in reports, concurrent programs, and interface extracts without additional joins for decoding. It is defined in the APPS schema and is documented with a status of VALID in the ETRM repository for release 12.1.1 and 12.2.2.

Underlying Base Objects

The view is a two-table join. The driving table is IGS_EN_ENCMB_EFCTTYP, aliased EET, which stores the encumbrance effect type definitions. The lookup side is IGS_LOOKUPS_VIEW, aliased LKUPS, filtered on LOOKUP_TYPE = 'ENCMB_EFFECT_TYPE'. The join condition is LKUPS.LOOKUP_CODE = EET.S_ENCMB_EFFECT_TYPE, so each row of the view combines the effect type definition with its user-facing meaning. The view text selects the ROWID of the base effect type row as ROW_ID, and exposes audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) directly from the base table. Note that the ETRM documented metadata lists no explicitly referenced base objects, but the delivered view text confirms the two sources above.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_EN_ENCMB_EFCTTYP row; useful as a unique identifier for the effect type definition, though it is not a stable primary key across reorganizations.
  • S_ENCMB_EFFECT_TYPE — the encumbrance effect type code (from the lookup code), the business key used to relate the effect to the encumbrance configuration.
  • DESCRIPTION — the lookup meaning text displayed to users; the human-readable name of the encumbrance effect.
  • APPLY_TO_COURSE_IND — indicates whether the encumbrance effect applies at course level, controlling how the restriction is propagated when a student enrolls.
  • ENCUMBRANCE_LEVEL — the lookup attribute that classifies the level or severity at which the encumbrance effect operates; this column is the one associated with the search term encumbrance_level.
  • CLOSED_IND — flags whether the effect type is closed (inactive) and therefore should be excluded from current processing.
  • Auxiliary audit columns record the creating and last-updating user, timestamps, and login, supporting audit and troubleshooting.

Common Use Cases and Queries

Typical usage includes LOV (list-of-values) population, validation of encumbrance effect setup, and extraction of active effect definitions for downstream processing. Because the view already decodes the effect type into its meaning, it removes the need for a separate lookup join in most reports.

SELECT s_encmb_effect_type,
       description,
       encumbrance_level,
       apply_to_course_ind
  FROM apps.igs_en_encmb_efcttyp_v
 WHERE closed_ind = 'N'
 ORDER BY description;

To isolate effects at a given encumbrance level:

SELECT s_encmb_effect_type, description, apply_to_course_ind
  FROM apps.igs_en_encmb_efcttyp_v
 WHERE encumbrance_level = :p_level
   AND closed_ind = 'N';

Because the view exposes only configuration data, application logic must still combine it with student-level encumbrance and enrollment tables to determine whether a specific student is actually affected. It should therefore be treated as a reference view of available effect types rather than a transactional source of student holds.