Results for “igs_ps_unit_ofr_opt”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view IGS_PS_UNIT_OFR_OPT belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module that is now classified as obsolete in the ETRM documentation set spanning releases 12.1.1 and 12.2.2. Functionally, the view exposes the record set behind the Unit Offering Option entity — the child-level, section-specific configuration of a unit offering that institutions use to control how a particular teaching instance is offered, enrolled into, graded, and reported. Each row represents a discrete offering option identified by the UOO_ID surrogate key, tied to a parent unit, version, calendar type, and location.
In reporting and integration terms, IGS_PS_UNIT_OFR_OPT served as a flattened, read-oriented projection suitable for enrollment rules, quota reporting, financial-aid flag analysis, and downstream extracts feeding student self-service or third-party schedulers. Because it collapses many offering-control attributes into a single denormalized row, it was commonly referenced by concurrent programs, discoverer reports, and interface staging logic rather than by transactional forms.
Underlying Base Objects
The ETRM metadata explicitly records that this object is not implemented in this database and lists no documented referenced base objects. The view text, however, is a straightforward SELECT ... FROM TAB projection, where the alias TAB resolves nominally to the underlying Unit Offering Option entity table, corresponding to the product's base entity carrying the UOO_ID primary key. No joins, unions, or derived expressions appear in the view text — every projected column maps one-to-one to a physical column on the base entity.
Because the object is obsolete and undocumented at the 12.2.2 level, DBAs should treat the base table association as historical. Verification should be performed against the installation's data dictionary (DBA_VIEWS, DBA_DEPENDENCIES) before relying on the mapping in a live environment.
Key Columns
UNIT_CD,VERSION_NUMBER,CAL_TYPE,CI_SEQUENCE_NUMBER,LOCATION_CD,UNIT_CLASS— the composite business key identifying the unit offering being configured.UOO_ID— the unique surrogate identifier for the offering option row.OFFERED_IND,UNIT_SECTION_STATUS,UNIT_SECTION_START_DATE,UNIT_SECTION_END_DATE— offering availability and timeframe.UNIT_QUOTA,UNIT_QUOTA_RESERVED_PLACES,ENROLLMENT_ACTUAL,WAITLIST_ACTUAL,RESERVED_SEATING_ALLOWED— capacity and demand metrics.GRADING_SCHEMA_CD,GS_VERSION_NUMBER,GRADING_SCHEMA_PRCDNCE_IND,ANON_UNIT_GRADING_IND,ANON_ASSESS_GRADING_IND— grading configuration.SS_DISPLAY_IND,SS_ENROL_IND,DIR_ENROLLMENT,ENR_FROM_WLST,INQ_NOT_WLST— self-service and enrollment-control switches.STATE_FINANCIAL_AID,FEDERAL_FINANCIAL_AID,INSTITUTIONAL_FINANCIAL_AID— financial-aid eligibility flags.OWNER_ORG_UNIT_CD,ORG_ID— multi-org ownership context.CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN— standard WHO audit columns.REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE— concurrent-program audit context.
Common Use Cases and Queries
Typical scenarios include auditing which unit offerings allow self-service enrollment, reconciling quota against actual enrollment, and confirming grading-schema assignments ahead of results processing.
- Inspect offering options for a given unit and version.
- Report on open sections with remaining quota.
- Audit financial-aid and self-service flags.
SELECT uoo.unit_cd,
uoo.version_number,
uoo.cal_type,
uoo.location_cd,
uoo.uoo_id,
uoo.offered_ind,
uoo.unit_section_status,
uoo.unit_quota,
uoo.enrollment_actual,
uoo.ss_enrol_ind
FROM igs_ps_unit_ofr_opt uoo
WHERE uoo.unit_cd = :unit_cd
AND uoo.offered_ind = 'Y'
ORDER BY uoo.location_cd, uoo.uoo_id;
Given the obsolete classification, any production query should first confirm the view exists in the target schema; if absent, equivalent data must be sourced from the corresponding base entity or a supported successor view.
-
View: IGS_PS_UNIT_OFR_OPT 12.1.1
APPS.IGS_PS_UNIT_OFR_OPT·↳ IGS_PS_UNIT_OFR_OPT_ALL·Explore IGS module →
-
View: IGS_PS_UNIT_OFR_OPT 12.2.2
Not implemented in this database·Explore IGS module →