Results for “igs_as_su_setatmpt_pk”

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

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.

• PERSON_ID – identifies the student making the attempt.
• COURSE_CD – the course to which the unit set belongs.
• UNIT_SET_CD and US_VERSION_NUMBER – the program unit set and its version.
• SEQUENCE_NUMBER – distinguishes multiple attempts at the same unit set.
• SELECTION_DT – date the student selected the unit set.
• STUDENT_CONFIRMED_IND and PRIMARY_SET_IND – flags for confirmation and primary-set designation.
• END_DT and VOLUNTARY_END_IND – termination date and voluntary-withdrawal flag.
• RQRMNTS_COMPLETE_IND and RQRMNTS_COMPLETE_DT – requirements-completion status and date.
• PARENT_UNIT_SET_CD and PARENT_SEQUENCE_NUMBER – hierarchical linkage to a parent attempt (self-referencing FK).
• AUTHORISED_PERSON_ID, AUTHORISED_ON, OVERRIDE_TITLE – administrative overrides.
• CATALOG_CAL_TYPE and CATALOG_SEQ_NUM – calendar linkage to IGS_CA_INST_ALL.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) and twenty ATTRIBUTE columns for extensibility.

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.