Results for “s_encmb_effect_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_FI_ENC_DFLT_EFT is a configuration table within the Oracle E-Business Suite IGS (Student System) module. It describes the default effects that are applied to an associated encumbrance type. In practical terms, the table stores the mapping between an encumbrance type defined in the financial aid or student financials encumbrance framework and the effect type that should be applied by default when that encumbrance is processed.
This object belongs to the IGS product, which Oracle classifies as obsolete in release 12.1.1 and 12.2.2. The ETRM metadata explicitly records "Not implemented in this database," meaning the table is not instantiated in the delivered Oracle EBS schema and should be regarded as documentation-only or legacy reference information rather than a live repository object.
From a Data Vault modeling perspective, the metadata's heuristic classification is link. This reflects the table's structural role: it resolves a many-to-many association between an encumbrance type and an encumbrance effect type. Adopting that suggestion, IGS_FI_ENC_DFLT_EFT functions as a link entity, with the two foreign key columns acting as the composite business key.
Key Information Stored
The documented physical schema contains eight columns. The most significant are the following:
- ENCUMBRANCE_TYPE — Identifies the encumbrance type to which a default effect applies. It is a foreign key to IGS_FI_ENCMB_TYPE_ALL and forms part of the composite primary key.
- S_ENCMB_EFFECT_TYPE — Identifies the encumbrance effect type applied by default. It is a foreign key to IGS_EN_ENCMB_EFCTTYP and forms the second component of the composite primary key.
- COMMENTS — Free-form descriptive text documenting the default effect or the rationale for the mapping.
- CREATED_BY, CREATION_DATE — Standard WHO audit columns recording the creating user and creation timestamp.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modifying user, update timestamp, and login session.
The primary key is defined as IGS_FI_ENC_DFLT_EFT_PK over (ENCUMBRANCE_TYPE, S_ENCMB_EFFECT_TYPE). A unique index, IGS_FI_ENC_DFLT_EFT_U1, covers the same two columns, confirming them as the business-key candidate. No separate surrogate key column is documented; the composite natural key serves as the identifier.
Common Use Cases and Queries
The table supports configuration validation and reporting on encumbrance default behaviors. Typical queries resolve the descriptive names behind the numeric foreign keys:
- Listing all default effects for a given encumbrance type.
- Confirming that a specific encumbrance type / effect type pairing exists before an encumbrance is created.
- Auditing recent configuration changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.
A representative join pattern follows:
- SELECT e.encumbrance_type, t.description, e.s_encmb_effect_type, f.description FROM igs_fi_enc_dflt_eft e, igs_fi_encmb_type_all t, igs_en_encmb_efcttyp f WHERE e.encumbrance_type = t.encumbrance_type AND e.s_encmb_effect_type = f.s_encmb_effect_type;
Because the object is not implemented in the delivered database, these queries serve documented reference purposes and may require custom creation in legacy or upgraded environments.
Related Objects
- IGS_FI_ENCMB_TYPE_ALL — Referenced by ENCUMBRANCE_TYPE; the parent encumbrance-type definition table.
- IGS_EN_ENCMB_EFCTTYP — Referenced by S_ENCMB_EFFECT_TYPE; the encumbrance effect-type definition table.
- IGS_FI_ENC_DFLT_EFT_PK — The primary key constraint over (ENCUMBRANCE_TYPE, S_ENCMB_EFFECT_TYPE).
- IGS_FI_ENC_DFLT_EFT_U1 — The unique index enforcing the composite business key.
These relationships establish the table as a dependent configuration link within the IGS encumbrance sub-model, joining the encumbrance-type and effect-type entities that it bridges.
-
Describes the default effects that are applied to the associated encumbrance type.
-
This entity describes a course group from which a person has been excluded.
-
Describes units that are required to be studied by the student as part of a hold
-
This entity defines a course which a student has been excluded from. e.g. block admission to a course for an applicant.
-
This entity describes a unit set which a student has been excluded from.
-
This entity describes the effects which are imposed on a person (or one or their courses) as part on an encumbrance. eg. course exclusion, suppression of transcript.
-
Person Hold Effect Fund Exclusion Details.
-
View: IGS_PE_FUND_EXCL_V 12.1.1
Person Hold Effect Fund Exclusion Details.
APPS.IGS_PE_FUND_EXCL_V·↳ IGF_AW_FUND_CAT·↳ IGS_PE_FUND_EXCL·Explore IGS module →
-
This entity describes the encumbrance effects recognized by the system, and available for application to a student. e.g. Suppression of transcript, maximum enrollment load restriction.
-
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 entity describes a unit which a student has been excluded from.
-
View: IGSBV_PERSON_FUND_EXCL 12.1.1
Person Hold Effect Fund Exclusion Details Base Business View
APPS.IGSBV_PERSON_FUND_EXCL·↳ IGS_PE_FUND_EXCL·Explore IGS module →
-
View: IGSFV_PERSON_FUND_EXCL 12.1.1
Person Hold Effect Fund Exclusion Details Full Business View
APPS.IGSFV_PERSON_FUND_EXCL·↳ IGF_AW_FUND_CAT·↳ IGS_PE_FUND_EXCL·Explore IGS module →
-
TABLE: IGS.IGS_PE_FUND_EXCL 12.1.1
-
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 →
-
Table: IGS_EN_ENCMB_EFCTTYP 12.2.2
This entity describes the encumbrance effects recognized by the system, and available for application to a student. e.g. Suppression of transcript, maximum enrollment load restriction.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PE_UNT_REQUIRMNT 12.2.2
Describes units that are required to be studied by the student as part of a hold
Not implemented in this database·Explore IGS module →
-
Table: IGS_FI_ENC_DFLT_EFT 12.2.2
Describes the default effects that are applied to the associated encumbrance type.
Not implemented in this database·Explore IGS module →
-
This entity describes the hold effects recognised by the system, and available for application to a student. E.g. Suppression of transcript, maximum enrolment load restriction.
Not implemented in this database·Explore IGS module →
-
This entity describes the hold effects recognised by the system, and available for application to a student. E.g. Suppression of transcript, maximum enrolment load restriction.
APPS.IGSBV_SYSTEM_HOLD_EFFECT_TYPES·↳ IGS_EN_ENCMB_EFCTTYP·Explore IGS module →
-
Table: IGS_PE_UNT_SET_EXCL 12.2.2
This entity describes a unit set which a student has been excluded from.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PE_PERS_UNT_EXCL 12.2.2
This entity describes a unit which a student has been excluded from.
Not implemented in this database·Explore IGS module →