Search Results igs_as_sua_ref_cds




Overview
Explore in AI Chat

Overview

The IGS_AS_SUA_REF_CDS table is a core data repository within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It functions as a junction table, establishing and storing the relationships between Student Unit Attempts (SUAs) and various reference codes. Its primary role is to associate a student's enrollment in a specific unit offering with standardized, system-defined reference data. This design enables the flexible tagging of unit attempts with multiple classifications or attributes, supporting complex academic rules, reporting, and administrative processes within the institution's student lifecycle management.

Key Information Stored

The table's structure is centered on linking identifiers from two primary entities. The key columns include the surrogate primary key SUAR_ID. The foreign key columns PERSON_ID, COURSE_CD, and UOO_ID collectively identify the specific Student Unit Attempt record in the IGS_EN_SU_ATTEMPT_ALL table. The column REFERENCE_CODE_ID stores a foreign key to the IGS_GE_REF_CD table, which holds the master list of valid reference codes. This relationship allows a single unit attempt to be associated with multiple reference codes, each stored as a distinct record in IGS_AS_SUA_REF_CDS.

Common Use Cases and Queries

This table is essential for queries and reports that need to filter or categorize student academic records based on attached reference codes. Common scenarios include identifying all unit attempts marked with a specific attribute, such as a particular assessment type, funding source, or academic status reason. A typical reporting query would join this table to the student unit attempt and reference code master tables.

  • Sample Query Pattern: To retrieve students and their units associated with a specific reference code value, a developer might use: SELECT sua.person_id, sua.unit_cd FROM igs_as_sua_ref_cds refcd JOIN igs_en_su_attempt_all sua ON (refcd.person_id = sua.person_id AND refcd.course_cd = sua.course_cd AND refcd.uoo_id = sua.uoo_id) JOIN igs_ge_ref_cd rc ON (refcd.reference_code_id = rc.reference_code_id) WHERE rc.reference_code = 'SPECIFIC_CODE';
  • It is also critical for data validation and integrity checks when processing unit enrollments, ensuring that only permitted reference codes are attached to an attempt.

Related Objects

The IGS_AS_SUA_REF_CDS table is centrally connected within the Student System schema through defined foreign key relationships. It is a child table to both the student unit attempt master and the generic reference code master.

  • IGS_EN_SU_ATTEMPT_ALL: This is the primary parent table. IGS_AS_SUA_REF_CDS references it via the composite foreign key on PERSON_ID, COURSE_CD, and UOO_ID. This enforces that a reference code can only be linked to a valid, existing unit attempt.
  • IGS_GE_REF_CD: This is the reference code master table. IGS_AS_SUA_REF_CDS references it via the REFERENCE_CODE_ID column, ensuring data integrity by allowing only codes defined in the central repository to be assigned.
  • The table's own primary key, IGS_AS_SUA_REF_CDS_PK on the SUAR_ID column, may be referenced by other application objects or custom extensions for building more complex data relationships.