Search Results same_teach_period_repeats_cp




Overview
Explore in AI Chat

Overview

The view IGS_PS_USEC_RPT_COND_V is a reporting and integration construct in the Oracle E-Business Suite Student System (IGS) product family. It is owned by the APPS schema and is documented as VALID in the ETRM repository for releases 12.1.1 and 12.2.2. The view exposes the repeat-conditioning rules that govern how a student may repeat a unit offering option within the context of a unit section. These rules determine whether a student is permitted to repeat a unit, how many times a repeat may be counted for academic credit, how many times it may be counted for funding purposes, and the credit points that may be accrued through repetition.

The ETRM description associates this view with the case and seed document PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc and marks the object as Obsolete. Despite this designation, the object remains present and valid in the APPS schema, which is common for superseded IGS views that are retained to preserve backward compatibility with custom reports, concurrent programs, and interface extracts that reference them. The view therefore functions primarily as a stable read-only projection of the underlying repeat-condition table, insulating downstream consumers from the physical column layout of that table.

Underlying Base Objects

The view is defined over a single base table: IGS_PS_USEC_RPT_COND (aliased as USRC). No other base objects, joins, or subqueries are documented in the view text; it is a direct, one-to-one projection of the table's columns with no filtering or transformation logic. Because the mapping is unfiltered, the view returns all rows present in the base table, and the row count and cardinality of the view are identical to those of IGS_PS_USEC_RPT_COND.

  • IGS_PS_USEC_RPT_COND — the sole documented referenced base table, storing unit section repeat-condition definitions keyed by UNIT_SECTION_REPT_CONDITION_ID.

Although the ETRM metadata lists no referenced base objects under the documented view metadata section, the embedded view text explicitly identifies IGS_PS_USEC_RPT_COND as the source. All columns are passed through directly, including the ROWID pseudo-column, which is aliased to ROW_ID.

Key Columns

Common Use Cases and Queries

Typical consumers use this view to enforce or report repeat eligibility during enrolment, to validate funding claims, and to drive custom extracts. Because the view is unfiltered, queries should restrict rows by the relevant identifier columns.

Retrieve repeat rules for a specific unit offering option:

  • SELECT uoo_id, repeatable_ind, max_repeats_for_credit, max_repeats_for_funding, max_repeat_credit_points FROM igs_ps_usec_rpt_cond_v WHERE uoo_id = :p_uoo_id;

Identify repeatable units permitting more than one credit-bearing repeat:

  • SELECT unit_section_rept_condition_id, uoo_id, max_repeats_for_credit FROM igs_ps_usec_rpt_cond_v WHERE repeatable_ind = 'Y' AND max_repeats_for_credit > 1;

Given its Obsolete status, new development should target the base table or its documented successor, but the view remains a valid integration point for existing IGS reports.