Results for “status_description”
1 result
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PS_UNIT_OFR_OPT_V is a reporting view within the Oracle E-Business Suite IGS — Student System product family. In EBS 12.1.1 and 12.2.2 this module is classified as obsolete, meaning Oracle has ceased active development and the object is retained only for backward compatibility with institutions that still run legacy Student System data. The view presents a denormalized, flattened picture of a unit offering option — the schedulable instance of a course unit that an institution makes available for enrollment in a given academic calendar — joined to its parent unit version and to descriptive lookups.
The mnemonic decomposes as follows: IGS is the Student System schema prefix, PS denotes the Student Records/Enrollment sub-area, UNIT_OFR refers to unit offering, OPT indicates an offering option or section variant, and _V confirms that the object is a database view rather than a base table. Its role in reporting and integration is to serve as a single denormalized source for enrollment, catalog, scheduling, and financial-aid reporting queries that would otherwise require joining five or more tables.
Notably, the metadata records this view as not implemented in this database. In a target environment where the IGS schema is not installed or the specific view has been dropped, any query or concurrent program referencing IGS_PS_UNIT_OFR_OPT_V will raise ORA-00942 or a similar resolution error. Consultants should therefore verify its existence before designing dependent extracts.
Underlying Base Objects
The documented view text references the following aliased base objects: UOO (the unit offering option table, contributing the majority of columns and the ROW_ID/UOO_ID keys), UV (the unit version table, supplying UNIT_STATUS, TITLE, and default credit-point values), CI (the calendar instance, providing alternate code and start/end dates), UC (unit class, providing unit mode), LOC (location lookup, providing the location description), US (a lookup on section status meaning), OU (owner organization unit, providing start date and party name), and CPS (a credit-point summary object used with NVL to override the unit-version defaults for achievable and enrolled credit points). No referenced base objects are formally documented beyond these aliases in the ETRM metadata.
Key Columns
- UNIT_CD / VERSION_NUMBER — identify the catalog unit and its version.
- UNIT_STATUS — sourced from UV; the academic status of the unit version (e.g., active, inactive, retired). This is the column most closely associated with the user's unit_status search.
- UNIT_SECTION_STATUS / STATUS_DESCRIPTION — the offering-level status code and its decoded meaning from the US lookup.
- CALL_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, ALTERNATE_CODE, CAL_START_DT, CAL_END_DT — scheduling and calendar-instance attributes.
- UNIT_CLASS, UNIT_MODE, LOCATION_CD, LOCATION_DESCRIPTION — delivery-mode and location data.
- UNIT_SECTION_START_DATE / UNIT_SECTION_END_DATE — the effective teaching window.
- ENROLLMENT_ACTUAL, WAITLIST_ACTUAL, UNIT_QUOTA, UNIT_QUOTA_RESERVED_PLACES — enrollment and capacity metrics.
- STATE/FEDERAL/INSTITUTIONAL_FINANCIAL_AID — financial-aid eligibility flags.
- ACHIEVABLE_CREDIT_POINTS / ENROLLED_CREDIT_POINTS — resolved from CPS with UV fallback.
- OFFERED_IND, SS_DISPLAY_IND, SS_ENROL_IND, IVRS_AVAILABLE_IND — publication and self-service visibility flags.
- Standard CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN audit columns.
Common Use Cases and Queries
The view is typically consumed by enrollment-catalog extracts, timetable publications, and capacity reports. A common pattern filters on academic status and section status simultaneously:
SELECT unit_cd, version_number, call_number, unit_status, status_description, enrollment_actual, unit_quota FROM igs_ps_unit_ofr_opt_v WHERE unit_status = 'ACTIVE' AND offered_ind = 'Y';
Because it may not exist in a given environment, the following defensive check is advisable before executing dependent SQL:
SELECT COUNT(*) FROM all_views WHERE view_name = 'IGS_PS_UNIT_OFR_OPT_V';
Where the view is unavailable, equivalent results must be reconstructed from the underlying IGS base tables, applying the joins shown in the view text above.