Results for “spcl_consideration_cat”

25 results




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

Overview

The IGS_AS_SPCL_CONS_CAT table is a reference (lookup) object within the Oracle E-Business Suite IGS — Student System product family. Its documented purpose is to describe the available categories of special consideration applications, providing the controlled vocabulary against which individual special consideration requests are classified. Such categories typically distinguish types of circumstances (for example, medical, compassionate, or extenuating academic situations) under which a student may apply for special consideration in assessment or examination processes.

The ETRM metadata records this object under the IGS — Student System (Obsolete) designation, and notes that it is not implemented in this database in the sampled 12.1.1 installation. This status is significant: the table is documented and carries a physical schema definition, but practitioners should confirm its existence and population before relying on it in a given environment. It is most relevant to historical or legacy EBS deployments where the Student System was actively used.

The metadata supplies a heuristic Data Vault classification of hub-leaning. In Data Vault modeling terms, this suggests treating the table as a hub: a stable set of unique business keys (SPCL_CONSIDERATION_CAT) that anchor descriptive attributes, which would conventionally be split into a satellite. This is offered as a modeling suggestion rather than a prescriptive design.

Key Information Stored

The physical schema documents nine columns owned by the IGS schema. The most important are:

  • SPCL_CONSIDERATION_CAT — The primary key column and the business-key candidate. It identifies each special consideration category and is also defined by the unique index IGS_AS_SPCL_CONS_CAT_U1.
  • DESCRIPTION — The human-readable name of the category, used in list-of-values displays and reports.
  • EXPLANATION — Supplementary narrative clarifying the scope or intended use of the category.
  • CLOSED_IND — A status flag indicating whether the category is closed (inactive) and therefore unavailable for new applications.
  • CREATED_BY, CREATION_DATE — Standard WHO audit columns capturing the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the most recent modification user, timestamp, and session login.

Notably, the documented metadata does not include a separate system-generated surrogate key column; the primary key IGS_AS_SPCL_CONS_CAT_PK is defined on the business-meaningful SPCL_CONSIDERATION_CAT column, which is reinforced by the unique index IGS_AS_SPCL_CONS_CAT_U1. The audit columns conform to the standard Oracle EBS WHO column convention and should not be treated as business attributes.

Common Use Cases and Queries

As a category lookup, this table is typically joined to the application table to resolve category descriptions for reporting and validation. A representative query lists active categories:

  • SELECT SPCL_CONSIDERATION_CAT, DESCRIPTION FROM IGS_AS_SPCL_CONS_CAT WHERE NVL(CLOSED_IND,'N') = 'N';
  • Resolution join: SELECT a.*, c.DESCRIPTION FROM IGS_AS_SPL_CONS_APPL a, IGS_AS_SPCL_CONS_CAT c WHERE a.SPCL_CONSIDERATION_CAT = c.SPCL_CONSIDERATION_CAT;

Reporting uses include counts of special consideration applications grouped by category, analysis of categories in use versus those closed, and validation of incoming application data against valid category codes.

Related Objects

The documented foreign key relationship identifies the principal dependent object:

  • IGS_AS_SPL_CONS_APPL — The special consideration application table. Its column SPCL_CONSIDERATION_CAT references IGS_AS_SPCL_CONS_CAT.SPCL_CONSIDERATION_CAT, making this the primary transactional consumer of the category definitions.

Beyond this documented relationship, category data is commonly consumed by Student System inquiry forms, list-of-values definitions, and reporting extracts built against the IGS schema. Administrators should verify implementation status in each environment, given the obsolete designation.