Search Results igs_gr_grd_perd_v




Overview
Explore in AI Chat

Overview

IGS_GR_GRD_PERD_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined within the IGS (Student System) product family. It is used to maintain and present graduation period information, consolidating the calendar type and calendar instance sequence that together identify a specific graduation round into a single, RPAD-padded display value. The view is classified as VALID and is available in both the 12.1.1 and 12.2.2 releases. Because it is a view and not a table, it exposes no DML surface; all maintenance of the underlying graduation period data is performed against the base tables, while the view serves purely as a reporting and integration read layer. Consumers use it to resolve graduation periods to human-readable alternate codes and formatted start and end dates without having to re-implement the multi-table join logic themselves.

Underlying Base Objects

The view is defined over five IGS base tables joined on common calendar and status keys:

The join path therefore runs from the graduation round through the calendar instance to its type and status, restricting output to active graduation calendar instances only.

Key Columns

  • GRD_PERD — the concatenation of GRD_CAL_TYPE (padded to 10 characters) and GRD_CI_SEQUENCE_NUMBER (padded to 10 characters). This is the composite graduation period identifier used to key downstream lookups.
  • ALT_CODE — the alternate code of the calendar instance (NVL of ALTERNATE_CODE and CAL_TYPE), padded to 10 characters. This is the user-facing graduation period label.
  • START_DT — the calendar instance start date, formatted as DD/MM/YYYY.
  • END_DT — the calendar instance end date, formatted as DD/MM/YYYY and padded to 20 characters.

Common Use Cases and Queries

The view is typically used to drive graduation period list-of-values, reporting extracts and integration payloads where a readable period label and date window are required. A typical query returns all active graduation periods with their display labels and date ranges:

  • SELECT grd_perd, alt_code, start_dt, end_dt FROM igs_gr_grd_perd_v;
  • SELECT alt_code, start_dt, end_dt FROM igs_gr_grd_perd_v WHERE grd_perd = :p_grd_perd;
  • SELECT grd_perd, alt_code FROM igs_gr_grd_perd_v WHERE TRUNC(SYSDATE) BETWEEN TO_DATE(start_dt,'DD/MM/YYYY') AND TO_DATE(end_dt,'DD/MM/YYYY');

Because the view returns only ACTIVE calendar instances, implementers should note that graduation rounds whose calendar instance status is not active will not appear, and any query relying on the padded GRD_PERD value must preserve the exact 10+10 padding when joining back to base tables such as IGS_GR_CRMN_ROUND.