Results for “igs_ps_usec_spnsrshp_u2”

6 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS.IGS_PS_USEC_SPNSRSHP table is a transactional data object within the Oracle E-Business Suite Student Systems (IGS) product family. It captures sponsorship information associated with a unit section, allowing institutions to record which organizational units sponsor a given unit offering option and the percentage of that sponsorship. From a Data Vault modeling perspective, this object is best classified as a link, since it resolves a many-to-many relationship between a unit section (identified by UOO_ID) and a sponsoring organizational unit (identified by ORGANIZATION_CODE), carrying a measurable attribute (SPONSORSHIP_PERCENTAGE) that describes the association itself.

In EBS 12.1.1 and 12.2.2, the table resides in the IGS schema, is stored in the APPS_TS_TX_DATA tablespace, and is exposed to the application layer through the APPS synonym IGS_PS_USEC_SPNSRSHP. Its status is VALID and it is registered in FND Design Data as IGS.IGS_PS_USEC_SPNSRSHP.

Key Information Stored

The table contains nine documented columns. The most significant are outlined below.

  • UNIT_SECTION_SPONSORSHIP_ID (NUMBER) — the surrogate primary key and unique identifier for each sponsorship record. It is enforced by the unique index IGS_PS_USEC_SPNSRSHP_U1, which the user's search term (igs_ps_usec_spnsrshp_u1) directly references.
  • UOO_ID (NUMBER) — the unique identifier of the unit section (unit offering option) being sponsored. This column participates in a foreign key to IGS_PS_UNIT_OFR_OPT_ALL and forms part of the business-key candidate index IGS_PS_USEC_SPNSRSHP_U2.
  • ORGANIZATION_CODE (VARCHAR2, 10) — the sponsoring organizational unit code. It is the second column of IGS_PS_USEC_SPNSRSHP_U2 and, together with UOO_ID, constitutes a unique business key.
  • SPONSORSHIP_PERCENTAGE (NUMBER) — the percentage of sponsorship contributed by the sponsoring organization for the unit section. This is the principal non-key descriptive attribute.

The remaining columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are the standard EBS Who columns that provide audit and concurrency information.

Common Use Cases and Queries

The table is typically queried to determine which organizations sponsor a particular unit section, to compute aggregate sponsorship coverage, or to validate that sponsorship percentages are complete for a given offering. A representative query is:

SELECT s.UOO_ID, s.ORGANIZATION_CODE, s.SPONSORSHIP_PERCENTAGE FROM IGS.IGS_PS_USEC_SPNSRSHP s WHERE s.UOO_ID = :p_uooid ORDER BY s.ORGANIZATION_CODE;

Reporting use cases include listing all sponsored unit sections by organization, summing sponsorship percentages across a section to confirm they total appropriately, and joining to IGS_PS_UNIT_OFR_OPT_ALL to present section-level descriptive attributes alongside sponsorship detail. Operational scenarios include sponsorship setup and maintenance, fee sponsorship allocation, and audit reconciliation of sponsorship versus enrollment records.

Related Objects

  • IGS.IGS_PS_UNIT_OFR_OPT_ALL — the unit offering option (unit section) table. Joined via IGS_PS_USEC_SPNSRSHP.UOO_ID = IGS_PS_UNIT_OFR_OPT_ALL.UOO_ID.
  • IGS_PS_USEC_SPNSRSHP (APPS synonym) — the APPS-layer synonym used by application code and reports.
  • IGS_PS_USEC_SPNSRSHP_PK — the primary key constraint on UNIT_SECTION_SPONSORSHIP_ID.
  • 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 composite business key.

The table does not reference any database object other than through its UOO_ID foreign key, and is referenced by the APPS synonym IGS_PS_USEC_SPNSRSHP.