Search Results igs_en_encmb_efcttyp_pk

Overview

The table IGS_EN_ENCMB_EFCTTYP is a core reference entity within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It functions as the master catalog of all possible negative consequences or restrictions, known as encumbrance effects, that can be applied to a student's academic record. An encumbrance is a type of administrative hold, often related to financial or disciplinary matters. This table standardizes the types of effects, such as suppressing the issuance of official transcripts or imposing a maximum enrollment load, ensuring consistent application and management of student restrictions across the institution. Its role is foundational to the encumbrance management process, providing the valid list of effect codes that other transactional tables reference.

Key Information Stored

While the provided metadata does not list specific columns, the structure and relationships indicate the table's primary purpose is to store a controlled list of encumbrance effect types. The central column is S_ENCMB_EFFECT_TYPE, which serves as the table's primary key (PK). This column stores the unique code identifying each distinct type of encumbrance effect, such as 'TRANSCRIPT_SUPPRESS' or 'MAX_LOAD_RESTRICT'. Based on standard EBS design patterns, the table likely also contains descriptive columns like DESCRIPTION to provide a clear name for the effect, and potentially columns for controlling active status (CLOSED_IND) and tracking system (S_ENCMB_EFFECT_CAT). The integrity of this reference data is enforced by the primary key constraint IGS_EN_ENCMB_EFCTTYP_PK.

Common Use Cases and Queries

This table is primarily used in setup, maintenance, and reporting contexts. Administrators query it to review or configure the list of available effects before applying them to students. Common SQL operations include retrieving the active list of effects for a setup screen or validating an effect type before inserting a record into a transactional table. For reporting, it is frequently joined to transactional data to translate effect type codes into meaningful descriptions.

• Listing All Active Encumbrance Effects: SELECT s_encmb_effect_type, description FROM igs.igs_en_encmb_efcttyp WHERE closed_ind = 'N';
• Reporting on Students with a Specific Effect: This query would join to IGS_PE_PERSENC_EFFCT to find all students with a transcript suppression hold. SELECT p.* FROM igs.igs_pe_persenc_effct p, igs.igs_en_encmb_efcttyp t WHERE p.s_encmb_effect_type = t.s_encmb_effect_type AND t.s_encmb_effect_type = 'TRANSCRIPT_SUPPRESS';

Related Objects

The IGS_EN_ENCMB_EFCTTYP table is a parent reference table for several key transactional entities in the Student System, as defined by its foreign key relationships. These relationships ensure that only valid, pre-defined effect types can be assigned.

• IGS_FI_ENC_DFLT_EFT: This table links default financial encumbrances to specific effect types. The column IGS_FI_ENC_DFLT_EFT.S_ENCMB_EFFECT_TYPE references this table's primary key.
• IGS_PE_PERSENC_EFFCT: This is the primary transactional table that records which specific encumbrance effects are applied to a person (student). The column IGS_PE_PERSENC_EFFCT.S_ENCMB_EFFECT_TYPE is a foreign key to this table, tying each applied personal effect back to the master definition.