Search Results igs_as_su_setatmpt




Overview
Explore in AI Chat

Overview

IGS_AS_SU_SETATMPT is a table within the Oracle E-Business Suite Student System (IGS) product family, historically delivered under the Advanced Studies (AS) sub-module. It records a student's attempt at completing a program unit set — a structured grouping of course units that a learner must satisfy as part of an academic program. Each row captures the intersection of a student, a course, a unit set, and a specific attempt sequence, including lifecycle indicators such as confirmation, completion, and voluntary termination.

The object is classified in the source metadata as Obsolete for both Oracle EBS 12.1.1 and 12.2.2, and is documented as "Not implemented in this database." This is significant: while the physical schema, keys, and column definitions are preserved in ETRM documentation, the table is not part of a functioning EBS 12.1.1 or 12.2.2 installation. It persists as a legacy artefact of the earlier Student System data model, which was superseded by Oracle Student Cloud and related products. From a Data Vault modelling perspective, the heuristic classification is satellite-leaning, reflecting the table's role as a descriptive record attached to student/program-unit-set business keys rather than a pure hub or link.

Key Information Stored

The table carries 50 documented columns. The primary key, IGS_AS_SU_SETATMPT_PK, is composed of PERSON_ID, COURSE_CD, UNIT_SET_CD, and SEQUENCE_NUMBER. A unique index (IGS_AS_SU_SETATMPT_U1) enforces the same four-column combination, confirming it as the business-key candidate.

Common Use Cases and Queries

Because the table is obsolete, reporting use cases are largely historical or migration-oriented. Typical patterns include reconciling legacy student progress data during an upgrade, or extracting unit-set attempt histories for archival analysis.

  • Listing all attempts for a student:
SELECT person_id, course_cd, unit_set_cd, sequence_number,
       selection_dt, rqrmnts_complete_ind, end_dt
  FROM igs_as_su_setatmpt
 WHERE person_id = :p_person_id
 ORDER BY selection_dt DESC;
  • Identifying incomplete primary sets for a cohort:
SELECT person_id, unit_set_cd, selection_dt
  FROM igs_as_su_setatmpt
 WHERE primary_set_ind = 'Y'
   AND (rqrmnts_complete_ind IS NULL OR rqrmnts_complete_ind = 'N')
   AND end_dt IS NULL;
  • Tracing parent-child attempt hierarchies using the self-referencing FK on PERSON_ID, COURSE_CD, PARENT_UNIT_SET_CD, and PARENT_SEQUENCE_NUMBER.

Related Objects

Foreign key relationships identify the principal objects that this table depends upon or that depend upon it:

  • IGS_CA_INST_ALL – joined via CATALOG_CAL_TYPE and CATALOG_SEQ_NUM for calendar instance context.
  • IGS_EN_STDNT_PS_ATT_ALL – joined via PERSON_ID for student program-attempt data.
  • IGS_EN_UNIT_SET_ALL – joined via UNIT_SET_CD and US_VERSION_NUMBER for unit set definitions.
  • IGS_AS_SU_SETATMPT – self-referencing via PERSON_ID, COURSE_CD, PARENT_UNIT_SET_CD, PARENT_SEQUENCE_NUMBER for parent attempts.
  • IGS_HE_EN_SUSA – references this table via PERSON_ID, COURSE_CD, UNIT_SET_CD, and SEQUENCE_NUMBER, forming a dependent downstream relationship.

Together these relationships confirm the table's position as a detail-level satellite of student program-attempt activity within the legacy Student System schema.