Results for “system_default”

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

Overview

The IGS_AD_CODE_CLASSES_V view is a reporting and integration object within the Oracle E-Business Suite IGS – Student System product, owned by the APPS schema and documented as VALID in ETRM 12.1.1 and 12.2.2. It is a denormalized, lookup-enriched presentation of the admissions code classes configuration held in the base table IGS_AD_CODE_CLASSES. Its primary role is to expose admissions code class definitions alongside human-readable lookup meanings, so that forms, concurrent programs, reports, and external integrations do not have to resolve the IGS_LOOKUP_VALUES table themselves. The view joins the code class row to IGS_LOOKUP_VALUES on two separate axes: first, to translate the CLASS column into a user-facing MEANING, and second, via a scalar DECODE subquery, to resolve SYSTEM_STATUS into a descriptive value exposed as the SYSTEM_STATUS_DESC column. This explains why a search for "system_status_desc" resolves to this object: SYSTEM_STATUS_DESC is the derived column in the view that most consumers query when they need the displayable status of an admissions code class.

Underlying Base Objects

The view text documents a two-table definition with an embedded scalar subquery. The first referenced object is IGS_AD_CODE_CLASSES (aliased CC), the driving table that stores code class records including CLASS, CODE_ID, NAME, DESCRIPTION, CLOSED_IND, SYSTEM_STATUS, SYSTEM_DEFAULT, and CLASS_TYPE_CODE. The second is IGS_LOOKUP_VALUES (aliased L1), joined where L1.LOOKUP_TYPE is either 'ADM_CODE_CLASSES' or 'IGS_AD_QUAL_TYPE' and L1.LOOKUP_CODE equals CC.CLASS, supplying the MEANING column. The SYSTEM_STATUS_DESC column is not a stored attribute; it is produced by a correlated DECODE subquery that selects L2.MEANING from IGS_LOOKUP_VALUES (aliased L2), where L2.LOOKUP_TYPE equals CC.CLASS and L2.LOOKUP_CODE equals CC.SYSTEM_STATUS. This means the status values must be registered as lookup values under the same lookup type as the code class itself. The ROW_ID column exposes CC.ROWID, and the standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are passed through unchanged. ETRM records no other referenced base objects.

Key Columns

• ROW_ID — the base table ROWID, useful for row identification and troubleshooting.
• CLASS — the code class identifier, matched against the lookup code.
• MEANING — the displayable description of the class, from IGS_LOOKUP_VALUES where LOOKUP_TYPE is 'ADM_CODE_CLASSES' or 'IGS_AD_QUAL_TYPE'.
• CODE_ID, NAME, DESCRIPTION — the code class identity and descriptive attributes.
• CLOSED_IND — indicates whether the code class is closed to new use.
• SYSTEM_STATUS — the stored status code.
• SYSTEM_STATUS_DESC — the translated status meaning derived from IGS_LOOKUP_VALUES.
• SYSTEM_DEFAULT — flags the default code class.
• CLASS_TYPE_CODE — categorizes the code class.

Common Use Cases and Queries

Typical consumers query the view to list admissions code classes with descriptive labels, to find the default class, or to report class status. A common query is:

SELECT class, meaning, system_status, system_status_desc, system_default FROM igs_ad_code_classes_v WHERE closed_ind = 'N' ORDER BY class;

Integrations extracting code class reference data select CLASS, CODE_ID, and SYSTEM_STATUS_DESC to build external code mappings, while troubleshooting queries filter on a specific class to inspect its status translation. Because the view already resolves both the class MEANING and SYSTEM_STATUS_DESC, it remains the preferred read-only access path over IGS_AD_CODE_CLASSES for status-aware reporting.