Search Results s_rule_call_cd




Overview
Explore in AI Chat

Overview

The IGS_EN_UNIT_SET_RULE table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student Systems (IGS) module. It functions as a mapping or junction table that defines the linkage between academic unit sets (programs or courses of study) and the specific business rules that govern them. Its primary role is to associate a unit set, identified by its code and version, with one or more rule sequences, categorized by a rule call code. This association is fundamental for enforcing academic policies, prerequisites, and progression requirements during student enrollment and academic planning processes.

Key Information Stored

The table stores a concise set of columns that establish the relationship between a unit set and its governing rules. The key identifiers are UNIT_SET_CD and VERSION_NUMBER, which together uniquely identify a specific version of an academic program. The S_RULE_CALL_CD is a critical field, representing the category or type of rule being applied (e.g., enrollment, completion, exclusion). The RUL_SEQUENCE_NUMBER points to the specific rule definition within that category that must be evaluated. The combination of UNIT_SET_CD, VERSION_NUMBER, and S_RULE_CALL_CD forms a unique constraint (IGS_EN_UNIT_SET_RULE_U1), ensuring a unit set version does not have duplicate rule call types defined. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information.

Common Use Cases and Queries

This table is central to academic rule engine operations. A common use case is determining all rules applicable to a student's enrolled unit set to validate course enrollment requests or assess academic standing. For a user searching for the specific column S_RULE_CALL_CD, typical queries involve listing all rule associations for a given rule call type or identifying which unit sets invoke a particular rule category.

  • Find all unit set versions associated with a specific rule call category: 
    SELECT unit_set_cd, version_number, rul_sequence_number
FROM igs.igs_en_unit_set_rule
WHERE s_rule_call_cd = '&RULE_CALL_CODE';
  • Retrieve the full rule mapping for a specific academic program: 
    SELECT s_rule_call_cd, rul_sequence_number
FROM igs.igs_en_unit_set_rule
WHERE unit_set_cd = '&UNIT_SET_CODE'
AND version_number = &VERSION_NUM
ORDER BY s_rule_call_cd;

Related Objects

Based on the provided metadata, the IGS_EN_UNIT_SET_RULE table is referenced by an object named IGS_EN_UNIT_SET_RULE within the APPS schema, which is likely a synonym or a view providing a public interface to this table. The table's design, particularly the non-unique index IGS_EN_UNIT_SET_RULE_N1 on S_RULE_CALL_CD, indicates performance optimization for queries filtering by rule call type. To fully interpret the rule definitions, this table would relate to the master tables storing Unit Set details (likely IGS_EN_UNIT_SET) and the specific rule definitions referenced by RUL_SEQUENCE_NUMBER, though these dependencies are not listed in the provided excerpt.