Results for “igs_ps_unit_ofr_opt_all”

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

Overview

IGS_PS_UNIT_OFR_OPT_ALL is a Student System table in Oracle E-Business Suite that describes the available options for each unit offering. In the Oracle EBS 12.1.1 and 12.2.2 ETRM documentation set, the object is classified under the IGS product line and is flagged as obsolete. Institutions running the former Student System modules may still encounter the table in legacy schemas, custom extensions, and historical data extraction routines, even though it is documented as not implemented in the reference database.

Each row represents a specific unit offering option — a schedulable, enrollable instance of a unit offering, qualified by calendar type, class-instance sequence, location, and unit class. The table acts as the central anchor for enrollment, teaching, financial aid, and scheduling activity within the Student System, which is why so many dependent tables carry a UOO_ID foreign key to it.

The heuristic Data Vault classification mined from the foreign-key structure identifies this table as a hub. In Data Vault modeling terms, this suggests the table functions as a business-key-driven entity that defines the identity of the unit offering option, while surrounding tables capture descriptive attributes and transactional relationships. This classification is a modeling suggestion derived from the FK topology rather than an Oracle-published designation.

Key Information Stored

The table contains 54 documented columns. The most significant are summarized below.

• UOO_ID — the surrogate identifier for the unit offering option. It is the target of the majority of inbound foreign keys and is protected by the unique index IGS_PS_UNIT_OFR_OPT_ALL_U2, making it the primary operational key for joins.
• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, and UNIT_CLASS — the composite business key. The unique index IGS_PS_UNIT_OFR_OPT_ALL_U1 covers this set, and an additional unique key (IGS_PS_UNIT_OFR_OPT_ALL_UK2) is defined on CAL_TYPE, CI_SEQUENCE_NUMBER, and CALL_NUMBER.
• CALL_NUMBER — the call or section identifier associated with the offering option.
• UNIT_SECTION_STATUS, UNIT_SECTION_START_DATE, UNIT_SECTION_END_DATE — the lifecycle state and effective dates of the section.
• ENROLLMENT_ACTUAL, WAITLIST_ACTUAL, UNIT_QUOTA, UNIT_QUOTA_RESERVED_PLACES — enrollment counts and capacity controls used for demand and waitlist reporting.
• OFFERED_IND, SS_ENROL_IND, SS_DISPLAY_IND — self-service and offering availability flags.
• GRADING_SCHEMA_CD, GS_VERSION_NUMBER, GRADING_SCHEMA_PRCDNCE_IND — grading configuration for the option.
• RESERVED_SEATING_ALLOWED, SPECIAL_PERMISSION_IND, FEDERAL_FINANCIAL_AID, STATE_FINANCIAL_AID, INSTITUTIONAL_FINANCIAL_AID — policy and eligibility attributes.
• REV_ACCOUNT_CD — the revenue account associated with the offering option.
• STANDARD WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) plus ORG_ID, which supports multi-organization filtering.

Scheduling and pedagogy attributes such as ATTENDANCE_REQUIRED_IND, NON_STD_USEC_IND, AUDITABLE_IND, DIR_ENROLLMENT, ENR_FROM_WLST, and INQ_NOT_WLST further qualify how the option behaves during enrollment processing.

Common Use Cases and Queries

Reporting on unit offering options is typically driven by the composite business key and by enrollment counts. A common pattern joins the option to its parent unit offering pattern through UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER.

• Enrollment and capacity reports: aggregate ENROLLMENT_ACTUAL and WAITLIST_ACTUAL against UNIT_QUOTA and UNIT_QUOTA_RESERVED_PLACES to identify over-subscribed sections.
• Self-service availability extracts: filter on SS_ENROL_IND, SS_DISPLAY_IND, and OFFERED_IND to build catalog listings.
• Financial aid reporting: select options where FEDERAL_FINANCIAL_AID, STATE_FINANCIAL_AID, or INSTITUTIONAL_FINANCIAL_AID indicators are set, joining REV_ACCOUNT_CD to the account table.
• Grading configuration audits: join GRADING_SCHEMA_CD and GS_VERSION_NUMBER to the grading schema definition.
• Location and contact analysis: resolve LOCATION_CD and UNIT_CONTACT to their respective dimension tables.

A representative query shape is: SELECT u.UOO_ID, u.UNIT_CD, u.VERSION_NUMBER, u.CAL_TYPE, u.CALL_NUMBER, u.UNIT_SECTION_STATUS, u.ENROLLMENT_ACTUAL, u.UNIT_QUOTA FROM IGS_PS_UNIT_OFR_OPT_ALL u WHERE u.OFFERED_IND = 'Y' AND u.ORG_ID = :org_id;

Related Objects

The table participates in a dense web of foreign-key relationships, which confirms its hub position.

• IGS_PS_UNIT_OFR_PAT_ALL — parent unit offering pattern, joined on UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER.
• IGS_EN_SU_ATTEMPT_ALL — student unit attempts, referencing both UNIT_CD and UOO_ID.
• IGS_PS_USEC_OCCURS_ALL — offering occurrence instances linked through UOO_ID.
• IGS_PS_USEC_X_USEC — self-referencing parent/child relationships via PARENT_UOO_ID and CHILD_UOO_ID.
• IGS_FI_FTCI_ACCTS and IGS_FI_FAI_DTLS — financial aid and contract accounting detail rows keyed by UOO_ID.
• IGS_AS_GRD_SCHEMA — grading schema definition referenced by GRADING_SCHEMA_CD and GS_VERSION_NUMBER.
• IGS_AD_LOCATION_ALL — location dimension referenced by LOCATION_CD.
• IGS_AS_UNIT_CLASS_ALL — unit class dimension referenced by UNIT_CLASS.
• IGS_FI_ACC_ALL — account definition referenced by REV_ACCOUNT_CD.
• HZ_PARTIES — trading community party referenced by UNIT_CONTACT.

Because the table is documented as obsolete, join these relationships only when working with legacy Student System data or migration extracts. Confirm physical presence in the target schema before relying on the table in new development.