Search Results igs_re_candidature_all




Overview
Explore in AI Chat

Overview

The IGS_RE_CANDIDATURE_ALL table is a core entity within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for managing research education. It serves as the master repository for the candidature details of a research student, representing their formal enrollment and progression within a higher degree by research (HDR) program. This table is critical for tracking the lifecycle of a research student from admission through to completion, linking academic, supervisory, and administrative data. As an "ALL" table, it is designed to support the multi-org architecture of Oracle EBS, storing data partitioned by the SET_OF_BOOKS_ID or ORG_ID, which is a standard pattern in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is a composite of PERSON_ID and SEQUENCE_NUMBER, indicating that a single person (student) can have multiple candidature records, typically for different research programs or stages. While the provided metadata does not list all columns, the foreign key relationships and standard practice imply it stores essential attributes such as the candidature start and end dates, current status, associated research course code, and admission application details. Key foreign key columns include SCA_COURSE_CD (linking to the student's course attempt) and a set of columns prefixed with ACAI_ (linking to the original admission application instance). These links integrate the research candidature with the broader student admissions and enrollment framework.

Common Use Cases and Queries

This table is central to reporting and processes in research administration. Common use cases include generating lists of active research candidates, tracking candidature milestones and submission dates, and managing supervisory panels. A typical query might join to person and course tables to create a candidate dashboard. For example, to find active research students and their associated course of study, a query would pattern:

  • SELECT ca.person_id, p.party_name, ca.sca_course_cd, s.version_name FROM igs_re_candidature_all ca JOIN hz_parties p ON ca.person_id = p.party_id JOIN igs_en_stdnt_ps_att_all s ON ca.person_id = s.person_id AND ca.sca_course_cd = s.course_cd WHERE ca.candidature_status = 'ACTIVE';

Data from this table also feeds into processes for scholarship allocation, thesis submission tracking, and compliance reporting for research training.

Related Objects

The IGS_RE_CANDIDATURE_ALL table sits at the center of a network of related entities, as evidenced by its foreign key relationships. Key documented dependencies include:

These relationships enforce data integrity and create a comprehensive model where the candidature record is the anchor for a student's entire research profile.