Search Results igs_ps_usec_spnsrshp




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_SPNSRSHP is a table within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to serve as the entity that captures sponsorship information for a unit section. A unit section represents a specific offering of a unit (course) delivered by an academic institution, and sponsorship data attached to that offering identifies the external or internal organizations that financially underwrite seats, fees, or related costs for students enrolled in the section.

The ETRM metadata classifies this table with a heuristic Data Vault designation of a link. This modeling suggestion is consistent with the table's structure: it holds a surrogate primary key alongside multiple foreign-key and business-key columns, functioning as an associative entity that ties a unit section offering to sponsorship details. The table is flagged as obsolete and is documented as not implemented in the reference database, meaning it may exist as a legacy or placeholder object in certain installations but carries no active data in the described environment.

Key Information Stored

The table exposes nine documented columns. The most significant are summarized below.

Common Use Cases and Queries

In implementations where the table is active, it supports reporting on which organizations sponsor particular unit offerings and at what percentage. A typical retrieval joins the sponsorship record to its parent offering option:

SELECT s.unit_section_sponsorship_id,
       s.organization_code,
       s.sponsorship_percentage,
       o.unit_offering_option_id
FROM   igs_ps_usec_spnsrshp s,
       igs_ps_unit_ofr_opt_all o
WHERE  s.uoO_id = o.unit_offering_option_id
AND    s.organization_code = :org_code;

Because the metadata states the table is not implemented in the described database, queries against it in such environments will return no rows or fail if the object does not physically exist. Analysts verifying sponsorship data should first confirm object existence and row counts before building dependent reports.

Related Objects

  • IGS_PS_UNIT_OFR_OPT_ALL — The principal parent table. IGS_PS_USEC_SPNSRSHP.UOO_ID references it via two documented foreign-key relationships, making it the primary join target.
  • IGS_PS_UNIT_OFR_OPT_ALL (offering option context) — Supplies the offering, unit, and calendar context required to interpret any sponsorship record.
  • IGS_PS_USEC_SPNSRSHP_PK — The primary-key constraint object underpinning the surrogate identifier.
  • IGS_PS_USEC_SPNSRSHP_U1 — Unique index on UNIT_SECTION_SPONSORSHIP_ID.
  • IGS_PS_USEC_SPNSRSHP_U2 — Unique index on (UOO_ID, ORGANIZATION_CODE), the business-key candidate.

No additional dependent views or APIs are documented in the provided ETRM metadata, and the object's obsolete status limits its significance in current 12.1.1 and 12.2.2 implementations.