Search Results s_rule_call_cd




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_RU table is a core data object within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It functions as the central repository for defining and storing rules associated with academic units. In the context of a higher education institution's operational model, a "unit" typically represents a course or subject offering. This table enables the systematic enforcement of business logic, such as prerequisites, co-requisites, or other enrollment constraints, by linking specific rule types to unit codes. Its role is integral to maintaining academic integrity and automating compliance checks within the student lifecycle management processes.

Key Information Stored

The table's structure is designed to establish a unique relationship between a unit and a specific category of rule. Based on the provided metadata, the primary key is a composite of two columns, which are the most critical fields. The UNIT_CD column stores the unique identifier or code for the academic unit. The S_RULE_CALL_CD column, which was explicitly referenced in the user's search, is a key field that stores a code classifying the type of rule being invoked for the associated unit. This code likely references a lookup value defining rule categories such as 'PREREQ' for prerequisite or 'COREQ' for corequisite. The presence of these two columns as the primary key ensures that only one instance of a particular rule type can be defined per unit.

Common Use Cases and Queries

A primary use case is the validation of a student's eligibility to enroll in a specific unit. An application process would query this table to determine which rules (via S_RULE_CALL_CD) apply to a given UNIT_CD, then execute the corresponding logic to evaluate the student's academic record. For reporting, administrators may analyze rule assignments across the curriculum. Common SQL queries include identifying all units with a specific rule type or listing all rules attached to a particular unit.

  • Find all units that have a prerequisite rule defined: SELECT unit_cd FROM igs_ps_unit_ru WHERE s_rule_call_cd = 'PREREQ';
  • List all rule types for a specific unit 'MATH101': SELECT s_rule_call_cd FROM igs_ps_unit_ru WHERE unit_cd = 'MATH101';

Related Objects

The IGS_PS_UNIT_RU table sits at the intersection of unit definitions and rule logic. It is fundamentally related to the table storing the master list of units (likely named IGS_PS_UNIT or similar) via the UNIT_CD column. The S_RULE_CALL_CD column would typically have a foreign key relationship to a lookup table (e.g., IGS_LOOKUPS_VL) that defines the valid rule call codes and their meanings. Furthermore, the actual rule details and logic for a given S_RULE_CALL_CD and UNIT_CD combination are almost certainly stored in separate, related rule definition or rule detail tables. The primary key constraint IGS_PS_UNIT_RU_PK enforces data integrity for these relationships.