Results for “repeatable_indicator”

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

Overview

IGSBV_USEC_REPEAT_CONDITIONS is a read-only base view within the Oracle E-Business Suite product family identified as IGS – Student System. In the metadata catalogued for Oracle EBS 12.1.1 and 12.2.2 it is classified as an obsolete object, and the accompanying Case and Seed document (PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc) confirms this status. The view exposes the repeat conditions that govern whether a student may repeat a unit section, together with the quantitative ceilings applied to those repeats. Its role in reporting and integration is to present the repeat-condition attributes of a unit section alongside the descriptive attributes of the parent unit offering option, so that a single query can return both the rule definition and the academic context of the unit.

The object is presented as an enhancement-time artifact rather than as a supported production interface. The ETRM documentation records it as not implemented in the database, meaning it exists as a specification in the data model record but was not deployed.

Underlying Base Objects

The view text defines a two-table join. The driving table is IGS_PS_USEC_RPT_COND, aliased as US, which stores the repeat-condition rows keyed by the unit section repeat condition identifier. The second table is IGS_PS_UNIT_OFR_OPT_ALL, aliased as UN, which supplies the unit offering option details. The join predicate is US.UOO_ID = UN.UOO_ID, linking each repeat condition to its unit offering option by the unit offering option identifier. The view is declared WITH READ ONLY, preventing DML through the view. The documented view metadata for 12.2.2 records no referenced base objects and no owner, and the excerpt likewise states that the underlying base objects are not separately documented beyond the two tables named in the view text.

Key Columns

• UNIT_SECTION_REPT_CONDITION_ID – Primary key of the repeat-condition row.
• REPEATABLE_INDICATOR – Exposed from the source column REPEATABLE_IND, aliased because the user search term is repeatable_indicator. It flags whether the unit section is repeatable.
• SAME_TEACHING_PERIOD – Indicates whether the repeat is permitted within the same teaching period.
• MAX_REPEATS_FOR_CREDIT, MAX_REPEATS_FOR_FUNDING, MAX_REPEAT_CREDIT_POINTS – Ceilings on repeats counted for credit, for funding, and the associated credit points.
• SAME_TEACH_PERIOD_REPEATS, SAME_TEACH_PERIOD_REPEATS_CP – Repeat counts and credit points applicable where the teaching period is unchanged.
• UNIT_SECTION_ID – Exposed from UOO_ID, identifying the unit section.
• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS – Unit code, version, calendar type, calendar instance sequence, location, and unit class.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE – Standard audit columns inherited from the base table.

Common Use Cases and Queries

Typical use is audit or reporting of repeat rules by academic unit. The following query lists repeatable unit sections with their limits.

SELECT unit_cd, version_number, location_cd,
       repeatable_indicator, max_repeats_for_credit,
       max_repeats_for_funding, max_repeat_credit_points
FROM   igsbv_usec_repeat_conditions
WHERE  repeatable_indicator = 'Y';

Because the object is documented as obsolete and not implemented, it should not be referenced in new customizations. Confirm availability in the target instance before relying on it.