Search Results igs_as_sua_ses_atts




Overview
Explore in AI Chat

Overview

The IGS_AS_SUA_SES_ATTS table is a core data object within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves the critical function of recording and storing student attendance data at a granular level. Specifically, it captures attendance records for an individual student's attempt at a specific unit (or subject) against a particular scheduled session, such as a lecture, tutorial, or laboratory class. This table is essential for institutions that mandate or track attendance as part of academic compliance, student engagement monitoring, or course completion requirements. Its existence directly supports the operational and reporting needs of academic administration.

Key Information Stored

The table's structure is designed to uniquely identify a student's attendance event by linking it to the student, their course, the unit attempt, and the specific session. The primary key columns define this unique relationship: PERSON_ID identifies the student, COURSE_CD identifies the academic program, and UOO_ID (Unit Offering Option ID) identifies the specific instance of the unit being attempted. The SESSION_NAME identifies the particular scheduled event within that unit offering. While the provided metadata focuses on these key identifiers, a fully implemented table would typically include additional columns to store the actual attendance record, such as an attendance status (e.g., 'Present', 'Absent', 'Late'), a recorded date, and audit columns like CREATION_DATE and LAST_UPDATE_DATE.

Common Use Cases and Queries

This table is central to attendance-related processes. Common use cases include generating class rosters with attendance marks, calculating overall attendance percentages for a student in a unit, identifying students falling below required attendance thresholds, and populating official academic transcripts or reports that include attendance data. A typical reporting query would join this table to student and unit dimension tables. For example, to list attendance for a specific session, one might use: SELECT sua.person_id, sua.session_name, sua.attendance_status FROM igs_as_sua_ses_atts sua WHERE sua.uoo_id = :p_uoo_id AND sua.session_name = :p_session_name; Another common pattern is aggregating data to find a student's total attendance rate for a unit attempt by counting present records against the total number of sessions.

Related Objects

The IGS_AS_SUA_SES_ATTS table maintains defined foreign key relationships with other critical Student System tables, ensuring referential integrity. As per the provided metadata, it is directly linked to two primary entities:

  • IGS_AS_USEC_SESSNS: This relationship validates that the session (SESSION_NAME) exists for the given unit offering (UOO_ID). The join is on the columns IGS_AS_SUA_SES_ATTS.UOO_ID and IGS_AS_SUA_SES_ATTS.SESSION_NAME.
  • IGS_EN_SU_ATTEMPT_ALL: This is a fundamental relationship that ties the attendance record to the core student unit attempt. It ensures the attendance is recorded for a valid combination of student (PERSON_ID), course (COURSE_CD), and unit attempt (UOO_ID). The join uses all three primary key columns: PERSON_ID, COURSE_CD, and UOO_ID.
These relationships are crucial for any data extraction or integration, as they define the correct path to join attendance data with student demographic, course, and unit offering information.

  • Table: IGS_AS_SUA_SES_ATTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_SUA_SES_ATTS,  object_name:IGS_AS_SUA_SES_ATTS,  status:VALID,  product: IGS - Student System ,  description: Stores the attendance for the student's unit attempt against the session. ,  implementation_dba_data: IGS.IGS_AS_SUA_SES_ATTS , 

  • Table: IGS_AS_USEC_SESSNS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_USEC_SESSNS,  object_name:IGS_AS_USEC_SESSNS,  status:VALID,  product: IGS - Student System ,  description: New table to store Unit Section Session details ,  implementation_dba_data: IGS.IGS_AS_USEC_SESSNS , 

  • View: IGS_AS_SUA_SES_ATTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_SUA_SES_ATTS_V,  object_name:IGS_AS_SUA_SES_ATTS_V,  status:VALID,  product: IGS - Student System ,  description: This view defines the student's attendance for a placement session. ,  implementation_dba_data: APPS.IGS_AS_SUA_SES_ATTS_V , 

  • Table: IGS_EN_SU_ATTEMPT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_SU_ATTEMPT_ALL,  object_name:IGS_EN_SU_ATTEMPT_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a student's attempt at studying a particular unit offered by the university. This table is modified to capture the Organizational unit code for the student finance requirements. ,  implementation_dba_data: IGS.IGS_EN_SU_ATTEMPT_ALL ,