Search Results igs_re_cdt_fld_of_sy




Overview
Explore in AI Chat

Overview

The table IGS_RE_CDT_FLD_OF_SY is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for managing research candidatures. It functions as a junction table that establishes and stores the formal academic linkage between a research candidate and their declared field(s) of study. This table is critical for accurately representing complex research profiles, as it supports scenarios where a single candidature may be associated with multiple fields of study, with the involvement in each field potentially defined by a specific percentage allocation. Its existence enables the system to model interdisciplinary research and track the precise academic focus areas for higher-degree research students across both Oracle EBS 12.1.1 and 12.2.2 implementations.

Key Information Stored

The table's structure is defined by a composite primary key and columns that facilitate its relationships. The primary key itself consists of three columns: PERSON_ID, which uniquely identifies the student; CA_SEQUENCE_NUMBER, which distinguishes between multiple candidature records for the same person; and FIELD_OF_STUDY, which is the code for the specific academic discipline. This three-part key ensures that each unique combination of candidate, candidature instance, and field is recorded only once. While the provided metadata explicitly lists these key columns, it is implied that additional attributes exist to store the associated percentage split for each field of study link, operational dates (such as effective start and end dates), and standard WHO columns (CREATED_BY, CREATION_DATE, etc.) for auditability.

Common Use Cases and Queries

A primary use case is generating academic reports and transcripts that detail the formal research components of a candidate's program. Administrators use this data to verify compliance with program requirements regarding field specialization. A common reporting query involves joining this table to the candidature and field of study master tables to produce a clean list. For example:

  • To list all fields of study for a specific candidature: SELECT cfos.*, fos.TITLE FROM IGS_RE_CDT_FLD_OF_SY cfos JOIN IGS_PS_FLD_OF_STUDY_ALL fos ON cfos.FIELD_OF_STUDY = fos.FIELD_OF_STUDY WHERE cfos.PERSON_ID = :p_person_id AND cfos.CA_SEQUENCE_NUMBER = :p_ca_sequence;
  • To analyze the distribution of candidates across different fields of study for institutional research planning.
  • To serve as a validation point when creating or updating a research candidature, ensuring that the total percentage allocation across all linked fields does not exceed 100%.

Related Objects

The IGS_RE_CDT_FLD_OF_SY table sits at the intersection of two major master tables, as defined by its foreign key constraints. It has a mandatory relationship to the research candidature header table, ensuring every field-of-study link is attached to a valid candidature record. It also has a mandatory relationship to the field of study definition table, guaranteeing referential integrity for the academic discipline code.

  • IGS_RE_CANDIDATURE_ALL: This is the parent table for the research candidature entity. The foreign key is defined on the columns PERSON_ID and CA_SEQUENCE_NUMBER. This relationship ensures that every record in IGS_RE_CDT_FLD_OF_SY is associated with an active candidature.
  • IGS_PS_FLD_OF_STUDY_ALL: This is the master table defining all valid academic fields of study. The foreign key is defined on the column FIELD_OF_STUDY. This relationship ensures that the field code linked to a candidature is a recognized and active discipline within the institution's academic catalog.