Search Results igs_gr_graduand




Overview
Explore in AI Chat

Overview

IGS_GR_GRADUAND is a valid, predefined view owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product. In the context of EBS 12.1.1 and 12.2.2, it presents a reporting-oriented projection of graduand records — the graduating students who are being processed for conferral of an award. The view abstracts the multi-organization structure of the underlying graduand entity by exposing a single, fully qualified result set that is filtered against the operating unit context of the runtime session. This makes it suitable for concurrent programs, OBIEE extracts, XML Publisher reports, and integration interfaces that need to read graduand data without directly touching the base table. The view is read-only in practice; it carries no documented DML capability. Because it resolves the operating unit through the ORG_ID column and the CLIENT_INFO environment setting, it enforces Multi-Org security semantics at query time, which is a key design characteristic of the IGS schema.

Underlying Base Objects

The ETRM metadata identifies a single documented base object: the table IGS_GR_GRADUAND_ALL. The view text selects from IGS_GR_GRADUAND_ALL with the alias TAB and applies a predicate that filters rows by operating unit. This predicate uses the standard Multi-Org access pattern, comparing TAB.ORG_ID against an expression derived from USERENV('CLIENT_INFO'); the first character is tested for a space and, when not blank, the remaining characters are converted to a number and matched against ORG_ID. As a result, IGS_GR_GRADUAND returns only those graduand rows that belong to the operating unit currently set in the session. No additional joins are performed in the FROM clause; the only join-like construct is a scalar subquery against IGS_EN_SPA_AWD_AIM used to derive the conferral date. The "_ALL" suffix on the base table is consistent with the Multi-Org partitioning convention used throughout Oracle EBS, and the view is the organization-secured public synonym-style access point over it.

Key Columns

The view exposes the full column set of the base table, including the ROWID (aliased ROW_ID) as a unique row identifier. Principal business columns include PERSON_ID (the graduating person), ORG_ID (operating unit), GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER (identifying the graduation calendar instance), COURSE_CD, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, and AWARD_CD (the award being conferred), HONOURS_LEVEL, and GRADUAND_STATUS / GRADUAND_APPR_STATUS (workflow and approval states). GRADUATION_NAME and PROXY_AWARD_IND / PROXY_AWARD_PERSON_ID support ceremony and proxy award handling, while CONVOCATION_MEMBERSHIP_IND and PREVIOUS_QUALIFICATIONS hold attendance and prior attainment data. The derived CONFERRAL_DT column is notable: it is computed by a correlated scalar subquery on IGS_EN_SPA_AWD_AIM matching PERSON_ID, COURSE_CD, and AWARD_CD, so it reflects the actual conferral event rather than a stored graduand attribute. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), concurrent program request columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), and the twenty descriptive flexfield columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20) are also present.

Common Use Cases and Queries

Typical usage covers graduation ceremony reporting, award conferral reconciliation, and downstream student record integration. Because the view is organization-filtered, callers must ensure the correct operating unit is set before querying; otherwise rows may be silently excluded. A representative query is:

  • SELECT person_id, course_cd, award_cd, honours_level, graduand_status, conferral_dt FROM apps.igs_gr_graduand WHERE grd_cal_type = :p_cal_type AND grd_ci_sequence_number = :p_seq;
  • SELECT graduand_status, COUNT(*) FROM apps.igs_gr_graduand GROUP BY graduand_status; — to profile graduand workflow states.
  • SELECT g.graduation_name, g.conferral_dt, g.honours_level FROM apps.igs_gr_graduand g WHERE g.proxy_award_ind = 'Y'; — to identify proxy awards.
  • SELECT org_id, award_cd, COUNT(*) FROM apps.igs_gr_graduand GROUP BY org_id, award_cd; — for awards-by-operating-unit summaries.

These patterns are appropriate for listing reports, award audits, and staging extracts into institutional data warehouses. Since the view is a read layer over IGS_GR_GRADUAND_ALL, any insert, update, or delete must be directed at the base table through supported Student System APIs rather than against this view.