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_EFCTTYProw; 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.
-
View: IGS_EN_ENCMB_EFCTTYP_V 12.1.1
View incorporating the encumbrance effects recognized by the system, and available for application to a student. eg. Suppression of transcript, maximum enrollment load restriction.
APPS.IGS_EN_ENCMB_EFCTTYP_V·↳ IGS_EN_ENCMB_EFCTTYP·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
This table has a foreign key relationship with FND_LOOKUPS_VAL. The join is based on the columns LOOKUP_TYPE and LOOKUP_CODE.
-
View: IGS_LOOKUPS_VIEW 12.1.1
APPS.IGS_LOOKUPS_VIEW·↳ FND_LOOKUP_VALUES·↳ IGS_LOOKUPS_VAL·Explore IGS module →
-
View: IGS_EN_ENCMB_EFCTTYP_V 12.2.2
View incorporating the encumbrance effects recognized by the system, and available for application to a student. eg. Suppression of transcript, maximum enrollment load restriction.
Not implemented in this database·Explore IGS module →
-
View: IGS_LOOKUPS_VIEW 12.2.2
Not implemented in this database·Explore IGS module →
-
TABLE: IGS.IGS_LOOKUPS_VAL 12.1.1
-
VIEW: APPS.IGS_LOOKUPS_VIEW 12.1.1
-
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'.