Results for “igs_re_seo_class_cd”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_RE_SEO_CLASS_CD table resides in the IGS schema, which supports the Oracle Student System (Student Administration) product within Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to store the institution's user-defined Socio-Economic Objective (SEO) classifications. These locally defined classifications must be mapped to one of the current government-defined SEO classifications, enabling institutions to model their own reporting taxonomy while still satisfying statutory reporting obligations. In practice, SEO data is used for equity, access, and participation reporting, and institutions frequently define sub-classifications that roll up to the official government codes.

The table carries a primary key constraint, IGS_RE_SEO_CLASS_CD_PK, defined over SEO_CLASS_CD. The same column is also the sole component of the unique index IGS_RE_SEO_CLASS_CD_U1, making it both the surrogate primary key and the natural business-key candidate. Based on the foreign key topology, the heuristic Data Vault classification for this object is satellite-leaning: it describes and qualifies a classification concept and references a government reference entity (IGS_RE_GV_SEO_CLS_CD via GOVT_SEO_CLASS_CD) rather than acting as a pure hub or a link between two independent hubs.

Key Information Stored

The documented physical schema contains nine columns. The most important are:

• SEO_CLASS_CD — The primary key and business key. Holds the institution-defined code that uniquely identifies each user-defined Socio-Economic Objective classification.
• GOVT_SEO_CLASS_CD — The foreign key to IGS_RE_GV_SEO_CLS_CD. Maps each user-defined classification onto a current government SEO classification, ensuring statutory reporting alignment.
• DESCRIPTION — The descriptive text presented to users when selecting an SEO classification for a candidate or applicant record.
• CLOSED_IND — A status flag indicating whether the classification is closed and therefore unavailable for new assignments, while remaining valid for historical records.
• CREATED_BY, CREATION_DATE — Standard EBS WHO columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns capturing the most recent change and its originating login.

The distinction between SEO_CLASS_CD and GOVT_SEO_CLASS_CD is central: the former is the institution's own identifier, while the latter is the government-mandated identifier to which it is bound by foreign key.

Common Use Cases and Queries

Typical scenarios include validating that all active user-defined classifications map to a valid government code, and reporting SEO distributions across applicants and candidates. A representative query joining to the government classification reference table:

• SELECT c.SEO_CLASS_CD, c.DESCRIPTION, c.GOVT_SEO_CLASS_CD, g.DESCRIPTION
FROM IGS_RE_SEO_CLASS_CD c, IGS_RE_GV_SEO_CLS_CD g
WHERE c.GOVT_SEO_CLASS_CD = g.GOVT_SEO_CLASS_CD
AND c.CLOSED_IND = 'N';

To identify unmapped or orphaned classifications, an outer join from IGS_RE_SEO_CLASS_CD to IGS_RE_GV_SEO_CLS_CD reveals rows whose GOVT_SEO_CLASS_CD does not resolve. For audit purposes, querying by LAST_UPDATE_DATE and LAST_UPDATED_BY supports change-tracking extracts. Because assignment data resides in IGS_RE_CAND_SEO_CLS, reporting on recorded SEO values requires joining that table to this one on SEO_CLASS_CD.

Related Objects

• IGS_RE_GV_SEO_CLS_CD — The government SEO classification reference table. Joined via GOVT_SEO_CLASS_CD; this table's FK target.
• IGS_RE_CAND_SEO_CLS — The candidate/applicant SEO assignment table. References IGS_RE_SEO_CLASS_CD through SEO_CLASS_CD, linking recorded SEO values to the defined classifications.
• IGS_RE_SEO_CLASS_CD_PK — The primary key constraint over SEO_CLASS_CD.
• IGS_RE_SEO_CLASS_CD_U1 — The unique index over SEO_CLASS_CD, confirming the business key.

Together, these objects form the SEO classification and assignment model within the Student System, with this table acting as the institution-defined control point mapped to government standards.