Search Results repeatable_indicator




Overview
Explore in AI Chat

Overview

IGSFV_USEC_REPEAT_CONDITIONS is a read-only Oracle E-Business Suite view owned by the APPS schema and defined in the Student Systems / Student Records (IGS) product family. It presents the repeat-condition configuration that governs whether a unit offering option may be attempted more than once, and under what rules. In ETRM 12.1.1 and 12.2.2 the view is registered against the higher-education unit-of-study data model, where the term "USEC" denotes "Unit Section" — the offering-level instance of a unit within a specific calendar, location, and class.

The view functions as a denormalized reporting surface. Rather than forcing report authors and integration developers to join the repeat-condition table directly to the unit offering table and resolve the many descriptive columns themselves, the view exposes the repeat rules already joined to unit code, version, calendar type, and location. Because it is declared WITH READ ONLY, it is intended strictly for query and extraction, not for DML. It is typically consumed by registration validation reports, enrolment exception analysis, student record extracts, and custom integrations that need to know whether a failed or previously passed attempt may be repeated.

Underlying Base Objects

The documented view text identifies two base objects. The driving table is IGS_PS_USEC_RPT_COND (aliased US), which stores one repeat-condition record per unit section. The second object is IGS_PS_UNIT_OFR_OPT_ALL (aliased UN), the unit offering option table, which supplies the descriptive unit attributes. These are combined in a simple equi-join on UOO_ID:

  • IGS_PS_USEC_RPT_COND — repeat condition rules, keyed by UNIT_SECTION_REPT_CONDITION_ID and linked through US.UOO_ID.
  • IGS_PS_UNIT_OFR_OPT_ALL — the "_ALL" variant, which includes records across the effective-dating or organizational security ranges, joined on UN.UOO_ID.

No additional base objects are documented in the ETRM metadata; the view's WHERE clause consists solely of the join predicate US.UOO_ID = UN.UOO_ID. This means the view inherits the multi-org/security behavior of the _ALL table and should be queried with the appropriate MO/security context where applicable.

Key Columns

The projection renames several columns for readability, most notably US.REPEATABLE_IND as REPEATABLE_INDICATOR — the exact term surfaced by the user's search. This is the primary flag indicating whether the unit section permits repeat attempts (typically Y/N). Supporting columns include:

Common Use Cases and Queries

Typical usage is to retrieve all repeatable unit sections, to audit which sections allow repeats and under what caps, or to feed an integration with repeat eligibility data. A representative query listing repeatable offerings is:

  • SELECT REPEATABLE_INDICATOR, UNIT_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, MAX_REPEATS_FOR_CREDIT, MAX_REPEATS_FOR_FUNDING FROM APPS.IGSFV_USEC_REPEAT_CONDITIONS WHERE REPEATABLE_INDICATOR = 'Y';
  • Joining to student attempt/enrolment tables on UNIT_SECTION_ID to determine whether a student who failed or passed a unit is eligible for a further attempt.
  • Reporting repeat rules by calendar type or location using the joined descriptive columns, avoiding a manual join in custom reports.

Because the view is read-only and keyed on UOO_ID, it should always be accessed within the correct operating-unit and security profile so that the underlying _ALL data set returns the intended rows.