Search Results igs_re_cand_seo_cls

Overview

The table IGS_RE_CAND_SEO_CLS is a data entity within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically designed to manage research-related information. As indicated by its description, this table establishes and stores the links between a research candidature and one or more Socio-Economic Objectives (SEO). These objectives typically classify research activities based on their intended economic, social, or environmental outcomes, which is critical for government reporting, funding attribution, and institutional research analytics. It is important to note that the provided ETRM metadata explicitly classifies the IGS - Student System as "Obsolete" and states this table was "Not implemented in this database," suggesting it was part of a defined data model that may not have been deployed in all instances or has been superseded in later releases.

Key Information Stored

The table's structure is defined by a composite primary key, which precisely identifies each unique candidature-SEO link. The key columns are PERSON_ID, which identifies the student or researcher; CA_SEQUENCE_NUMBER, which uniquely identifies a specific candidature period for that person; and SEO_CLASS_CD, the code for the linked Socio-Economic Objective. This design allows a single candidature to be associated with multiple SEO codes. The table primarily serves as a junction or intersection table, with its core purpose being to maintain these many-to-many relationships between candidatures and SEO classifications.

Common Use Cases and Queries

The primary use case for this table is reporting and compliance. Institutions would query it to analyze the distribution of research efforts across different socio-economic areas, often required for government funding bodies or internal strategic reviews. A typical query would join this table to the candidature and SEO code description tables to produce a meaningful report. For example, to list all SEOs for a specific candidate, one might use a SQL pattern such as: SELECT seo.SEO_CLASS_CD, seo.DESCRIPTION FROM IGS_RE_CAND_SEO_CLS cls JOIN IGS_RE_SEO_CLASS_CD seo ON cls.SEO_CLASS_CD = seo.SEO_CLASS_CD WHERE cls.PERSON_ID = :p_person_id AND cls.CA_SEQUENCE_NUMBER = :p_ca_sequence;. Another common use would be aggregate reporting to count candidatures per SEO classification across the institution.

Related Objects

IGS_RE_CAND_SEO_CLS is centrally connected to two primary tables via foreign key constraints, as documented in the ETRM metadata. The relationships are as follows:

• IGS_RE_CANDIDATURE_ALL: This is the master table for research candidature information. The foreign key from IGS_RE_CAND_SEO_CLS references it using the composite of PERSON_ID and CA_SEQUENCE_NUMBER. This ensures every SEO link is attached to a valid, existing candidature record.
• IGS_RE_SEO_CLASS_CD: This is the reference code table containing the valid list of Socio-Economic Objective codes and their descriptions. The foreign key on the SEO_CLASS_CD column ensures that only predefined, valid SEO codes can be assigned to a candidature.

The table itself is defined by its primary key constraint, IGS_RE_CAND_SEO_CLS_PK, on the columns (PERSON_ID, CA_SEQUENCE_NUMBER, SEO_CLASS_CD).