Search Results seo_class_cd




Overview
Explore in AI Chat

Overview

The IGS_RE_CAND_SEO_CLS table is a core data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically designed for the Oracle Student Management (Campus Solutions) or related research administration modules. It functions as a junction table that establishes and manages the formal links between a student's research candidature and one or more socio-economic objectives (SEO). This table is critical for tracking and reporting the alignment of academic research with broader economic and social goals, a common requirement for government funding bodies and institutional research reporting. Its role is to store the specific classification codes and the associated weighting of a candidature's effort against each objective.

Key Information Stored

The table stores the relationship between a candidature and its socio-economic classifications. The key columns include the composite primary key, which uniquely identifies each record: PERSON_ID and CA_SEQUENCE_NUMBER (together identifying the specific candidature) and SEO_CLASS_CD (the socio-economic objective code). The PERCENTAGE column is a crucial data point, quantifying the proportion of the research effort attributed to the linked objective. This allows a single candidature to be associated with multiple objectives, with the percentages typically summing to 100. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit and compliance purposes.

Common Use Cases and Queries

This table is central to generating reports on research funding and focus areas. Common use cases include reporting to external agencies on the distribution of research activity across socio-economic classifications, internal analysis of research trends, and validating candidature data for grant compliance. A typical query would join this table to the candidature and SEO code description tables to produce a readable report.

Sample Query: Retrieving all SEO classifications for a specific candidature with code descriptions.

SELECT cand.person_id,
       cand.ca_sequence_number,
       cls.seo_class_cd,
       seocode.description AS seo_description,
       cls.percentage
FROM igs.igs_re_cand_seo_cls cls
JOIN igs.igs_re_candidature_all cand ON cls.person_id = cand.person_id AND cls.ca_sequence_number = cand.sequence_number
JOIN igs.igs_re_seo_class_cd seocode ON cls.seo_class_cd = seocode.seo_class_cd
WHERE cand.person_id = :p_person_id
ORDER BY cls.percentage DESC;

Related Objects

The IGS_RE_CAND_SEO_CLS table is defined by its foreign key relationships, which are essential for data integrity and query construction. The documented relationships are:

  • Foreign Key to IGS_RE_CANDIDATURE_ALL: The PERSON_ID and CA_SEQUENCE_NUMBER columns reference the primary key of the IGS_RE_CANDIDATURE_ALL table. This ensures every SEO classification link is attached to a valid research candidature record.
  • Foreign Key to IGS_RE_SEO_CLASS_CD: The SEO_CLASS_CD column references the IGS_RE_SEO_CLASS_CD table. This validates that the socio-economic objective code used is a defined and active code within the system, typically providing a descriptive name and other metadata.

The table's primary key constraint (IGS_RE_CAND_SEO_CLS_PK) enforces the uniqueness of the combination of candidature and SEO code, preventing duplicate assignments.