Search Results igs_or_unit_fundsrc_v

Overview

IGS_OR_UNIT_FUNDSRC_V is a denormalized reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGS (Student System) product family. Its documented purpose is to present a unified listing of all organization units joined to all funding sources, and it exists specifically to support the ADMF2M44 administrative inquiry process. In practice, the view serves as a single access point that combines party-level organization data held in the Trading Community Architecture (TCA) with funding source reference data, allowing reports, concurrent programs, and integration extracts to resolve organization unit attributes and funding source attributes without writing multi-table joins directly against the base schemas.

The view is documented as VALID in ETRM 12.2.2 and retains the same definition across the 12.1.1 and 12.2.2 releases. Because it is a view rather than a table, it carries no independent storage, no indexes, and no DML support; consumers read it as a reporting projection only. The user query term "ou_description" maps directly to the OU_DESCRIPTION column, which is sourced from HZ_PARTIES.PARTY_NAME.

Underlying Base Objects

The view is defined over three documented base objects:

• HZ_PARTIES (HZ) — the TCA master party record, supplying the party number, party name, and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).
• IGS_PE_HZ_PARTIES (PEP) — the IGS extension of the HZ party record, supplying organization unit code, start and end dates, organization status, organization type, member type, and institution code. The join to HZ_PARTIES is on PARTY_ID, and the filter PEP.INST_ORG_IND = 'O' restricts the result set to organization parties only.
• IGS_FI_FUND_SRC (FS) — the funding source reference table, supplying funding source code and description, government funding source indicator, and the closed indicator. The join is effectively a cross join to the filtered party set, which is why the view is described as returning all organization units joined to all funding sources.

Because the funding source join is not filtered or keyed on institution, the row count equals the number of qualifying organization parties multiplied by the number of funding source rows. ETRM documents no additional referenced base objects beyond these three.

Key Columns

• TCA_PARTY_NUMBER — the HZ party number for the organization unit.
• ORG_UNIT_CD — the IGS organization unit code (from PEP.OSS_ORG_UNIT_CD), the primary business key for the unit.
• START_DT / END_DT — the effective date bounds of the organization unit record.
• OU_DESCRIPTION — the descriptive name of the organization unit, mapped from HZ_PARTIES.PARTY_NAME. This is the column most frequently referenced in ad hoc queries.
• ORG_STATUS, ORG_TYPE, MEMBER_TYPE, INSTITUTION_CD — IGS classification attributes of the unit, useful for filtering by institution or organizational role.
• FUNDING_SOURCE and FS_DESCRIPTION — the funding source code and its descriptive text.
• GOVT_FUNDING_SOURCE — indicates whether the funding source represents government funding.
• CLOSED_IND — indicates whether the funding source has been closed and should be excluded from active use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — TCA audit columns sourced from HZ_PARTIES.

Common Use Cases and Queries

Typical scenarios include validation reports for the ADMF2M44 process, institution-level listings of organization units with their eligible funding sources, and extracts for downstream reporting where a flat organization-to-funding-source matrix is required. Active funding sources are usually isolated with CLOSED_IND = 'N'.

Sample query listing active organization units and their funding sources for one institution:

• SELECT org_unit_cd, ou_description, org_type, institution_cd, funding_source, fs_description FROM apps.igs_or_unit_fundsrc_v WHERE institution_cd = :institution AND closed_ind = 'N' ORDER BY org_unit_cd, funding_source;

Sample query filtering by the searched attribute:

• SELECT org_unit_cd, ou_description, funding_source FROM apps.igs_or_unit_fundsrc_v WHERE UPPER(ou_description) LIKE UPPER(:search_text) || '%';

Sample query returning only government funding sources:

• SELECT org_unit_cd, ou_description, funding_source, fs_description FROM apps.igs_or_unit_fundsrc_v WHERE govt_funding_source = 'Y' AND closed_ind = 'N';

Because of the cross-join behavior, queries should always constrain on institution, organization unit, or funding source to avoid returning an excessively large result set.