Results for “alternate_code”

18 results




Overview
Explore in AI Chat

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

Overview

The IGF_AP_PR_PRG_TYPE_V view is a reporting object within the IGF – Financial Aid product family in Oracle E-Business Suite, a module now classified as obsolete in the ETRM documentation for releases 12.1.1 and 12.2.2. The view exposes basic information about year-specific Program Types that are used to define Grade Levels for a particular program type's class standing. In practice, it acts as a denormalized read layer that joins program type definitions to their scheduled class standing records, calendar instances, and batch award mappings, allowing financial aid administrators and integrators to retrieve the relationship between a student's program type and the academic calendar against which awards and grade levels are evaluated.

Because the underlying module is obsolete, the view is retained largely for backward compatibility with existing extensions, custom reports, and integration interfaces rather than for active functional configuration. It remains relevant to anyone supporting legacy Financial Aid implementations or migrating data out of IGF.

Underlying Base Objects

The view's SQL text confirms it is defined over five base tables. Although the ETRM metadata lists no referenced base objects, the view text itself is authoritative:

Joins are driven on COURSE_TYPE between IGS_PS_TYPE and IGS_PR_CS_SCHDL, on IGS_PR_CS_SCHDL_ID between the schedule and IGF_AP_PR_PRG_TYPE, and on the CAL_TYPE/SEQUENCE_NUMBER pair between IGF_AP_PR_PRG_TYPE, IGF_AP_BATCH_AW_MAP_ALL, and IGS_CA_INST_ALL.

Key Columns

  • ROW_ID – row identifier inherited from the base table ROWID, used for direct row addressing.
  • PPT_ID – primary key of the program type record.
  • IGS_PR_CS_SCHDL_ID – foreign key to the program class standing schedule.
  • PROGRAM_TYPE (COURSE_TYPE) – the code identifying the program type.
  • DESCRIPTION – descriptive name of the program type.
  • CAL_TYPE and SEQUENCE_NUMBER – identify the calendar instance and its sequence used for award mapping.
  • ALTERNATE_CODE, START_DT, END_DT – calendar instance identifiers and validity date range.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard EBS WHO audit columns.

Common Use Cases and Queries

Typical usage includes extracting all program types valid for a calendar instance, validating grade-level mappings during award processing, and auditing obsolete IGF configuration for migration. A representative query returning active program types for a given calendar is:

SELECT ppt_id, program_type, description, cal_type, sequence_number, start_dt, end_dt FROM igf_ap_pr_prg_type_v WHERE cal_type = :cal_type AND trunc(sysdate) BETWEEN start_dt AND end_dt ORDER BY sequence_number;

A second scenario joins the view to grade-level definitions to reconcile class standing against program types. Because the ETRM implementation note states the view is not implemented in the database, DBAs should confirm its presence in ALL_VIEWS before relying on it in custom code, as obsolete objects may be absent in some 12.2.2 environments.