Results for “igs_as_sua_ref_cds”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AS_SUA_REF_CDS is a table within the Oracle E-Business Suite IGS — Student System product family. Its documented description states that it stores Student Unit Attempt Reference Codes. In the higher-education data model, a "Student Unit Attempt" (SUA) records a student's enrollment attempt in a specific unit or course offering, and reference codes attached to that attempt capture externally or administratively meaningful classifications — for example, admission or entry pathway codes, government reporting references, or other coded attributes that qualify the attempt without altering its core academic record.

The table is documented as obsolete, and the ETRM metadata explicitly notes: "Not implemented in this database." This means the object should be treated as a legacy model definition rather than an actively populated table in a current 12.1.1 or 12.2.2 instance. Its continued value lies in understanding historical integrations, data migration mappings, and prior customizations that may still reference it.

From a data-modeling perspective, the mined foreign-key structure supports a heuristic Data Vault classification of link. The table resolves relationships among a person/student attempt, a course, a unit offering option, and a generic reference code — a classic associative pattern connecting multiple business keys rather than holding descriptive attributes of a single entity.

Key Information Stored

The surrogate primary key is SUAR_ID, enforced by the constraint IGS_AS_SUA_REF_CDS_PK. Because the user searched for suar_id, this is the column most likely to appear in join and lookup conditions. It is a system-generated identifier with no business meaning.

Business-key candidates are defined by the unique index IGS_AS_SUA_REF_CDS_U1, which spans PERSON_ID, COURSE_CD, UOO_ID, REFERENCE_CODE_ID, APPLIED_COURSE_CD, and DELETED_DATE. This composite effectively guarantees that a given student, course, unit offering option, and reference code combination is recorded only once for an active (non-deleted) row.

• SUAR_ID — surrogate primary key uniquely identifying each row.
• PERSON_ID — the student (person) associated with the unit attempt.
• COURSE_CD — the course or unit code for the attempt.
• UOO_ID — the unit offering option, identifying the specific delivery/offering instance.
• REFERENCE_CODE_ID — foreign key to the generic reference code definition.
• REFERENCE_CD_TYPE and REFERENCE_CD — denormalized type and value of the reference code as applied.
• APPLIED_COURSE_CD — the course against which the reference was applied, part of the unique business key.
• DELETED_DATE — soft-delete marker, also part of the unique key.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical usage centers on reconstructing which reference codes applied to a given student's unit attempt, and on joining attempt data to reference-code lookup values. A representative query retrieves reference codes for a person's attempts:

• SELECT suar.suar_id, suar.person_id, suar.course_cd, suar.reference_cd_type, suar.reference_cd FROM igs_as_sua_ref_cds suar WHERE suar.person_id = :person_id AND suar.deleted_date IS NULL;
• Join to the reference-code table to obtain descriptions: SELECT suar.suar_id, grc.description FROM igs_as_sua_ref_cds suar, igs_ge_ref_cd grc WHERE suar.reference_code_id = grc.reference_code_id;
• Locate a specific row by primary key: SELECT * FROM igs_as_sua_ref_cds WHERE suar_id = :suar_id;

Reporting scenarios include auditing applied reference codes per offering, migration validation when mapping legacy SUA reference data into current structures, and reconciliation against student attempt records.

Related Objects

The documented foreign keys and relationships identify the following significant related objects:

• IGS_GE_REF_CD — referenced via REFERENCE_CODE_ID; provides the catalog of generic reference codes and their descriptions.
• IGS_EN_SU_ATTEMPT_ALL — the student unit attempt table, joined on PERSON_ID, COURSE_CD, and UOO_ID; it is the primary parent for the attempt context.

Because the table is marked obsolete and not implemented, dependent views, APIs, and concurrent programs are unlikely to be active. Any remaining references should be verified against the specific 12.1.1 or 12.2.2 instance before relying on the object in custom code or reports.