Search Results igs_re_seo_class_cd




Overview
Explore in AI Chat

Overview

The table IGS_RE_SEO_CLASS_CD is a data structure within the Oracle E-Business Suite (EBS) Student System (IGS), specifically noted as obsolete. It serves as a repository for user-defined Socio-Economic Objective (SEO) classifications. Its primary role is to act as a mapping layer, allowing institutions to define their internal research classification codes while maintaining a mandatory link to the standardized government classifications. This design ensures that internal reporting can be reconciled with external government reporting requirements for research activities. The table's status as obsolete indicates it is part of a legacy data model that may be deprecated or replaced in more recent versions or implementations of the EBS Student System.

Key Information Stored

The table's central purpose is to store the mapping between a user-defined code and its corresponding government standard. The primary key column, SEO_CLASS_CD, uniquely identifies each user-defined classification code. A critical foreign key column, GOVT_SEO_CLASS_CD, holds the reference to the official government Socio-Economic Objective code as defined in the related IGS_RE_GV_SEO_CLS_CD table. This enforces the documented requirement that every user-defined classification "must be mapped onto one the current government classifications." While other descriptive columns likely exist (e.g., a description or enabled flag), the provided metadata explicitly confirms these two core columns that establish the table's identity and its essential referential integrity.

Common Use Cases and Queries

The primary use case involves reporting and validating research candidate data against socio-economic objectives. Administrators would query this table to review or maintain the institution-specific SEO codes and their government equivalents. A typical query would join this table to the government standard table to produce a mapping report for audit purposes. For example: SELECT usr.SEO_CLASS_CD, usr.DESCRIPTION, gov.GOVT_SEO_CLASS_CD, gov.DESCRIPTION FROM IGS_RE_SEO_CLASS_CD usr JOIN IGS_RE_GV_SEO_CLS_CD gov ON usr.GOVT_SEO_CLASS_CD = gov.GOVT_SEO_CLASS_CD; Another common operation is validating data integrity for candidates, ensuring that any candidate-assigned SEO code (IGS_RE_CAND_SEO_CLS) has a valid entry in this mapping table. Given the object's obsolete status, a critical use case in upgrades or migrations would involve analyzing data in this table to plan for transition to a successor data model.

Related Objects

The table participates in specific foreign key relationships, as documented in the ETRM metadata.

  • References (Outgoing FK): IGS_RE_SEO_CLASS_CD.GOVT_SEO_CLASS_CD references the IGS_RE_GV_SEO_CLS_CD table. This links each user-defined code to a valid government standard code.
  • Referenced By (Incoming FK): The SEO_CLASS_CD column is referenced by the IGS_RE_CAND_SEO_CLS table (via its SEO_CLASS_CD column). This indicates that research candidates are assigned a user-defined SEO classification from this table.
These relationships form a small but critical data chain: Government Standard (IGS_RE_GV_SEO_CLS_CD) ← User Mapping (IGS_RE_SEO_CLASS_CD) → Candidate Assignment (IGS_RE_CAND_SEO_CLS).