Results for “fund_description”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PE_FUND_EXCL_V is an Oracle E-Business Suite view owned by the APPS schema and delivered as part of the IGS (Student System) product family. It carries a VALID status in the ETRM repository for both 12.1.1 and 12.2.2. The view is described as "Person Hold Effect Fund Exclusion Details," which positions it as a reporting and integration surface over records that govern how person-level holds affect the exclusion of specific funds from encumbrance processing.
Functionally, the view denormalizes fund exclusion rows by joining each exclusion record to the fund catalog so that a human-readable fund description is available alongside the raw code. This makes it suitable for operational reporting, data validation, and downstream extracts where a fund code alone would be insufficient. Because the object is a view rather than a table, it holds no data of its own; it is a read-only projection assembled at query time from the underlying base objects.
Underlying Base Objects
The view is defined over two base objects. The driving table is IGS_PE_FUND_EXCL, aliased as E, which supplies the exclusion transaction rows. The lookup side is IGF_AW_FUND_CAT, aliased as L, which supplies the fund description. The join is an equality on FUND_CODE, expressed as E.FUND_CODE = L.FUND_CODE.
- IGS_PE_FUND_EXCL — the primary base table holding person hold effect fund exclusion records. All key business columns except the description originate here.
- IGF_AW_FUND_CAT — the fund catalog table, which the user searched for directly under the name "igf_aw_fund_cat." It contributes the DESCRIPTION column, projected as FUND_DESCRIPTION.
The join is an inner join, so an exclusion row is returned only when a matching fund code exists in the catalog. Both base objects are referenced through the APPS schema. The ETRM metadata records no additional referenced base objects beyond these two.
Key Columns
The view exposes the following columns, in the order defined by the view text:
- ROW_ID — the ROWID of the underlying IGS_PE_FUND_EXCL row, useful for uniquely identifying a source record.
- FUND_EXCL_ID — the primary identifier of the fund exclusion record.
- PERSON_ID — the person to whom the exclusion applies.
- ENCUMBRANCE_TYPE — the encumbrance type associated with the exclusion.
- PEN_START_DT — the start date of the person encumbrance related to the hold.
- S_ENCMB_EFFECT_TYPE — the encumbrance effect type for the student record.
- PEE_START_DT and PEE_SEQUENCE_NUMBER — the start date and sequence of the person encumbrance effect.
- FUND_CODE — the fund code that links the exclusion to the catalog.
- FUND_DESCRIPTION — the descriptive name of the fund, sourced from IGF_AW_FUND_CAT.
- PFE_START_DT — the start date of the person fund exclusion.
- EXPIRY_DT — the date on which the exclusion expires.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS who-columns for audit traceability.
Common Use Cases and Queries
The principal use case is reporting on which funds a given person is excluded from and for what period. Because the view already resolves the fund description, it is convenient for extracts and for BI Publisher or OBIEE style reporting without an extra lookup join.
- Listing active exclusions for a person, filtered by expiry date.
- Auditing the relationship between encumbrance types and excluded funds.
- Joining to person and fund catalog reporting objects for name-level detail.
SELECT fund_excl_id,
person_id,
fund_code,
fund_description,
pfe_start_dt,
expiry_dt
FROM apps.igs_pe_fund_excl_v
WHERE person_id = :p_person_id
AND (expiry_dt IS NULL OR expiry_dt >= SYSDATE);
A second common pattern validates that every exclusion references a valid catalog entry:
SELECT a.fund_code, a.fund_description, COUNT(*) exclusions FROM apps.igs_pe_fund_excl_v a GROUP BY a.fund_code, a.fund_description ORDER BY exclusions DESC;
Because the view performs an inner join on FUND_CODE, exclusion rows whose fund code is absent from IGF_AW_FUND_CAT will not appear. Analysts seeking orphaned exclusions should therefore query IGS_PE_FUND_EXCL directly and use an outer join to the fund catalog.
-
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 →
-
Full View for the Entity that holds Direct Loan Promissory Note Activities
APPS.IGFFV_DL_PNOTE_STATUS_HISTORY·↳ HZ_PARTIES·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_FUND_MAST_ALL·Explore IGF module →
-
Base view for the entity that holds Student Work Study Award Details
APPS.IGFBV_STUDENT_FWS_AWAD_DETAILS·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_AWD_DISB_ALL·Explore IGF module →
-
User interface view for funding request header.
APPS.OKL_FUND_REQ_HEADERS_UV·↳ AP_TERMS_V·↳ FND_CURRENCIES_TL·↳ FND_GLOBAL·Explore OKL module →
-
View: IGF_DB_AWD_DISB_V 12.1.1
Award disbursement details
APPS.IGF_DB_AWD_DISB_V·↳ IGF_AW_AWARD_V·↳ IGF_AW_AWD_DISB_V·↳ IGF_AW_GEN·Explore IGF module →
-
Describes the financial aid fund the student will be excluded from when a student progression outcome is applied.
APPS.IGSFV_PR_STDNT_PRG_FUNDS·↳ HZ_PARTIES·↳ IGF_AW_FUND_CAT_ALL·↳ IGS_PR_STDNT_PR_FND·Explore IGS module →
-
Contains those records selected for reporting in the specified period
-
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 →
-
Describes the financial aid fund the student will be excluded from when a student progression outcome is applied.
APPS.IGSBV_PR_STDNT_PRG_FUNDS·↳ HZ_PARTIES·↳ IGF_AW_FUND_CAT_ALL·↳ IGS_PR_STDNT_PR_FND·Explore IGS module →
-
View: IGFFV_DL_REJECTS 12.1.1
Full View for the Entity that holds Financial Aid Direct Loan Rejects
APPS.IGFFV_DL_REJECTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds Direct Stafford Loan Promissory Notes
APPS.IGFFV_DL_STAFFORD_PROM_NOTES·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_FUND_MAST_ALL·↳ IGF_SL_DL_PNOTE_S_P_ALL·Explore IGF module →
-
View: IGFFV_PERKINS_LOANS 12.1.1
Full View for the Entity that holds Perkins Loans
APPS.IGFFV_PERKINS_LOANS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Holds sponsor student relation details
APPS.IGSBV_STUDENT_SPNSR_RELATIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_FUND_MAST_ALL·Explore IGS module →
-
Stores temporary data that should to be shown on the Award Notification Letter
-
View: IGFFV_FFELP_REJECTS 12.1.1
Full View for the Entity that holds Financial Aid FFELP Rejects
APPS.IGFFV_FFELP_REJECTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Full View for the Entity that holds Student Work Authorizations
APPS.IGFFV_STUDENT_AUTHORIZATIONS·↳ HZ_PARTIES·↳ IGF_AW_FUND_MAST_ALL·↳ IGF_SE_AUTH·Explore IGF module →
-
Full View for the Entity that holds Direct Loan Promissory Note Manifests
APPS.IGFFV_DL_PROM_NOTE_MANIFESTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
Holds sponsor student relation details
APPS.IGSFV_STUDENT_SPNSR_RELATIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_FUND_MAST_ALL·Explore IGS module →
-
Full View for the Entity that holds Direct Plus Loan Promissory Notes
APPS.IGFFV_DL_PLUS_PROM_NOTES·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_FUND_MAST_ALL·↳ IGF_SL_DL_PNOTE_P_P_ALL·Explore IGF module →
-
Full View for the Entity that holds Student Work Study Award Details
APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
User interface view for funding request header.
APPS.OKL_FUND_REQ_HEADERS_UV·↳ AP_TERMS_V·↳ FND_CURRENCIES_TL·↳ FND_GLOBAL·Explore OKL module →
-
Contains those records selected for reporting in the specified period
-
View: IGFFV_STUDENT_AWARDS 12.1.1
Full View for the Entity that holds the information about the Awards given to students
APPS.IGFFV_STUDENT_AWARDS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGFFV_FUNDS 12.1.1
Full View for the Entity that holds the all the details and the properties for each fund
APPS.IGFFV_FUNDS·↳ HZ_PARTIES·↳ IGF_AW_FUND_CAT_ALL·↳ IGF_AW_FUND_MAST_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid FFELP Loan Originations
APPS.IGFFV_FFELP_LOAN_ORIGINATIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGFBV_FUNDS 12.1.1
Base View for the Entity that holds the all the details and the properties for each fund
APPS.IGFBV_FUNDS·↳ IGF_AW_FUND_MAST_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Originations
APPS.IGFFV_DIRECT_LOAN_ORIGINATIONS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGS_PE_FUND_EXCL_V 12.2.2
Person Hold Effect Fund Exclusion Details.
Not implemented in this database·Explore IGS module →
-
View: IGSFV_PERSON_FUND_EXCL 12.2.2
Person Hold Effect Fund Exclusion Details Full Business View
Not implemented in this database·Explore IGS module →
-
View: IGF_DB_AWD_DISB_V 12.2.2
Award disbursement details
Not implemented in this database·Explore IGF module →
-
VIEW: FV.FV_SF224_TEMP# 12.2.2
-
VIEW: FV.FV_SF224_TEMP# 12.2.2
-
Describes the financial aid fund the student will be excluded from when a student progression outcome is applied.
Not implemented in this database·Explore IGS module →
-
Full View for the Entity that holds Direct Loan Promissory Note Activities
Not implemented in this database·Explore IGF module →
-
View: IGFFV_PERKINS_LOANS 12.2.2
Full View for the Entity that holds Perkins Loans
Not implemented in this database·Explore IGF module →
-
Describes the financial aid fund the student will be excluded from when a student progression outcome is applied.
Not implemented in this database·Explore IGS module →
-
View: IGFFV_STUDENT_AWARDS 12.2.2
Full View for the Entity that holds the information about the Awards given to students
Not implemented in this database·Explore IGF module →