Results for “igs_ps_usec_ref_v”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PS_USEC_REF_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to expose the relationship between Unit Sections and the Unit Section Reference Code. In ETRM 12.2.2 the view is classified as part of the IGS - Student System, which is flagged as obsolete, and the metadata records "Not implemented in this database," meaning it does not exist as a deployed object in the reference environment even though its definition is preserved. The view acts as a denormalized read layer over the student unit-section reference data, joining the unit section reference entity to the unit subtitle entity so that consumers can retrieve reference-code attributes together with their associated subtitle text in a single query. Analysts and integrators searching on the column class_schedule_exclusion_flag typically reach this view because that flag is one of several exclusion indicators surfaced here rather than on the base table alone.
Underlying Base Objects
The documented view definition is a two-table outer join. The driving table is IGS_PS_USEC_REF (aliased USRF), which supplies the unit section reference identifier, the unit offering option identifier, short and long titles, the three exclusion flags, and the twenty descriptive flexfield attribute columns. The second table is IGS_PS_UNIT_SUBTITLE (aliased UVSB), which supplies the SUBTITLE value; it is joined on SUBTITLE_ID using an outer join (UVSB.SUBTITLE_ID(+) in Oracle syntax), so unit section reference rows are retained even when no matching subtitle row exists. The ROWID of IGS_PS_USEC_REF is exposed as ROW_ID, which allows the view to be used for row-level identification purposes. No additional base objects are documented for this view in the ETRM metadata.
Key Columns
- ROW_ID — the ROWID of the underlying IGS_PS_USEC_REF row.
- UNIT_SECTION_REFERENCE_ID — primary identifier of the unit section reference record.
- UOO_ID — the unit offering option to which the reference relates.
- SUBTITLE_ID / SUBTITLE — the foreign key to the subtitle entity and the resolved subtitle text from IGS_PS_UNIT_SUBTITLE.
- SUBTITLE_MODIFIABLE_FLAG — indicates whether the subtitle may be modified.
- CLASS_SCHEDULE_EXCLUSION_FLAG — indicates whether the unit section is excluded from class scheduling; the column most frequently sought by users searching this view.
- REGISTRATION_EXCLUSION_FLAG — indicates exclusion from registration processing.
- RECORD_EXCLUSION_FLAG — indicates exclusion from record creation or maintenance.
- SHORT_TITLE / TITLE — short and full descriptive titles of the reference.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — descriptive flexfield context and segments.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.
Common Use Cases and Queries
Because the view couples exclusion flags with subtitle descriptions, it is typically used in student scheduling and registration reporting, and in integrations that must determine whether a unit section reference participates in class schedule generation. A representative query retrieving references excluded from class scheduling is:
SELECT usec.unit_section_reference_id, usec.uooid, usec.short_title,
usec.subtitle, usec.class_schedule_exclusion_flag,
usec.registration_exclusion_flag, usec.record_exclusion_flag
FROM igs_ps_usec_ref_v usec
WHERE usec.class_schedule_exclusion_flag = 'Y';
A second pattern reports the full exclusion profile per unit offering option, joining on UOO_ID to the unit offering option entity. Practitioners should verify object existence before relying on the view, since the ETRM metadata states it is not implemented in the documented database and the IGS product line is marked obsolete; equivalent functionality in supported releases is generally obtained directly from IGS_PS_USEC_REF joined to IGS_PS_UNIT_SUBTITLE.
-
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 →
-
VIEW: APPS.IGS_PS_USEC_REF_V 12.1.1
-
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 →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.