Search Results igs_ru_set_member_pk

Overview

The IGS_RU_SET_MEMBER table is a core data object within the Oracle E-Business Suite Student System (IGS), specifically designed to manage rule set membership. In the context of academic administration, rule sets are logical groupings used to define and enforce specific academic policies, prerequisites, or progression requirements. This table functions as the junction entity that associates individual rule components, identified by unit codes, with their parent rule sets. Its primary role is to establish the membership structure, allowing for complex, multi-part rule definitions. It is critical to note that the provided ETRM metadata explicitly states this product module is marked as "Obsolete" and the table itself is "Not implemented in this database," indicating it may represent legacy functionality in the specified releases (12.1.1 / 12.2.2).

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the fundamental data it holds. The two key columns are RS_SEQUENCE_NUMBER and UNIT_CD. The RS_SEQUENCE_NUMBER serves as the foreign key link to the parent IGS_RU_SET table, uniquely identifying the rule set to which a member belongs. The UNIT_CD column stores the code identifying the specific unit, or rule component, that is a member of that set. Together, these columns create a record defining that a particular unit is a constituent part of a specific rule set. The existence of a primary key on this combination also enforces data integrity, preventing duplicate memberships within the same rule set.

Common Use Cases and Queries

This table is central to queries that need to list, validate, or report on the composition of academic rule sets. A common operational use case would be an advisor or administrator needing to understand all components that make up a graduation requirement or a course prerequisite rule. Sample SQL would typically involve joining to the IGS_RU_SET table to get descriptive information about the rule set itself.

• Listing all members of a specific rule set:
  SELECT unit_cd FROM igs_ru_set_member WHERE rs_sequence_number = <set_id> ORDER BY unit_cd;
• Finding which rule sets a specific unit belongs to:
  SELECT s.rule_set_name, m.rs_sequence_number FROM igs_ru_set_member m JOIN igs_ru_set s ON m.rs_sequence_number = s.rs_sequence_number WHERE m.unit_cd = '<UNIT_CODE>';

Related Objects

Based on the provided relationship data, IGS_RU_SET_MEMBER has a direct and singular foreign key relationship. The table references the IGS_RU_SET table via the RS_SEQUENCE_NUMBER column. This establishes a one-to-many relationship where a single rule set defined in IGS_RU_SET can have multiple member records in IGS_RU_SET_MEMBER. The primary key IGS_RU_SET_MEMBER_PK (RS_SEQUENCE_NUMBER, UNIT_CD) ensures each member association is unique. There are no other documented foreign keys where this table is the referenced (parent) table in the provided metadata.