Search Results igs_re_cdt_att_hist_all




Overview
Explore in AI Chat

Overview

The table IGS_RE_CDT_ATT_HIST_ALL is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for managing research student records. It serves as the historical repository for tracking the attendance patterns of a research student, or candidate, throughout the entire duration of their candidature. Its primary role is to provide a consolidated and auditable record that captures both the qualitative attendance type and the quantitative attendance percentage over time. This historical data is critical for academic administration, compliance reporting, and monitoring student progress within the research lifecycle in Oracle EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify a student's attendance record within the context of their specific candidature instance. The primary key is a composite of PERSON_ID, CA_SEQUENCE_NUMBER, and SEQUENCE_NUMBER. This combination links an attendance history entry to a specific person and their candidature record (via PERSON_ID and CA_SEQUENCE_NUMBER), while the SEQUENCE_NUMBER allows for multiple historical entries per candidature. The most significant data columns include ATTENDANCE_TYPE, which is a foreign key to a lookup of attendance classifications (e.g., full-time, part-time), and columns that store the associated attendance percentage. Together, these fields create a complete historical profile of a candidate's enrollment status.

Common Use Cases and Queries

This table is central to generating compliance and progress reports for research offices. A common use case is auditing a student's attendance history for a specific candidature period to verify continuous enrollment or a change in status. Another scenario involves reporting on the distribution of attendance types across a cohort of research students. A typical query would join this table to the candidature and person tables to retrieve a student's attendance timeline.

  • Sample Query Pattern: SELECT hist.sequence_number, hist.attendance_type, hist.attendance_percentage FROM igs_re_cdt_att_hist_all hist JOIN igs_re_candidature_all ca ON hist.person_id = ca.person_id AND hist.ca_sequence_number = ca.sequence_number WHERE ca.person_id = :p_person_id ORDER BY hist.sequence_number;
  • Reporting Use Case: Generating a list of all students whose attendance type changed from 'Full Time' to 'Part Time' within a given academic year.

Related Objects

The table maintains defined foreign key relationships with other critical tables in the Student System, ensuring referential integrity. These relationships are essential for accurate data retrieval and reporting.

  • IGS_RE_CANDIDATURE_ALL: This is the parent table for a student's candidature record. The relationship is established via the columns PERSON_ID and CA_SEQUENCE_NUMBER in IGS_RE_CDT_ATT_HIST_ALL, which reference the PERSON_ID and SEQUENCE_NUMBER in IGS_RE_CANDIDATURE_ALL. Every attendance history record must be associated with a valid candidature.
  • IGS_EN_ATD_TYPE_ALL: This table stores the valid lookup values for attendance types. The column IGS_RE_CDT_ATT_HIST_ALL.ATTENDANCE_TYPE is a foreign key to this table, ensuring that the recorded attendance type is from a controlled, predefined list.