Search Results igs_en_su_attempt_all




Overview
Explore in AI Chat

Overview

The IGS_EN_SU_ATTEMPT_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) module for versions 12.1.1 and 12.2.2. It serves as the central repository for recording a student's attempt to study a specific unit (or course) offered by the institution. Each record represents an enrollment instance, capturing the administrative and academic context of that attempt. A key functional extension of this table, as noted in its description, is the capture of the Organizational unit code to support student finance requirements. As an `_ALL` table, it is designed to support the Multi-Org architecture, storing data partitioned by the `ORG_ID` column to facilitate operations across multiple business units or campuses.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which anchor it within the broader Student System schema. Two primary keys are documented, reflecting different granularities: one based on the unit offering components (`UNIT_CD`, `CAL_TYPE`, `CI_SEQUENCE_NUMBER`) and a more modern one utilizing the Unit Offering Option ID (`UOO_ID`). Essential columns include identifiers for the student (`PERSON_ID`), their academic program (`COURSE_CD`), and the specific unit attempt (`UNIT_CD`, `VERSION_NUMBER`, `UOO_ID`). It also stores critical calendar instance details (`CAL_TYPE`, `CI_SEQUENCE_NUMBER`, `CI_START_DT`, `CI_END_DT`), administrative status, assessment details like `EXAM_LOCATION_CD`, and financial attributes such as the Organizational unit code. The `RULE_WAIVED_PERSON_ID` column links to a party who may have authorized an exception to an academic rule.

Common Use Cases and Queries

This table is fundamental for enrollment reporting, academic auditing, and financial processing. Common operational and analytical queries include retrieving a student's current course load, generating class rosters, calculating tuition fees by organizational unit, and auditing enrollment history for academic standing reviews. A typical query to fetch a student's active unit attempts would join to the student's program attempt and the unit offering details.

  • Sample Query: SELECT sua.unit_cd, sua.unit_class, sua.administrative_unit_status, uoo.location_cd FROM igs_en_su_attempt_all sua JOIN igs_ps_unit_ofr_opt_all uoo ON sua.uoo_id = uoo.uoo_id WHERE sua.person_id = :stu_id AND sua.course_cd = :course_cd AND sua.cal_type = :term_code;
  • Financial Reporting: Aggregating enrollment counts by the captured Organizational unit code for internal chargebacks or budgeting.
  • Data Integrity: Validating that `ADMINISTRATIVE_UNIT_STATUS` values exist in the referenced `IGS_AD_ADM_UNIT_STAT_ALL` table.

Related Objects

The table maintains extensive foreign key relationships, integrating it with the foundation of the Student System. Key documented relationships include:

  • IGS_EN_STDNT_PS_ATT_ALL: Links the unit attempt to the student's broader program (course) attempt via `PERSON_ID` and `COURSE_CD`.
  • IGS_PS_UNIT_OFR_OPT_ALL (UOO_ID): The primary relationship to the specific offering option of the unit, defining its schedule, location, and mode.
  • IGS_CA_INST_ALL: References the calendar instance (`CAL_TYPE`, `CI_SEQUENCE_NUMBER`) governing the teaching period of the attempt.
  • IGS_AD_ADM_UNIT_STAT_ALL: Validates the `ADMINISTRATIVE_UNIT_STATUS` of the enrollment (e.g., ENROLLED, DROPPED).
  • HZ_PARTIES: Links the `RULE_WAIVED_PERSON_ID` to the person entity who authorized a waiver.
  • IGS_AS_ANON_ID_US: References this table's key columns (`PERSON_ID`, `COURSE_CD`, `UOO_ID`) for anonymous assessment identification purposes.