Search Results progression_status




Overview
Explore in AI Chat

Overview

The IGS_AS_GPC_ACA_STNDG_V view belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module now classified as obsolete in release 12.1.1 and 12.2.2. Functionally, the view exposes Advance Standing Information for a progression, presenting records that describe the standing awarded to a student in relation to an academic progression associated with a grading period. It acts as a reporting and integration façade over the underlying Advance Standing table, translating the stored progression status code into a human-readable description through a lookup join.

Because IGS is obsolete and the view is not implemented in the reference database, it is primarily encountered in legacy schemas, historical data migrations, and read-only reporting against archived Student System installations. Its principal role is to simplify downstream queries: consumers do not need to know the lookup type or join IGS_LOOKUPS_VIEW themselves, since the view already decodes PROGRESSION_STATUS into PROGRESSION_STATUS_DESC.

Underlying Base Objects

The view text is defined as a two-table join:

  • IGS_AS_GPC_ACA_STNDG ACA — the primary Advance Standing table holding the progression and grading period data. The view selects ACA.ROWID as ROW_ID plus all business and audit columns from this table.
  • IGS_LOOKUPS_VIEW LKUP — the standard lookup view, joined on LKUP.LOOKUP_CODE = ACA.PROGRESSION_STATUS and constrained to LKUP.LOOKUP_TYPE = 'PROGRESSION_STATUS'. This provides the decoded meaning exposed as PROGRESSION_STATUS_DESC.

No base objects are documented for the 12.2.2 metadata (referenced base objects: none documented), and the object carries no documented owner. The authoritative definition therefore remains the view text itself, which confirms IGS_AS_GPC_ACA_STNDG and IGS_LOOKUPS_VIEW as the effective sources. The join is effectively an equijoin filtered by the lookup type, meaning any progression status code without a matching 'PROGRESSION_STATUS' lookup row is excluded from the result set.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_AS_GPC_ACA_STNDG row; useful for row identification in extracts.
  • GPC_ACA_STNDG_ID — primary key of the advance standing record.
  • GRADING_PERIOD_CD — the grading period code to which the standing applies.
  • PROGRESSION_STATUS — coded status value stored on the base record.
  • PROGRESSION_STATUS_DESC — decoded meaning of the status, sourced from IGS_LOOKUPS_VIEW.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle audit columns describing record creation and maintenance.

Common Use Cases and Queries

Typical usage involves extracting advance standing outcomes per grading period, validating that status codes have valid lookup definitions, or feeding progression data into integration interfaces and reports.

Sample query returning standings for a specific grading period:

SELECT GPC_ACA_STNDG_ID,
       GRADING_PERIOD_CD,
       PROGRESSION_STATUS,
       PROGRESSION_STATUS_DESC
FROM   IGS_AS_GPC_ACA_STNDG_V
WHERE  GRADING_PERIOD_CD = :grading_period
ORDER  BY GPC_ACA_STNDG_ID;

A second common scenario audits status distribution across grading periods, aggregating by the decoded description:

SELECT GRADING_PERIOD_CD,
       PROGRESSION_STATUS_DESC,
       COUNT(*) cnt
FROM   IGS_AS_GPC_ACA_STNDG_V
GROUP  BY GRADING_PERIOD_CD, PROGRESSION_STATUS_DESC;

Because the view enforces the lookup join internally, records with unmapped progression status codes will not appear; reconciliation queries against the base table IGS_AS_GPC_ACA_STNDG should be used where completeness is required.