Search Results rpt_fmly_id




Overview
Explore in AI Chat

Overview

The IGS_PS_RPT_FMLY_ALL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (Campus Solutions) product, owned by the IGS schema. Its primary role is to define and manage repeat families for academic units. A repeat family is a logical grouping of course units under a common code, which indicates that these units are considered equivalent or related for the purpose of academic rules, such as preventing students from receiving credit for the same material multiple times. This table acts as a master reference, storing the unique codes and descriptions that identify these groupings across the academic curriculum.

Key Information Stored

The table stores the defining attributes for a repeat family. The most critical columns include the system-generated primary key, RPT_FMLY_ID, which uniquely identifies each record and is populated by the associated sequence IGS_PS_RPT_FMLY_ALL_S. The business identifier is the REPEAT_CODE (VARCHAR2(10)), a unique, user-defined code that signifies the family. This code is paired with a DESCRIPTION (VARCHAR2(80)) for clarity. The CLOSED_IND flag controls the lifecycle of the code, marking it as inactive and unavailable for new assignments when set. Supporting multi-organization architecture, the ORG_ID column segregates data by operating unit, and standard WHO columns (CREATED_BY, CREATION_DATE, etc.) track audit information.

Common Use Cases and Queries

This table is central to enforcing academic policies regarding unit repetition. A primary use case is the setup and maintenance of repeat families via the application's administrative forms, ensuring units with overlapping content are correctly grouped. For reporting and data validation, common queries involve listing active repeat families for a specific operating unit or identifying which units belong to a particular family via a join to the IGS_PS_UNIT_VER_ALL table. A typical query to retrieve all active repeat codes for analysis would be:

  • SELECT RPT_FMLY_ID, REPEAT_CODE, DESCRIPTION FROM IGS_PS_RPT_FMLY_ALL WHERE CLOSED_IND = 'N' AND ORG_ID = :org_id ORDER BY REPEAT_CODE;

Technical integrations or data fixes often reference the RPT_FMLY_ID when associating or disassociating units from a family, using it as the key foreign key value.

Related Objects

The IGS_PS_RPT_FMLY_ALL table has defined relationships with other key curriculum objects. Its primary key is enforced by the constraint IGS_PS_RPT_FMLY_ALL_PK on the RPT_FMLY_ID column. The most significant relationship is as a parent table to IGS_PS_UNIT_VER_ALL, which stores version-specific details of academic units. A foreign key constraint exists where IGS_PS_UNIT_VER_ALL.RPT_FMLY_ID references IGS_PS_RPT_FMLY_ALL.RPT_FMLY_ID. This is the operational link that assigns individual unit versions to a repeat family. The table is also referenced by the synonym APPS.IGS_PS_RPT_FMLY_ALL, which provides the standard access point for the application tier.