Results for “ca_sequence_number”

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

Overview

The IGS_RE_CAND_SEO_CLS table resides in the IGS (Student System) product schema and represents the association between a candidature record and one or more Socio-Economic Objectives (SEO) classifications. In the terminology of the ETRM data model, this object functions as a classification or cross-reference table that links a research candidature to the socio-economic objective codes applicable to that candidature. The table is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2, and the ETRM metadata explicitly states "Not implemented in this database," indicating that the object is retained for historical or documentation purposes rather than active transactional use.

Applying a heuristic Data Vault classification based on the foreign key topology, IGS_RE_CAND_SEO_CLS is best modeled as a link entity. It resolves a many-to-many relationship between candidatures and socio-economic objective classifications, carrying no descriptive attributes of its own beyond the association and an optional weighting percentage. This classification is a modeling suggestion derived from the FK structure, not a directive from the ETRM documentation itself.

Key Information Stored

The table is documented with nine physical columns, of which a small subset carries meaningful business data. The most significant columns are:

• PERSON_ID — Identifies the person (student or candidate) associated with the candidature. Part of the composite primary key and a foreign key to IGS_RE_CANDIDATURE_ALL.
• CA_SEQUENCE_NUMBER — The candidature sequence number, distinguishing among multiple candidatures belonging to the same person. Part of the composite primary key and a foreign key to IGS_RE_CANDIDATURE_ALL.
• SEO_CLASS_CD — The socio-economic objective classification code assigned to the candidature. Part of the composite primary key and a foreign key to IGS_RE_SEO_CLASS_CD.
• PERCENTAGE — The proportional weight or percentage applied to the socio-economic objective for the candidature, allowing a candidature to distribute its classification across multiple objectives.

The documented primary key is IGS_RE_CAND_SEO_CLS_PK, comprising the three columns PERSON_ID, CA_SEQUENCE_NUMBER, and SEO_CLASS_CD. A unique index, IGS_RE_CAND_SEO_CLS_U1, is defined over the identical three-column combination, serving as the business-key candidate that enforces uniqueness of the candidature-to-objective association. The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are standard Oracle EBS who-columns providing audit and concurrency information.

Common Use Cases and Queries

Where the table is present or historically implemented, its principal use is to report on the socio-economic classification profile of research candidatures, supporting statutory reporting, funding analysis, and research-output categorisation. A typical query joining the candidature and classification tables would resemble:

• SELECT c.PERSON_ID, c.CA_SEQUENCE_NUMBER, c.SEO_CLASS_CD, c.PERCENTAGE FROM IGS_RE_CAND_SEO_CLS c WHERE c.CA_SEQUENCE_NUMBER = :ca_seq; — retrieving all objectives for a given candidature.
• SELECT s.SEO_CLASS_CD, COUNT(*) FROM IGS_RE_CAND_SEO_CLS s GROUP BY s.SEO_CLASS_CD; — distribution of candidatures across objective classifications.
• Joining to IGS_RE_CANDIDATURE_ALL on PERSON_ID and CA_SEQUENCE_NUMBER to combine classification data with candidature status and enrolment detail.

Reporting scenarios include cross-referencing objective codes with student cohorts, validating that the sum of PERCENTAGE values per candidature equals 100, and auditing objective assignments for research funding submissions.

Related Objects

The most significant related objects are those connected through the documented foreign keys, plus adjacent IGS research entities:

• IGS_RE_CANDIDATURE_ALL — Parent candidature view/table; joined on PERSON_ID and CA_SEQUENCE_NUMBER. This is the principal parent entity.
• IGS_RE_SEO_CLASS_CD — Parent classification reference table; joined on SEO_CLASS_CD, providing the objective description and hierarchy.
• IGS_RE_CAND_SEO_CLS_PK — The primary key constraint object itself, referenced by dependent constraints.
• IGS_RE_CAND_SEO_CLS_U1 — The unique index enforcing the business-key candidate over the same three columns.
• Related research entities such as IGS_RE_CANDIDATURE variants and socio-economic objective reference structures that share the SEO_CLASS_CD domain.

Because the object is obsolete and not implemented in the documented database, integrators should treat any residual dependencies as archival and avoid new development against it in Oracle EBS 12.1.1 or 12.2.2.