Results for “show_on_official_ntfctn_ind”

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

Overview

IGS_PS_OFR_UNIT_SET is a table within the Oracle E-Business Suite Student System (IGS) product family, historically deployed in releases such as 12.1.1 and 12.2.2. Per the ETRM metadata, this entity describes the link between unit sets and programs — for example, it links the possible majors to a program. In the academic data model, unit sets represent collections of academic units (subjects, majors, or specializations) that a learner may pursue, and this table establishes which of those unit sets are permitted or offered against a given program (course) version within a specific calendar type.

The metadata flags this product as Obsolete and states that the object is "Not implemented in this database." Consequently, in most EBS 12.1.1 and 12.2.2 installations, the table does not physically exist and appears only in the historical reference model retained by the ETRM repository. The FK-derived heuristic classifies IGS_PS_OFR_UNIT_SET as hub-leaning within a Data Vault modeling scheme, suggesting that its composite business key identifies a distinct, referenceable construct — a program-to-unit-set association — around which dependent relationships are attached.

Key Information Stored

The table carries thirteen documented columns. The most significant are the five that constitute both the primary key (IGS_PS_OFR_UNIT_SET_PK) and the unique business-key index (IGS_PS_OFR_UNIT_SET_U1):

• COURSE_CD — the program (course) code identifying the owning program version; part of the composite key and a foreign key to IGS_PS_OFR_ALL.
• CRV_VERSION_NUMBER — the version number of the program offering record, qualifying COURSE_CD.
• CAL_TYPE — the calendar type (e.g., academic, admission) under which the program version applies.
• UNIT_SET_CD — the unit set code being linked to the program; a foreign key to IGS_EN_UNIT_SET_ALL.
• US_VERSION_NUMBER — the version number of the unit set, qualifying UNIT_SET_CD.

Functional attributes complement the key: OVERRIDE_TITLE allows a context-specific display title to supersede the default unit set title for the program, ONLY_AS_SUB_IND constrains whether the unit set may be used solely as a subordinate set, and SHOW_ON_OFFICIAL_NTFCTN_IND controls whether the set appears on official notifications. The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are standard Oracle EBS audit columns. There is no single-column surrogate identifier: the primary key is wholly composite and identical to the unique business key.

Common Use Cases and Queries

Where the table is present, its principal reporting purpose is to enumerate the unit sets (majors, specializations, or subject groupings) that a program version exposes, filtered by calendar type and constrained by ONLY_AS_SUB_IND and SHOW_ON_OFFICIAL_NTFCTN_IND. A typical query joining the program offering and unit set masters appears as follows:

• Program-to-unit-set listing: SELECT o.COURSE_CD, o.CRV_VERSION_NUMBER, o.CAL_TYPE, u.UNIT_SET_CD, u.US_VERSION_NUMBER, o.OVERRIDE_TITLE FROM IGS_PS_OFR_UNIT_SET o, IGS_EN_UNIT_SET_ALL u WHERE o.UNIT_SET_CD = u.UNIT_SET_CD AND o.US_VERSION_NUMBER = u.US_VERSION_NUMBER;
• Official notification reporting: filter on SHOW_ON_OFFICIAL_NTFCTN_IND = 'Y' to restrict output to sets published on official documents.
• Subordinate-set validation: identify records where ONLY_AS_SUB_IND = 'Y' before allowing a unit set to be offered as a leading choice.
• Version reconciliation: compare CRV_VERSION_NUMBER and US_VERSION_NUMBER to detect stale program-to-unit-set links against current unit set versions.

Because the table is documented as obsolete and unimplemented, these patterns primarily serve migration auditing, data-model archaeology, and reconciliation when moving legacy IGS data into successor structures.

Related Objects

The FK metadata positions this table as both a dependent and a parent within the IGS structural model:

• IGS_PS_OFR_ALL — the program offering master; joined on COURSE_CD, CRV_VERSION_NUMBER, and CAL_TYPE.
• IGS_EN_UNIT_SET_ALL — the unit set master; joined on UNIT_SET_CD and US_VERSION_NUMBER.
• IGS_PS_OF_OPT_UNT_ST — optional unit set association; references this table on COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, UNIT_SET_CD, and US_VERSION_NUMBER.
• IGS_PS_OF_UNT_SET_RL — unit set relationship (sub/super hierarchy); references this table on two FK paths, using SUB_UNIT_SET_CD/SUB_US_VERSION_NUMBER and SUP_UNIT_SET_CD/SUP_US_VERSION_NUMBER respectively.

These four objects constitute the immediate structural neighborhood of IGS_PS_OFR_UNIT_SET and should be consulted together when interpreting legacy program-to-unit-set configurations.