Search Results igs_as_sua_ses_atts_n1

Overview

The IGS_AS_SUA_SES_ATTS table is a core transactional data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product. Owned by the IGS schema, its primary function is to store granular student attendance records. It captures attendance for a specific student unit attempt against a defined academic session, forming a critical link between a student's enrollment in a unit section and their participation in scheduled instructional events. This table supports attendance tracking, compliance reporting, and academic performance monitoring within the institution.

Key Information Stored

The table's structure is designed to uniquely identify a student's attendance event and record its status. Key columns include the composite foreign key from the Student Unit Attempt (SUA) table—PERSON_ID, COURSE_CD, and UOO_ID—which identifies the specific enrollment. The SESSION_NAME column (VARCHAR2(90)) is a mandatory field that identifies the particular academic session, lecture, or tutorial for which attendance is being recorded. The ATTENDANCE_FLAG holds the attendance status with valid values of 'Y' (Yes/Attended), 'N' (No/Not Attended), and 'O' (Other/Excused). Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) are also present for audit purposes.

Common Use Cases and Queries

A primary use case is generating attendance reports for a specific session or unit. Administrators can query this table to identify students who did not attend a mandatory session or to calculate aggregate attendance percentages. The table's indexes, particularly IGS_AS_SUA_SES_ATTS_N1 on (PERSON_ID, SESSION_NAME) and IGS_AS_SUA_SES_ATTS_N3 on (SESSION_NAME, UOO_ID), are optimized for such lookups. Common SQL patterns include retrieving attendance for a given session or summarizing attendance by student.

• Attendance for a Specific Session: SELECT PERSON_ID, ATTENDANCE_FLAG FROM IGS.IGS_AS_SUA_SES_ATTS WHERE SESSION_NAME = '&SESSION_NAME';
• Student's Attendance Across Sessions in a Unit: SELECT SESSION_NAME, ATTENDANCE_FLAG FROM IGS.IGS_AS_SUA_SES_ATTS WHERE PERSON_ID = &STUDENT_ID AND UOO_ID = &UOO_ID ORDER BY SESSION_NAME;
• Count of Attendees per Session: SELECT SESSION_NAME, COUNT(*) ATTENDEE_COUNT FROM IGS.IGS_AS_SUA_SES_ATTS WHERE ATTENDANCE_FLAG = 'Y' GROUP BY SESSION_NAME;

Related Objects

As indicated by its foreign key columns, this table has a fundamental dependency on the Student Unit Attempt (SUA) table, which is not explicitly named in the provided metadata but is central to OSM. The table is referenced by the APPS synonym IGS_AS_SUA_SES_ATTS, which is the standard access point for all application code and reports. While the dependency list states it does not reference other objects, it is logically a child table of the SUA entity. Its data is likely accessed and maintained through dedicated OSM application forms and APIs for managing class attendance.