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:
- UNIT_SECTION_REFERENCE_ID — the surrogate primary key (IGS_PS_USEC_REF_PK) and a unique-index candidate (IGS_PS_USEC_REF_U1).
- UOO_ID — the foreign key to IGS_PS_UNIT_OFR_OPT_ALL and the second unique-index candidate (IGS_PS_USEC_REF_U2), anchoring the record to a unit offering option.
- SUBTITLE_ID — foreign key to IGS_PS_UNIT_SUBTITLE.
- TITLE and SHORT_TITLE — display descriptors for the section reference.
- SUBTITLE and SUBTITLE_MODIFIABLE_FLAG — subtitle text and whether it may be changed.
- CLASS_SCHEDULE_EXCLUSION_FLAG and REGISTRATION_EXCLUSION_FLAG — indicators controlling exclusion from scheduling and enrollment processing.
- RECORD_EXCLUSION_FLAG — soft-delete / record-inactivation indicator.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard EBS descriptive flexfield columns.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
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.
-
To capture the relation between Unit Sections and Unit Section Reference Codes
-
TABLE: IGS.IGS_PS_USEC_REF 12.1.1
-
Table: IGS_PS_USEC_REF 12.2.2
To capture the relation between Unit Sections and Unit Section Reference Codes
Not implemented in this database·Explore IGS module →
-
View: IGSFV_USEC_REFERENCES 12.1.1
This is the full view, which describes the relation between unit sections reference and reference codes
APPS.IGSFV_USEC_REFERENCES·↳ IGS_GE_REF_CD_TYPE·↳ IGS_PS_USEC_REF·↳ IGS_PS_USEC_REF_CD·Explore IGS module →
-
View: IGSBV_USEC_REFERENCES 12.1.1
This is the base view, which describes the relation between unit sections reference and reference codes
APPS.IGSBV_USEC_REFERENCES·↳ IGS_GE_REF_CD_TYPE·↳ IGS_PS_USEC_REF·↳ IGS_PS_USEC_REF_CD·Explore IGS module →
-
Table: IGS_PS_US_REQ_REF_CD 12.2.2
This table contains information about Unit Section Requirements Reference Codes.
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_USEC_REF_V 12.1.1
The view is created for showing the relation between Unit Sections and Unit Section Reference Code.
APPS.IGS_PS_USEC_REF_V·↳ IGS_PS_UNIT_SUBTITLE·↳ IGS_PS_USEC_REF·Explore IGS module →
-
Table: IGS_PS_USEC_REF_CD 12.2.2
Entity to capture the relation between Unit Sections Reference and Reference codes.
Not implemented in this database·Explore IGS module →
-
This entity describes the available options for each unit offering.
Not implemented in this database·Explore IGS module →
-
Enrollment Worksheet Result
APPS.IGS_SS_EN_ENROLL_CART_RSLT_V·↳ IGS_AD_LOCATION·↳ IGS_PS_USEC_GRD_SCHM·↳ IGS_PS_USEC_REF·Explore IGS module →
-
View: IGSBV_USEC_REFERENCES 12.2.2
This is the base view, which describes the relation between unit sections reference and reference codes
Not implemented in this database·Explore IGS module →
-
Table: IGS_PS_UNIT_SUBTITLE 12.2.2
Describes the subtitles for units.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_PS_USEC_REF_V 12.1.1
-
View: IGSFV_USEC_REFERENCES 12.2.2
This is the full view, which describes the relation between unit sections reference and reference codes
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_USEC_REF_V 12.2.2
The view is created for showing the relation between Unit Sections and Unit Section Reference Code.
Not implemented in this database·Explore IGS module →
-
This table contains information about Unit Section Requirements Reference Codes.
-
Entity to capture the relation between Unit Sections Reference and Reference codes.
-
Enrollment Worksheet Result
Not implemented in this database·Explore IGS module →