Search Results igsbv_usec_alloc_resps

Overview

IGSBV_USEC_ALLOC_RESPS is a read-only Oracle EBS view owned by the APPS schema and delivered as part of the IGS (Student System) product family. Its documented purpose is to serve as the base view describing sponsorship information for a unit section, presenting the financial allocation of a unit section across sponsoring organizations together with the identity of the unit offering itself. Because the view is defined WITH READ ONLY, it is intended exclusively for query and reporting access rather than for DML operations. In Oracle EBS 12.1.1 and 12.2.2 environments, the object is reported with STATUS = VALID, and it functions as a denormalized join layer that consolidates sponsorship records with their parent unit offering attributes. Its column naming preserves the internal identifier conventions of the Student System, including the mapped column CAL_INST_SEQUENCE_NUMBER, which is the alias most commonly located by users searching that term.

Underlying Base Objects

The view is defined over two base tables in the APPS schema. The first, IGS_PS_USEC_SPNSRSHP, supplies the sponsorship facts: the unit section sponsorship identifier, the unit offering option identifier (UOO_ID), the sponsoring organization code, and the sponsorship percentage. The second, IGS_PS_UNIT_OFR_OPT_ALL, supplies the descriptive attributes of the unit offering option, including unit code, version number, calendar type, calendar instance sequence number, location code, and unit class. The two sources are joined on UOO_ID, which forms the correlation key between the sponsorship record and the parent unit offering option. Within the view definition, the column UN.CI_SEQUENCE_NUMBER is projected and renamed to CAL_INST_SEQUENCE_NUMBER, so any external reference to that name must resolve through this view rather than the underlying base table column.

Key Columns

• UNIT_SECTION_SPONSORSHIP_ID — primary identifier for the sponsorship record inherited from IGS_PS_USEC_SPNSRSHP.
• UNIT_SECTION_ID — alias of US.UOO_ID, the unit offering option identifier that links the section to its offering row.
• ORGANIZATION_CODE — code identifying the sponsoring organization contributing to the section.
• SPONSORSHIP_PERCENTAGE — proportion of the unit section sponsored by that organization.
• UNIT_CODE, VERSION_NUMBER, CALENDAR_TYPE — teaching period and unit identification attributes drawn from the unit offering option.
• CAL_INST_SEQUENCE_NUMBER — the calendar instance sequence number (aliased from CI_SEQUENCE_NUMBER), identifying the specific calendar instance in which the unit is offered.
• LOCATION_CODE, UNIT_CLASS — delivery location and the classification of the unit offering.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

The view is typically used to report which organizations sponsor a given unit section and in what proportion, and to resolve sponsorship data alongside calendar instance information. A query retrieving all allocations for a unit offering option takes the following form:

SELECT unit_section_id,
       organization_code,
       sponsorship_percentage,
       unit_code,
       calendar_type,
       cal_inst_sequence_number
FROM   apps.igsbv_usec_alloc_resps
WHERE  unit_section_id = :p_uoo_id;

Because the view is read only with no INSTEAD OF triggers, it cannot support inserts or updates; any maintenance must be performed against IGS_PS_USEC_SPNSRSHP directly. Note that the documented ETRM metadata for this object lists no referenced base objects, so the dependency information above is derived from the published view text. Consumers should therefore validate dependencies against the data dictionary in their specific 12.1.1 or 12.2.2 instance before relying on them for impact analysis.