Results for “igs_ps_usec_ref”

50+ results




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

Overview

IGS_PS_USEC_REF is a table within the Oracle E-Business Suite Student System (IGS) product family. In ETRM 12.1.1 and 12.2.2, its documented purpose is to capture the relationship between Unit Sections and Unit Section Reference Codes. This places the table in the enrollment and academic-structure layer of the Student System, where unit offerings, options, and section-level reference data are maintained. Notably, the ETRM metadata classifies the product as obsolete and states that the table is "not implemented in this database," so in most 12.1.1 and 12.2.2 instances the object exists only as shipped reference metadata rather than as an active, populated table.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning. That is a modeling suggestion rather than a physical assertion: the table behaves as a descriptive, dependent record clustered around a parent business key (UOO_ID), which aligns with the structure of a satellite attached to a hub or link representing the unit offering option.

Key Information Stored

The table is owned by the IGS schema and carries 36 documented columns. The most significant are:

Primary key and unique columns are explicitly documented; the remaining non-key columns (the full attribute block) are present per the documented schema but carry no described semantics in the metadata.

Common Use Cases and Queries

Where the table is populated in a legacy or migrated environment, typical patterns involve joining section reference records back to the unit offering option that owns them.

Retrieving section reference details for a unit offering option:

  • SELECT r.UNIT_SECTION_REFERENCE_ID, r.UOO_ID, r.TITLE, r.SHORT_TITLE FROM IGS_PS_USEC_REF r WHERE r.UOO_ID = :uoo_id;

Filtering active, registerable records by excluding flagged rows:

  • SELECT * FROM IGS_PS_USEC_REF WHERE RECORD_EXCLUSION_FLAG = 'N' AND REGISTRATION_EXCLUSION_FLAG = 'N';

Joining to the unit offering option for reporting:

  • SELECT o.*, r.TITLE FROM IGS_PS_UNIT_OFR_OPT_ALL o JOIN IGS_PS_USEC_REF r ON r.UOO_ID = o.UOO_ID;

Typical reporting uses include auditing section-level exclusions, reconciling reference codes against their parent options, and supporting migration validation by comparing UOO_ID values against the offering option table. Because the table is documented as not implemented, any 12.2.2 work typically starts with confirming whether the object was actually created and populated.

Related Objects

The documented foreign-key structure links IGS_PS_USEC_REF to several Student System tables. The most significant relationships are:

  • IGS_PS_UNIT_OFR_OPT_ALL — referenced twice via IGS_PS_USEC_REF.UOO_ID, the parent unit offering option.
  • IGS_PS_UNIT_SUBTITLE — referenced via IGS_PS_USEC_REF.SUBTITLE_ID.
  • IGS_PS_US_REQ_REF_CD — references this table through UNIT_SECTION_REFERENCE_ID.
  • IGS_PS_USEC_REF_CD — also references this table through UNIT_SECTION_REFERENCE_ID.

These four relationships define the object's position in the schema: it depends on the unit offering option and subtitle definitions, while the two "CD" tables depend on it. No views or PL/SQL APIs are documented for this table in the supplied metadata, so the referenced tables above represent the authoritative dependency set.