Results for “igs_gr_graduand_all”

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

Overview

IGS_GR_GRADUAND_ALL is a core table within the Oracle E-Business Suite IGS – Student System product, which is the component that manages student records, admissions, curricular structures, and graduation processing. In EBS 12.1.1 and 12.2.2 this table resides in the IGS schema and is documented as VALID. As its description states, the entity "describes graduand details" — that is, one row represents an individual who is a candidate for, or has been conferred with, an academic award, together with the administrative attributes that surround that graduation event.

The table is a key operational store for the graduation ceremony and award conferral functions. It links a person (student) to a conferral calendar and ceremony round, to an award, course, and honours classification, and to status flags indicating where that graduand stands in the graduation workflow. Because the same person can be recorded against different conferral events, the table is not a pure person master; rather it captures the graduation instance of a person and is therefore best treated, from a Data Vault modelling perspective, as satellite-leaning — it holds descriptive, time-varying attributes about a person's graduation state and depends on parent entities (person, ceremony round, honours level) for its business context.

Key Information Stored

The primary key is the surrogate/business composite IGS_GR_GRADUAND_PK, defined across PERSON_ID and CREATE_DT. A unique index IGS_GR_GRADUAND_ALL_U1 mirrors this same column pair, making PERSON_ID + CREATE_DT the effective business key. Notable columns include:

• PERSON_ID — the graduating party; foreign-referenced to HZ_PARTIES and to student programme attempt records in IGS_EN_STDNT_PS_ATT_ALL.
• CREATE_DT — the creation timestamp forming the second half of the composite key.
• GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER — the conferral/graduation calendar and calendar instance identifying the ceremony round, referencing IGS_GR_CRMN_ROUND_ALL.
• AWARD_CD, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER — the award being conferred and its associated course and version.
• COURSE_CD — the course context for the graduand.
• HONOURS_LEVEL — references IGS_GR_HONOURS_LEVEL_ALL to capture degree classification.
• CONFERRAL_DT — the date the award is formally conferred.
• GRADUAND_STATUS and GRADUAND_APPR_STATUS — workflow state of the graduand record and its approval.
• S_GRADUAND_TYPE and GRADUATION_NAME — the type of graduand and the name printed/used at the ceremony.
• CONVOCATION_MEMBERSHIP_IND — flag identifying attendance/membership at convocation.

The table also carries standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), Multi-Org ORG_ID, a REQUEST_ID for concurrent processing, and twenty descriptive flexfield attribute columns (ATTRIBUTE_CATEGORY plus ATTRIBUTE1–ATTRIBUTE20).

Common Use Cases and Queries

The principal use cases are graduation eligibility reporting, convocation attendance lists, award conferral audits, and reconciliation of graduands against student records. A typical reporting query joins the graduand record to the person party to return graduation names:

• Ceremony roster: select graduands by GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, and GRADUAND_APPR_STATUS to build an approved convocation list.
• Conferral audit: filter on CONFERRAL_DT ranges to reconcile awards against IGS_GR_AWD_CRMN_HIST.
• Honours analysis: group by HONOURS_LEVEL to produce classification distributions per course and version.
• Data quality check: identify graduands whose PERSON_ID has no corresponding row in IGS_EN_STDNT_PS_ATT_ALL.

A representative pattern is SELECT g.PERSON_ID, g.GRADUATION_NAME, g.AWARD_CD, g.CONFERRAL_DT FROM IGS.IGS_GR_GRADUAND_ALL g WHERE g.GRD_CAL_TYPE = :cal AND g.GRADUAND_APPR_STATUS = 'APPROVED', extended with a join to HZ_PARTIES on PERSON_ID where the party-level party name is required.

Related Objects

The most significant relationships established by the documented foreign keys and reverse references are:

• HZ_PARTIES — joined on PERSON_ID, the TCA party master providing person identity.
• IGS_EN_STDNT_PS_ATT_ALL — joined on PERSON_ID (and COURSE_CD), supplying the student programme attempt context.
• IGS_GR_CRMN_ROUND_ALL — joined on GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER, the ceremony round definition.
• IGS_GR_HONOURS_LEVEL_ALL — joined on HONOURS_LEVEL, the honours classification lookup.
• IGS_GR_AWD_CRMN_HIST — a child table whose PERSON_ID and CREATE_DT reference this graduand, recording award conferral history.

These relationships make the table a central junction for graduation reporting, linking the person, ceremony, and academic award domains within the Student System.