Results for “igs_ps_usec_rpt_cond_u2”

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

Overview

IGS.IGS_PS_USEC_RPT_COND is a transactional configuration table within the Oracle E-Business Suite Student Systems (IGS) schema. It stores the repeat condition rules that govern how a student may repeat a specific unit section offering. Each row associates a repeat-condition record with a unit offering option (UOO_ID), capturing the academic and funding constraints that determine whether, how often, and under what credit limits a unit section may be repeated. The table is populated and maintained by the Student Systems enrollment and progression processes and is consumed during enrollment validation, academic progress evaluation, and funding/credit reporting.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its unique indexes reside in APPS_TS_TX_IDX, reflecting the standard Oracle EBS separation of data and index storage. From a Data Vault modeling perspective, the metadata classifies this object as satellite-leaning. This is a heuristic suggestion: the table carries descriptive, attribute-rich columns (repeat indicators, maximums, and credit points) keyed to a parent unit offering option, which is characteristic of a satellite record attached to a business key hub rather than an independent hub or a relationship link.

Key Information Stored

The primary key is the surrogate identifier UNIT_SECTION_REPT_CONDITION_ID, which uniquely identifies each repeat-condition record and is enforced by the unique index IGS_PS_USEC_RPT_COND_U1. A second unique index, IGS_PS_USEC_RPT_COND_U2, enforces uniqueness on UOO_ID, making the unit offering option identifier a documented business-key candidate; in practice this constrains each unit offering option to a single repeat-condition record.

• UOO_ID — Unique unit section (unit offering option) identifier; the foreign key linking the condition to IGS_PS_UNIT_OFR_OPT_ALL.
• REPEATABLE_IND — Indicator of whether the unit section is repeatable at all.
• SAME_TEACHING_PERIOD — Indicator governing whether the repeat must occur within the same teaching period.
• MAX_REPEATS_FOR_CREDIT — Maximum number of permitted repeats when the repeat is taken for credit.
• MAX_REPEATS_FOR_FUNDING — Maximum number of repeats permitted for funding purposes.
• MAX_REPEAT_CREDIT_POINTS — Maximum credit points allowable for the repeat.
• SAME_TEACH_PERIOD_REPEATS — Number of repeats allowed within the same teaching period.
• SAME_TEACH_PERIOD_REPEATS_CP — Credit points associated with same-teaching-period repeats.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns capturing audit and concurrency information.

Common Use Cases and Queries

Typical uses include validating repeat eligibility during enrollment, reporting repeat limits for academic progression review, and reconciling credit and funding constraints for a unit offering option. A standard retrieval by business key uses the UOO_ID unique index:

• SELECT UNIT_SECTION_REPT_CONDITION_ID, REPEATABLE_IND, SAME_TEACHING_PERIOD, MAX_REPEATS_FOR_CREDIT, MAX_REPEATS_FOR_FUNDING, MAX_REPEAT_CREDIT_POINTS FROM IGS.IGS_PS_USEC_RPT_COND WHERE UOO_ID = :p_uooid;
• SELECT r.UOO_ID, r.REPEATABLE_IND, r.MAX_REPEATS_FOR_CREDIT FROM IGS.IGS_PS_USEC_RPT_COND r JOIN IGS.IGS_PS_UNIT_OFR_OPT_ALL o ON o.UOO_ID = r.UOO_ID WHERE r.SAME_TEACHING_PERIOD = 'Y';
• Aggregate reporting: SELECT COUNT(*) FROM IGS.IGS_PS_USEC_RPT_COND WHERE REPEATABLE_IND = 'Y';

Related Objects

The principal relationship is the foreign key from UOO_ID to IGS.IGS_PS_UNIT_OFR_OPT_ALL, the parent unit offering option record. Related dependent objects include the unique indexes IGS_PS_USEC_RPT_COND_U1 and IGS_PS_USEC_RPT_COND_U2, and the primary key constraint IGS_PS_USEC_RPT_COND_PK. Enrollment and progression validation logic within the Student Systems modules reads this table when evaluating repeat requests, and reporting views over unit offering options frequently join to it to expose repeat limits alongside offering attributes.