Results for “grading_period”

18 results




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

Overview

The IGS_AS_GPC_PROGRAMS_V view is a reporting and integration object within the Oracle E-Business Suite Student System (IGS) product family. It presents grading period information associated with programs and courses, exposing a denormalized, human-readable representation of grading period assignments. In Oracle EBS Release 12.1.1 and 12.2.2, this view resides in the APPS schema and carries a VALID status, indicating that it is a supported, queryable object suitable for use in reports, concurrent programs, and interface extracts.

Because the underlying IGS_AS_GPC_PROGRAMS table stores grading period assignments only as coded values, the view's primary role is to resolve those codes into descriptive meanings and to join them to course version titles. This makes the view particularly useful when building operational reports, grading extracts, or dashboards where end users require legible descriptions rather than internal lookup codes. The name itself decomposes into "GPC" (grading period configuration) and "PROGRAMS," reflecting its function of mapping grading periods to programmatically defined courses.

Underlying Base Objects

The view is defined over three referenced objects joined in a single SELECT statement:

  • IGS_AS_GPC_PROGRAMS GPR — the primary base table holding grading period program records. Its GPC_PROGRAM_ID serves as the unique identifier.
  • IGS_LOOKUPS_VIEW LKUP — the lookup view used to translate the GRADING_PERIOD_CD code into a meaningful description, filtered by the lookup type AS_GRADING_PERIOD.
  • IGS_PS_VER PRGV — the course version table, joined on course code and version number to supply the course title.

The join predicates are:

No additional base objects are documented for this view in the 12.2.2 metadata. The view does not appear to perform aggregation; it is a straightforward equi-join projection identifying each row by GPR.ROWID.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_AS_GPC_PROGRAMS record, providing a stable row identifier.
  • GPC_PROGRAM_ID — the surrogate primary key for the grading period program record.
  • GRADING_PERIOD_CD — the coded grading period value, joining to AS_GRADING_PERIOD lookups.
  • GRADING_PERIOD — the decoded meaning of the grading period code, sourced from IGS_LOOKUPS_VIEW.MEANING.
  • COURSE_CD and COURSE_VERSION_NUMBER — the course and version to which the grading period applies.
  • COURSE_TITLE — the descriptive title of the course version, taken from IGS_PS_VER.TITLE.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN support audit and incremental-extract logic.

Common Use Cases and Queries

Typical scenarios include grading period setup validation, course-to-grading-period reporting, and extract generation for downstream academic systems. A representative query retrieves all grading periods for a specific course:

  • SELECT gpc_program_id, grading_period, course_cd, course_version_number, course_title FROM igs_as_gpc_programs_v WHERE course_cd = :course_code ORDER BY grading_period;

For audit or incremental extraction, the timestamp columns may be filtered:

  • SELECT * FROM igs_as_gpc_programs_v WHERE last_update_date >= :last_extract_date;

Because the view already resolves lookup meanings, it is commonly embedded in Oracle Reports, BI Publisher data templates, and OAF pages servicing academic configuration, eliminating the need for report-level lookup joins.