Search Results core_curriculum_value




Overview
Explore in AI Chat

Overview

IGS_AD_TRANSCRIPT_V is a query-only view in the Oracle E-Business Suite student system schema (APPS) that presents admission transcript data recorded against an applicant's education record. Its principal role is to denormalize the raw IGS_AD_TRANSCRIPT table by resolving foreign-key lookups into human-readable descriptions before the data reaches reports, concurrent programs, self-service pages, and integration extracts. The view exposes one row per admission transcript, identified by TRANSCRIPT_ID, and surfaces the admission statistics that institutions capture when receiving an external academic record: rank in class, class size, percentile and related positional measures, and entering and converted grade point averages.

Because several of the most frequently referenced attributes are stored as coded values, the view joins IGS_LOOKUPS_VIEW three times (aliased L1, L2, L3) and IGS_AD_CODE_CLASSES three times (aliased CC1, CC2, CC3). This resolved-meaning pattern makes the view particularly convenient for reporting tools and interfaces that expect display text rather than internal codes. The view text includes the ROW_ID pseudo-column derived from T.ROWID, supporting the standard Oracle Forms/ADF updatable-block convention even though the view itself is not inherently updatable. In 12.1.1 and 12.2.2 the definition and column set are documented as identical; the object is a standard component of the Oracle Student System admissions data model.

Underlying Base Objects

The view is defined over six referenced objects, all in the APPS schema.

  • IGS_AD_TRANSCRIPT (alias T) — the driving base table holding admission transcript records for each education record.
  • IGS_LOOKUPS_VIEW (aliases L1, L2, L3) — joined on TRANSCRIPT_STATUS / 'TRANSCRIPT_STATUS', TERM_TYPE / 'TERM_TYPE', and TRANSCRIPT_TYPE / 'TRANSCRIPT_TYPE' to return the MEANING column for each lookup.
  • IGS_AD_CODE_CLASSES (aliases CC1, CC2, CC3) — a generic code-class table joined on CODE_ID to resolve ENTERED_GS_ID, CONV_GS_ID, and TRANSCRIPT_SOURCE into grading-scale and source names via the NAME column.

All joins are inner joins on equality predicates, so a transcript row is returned only when the corresponding lookup meaning and code-class name exist. The documented ETRM metadata records no additional base objects beyond these six.

Key Columns

Common Use Cases and Queries

Typical uses include admission evaluation reports, transcript data extracts to data warehouses, grading-scale conversion validation, and equality checks against applicant-supplied statistics.

To retrieve the core curriculum value for all transcripts of a given applicant:

  • SELECT transcript_id, education_id, transcript_status_meaning, core_curriculum_value FROM igs_ad_transcript_v WHERE education_id = :p_education_id;

To compare entering and converted GPAs by grading scale:

  • SELECT entered_grading_scale, conv_grading_scale, entered_gpa, conv_gpa FROM igs_ad_transcript_v WHERE conv_gpa IS NOT NULL ORDER BY conv_gpa DESC;

To rank transcripts by class standing and source:

  • SELECT transcript_source_code, rank_in_class, class_size, percentile_rank FROM igs_ad_transcript_v WHERE transcript_type_meaning = 'Official';

Because the view contains no aggregation or filter predicates beyond the lookup joins, users should apply their own date, type, and status predicates to keep result sets selective on high-volume admissions tables.